| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| user_id | char(36) | YES | |||
| type | longtext | YES | |||
| dimension | longtext | YES | |||
| points | decimal(8,2) | YES | |||
| label | longtext | YES | |||
| record_date | date | YES | |||
| occurred_at | datetime(3) | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| record_kind | longtext | YES | |||
| checkin_date | date | YES | |||
| dimensions | longtext | YES | |||
| total_points | decimal(8,2) | YES | |||
| continuous_days | int(11) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |