SQLize | PHPize | SQLtest

CREATE TABLE `pegawai` ( `id_pegawai` varchar(20) NOT NULL, `ID_Presensi` varchar(20) NOT NULL, `NAMA` varchar(150) NOT NULL, `NIK` varchar(20) NOT NULL, `ALAMAT` varchar(200) NOT NULL, `NIP` varchar(20) NOT NULL, `NAMA_Tanpa_Gelar` varchar(150) NOT NULL, `Gelar_Depan` varchar(20) NOT NULL, `Gelar_Belakang` varchar(20) NOT NULL, `Agama` varchar(20) NOT NULL, `NO_HP` varchar(20) NOT NULL, `Email_Pribadi` varchar(75) NOT NULL, `Email_Gov` varchar(75) NOT NULL, `Tempat_Lahir` varchar(75) NOT NULL, `NPWP` varchar(25) NOT NULL, `BPJS` varchar(20) NOT NULL, `KARTU_ASN_VIRTUAL` varchar(20) NOT NULL, `NOMOR_SK_CPNS` varchar(20) NOT NULL, `TANGGAL_SK_CPNS` date NOT NULL, `TMT_CPNS` date NOT NULL, `NOMOR_SK_PNS` varchar(20) NOT NULL, `TANGGAL_SK_PNS` date NOT NULL, `TMT_PNS` date NOT NULL, `TGL_LAHIR` date NOT NULL, `GOL` varchar(100) NOT NULL, `GOL_AWAL_NAMA` varchar(100) NOT NULL, `GOL_AKHIR_NAMA` varchar(100) NOT NULL, `TMT_GOLONGAN` date NOT NULL, `JENIS_JABATAN_NAMA` varchar(100) NOT NULL, `JABATAN_NAMA` varchar(100) NOT NULL, `TMT_JABATAN` date NOT NULL, `TINGKAT_PENDIDIKAN_NAMA` varchar(75) NOT NULL, `PENDIDIKAN_NAMA` varchar(100) NOT NULL, `TAHUN_LULUS` varchar(20) NOT NULL, `GAJI_POKOK` varchar(20) NOT NULL, `INSTANSI` varchar(150) NOT NULL, `Status_Kepegawaian` varchar(50) NOT NULL, `Status_Perkawinan` varchar(35) NOT NULL, `Jenis_Kelamin` enum('Laki-laki','Perempuan') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci