· 3 years ago · Sep 26, 2022, 06:00 PM
1-- MySQL dump 10.16 Distrib 10.1.37-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: jemaat
4-- ------------------------------------------------------
5-- Server version 10.1.37-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `admin`
20--
21
22DROP TABLE IF EXISTS `admin`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `admin` (
26 `id_admin` int(10) unsigned NOT NULL AUTO_INCREMENT,
27 `username` varchar(255) NOT NULL,
28 `sandi` varchar(255) NOT NULL,
29 `nama` varchar(255) NOT NULL,
30 `super_admin` tinyint(3) unsigned DEFAULT '0',
31 PRIMARY KEY (`id_admin`)
32) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `admin`
37--
38
39LOCK TABLES `admin` WRITE;
40/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
41INSERT INTO `admin` VALUES (3,'donnisnoni','$2b$04$GvxoqRTIevm4LS/.6xcuvuHye1KxpORLycsEVAwlKCCIow9TEzcR2','admin',1);
42/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `anggota_kk`
47--
48
49DROP TABLE IF EXISTS `anggota_kk`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `anggota_kk` (
53 `id_anggota_kk` int(10) unsigned NOT NULL AUTO_INCREMENT,
54 `id_kk` int(10) unsigned NOT NULL,
55 `nama` varchar(255) NOT NULL,
56 `jk` enum('L','P') NOT NULL,
57 `tempat_lahir` varchar(255) NOT NULL,
58 `tanggal_lahir` date NOT NULL,
59 `status` enum('Suami','Istri','Anak','Saudara Kandung','Saudara Ipar','Orang Tua','Mertua','Lainnya') NOT NULL,
60 `golongan_darah` enum('A','B','AB','O') NOT NULL,
61 `sudah_baptis` tinyint(4) NOT NULL,
62 `tanggal_baptis` date DEFAULT NULL,
63 `tempat_baptis` varchar(255) DEFAULT NULL,
64 `nama_pelayan_baptis` varchar(255) DEFAULT NULL,
65 `sudah_sidi` tinyint(4) NOT NULL,
66 `tanggal_sidi` date DEFAULT NULL,
67 `tempat_sidi` varchar(255) DEFAULT NULL,
68 `nama_pelayan_sidi` varchar(255) DEFAULT NULL,
69 `sudah_nikah` tinyint(4) NOT NULL,
70 `tanggal_nikah` date DEFAULT NULL,
71 `tempat_nikah` varchar(255) DEFAULT NULL,
72 `nama_pelayan_nikah` varchar(255) DEFAULT NULL,
73 `pendidikan` enum('Tidak/Belum Sekolah','PAUD/TK','SD','SMP','SMA','D2','D3','S1/D4','S2','S3') NOT NULL,
74 `kedudukan_di_jemaat` enum('Jemaat','Jemaat Tamu','Diaken','Penatua','Pendeta') NOT NULL,
75 `pekerjaan` enum('Tidak/Belum Ada','Pendeta','PNS','Pegawai Swasta','Wirawasta','TNI/Polri','Dokter','Bidan','Perawat','Apoteker','Pensiunan','Petani','Pembantu Rumah Tangga','Sopir','Tukang','Buruh','Pegawai Gereja','Pelajar','Mahasiswa','Pedagang','Ibu Rumah Tangga','Pegawai Kontrak/Honor','Lainnya') NOT NULL,
76 `penghasilan` enum('Tidak Ada','sd. Rp. 750.000','Rp. 750.000 - Rp. 1.500.000','Rp. 1.500.000 - Rp. 2.500.000','Rp. 2.500.000 - Rp. 5.000.000','> Rp. 5.000.000') NOT NULL,
77 `jaminan_kesehatan` enum('Tidak Ada','BPJS/ASKES','Asuransi Lain') NOT NULL,
78 `keterangan` enum('Tidak Ada','Janda','Duda','Yatim/Piatu','Penyandang Cacat') NOT NULL,
79 `tgl_buat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
80 `tgl_terakhir_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
81 PRIMARY KEY (`id_anggota_kk`),
82 KEY `id_kk` (`id_kk`),
83 CONSTRAINT `anggota_kk_ibfk_1` FOREIGN KEY (`id_kk`) REFERENCES `kepala_keluarga` (`id_kk`) ON DELETE NO ACTION ON UPDATE CASCADE
84) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `anggota_kk`
89--
90
91LOCK TABLES `anggota_kk` WRITE;
92/*!40000 ALTER TABLE `anggota_kk` DISABLE KEYS */;
93INSERT INTO `anggota_kk` VALUES (7,15,'Don Nisnoni','L','Kupang','1994-09-18','Suami','AB',1,'1997-11-19','Gereja Sion','Markus Banusu',1,'2015-05-06','Gereja Koinonia','Alex Iga',1,'2019-06-11','Gereja Koinonia','Alex Iga','D3','Jemaat','Pegawai Swasta','Rp. 2.500.000 - Rp. 5.000.000','Asuransi Lain','Yatim/Piatu','2022-09-26 14:41:19','2022-09-26 14:41:19'),(8,15,'Septyana Florence Balla','P','Kupang','1994-09-18','Istri','B',1,'1996-07-16','Gereja Sion','Markus Banusu',1,'2011-01-07','Gereja Koinonia','Alex Iga',0,NULL,NULL,NULL,'S1/D4','Jemaat','Bidan','Rp. 1.500.000 - Rp. 2.500.000','BPJS/ASKES','Tidak Ada','2022-09-26 14:41:19','2022-09-26 14:41:19'),(9,15,'Andi Kore','L','Sabu','2005-01-13','Anak','O',1,'2009-01-15','GMIT Ebenhezer Sabu','Simon Gaek',1,'2015-01-30','GMIT Ebenhezer Sabu','Simon Gaek',0,NULL,NULL,NULL,'SMA','Jemaat','Mahasiswa','Tidak Ada','Asuransi Lain','Tidak Ada','2022-09-26 14:41:19','2022-09-26 14:41:19'),(10,16,'Ariel Dillak','L','Rote','1995-01-14','Anak','B',0,'2022-09-26',NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,'S2','Jemaat','Dokter','Rp. 750.000 - Rp. 1.500.000','BPJS/ASKES','Tidak Ada','2021-01-14 12:53:44','2021-01-14 12:53:44'),(13,16,'Ignasius Levi','P','Rote','2021-01-28','Anak','A',0,NULL,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,'Tidak/Belum Sekolah','Jemaat','Tidak/Belum Ada','Tidak Ada','Tidak Ada','Tidak Ada','2021-01-14 12:53:44','2021-01-14 12:53:44'),(14,16,'Xilong Sinatra','L','Kupang','2020-12-29','Anak','A',0,NULL,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,'Tidak/Belum Sekolah','Jemaat','Tidak/Belum Ada','Tidak Ada','Tidak Ada','Tidak Ada','2021-01-14 12:58:34','2021-01-14 12:58:34'),(15,16,'El Nino','P','Rote','2021-01-11','Suami','A',0,NULL,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,'Tidak/Belum Sekolah','Jemaat','Tidak/Belum Ada','Tidak Ada','Tidak Ada','Tidak Ada','2021-01-14 12:58:34','2021-01-14 12:58:34');
94/*!40000 ALTER TABLE `anggota_kk` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `kepala_keluarga`
99--
100
101DROP TABLE IF EXISTS `kepala_keluarga`;
102/*!40101 SET @saved_cs_client = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `kepala_keluarga` (
105 `id_kk` int(10) unsigned NOT NULL AUTO_INCREMENT,
106 `id_rayon` int(10) unsigned NOT NULL,
107 `nama` varchar(255) NOT NULL,
108 `alamat` varchar(255) NOT NULL,
109 `status_nikah` enum('Belum Menikah/Bujang','Nikah Gereja','Belum Nikah Gereja','Duda Janda') NOT NULL,
110 `no_hp` varchar(255) NOT NULL,
111 `kategori_rumah` enum('Permanen','Semi Permanen','Darurat','Lainnya') NOT NULL,
112 `status_rumah` enum('Milik Sendiri','Kontrak','Menumpang','Lainnya') NOT NULL,
113 `tgl_buat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
114 `tgl_terakhir_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
115 PRIMARY KEY (`id_kk`),
116 KEY `id_rayon` (`id_rayon`),
117 CONSTRAINT `kepala_keluarga_ibfk_1` FOREIGN KEY (`id_rayon`) REFERENCES `rayon` (`id_rayon`) ON DELETE NO ACTION ON UPDATE CASCADE
118) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `kepala_keluarga`
123--
124
125LOCK TABLES `kepala_keluarga` WRITE;
126/*!40000 ALTER TABLE `kepala_keluarga` DISABLE KEYS */;
127INSERT INTO `kepala_keluarga` VALUES (15,1,'Don Nisnoni','Amnesi','Nikah Gereja','1111111111111111','Permanen','Milik Sendiri','2022-09-26 14:41:19','2022-09-26 14:41:19'),(16,8,'El Nino','USA','Nikah Gereja','222222222222222','Permanen','Milik Sendiri','2021-01-14 12:58:34','2021-01-14 12:58:34');
128/*!40000 ALTER TABLE `kepala_keluarga` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `mutasi`
133--
134
135DROP TABLE IF EXISTS `mutasi`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `mutasi` (
139 `id_mutasi` int(11) unsigned NOT NULL,
140 `id_anggota_kk` int(11) unsigned NOT NULL,
141 `tipe_mutasi` enum('Meninggal Dunia','Pindah Jemaat') NOT NULL DEFAULT 'Pindah Jemaat',
142 `tanggal` date NOT NULL,
143 `keterangan` varchar(50) DEFAULT NULL,
144 PRIMARY KEY (`id_mutasi`) USING BTREE,
145 KEY `FK_ANGGOTA_KK2` (`id_anggota_kk`),
146 CONSTRAINT `FK_ANGGOTA_KK2` FOREIGN KEY (`id_anggota_kk`) REFERENCES `anggota_kk` (`id_anggota_kk`) ON UPDATE CASCADE
147) ENGINE=InnoDB DEFAULT CHARSET=latin1;
148/*!40101 SET character_set_client = @saved_cs_client */;
149
150--
151-- Dumping data for table `mutasi`
152--
153
154LOCK TABLES `mutasi` WRITE;
155/*!40000 ALTER TABLE `mutasi` DISABLE KEYS */;
156/*!40000 ALTER TABLE `mutasi` ENABLE KEYS */;
157UNLOCK TABLES;
158
159--
160-- Table structure for table `rayon`
161--
162
163DROP TABLE IF EXISTS `rayon`;
164/*!40101 SET @saved_cs_client = @@character_set_client */;
165/*!40101 SET character_set_client = utf8 */;
166CREATE TABLE `rayon` (
167 `id_rayon` int(10) unsigned NOT NULL AUTO_INCREMENT,
168 `nama` varchar(255) NOT NULL,
169 `tgl_buat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
170 `tgl_terakhir_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
171 PRIMARY KEY (`id_rayon`)
172) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `rayon`
177--
178
179LOCK TABLES `rayon` WRITE;
180/*!40000 ALTER TABLE `rayon` DISABLE KEYS */;
181INSERT INTO `rayon` VALUES (1,'Kasih','2020-09-05 19:28:47','2020-12-21 12:32:21'),(2,'Sukacita','2020-12-13 13:28:43','2020-12-21 15:04:39'),(3,'Damai Sejahtera','2020-12-13 13:29:03','2020-12-21 15:04:52'),(4,'Kesabaran','2020-12-13 13:29:18','2020-12-21 15:04:55'),(5,'Kemurahan','2020-12-13 13:31:40','2020-12-21 15:04:58'),(6,'Kebaikan','2021-01-07 00:11:41','2021-01-07 00:11:41'),(7,'Kesetiaan','2020-12-13 13:32:00','2020-12-21 15:05:07'),(8,'Kelemahlembutan','2020-12-13 13:32:37','2020-12-21 15:05:21'),(9,'Another Rayon','2022-09-26 14:43:11','2022-09-26 14:43:11'),(10,'Dfdfdjhfd','2022-09-26 17:25:23','2022-09-26 17:25:23');
182/*!40000 ALTER TABLE `rayon` ENABLE KEYS */;
183UNLOCK TABLES;
184/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
185
186/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
187/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
188/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
189/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
190/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
191/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
192/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
193
194-- Dump completed on 2022-09-27 1:46:29
195