| Column | Type | Actions |
|---|---|---|
| team_id | int(10) unsigned | |
| team_name | varchar(100) | |
| member_id | int(10) unsigned | |
| member_type | enum('sales_employee','manager') | |
| member_name | varchar(100) | |
| member_email | varchar(100) | |
| member_phone | varchar(20) | |
| project_id | int(11) | |
| project_number | varchar(20) | |
| title | varchar(250) | |
| price | decimal(12,2) | |
| payment_received | decimal(12,2) | |
| payment_remaining | decimal(12,2) | |
| tip_amount | decimal(12,2) | |
| payment_method | varchar(100) | |
| tip_payment_method | varchar(255) | |
| deadline | date | |
| project_status | enum('Pending','AdminApproved','AdminRejected','SentToDesigner','AssignedToDesigner','DesignUploaded','RevisionRequested','RevisionUploaded','DesignApproved','DesignFinalApproved','FinalFilesUploaded','Completed') | |
| created_at | timestamp | |
| completed_at | datetime | |
| payment_details | varchar(372) |