|
id
|
INT
|
|
|
|
|
user_id
|
INT
|
|
|
|
|
nik_ktp
|
varchar(16)
|
utf8mb4_unicode_ci
|
|
|
|
nik_rs
|
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
|
gelar_depan
|
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
|
gelar_belakang
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
tempat_lahir
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
tgl_lahir
|
date
|
|
|
|
|
jenis_kelamin
|
enum('L', 'P')
|
utf8mb4_unicode_ci
|
|
|
|
golongan_darah
|
enum('A', 'B', 'AB', 'O', 'A+', 'A-', 'B+', 'B-', 'AB+', 'AB-', 'O+', 'O-')
|
utf8mb4_unicode_ci
|
|
|
|
agama
|
enum('Islam', 'Kristen Protestan', 'Kristen Katolik', 'Hindu', 'Buddha', 'Konghucu')
|
utf8mb4_unicode_ci
|
|
|
|
status_pernikahan
|
enum('Belum Menikah', 'Menikah', 'Cerai Hidup', 'Cerai Mati')
|
utf8mb4_unicode_ci
|
|
|
|
jumlah_anak
|
INT
|
|
|
|
|
kewarganegaraan
|
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
|
suku
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
no_ktp
|
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
|
no_hp
|
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
|
no_hp_darurat
|
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
|
kontak_darurat
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
hubungan_darurat
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
email_pribadi
|
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
|
alamat_ktp
|
text
|
utf8mb4_unicode_ci
|
|
|
|
kelurahan_ktp
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
kecamatan_ktp
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
kota_ktp
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
provinsi_ktp
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
kode_pos_ktp
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
alamat_domisili
|
text
|
utf8mb4_unicode_ci
|
|
|
|
kota_domisili
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
pendidikan_terakhir
|
enum('SD', 'SMP', 'SMA/SMK', 'D1', 'D3', 'D4', 'S1', 'S2', 'S3', 'Profesi', 'Spesialis', 'Sub-Spesialis')
|
utf8mb4_unicode_ci
|
|
|
|
jurusan
|
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
|
universitas
|
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
|
tahun_lulus
|
year(4)
|
|
|
|
|
jabatan_id
|
INT
|
|
|
|
|
divisi
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
unit_kerja
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
jenis_karyawan
|
enum('Medis', 'Non-Medis', 'Penunjang Medis')
|
utf8mb4_unicode_ci
|
|
|
|
jenis_tenaga
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
status_kepegawaian
|
enum('Tetap', 'Kontrak', 'Honorer', 'Magang', 'PPPK', 'Outsourcing')
|
utf8mb4_unicode_ci
|
|
|
|
tgl_masuk
|
date
|
|
|
|
|
tgl_kontrak_mulai
|
date
|
|
|
|
|
tgl_kontrak_selesai
|
date
|
|
|
|
|
tgl_pengangkatan
|
date
|
|
|
|
|
masa_kerja_tahun
|
INT
|
|
|
|
|
no_bpjs_kes
|
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
|
no_bpjs_tk
|
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
|
no_npwp
|
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
|
no_rekening
|
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
|
bank
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
atas_nama_rek
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
no_str
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
tgl_terbit_str
|
date
|
|
|
|
|
tgl_exp_str
|
date
|
|
|
|
|
no_sip
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
tgl_terbit_sip
|
date
|
|
|
|
|
tgl_exp_sip
|
date
|
|
|
|
|
no_sik
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
tgl_exp_sik
|
date
|
|
|
|
|
spesialisasi
|
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
|
sub_spesialisasi
|
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
|
kompetensi
|
text
|
utf8mb4_unicode_ci
|
|
|
|
status
|
enum('aktif', 'nonaktif', 'cuti', 'resign', 'pensiun')
|
utf8mb4_unicode_ci
|
|
|
|
tgl_resign
|
date
|
|
|
|
|
alasan_resign
|
text
|
utf8mb4_unicode_ci
|
|
|
|
catatan
|
text
|
utf8mb4_unicode_ci
|
|
|
|
foto
|
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
|
updated_by
|
INT
|
|
|
|
|
created_at
|
datetime
|
|
|
|
|
updated_at
|
datetime
|
|
|
|
