-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.6.23 - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for db_siperumku_tci3
CREATE DATABASE IF NOT EXISTS `db_siperumku_tci3` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `db_siperumku_tci3`;

-- Dumping structure for table db_siperumku_tci3.tb_administrasi
CREATE TABLE IF NOT EXISTS `tb_administrasi` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `no_surat` varchar(50) NOT NULL DEFAULT '0',
  `id_rumah` varchar(5) DEFAULT NULL,
  `group` varchar(6) DEFAULT NULL,
  `jenis` varchar(20) DEFAULT NULL,
  `keperluan` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `exp_date` varchar(10) DEFAULT NULL,
  `nik` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `no_surat` (`no_surat`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_berita
CREATE TABLE IF NOT EXISTS `tb_berita` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `slug` varchar(50) DEFAULT NULL,
  `judul` varchar(50) DEFAULT NULL,
  `deskripsi` text,
  `image` varchar(50) DEFAULT NULL,
  `group` varchar(50) DEFAULT NULL,
  `editor` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_darurat
CREATE TABLE IF NOT EXISTS `tb_darurat` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nama` varchar(50) DEFAULT NULL,
  `jabatan` varchar(50) DEFAULT NULL,
  `no_hp` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `group` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_data_iuran
CREATE TABLE IF NOT EXISTS `tb_data_iuran` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `id_rumah` varchar(5) DEFAULT NULL,
  `group` varchar(6) DEFAULT NULL,
  `periode` varchar(6) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `bukti_tf` varchar(6) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_dispensasi
CREATE TABLE IF NOT EXISTS `tb_dispensasi` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `id_rumah` varchar(5) NOT NULL DEFAULT '0',
  `alasan` varchar(100) NOT NULL DEFAULT '0',
  `group` varchar(6) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `kategori` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_gallery
CREATE TABLE IF NOT EXISTS `tb_gallery` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nama` varchar(50) DEFAULT NULL,
  `photo` varchar(100) DEFAULT NULL,
  `group` varchar(6) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_global
CREATE TABLE IF NOT EXISTS `tb_global` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `desa` varchar(100) DEFAULT NULL,
  `kecamatan` varchar(100) DEFAULT NULL,
  `kabupaten` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_iuran
CREATE TABLE IF NOT EXISTS `tb_iuran` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nominal` int(11) NOT NULL DEFAULT '0',
  `group` varchar(6) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_kegiatan
CREATE TABLE IF NOT EXISTS `tb_kegiatan` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kegiatan` varchar(50) DEFAULT NULL,
  `deskripsi` text,
  `group` varchar(6) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_kerjabakti
CREATE TABLE IF NOT EXISTS `tb_kerjabakti` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `id_rumah` varchar(5) DEFAULT NULL,
  `group` varchar(6) DEFAULT NULL,
  `periode` varchar(6) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_keuangan
CREATE TABLE IF NOT EXISTS `tb_keuangan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaksi` varchar(100) NOT NULL,
  `kategori` varchar(20) NOT NULL,
  `nominal` decimal(20,0) NOT NULL,
  `id_rumah` varchar(5) NOT NULL,
  `group` varchar(6) DEFAULT NULL,
  `periode` varchar(6) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_nomor_darurat
CREATE TABLE IF NOT EXISTS `tb_nomor_darurat` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `nama` varchar(50) DEFAULT NULL,
  `instansi` varchar(50) DEFAULT NULL,
  `jabatan` varchar(50) DEFAULT NULL,
  `hanpdhone` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_pengurus
CREATE TABLE IF NOT EXISTS `tb_pengurus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_rumah` varchar(50) NOT NULL DEFAULT '0',
  `jabatan` varchar(50) NOT NULL DEFAULT '0',
  `tupoksi` varchar(500) NOT NULL DEFAULT '0',
  `group` varchar(6) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `sorting` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_ronda
CREATE TABLE IF NOT EXISTS `tb_ronda` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `id_rumah` varchar(5) NOT NULL DEFAULT '0',
  `group` varchar(6) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `periode` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_slider
CREATE TABLE IF NOT EXISTS `tb_slider` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `photo` varchar(250) DEFAULT NULL,
  `nama` varchar(250) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_umkm
CREATE TABLE IF NOT EXISTS `tb_umkm` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `nama_produk` varchar(150) DEFAULT NULL,
  `id_toko` varchar(50) DEFAULT NULL,
  `nama_usaha` varchar(50) DEFAULT NULL,
  `harga` int(7) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_user
CREATE TABLE IF NOT EXISTS `tb_user` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_rumah` varchar(10) DEFAULT NULL,
  `password` varchar(8) DEFAULT NULL,
  `access` varchar(15) DEFAULT NULL,
  `hash_password` varchar(200) NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `group` varchar(10) DEFAULT NULL,
  `korlap` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Column 2` (`id_rumah`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table db_siperumku_tci3.tb_warga
CREATE TABLE IF NOT EXISTS `tb_warga` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `no_kk` varchar(16) DEFAULT NULL,
  `nik` varchar(16) DEFAULT NULL,
  `nama` varchar(100) DEFAULT NULL,
  `rw` varchar(3) DEFAULT NULL,
  `rt` varchar(3) DEFAULT NULL,
  `dusun` varchar(30) DEFAULT NULL,
  `alamat` varchar(300) DEFAULT NULL,
  `domisili` varchar(300) DEFAULT NULL,
  `sex` varchar(20) DEFAULT NULL,
  `tmp_lahir` varchar(100) DEFAULT NULL,
  `tgl_lahir` varchar(10) DEFAULT NULL,
  `agama_id` varchar(20) DEFAULT NULL,
  `pendidikan_kk_id` varchar(100) DEFAULT NULL,
  `pendidikan_sedang_id` varchar(100) DEFAULT NULL,
  `pekerjaan_id` varchar(100) DEFAULT NULL,
  `status_kawin_id` varchar(100) DEFAULT NULL,
  `kk_level` varchar(20) DEFAULT NULL,
  `wn_status` varchar(100) DEFAULT NULL,
  `ayah_nik` varchar(16) DEFAULT NULL,
  `nama_ayah` varchar(100) DEFAULT NULL,
  `ibu_nik` varchar(16) DEFAULT NULL,
  `nama_ibu` varchar(16) DEFAULT NULL,
  `gol_darah` varchar(16) DEFAULT NULL,
  `no_akta_lahir` varchar(20) DEFAULT NULL,
  `doc_paspor` varchar(20) DEFAULT NULL,
  `tgl_akhir_paspor` varchar(10) DEFAULT NULL,
  `doc_kitas` varchar(20) DEFAULT NULL,
  `akta_kawin` varchar(20) DEFAULT NULL,
  `tgl_kawin` varchar(10) DEFAULT NULL,
  `akta_cerai` varchar(20) DEFAULT NULL,
  `tgl_cerai` varchar(10) DEFAULT NULL,
  `cacat_id` varchar(20) DEFAULT NULL,
  `cara_kb_id` varchar(20) DEFAULT NULL,
  `hamil` varchar(30) DEFAULT NULL,
  `ktp_el` varchar(30) DEFAULT NULL,
  `status_rekam` varchar(30) DEFAULT NULL,
  `status_dasar` varchar(30) DEFAULT NULL,
  `suku` varchar(30) DEFAULT NULL,
  `tag_id_card` varchar(30) DEFAULT NULL,
  `id_asuransi` varchar(50) DEFAULT NULL,
  `no_asuransi` varchar(30) DEFAULT NULL,
  `lat` varchar(30) DEFAULT NULL,
  `ing` varchar(30) DEFAULT NULL,
  `id_user` varchar(30) DEFAULT NULL,
  `handphone` varchar(13) DEFAULT NULL,
  `status_ktp` varchar(20) DEFAULT NULL,
  `jamkesnas` varchar(5) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `group` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nik` (`nik`)
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
