| | |
|---|
| | | registrant_id VARCHAR(50) NOT NULL, -- 登记人id |
|---|
| | | type VARCHAR(50) NOT NULL, -- 登记人id |
|---|
| | | pending_id BIGINT, -- 待入库id |
|---|
| | | merge_id BIGINT, -- 合并id |
|---|
| | | registration_date TIMESTAMP WITHOUT TIME ZONE, |
|---|
| | | |
|---|
| | | deleted INT NOT NULL DEFAULT 0, -- 软删除标志：0=未删除，1=已删除 |
|---|
| | |
|---|
| | | COMMENT ON COLUMN official_inventory.pending_replenishment IS '待补库'; |
|---|
| | | COMMENT ON COLUMN official_inventory.registrant_id IS '登记人id'; |
|---|
| | | COMMENT ON COLUMN official_inventory.registration_date IS '登记日期'; |
|---|
| | | COMMENT ON COLUMN official_inventory.merge_id IS '合并id'; |
|---|
| | | |
|---|
| | | COMMENT ON COLUMN official_inventory.deleted IS '软删除标志，0=未删除，1=已删除'; |
|---|
| | | COMMENT ON COLUMN official_inventory.create_by IS '创建该记录的用户'; |
|---|
