| | |
| | | ); |
| | | |
| | | -- ---------------------------- |
| | | -- MES 质检审核人配置 |
| | | -- ---------------------------- |
| | | CREATE TABLE IF NOT EXISTS "mes_qc_approver_config" ( |
| | | "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, |
| | | "qc_type" tinyint NOT NULL, |
| | | "approve_node" tinyint NOT NULL, |
| | | "user_id" bigint NOT NULL, |
| | | "status" tinyint NOT NULL DEFAULT 0, |
| | | "remark" varchar(255) 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 退货检验单(RQC) |
| | | -- ---------------------------- |
| | | CREATE TABLE IF NOT EXISTS "mes_qc_rqc" ( |