e-kinerja - Laravel Schema Designer

pegawai

id increments
timestamps timestamps
softDeletes softDeletes
nip string (18)
nama string (32)

kinerja

id increments
timestamps timestamps
softDeletes softDeletes
pegawai_id ^FK integer
pegawai_data json
tahun string
tanggal_mulai string
tanggal_akhir string

iki_sasaran_program

id increments
timestamps timestamps
softDeletes softDeletes
kinerjai_id ^FK integer
program string

iki_indikator

id increments
timestamps timestamps
softDeletes softDeletes
iki_sasaran_program_id ^FK integer
kegiatan string
penjelasan string
satuan string
sumber_data string

pk

id increments
timestamps timestamps
softDeletes softDeletes
iki_indikator_id ^FK integer
target_tahun string
target_bulan_1 string
target_bulan_2 string
target_bulan_3 string
target_bulan_4 string
target_bulan_5 string
target_bulan_6 string
target_bulan_7 string
target_bulan_8 string
target_bulan_9 string
target_bulan_10 string
target_bulan_11 string
target_bulan_12 string

program_kegiatan

id increments
timestamps timestamps
softDeletes softDeletes
kinerja_id ^FK integer
program string
kegiatan string
anggaran integer

ppk

id increments
timestamps timestamps
softDeletes softDeletes
kinerja_id ^FK integer
penilai_pegawai_id integer
penilai json
atasan_penilai_pegawai_id integer
atasan_penilai json
nilai string
nilai_label string
data string

skp_kegiatan

id increments
timestamps timestamps
softDeletes softDeletes
skp_id ^FK integer
name string
satuan string
target_angka_kredit string
target_kuantitas string
target_kualitas string
target_waktu string
target_biaya string
is_realisasi boolean
realisasi_angka_kredit string
realisasi_kuantitas string
realisasi_kualitas string
realisasi_waktu string
realisasi_biaya string
perhitungan string
nilai string
is_error boolean

skp_tugas_penilaian

id increments
timestamps timestamps
softDeletes softDeletes
skp_tugas_id ^FK integer
nama string
penilai_pegawai_id integer
penilai json
surat_nomor string
surat_tanggal date
surat_penandatangan string
nilai integer
data string

skp_kreativitas

id increments
timestamps timestamps
softDeletes softDeletes
skp_id ^FK integer
total integer
kuantitas integer
nilai integer

ppk_perilaku

id increments
timestamps timestamps
softDeletes softDeletes
ppk_id ^FK integer
total integer
kuantitas integer
sub_nilai integer
sub_nilai_label string
bobot integer
nilai integer

ppk_perilaku_penilaian

id increments
timestamps timestamps
softDeletes softDeletes
ppk_perilaku_id ^FK integer
nama string
nilai integer
nilai_label string

skp

id increments
timestamps timestamps
softDeletes softDeletes
ppk_id integer
sub_nilai integer
sub_nilai_label string
bobot integer
nilai integer

skp_tugas

id increments
timestamps timestamps
softDeletes softDeletes
skp_id ^FK integer
total integer
kuantitas integer
nilai integer

skp_kreativitas_penilaian

id increments
timestamps timestamps
softDeletes softDeletes
skp_kreativitas_id ^FK integer
nama string
penilai_pegawai_id integer
penilai json
surat_nomor string
surat_tanggal date
surat_penandatangan string
nilai integer

tunjangan

id increments
timestamps timestamps
softDeletes softDeletes
pegawai_id ^FK integer
pegawai_data json
tunjangan bigInteger

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