-- 创建生产明细表
|
CREATE TABLE production
|
(
|
id BIGSERIAL PRIMARY KEY, -- 主键ID
|
coal_id BIGINT NOT NULL DEFAULT 0, -- 煤种ID
|
coal VARCHAR(50) NOT NULL, -- 煤种
|
calorific_value INT NOT NULL, -- 热值
|
production_quantity INT NOT NULL, -- 生产数量
|
labor_cost DECIMAL(10, 2) NOT NULL, -- 人工成本
|
energy_consumption_cost DECIMAL(10, 2) NOT NULL, -- 能耗成本
|
equipment_depreciation DECIMAL(10, 2) NOT NULL, -- 设备折旧
|
purchase_price DECIMAL(10, 2) NOT NULL, -- 采购单价
|
total_cost DECIMAL(10, 2) NOT NULL, -- 总成本
|
producer VARCHAR(50), -- 生产人
|
production_date DATE, -- 生产日期
|
|
deleted INT NOT NULL DEFAULT 0, -- 软删除标志：0=未删除，1=已删除
|
create_by VARCHAR(255), -- 创建人用户名
|
create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 创建时间，默认当前时间
|
update_by VARCHAR(255), -- 最后更新人用户名
|
update_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP -- 最后更新时间，默认当前时间
|
);
|
|
-- 添加表注释
|
COMMENT ON TABLE production IS '生产明细表';
|
|
-- 添加字段注释
|
COMMENT ON COLUMN production.id IS '主键ID';
|
COMMENT ON COLUMN production.coal_id IS '煤种ID';
|
COMMENT ON COLUMN production.coal IS '煤种';
|
COMMENT ON COLUMN production.calorific_value IS '热值';
|
COMMENT ON COLUMN production.production_quantity IS '生产数量';
|
COMMENT ON COLUMN production.labor_cost IS '人工成本';
|
COMMENT ON COLUMN production.energy_consumption_cost IS '能耗成本';
|
COMMENT ON COLUMN production.equipment_depreciation IS '设备折旧';
|
COMMENT ON COLUMN production.purchase_price IS '采购单价';
|
COMMENT ON COLUMN production.total_cost IS '总成本';
|
COMMENT ON COLUMN production.producer IS '生产人';
|
COMMENT ON COLUMN production.production_date IS '生产日期';
|
|
COMMENT ON COLUMN production.deleted IS '软删除标志，0=未删除，1=已删除';
|
COMMENT ON COLUMN production.create_by IS '创建该记录的用户';
|
COMMENT ON COLUMN production.create_time IS '记录创建时间';
|
COMMENT ON COLUMN production.update_by IS '最后修改该记录的用户';
|
COMMENT ON COLUMN production.update_time IS '记录最后更新时间';
|
