| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| movement_no | varchar(64) | YES | |||
| warehouse_id | char(36) | MUL | YES | ||
| store_id | char(36) | YES | |||
| product_id | char(36) | MUL | YES | ||
| sku_id | char(36) | YES | |||
| movement_type | varchar(32) | MUL | YES | inbound入库/outbound出库/transfer调拨/stocktake盘点/adjust调整/return退货/purchase采购 | |
| quantity | decimal(12,2) | YES | 0.00 | ||
| quantity_before | decimal(12,2) | YES | |||
| quantity_after | decimal(12,2) | YES | |||
| cost_price | decimal(12,2) | YES | |||
| ref_order_no | varchar(64) | YES | 关联单据号 | ||
| operator_id | char(36) | YES | |||
| operator_name | varchar(64) | YES | |||
| remark | longtext | YES | |||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| pool | varchar(24) | NO | STORE_TURNOVER | ||
| biz_type | varchar(24) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_sm_prod | product_id,created_at | 普通 |
| idx_sm_type | movement_type,created_at | 普通 |
| idx_sm_wh | warehouse_id,created_at | 普通 |
| PRIMARY | id | 唯一 |
| id | movement_no | warehouse_id | store_id | product_id | sku_id | movement_type | quantity | quantity_before | quantity_after | cost_price | ref_order_no |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 023f336a-7a88-50de-b737-159acc673705 | LS20261109002 | wh-0001-0000-4000-8000-000000000001 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 00025b95-27f3-4786-b76f-bf3e9730be52 | 80d264d2-992c-59b8-a473-b5857ff30448 | in | 50.00 | 20.00 | 70.00 | 130.90 | CG20261109002 |
| 08239b18-eb02-484c-bdd5-d47bc7c5d50e | CK20261107092120554 | wh-0001-0000-4000-8000-000000000001 | NULL | 0003cbbf-9d90-44bc-bdef-b6853b53c44c | NULL | outbound | -20.00 | 50.00 | 30.00 | NULL | NULL |
| 0d5199e2-7384-5310-858e-eed7dfc92484 | LS20261109001 | wh-0001-0000-4000-8000-000000000001 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 0000d2f3-1978-4e23-aa87-b47796611b06 | 3fd6d85f-2bda-56bb-83be-204bdfe6bc8b | in | 50.00 | 20.00 | 70.00 | 5.50 | CG20261109001 |