| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| class_id | int(11) | NO | MUL | ||
| title | varchar(100) | NO | |||
| description | text | YES | |||
| type | enum('materi','tugas','ujian') | NO | |||
| deadline | datetime | YES | |||
| file_url | varchar(255) | YES | |||
| created_at | timestamp | YES | current_timestamp() |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| material_id | int(11) | NO | MUL | ||
| student_id | int(11) | NO | MUL | ||
| file_url | varchar(255) | YES | |||
| answer | text | YES | |||
| grade | int(11) | YES | |||
| submitted_at | timestamp | YES | current_timestamp() |