| Column | Type | Actions |
|---|---|---|
| id | bigint(20) | |
| project_code | varchar(50) | |
| title | varchar(255) | |
| description | text | |
| total_amount | decimal(10,2) | |
| paid_amount | decimal(10,2) | |
| remaining_amount | decimal(10,2) | |
| tip_amount | decimal(10,2) | |
| deadline | date | |
| status | enum('PENDING','REJECTED','VALIDATED','SRS_CREATED','UI_IN_PROGRESS','UI_COMPLETED','UI_REVISION','UI_APPROVED','DEV_IN_PROGRESS','DEV_COMPLETED','DEV_REVISION','DEV_APPROVED','CLIENT_REVISION','READY_FOR_DEPLOYMENT','DEPLOYED') | |
| created_by | bigint(20) | |
| created_by_type | enum('employee','manager') | |
| client_name | varchar(255) | |
| client_email | varchar(255) | |
| client_phone | varchar(50) | |
| created_at | timestamp | |
| updated_at | timestamp | |
| srs_file_url | text | |
| srs_file_name | varchar(255) | |
| srs_assigned_to | bigint(20) | |
| srs_status | enum('PENDING','IN_PROGRESS','SUBMITTED','APPROVED','REJECTED') | |
| srs_submitted_at | timestamp | |
| srs_approved_at | timestamp | |
| srs_rejected_at | timestamp | |
| srs_review_remarks | text | |
| ui_design_url | text | |
| ui_design_type | enum('FIGMA','WEB','OTHER') | |
| ui_assigned_to | bigint(20) | |
| ui_status | enum('PENDING','IN_PROGRESS','SUBMITTED','REVISION_REQUIRED','APPROVED') | |
| ui_submitted_at | timestamp | |
| ui_approved_at | timestamp | |
| ui_feedback | text | |
| developer_assigned_to | bigint(20) | |
| assignment_type | enum('solo','team') | |
| dev_started_at | timestamp | |
| deployment_url | text | |
| deployed_by | bigint(20) | |
| deployed_at | timestamp | |
| payment_method | varchar(100) |