| id |
int(11)
|
|
|
|
| cabang_id |
int(11)
|
|
|
|
| pelanggan_id |
int(11)
|
|
|
|
| tanggal_masuk |
datetime
|
|
|
|
| nama_proyek |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| jenis_proyek |
enum('UMUM', 'CCTV', 'DEPLOYMENT_SUPPORT', 'JARINGAN')
|
utf8mb4_unicode_ci
|
|
|
| biaya_akomodasi |
decimal(15,2)
|
|
|
|
| biaya_transport |
decimal(15,2)
|
|
|
|
| biaya_vendor_proyek |
decimal(15,2)
|
|
|
|
| deskripsi |
text
|
utf8mb4_unicode_ci
|
|
|
| file_lampiran |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| pelanggan_nama |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| pelanggan_hp |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| nilai_kontrak |
decimal(15,2)
|
|
|
|
| diskon_nominal |
decimal(15,2)
|
|
|
|
| diskon_persen |
decimal(5,2)
|
|
|
|
| fee_marketing_nominal |
decimal(15,2)
|
|
|
|
| fee_marketing_persen |
decimal(5,2)
|
|
|
|
| margin_profit |
decimal(5,2)
|
|
|
|
| dp |
decimal(15,2)
|
|
|
|
| akun_kas_id |
int(11)
|
|
|
|
| status |
enum('SURVEY', 'PENAWARAN', 'DEAL', 'PROSES', 'SELESAI', 'BATAL', 'PENAWARAN_DISETUJUI')
|
utf8mb4_unicode_ci
|
|
|
| biaya_approved_by |
int(11)
|
|
|
|
| is_locked |
tinyint(1)
|
|
|
|
| penawaran_syarat |
text
|
utf8mb4_unicode_ci
|
|
|
| status_pembayaran |
enum('PENDING', 'PROSES', 'LUNAS')
|
utf8mb4_unicode_ci
|
|
|
| tanggal_approval |
datetime
|
|
|
|
| tanggal_penawaran |
datetime
|
|
|
|
| tanggal_mulai |
date
|
|
|
|
| tanggal_target |
date
|
|
|
|
| tanggal_selesai |
date
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| rekanan_nama |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| rekanan_no_hp |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| pic_lapangan |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| pic_lapangan_hp |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| surat_tugas_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| is_onsite_proyek |
tinyint(1)
|
|
|
|
