----- 2021年3月8号
|
-- 工作站表
|
ALTER TABLE "basic_workstation" RENAME status TO artificial_type ;
|
-- 人员表
|
ALTER TABLE "production_product_output_staff" RENAME status TO artificial_type ;
|
-- 2021年3月10号
|
-- 人员表
|
ALTER TABLE "basic_staff" ADD COLUMN "personnel_factor" numeric(12,3) DEFAULT 0;
|
-- 2021年3月12号
|
-- 上班记录表
|
ALTER TABLE "production_duty_record" ADD COLUMN "now_duty_date" varchar(250) COLLATE "pg_catalog"."default";
|
-- 2021年3月23号
|
-- 人员表
|
ALTER TABLE "production_product_output_staff" ADD COLUMN "staff_id" int8;
|
-- 2021年3月25号
|
-- 工序模板表
|
CREATE TABLE "public"."technology_operation_template" (
|
"id" int8 NOT NULL,
|
"operation_template_name" varchar(255) COLLATE "pg_catalog"."default",
|
"operation_template_no" varchar(255) COLLATE "pg_catalog"."default",
|
"operation_template_type" varchar(255) COLLATE "pg_catalog"."default",
|
"remark" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "technology_operation_template_pkey" PRIMARY KEY ("id")
|
)
|
;
|
-- 工序模板与工序参数关联表
|
CREATE TABLE "public"."technology_operation_join_template" (
|
"technology_operation_param_id" int8 NOT NULL,
|
"technology_operation_template_id" int8 NOT NULL
|
);
|
|
|
|
|
-- 2021年3月26号
|
-- 工序与工序模板关联表
|
ALTER TABLE "technology_join_operation_param" RENAME TO "technology_join_operation_template";
|
ALTER TABLE "technology_join_operation_template" RENAME technology_param_id TO technology_template_id ;
|
-- 2021年3月29号
|
-- 工序模板与工序参数关联表
|
ALTER TABLE "technology_join_operation_template" ADD COLUMN "sort" int8;
|
|
-- 2021年4月2号
|
-- 工序模板
|
ALTER TABLE "technology_operation_template" RENAME TO "basic_template";
|
-- 工序参数
|
ALTER TABLE "technology_param" RENAME TO "basic_param" ;
|
-- 工序参数关联工序模板
|
ALTER TABLE "technology_operation_join_template" RENAME TO "basic_param_join_template";
|
-- 2021年4月6号
|
-- 工艺路线复制模板表
|
ALTER TABLE "technology_operation_template_copy" RENAME TO "technology_routing_operation_template";
|
-- 模板类型
|
CREATE SEQUENCE "public"."basic_template_type_relation_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."basic_template_type_relation" (
|
"id" int8 NOT NULL DEFAULT nextval('basic_template_type_relation_id_seq'::regclass),
|
"template_type_name" varchar(255) COLLATE "pg_catalog"."default",
|
"data_type" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "basic_template_type_relation_pkey" PRIMARY KEY ("id"),
|
CONSTRAINT "template_type_name_uniq" UNIQUE ("template_type_name")
|
)
|
;
|
|
ALTER SEQUENCE "public"."basic_template_type_relation_id_seq"
|
OWNED BY "public"."basic_template_type_relation"."id";
|
|
ALTER SEQUENCE "public"."basic_template_type_relation_id_seq" OWNER TO "postgres";
|
|
-- 2021年4月6号
|
-- 制造订单复制参数表
|
CREATE SEQUENCE "public"."plan_routing_operation_param_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."plan_routing_operation_param" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_routing_operation_param_id_seq'::regclass),
|
"routing_id" int8,
|
"code" varchar(255) COLLATE "pg_catalog"."default",
|
"parameter_item" varchar(255) COLLATE "pg_catalog"."default",
|
"type" varchar(255) COLLATE "pg_catalog"."default",
|
"unit" varchar(255) COLLATE "pg_catalog"."default",
|
"param_value" varchar(255) COLLATE "pg_catalog"."default",
|
"operation_id" int8,
|
"routing_operation_id" int8,
|
"operation_template_id" int8,
|
CONSTRAINT "plan_routing_operation_param_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER SEQUENCE "public"."plan_routing_operation_param_id_seq"
|
OWNED BY "public"."plan_routing_operation_param"."id";
|
|
ALTER SEQUENCE "public"."plan_routing_operation_param_id_seq" OWNER TO "postgres";
|
|
|
-- 制造订单复制模板表
|
CREATE SEQUENCE "public"."plan_routing_operation_template_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."plan_routing_operation_template" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_routing_operation_template_id_seq'::regclass),
|
"operation_template_name" varchar(255) COLLATE "pg_catalog"."default",
|
"operation_template_no" varchar(255) COLLATE "pg_catalog"."default",
|
"operation_template_type" varchar(255) COLLATE "pg_catalog"."default",
|
"remark" varchar(2000) COLLATE "pg_catalog"."default",
|
"routing_operation_id" int8,
|
"data_type" varchar(255) COLLATE "pg_catalog"."default",
|
"system_no" varchar(255) COLLATE "pg_catalog"."default",
|
"mo_id" int8,
|
CONSTRAINT "plan_routing_operation_template_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER SEQUENCE "public"."plan_routing_operation_template_id_seq"
|
OWNED BY "public"."plan_routing_operation_template"."id";
|
|
ALTER SEQUENCE "public"."plan_routing_operation_template_id_seq" OWNER TO "postgres";
|
|
-- 2021年4月6号
|
-- 工艺路线复制模板表
|
ALTER TABLE "public"."technology_routing_operation_template" ADD COLUMN "system_no" varchar(250) COLLATE "pg_catalog"."default";
|
-- 2021年4月7号
|
-- 工序模板
|
ALTER TABLE "basic_template" RENAME operation_template_name TO template_name ;
|
ALTER TABLE "basic_template" RENAME operation_template_no TO template_no ;
|
ALTER TABLE "basic_template" RENAME operation_template_type TO template_type ;
|
-- 2021年4月8号
|
-- 工作台参数
|
CREATE SEQUENCE "public"."production_operation_task_param_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."production_operation_task_param" (
|
"id" int8 NOT NULL DEFAULT nextval('production_operation_task_param_id_seq'::regclass),
|
"code" varchar(255) COLLATE "pg_catalog"."default",
|
"parameter_item" varchar(255) COLLATE "pg_catalog"."default",
|
"type" varchar(255) COLLATE "pg_catalog"."default",
|
"unit" varchar(255) COLLATE "pg_catalog"."default",
|
"param_value" varchar(255) COLLATE "pg_catalog"."default",
|
"operation_template_id" int8,
|
"operation_task_id" int8,
|
CONSTRAINT "production_operation_task_param_pkey" PRIMARY KEY ("id")
|
)
|
;
|
ALTER SEQUENCE "public"."production_operation_task_param_id_seq"
|
OWNED BY "public"."production_operation_task_param"."id";
|
|
ALTER SEQUENCE "public"."production_operation_task_param_id_seq" OWNER TO "postgres";
|
-- 2021年4月9号
|
-- 工作台产出表
|
ALTER TABLE "public"."production_product_output" RENAME out_system_no TO system_no ;
|
-- 2021年4月13号
|
-- 工作台投料表
|
ALTER TABLE "public"."production_product_input" ADD COLUMN "system_no" varchar(2000) COLLATE "pg_catalog"."default";
|
-- 2021年4月13号
|
-- 实时库存
|
ALTER TABLE "public"."warehouse_stock" ADD COLUMN "system_no" varchar(2000) COLLATE "pg_catalog"."default";
|
|
|
-- 2021年4月16号
|
--客户订单参数
|
CREATE SEQUENCE "public"."plan_customer_order_param_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."plan_customer_order_param" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_customer_order_param_id_seq'::regclass),
|
"order_id" int8,
|
"field" varchar(255) COLLATE "pg_catalog"."default",
|
"value" varchar(255) COLLATE "pg_catalog"."default",
|
"order_param_id" int8,
|
CONSTRAINT "plan_customer_order_param_pkey" PRIMARY KEY ("id")
|
)
|
;
|
ALTER SEQUENCE "public"."plan_customer_order_param_id_seq"
|
OWNED BY "public"."plan_customer_order_param"."id";
|
|
ALTER TABLE "public"."plan_customer_order_param"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."plan_customer_order_param"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."plan_customer_order_param"."order_id" IS '订单id';
|
|
COMMENT ON COLUMN "public"."plan_customer_order_param"."field" IS '参数对应字段';
|
|
COMMENT ON COLUMN "public"."plan_customer_order_param"."value" IS '参数值';
|
|
COMMENT ON COLUMN "public"."plan_customer_order_param"."order_param_id" IS '订单参数id';
|
|
|
--订单参数
|
CREATE SEQUENCE "public"."plan_order_param_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."plan_order_param" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_order_param_id_seq'::regclass),
|
"code" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
|
"item" varchar(255) COLLATE "pg_catalog"."default",
|
"type" varchar(255) COLLATE "pg_catalog"."default",
|
"source" varchar(255) COLLATE "pg_catalog"."default",
|
"field" varchar(255) COLLATE "pg_catalog"."default",
|
"distinguish" varchar(255) COLLATE "pg_catalog"."default",
|
"rename_field" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "plan_order_param_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER SEQUENCE "public"."plan_order_param_id_seq"
|
OWNED BY "public"."plan_order_param"."id";
|
|
ALTER TABLE "public"."plan_order_param"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."plan_order_param"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."plan_order_param"."code" IS '参数编号';
|
|
COMMENT ON COLUMN "public"."plan_order_param"."item" IS '参数项';
|
|
COMMENT ON COLUMN "public"."plan_order_param"."type" IS '参数类型';
|
|
COMMENT ON COLUMN "public"."plan_order_param"."source" IS '参数来源';
|
|
COMMENT ON COLUMN "public"."plan_order_param"."field" IS '参数对应字段';
|
|
COMMENT ON COLUMN "public"."plan_order_param"."distinguish" IS '参数区分主表还是从表';
|
|
COMMENT ON COLUMN "public"."plan_order_param"."rename_field" IS '参数对应字段(重命名)';
|
|
COMMENT ON TABLE "public"."plan_order_param" IS '订单参数';
|
|
-- 2021年4月19号
|
--工步
|
CREATE SEQUENCE "public"."technology_step_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."technology_step" (
|
"id" int8 NOT NULL DEFAULT nextval('technology_step_id_seq'::regclass),
|
"step_no" varchar(255) COLLATE "pg_catalog"."default",
|
"name" varchar(255) COLLATE "pg_catalog"."default",
|
"remark" varchar(255) COLLATE "pg_catalog"."default",
|
"update_time" timestamp(6),
|
CONSTRAINT "technology_step_pkey" PRIMARY KEY ("id")
|
)
|
;
|
ALTER SEQUENCE "public"."technology_step_id_seq"
|
OWNED BY "public"."technology_step"."id";
|
|
ALTER TABLE "public"."technology_step"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."technology_step"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."technology_step"."step_no" IS '工步编号';
|
|
COMMENT ON COLUMN "public"."technology_step"."name" IS '工步名称';
|
|
COMMENT ON COLUMN "public"."technology_step"."remark" IS '备注';
|
|
COMMENT ON COLUMN "public"."technology_step"."update_time" IS '更新时间';
|
|
COMMENT ON TABLE "public"."technology_step" IS '工步';
|
|
--工序关联工步
|
CREATE TABLE "public"."technology_join_operation_step" (
|
"technology_operation_id" int8 NOT NULL,
|
"technology_step_id" int8 NOT NULL,
|
"sort" int8 NOT NULL
|
)
|
;
|
|
ALTER TABLE "public"."technology_join_operation_step"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."technology_join_operation_step"."technology_operation_id" IS '工序id';
|
|
COMMENT ON COLUMN "public"."technology_join_operation_step"."technology_step_id" IS '工步id';
|
|
COMMENT ON COLUMN "public"."technology_join_operation_step"."sort" IS '排序';
|
|
COMMENT ON TABLE "public"."technology_join_operation_step" IS '工序关联工步';
|
|
--工作台关联工步
|
CREATE SEQUENCE "public"."production_product_step_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."production_product_step" (
|
"id" int8 NOT NULL DEFAULT nextval('production_product_step_id_seq'::regclass),
|
"operation_task_id" int8,
|
"step_id" int8,
|
"number" numeric(12,3),
|
"create_time" timestamp(6),
|
CONSTRAINT "production_product_step_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."production_product_step"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."production_product_step_id_seq"
|
OWNED BY "public"."production_product_step"."id";
|
|
COMMENT ON COLUMN "public"."production_product_step"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."production_product_step"."operation_task_id" IS '工单id';
|
|
COMMENT ON COLUMN "public"."production_product_step"."step_id" IS '工步id';
|
|
COMMENT ON COLUMN "public"."production_product_step"."number" IS '数量';
|
|
COMMENT ON COLUMN "public"."production_product_step"."create_time" IS '创建时间';
|
|
COMMENT ON TABLE "public"."production_product_step" IS '工单工步表';
|
|
--工单工步人员表
|
CREATE SEQUENCE "public"."production_product_step_staff_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."production_product_step_staff" (
|
"id" int8 NOT NULL DEFAULT nextval('production_product_step_staff_id_seq'::regclass),
|
"product_step_id" int8,
|
"staff_id" int8,
|
"number" numeric(12,3),
|
CONSTRAINT "production_product_step_staff_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."production_product_step_staff"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."production_product_step_staff_id_seq"
|
OWNED BY "public"."production_product_step_staff"."id";
|
|
COMMENT ON COLUMN "public"."production_product_step_staff"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."production_product_step_staff"."product_step_id" IS '工单工步id';
|
|
COMMENT ON COLUMN "public"."production_product_step_staff"."staff_id" IS '人员id';
|
|
COMMENT ON COLUMN "public"."production_product_step_staff"."number" IS '数量';
|
|
COMMENT ON TABLE "public"."production_product_step_staff" IS '工单工步人员表';
|
|
|
|
|
--工作台生产记录的记录表
|
CREATE SEQUENCE "public"."production_operation_task_record_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."production_operation_task_record" (
|
"id" int8 NOT NULL DEFAULT nextval('production_operation_task_record_id_seq'::regclass),
|
"name" varchar(255) COLLATE "pg_catalog"."default",
|
"operation_task_id" int8,
|
"operation_template_id" int8,
|
"duty_record_id" int8,
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "production_operation_task_record_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."production_operation_task_record"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."production_operation_task_record_id_seq"
|
OWNED BY "public"."production_operation_task_record"."id";
|
COMMENT ON COLUMN "public"."production_operation_task_record"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."name" IS '名称';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."operation_task_id" IS '工单id';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."operation_template_id" IS '工序模板id';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."duty_record_id" IS '班次id';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."create_time" IS '创建时间';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."update_time" IS '更新时间';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."create_user" IS '创建人';
|
|
COMMENT ON COLUMN "public"."production_operation_task_record"."update_user" IS '更新人';
|
|
COMMENT ON TABLE "public"."production_operation_task_record" IS '生产记录模板记录';
|
|
--工作台生产记录的参数表
|
ALTER TABLE "production_operation_task_param" ADD COLUMN "operation_task_record_id" int8;
|
|
|
|
--2021-05-05 by zhangxy
|
--保存完整的bom树
|
CREATE TABLE "public"."technology_bom" (
|
"id" serial8,
|
"number" varchar(255) COLLATE "pg_catalog"."default",
|
"state" varchar(255) COLLATE "pg_catalog"."default" NOT NULL DEFAULT '01draft'::character varying,
|
"part_id" int8,
|
"remark" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "technology_bom_pkey" PRIMARY KEY ("id"),
|
CONSTRAINT "uniq_bom_number" UNIQUE ("number")
|
)
|
;
|
|
ALTER TABLE "public"."technology_bom"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."technology_bom"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."technology_bom"."number" IS '编号';
|
|
COMMENT ON COLUMN "public"."technology_bom"."state" IS '状态';
|
|
COMMENT ON COLUMN "public"."technology_bom"."part_id" IS '零件id';
|
|
COMMENT ON COLUMN "public"."technology_bom"."remark" IS '备注';
|
|
COMMENT ON TABLE "public"."technology_bom" IS '完整bom';
|
|
|
|
|
CREATE TABLE "public"."technology_bom_component" (
|
"id" serial8,
|
"qpa" numeric(12,2),
|
"parent" int8,
|
"part_id" int8,
|
"unit" varchar COLLATE "pg_catalog"."default",
|
"bom_id" int8,
|
CONSTRAINT "_bom_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."technology_bom_component"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."technology_bom_component"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."technology_bom_component"."qpa" IS '单位产出';
|
|
COMMENT ON COLUMN "public"."technology_bom_component"."parent" IS '状态';
|
|
COMMENT ON COLUMN "public"."technology_bom_component"."part_id" IS '零件id';
|
|
COMMENT ON COLUMN "public"."technology_bom_component"."unit" IS '单位';
|
|
COMMENT ON COLUMN "public"."technology_bom_component"."bom_id" IS 'bom主表id';
|
|
COMMENT ON TABLE "public"."technology_bom_component" IS '完整工艺树';
|
|
--检测申请材料表
|
ALTER TABLE "quality_apply_part" ADD COLUMN "part_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "part_desc" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "order_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "line_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "release_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "receipt_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "supplier_id" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "supplier_name" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "waiv_dev_rej_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "location_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "lot_batch_no" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "quality_apply_part" ADD COLUMN "qty_arrived" varchar(255) COLLATE "pg_catalog"."default";
|
|
CREATE TABLE "public"."production_operation_task_attachment" (
|
"id" serial8,
|
"operation_task_id" int8,
|
"file_name" varchar(255) COLLATE "pg_catalog"."default",
|
"url" varchar(255) COLLATE "pg_catalog"."default",
|
"original" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "production_operation_task_attachment_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."production_operation_task_attachment"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."production_operation_task_attachment"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."production_operation_task_attachment"."file_name" IS 'oss文件名';
|
|
COMMENT ON COLUMN "public"."production_operation_task_attachment"."url" IS '路径';
|
|
COMMENT ON COLUMN "public"."production_operation_task_attachment"."original" IS '原文件名';
|
|
COMMENT ON TABLE "public"."production_operation_task_attachment" IS '工单的附件表';
|
|
|
|
--制造订单产品结构
|
ALTER TABLE "public"."plan_mo_structure_component" ADD COLUMN "parent" int8;
|
COMMENT ON COLUMN "public"."plan_mo_structure_component"."parent" IS '父id';
|
|
|
ALTER TABLE "public"."plan_manufacturing_order" ADD COLUMN "bom_id" int8;
|
COMMENT ON COLUMN "public"."plan_manufacturing_order"."bom_id" IS 'bomid';
|
|
|
--制造订单，允许暂存
|
ALTER TABLE "public"."plan_manufacturing_order"
|
ALTER COLUMN "technology_routing_id" DROP NOT NULL,
|
ALTER COLUMN "_id" DROP NOT NULL;
|
|
-- 产品结构去掉多余字段
|
ALTER TABLE "public".""
|
DROP COLUMN "routing_id",
|
DROP COLUMN "state";
|
ALTER TABLE "public"."_component"
|
DROP COLUMN "routing_operation_id";
|
|
--添加库存调整的系统号
|
ALTER TABLE "warehouse_adjust_detail" ADD COLUMN "system_no" varchar(255);
|
COMMENT ON COLUMN "public"."warehouse_adjust_detail"."system_no" IS '系统编号';
|
|
--添加库存盘点的系统号
|
ALTER TABLE "warehouse_check_detail" ADD COLUMN "system_no" varchar(255);
|
COMMENT ON COLUMN "public"."warehouse_check_detail"."system_no" IS '系统编号';
|
|
--添加仓库备料的系统号
|
ALTER TABLE "warehouse_prepare_detail" ADD COLUMN "system_no" varchar(255);
|
COMMENT ON COLUMN "public"."warehouse_prepare_detail"."system_no" IS '系统编号';
|
|
--添加仓库报废的系统号
|
ALTER TABLE "warehouse_scrap_detail" ADD COLUMN "system_no" varchar(255);
|
COMMENT ON COLUMN "public"."warehouse_scrap_detail"."system_no" IS '系统编号';
|
|
--添加检测申请的要检验的采购数量
|
ALTER TABLE "quality_apply_part" ADD COLUMN "qty_to_inspect" varchar(255);
|
COMMENT ON COLUMN "public"."quality_apply_part"."qty_to_inspect" IS '要检验的采购数量';
|
--添加检测申请的检验后移库的字段
|
ALTER TABLE "quality_apply_part" ADD COLUMN "serial_no" varchar(255);
|
COMMENT ON COLUMN "public"."quality_apply_part"."serial_no" IS '序列号';
|
ALTER TABLE "quality_apply_part" ADD COLUMN "eng_chg_level" varchar(255);
|
ALTER TABLE "quality_apply_part" ADD COLUMN "activity_seq" varchar(255);
|
|
--零件族添加检测规则字段
|
ALTER TABLE "basic_part_family" ADD COLUMN "test_rule_id" int8;
|
COMMENT ON COLUMN "public"."basic_part_family"."test_rule_id" IS '检测规则id';
|
--BOM精度改为小数点后8位
|
ALTER TABLE "public"."technology_bom_component" ALTER COLUMN "qpa" TYPE numeric(16,8);
|
ALTER TABLE "public"."technology_structure_component" ALTER COLUMN "qpa" TYPE numeric(16,8);
|
ALTER TABLE "public"."production_operation_task_material"
|
ALTER COLUMN "qpa" TYPE numeric(16,8),
|
ALTER COLUMN "quantity_required" TYPE numeric(16,8),
|
ALTER COLUMN "quantity_issued" TYPE numeric(16,8);
|
|
--包装主表
|
CREATE TABLE "public"."warehouse_packaging" (
|
"id" serial8,
|
"no" varchar COLLATE "pg_catalog"."default",
|
"netweight" numeric(18,6),
|
"grossweight" numeric(18,6),
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default",
|
"number" numeric(18,6),
|
CONSTRAINT "warehouse_package_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."warehouse_packaging"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."no" IS '编号';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."netweight" IS '净重';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."grossweight" IS '毛重';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."create_time" IS '创建日期';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."update_time" IS '更新日期';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."create_user" IS '创建人';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."update_user" IS '更新人';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging"."number" IS '数量';
|
|
COMMENT ON TABLE "public"."warehouse_packaging" IS '包装主表';
|
|
--包装明细表
|
CREATE TABLE "public"."warehouse_packaging_item" (
|
"id" serial8,
|
"part_id" int8,
|
"out_batch_no" varchar COLLATE "pg_catalog"."default",
|
"system_no" varchar COLLATE "pg_catalog"."default",
|
"package_qty" numeric,
|
"create_time" timestamp(6),
|
"specs" varchar(255) COLLATE "pg_catalog"."default",
|
"packaging_id" int8,
|
CONSTRAINT "warehouse_package_item_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."warehouse_packaging_item"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."part_id" IS '零件id';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."out_batch_no" IS '批次号';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."system_no" IS '系统号';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."package_qty" IS '包装数量';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."create_time" IS '创建时间';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."specs" IS '规格';
|
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."packaging_id" IS '包装主表id';
|
|
COMMENT ON TABLE "public"."warehouse_packaging_item" IS '包装明细表';
|
|
|
|
-- 打印模板
|
CREATE TABLE "public"."report_template" (
|
"id" serial8,
|
"module" varchar(255) COLLATE "pg_catalog"."default",
|
"template_name" varchar(255) COLLATE "pg_catalog"."default",
|
"description" varchar(255) COLLATE "pg_catalog"."default",
|
"sort" int4 DEFAULT 0,
|
CONSTRAINT "report_template_pkey" PRIMARY KEY ("id"),
|
CONSTRAINT "uniq_temp_name" UNIQUE ("template_name")
|
)
|
;
|
|
ALTER TABLE "public"."report_template"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."report_template"."module" IS '模块';
|
|
COMMENT ON COLUMN "public"."report_template"."template_name" IS '模板名称';
|
|
COMMENT ON COLUMN "public"."report_template"."description" IS '描述';
|
|
COMMENT ON COLUMN "public"."report_template"."sort" IS '排序';
|
|
COMMENT ON TABLE "public"."report_template" IS 'jasper报表模板';
|
|
--添加零件的单位重量
|
ALTER TABLE "basic_part" ADD COLUMN "weight" numeric(12,3) DEFAULT 1;
|
COMMENT ON COLUMN "public"."basic_part"."weight" IS '重量';
|
|
--添加包装明细表的实时库存id
|
ALTER TABLE "warehouse_packaging_item" ADD COLUMN "stock_id" int8;
|
COMMENT ON COLUMN "public"."warehouse_packaging_item"."stock_id" IS '实时库存id';
|
|
--添加包装主表的差异数量和实际数量
|
ALTER TABLE "warehouse_packaging" ADD COLUMN "difference_weight" numeric(18,6);
|
COMMENT ON COLUMN "public"."warehouse_packaging"."difference_weight" IS '差异重量';
|
|
ALTER TABLE "warehouse_packaging" ADD COLUMN "real_weight" numeric(18,6);
|
COMMENT ON COLUMN "public"."warehouse_packaging"."real_weight" IS '实际重量';
|
|
|
|
--2021-6-10 模板与客户订单的关系表
|
CREATE TABLE "public"."plan_join_model_customer" (
|
"customer_order_id" int8 NOT NULL,
|
"model_id" int8 NOT NULL,
|
"model" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
|
CONSTRAINT "plan_join_model_customer_pkey" PRIMARY KEY ("customer_order_id", "model_id")
|
)
|
;
|
|
ALTER TABLE "public"."plan_join_model_customer"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."plan_join_model_customer"."customer_order_id" IS '客户订单id';
|
|
COMMENT ON COLUMN "public"."plan_join_model_customer"."model_id" IS '模块的id';
|
|
COMMENT ON COLUMN "public"."plan_join_model_customer"."model" IS '模块';
|
|
COMMENT ON TABLE "public"."plan_join_model_customer" IS '模块与客户订单的关联表';
|
|
--检测规则的检测参数新增参数项的检测类型
|
ALTER TABLE "quality_test_standard_param" ADD COLUMN "param_type" varchar(255);
|
COMMENT ON COLUMN "public"."quality_test_standard_param"."param_type" IS '参数项的检测类型';
|
|
--制造订单的检测参数复制表新增参数项的检测类型
|
ALTER TABLE "plan_mo_test_standard_param" ADD COLUMN "param_type" varchar(255);
|
COMMENT ON COLUMN "public"."plan_mo_test_standard_param"."param_type" IS '参数项的检测类型';
|
|
CREATE TABLE "public"."quality_exception" (
|
"id" serial8,
|
"code" varchar(255) COLLATE "pg_catalog"."default",
|
"workstation_id" int8,
|
"productout_id" int8,
|
"exception_type" varchar(255) COLLATE "pg_catalog"."default",
|
"exception_description" varchar(255) COLLATE "pg_catalog"."default",
|
"handle_way" varchar(255) COLLATE "pg_catalog"."default",
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"remark" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "quality_exception_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."quality_exception"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."quality_exception"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."quality_exception"."code" IS '编号';
|
|
COMMENT ON COLUMN "public"."quality_exception"."workstation_id" IS '工作站id';
|
|
COMMENT ON COLUMN "public"."quality_exception"."productout_id" IS '产出id';
|
|
COMMENT ON COLUMN "public"."quality_exception"."exception_type" IS '异常类型';
|
|
COMMENT ON COLUMN "public"."quality_exception"."exception_description" IS '异常描述';
|
|
COMMENT ON COLUMN "public"."quality_exception"."handle_way" IS '处理方案';
|
|
COMMENT ON COLUMN "public"."quality_exception"."create_user" IS '处理人';
|
|
COMMENT ON COLUMN "public"."quality_exception"."create_time" IS '创建时间';
|
|
COMMENT ON COLUMN "public"."quality_exception"."remark" IS '备注';
|
|
COMMENT ON TABLE "public"."quality_exception" IS '生产异常处理';
|
|
CREATE TABLE "public"."quality_exception_attachment" (
|
"id" serial8,
|
"exception_id" int8,
|
"file_name" varchar(255) COLLATE "pg_catalog"."default",
|
"url" varchar(255) COLLATE "pg_catalog"."default",
|
"original" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "quality_exception_attachment_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."quality_exception_attachment"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."quality_exception_attachment"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."quality_exception_attachment"."exception_id" IS '生产异常记录id';
|
|
COMMENT ON COLUMN "public"."quality_exception_attachment"."file_name" IS 'oss文件名';
|
|
COMMENT ON COLUMN "public"."quality_exception_attachment"."url" IS '路径';
|
|
COMMENT ON COLUMN "public"."quality_exception_attachment"."original" IS '原文件名';
|
|
COMMENT ON TABLE "public"."quality_exception_attachment" IS '生产异常记录附件';
|
|
|
|
--master新增客户订单主表
|
CREATE TABLE "public"."plan_customer" (
|
"id" serial8,
|
"contract_no" varchar COLLATE "pg_catalog"."default",
|
"customer_contract_no" varchar COLLATE "pg_catalog"."default",
|
"customer_name" varchar(255) COLLATE "pg_catalog"."default",
|
"entity_name" varchar(255) COLLATE "pg_catalog"."default",
|
"delivery_date" timestamp(6),
|
"sales_department" varchar(255) COLLATE "pg_catalog"."default",
|
"province" varchar(255) COLLATE "pg_catalog"."default",
|
"sales_man" varchar(255) COLLATE "pg_catalog"."default",
|
"saler_work_code" varchar(255) COLLATE "pg_catalog"."default",
|
"original_contract_status" varchar(255) COLLATE "pg_catalog"."default",
|
"is_cp" varchar(255) COLLATE "pg_catalog"."default",
|
"customer_no" varchar COLLATE "pg_catalog"."default",
|
"return_status" varchar(255) COLLATE "pg_catalog"."default",
|
"place_order_date" timestamp(6),
|
"verify_date" timestamp(6),
|
"factory_place_order_date" timestamp(6),
|
CONSTRAINT "plan_customer_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."plan_customer"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."plan_customer"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."plan_customer"."contract_no" IS '合同号';
|
|
COMMENT ON COLUMN "public"."plan_customer"."customer_contract_no" IS '客户合同号';
|
|
COMMENT ON COLUMN "public"."plan_customer"."customer_name" IS '客户名称';
|
|
COMMENT ON COLUMN "public"."plan_customer"."entity_name" IS '工程名称';
|
|
COMMENT ON COLUMN "public"."plan_customer"."delivery_date" IS '交货日期';
|
|
COMMENT ON COLUMN "public"."plan_customer"."sales_department" IS '事业部';
|
|
COMMENT ON COLUMN "public"."plan_customer"."province" IS '省份';
|
|
COMMENT ON COLUMN "public"."plan_customer"."sales_man" IS '业务员';
|
|
COMMENT ON COLUMN "public"."plan_customer"."saler_work_code" IS '业务员编号';
|
|
COMMENT ON COLUMN "public"."plan_customer"."original_contract_status" IS '正本状态';
|
|
COMMENT ON COLUMN "public"."plan_customer"."is_cp" IS '项目性质';
|
|
COMMENT ON COLUMN "public"."plan_customer"."customer_no" IS '客户编码';
|
|
COMMENT ON COLUMN "public"."plan_customer"."return_status" IS '合同正本状态';
|
|
COMMENT ON COLUMN "public"."plan_customer"."place_order_date" IS '下单日期';
|
|
COMMENT ON COLUMN "public"."plan_customer"."verify_date" IS '审核日期';
|
|
COMMENT ON COLUMN "public"."plan_customer"."factory_place_order_date" IS '工厂下单日期';
|
|
COMMENT ON TABLE "public"."plan_customer" IS '客户订单主表';
|
|
--客户订单
|
ALTER TABLE "plan_customer_order" ADD COLUMN "customer_id" int8;
|
COMMENT ON COLUMN "public"."plan_customer_order"."customer_id" IS '客户订单主表的id(plan_customer)';
|
|
--检测申请增加创建人、创建时间、更新人和更新时间
|
ALTER TABLE "quality_apply" ADD COLUMN "create_time" timestamp(6);
|
COMMENT ON COLUMN "public"."quality_apply"."create_time" IS '创建时间';
|
ALTER TABLE "quality_apply" ADD COLUMN "create_user" varchar(255);
|
COMMENT ON COLUMN "public"."quality_apply"."create_user" IS '创建人';
|
ALTER TABLE "quality_apply" ADD COLUMN "update_time" timestamp(6);
|
COMMENT ON COLUMN "public"."quality_apply"."update_time" IS '更新时间';
|
ALTER TABLE "quality_apply" ADD COLUMN "update_user" varchar(255);
|
COMMENT ON COLUMN "public"."quality_apply"."update_user" IS '更新人';
|
|
--0830 start cxf 质量检测自动判断公式
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "item_code" varchar(50);
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."item_code" IS '检测项目编号';
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "item_type" varchar(50);
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."item_type" IS '检测项目类型';
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "value_formula" varchar(255);
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."value_formula" IS '值公式（针对计算出来的值）';
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "judge_formula" varchar(255);
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."judge_formula" IS '判断公式（是否合格）';
|
|
ALTER TABLE "public"."quality_report_sample" RENAME mo_test_standard_id TO test_standard_id;
|
ALTER TABLE "quality_report_sample" ADD COLUMN "is_mo_test_standard" bool;
|
COMMENT ON COLUMN "public"."quality_report_sample"."is_mo_test_standard" IS '是否来自客户订单的检测标准';
|
|
ALTER TABLE "quality_test_standard_param" ADD COLUMN "value_formula" varchar(255);
|
COMMENT ON COLUMN "public"."quality_test_standard_param"."value_formula" IS '值公式（针对计算出来的值）';
|
ALTER TABLE "quality_test_standard_param" ADD COLUMN "judge_formula" varchar(255);
|
COMMENT ON COLUMN "public"."quality_test_standard_param"."judge_formula" IS '判断公式（是否合格）';
|
ALTER TABLE "quality_test_standard" ADD COLUMN "judge_formula" varchar(255);
|
COMMENT ON COLUMN "public"."quality_test_standard"."judge_formula" IS '判断公式（是否合格）';
|
|
ALTER TABLE "plan_mo_test_standard_param" ADD COLUMN "value_formula" varchar(255);
|
COMMENT ON COLUMN "public"."plan_mo_test_standard_param"."value_formula" IS '值公式（针对计算出来的值）';
|
ALTER TABLE "plan_mo_test_standard_param" ADD COLUMN "judge_formula" varchar(255);
|
COMMENT ON COLUMN "public"."plan_mo_test_standard_param"."judge_formula" IS '判断公式（是否合格）';
|
ALTER TABLE "plan_mo_test_standard" ADD COLUMN "judge_formula" varchar(255);
|
COMMENT ON COLUMN "public"."plan_mo_test_standard"."judge_formula" IS '判断公式（是否合格）';
|
--0830 end
|
|
|
--检测申请增加创建人、创建时间、更新人和更新时间
|
ALTER TABLE "warehouse_join_stock_order" ADD COLUMN "operation_task_id" int8;
|
COMMENT ON COLUMN "public"."warehouse_join_stock_order"."operation_task_id" IS '工单的id';
|
ALTER TABLE "warehouse_join_stock_order" ADD COLUMN "type" varchar(255);
|
COMMENT ON COLUMN "public"."warehouse_join_stock_order"."type" IS '类型';
|
|
--工单增加已预留数量
|
ALTER TABLE "production_operation_task" ADD COLUMN "reserved_quantity" numeric(12,6) DEFAULT 0;
|
COMMENT ON COLUMN "public"."production_operation_task"."reserved_quantity" IS '预留数量';
|
--工单所需物料增加预留数量
|
ALTER TABLE "production_operation_task_material" ADD COLUMN "reserved_quantity" numeric(12,6) DEFAULT 0;
|
COMMENT ON COLUMN "public"."production_operation_task_material"."reserved_quantity" IS '预留数量';
|
--0831 end
|
--工艺增加字段是否预留
|
ALTER TABLE "technology_routing_operation" ADD COLUMN "reserved" bool;
|
COMMENT ON COLUMN "public"."technology_routing_operation"."reserved" IS '是否预留';
|
--0831 end
|
|
--0906 start
|
--报工产出新增状态
|
ALTER TABLE "production_product_output" ADD COLUMN "state" varchar(255) COLLATE "pg_catalog"."default" DEFAULT '01draft'::character varying;
|
COMMENT ON COLUMN "public"."production_product_output"."state" IS '状态';
|
--0906 end
|
|
--0910 start
|
--退货
|
CREATE TABLE "public"."warehouse_send_back" (
|
"id" serial8,
|
"escort_detail_id" int8,
|
"part_no" varchar(100) COLLATE "pg_catalog"."default",
|
"part_name" varchar(100) COLLATE "pg_catalog"."default",
|
"part_batch_no" varchar(100) COLLATE "pg_catalog"."default",
|
"system_no" varchar(100) COLLATE "pg_catalog"."default",
|
"send_back_quantity" numeric(18,6) DEFAULT 0,
|
"part_unit" varchar(100) COLLATE "pg_catalog"."default",
|
"send_back_date" timestamp(6),
|
"is_company" bool,
|
"send_back_company_date" timestamp(6),
|
"send_back_reason" varchar(255) COLLATE "pg_catalog"."default",
|
"send_back_location_id" int8,
|
"status" varchar(255) COLLATE "pg_catalog"."default",
|
CONSTRAINT "warehouse_send_back_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."warehouse_send_back"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."escort_detail_id" IS '发货明细id';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."part_no" IS '零件编号';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."part_name" IS '零件名称';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."part_batch_no" IS '零件批号';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."system_no" IS '零件系统号';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."send_back_quantity" IS '退货数量';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."part_unit" IS '零件单位';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."send_back_date" IS '退货日期';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."is_company" IS '是否退回公司';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."send_back_company_date" IS '退回公司日期';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."send_back_reason" IS '退货原因';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."send_back_location_id" IS '退回库位id';
|
|
COMMENT ON COLUMN "public"."warehouse_send_back"."status" IS '状态';
|
|
COMMENT ON TABLE "public"."warehouse_send_back" IS '退货表';
|
--0910 end
|
|
--0908 start cxf
|
ALTER TABLE "public"."quality_report_sample"
|
ADD COLUMN "is_qualified" bool;
|
COMMENT ON COLUMN "public"."quality_report_sample"."is_qualified" IS '是否合格';
|
--0908 end cxf
|
--1023 start cxf
|
CREATE TABLE "public"."plan_outsourcing_order" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_outsourcing_order_id_seq'::regclass),
|
"outsourcing_order_no" varchar(50) COLLATE "pg_catalog"."default",
|
"part_id" int8 NOT NULL,
|
"qty_required" numeric(18,6) NOT NULL,
|
"qty_finished" numeric(18,6) NOT NULL DEFAULT 0,
|
"required_date" timestamp(6),
|
"state" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
|
"remark" varchar(255) COLLATE "pg_catalog"."default",
|
"oa_id" int8,
|
"oa_state" varchar(50) COLLATE "pg_catalog"."default",
|
"erp_id" int8,
|
"erp_state" varchar(50) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default",
|
"mps_id" int8,
|
CONSTRAINT "plan_outsourcing_order_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."plan_outsourcing_order"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."outsourcing_order_no" IS '委外订单号';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."part_id" IS '零件id';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."qty_required" IS '需求数量';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."qty_finished" IS '完成数量';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."required_date" IS '需求日期';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."state" IS '状态';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."remark" IS '备注';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."oa_id" IS 'oa_id';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."oa_state" IS 'oa状态';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."erp_id" IS 'erp_id';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."erp_state" IS 'erp状态';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."create_time" IS '创建时间';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."update_time" IS '更新时间';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."create_user" IS '创建人';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."update_user" IS '更新人';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order"."mps_id" IS '主生产计划id';
|
|
COMMENT ON TABLE "public"."plan_outsourcing_order" IS '委外订单表';
|
|
CREATE TABLE "public"."plan_outsourcing_order_stock" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_outsourcing_order_stock_id_seq'::regclass),
|
"outsourcing_order_id" int8,
|
"part_id" int8,
|
"part_batch_no" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
|
"receive_quantity" numeric(18,6) NOT NULL,
|
"location_id" int8,
|
"stock_id" int8,
|
CONSTRAINT "plan_outsourcing_order_stock_pkey" PRIMARY KEY ("id")
|
)
|
;
|
|
ALTER TABLE "public"."plan_outsourcing_order_stock"
|
OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order_stock"."id" IS 'id';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order_stock"."outsourcing_order_id" IS '委外订单id';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order_stock"."part_id" IS '零件id';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order_stock"."part_batch_no" IS '零件批号';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order_stock"."receive_quantity" IS '接受数量';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order_stock"."location_id" IS '库位';
|
|
COMMENT ON COLUMN "public"."plan_outsourcing_order_stock"."stock_id" IS '库存id';
|
|
COMMENT ON TABLE "public"."plan_outsourcing_order_stock" IS '委外订单库存接收表';
|
|
--客户订单增加合同的id
|
ALTER TABLE "plan_customer_order" ADD COLUMN "auto_id" int8,
|
COMMENT ON COLUMN "public"."plan_customer_order"."auto_id" IS 'GSM合同产品的id';
|
--发货增加GSM的押运单的id
|
ALTER TABLE "warehouse_escort" ADD COLUMN "escort_auto_id" int8,
|
COMMENT ON COLUMN "public"."warehouse_escort"."escort_auto_id" IS 'GSM的押运单的id';
|
--发货明细增加GSM的押运单的id
|
ALTER TABLE "warehouse_escort_detail" ADD COLUMN "escort_in_auto_id" int8,
|
COMMENT ON COLUMN "public"."warehouse_escort_detail"."escort_in_auto_id" IS 'GSM的押运单明细表的入库id';
|
ALTER TABLE "warehouse_escort_detail" ADD COLUMN "escort_out_auto_id" int8,
|
COMMENT ON COLUMN "public"."warehouse_escort_detail"."escort_out_auto_id" IS 'GSM的押运单明细表的发货id';
|
--1023 end cxf
|
|
-- 2022.09.06
|
create table public.plan_order_process_config_file
|
(
|
id bigserial
|
primary key,
|
order_number varchar(50),
|
file_name varchar,
|
bucket_name varchar(255),
|
original_file_name varchar(100),
|
create_user varchar(20),
|
create_time timestamp(6),
|
update_user varchar(20),
|
update_time timestamp(6),
|
line_number varchar(10),
|
effective_range varchar(1)
|
);
|
|
comment on column public.plan_order_process_config_file.order_number is '销售订单号';
|
|
comment on column public.plan_order_process_config_file.file_name is '文件名';
|
|
comment on column public.plan_order_process_config_file.original_file_name is '原始文件名';
|
|
comment on column public.plan_order_process_config_file.create_user is '创建人';
|
|
comment on column public.plan_order_process_config_file.create_time is '创建时间';
|
|
comment on column public.plan_order_process_config_file.update_user is '更新人';
|
|
comment on column public.plan_order_process_config_file.update_time is '更新时间';
|
|
comment on column public.plan_order_process_config_file.line_number is '行号';
|
|
comment on column public.plan_order_process_config_file.effective_range is '文件适用范围：1:销售订单；2：销售订单行';
|
|
-- 2022.09.19 生产退料申请表
|
CREATE SEQUENCE "public"."warehouse_reverse_stock_apply_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."warehouse_reverse_stock_apply"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('warehouse_reverse_stock_apply_id_seq'::regclass),
|
"apply_serial_no" varchar(20) COLLATE "pg_catalog"."default",
|
"state" varchar(20) COLLATE "pg_catalog"."default",
|
"create_user" varchar(100) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_user" varchar(100) COLLATE "pg_catalog"."default",
|
"update_time" timestamp(6),
|
CONSTRAINT "warehouse_reverse_stock_apply_pkey" PRIMARY KEY ("id")
|
);
|
comment on column public.warehouse_reverse_stock_apply.apply_serial_no is '退料申请流水号';
|
comment on column public.warehouse_reverse_stock_apply.state is '状态：draft-草稿;processing-进行中;processed-已执行';
|
comment on column public.warehouse_reverse_stock_apply.create_user is '创建人';
|
comment on column public.warehouse_reverse_stock_apply.create_time is '创建时间';
|
comment on column public.warehouse_reverse_stock_apply.update_user is '更新人';
|
comment on column public.warehouse_reverse_stock_apply.update_time is '更新时间';
|
|
ALTER SEQUENCE "public"."warehouse_reverse_stock_apply_id_seq"
|
OWNED BY "public"."warehouse_reverse_stock_apply"."id";
|
|
ALTER TABLE "public"."warehouse_reverse_stock_apply" OWNER TO "postgres";
|
ALTER SEQUENCE "public"."warehouse_reverse_stock_apply_id_seq" OWNER TO "postgres";
|
|
-- 生产退料申请详情表
|
CREATE SEQUENCE "public"."warehouse_reverse_stock_apply_detail_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."warehouse_reverse_stock_apply_detail"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('warehouse_reverse_stock_apply_detail_id_seq'::regclass),
|
"reverse_apply_id" bigint not null,
|
"stock_id" bigint not null,
|
"part_no" varchar(50) COLLATE "pg_catalog"."default",
|
"part_name" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_batch_no" varchar(100) COLLATE "pg_catalog"."default",
|
"sn" varchar(200) COLLATE "pg_catalog"."default",
|
"reverse_quantity" numeric(18,6),
|
"unit" varchar(50) COLLATE "pg_catalog"."default",
|
"ifs_from_location_no" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_from_location_name" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_to_location_no" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_to_location_name" varchar(255) COLLATE "pg_catalog"."default",
|
"state" varchar(20) COLLATE "pg_catalog"."default",
|
"create_user" varchar(100) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_user" varchar(100) COLLATE "pg_catalog"."default",
|
"update_time" timestamp(6),
|
CONSTRAINT "warehouse_reverse_stock_apply_detail_pkey" PRIMARY KEY ("id")
|
);
|
|
comment on column public.warehouse_reverse_stock_apply_detail.reverse_apply_id is '退料申请主表id';
|
comment on column public.warehouse_reverse_stock_apply_detail.stock_id is '库存id';
|
comment on column public.warehouse_reverse_stock_apply_detail.part_no is '零件编号';
|
comment on column public.warehouse_reverse_stock_apply_detail.part_name is '零件名称';
|
comment on column public.warehouse_reverse_stock_apply_detail.ifs_batch_no is 'IFS批次号';
|
comment on column public.warehouse_reverse_stock_apply_detail.sn is 'SN号';
|
comment on column public.warehouse_reverse_stock_apply_detail.reverse_quantity is '退料数量';
|
comment on column public.warehouse_reverse_stock_apply_detail.unit is '单位';
|
comment on column public.warehouse_reverse_stock_apply_detail.ifs_from_location_no is 'IFS从库位编号';
|
comment on column public.warehouse_reverse_stock_apply_detail.ifs_from_location_name is 'IFS从库位名称';
|
comment on column public.warehouse_reverse_stock_apply_detail.ifs_to_location_no is 'IFS至库位编号';
|
comment on column public.warehouse_reverse_stock_apply_detail.ifs_to_location_name is 'IFS至库位名称';
|
comment on column public.warehouse_reverse_stock_apply_detail.state is '状态:new-新建;processed-已执行';
|
comment on column public.warehouse_reverse_stock_apply_detail.create_user is '创建人';
|
comment on column public.warehouse_reverse_stock_apply_detail.create_time is '创建时间';
|
comment on column public.warehouse_reverse_stock_apply_detail.update_user is '更新人';
|
comment on column public.warehouse_reverse_stock_apply_detail.update_time is '更新时间';
|
|
ALTER SEQUENCE "public"."warehouse_reverse_stock_apply_detail_id_seq"
|
OWNED BY "public"."warehouse_reverse_stock_apply_detail"."id";
|
|
ALTER TABLE "public"."warehouse_reverse_stock_apply_detail" OWNER TO "postgres";
|
ALTER SEQUENCE "public"."warehouse_reverse_stock_apply_detail_id_seq" OWNER TO "postgres";
|
|
-- 工艺配置单销售订单关系表
|
CREATE SEQUENCE "public"."plan_process_config_file_order_mapping_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."plan_process_config_file_order_mapping"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('plan_process_config_file_order_mapping_id_seq'::regclass),
|
"config_file_id" bigint not null,
|
"order_number" varchar(150) COLLATE "pg_catalog"."default",
|
"line_number" varchar(50) COLLATE "pg_catalog"."default",
|
"create_user" varchar(100) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_user" varchar(100) COLLATE "pg_catalog"."default",
|
"update_time" timestamp(6),
|
CONSTRAINT "plan_process_config_file_order_mapping_pkey" PRIMARY KEY ("id")
|
);
|
|
comment on column public.plan_process_config_file_order_mapping.config_file_id is '工艺配置单文件表id';
|
comment on column public.plan_process_config_file_order_mapping.order_number is '订单号';
|
comment on column public.plan_process_config_file_order_mapping.line_number is '行号';
|
comment on column public.plan_process_config_file_order_mapping.create_user is '创建人';
|
comment on column public.plan_process_config_file_order_mapping.create_time is '创建时间';
|
comment on column public.plan_process_config_file_order_mapping.update_user is '更新人';
|
comment on column public.plan_process_config_file_order_mapping.update_time is '更新时间';
|
|
ALTER SEQUENCE "public"."plan_process_config_file_order_mapping_id_seq"
|
OWNED BY "public"."plan_process_config_file_order_mapping"."id";
|
|
ALTER TABLE "public"."plan_process_config_file_order_mapping" OWNER TO "postgres";
|
ALTER SEQUENCE "public"."plan_process_config_file_order_mapping_id_seq" OWNER TO "postgres";
|
|
-- 外协成品报检表
|
CREATE SEQUENCE "public"."outsource_inspection_declaration_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."outsource_inspection_declaration"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('outsource_inspection_declaration_id_seq'::regclass),
|
"inspection_serial_no" varchar(20) COLLATE "pg_catalog"."default",
|
"inspection_quantity" numeric(18,6),
|
"stock_quantity" numeric(18,6),
|
"difference_quantity" numeric(18,6),
|
"create_user" varchar(100) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_user" varchar(100) COLLATE "pg_catalog"."default",
|
"update_time" timestamp(6),
|
CONSTRAINT "outsource_inspection_declaration_pkey" PRIMARY KEY ("id")
|
);
|
|
comment on column public.outsource_inspection_declaration.inspection_serial_no is '报检流水号';
|
comment on column public.outsource_inspection_declaration.inspection_quantity is '报检数量';
|
comment on column public.outsource_inspection_declaration.stock_quantity is '入库数量';
|
comment on column public.outsource_inspection_declaration.difference_quantity is '差额';
|
comment on column public.outsource_inspection_declaration.create_user is '创建人';
|
comment on column public.outsource_inspection_declaration.create_time is '创建时间';
|
comment on column public.outsource_inspection_declaration.update_user is '更新人';
|
comment on column public.outsource_inspection_declaration.update_time is '更新时间';
|
|
ALTER SEQUENCE "public"."outsource_inspection_declaration_id_seq"
|
OWNED BY "public"."outsource_inspection_declaration"."id";
|
|
ALTER TABLE "public"."outsource_inspection_declaration" OWNER TO "postgres";
|
ALTER SEQUENCE "public"."outsource_inspection_declaration_id_seq" OWNER TO "postgres";
|
|
-- 外协成品报检明细表
|
CREATE SEQUENCE "public"."outsource_inspection_declaration_detail_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."outsource_inspection_declaration_detail"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('outsource_inspection_declaration_detail_id_seq'::regclass),
|
"inspection_serial_no" varchar(20) COLLATE "pg_catalog"."default",
|
"certificate_number" varchar(100) COLLATE "pg_catalog"."default",
|
"inspection_quantity" numeric(18,6),
|
"sampling_state" varchar(2) COLLATE "pg_catalog"."default",
|
"packaging_state" varchar(2) COLLATE "pg_catalog"."default",
|
"stock_state" varchar(2) COLLATE "pg_catalog"."default",
|
"packaging_operator" varchar(100) COLLATE "pg_catalog"."default",
|
"stock_operator" varchar(100) COLLATE "pg_catalog"."default",
|
"state" varchar(20) COLLATE "pg_catalog"."default",
|
"insp_state" varchar(20) COLLATE "pg_catalog"."default",
|
"create_user" varchar(100) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_user" varchar(100) COLLATE "pg_catalog"."default",
|
"update_time" timestamp(6),
|
CONSTRAINT "outsource_inspection_declaration_detail_pkey" PRIMARY KEY ("id")
|
);
|
|
comment on column public.outsource_inspection_declaration_detail.inspection_serial_no is '报检流水号';
|
comment on column public.outsource_inspection_declaration_detail.certificate_number is '合格证号';
|
comment on column public.outsource_inspection_declaration_detail.inspection_quantity is '报检数量';
|
comment on column public.outsource_inspection_declaration_detail.sampling_state is '是否抽检';
|
comment on column public.outsource_inspection_declaration_detail.packaging_state is '是否包装';
|
comment on column public.outsource_inspection_declaration_detail.stock_state is '是否入库';
|
comment on column public.outsource_inspection_declaration_detail.packaging_operator is '包装人员';
|
comment on column public.outsource_inspection_declaration_detail.stock_operator is '入库人员';
|
comment on column public.outsource_inspection_declaration_detail.state is '状态';
|
comment on column public.outsource_inspection_declaration_detail.insp_state is '检测状态';
|
comment on column public.outsource_inspection_declaration_detail.create_user is '创建人';
|
comment on column public.outsource_inspection_declaration_detail.create_time is '创建时间';
|
comment on column public.outsource_inspection_declaration_detail.update_user is '更新人';
|
comment on column public.outsource_inspection_declaration_detail.update_time is '更新时间';
|
|
ALTER SEQUENCE "public"."outsource_inspection_declaration_detail_id_seq"
|
OWNED BY "public"."outsource_inspection_declaration_detail"."id";
|
|
ALTER TABLE "public"."outsource_inspection_declaration_detail" OWNER TO "postgres";
|
ALTER SEQUENCE "public"."outsource_inspection_declaration_detail_id_seq" OWNER TO "postgres";
|
|
---- 2022年10月20号
|
-- 新盘点主表
|
CREATE SEQUENCE "public"."warehouse_inventory_main_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."warehouse_inventory_main" (
|
"id" int8 NOT NULL DEFAULT nextval('warehouse_inventory_main_id_seq'::regclass),
|
"iny_no" varchar(50) COLLATE "pg_catalog"."default",
|
"iny_desc" varchar(255) COLLATE "pg_catalog"."default",
|
"iny_status" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default"
|
)
|
;
|
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."id" IS 'id';
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."iny_no" IS '盘点编号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."iny_desc" IS '盘点描述';
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."iny_status" IS '状态（草稿，盘点中，已完成）';
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."warehouse_inventory_main"."update_user" IS '更新人';
|
|
ALTER TABLE "public"."warehouse_inventory_main"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."warehouse_inventory_main_id_seq"
|
OWNED BY "public"."warehouse_inventory_main"."id";
|
|
|
---- 2022年10月20号
|
-- 新盘点明细表
|
CREATE SEQUENCE "public"."warehouse_inventory_detail_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
CREATE TABLE "public"."warehouse_inventory_detail" (
|
"id" int8 NOT NULL DEFAULT nextval('warehouse_inventory_detail_id_seq'::regclass),
|
"inventory_main_id" int8,
|
"part_no" varchar(100) COLLATE "pg_catalog"."default",
|
"part_name" varchar(225) COLLATE "pg_catalog"."default",
|
"planning_method" varchar(50) COLLATE "pg_catalog"."default",
|
"sn" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_batch_no" varchar(255) COLLATE "pg_catalog"."default",
|
"warehouse_name" varchar(255) COLLATE "pg_catalog"."default",
|
"loc_no" varchar(50) COLLATE "pg_catalog"."default",
|
"stock_quantity" numeric(18,6),
|
"unit" varchar(20) COLLATE "pg_catalog"."default",
|
"iny_qty" numeric(18,6),
|
"iny_diff_qty" numeric(18,6),
|
"commit_num" int4,
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"iny_no" varchar(50) COLLATE "pg_catalog"."default",
|
"warehouse_id" int8
|
)
|
;
|
|
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."id" IS 'id';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."inventory_main_id" IS '盘点主表id';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."part_no" IS '零件号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."part_name" IS '零件名称';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."planning_method" IS '计划方法（只能传A、K、P）';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."sn" IS 'sn号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."ifs_batch_no" IS 'ifs批次号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."warehouse_name" IS '仓库';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."loc_no" IS '库位编号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."stock_quantity" IS '库存数量';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."unit" IS '单位';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."iny_qty" IS '盘点数量';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."iny_diff_qty" IS '盘点差异数量';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."commit_num" IS '扫码提交次数';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."update_user" IS '更新人';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."iny_no" IS '盘点编号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_detail"."warehouse_id" IS '仓库id';
|
|
ALTER TABLE "public"."warehouse_inventory_detail"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."warehouse_inventory_detail_id_seq"
|
OWNED BY "public"."warehouse_inventory_detail"."id";
|
|
|
-- 2022年10月26号
|
-- 新工艺配置单
|
CREATE SEQUENCE "public"."plan_process_config_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."plan_process_config" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_process_config_id_seq'::regclass),
|
"model_type" varchar(50) COLLATE "pg_catalog"."default",
|
"pro_no" varchar(50) COLLATE "pg_catalog"."default",
|
"pro_name" varchar(100) COLLATE "pg_catalog"."default",
|
"print_req" varchar(255) COLLATE "pg_catalog"."default",
|
"remark1" varchar(1000) COLLATE "pg_catalog"."default",
|
"remark2" varchar(1000) COLLATE "pg_catalog"."default",
|
"remark3" varchar(1000) COLLATE "pg_catalog"."default",
|
"remark4" varchar(1000) COLLATE "pg_catalog"."default",
|
"real_print_req" varchar(255) COLLATE "pg_catalog"."default",
|
"cable_core" varchar(50) COLLATE "pg_catalog"."default",
|
"model_core" varchar(50) COLLATE "pg_catalog"."default",
|
"model_sleeve" varchar(50) COLLATE "pg_catalog"."default",
|
"sizing_model" varchar(50) COLLATE "pg_catalog"."default",
|
"strand_model" varchar(50) COLLATE "pg_catalog"."default",
|
"work_frequency" varchar(255) COLLATE "pg_catalog"."default",
|
"frequency_range" varchar(255) COLLATE "pg_catalog"."default",
|
"resistance" varchar(255) COLLATE "pg_catalog"."default",
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"order_number" varchar(50) COLLATE "pg_catalog"."default",
|
"order_id" int8
|
)
|
;
|
COMMENT ON COLUMN "public"."plan_process_config"."id" IS 'id';
|
COMMENT ON COLUMN "public"."plan_process_config"."model_type" IS '模板类型';
|
COMMENT ON COLUMN "public"."plan_process_config"."pro_no" IS '项目编号';
|
COMMENT ON COLUMN "public"."plan_process_config"."pro_name" IS '项目名称';
|
COMMENT ON COLUMN "public"."plan_process_config"."print_req" IS '印字要求';
|
COMMENT ON COLUMN "public"."plan_process_config"."remark1" IS '备注1';
|
COMMENT ON COLUMN "public"."plan_process_config"."remark2" IS '备注2';
|
COMMENT ON COLUMN "public"."plan_process_config"."remark3" IS '备注3';
|
COMMENT ON COLUMN "public"."plan_process_config"."remark4" IS '备注4';
|
COMMENT ON COLUMN "public"."plan_process_config"."real_print_req" IS '实际印字要求';
|
COMMENT ON COLUMN "public"."plan_process_config"."cable_core" IS '发泡缆芯';
|
COMMENT ON COLUMN "public"."plan_process_config"."model_core" IS '模芯';
|
COMMENT ON COLUMN "public"."plan_process_config"."model_sleeve" IS '模套';
|
COMMENT ON COLUMN "public"."plan_process_config"."sizing_model" IS '定径模';
|
COMMENT ON COLUMN "public"."plan_process_config"."strand_model" IS '绞合模';
|
COMMENT ON COLUMN "public"."plan_process_config"."work_frequency" IS '工作频带内驻波比';
|
COMMENT ON COLUMN "public"."plan_process_config"."frequency_range" IS '频率范围';
|
COMMENT ON COLUMN "public"."plan_process_config"."resistance" IS '直流电阻';
|
COMMENT ON COLUMN "public"."plan_process_config"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."plan_process_config"."update_user" IS '更新人';
|
COMMENT ON COLUMN "public"."plan_process_config"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."plan_process_config"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."plan_process_config"."order_number" IS '订单号';
|
COMMENT ON COLUMN "public"."plan_process_config"."order_id" IS '订单id';
|
|
|
ALTER TABLE "public"."plan_process_config" OWNER TO "postgres";
|
ALTER SEQUENCE "public"."plan_process_config_id_seq"
|
OWNED BY "public"."plan_process_config"."id";
|
|
|
|
|
|
-- 2022年10月26号
|
-- 新工艺配置单产品性能要求表
|
CREATE SEQUENCE "public"."plan_process_config_data_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."plan_process_config_data" (
|
"id" int8 NOT NULL DEFAULT nextval('plan_process_config_data_id_seq'::regclass),
|
"frequency" varchar(50) COLLATE "pg_catalog"."default",
|
"delivery_reduce" varchar(50) COLLATE "pg_catalog"."default",
|
"coupling_loss" varchar(50) COLLATE "pg_catalog"."default",
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"config_id" int8
|
)
|
;
|
COMMENT ON COLUMN "public"."plan_process_config_data"."id" IS 'id';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."frequency" IS '频率';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."delivery_reduce" IS '最大传送衰减';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."coupling_loss" IS '耦合损耗';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."update_user" IS '更新人';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."plan_process_config_data"."config_id" IS '工艺配置单id';
|
|
ALTER TABLE "public"."plan_process_config_data" OWNER TO "postgres";
|
ALTER SEQUENCE "public"."plan_process_config_data_id_seq"
|
OWNED BY "public"."plan_process_config_data"."id";
|
|
|
|
|
|
---- 2022年10月20号
|
-- 新盘点pda表
|
CREATE SEQUENCE "public"."warehouse_inventory_pda_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."warehouse_inventory_pda" (
|
"id" int8 NOT NULL DEFAULT nextval('warehouse_inventory_pda_id_seq'::regclass),
|
"part_no" varchar(100) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
|
"sn" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_batch_no" varchar(255) COLLATE "pg_catalog"."default",
|
"loc_no" varchar(50) COLLATE "pg_catalog"."default",
|
"iny_qty" numeric(18,6),
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"inventory_detail_id" int8
|
)
|
;
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."id" IS 'id';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."part_no" IS '零件号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."sn" IS 'sn号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."ifs_batch_no" IS 'ifs批次号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."loc_no" IS '库位编号';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."iny_qty" IS '盘点数量';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."update_user" IS '更新人';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."warehouse_inventory_pda"."inventory_detail_id" IS '盘点明细id';
|
|
ALTER TABLE "public"."warehouse_inventory_pda"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."warehouse_inventory_pda_id_seq"
|
OWNED BY "public"."warehouse_inventory_pda"."id";
|
|
-- 2022-11-02 库存事务表新增IFS批次号字段
|
alter table warehouse_transaction
|
add column ifs_batch_no varchar(100);
|
|
-- 2022-11-07 对接ifs日志表新增字段
|
ALTER TABLE "ifs_log" ADD COLUMN "active" BOOLEAN DEFAULT TRUE;
|
|
-- 2022年11月7号
|
-- 货盘运输任务主表
|
ALTER TABLE "warehouse_pallet_transports" ADD COLUMN "state" varchar(20) COLLATE "pg_catalog"."default";
|
|
-- 2022年11月8号
|
-- 货盘运输任务主表状态加默认值
|
ALTER TABLE "warehouse_pallet_transports" ALTER COLUMN "state" set DEFAULT 'draft' ;
|
|
|
-- 2022年11月7号
|
--退料申请详情表
|
ALTER TABLE "warehouse_reverse_stock_apply_detail" ADD COLUMN "executor" varchar(100) COLLATE "pg_catalog"."default";
|
ALTER TABLE "warehouse_reverse_stock_apply_detail" ADD COLUMN "execute_time" timestamp(6);
|
|
-- 2022年11月16号
|
--工艺文件结构图表
|
CREATE SEQUENCE "public"."technology_document_jgt_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
|
CREATE TABLE "public"."technology_document_jgt" (
|
"id" int8 NOT NULL DEFAULT nextval('technology_document_jgt_id_seq'::regclass),
|
"file_name" varchar(500) COLLATE "pg_catalog"."default",
|
"document_id" int8,
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default"
|
)
|
;
|
COMMENT ON COLUMN "public"."technology_document_jgt"."id" IS 'id';
|
COMMENT ON COLUMN "public"."technology_document_jgt"."file_name" IS '结构图文件名';
|
COMMENT ON COLUMN "public"."technology_document_jgt"."document_id" IS '工艺文件id';
|
|
ALTER SEQUENCE "public"."technology_document_jgt_id_seq"
|
OWNED BY "public"."technology_document_jgt"."id";
|
|
ALTER SEQUENCE "public"."technology_document_jgt_id_seq" OWNER TO "postgres";
|
|
ALTER table "public"."technology_document" drop COLUMN "jgt";
|
|
|
|
|
-- 2022年11月7号
|
--工厂信息表
|
ALTER TABLE "equipment_equipment" ADD COLUMN "workshop" varchar(50) COLLATE "pg_catalog"."default";
|
|
-- 2022年11月17号
|
--工艺文件表
|
ALTER TABLE "technology_document" ADD COLUMN "test_standard" BOOLEAN COLLATE "pg_catalog"."default";
|
--零件表
|
ALTER TABLE "basic_part" ADD COLUMN "examiner" varchar(50) COLLATE "pg_catalog"."default";
|
|
--馈线合格证表
|
CREATE SEQUENCE "public"."production_feeder_certificate_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
|
CREATE TABLE "public"."production_feeder_certificate" (
|
"id" int8 NOT NULL,
|
"sn" varchar(255) COLLATE "pg_catalog"."default",
|
"part_no" varchar(255) COLLATE "pg_catalog"."default",
|
"part_name" varchar(255) COLLATE "pg_catalog"."default",
|
"specs" varchar(100) COLLATE "pg_catalog"."default",
|
"stock_quantity" numeric(18,6),
|
"date" varchar(50) COLLATE "pg_catalog"."default",
|
"examiner" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_batch_no" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default"
|
)
|
;
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."id" IS 'id';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."sn" IS 'sn号';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."part_no" IS '零件号';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."part_name" IS '零件名称';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."specs" IS '规格';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."stock_quantity" IS '长度';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."date" IS '日期';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."examiner" IS '检验员';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."ifs_batch_no" IS 'ifs批次号';
|
|
ALTER TABLE "public"."production_feeder_certificate"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."production_feeder_certificate_id_seq"
|
OWNED BY "public"."production_feeder_certificate"."id";
|
|
|
|
-- 2022年11月22号
|
--检验员配置表
|
CREATE SEQUENCE "public"."production_examiner_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."production_examiner" (
|
"id" int8 NOT NULL DEFAULT nextval('production_examiner_id_seq'::regclass),
|
"part_no" varchar(100) COLLATE "pg_catalog"."default",
|
"examiner" varchar(50) COLLATE "pg_catalog"."default",
|
"examiner_after" varchar(50) COLLATE "pg_catalog"."default",
|
"part_no_after" varchar(100) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_time" timestamp(6),
|
"update_user" varchar(50) COLLATE "pg_catalog"."default"
|
)
|
;
|
COMMENT ON COLUMN "public"."production_examiner"."part_no" IS '零件号';
|
COMMENT ON COLUMN "public"."production_examiner"."examiner" IS '默认检验员';
|
COMMENT ON COLUMN "public"."production_examiner"."examiner_after" IS '改后检验员';
|
COMMENT ON COLUMN "public"."production_examiner"."part_no_after" IS '改后零件号';
|
|
|
ALTER TABLE "public"."production_examiner"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."production_examiner_id_seq"
|
OWNED BY "public"."production_examiner"."id";
|
|
|
|
-- v1.31.0 检测项继承
|
-- 工艺文件标准参数
|
alter table public.technology_document_standard_param
|
add extends_part_no varchar(50);
|
|
comment on column public.technology_document_standard_param.extends_part_no is '继承检测零件号';
|
|
alter table public.technology_document_standard_param
|
add extends_routing_id bigint;
|
|
comment on column public.technology_document_standard_param.extends_routing_id is '继承检测工艺路线id';
|
|
alter table public.technology_document_standard_param
|
add extends_routing_no varchar(50);
|
|
comment on column public.technology_document_standard_param.extends_routing_no is '继承检测工艺路线编号';
|
|
alter table public.technology_document_standard_param
|
add extends_operation_id bigint;
|
|
comment on column public.technology_document_standard_param.extends_operation_id is '继承检测工序id';
|
|
alter table public.technology_document_standard_param
|
add extends_operation_no varchar(50);
|
|
comment on column public.technology_document_standard_param.extends_operation_no is '继承检测工序编号';
|
|
alter table public.technology_document_standard_param
|
add extends_test_standard_id bigint;
|
|
comment on column public.technology_document_standard_param.extends_test_standard_id is '继承检测标准id';
|
|
alter table public.technology_document_standard_param
|
add extends_test_standard_no varchar(50);
|
|
comment on column public.technology_document_standard_param.extends_test_standard_no is '继承检测标准编号';
|
|
alter table public.technology_document_standard_param
|
add extends_test_standard_param_id bigint;
|
|
comment on column public.technology_document_standard_param.extends_test_standard_param_id is '继承检测标准参数id';
|
|
alter table public.technology_document_standard_param
|
add extends_test_standard_param_no varchar(50);
|
|
comment on column public.technology_document_standard_param.extends_test_standard_param_no is '继承检测标准参数编号';
|
|
|
alter table public.technology_document_standard_param
|
add bom_routing_id bigint;
|
|
alter table public.technology_document_standard_param
|
add routing_operation_id bigint;
|
|
-- 制造订单-检测标准参数
|
alter table public.plan_mo_test_standard_param
|
add extends_part_no varchar(50);
|
|
comment on column public.plan_mo_test_standard_param.extends_part_no is '继承检测零件号';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_routing_id bigint;
|
|
comment on column public.plan_mo_test_standard_param.extends_routing_id is '继承检测工艺路线id';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_routing_no varchar(50);
|
|
comment on column public.plan_mo_test_standard_param.extends_routing_no is '继承检测工艺路线编号';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_operation_id bigint;
|
|
comment on column public.plan_mo_test_standard_param.extends_operation_id is '继承检测工序id';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_operation_no varchar(50);
|
|
comment on column public.plan_mo_test_standard_param.extends_operation_no is '继承检测工序编号';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_test_standard_id bigint;
|
|
comment on column public.plan_mo_test_standard_param.extends_test_standard_id is '继承检测标准id';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_test_standard_no varchar(50);
|
|
comment on column public.plan_mo_test_standard_param.extends_test_standard_no is '继承检测标准编号';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_test_standard_param_id bigint;
|
|
comment on column public.plan_mo_test_standard_param.extends_test_standard_param_id is '继承检测标准参数id';
|
|
alter table public.plan_mo_test_standard_param
|
add extends_test_standard_param_no varchar(50);
|
|
comment on column public.plan_mo_test_standard_param.extends_test_standard_param_no is '继承检测标准参数编号';
|
|
|
alter table public.plan_mo_test_standard_param
|
add technology_document_standard_param_id bigint;
|
|
comment on column public.plan_mo_test_standard_param.technology_document_standard_param_id is '工艺文件检测标准参数明细表id';
|
|
-- 检测汇报项目表
|
alter table public.quality_report_sample_item
|
add extends_part_no varchar(50);
|
|
comment on column public.quality_report_sample_item.extends_part_no is '继承检测零件号';
|
|
alter table public.quality_report_sample_item
|
add extends_routing_id bigint;
|
|
comment on column public.quality_report_sample_item.extends_routing_id is '继承检测工艺路线id';
|
|
alter table public.quality_report_sample_item
|
add extends_routing_no varchar(50);
|
|
comment on column public.quality_report_sample_item.extends_routing_no is '继承检测工艺路线编号';
|
|
alter table public.quality_report_sample_item
|
add extends_operation_id bigint;
|
|
comment on column public.quality_report_sample_item.extends_operation_id is '继承检测工序id';
|
|
alter table public.quality_report_sample_item
|
add extends_operation_no varchar(50);
|
|
comment on column public.quality_report_sample_item.extends_operation_no is '继承检测工序编号';
|
|
alter table public.quality_report_sample_item
|
add extends_test_standard_id bigint;
|
|
comment on column public.quality_report_sample_item.extends_test_standard_id is '继承检测标准id';
|
|
alter table public.quality_report_sample_item
|
add extends_test_standard_no varchar(50);
|
|
comment on column public.quality_report_sample_item.extends_test_standard_no is '继承检测标准编号';
|
|
alter table public.quality_report_sample_item
|
add extends_test_standard_param_id bigint;
|
|
comment on column public.quality_report_sample_item.extends_test_standard_param_id is '继承检测标准参数id';
|
|
alter table public.quality_report_sample_item
|
add extends_test_standard_param_no varchar(50);
|
|
comment on column public.quality_report_sample_item.extends_test_standard_param_no is '继承检测标准参数编号';
|
|
|
alter table public.quality_report_sample_item
|
add technology_document_standard_param_id bigint;
|
|
comment on column public.quality_report_sample_item.technology_document_standard_param_id is '工艺文件检测标准参数明细表id';
|
|
|
|
-- 2022年11月21号
|
--工艺文件主表
|
ALTER TABLE "technology_document" ADD COLUMN "update_user" varchar(50) COLLATE "pg_catalog"."default";
|
ALTER TABLE "technology_document" ADD COLUMN "update_time" timestamp(6);
|
|
alter table quality_report_sample_item add column extends_result_flag bool;
|
|
-- v1.33.0
|
alter table public.production_mould_register
|
add operation_task_id bigint;
|
|
comment on column public.production_mould_register.operation_task_id is '工单id';
|
|
alter table public.production_mould_register
|
add part_no varchar(100);
|
|
comment on column public.production_mould_register.part_no is '零件号';
|
|
alter table quality_zx_label_bind_relation
|
add column packaging_code varchar(100);
|
|
|
|
|
-- 2022年12月02号
|
--单位工时系数表
|
CREATE SEQUENCE "public"."production_unit_work_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
|
CREATE TABLE "public"."production_unit_work" (
|
"id" int8 NOT NULL DEFAULT nextval('production_unit_work_id_seq'::regclass),
|
"operation_id" int8,
|
"workstation_id" int8,
|
"part_id" int8,
|
"unit_work_factor" numeric(12,6),
|
"quota" numeric(12,6),
|
"update_user" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default"
|
)
|
;
|
COMMENT ON COLUMN "public"."production_unit_work"."id" IS 'id';
|
COMMENT ON COLUMN "public"."production_unit_work"."operation_id" IS '工序id';
|
COMMENT ON COLUMN "public"."production_unit_work"."workstation_id" IS '机台id';
|
COMMENT ON COLUMN "public"."production_unit_work"."part_id" IS '零件id';
|
COMMENT ON COLUMN "public"."production_unit_work"."unit_work_factor" IS '单位工时系数';
|
COMMENT ON COLUMN "public"."production_unit_work"."quota" IS '定额';
|
|
|
|
-- 2022年12月06号
|
-- 报工产出表
|
ALTER TABLE "production_product_output" ADD COLUMN "orig_part_id" int8;
|
COMMENT ON COLUMN "public"."production_product_output"."orig_part_id" IS '原始零件id';
|
|
-- 2022年12月06号
|
-- 馈线合格证表
|
ALTER TABLE "production_feeder_certificate" DROP COLUMN "examiner_before";
|
ALTER TABLE "production_feeder_certificate" DROP COLUMN "part_no_before";
|
ALTER TABLE "production_feeder_certificate" ADD COLUMN "examiner_after" varchar(255) COLLATE "pg_catalog"."default";
|
ALTER TABLE "production_feeder_certificate" ADD COLUMN "part_no_after" varchar(255) COLLATE "pg_catalog"."default";
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."examiner_after" IS '改后检验员';
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."part_no_after" IS '改后零件号';
|
|
-- 2022年12月12号
|
-- 馈线合格证表
|
ALTER TABLE "production_feeder_certificate" ADD COLUMN "stock_quantity_after" numeric(18,6) DEFAULT 0;
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."stock_quantity_after" IS '入库长度';
|
|
|
-- 2022年12月09号
|
-- 客户订单主表
|
ALTER TABLE "plan_customer" ADD COLUMN "comment" varchar(255);
|
COMMENT ON COLUMN "public"."plan_customer"."comment" IS '备注';
|
|
-- 2022年12月09号
|
-- 客户订单主表（股份公司）
|
ALTER TABLE "plan_customer_joint_stock_company" ADD COLUMN "comment" varchar(255);
|
COMMENT ON COLUMN "public"."plan_customer_joint_stock_company"."comment" IS '备注';
|
|
|
-- 2022-12-14
|
-- 工艺文件表
|
ALTER TABLE "technology_document" ALTER COLUMN "test_standard" SET DEFAULT false;
|
|
-- 2022-12-19 箱码，销售订单关系表
|
CREATE SEQUENCE "public"."plan_package_code_customer_order_relation_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."plan_package_code_customer_order_relation"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('plan_package_code_customer_order_relation_id_seq'::regclass),
|
"customer_order_id" bigint,
|
"customer_order_no" varchar(255) COLLATE "pg_catalog"."default",
|
"otc_line_no" varchar(50) COLLATE "pg_catalog"."default",
|
"package_code" varchar(50) COLLATE "pg_catalog"."default",
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6)
|
)
|
;
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."id" IS 'id';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."customer_order_id" IS '销售订单id';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."customer_order_no" IS '销售订单号';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."otc_line_no" IS '行号';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."package_code" IS '箱码';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."update_user" IS '更新人';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."plan_package_code_customer_order_relation"."update_time" IS '更新时间';
|
|
ALTER TABLE "public"."plan_package_code_customer_order_relation"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."plan_package_code_customer_order_relation_id_seq"
|
OWNED BY "public"."plan_package_code_customer_order_relation"."id";
|
|
-- 2022.12.21
|
alter table public.plan_manufacturing_order
|
add ori_ifs_order_no varchar(32);
|
|
comment on column public.plan_manufacturing_order.ori_ifs_order_no is '原ifs车间订单号';
|
|
-- 2022年12月20号
|
-- 工艺文件主表
|
ALTER TABLE "technology_document" ADD COLUMN "update_real_user" varchar(50) COLLATE "pg_catalog"."default";
|
ALTER TABLE "technology_document" ADD COLUMN "update_real_time" timestamp(6);
|
|
-- 2022-12-28
|
alter table public.ifs_log
|
add interrupt_flag boolean;
|
|
comment on column public.ifs_log.interrupt_flag is '定时器执行ifs日志中断标记';
|
-- 2023年1月4号
|
-- 客户订单表
|
ALTER TABLE "plan_customer_order" ADD COLUMN "is_send" BOOLEAN DEFAULT false;
|
|
|
-- 2023年1月6号
|
-- 报工产出表
|
ALTER TABLE "production_product_output" ADD COLUMN "print_num" int8;
|
COMMENT ON COLUMN "public"."production_product_output"."print_num" IS '成品标签1打印次数';
|
|
-- 2023年1月12号
|
-- 馈线合格证
|
ALTER TABLE "production_feeder_certificate" ADD COLUMN "print_num" int8;
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."print_num" IS '打印次数';
|
|
-- 2023年2月14号
|
--馈线合格证
|
ALTER TABLE "production_feeder_certificate" ADD COLUMN "prod_name" varchar(255) COLLATE "pg_catalog"."default";
|
|
-- 2023年2月17号
|
--19码防呆校验
|
ALTER TABLE "quality_hw_19_verify" ADD unique("bar_code");
|
|
-- 2023年3月10号
|
--检测汇报项目表增加单位
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "unit" varchar(50);
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."unit" IS '单位';
|
|
-- 2023年3月20号
|
--包装表增加 包装称重是否接收异常
|
ALTER TABLE "warehouse_packaging" ADD COLUMN "is_rec_exception" BOOLEAN ;
|
COMMENT ON COLUMN "public"."warehouse_packaging"."is_rec_exception" IS '包装称重是否接收异常';
|
|
-- 2023年3月23号
|
--19表增加SN,长度,客户物料编码
|
ALTER TABLE "quality_hw_19_verify" ADD COLUMN "sn" varchar(64);
|
COMMENT ON COLUMN "public"."quality_hw_19_verify"."sn" IS 'SN';
|
ALTER TABLE "quality_hw_19_verify" ADD COLUMN "cus_material_code" varchar(64);
|
COMMENT ON COLUMN "public"."quality_hw_19_verify"."cus_material_code" IS '客户物料编码';
|
ALTER TABLE "quality_hw_19_verify" ADD COLUMN "qty" numeric(18,6) DEFAULT 0;
|
COMMENT ON COLUMN "public"."quality_hw_19_verify"."qty" IS '长度';
|
|
-- 2023年3月24号
|
--检测汇报项目表增加 计算值和采集值
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "cal_item_value" varchar(100);
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."cal_item_value" IS '计算值';
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "acq_item_value" varchar(100);
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."acq_item_value" IS '采集值';
|
|
-- 2023年3月27号
|
--工单生产记录表增加 分割任务产出id
|
ALTER TABLE "production_operation_task_record" ADD COLUMN "segmentation_id" int8;
|
COMMENT ON COLUMN "public"."production_operation_task_record"."segmentation_id" IS '分割任务产出id';
|
|
|
-- 2023年4月7号
|
--产出表表增加 盘具尺寸
|
ALTER TABLE "production_product_output" ADD COLUMN "disc_tool_measurement" varchar(100);
|
COMMENT ON COLUMN "public"."production_product_output"."disc_tool_measurement" IS '盘具尺寸';
|
|
|
-- 2023年4月10号
|
--馈线合格证表增加 零件族群编号
|
ALTER TABLE "production_feeder_certificate" ADD COLUMN "part_family_no" varchar(100);
|
COMMENT ON COLUMN "public"."production_feeder_certificate"."part_family_no" IS '零件族编号';
|
|
-- 2023年3月30号
|
--不合格处理基础信息配置表
|
|
CREATE SEQUENCE "public"."quality_unqualified_configuration_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
|
CREATE TABLE "public"."quality_unqualified_configuration"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('quality_unqualified_configuration_id_seq'::regclass),
|
"work_shop" varchar(50) COLLATE "pg_catalog"."default",
|
"type" varchar(50) COLLATE "pg_catalog"."default",
|
"process_mode" varchar(50) COLLATE "pg_catalog"."default",
|
"originator" varchar(255) COLLATE "pg_catalog"."default",
|
"examiner" varchar(255) COLLATE "pg_catalog"."default",
|
"handler" varchar(255) COLLATE "pg_catalog"."default",
|
"create_user" varchar(50) COLLATE "pg_catalog"."default",
|
"update_user" varchar(50) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6)
|
)
|
;
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."id" IS 'id';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."work_shop" IS '车间';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."type" IS '产品类型';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."process_mode" IS '处理方式';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."originator" IS '发起人';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."examiner" IS '审核人';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."handler" IS '处理人';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."update_user" IS '更新人';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."quality_unqualified_configuration"."update_time" IS '更新时间';
|
|
ALTER TABLE "public"."quality_unqualified_configuration"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."quality_unqualified_configuration_id_seq"
|
OWNED BY "public"."quality_unqualified_configuration"."id";
|
|
|
-- 2023年4月4号
|
--不合格处理新增字段
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "examiner" varchar(255);
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."examiner" IS '审批人';
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "examine_time" timestamp(6);
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."examine_time" IS '审批时间';
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "handler" varchar(255);
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."handler" IS '执行人';
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "handle_time" timestamp(6);
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."handle_time" IS '执行时间';
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "execute_sn" varchar(100);
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."execute_sn" IS '处理后SN号';
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "degrade_part_id" int8;
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."degrade_part_id" IS '降级后零件id';
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "examine_idea" varchar(500);
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."examine_idea" IS '评审意见';
|
ALTER TABLE "quality_unqualified_process" ADD COLUMN "loss_registration" numeric(18,6) DEFAULT 0;
|
COMMENT ON COLUMN "public"."quality_unqualified_process"."loss_registration" IS '损失登记';
|
|
-- 2023年4月12号
|
--工单表表增加 批量提交状态
|
ALTER TABLE "production_operation_task" ADD COLUMN "is_submit" BOOLEAN default false ;
|
COMMENT ON COLUMN "public"."production_operation_task"."is_submit" IS '批量提交状态';
|
|
|
-- 2023年4月12号
|
--检测标准子表 新增是否抽检
|
ALTER TABLE "quality_test_standard_param" ADD COLUMN "is_check" BOOLEAN default false;
|
COMMENT ON COLUMN "public"."quality_test_standard_param"."is_check" IS '是否抽检';
|
|
-- 2023年4月12号
|
--检测汇报项目表 新增是否抽检
|
ALTER TABLE "quality_report_sample_item" ADD COLUMN "is_check" BOOLEAN default false;
|
COMMENT ON COLUMN "public"."quality_report_sample_item"."is_check" IS '是否抽检';
|
|
|
|
|
-- 2023年4月11号
|
--新建标签元素表
|
CREATE SEQUENCE "public"."quality_label_element_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."quality_label_element"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('quality_label_element_id_seq'::regclass),
|
"item_code" varchar(255) COLLATE "pg_catalog"."default",
|
"item_desc" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
;
|
COMMENT ON COLUMN "public"."quality_label_element"."id" IS 'id';
|
COMMENT ON COLUMN "public"."quality_label_element"."item_code" IS '标签元素码';
|
COMMENT ON COLUMN "public"."quality_label_element"."item_desc" IS '标签元素描述';
|
COMMENT ON COLUMN "public"."quality_label_element"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."quality_label_element"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."quality_label_element"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."quality_label_element"."update_user" IS '更新人';
|
|
ALTER TABLE "public"."quality_label_element"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."quality_label_element_id_seq"
|
OWNED BY "public"."quality_label_element"."id";
|
|
--新建标签信息配置表
|
CREATE SEQUENCE "public"."quality_label_print_config_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."quality_label_print_config"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('quality_label_print_config_id_seq'::regclass),
|
"label_unique_code" varchar(255) COLLATE "pg_catalog"."default",
|
"label_type_code" varchar(255) COLLATE "pg_catalog"."default",
|
"label_type_desc" varchar(255) COLLATE "pg_catalog"."default",
|
"label_desc" varchar(255) COLLATE "pg_catalog"."default",
|
"label_size" varchar(255) COLLATE "pg_catalog"."default",
|
"file_name" varchar(255) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
;
|
COMMENT ON COLUMN "public"."quality_label_print_config"."id" IS 'id';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."label_unique_code" IS '标签身份码';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."label_type_code" IS '标签类别码';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."label_type_desc" IS '标签类别描述';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."label_desc" IS '标签描述';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."label_size" IS '标签尺寸';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."file_name" IS '附件';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."quality_label_print_config"."update_user" IS '更新人';
|
|
ALTER TABLE "public"."quality_label_print_config"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."quality_label_print_config_id_seq"
|
OWNED BY "public"."quality_label_print_config"."id";
|
|
--新建标签信息配置明细表
|
CREATE SEQUENCE "public"."quality_label_print_config_detail_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."quality_label_print_config_detail"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('quality_label_print_config_detail_id_seq'::regclass),
|
"mid" int8,
|
"is_active" BOOLEAN DEFAULT FALSE,
|
"is_config_data_source" BOOLEAN DEFAULT FALSE,
|
"item_code" varchar(255) COLLATE "pg_catalog"."default",
|
"caption" varchar(255) COLLATE "pg_catalog"."default",
|
"default_value" varchar(255) COLLATE "pg_catalog"."default",
|
"qry_sql" varchar(2000) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
;
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."id" IS 'id';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."mid" IS '标签打印配置表记录行id';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."is_active" IS '是否启用';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."is_config_data_source" IS '是否配置数据源';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."item_code" IS '标签元素码';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."caption" IS '标题';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."default_value" IS '默认值';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."qry_sql" IS '查询SQL，传参统一为SN，输出字段统一为value';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."quality_label_print_config_detail"."update_user" IS '更新人';
|
|
ALTER TABLE "public"."quality_label_print_config_detail"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."quality_label_print_config_detail_id_seq"
|
OWNED BY "public"."quality_label_print_config_detail"."id";
|
|
|
--新建标签表
|
CREATE SEQUENCE "public"."quality_label_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."quality_label"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('quality_label_id_seq'::regclass),
|
"label_unique_code" varchar(255) COLLATE "pg_catalog"."default",
|
"label_type_code" varchar(255) COLLATE "pg_catalog"."default",
|
"label_type_desc" varchar(255) COLLATE "pg_catalog"."default",
|
"label_desc" varchar(255) COLLATE "pg_catalog"."default",
|
"label_size" varchar(255) COLLATE "pg_catalog"."default",
|
"part_batch_no" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_batch_no" varchar(255) COLLATE "pg_catalog"."default",
|
"wdr" varchar(255) COLLATE "pg_catalog"."default",
|
"part_no" varchar(255) COLLATE "pg_catalog"."default",
|
"qty" numeric(18,6) DEFAULT 0,
|
"label_info" varchar(4000) COLLATE "pg_catalog"."default",
|
"print_count" int8 default 0,
|
"active" BOOLEAN DEFAULT TRUE,
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
;
|
COMMENT ON COLUMN "public"."quality_label"."id" IS 'id';
|
COMMENT ON COLUMN "public"."quality_label"."label_unique_code" IS '标签身份码';
|
COMMENT ON COLUMN "public"."quality_label"."label_type_code" IS '标签类别码';
|
COMMENT ON COLUMN "public"."quality_label"."label_type_desc" IS '标签类别描述';
|
COMMENT ON COLUMN "public"."quality_label"."label_desc" IS '标签描述';
|
COMMENT ON COLUMN "public"."quality_label"."label_size" IS '标签尺寸';
|
COMMENT ON COLUMN "public"."quality_label"."part_batch_no" IS 'SN号';
|
COMMENT ON COLUMN "public"."quality_label"."ifs_batch_no" IS 'ifs批次号';
|
COMMENT ON COLUMN "public"."quality_label"."wdr" IS 'wdr';
|
COMMENT ON COLUMN "public"."quality_label"."part_no" IS '零件号';
|
COMMENT ON COLUMN "public"."quality_label"."qty" IS '数量';
|
COMMENT ON COLUMN "public"."quality_label"."label_info" IS 'JSON格式的标签信息';
|
COMMENT ON COLUMN "public"."quality_label"."print_count" IS '打印次数';
|
COMMENT ON COLUMN "public"."quality_label"."active" IS '软删除';
|
COMMENT ON COLUMN "public"."quality_label"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."quality_label"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."quality_label"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."quality_label"."update_user" IS '更新人';
|
|
ALTER TABLE "public"."quality_label"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."quality_label_id_seq"
|
OWNED BY "public"."quality_label"."id";
|
|
|
--新建标签打印日志表
|
CREATE SEQUENCE "public"."quality_label_print_log_id_seq"
|
INCREMENT 1
|
MINVALUE 1
|
MAXVALUE 9223372036854775807
|
START 1
|
CACHE 1;
|
|
CREATE TABLE "public"."quality_label_print_log"
|
(
|
"id" int8 NOT NULL DEFAULT nextval('quality_label_print_log_id_seq'::regclass),
|
"mid" int8,
|
"part_batch_no" varchar(255) COLLATE "pg_catalog"."default",
|
"ifs_batch_no" varchar(255) COLLATE "pg_catalog"."default",
|
"wdr" varchar(255) COLLATE "pg_catalog"."default",
|
"part_no" varchar(255) COLLATE "pg_catalog"."default",
|
"qty" numeric(18,6) DEFAULT 0,
|
"label_info" varchar(4000) COLLATE "pg_catalog"."default",
|
"create_time" timestamp(6),
|
"update_time" timestamp(6),
|
"create_user" varchar(255) COLLATE "pg_catalog"."default",
|
"update_user" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
;
|
COMMENT ON COLUMN "public"."quality_label_print_log"."id" IS 'id';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."mid" IS '标签表记录行id';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."part_batch_no" IS 'SN号';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."ifs_batch_no" IS 'ifs批次号';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."wdr" IS 'wdr';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."part_no" IS '零件号';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."qty" IS '数量';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."label_info" IS 'JSON格式的合格证信息';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."create_time" IS '创建时间';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."update_time" IS '更新时间';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."create_user" IS '创建人';
|
COMMENT ON COLUMN "public"."quality_label_print_log"."update_user" IS '更新人';
|
|
ALTER TABLE "public"."quality_label_print_log"
|
OWNER TO "postgres";
|
|
ALTER SEQUENCE "public"."quality_label_print_log_id_seq"
|
OWNED BY "public"."quality_label_print_log"."id";
|
|
|
-- 2023年4月25号
|
--制造订单-检测标准参数 新增是否抽检
|
ALTER TABLE "plan_mo_test_standard_param" ADD COLUMN "is_check" BOOLEAN default false;
|
COMMENT ON COLUMN "public"."plan_mo_test_standard_param"."is_check" IS '是否抽检';
|
|
-- 2023年4月25号
|
--工艺文件检测参数明细表 新增是否抽检
|
ALTER TABLE "technology_document_standard_param" ADD COLUMN "is_check" BOOLEAN default false;
|
COMMENT ON COLUMN "public"."technology_document_standard_param"."is_check" IS '是否抽检';
|
