| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| project_number | varchar(20) | |
| sales_id | int(11) | |
| sales_type | enum('employee','manager') | |
| sales_name | varchar(100) | |
| client_name | varchar(150) | |
| client_email | varchar(150) | |
| client_phone | varchar(30) | |
| title | varchar(250) | |
| description | text | |
| price | decimal(12,2) | |
| payment_received | decimal(12,2) | |
| payment_remaining | decimal(12,2) | |
| tip_amount | decimal(12,2) | |
| deadline | date | |
| payment_method | varchar(100) | |
| designer_deadline | date | |
| created_at | timestamp | |
| completed_at | datetime | |
| design_manager_id | int(11) | |
| design_manager_name | varchar(100) | |
| designer_id | int(11) | |
| designer_name | varchar(100) | |
| status | enum('Pending','AdminApproved','AdminRejected','SentToDesigner','AssignedToDesigner','DesignUploaded','RevisionRequested','RevisionUploaded','DesignApproved','DesignFinalApproved','FinalFilesUploaded','Completed') | |
| admin_notes | text | |
| revision_notes | text | |
| tip_payment_method | varchar(255) |