-- ----------------------------
|
-- MES 排班计划
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_cal_plan" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"name" varchar(255) DEFAULT NULL,
|
"calendar_type" tinyint DEFAULT NULL,
|
"start_date" timestamp DEFAULT NULL,
|
"end_date" timestamp DEFAULT NULL,
|
"shift_type" tinyint DEFAULT NULL,
|
"shift_method" tinyint DEFAULT NULL,
|
"shift_count" int DEFAULT NULL,
|
"status" tinyint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 排班计划班次
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_cal_plan_shift" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"plan_id" bigint DEFAULT NULL,
|
"sort" int DEFAULT NULL,
|
"name" varchar(64) DEFAULT NULL,
|
"start_time" varchar(10) DEFAULT NULL,
|
"end_time" varchar(10) DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 排班计划班组
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_cal_plan_team" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"plan_id" bigint DEFAULT NULL,
|
"team_id" bigint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 班组排班
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_cal_team_shift" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"plan_id" bigint DEFAULT NULL,
|
"team_id" bigint DEFAULT NULL,
|
"shift_id" bigint DEFAULT NULL,
|
"day" timestamp DEFAULT NULL,
|
"sort" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 编码规则表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_md_auto_code_rule" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) NOT NULL,
|
"name" varchar(64) NOT NULL,
|
"description" varchar(255) DEFAULT NULL,
|
"max_length" int DEFAULT NULL,
|
"padded" bit NOT NULL DEFAULT FALSE,
|
"padded_char" varchar(1) DEFAULT NULL,
|
"padded_method" tinyint DEFAULT NULL,
|
"status" tinyint NOT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 编码规则组成表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_md_auto_code_part" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"rule_id" bigint NOT NULL,
|
"sort" int NOT NULL,
|
"type" tinyint NOT NULL,
|
"length" int NOT NULL,
|
"date_format" varchar(20) DEFAULT NULL,
|
"fix_character" varchar(64) DEFAULT NULL,
|
"serial_start_no" int DEFAULT NULL,
|
"serial_step" int DEFAULT NULL,
|
"cycle_flag" bit DEFAULT FALSE,
|
"cycle_method" tinyint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 编码生成记录表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_md_auto_code_record" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"rule_id" bigint NOT NULL,
|
"result" varchar(64) DEFAULT NULL,
|
"serial_no" bigint DEFAULT NULL,
|
"input_char" varchar(64) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 到货通知单
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_arrival_notice" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"name" varchar(255) DEFAULT NULL,
|
"purchase_order_code" varchar(64) DEFAULT NULL,
|
"vendor_id" bigint DEFAULT NULL,
|
"arrival_date" timestamp DEFAULT NULL,
|
"contact_name" varchar(64) DEFAULT NULL,
|
"contact_telephone" varchar(64) DEFAULT NULL,
|
"status" tinyint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 外协入库单
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_outsource_receipt" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"name" varchar(255) DEFAULT NULL,
|
"work_order_id" bigint DEFAULT NULL,
|
"vendor_id" bigint DEFAULT NULL,
|
"receipt_date" timestamp DEFAULT NULL,
|
"status" tinyint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 来料检验单（IQC）
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_qc_iqc" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"name" varchar(255) DEFAULT NULL,
|
"template_id" bigint DEFAULT NULL,
|
"source_doc_type" int DEFAULT NULL,
|
"source_doc_id" bigint DEFAULT NULL,
|
"source_line_id" bigint DEFAULT NULL,
|
"source_doc_code" varchar(64) DEFAULT NULL,
|
"vendor_id" bigint DEFAULT NULL,
|
"vendor_batch" varchar(64) DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"received_quantity" decimal(24,6) DEFAULT NULL,
|
"check_quantity" decimal(24,6) DEFAULT NULL,
|
"qualified_quantity" decimal(24,6) DEFAULT NULL,
|
"unqualified_quantity" decimal(24,6) DEFAULT NULL,
|
"critical_rate" decimal(10,2) DEFAULT NULL,
|
"major_rate" decimal(10,2) DEFAULT NULL,
|
"minor_rate" decimal(10,2) DEFAULT NULL,
|
"critical_quantity" int DEFAULT NULL,
|
"major_quantity" int DEFAULT NULL,
|
"minor_quantity" int DEFAULT NULL,
|
"check_result" tinyint DEFAULT NULL,
|
"receive_date" timestamp DEFAULT NULL,
|
"inspect_date" timestamp DEFAULT NULL,
|
"inspector_user_id" bigint DEFAULT NULL,
|
"status" tinyint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 过程检验单（IPQC）
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_qc_ipqc" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"name" varchar(500) DEFAULT NULL,
|
"type" tinyint DEFAULT NULL,
|
"template_id" bigint DEFAULT NULL,
|
"source_doc_type" int DEFAULT NULL,
|
"source_doc_id" bigint DEFAULT NULL,
|
"source_line_id" bigint DEFAULT NULL,
|
"source_doc_code" varchar(64) DEFAULT NULL,
|
"work_order_id" bigint DEFAULT NULL,
|
"task_id" bigint DEFAULT NULL,
|
"workstation_id" bigint DEFAULT NULL,
|
"process_id" bigint DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"check_quantity" decimal(14,2) DEFAULT NULL,
|
"qualified_quantity" decimal(14,2) DEFAULT NULL,
|
"unqualified_quantity" decimal(14,2) DEFAULT NULL,
|
"labor_scrap_quantity" decimal(14,2) DEFAULT NULL,
|
"material_scrap_quantity" decimal(14,2) DEFAULT NULL,
|
"other_scrap_quantity" decimal(14,2) DEFAULT NULL,
|
"critical_rate" decimal(14,2) DEFAULT NULL,
|
"major_rate" decimal(14,2) DEFAULT NULL,
|
"minor_rate" decimal(14,2) DEFAULT NULL,
|
"critical_quantity" int DEFAULT NULL,
|
"major_quantity" int DEFAULT NULL,
|
"minor_quantity" int DEFAULT NULL,
|
"check_result" tinyint DEFAULT NULL,
|
"inspect_date" timestamp DEFAULT NULL,
|
"inspector_user_id" bigint DEFAULT NULL,
|
"status" tinyint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 生产报工
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_pro_feedback" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"type" tinyint DEFAULT NULL,
|
"channel" varchar(64) DEFAULT NULL,
|
"feedback_time" timestamp DEFAULT NULL,
|
"workstation_id" bigint DEFAULT NULL,
|
"route_id" bigint DEFAULT NULL,
|
"process_id" bigint DEFAULT NULL,
|
"work_order_id" bigint DEFAULT NULL,
|
"task_id" bigint DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"expire_date" timestamp DEFAULT NULL,
|
"lot_number" varchar(64) DEFAULT NULL,
|
"scheduled_quantity" decimal(14,2) DEFAULT NULL,
|
"feedback_quantity" decimal(14,2) DEFAULT NULL,
|
"qualified_quantity" decimal(14,2) DEFAULT NULL,
|
"unqualified_quantity" decimal(14,2) DEFAULT NULL,
|
"uncheck_quantity" decimal(14,2) DEFAULT NULL,
|
"labor_scrap_quantity" decimal(14,2) DEFAULT NULL,
|
"material_scrap_quantity" decimal(14,2) DEFAULT NULL,
|
"other_scrap_quantity" decimal(14,2) DEFAULT NULL,
|
"feedback_user_id" bigint DEFAULT NULL,
|
"approve_user_id" bigint DEFAULT NULL,
|
"status" tinyint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 生产入库单主表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_product_produce" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"work_order_id" bigint DEFAULT NULL,
|
"feedback_id" bigint DEFAULT NULL,
|
"task_id" bigint DEFAULT NULL,
|
"workstation_id" bigint DEFAULT NULL,
|
"process_id" bigint DEFAULT NULL,
|
"produce_date" timestamp DEFAULT NULL,
|
"status" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 生产入库单行表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_product_produce_line" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"produce_id" bigint DEFAULT NULL,
|
"feedback_id" bigint DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"quantity" decimal(12,2) DEFAULT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"expire_date" timestamp DEFAULT NULL,
|
"lot_number" varchar(128) DEFAULT NULL,
|
"quality_status" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 生产入库明细表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_product_produce_detail" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"produce_id" bigint DEFAULT NULL,
|
"line_id" bigint DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"quantity" decimal(12,2) DEFAULT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"warehouse_id" bigint DEFAULT NULL,
|
"location_id" bigint DEFAULT NULL,
|
"area_id" bigint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 出货检验单（OQC）
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_qc_oqc" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) NOT NULL,
|
"name" varchar(500) NOT NULL,
|
"template_id" bigint NOT NULL,
|
"source_doc_type" int DEFAULT NULL,
|
"source_doc_id" bigint DEFAULT NULL,
|
"source_line_id" bigint DEFAULT NULL,
|
"source_doc_code" varchar(64) DEFAULT NULL,
|
"client_id" bigint NOT NULL,
|
"batch_code" varchar(64) DEFAULT NULL,
|
"item_id" bigint NOT NULL,
|
"min_check_quantity" int DEFAULT 1,
|
"max_unqualified_quantity" int DEFAULT 0,
|
"out_quantity" decimal(14,2) NOT NULL,
|
"check_quantity" decimal(14,2) DEFAULT NULL,
|
"qualified_quantity" decimal(14,2) DEFAULT 0.00,
|
"unqualified_quantity" decimal(14,2) DEFAULT 0.00,
|
"critical_rate" decimal(14,2) DEFAULT 0.00,
|
"major_rate" decimal(14,2) DEFAULT 0.00,
|
"minor_rate" decimal(14,2) DEFAULT 0.00,
|
"critical_quantity" int DEFAULT 0,
|
"major_quantity" int DEFAULT 0,
|
"minor_quantity" int DEFAULT 0,
|
"check_result" tinyint DEFAULT NULL,
|
"out_date" timestamp DEFAULT NULL,
|
"inspect_date" timestamp DEFAULT NULL,
|
"inspector_user_id" bigint DEFAULT NULL,
|
"status" tinyint NOT NULL DEFAULT 0,
|
"remark" varchar(500) DEFAULT '',
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 退货检验单（RQC）
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_qc_rqc" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) NOT NULL,
|
"name" varchar(500) NOT NULL,
|
"template_id" bigint NOT NULL,
|
"source_doc_type" int DEFAULT NULL,
|
"source_doc_id" bigint DEFAULT NULL,
|
"source_line_id" bigint DEFAULT NULL,
|
"source_doc_code" varchar(64) DEFAULT NULL,
|
"type" int DEFAULT NULL,
|
"item_id" bigint NOT NULL,
|
"batch_code" varchar(128) DEFAULT NULL,
|
"check_quantity" decimal(14,2) DEFAULT NULL,
|
"qualified_quantity" decimal(14,2) DEFAULT 0.00,
|
"unqualified_quantity" decimal(14,2) DEFAULT 0.00,
|
"critical_rate" decimal(14,2) DEFAULT 0.00,
|
"major_rate" decimal(14,2) DEFAULT 0.00,
|
"minor_rate" decimal(14,2) DEFAULT 0.00,
|
"critical_quantity" int DEFAULT 0,
|
"major_quantity" int DEFAULT 0,
|
"minor_quantity" int DEFAULT 0,
|
"check_result" tinyint DEFAULT NULL,
|
"inspect_date" timestamp DEFAULT NULL,
|
"inspector_user_id" bigint DEFAULT NULL,
|
"status" tinyint NOT NULL DEFAULT 0,
|
"remark" varchar(500) DEFAULT '',
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 销售出库单行
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_product_sales_line" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"sales_id" bigint NOT NULL,
|
"notice_line_id" bigint DEFAULT NULL,
|
"item_id" bigint NOT NULL,
|
"quantity" decimal(20,6) NOT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"material_stock_id" bigint DEFAULT NULL,
|
"oqc_check_flag" tinyint DEFAULT NULL,
|
"oqc_id" bigint DEFAULT NULL,
|
"quality_status" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 生产退料单行
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_return_issue_line" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"issue_id" bigint NOT NULL,
|
"material_stock_id" bigint DEFAULT NULL,
|
"item_id" bigint NOT NULL,
|
"quantity" decimal(12,2) NOT NULL DEFAULT 0.00,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"rqc_id" bigint DEFAULT NULL,
|
"rqc_check_flag" bit NOT NULL DEFAULT FALSE,
|
"quality_status" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT '',
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 销售退货单行
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_return_sales_line" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"return_id" bigint NOT NULL,
|
"item_id" bigint NOT NULL,
|
"quantity" decimal(12,2) NOT NULL DEFAULT 0.00,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"rqc_id" bigint DEFAULT NULL,
|
"rqc_check_flag" bit NOT NULL DEFAULT FALSE,
|
"quality_status" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT '',
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 采购入库单
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_item_receipt" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) NOT NULL,
|
"name" varchar(255) DEFAULT NULL,
|
"iqc_id" bigint DEFAULT NULL,
|
"notice_id" bigint DEFAULT NULL,
|
"vendor_id" bigint DEFAULT NULL,
|
"purchase_order_code" varchar(64) DEFAULT NULL,
|
"receipt_date" timestamp DEFAULT NULL,
|
"status" tinyint NOT NULL DEFAULT 0,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 采购入库单行
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_item_receipt_line" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"receipt_id" bigint NOT NULL,
|
"arrival_notice_line_id" bigint DEFAULT NULL,
|
"item_id" bigint NOT NULL,
|
"received_quantity" decimal(14,2) DEFAULT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"production_date" timestamp DEFAULT NULL,
|
"expire_date" timestamp DEFAULT NULL,
|
"lot_number" varchar(128) DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 采购入库明细
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_item_receipt_detail" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"line_id" bigint NOT NULL,
|
"receipt_id" bigint NOT NULL,
|
"item_id" bigint NOT NULL,
|
"quantity" decimal(14,2) DEFAULT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"warehouse_id" bigint DEFAULT NULL,
|
"location_id" bigint DEFAULT NULL,
|
"area_id" bigint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 物料消耗记录表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_item_consume" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"work_order_id" bigint NOT NULL,
|
"task_id" bigint NOT NULL,
|
"workstation_id" bigint NOT NULL,
|
"process_id" bigint NOT NULL,
|
"feedback_id" bigint NOT NULL,
|
"consume_date" timestamp NOT NULL,
|
"status" tinyint NOT NULL DEFAULT 0,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 物料消耗记录行表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_item_consume_line" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"consume_id" bigint NOT NULL,
|
"item_id" bigint NOT NULL,
|
"quantity" decimal(14,2) NOT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(128) DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 物料消耗记录明细表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_item_consume_detail" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"consume_id" bigint NOT NULL,
|
"line_id" bigint NOT NULL,
|
"material_stock_id" bigint DEFAULT NULL,
|
"item_id" bigint NOT NULL,
|
"quantity" decimal(14,2) NOT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(128) DEFAULT NULL,
|
"warehouse_id" bigint NOT NULL,
|
"location_id" bigint NOT NULL,
|
"area_id" bigint NOT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 批次记录表
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_batch" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(128) DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"produce_date" timestamp DEFAULT NULL,
|
"expire_date" timestamp DEFAULT NULL,
|
"receipt_date" timestamp DEFAULT NULL,
|
"vendor_id" bigint DEFAULT NULL,
|
"client_id" bigint DEFAULT NULL,
|
"sales_order_code" varchar(64) DEFAULT NULL,
|
"purchase_order_code" varchar(64) DEFAULT NULL,
|
"work_order_id" bigint DEFAULT NULL,
|
"task_id" bigint DEFAULT NULL,
|
"workstation_id" bigint DEFAULT NULL,
|
"tool_id" bigint DEFAULT NULL,
|
"mold_id" bigint DEFAULT NULL,
|
"lot_number" varchar(128) DEFAULT NULL,
|
"quality_status" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 库存台账
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_material_stock" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"item_type_id" bigint DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"warehouse_id" bigint DEFAULT NULL,
|
"location_id" bigint DEFAULT NULL,
|
"area_id" bigint DEFAULT NULL,
|
"vendor_id" bigint DEFAULT NULL,
|
"quantity" decimal(14,2) DEFAULT NULL,
|
"receipt_time" timestamp DEFAULT NULL,
|
"frozen" bit DEFAULT FALSE,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 生产任务
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_pro_task" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"name" varchar(255) DEFAULT NULL,
|
"work_order_id" bigint DEFAULT NULL,
|
"workstation_id" bigint DEFAULT NULL,
|
"route_id" bigint DEFAULT NULL,
|
"process_id" bigint DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"quantity" decimal(14,2) DEFAULT NULL,
|
"produced_quantity" decimal(14,2) DEFAULT NULL,
|
"qualify_quantity" decimal(14,2) DEFAULT NULL,
|
"unqualify_quantity" decimal(14,2) DEFAULT NULL,
|
"changed_quantity" decimal(14,2) DEFAULT NULL,
|
"client_id" bigint DEFAULT NULL,
|
"start_time" timestamp DEFAULT NULL,
|
"duration" int DEFAULT NULL,
|
"end_time" timestamp DEFAULT NULL,
|
"color_code" varchar(20) DEFAULT NULL,
|
"finish_date" timestamp DEFAULT NULL,
|
"cancel_date" timestamp DEFAULT NULL,
|
"status" int DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 工艺路线工序
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_pro_route_process" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"route_id" bigint DEFAULT NULL,
|
"process_id" bigint DEFAULT NULL,
|
"sort" int DEFAULT NULL,
|
"next_process_id" bigint DEFAULT NULL,
|
"link_type" int DEFAULT NULL,
|
"prepare_time" int DEFAULT NULL,
|
"wait_time" int DEFAULT NULL,
|
"color_code" varchar(20) DEFAULT NULL,
|
"key_flag" bit DEFAULT FALSE,
|
"check_flag" bit DEFAULT FALSE,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 销售出库明细
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_wm_product_sales_detail" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"line_id" bigint NOT NULL,
|
"sales_id" bigint NOT NULL,
|
"item_id" bigint NOT NULL,
|
"quantity" decimal(14,2) DEFAULT NULL,
|
"material_stock_id" bigint DEFAULT NULL,
|
"batch_id" bigint DEFAULT NULL,
|
"batch_code" varchar(255) DEFAULT NULL,
|
"warehouse_id" bigint DEFAULT NULL,
|
"location_id" bigint DEFAULT NULL,
|
"area_id" bigint DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
|
-- ----------------------------
|
-- MES 检验结果记录
|
-- ----------------------------
|
CREATE TABLE IF NOT EXISTS "mes_qc_indicator_result" (
|
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
|
"code" varchar(64) DEFAULT NULL,
|
"qc_id" bigint DEFAULT NULL,
|
"qc_type" int DEFAULT NULL,
|
"item_id" bigint DEFAULT NULL,
|
"sn" varchar(128) DEFAULT NULL,
|
"remark" varchar(500) DEFAULT NULL,
|
"creator" varchar(64) DEFAULT '',
|
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"updater" varchar(64) DEFAULT '',
|
"update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
"deleted" bit NOT NULL DEFAULT FALSE,
|
"tenant_id" bigint NOT NULL DEFAULT 0,
|
PRIMARY KEY ("id")
|
);
|
