| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| user_id | char(36) | YES | |||
| family_id | char(36) | YES | |||
| type | longtext | YES | |||
| category | longtext | YES | |||
| amount | decimal(12,2) | YES | |||
| description | longtext | YES | |||
| record_date | date | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |