· 6 years ago · Dec 24, 2019, 05:06 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 8.0.18 - MySQL Community Server - GPL
4-- Server OS: Win64
5-- HeidiSQL Version: 10.2.0.5752
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for prj_antrian
16DROP DATABASE IF EXISTS `prj_antrian`;
17CREATE DATABASE IF NOT EXISTS `prj_antrian` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;
18USE `prj_antrian`;
19
20-- Dumping structure for table prj_antrian.tbl_antrian
21DROP TABLE IF EXISTS `tbl_antrian`;
22CREATE TABLE IF NOT EXISTS `tbl_antrian` (
23 `id_antrian` int(11) NOT NULL AUTO_INCREMENT,
24 `tanggal` date NOT NULL,
25 `id_satker` int(11) NOT NULL DEFAULT '0',
26 `id_loket` int(1) NOT NULL DEFAULT '0',
27 `code_layanan` varchar(6) NOT NULL COMMENT 'Code Random 6 digit',
28 `ts1` timestamp NOT NULL COMMENT 'TimeStamp Cetak Antrian',
29 `ts2` timestamp NULL DEFAULT NULL COMMENT 'TimeStamp Panggil Antrian',
30 `ts3` timestamp NULL DEFAULT NULL COMMENT 'TimeStamp Selesai Layanan',
31 `status` varchar(1) NOT NULL COMMENT '0: belum dipanggil, 1: dalam layanan, 2: selesai',
32 `lampiran1` varchar(255) DEFAULT NULL,
33 `lampiran2` varchar(255) DEFAULT NULL,
34 PRIMARY KEY (`id_antrian`)
35) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
36
37-- Dumping data for table prj_antrian.tbl_antrian: ~0 rows (approximately)
38/*!40000 ALTER TABLE `tbl_antrian` DISABLE KEYS */;
39REPLACE INTO `tbl_antrian` (`id_antrian`, `tanggal`, `id_satker`, `id_loket`, `code_layanan`, `ts1`, `ts2`, `ts3`, `status`, `lampiran1`, `lampiran2`) VALUES
40 (1, '2019-12-24', 1, 1, '', '2019-12-24 21:24:58', NULL, NULL, '', 'Surat Jalan', '1 Lembar'),
41 (2, '2019-12-24', 3, 2, '', '2019-12-24 21:26:21', NULL, NULL, '', 'Dokumen', '2 Lembar');
42/*!40000 ALTER TABLE `tbl_antrian` ENABLE KEYS */;
43
44-- Dumping structure for table prj_antrian.tbl_kepuasan
45DROP TABLE IF EXISTS `tbl_kepuasan`;
46CREATE TABLE IF NOT EXISTS `tbl_kepuasan` (
47 `id_penilaian` int(11) NOT NULL AUTO_INCREMENT,
48 `tgl_penilaian` date NOT NULL,
49 `id_antrian` int(11) NOT NULL DEFAULT '0',
50 `id_satker` int(6) NOT NULL,
51 `nilai` int(1) NOT NULL,
52 PRIMARY KEY (`id_penilaian`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
54
55-- Dumping data for table prj_antrian.tbl_kepuasan: ~0 rows (approximately)
56/*!40000 ALTER TABLE `tbl_kepuasan` DISABLE KEYS */;
57/*!40000 ALTER TABLE `tbl_kepuasan` ENABLE KEYS */;
58
59-- Dumping structure for table prj_antrian.tbl_loket
60DROP TABLE IF EXISTS `tbl_loket`;
61CREATE TABLE IF NOT EXISTS `tbl_loket` (
62 `id_loket` int(3) NOT NULL AUTO_INCREMENT,
63 `nama_loket` varchar(128) NOT NULL,
64 `status` char(1) NOT NULL DEFAULT '1',
65 PRIMARY KEY (`id_loket`)
66) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
67
68-- Dumping data for table prj_antrian.tbl_loket: ~0 rows (approximately)
69/*!40000 ALTER TABLE `tbl_loket` DISABLE KEYS */;
70REPLACE INTO `tbl_loket` (`id_loket`, `nama_loket`, `status`) VALUES
71 (1, 'Customer Service', '1'),
72 (2, 'Loket 2', '1'),
73 (3, 'Loket 3', '1'),
74 (4, 'Loket 4', '1');
75/*!40000 ALTER TABLE `tbl_loket` ENABLE KEYS */;
76
77-- Dumping structure for table prj_antrian.tbl_satker
78DROP TABLE IF EXISTS `tbl_satker`;
79CREATE TABLE IF NOT EXISTS `tbl_satker` (
80 `id_satker` int(11) NOT NULL AUTO_INCREMENT,
81 `nama_satker` varchar(128) DEFAULT NULL,
82 `code_ba` varchar(3) DEFAULT NULL,
83 `code_satker` varchar(6) NOT NULL,
84 `status` varchar(1) NOT NULL DEFAULT '1',
85 PRIMARY KEY (`id_satker`)
86) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
87
88-- Dumping data for table prj_antrian.tbl_satker: ~0 rows (approximately)
89/*!40000 ALTER TABLE `tbl_satker` DISABLE KEYS */;
90REPLACE INTO `tbl_satker` (`id_satker`, `nama_satker`, `code_ba`, `code_satker`, `status`) VALUES
91 (1, 'Kejaksaan Negeri Surakarta', '006', '005531', '1'),
92 (2, 'Kejaksaan Negeri Sukoharjo', '006', '005570', '1'),
93 (3, 'Kejaksaan Negeri Wonogiri', '006', '005587', '1');
94/*!40000 ALTER TABLE `tbl_satker` ENABLE KEYS */;
95
96/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
97/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
98/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;