-- 创建煤质信息表
|
CREATE TABLE coal_quality
|
(
|
id BIGSERIAL PRIMARY KEY, -- 主键ID，自动递增
|
|
coal_id bigint DEFAULT 0 NOT NULL,
|
coal VARCHAR(255) NOT NULL, -- 煤种类型，不允许为空
|
|
total_moisture DECIMAL(10, 2), -- 全水含量 (%)
|
analysis_moisture DECIMAL(10, 2), -- 分析水含量 (%)
|
volatile_matter DECIMAL(10, 2), -- 挥发分 (%)
|
fixed_carbon DECIMAL(10, 2), -- 固定碳 (%)
|
lower_heat_value DECIMAL(10, 2), -- 低位发热量 (kcal/kg)
|
higher_heat_value DECIMAL(10, 2), -- 高位发热量 (kcal/kg)
|
ash_content DECIMAL(10, 2), -- 灰分 (%)
|
sulfur_content DECIMAL(10, 2), -- 硫含量 (%)
|
|
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 coal_quality IS '煤质信息表，记录煤炭质量检测相关数据';
|
|
-- 字段注释
|
COMMENT ON COLUMN coal_quality.id IS '主键ID';
|
COMMENT ON COLUMN coal_quality.coal_id IS '煤种类型id';
|
COMMENT ON COLUMN coal_quality.coal IS '煤种类型';
|
COMMENT ON COLUMN coal_quality.total_moisture IS '全水含量百分比 (%)';
|
COMMENT ON COLUMN coal_quality.analysis_moisture IS '分析水含量百分比 (%)';
|
COMMENT ON COLUMN coal_quality.volatile_matter IS '挥发分百分比 (%)';
|
COMMENT ON COLUMN coal_quality.fixed_carbon IS '固定碳百分比 (%)';
|
COMMENT ON COLUMN coal_quality.lower_heat_value IS '低位发热量（单位：千卡/千克）';
|
COMMENT ON COLUMN coal_quality.higher_heat_value IS '高位发热量（单位：千卡/千克）';
|
COMMENT ON COLUMN coal_quality.ash_content IS '灰分百分比 (%)';
|
COMMENT ON COLUMN coal_quality.sulfur_content IS '硫含量百分比 (%)';
|
COMMENT ON COLUMN coal_quality.deleted IS '软删除标志，0=未删除，1=已删除';
|
COMMENT ON COLUMN coal_quality.create_by IS '创建该记录的用户';
|
COMMENT ON COLUMN coal_quality.create_time IS '记录创建时间';
|
COMMENT ON COLUMN coal_quality.update_by IS '最后修改该记录的用户';
|
COMMENT ON COLUMN coal_quality.update_time IS '记录最后更新时间';
|
