| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| parent_id | char(36) | YES | |||
| name | longtext | YES | |||
| description | longtext | YES | |||
| image_url | longtext | YES | |||
| is_deleted | tinyint(1) | YES | |||
| delete_time | datetime(3) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| sort_order | int(11) | YES | |||
| icon | longtext | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | parent_id | name | description | image_url | is_deleted | delete_time | created_at | updated_at | sort_order | icon |
|---|---|---|---|---|---|---|---|---|---|---|
| 00656017-a897-4696-b8d6-3b9ce53b29b3 | NULL | 海鲜水产 > 鱼类 > 淡水鱼 > 调味品 | NULL | NULL | 1 | 2026-10-21 14:40:54.465000 | 2026-10-16 03:47:02.494000 | 2026-10-21 14:40:54.465000 | 0 | NULL |
| 00efab92-ca66-40fa-be25-8b8ab8024eab | f4828943-7f49-4af1-91c5-9709f854d761 | 衣物清洁 | NULL | NULL | 0 | NULL | 2026-10-16 09:32:06.761000 | 2026-11-08 01:24:11.423000 | 1 | NULL |
| 00f8a9fc-c1f9-4def-ad45-9daa53b699fa | a0000001-0000-0000-0000-000000000003 | 灯具照明 | NULL | NULL | 1 | 2026-10-21 14:40:54.465000 | 2026-10-16 01:27:50.475000 | 2026-10-21 14:40:54.465000 | 8 | NULL |