| id |
int(11)
|
|
|
|
| project_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| project_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| customer_id |
int(11)
|
|
|
|
| project_type_id |
int(11)
|
|
|
|
| status_id |
int(11)
|
|
|
|
| pm_id |
int(11)
|
|
|
|
| start_date |
date
|
|
|
|
| end_date |
date
|
|
|
|
| survey_date |
date
|
|
|
|
| deal_date |
date
|
|
|
|
| completed_date |
date
|
|
|
|
| nilai_rab |
decimal(15,2)
|
|
|
|
| nilai_penawaran |
decimal(15,2)
|
|
|
|
| nilai_deal |
decimal(15,2)
|
|
|
|
| biaya_barang |
decimal(15,2)
|
|
|
|
| biaya_tenaga |
decimal(15,2)
|
|
|
|
| biaya_transport |
decimal(15,2)
|
|
|
|
| fee_marketing |
decimal(15,2)
|
|
|
|
| total_cost |
decimal(15,2)
|
|
|
|
| laba_rugi |
decimal(15,2)
|
|
|
|
| margin_persen |
decimal(5,2)
|
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| location |
text
|
utf8mb4_general_ci
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| survey_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| rab_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| penawaran_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| kontrak_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| bast_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
