| 字段名 | 类型 | 是否为空 | 主键 | 默认值 | 额外信息 |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| user_id | varchar(50) | NO | MUL | ||
| subject | varchar(20) | NO | MUL | ||
| day_of_week | int(1) | NO | |||
| start_time | time | NO | |||
| end_time | time | NO | |||
| created_at | datetime | NO | |||
| updated_at | datetime | NO |
| 字段名 | 类型 | 是否为空 | 主键 | 默认值 | 额外信息 |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| user_id | varchar(50) | NO | MUL | ||
| subject | varchar(20) | NO | MUL | ||
| date | date | NO | |||
| completed_items | text | YES | |||
| gains | text | YES | |||
| created_at | datetime | NO | |||
| updated_at | datetime | NO |