| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| code | varchar | YES | ||
| name | varchar | YES | ||
| category | varchar | YES | ||
| origin | varchar | YES | ||
| batch_no | varchar | YES | ||
| price | decimal | YES | ||
| stock | int | YES | ||
| shelf_status | varchar | YES | ||
| merchant_id | bigint | YES | ||
| supplier_id | bigint | YES | ||
| status | varchar | YES | ||
| remark | text | YES | ||
| created_at | datetime | YES | ||
| updated_at | datetime | YES | ||
| create_time | datetime | YES |