text: CREATE TABLE `sms` (
    `id_sms` varchar(255) NOT NULL,
    `nm_lemb` varchar(80) DEFAULT NULL,
    `smt_mulai` varchar(5) DEFAULT NULL,
    `kode_prodi` varchar(10) DEFAULT NULL,
    `kaprodi` varchar(255) DEFAULT NULL,
    `id_sp` varchar(255) DEFAULT NULL,
    `id_jenj_didik` decimal(2,0) DEFAULT NULL,
    `id_jns_sms` decimal(2,0) DEFAULT NULL,
    `id_pengguna` varchar(255) DEFAULT NULL,
    `id_fungsi_lab` varchar(1) DEFAULT NULL,
    `id_kel_usaha` varchar(8) DEFAULT NULL,
    `id_blob` varchar(255) DEFAULT NULL,
    `id_wil` varchar(8) DEFAULT NULL,
    `id_jur` varchar(10) DEFAULT NULL,
    `id_induk_sms` varchar(255) DEFAULT NULL,
    `jln` varchar(80) DEFAULT NULL,
    `rt` decimal(2,0) DEFAULT NULL,
    `rw` decimal(2,0) DEFAULT NULL,
    `nm_dsn` varchar(50) DEFAULT NULL,
    `ds_kel` varchar(50) DEFAULT NULL,
    `kode_pos` varchar(5) DEFAULT NULL,
    `lintang` decimal(10,6) DEFAULT NULL,
    `bujur` decimal(10,6) DEFAULT NULL,
    `no_tel` varchar(20) DEFAULT NULL,
    `no_fax` varchar(20) DEFAULT NULL,
    `email` varchar(50) DEFAULT NULL,
    `website` varchar(100) DEFAULT NULL,
    `singkatan` varchar(50) DEFAULT NULL,
    `tgl_berdiri` date DEFAULT NULL,
    `sk_selenggara` varchar(40) DEFAULT NULL,
    `tgl_sk_selenggara` date DEFAULT NULL,
    `tmt_sk_selenggara` date DEFAULT NULL,
    `tst_sk_selenggara` date DEFAULT NULL,
    `kpst_pd` decimal(5,0) DEFAULT NULL,
    `sks_lulus` decimal(3,0) DEFAULT NULL,
    `gelar_lulusan` varchar(10) DEFAULT NULL,
    `stat_prodi` varchar(1) DEFAULT NULL,
    `polesei_nilai` varchar(1) DEFAULT NULL,
    `luas_lab` decimal(5,0) DEFAULT NULL,
    `kapasitas_prak_satu_shift` decimal(4,0) DEFAULT NULL,
    `jml_mhs_pengguna` decimal(6,0) DEFAULT NULL,
    `jml_jam_penggunaan` decimal(5,1) DEFAULT NULL,
    `jml_prodi_pengguna` decimal(3,0) DEFAULT NULL,
    `jml_modul_prak_sendiri` decimal(4,0) DEFAULT NULL,
    `jml_modul_prak_lain` decimal(4,0) DEFAULT NULL,
    `fungsi_selain_prak` varchar(1) DEFAULT NULL,
    `penggunaan_lab` varchar(1) DEFAULT NULL,
    `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `soft_delete` timestamp NULL DEFAULT NULL,
    `last_sync` timestamp NULL DEFAULT NULL,
    `id_updater` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id_sms`),
    KEY `id_sms` (`id_sms`) USING BTREE,
    KEY `id_jenj_didik` (`id_jenj_didik`) USING BTREE,
    KEY `id_jns_sms` (`id_jns_sms`) USING BTREE,
    KEY `id_jur` (`id_jur`) USING BTREE,
    KEY `fk_sms_satuan_pendidikan_id_sp` (`id_sp`) USING BTREE,
    KEY `fk_sms_wilayah_id_wil` (`id_wil`) USING BTREE,
    KEY `nm_lemb` (`nm_lemb`) USING BTREE,
    KEY `kaprodi` (`kaprodi`),
    CONSTRAINT `sms_ibfk_1` FOREIGN KEY (`id_jns_sms`) REFERENCES `jenis_sms` (`id_jns_sms`) ON DELETE NO ACTION ON UPDATE CASCADE,
    CONSTRAINT `sms_ibfk_2` FOREIGN KEY (`id_jenj_didik`) REFERENCES `jenjang_pendidikan` (`id_jenj_didik`) ON DELETE NO ACTION ON UPDATE CASCADE,
    CONSTRAINT `sms_ibfk_3` FOREIGN KEY (`id_jur`) REFERENCES `jurusan` (`id_jur`) ON DELETE NO ACTION ON UPDATE CASCADE,
    CONSTRAINT `sms_ibfk_4` FOREIGN KEY (`id_sp`) REFERENCES `satuan_pendidikan` (`id_sp`) ON DELETE NO ACTION ON UPDATE CASCADE,
    CONSTRAINT `sms_ibfk_5` FOREIGN KEY (`id_wil`) REFERENCES `wilayah` (`id_wil`) ON DELETE NO ACTION ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='REF';