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;