From d346846239a8a39246c464dc634f5fd72add99ab Mon Sep 17 00:00:00 2001 From: maven <2163098428@qq.com> Date: 星期二, 26 八月 2025 15:22:15 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/pim-jlmy' into pim-jlmy --- main-business/src/main/resources/db/migration/postgresql/V20250825111200__create_table_production_scheduling.sql | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 59 insertions(+), 0 deletions(-) diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250825111200__create_table_production_scheduling.sql b/main-business/src/main/resources/db/migration/postgresql/V20250825111200__create_table_production_scheduling.sql new file mode 100644 index 0000000..70cbfd0 --- /dev/null +++ b/main-business/src/main/resources/db/migration/postgresql/V20250825111200__create_table_production_scheduling.sql @@ -0,0 +1,59 @@ +-- 鍒涘缓姝ｅ紡搴撹〃 +CREATE TABLE production_scheduling +( + id BIGSERIAL PRIMARY KEY, -- BIGSERIAL 瀵瑰簲 int8 + production_id int8 NOT NULL DEFAULT 0, + coal_id BIGINT NOT NULL DEFAULT 0, -- 鐓ょID + scheduling_num numeric(10,2), + type int8, + status int8, + unit varchar(50), + process varchar(50) NOT NULL, + work_hours numeric(10,2) NOT NULL, + scheduling_date date, + scheduling_user_id int8, + scheduling_user_name varchar(50), + deleted int4 NOT NULL DEFAULT 0, + create_by varchar(255) COLLATE "pg_catalog"."default", + create_time timestamp(6), + update_by varchar(255) COLLATE "pg_catalog"."default", + success_num int8 DEFAULT 0, + update_time timestamp(6) +); + +COMMENT ON COLUMN "production_scheduling"."id" IS '涓婚敭ID'; + +COMMENT ON COLUMN "production_scheduling"."production_id" IS '鐢熶骇鏄庣粏id'; +COMMENT ON COLUMN production_scheduling.coal_id IS '鐓ょID'; + +COMMENT ON COLUMN "production_scheduling"."scheduling_num" IS '鎺掍骇鏁伴噺'; + +COMMENT ON COLUMN "production_scheduling"."unit" IS '鍗曚綅'; + +COMMENT ON COLUMN "production_scheduling"."process" IS '宸ュ簭锛堝瓧鍏革級'; + +COMMENT ON COLUMN "production_scheduling"."work_hours" IS '宸ユ椂瀹氶'; + +COMMENT ON COLUMN "production_scheduling"."scheduling_date" IS '鎺掍骇鏃ユ湡'; + +COMMENT ON COLUMN "production_scheduling"."scheduling_user_id" IS '鎺掍骇浜篿d'; + +COMMENT ON COLUMN "production_scheduling"."scheduling_user_name" IS '鎺掍骇浜哄悕绉�'; + + +COMMENT ON COLUMN "production_scheduling"."deleted" IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�'; + +COMMENT ON COLUMN "production_scheduling"."create_by" IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; + +COMMENT ON COLUMN "production_scheduling"."create_time" IS '璁板綍鍒涘缓鏃堕棿'; +COMMENT ON COLUMN "production_scheduling"."production_scheduling"."update_by" IS '鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴�'; + +COMMENT ON COLUMN "production_scheduling"."production_scheduling"."update_time" IS '璁板綍鏈�鍚庢洿鏂版椂闂�'; + +COMMENT ON COLUMN "production_scheduling"."production_scheduling"."type" IS '鐓ゆ枡绫诲瀷锛�1-鎴愬搧 2-鍘熸枡锛�'; + +COMMENT ON COLUMN "production_scheduling"."production_scheduling"."status" IS '鐘舵�侊紙1-寰呯敓浜� 2-鐢熶骇涓� 3-宸叉姤宸ワ級'; +COMMENT ON COLUMN "production_scheduling"."production_scheduling"."success_num" IS '鍏ュ簱鏁伴噺'; + + +COMMENT ON TABLE "public"."production_scheduling" IS '鐢熶骇鎶ュ伐琛�'; \ No newline at end of file -- Gitblit v1.9.3