| Column | Type | Actions |
|---|---|---|
| id | bigint(20) | |
| project_id | bigint(20) | |
| title | varchar(255) | |
| description | text | |
| assigned_to | bigint(20) | |
| status | enum('TODO','IN_PROGRESS','REVIEW','REVISION','DONE') | |
| priority | enum('LOW','MEDIUM','HIGH') | |
| deadline | date | |
| created_by | bigint(20) | |
| created_at | timestamp | |
| updated_at | timestamp | |
| submission_url | text | |
| submission_type | enum('LIVE_URL','FILE_URL','ZIP_URL') | |
| submitted_at | timestamp | |
| review_remarks | text | |
| reviewed_by | bigint(20) | |
| reviewed_at | timestamp |