Print view - phpMyAdmin 4.5.1

aspek_penilaian_kinerja

Column	Type	Null	Default	Links to	Comments

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Open new phpMyAdmin window