-- 创建设备使用明细表 equipment_usage_detail
|
DROP TABLE IF EXISTS equipment_usage_detail;
|
|
CREATE TABLE equipment_usage_detail
|
(
|
id BIGSERIAL PRIMARY KEY, -- 主键ID，自动递增
|
usage_id BIGINT NOT NULL, -- 关联的使用记录ID
|
equipment_id BIGINT NOT NULL, -- 关联的设备ID
|
operation_type INT NOT NULL, -- 操作类型：1-领用，2-归还
|
quantity INT NOT NULL, -- 操作数量
|
operator_id BIGINT NOT NULL, -- 操作人ID
|
operator VARCHAR(255), -- 操作人
|
remark VARCHAR(255), -- 备注
|
|
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_detail IS '设备使用明细表';
|
|
-- 为字段添加注释
|
COMMENT
|
ON COLUMN equipment_usage_detail.id IS '主键ID';
|
COMMENT
|
ON COLUMN equipment_usage_detail.usage_id IS '关联的使用记录ID';
|
COMMENT
|
ON COLUMN equipment_usage_detail.equipment_id IS '关联的设备ID';
|
COMMENT
|
ON COLUMN equipment_usage_detail.operation_type IS '操作类型：1-领用，2-归还';
|
COMMENT
|
ON COLUMN equipment_usage_detail.quantity IS '操作数量';
|
COMMENT
|
ON COLUMN equipment_usage_detail.operator_id IS '操作人ID';
|
COMMENT
|
ON COLUMN equipment_usage_detail.operator IS '操作人';
|
COMMENT
|
ON COLUMN equipment_usage_detail.remark IS '备注';
|
|
COMMENT
|
ON COLUMN equipment_usage_detail.deleted IS '软删除标志，0=未删除，1=已删除';
|
COMMENT
|
ON COLUMN equipment_usage_detail.create_by IS '创建该记录的用户';
|
COMMENT
|
ON COLUMN equipment_usage_detail.create_time IS '记录创建时间';
|
COMMENT
|
ON COLUMN equipment_usage_detail.update_by IS '最后修改该记录的用户';
|
COMMENT
|
ON COLUMN equipment_usage_detail.update_time IS '记录最后更新时间';
|
