aspek_penilaian_kinerja
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_aspek (Primary) | int(11) | No | ||||
| aspek | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_aspek | 4 | A | No |
bagian_jabatan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_bagian (Primary) | int(11) | No | ||||
| nama_bagian | varchar(500) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_bagian | 8 | A | No |
checklog_karyawan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_checklog (Primary) | int(11) | No | ||||
| PIN | varchar(10) | No | ||||
| NIK | varchar(10) | No | ||||
| Name | varchar(255) | No | ||||
| Location | varchar(500) | No | ||||
| cloud_id | varchar(50) | No | ||||
| date_time | varchar(500) | No | ||||
| type | varchar(100) | No | ||||
| status | int(11) | No | ||||
| verify | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_checklog | 183011 | A | No |
checklog_security
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_checklog (Primary) | int(11) | No | ||||
| PIN | varchar(10) | No | ||||
| NIK | varchar(10) | No | ||||
| Name | varchar(255) | No | ||||
| Location | varchar(500) | No | ||||
| cloud_id | varchar(50) | No | ||||
| date_time | varchar(500) | No | ||||
| type | varchar(100) | No | ||||
| status | int(11) | No | ||||
| verify | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_checklog | 1476 | A | No |
checklog_tpk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_checklog (Primary) | int(11) | No | ||||
| PIN | varchar(10) | No | ||||
| NIK | varchar(10) | No | ||||
| Name | varchar(255) | No | ||||
| Location | varchar(500) | No | ||||
| cloud_id | varchar(50) | No | ||||
| date_time | varchar(500) | No | ||||
| type | varchar(100) | No | ||||
| status | int(11) | No | ||||
| verify | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_checklog | 2796 | A | No |
hutang_karyawan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_hutang_karyawan (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| tanggal_hutang | date | No | ||||
| jumlah | double | No | ||||
| pelunasan | double | Yes | NULL | |||
| status_pelunasan | int(11) | No | 0 | |||
| kategori_hutang | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_hutang_karyawan | 2 | A | No |
hutang_pu
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_hutang_pu (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | karyawan -> id_karyawan | |||
| tanggal_hutang | date | No | ||||
| bulan_potong_gaji | int(11) | No | 0 | |||
| tahun_potong_gaji | year(4) | No | 2000 | |||
| id_unit | int(11) | No | ||||
| keterangan | varchar(500) | No | ||||
| nominal | double | No | ||||
| status | int(11) | No | 0 = hutang / 1 = lunas | |||
| jenis | int(11) | No | ||||
| user | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_hutang_pu | 2798 | A | No | |
| hutang_pu_ibfk_1 | BTREE | No | No | id_karyawan | 199 | A | No |
indikator_penilaian_kinerja
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_indikator (Primary) | int(11) | No | ||||
| id_aspek | int(11) | No | aspek_penilaian_kinerja -> id_aspek | |||
| indikator | varchar(500) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_indikator | 20 | A | No | |
| id_aspek | BTREE | No | No | id_aspek | 10 | A | No |
jabatan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jabatan (Primary) | int(11) | No | ||||
| nama_jabatan | varchar(500) | No | ||||
| keterangan_jabatan | varchar(500) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jabatan | 19 | A | No |
jam_kerja
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jam_kerja (Primary) | int(11) | No | ||||
| jam_masuk | time | No | ||||
| jam_pulang | time | No | ||||
| keterangan | varchar(255) | Yes | NULL | |||
| id_jabatan | int(11) | No | jabatan -> id_jabatan | |||
| shift | int(11) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jam_kerja | 30 | A | No | |
| jam_kerja_ibfk_1 | BTREE | No | No | id_jabatan | 30 | A | No |
karyawan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| no_karyawan | int(11) | Yes | NULL | |||
| id_karyawan | int(11) | No | ||||
| pass_karyawan | varchar(35) | No | ||||
| nama_karyawan | text | No | ||||
| status_karyawan | int(11) | No | jabatan -> id_jabatan | |||
| bagian_karyawan | int(11) | No | bagian_jabatan -> id_bagian | |||
| kode_unit | int(11) | No | ||||
| detail_bagian | varchar(500) | Yes | NULL | |||
| desa_karyawan | varchar(22) | Yes | NULL | |||
| kec_karyawan | varchar(22) | Yes | NULL | |||
| kab_karyawan | varchar(22) | Yes | NULL | |||
| tgl_lahir | date | No | ||||
| jenis_kelamin | varchar(255) | No | ||||
| tgl_masuk | date | Yes | NULL | |||
| tgl_pensiun | date | Yes | NULL | |||
| pend | text | Yes | NULL | |||
| stat | text | Yes | NULL | |||
| no_npwp | text | Yes | NULL | |||
| no_tenagakerja | text | Yes | NULL | |||
| no_kesehatan | text | Yes | NULL | |||
| no_ktp | text | Yes | NULL | |||
| no_tlp | text | Yes | NULL | |||
| foto | varchar(250) | Yes | blank_foto.png | |||
| h_normal | int(11) | No | 0 | |||
| h_masuk | int(11) | No | 0 | |||
| alpha | int(11) | No | 0 | |||
| sakit | int(11) | No | 0 | |||
| izin | int(11) | No | 0 | |||
| cuti | int(11) | No | 0 | |||
| aktif | varchar(5) | No | ||||
| jenis_keluar | varchar(100) | No | ||||
| tgl_keluar | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 99 | A | No | |
| id_karyawan | BTREE | Yes | No | id_karyawan | 99 | A | No | |
| bagian_karyawan | BTREE | No | No | bagian_karyawan | 12 | A | No | |
| status_karyawan | BTREE | No | No | status_karyawan | 33 | A | No |
kontrak_kerja
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kontrak_kerja (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| mulai_kontrak | date | No | ||||
| akhir_kontrak | date | No | ||||
| status_kontrak | varchar(50) | No | ||||
| dokumen_kontrak | varchar(500) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_kontrak_kerja | 0 | A | No |
kriteria_penilaian
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kriteria (Primary) | int(11) | No | ||||
| keterangan | varchar(255) | Yes | NULL | |||
| prosentase | int(11) | Yes | NULL | |||
| nilai | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_kriteria | 5 | A | No |
nilai_indikator
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_nilai (Primary) | int(11) | No | ||||
| id_indikator | int(11) | No | indikator_penilaian_kinerja -> id_indikator | |||
| nilai_indikator | int(11) | No | ||||
| nik_karyawan | int(11) | No | karyawan -> id_karyawan | |||
| id_periode | int(11) | No | periode_penilaian -> id_periode | |||
| tahun | year(4) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_nilai | 0 | A | No | |
| id_indikator | BTREE | No | No | id_indikator | 0 | A | No | |
| nilai_indikator_ibfk_2 | BTREE | No | No | nik_karyawan | 0 | A | No | |
| nilai_indikator_ibfk_3 | BTREE | No | No | id_periode | 0 | A | No |
panitia
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| no_karyawan | int(11) | Yes | NULL | |||
| id_karyawan | int(11) | No | ||||
| nama_karyawan | text | No | ||||
| posisi | varchar(255) | No | ||||
| tag | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 36 | A | No | |
| id_karyawan | BTREE | Yes | No | id_karyawan | 36 | A | No |
pelanggaran
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pelanggaran (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| detail | varchar(500) | No | ||||
| tanggal | date | No | ||||
| bukti_pelanggaran | varchar(500) | No | ||||
| kode | int(11) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pelanggaran | 0 | A | No |
pelunasan_hutang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pelunasan_hutang (Primary) | int(11) | No | ||||
| id_hutang_karyawan | int(11) | No | hutang_karyawan -> id_hutang_karyawan | |||
| tanggal_pelunasan | date | No | ||||
| nominal | double | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pelunasan_hutang | 0 | A | No | |
| id_hutang_karyawan | BTREE | No | No | id_hutang_karyawan | 0 | A | No |
periode_penilaian
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_periode (Primary) | int(11) | No | ||||
| periode_penilaian | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_periode | 2 | A | No |
perizinan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_perizinan (Primary) | int(11) | No | ||||
| tanggal_izin | date | No | ||||
| tanggal_mulai | date | No | ||||
| tanggal_selesai | date | No | ||||
| alasan | varchar(500) | Yes | NULL | |||
| bukti | varchar(500) | Yes | NULL | |||
| kategori_izin | int(1) | No | ||||
| id_karyawan | int(11) | No | ||||
| status_izin | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_perizinan | 2451 | A | No |
persen_thp
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_persen (Primary) | int(11) | No | ||||
| persen_thp | int(11) | No | ||||
| tanggal_input | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_persen | 0 | A | No |
poin_penilaian
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_poin (Primary) | int(11) | No | ||||
| poin_penilaian | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_poin | 2 | A | No |
presensi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_presensi (Primary) | int(11) | No | ||||
| PIN | varchar(10) | No | ||||
| NIK | varchar(10) | No | ||||
| Name | varchar(255) | No | ||||
| tanggal | date | No | ||||
| waktu_masuk | time | Yes | NULL | |||
| waktu_pulang | time | Yes | NULL | |||
| nilai_masuk | int(11) | No | ||||
| nilai_pulang | int(11) | No | ||||
| jam_masuk | time | No | ||||
| jam_pulang | time | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_presensi | 13 | A | No |
rekap_absensi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | karyawan -> id_karyawan | |||
| periode_penilaian | int(11) | No | periode_penilaian -> id_periode | |||
| tahun | year(4) | No | ||||
| sakit | int(11) | No | ||||
| ijin | int(11) | No | ||||
| alpa | int(11) | No | ||||
| keterlambatan | int(11) | No | ||||
| pulang_awal | int(11) | No | ||||
| bulan_1 | int(11) | No | ||||
| bulan_2 | int(11) | No | ||||
| bulan_3 | int(11) | No | ||||
| bulan_4 | int(11) | No | ||||
| bulan_5 | int(11) | No | ||||
| bulan_6 | int(11) | No | ||||
| nilai | int(11) | No | ||||
| rekomendasi | varchar(500) | Yes | NULL | |||
| tanggal_rapor | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 101 | A | No | |
| nik_karyawan | BTREE | No | No | id_karyawan | 101 | A | No | |
| periode_penilaian | BTREE | No | No | periode_penilaian | 4 | A | No |
rekap_bulanan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | year(4) | No | ||||
| sakit | int(11) | No | ||||
| ijin | int(11) | No | ||||
| alpa | int(11) | No | ||||
| keterlambatan | int(11) | No | ||||
| pulang_awal | int(11) | No | ||||
| nilai_masuk | int(11) | No | ||||
| nilai_pulang | int(11) | No | ||||
| nilai_bulanan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 5336 | A | No |
rekap_bulanan_kejujuran
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | year(4) | No | ||||
| nilai_bulanan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 2176 | A | No |
rekap_bulanan_kejujuran1
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | year(4) | No | ||||
| nilai_bulanan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 0 | A | No |
rekap_bulanan_kejujuran2
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | year(4) | No | ||||
| nilai_bulanan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 0 | A | No |
rekap_bulanan_kepatuhan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | year(4) | No | ||||
| nilai_bulanan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 2176 | A | No |
rekap_bulanan_tanggung_jawab
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | year(4) | No | ||||
| nilai_bulanan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 2176 | A | No |
rekap_rapor
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_rekap (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| periode_penilaian | int(11) | No | ||||
| tahun | year(4) | No | ||||
| sakit | int(11) | No | ||||
| ijin | int(11) | No | ||||
| alpa | int(11) | No | ||||
| keterlambatan | int(11) | No | ||||
| pulang_awal | int(11) | No | ||||
| disiplin_bulan_1 | int(11) | No | ||||
| disiplin_bulan_2 | int(11) | No | ||||
| disiplin_bulan_3 | int(11) | No | ||||
| disiplin_bulan_4 | int(11) | No | ||||
| disiplin_bulan_5 | int(11) | No | ||||
| disiplin_bulan_6 | int(11) | No | ||||
| nilai_disiplin | int(11) | No | ||||
| tanggung_jawab_bulan_1 | int(11) | No | ||||
| tanggung_jawab_bulan_2 | int(11) | No | ||||
| tanggung_jawab_bulan_3 | int(11) | No | ||||
| tanggung_jawab_bulan_4 | int(11) | No | ||||
| tanggung_jawab_bulan_5 | int(11) | No | ||||
| tanggung_jawab_bulan_6 | int(11) | No | ||||
| nilai_tanggung_jawab | int(11) | No | ||||
| kepatuhan_bulan_1 | int(11) | No | ||||
| kepatuhan_bulan_2 | int(11) | No | ||||
| kepatuhan_bulan_3 | int(11) | No | ||||
| kepatuhan_bulan_4 | int(11) | No | ||||
| kepatuhan_bulan_5 | int(11) | No | ||||
| kepatuhan_bulan_6 | int(11) | No | ||||
| nilai_kepatuhan | int(11) | No | ||||
| kejujuran_bulan_1 | int(11) | No | ||||
| kejujuran_bulan_2 | int(11) | No | ||||
| kejujuran_bulan_3 | int(11) | No | ||||
| kejujuran_bulan_4 | int(11) | No | ||||
| kejujuran_bulan_5 | int(11) | No | ||||
| kejujuran_bulan_6 | int(11) | No | ||||
| nilai_kejujuran | int(11) | No | ||||
| total_nilai_kedisiplinan | int(11) | No | ||||
| total_nilai_kinerja | int(11) | No | ||||
| total_nilai_rapor | int(11) | No | ||||
| rekomendasi | varchar(500) | Yes | NULL | |||
| tanggal_rapor | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_rekap | 387 | A | No | |
| nik_karyawan | BTREE | No | No | id_karyawan | 387 | A | No | |
| periode_penilaian | BTREE | No | No | periode_penilaian | 4 | A | No |
sk_karyawan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_sk_karyawan (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| mulai_sk | date | No | ||||
| detail | varchar(500) | No | ||||
| status_sk | varchar(50) | No | ||||
| dokumen_sk | varchar(500) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_sk_karyawan | 36 | A | No |
take_home_pay
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_take_home_pay (Primary) | int(11) | No | ||||
| no_karyawan | int(11) | Yes | NULL | |||
| id_karyawan | int(11) | Yes | NULL | |||
| kode_unit | int(11) | Yes | NULL | |||
| bulan | int(11) | Yes | NULL | |||
| tahun | date | Yes | NULL | |||
| gaji_pokok | varchar(100) | Yes | NULL | |||
| tunjangan_jabatan | varchar(100) | Yes | NULL | |||
| tunjangan_masa_kerja | varchar(100) | Yes | NULL | |||
| tunjangan_pendidikan | varchar(100) | Yes | NULL | |||
| tunjangan_insentif | varchar(100) | Yes | NULL | |||
| tunjangan_lain_lain | varchar(100) | Yes | NULL | |||
| jumlah_gaji | varchar(100) | Yes | NULL | |||
| potongan_jamsostek | varchar(100) | Yes | NULL | |||
| potongan_bpjs | varchar(100) | Yes | NULL | |||
| potongan_dana_pensiun | varchar(100) | Yes | NULL | |||
| potongan_ppn | varchar(100) | Yes | NULL | |||
| potongan_lain_lain | varchar(100) | Yes | NULL | |||
| presentase_thp | varchar(100) | Yes | NULL | |||
| jumlah_thp | varchar(100) | Yes | NULL | |||
| saldo_potongan | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_take_home_pay | 1566 | A | No |
tanggal_libur
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_tanggal_libur (Primary) | int(11) | No | ||||
| mulai_libur | date | No | ||||
| akhir_libur | date | No | ||||
| keterangan | varchar(500) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_tanggal_libur | 66 | A | No |
tbl_pln
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| idpel | varchar(50) | No | ||||
| nama_pel | varchar(50) | No | ||||
| status | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 16 | A | No |
thp
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_take_home_pay (Primary) | int(11) | No | ||||
| no_karyawan | int(11) | No | ||||
| id_karyawan | int(11) | No | ||||
| bulan | int(11) | No | ||||
| tahun | year(4) | No | ||||
| jumlah_gaji | double | No | ||||
| potongan_bpjs_tk | double | No | ||||
| potongan_bpjs_kes | double | No | ||||
| potongan_dana_pensiun | double | No | ||||
| potongan_pph | double | No | ||||
| potongan_sp | double | No | ||||
| potongan_espe_pay | double | No | ||||
| potongan_swa_pinjaman | double | No | ||||
| potongan_swa_tabungan | double | No | ||||
| potongan_induk | double | No | ||||
| potongan_lain_lain | double | No | ||||
| potongan_pln | double | No | ||||
| potongan_pu | double | No | ||||
| jumlah_potongan_fix | double | No | bpjs - pph | |||
| jumlah_potongan_tambahan | double | No | sp - pu | |||
| jumlah_potongan_total | double | No | ||||
| jumlah_thp | double | No | ||||
| status | int(11) | No | 0 = belum valid / 1 = inisialisasi / 2 = fix thp |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_take_home_pay | 375 | A | No |
unit
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_unit (Primary) | int(11) | No | ||||
| nama_unit | varchar(255) | No | ||||
| kode_unit | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_unit | 14 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_user (Primary) | int(11) | No | ||||
| nama_user | varchar(255) | No | ||||
| password | varchar(255) | No | ||||
| username | varchar(100) | No | ||||
| id_unit | int(11) | No | unit -> id_unit | |||
| level | varchar(20) | No | ||||
| aktif | enum('Y', 'N') | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_user | 24 | A | No | |
| id_unit | BTREE | No | No | id_unit | 24 | A | No |