| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| product_id | char(36) | MUL | YES | ||
| merchant_id | char(36) | YES | |||
| store_id | char(36) | YES | |||
| audit_type | varchar(32) | YES | listing | listing上架/edit编辑/offline下架 | |
| submit_by | char(36) | YES | |||
| status | tinyint(4) | MUL | YES | 0 | 0待审 1通过 2驳回 |
| auditor_id | char(36) | YES | |||
| audit_at | datetime(3) | YES | |||
| reject_reason | longtext | YES | |||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_pa_product | product_id | 普通 |
| idx_pa_status | status,created_at | 普通 |
| PRIMARY | id | 唯一 |
| id | product_id | merchant_id | store_id | audit_type | submit_by | status | auditor_id | audit_at | reject_reason | is_deleted | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 983936c1-88a4-4e5f-9c42-3ec675a75f2a | 0003cbbf-9d90-44bc-bdef-b6853b53c44d | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | listing | storemgr01 | 2 | NULL | 2026-11-07 09:23:11.784000 | 主图含水印,请重新提交 | 0 | 2026-11-07 09:23:11.777000 |
| e12220ee-fb2f-450d-82e4-899a0da9f059 | 0003cbbf-9d90-44bc-bdef-b6853b53c44c | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | listing | storemgr01 | 1 | admin | 2026-11-07 09:23:11.780000 | NULL | 0 | 2026-11-07 09:23:11.772000 |