zd-after.git - Gitblit

			@@ -3,7 +3,6 @@
			(
			id BIGSERIAL PRIMARY KEY, -- 主键ID
			supplier_name VARCHAR(255) NOT NULL, -- 供货商名称
			coal VARCHAR(50) NOT NULL, -- 煤种
			unit VARCHAR(50) NOT NULL, -- 单位
			inventory_quantity NUMERIC(10, 2) NOT NULL, -- 库存数量
			price_including_tax NUMERIC(10, 2) NOT NULL, -- 单价（含税）
			@@ -12,11 +11,13 @@
			registration_time TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP, -- 登记时间
			price_excluding_tax VARCHAR(255), -- 单价（不含税）
			total_price_excluding_tax VARCHAR(255), -- 总价（不含税）
			registrant_id VARCHAR(32), -- 登记人ID
			registrant_id BIGINT, -- 登记人ID
			registration_date DATE, -- 登记日期
			supplier_id BIGINT, -- 供货商ID
			coal_id BIGINT, -- 煤种ID
			master_id BIGINT, -- 生产加工id
			purchase_id BIGINT, -- 采购id
			coal_plan_id BIGINT, -- 煤质方案id

			deleted INTEGER DEFAULT 0, -- 软删除标志，0=未删除，1=已删除
			create_by VARCHAR(255), -- 创建该记录的用户
			@@ -31,7 +32,6 @@
			-- 字段注释
			COMMENT ON COLUMN pending_inventory.id IS '主键ID';
			COMMENT ON COLUMN pending_inventory.supplier_name IS '供货商名称';
			COMMENT ON COLUMN pending_inventory.coal IS '煤种';
			COMMENT ON COLUMN pending_inventory.unit IS '单位';
			COMMENT ON COLUMN pending_inventory.inventory_quantity IS '库存数量';
			COMMENT ON COLUMN pending_inventory.price_including_tax IS '单价（含税）';
			@@ -45,6 +45,8 @@
			COMMENT ON COLUMN pending_inventory.supplier_id IS '供货商ID';
			COMMENT ON COLUMN pending_inventory.coal_id IS '煤种ID';
			COMMENT ON COLUMN pending_inventory.master_id IS '生产加工id';
			COMMENT ON COLUMN pending_inventory.purchase_id IS '采购id';
			COMMENT ON COLUMN pending_inventory.coal_plan_id IS '煤质方案id';

			COMMENT ON COLUMN pending_inventory.deleted IS '软删除标志，0=未删除，1=已删除';
			COMMENT ON COLUMN pending_inventory.create_by IS '创建该记录的用户';