| | |
|---|
| | | customer_id BIGINT, -- 客户id |
|---|
| | | customer VARCHAR(255) NOT NULL, -- 客户 |
|---|
| | | coal_id VARCHAR(255) NOT NULL, -- 煤种 id |
|---|
| | | coal VARCHAR(255) NOT NULL, -- 煤种 |
|---|
| | | price_including_tax DECIMAL(10, 2) NOT NULL, -- 单价（含税） |
|---|
| | | inventory_quantity DECIMAL(10, 0) NOT NULL, -- 库存数量 |
|---|
| | | unit VARCHAR(100) NOT NULL, -- 单位 |
|---|
| | |
|---|
| | | COMMENT ON COLUMN sales_record.sale_date IS '销售日期'; |
|---|
| | | COMMENT ON COLUMN sales_record.customer IS '客户'; |
|---|
| | | COMMENT ON COLUMN sales_record.customer_id IS '客户id'; |
|---|
| | | COMMENT ON COLUMN sales_record.coal IS '煤种'; |
|---|
| | | COMMENT ON COLUMN sales_record.coal_id IS '煤种id'; |
|---|
| | | COMMENT ON COLUMN sales_record.unit IS '单位'; |
|---|
| | | COMMENT ON COLUMN sales_record.price_including_tax IS '单价（含税）'; |
|---|
