| id |
int(11)
|
|
|
|
| request_no |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| applicant_id |
int(11)
|
|
|
|
| customer_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| order_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| quotation_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| project_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| amount |
decimal(14,2)
|
|
|
|
| payment_terms |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| status |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| admin_reviewer_id |
int(11)
|
|
|
|
| reviewed_by |
int(11)
|
|
|
|
| reviewed_at |
datetime
|
|
|
|
| project_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| reject_reason |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| apply_date |
date
|
|
|
|
| category_code |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| customer_id |
int(11)
|
|
|
|
| quotation_id |
int(11)
|
|
|
|
| order_amount |
decimal(14,2)
|
|
|
|
| currency |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| owner |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| note |
text
|
utf8mb4_general_ci
|
|
|
| order_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| quote_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cost_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| project_case_id |
int(11)
|
|
|
|
