cr_cos - Laravel Schema Designer

coi_pegawai

id increments
timestamps timestamps
nip_pegawai string (10)
company_code string (10)
kegiatan string (100)
tgl_kegiatan date
deskripsi string (200)
business_area string
putusan_atasan_id integer
rekomendasi_putusan_id integer
evidence string (100)
berkas string (100)
atasan_id integer
nip_atasan string (10)
tgl_putusan_atasan date
divkpt_id integer
tgl_rekomendasi_putusan date
klasifikasi_id integer
evaluasi_id integer
last_status_id integer

user

id increments
timestamps timestamps
nip string

m_putusan

id increments
timestamps timestamps
nama string (200)

dpm_pegawai

id increments
timestamps timestamps
tgl_pelaporan date
nip_pegawai string (20)
status integer
validasi_id integer
business_area string (100)
company_code string (100)

dpm_saham

id increments
timestamps timestamps
jumlah float
pengalihan string (100)
nomor string (100)
tgl_perolehan string (100)
dpm_id integer
gadai string (100)
catatan string (100)
self_assesment string (200)
compliance_opinion string

dpm_aset

id increments
timestamps timestamps
jenis string (100)
bukti_kepemilikan string (100)
nama_pemilik string (100)
tgl_perolehan date
pemanfaatan_aset string (100)
pemilik_manfaat string (100)
self_assesment string (100)
compliance_opinion string (200)

m_klasifikasi

id increments
timestamps timestamps
klasifikasi integer

m_evaluasi_coi

id increments
timestamps timestamps
evaluasi string (100)

m_status_coi

id increments
timestamps timestamps
status string (20)
deskripsi string (100)

m_validasi_dpm

id increments
timestamps timestamps
validasi string (100)
deskripsi string (100)

history_coi

id increments
timestamps timestamps
tgl_history date
status_id integer
coi_id integer

bussiness_area

id increments
timestamps timestamps
business_area string (100)

company_code

id increments
timestamps timestamps
company_code string (100)

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01