1Rcsz8wy

1DROP TABLE IF EXISTS `data_ormas`;
2CREATE TABLE `data_ormas` (
3  `id` bigint(20) unsigned NOT NULL,
4  `no_akte` varchar(50) NOT NULL,
5  `nama_ormas` varchar(255) NOT NULL,
6  `alamat` text NOT NULL,
7  `ketua` varchar(255) DEFAULT NULL,
8  `ormas_afiliasi` varchar(255) NOT NULL COMMENT 'Relasi ke master kabupaten',
9  `kode_pendidikan` varchar(10) NOT NULL COMMENT 'Relasi ke master pendidikan',
10  `status_data` int(1) NOT NULL COMMENT 'Relasi ke master status data',
11  `acc_kankemenag` varchar(100) NOT NULL,
12  `acc_kanwil` varchar(100) NOT NULL,
13  `acc_pusat` varchar(100) NOT NULL,
14  `created_by` varchar(100) NOT NULL,
15  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
16  `updated_by` varchar(100) NOT NULL,
17  `updated_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
18  `kode_satker` varchar(20) NOT NULL,
19  `kode_agama` int(1) unsigned NOT NULL DEFAULT '0',
20  `kode_kab` char(4) DEFAULT NULL
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;