| id |
int(11)
|
|
|
|
| project_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| apply_date |
date
|
|
|
|
| category_code |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| project_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| customer_id |
int(11)
|
|
|
|
| quotation_id |
int(11)
|
|
|
|
| order_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| order_amount |
decimal(15,2)
|
|
|
|
| currency |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| exchange_rate |
decimal(12,4)
|
|
|
|
| owner |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| total_cost |
decimal(15,2)
|
|
|
|
| invoice_percent_done |
decimal(10,2)
|
|
|
|
| order_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| quote_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cost_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| note |
text
|
utf8mb4_general_ci
|
|
|
| created_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| closed_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
