From 0f8f4c5de1d817aa87c4c79e966d3cfbd0997aeb Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期三, 23 七月 2025 16:55:56 +0800 Subject: [PATCH] 1.设备领用添加记录 2.采购添加运费 --- main-business/src/main/resources/db/migration/postgresql/V20250707155600__create_table_equipment_usage_record.sql | 76 +++++++++++++++++++++++-------------- 1 files changed, 47 insertions(+), 29 deletions(-) diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250707155600__create_table_equipment_usage_record.sql b/main-business/src/main/resources/db/migration/postgresql/V20250707155600__create_table_equipment_usage_record.sql index af01796..d67ea18 100644 --- a/main-business/src/main/resources/db/migration/postgresql/V20250707155600__create_table_equipment_usage_record.sql +++ b/main-business/src/main/resources/db/migration/postgresql/V20250707155600__create_table_equipment_usage_record.sql @@ -1,39 +1,57 @@ -- 鍒涘缓璁惧浣跨敤璁板綍琛� equipment_usage_record CREATE TABLE equipment_usage_record ( -id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 - equipment_id BIGINT NOT NULL, -- 璁惧ID锛屽叧鑱旇澶囦俊鎭〃锛屼笉鍏佽涓虹┖ - usage_quantity INT NOT NULL, -- 浣跨敤鏁伴噺锛屼笉鍏佽涓虹┖ - user_id BIGINT NOT NULL, -- 浣跨敤浜篒D锛屽叧鑱旂敤鎴疯〃锛屼笉鍏佽涓虹┖ - department_id BIGINT , -- 閮ㄩ棬ID锛屽叧鑱旈儴闂ㄨ〃锛屼笉鍏佽涓虹┖ - equipment_status BIGINT NOT NULL, -- 璁惧鐘舵��:1.浣跨敤涓� 2.宸插綊杩� - usage_start_time TIMESTAMP NOT NULL, -- 浣跨敤寮�濮嬫椂闂达紝涓嶅厑璁镐负绌� - usage_end_time TIMESTAMP, -- 浣跨敤缁撴潫鏃堕棿锛屽彲涓虹┖锛堟湭褰掕繕鏃讹級 - remarks VARCHAR(1000), -- 澶囨敞淇℃伅锛屽彲涓虹┖ + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 + equipment_id BIGINT NOT NULL, -- 璁惧ID锛屽叧鑱旇澶囦俊鎭〃锛屼笉鍏佽涓虹┖ + usage_quantity INT NOT NULL, -- 棰嗙敤鏁伴噺锛屼笉鍏佽涓虹┖ + return_quantity INT, -- 褰掕繕鏁伴噺 + user_id BIGINT NOT NULL, -- 浣跨敤浜篒D锛屽叧鑱旂敤鎴疯〃锛屼笉鍏佽涓虹┖ + department_id BIGINT, -- 閮ㄩ棬ID锛屽叧鑱旈儴闂ㄨ〃锛屼笉鍏佽涓虹┖ + equipment_status BIGINT NOT NULL, -- 璁惧鐘舵��:1.浣跨敤涓� 2.宸插綊杩� + usage_start_time TIMESTAMP NOT NULL, -- 浣跨敤寮�濮嬫椂闂达紝涓嶅厑璁镐负绌� + usage_end_time TIMESTAMP, -- 浣跨敤缁撴潫鏃堕棿锛屽彲涓虹┖锛堟湭褰掕繕鏃讹級 + remarks VARCHAR(1000), -- 澶囨敞淇℃伅锛屽彲涓虹┖ - deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� - create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕 - create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� - update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚� - update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂� + deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� + create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕 + create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� + update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚� + update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂� ); -- 涓鸿〃娣诲姞娉ㄩ噴 -COMMENT ON TABLE equipment_usage_record IS '璁惧浣跨敤璁板綍琛�'; +COMMENT +ON TABLE equipment_usage_record IS '璁惧浣跨敤璁板綍琛�'; -- 涓哄瓧娈垫坊鍔犳敞閲� -COMMENT ON COLUMN equipment_usage_record.id IS '涓婚敭ID'; -COMMENT ON COLUMN equipment_usage_record.equipment_id IS '璁惧ID'; -COMMENT ON COLUMN equipment_usage_record.usage_quantity IS '浣跨敤鏁伴噺'; -COMMENT ON COLUMN equipment_usage_record.user_id IS '浣跨敤浜篒D'; -COMMENT ON COLUMN equipment_usage_record.department_id IS '閮ㄩ棬ID'; -COMMENT ON COLUMN equipment_usage_record.equipment_status IS '璁惧鐘舵��:1.浣跨敤涓� 2.宸插綊杩�'; -COMMENT ON COLUMN equipment_usage_record.usage_start_time IS '浣跨敤寮�濮嬫椂闂�'; -COMMENT ON COLUMN equipment_usage_record.usage_end_time IS '浣跨敤缁撴潫鏃堕棿'; -COMMENT ON COLUMN equipment_usage_record.remarks IS '澶囨敞淇℃伅'; +COMMENT +ON COLUMN equipment_usage_record.id IS '涓婚敭ID'; +COMMENT +ON COLUMN equipment_usage_record.equipment_id IS '璁惧ID'; +COMMENT +ON COLUMN equipment_usage_record.usage_quantity IS '棰嗙敤鏁伴噺'; +COMMENT +ON COLUMN equipment_usage_record.return_quantity IS '褰掕繕鏁伴噺'; +COMMENT +ON COLUMN equipment_usage_record.user_id IS '浣跨敤浜篒D'; +COMMENT +ON COLUMN equipment_usage_record.department_id IS '閮ㄩ棬ID'; +COMMENT +ON COLUMN equipment_usage_record.equipment_status IS '璁惧鐘舵��:1.浣跨敤涓� 2.宸插綊杩�'; +COMMENT +ON COLUMN equipment_usage_record.usage_start_time IS '浣跨敤寮�濮嬫椂闂�'; +COMMENT +ON COLUMN equipment_usage_record.usage_end_time IS '浣跨敤缁撴潫鏃堕棿'; +COMMENT +ON COLUMN equipment_usage_record.remarks IS '澶囨敞淇℃伅'; -COMMENT ON COLUMN equipment_usage_record.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�'; -COMMENT ON COLUMN equipment_usage_record.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; -COMMENT ON COLUMN equipment_usage_record.create_time IS '璁板綍鍒涘缓鏃堕棿'; -COMMENT ON COLUMN equipment_usage_record.update_by IS '鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴�'; -COMMENT ON COLUMN equipment_usage_record.update_time IS '璁板綍鏈�鍚庢洿鏂版椂闂�'; \ No newline at end of file +COMMENT +ON COLUMN equipment_usage_record.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�'; +COMMENT +ON COLUMN equipment_usage_record.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; +COMMENT +ON COLUMN equipment_usage_record.create_time IS '璁板綍鍒涘缓鏃堕棿'; +COMMENT +ON COLUMN equipment_usage_record.update_by IS '鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴�'; +COMMENT +ON COLUMN equipment_usage_record.update_time IS '璁板綍鏈�鍚庢洿鏂版椂闂�'; \ No newline at end of file -- Gitblit v1.9.3