· 6 years ago · Mar 15, 2019, 08:42 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.25-0ubuntu0.18.04.2 - (Ubuntu)
4-- Server OS: Linux
5-- HeidiSQL Version: 10.1.0.5464
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-- Dumping structure for table yarsi_nita_ukm.auth_assignment
15CREATE TABLE IF NOT EXISTS `auth_assignment` (
16 `item_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
17 `user_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
18 `created_at` int(11) DEFAULT NULL,
19 PRIMARY KEY (`item_name`,`user_id`),
20 CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
21) ENGINE=InnoDB DEFAULT CHARSET=utf8;
22
23-- Data exporting was unselected.
24-- Dumping structure for table yarsi_nita_ukm.auth_item
25CREATE TABLE IF NOT EXISTS `auth_item` (
26 `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
27 `type` smallint(6) NOT NULL,
28 `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
29 `rule_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
30 `data` blob,
31 `created_at` int(11) DEFAULT NULL,
32 `updated_at` int(11) DEFAULT NULL,
33 PRIMARY KEY (`name`),
34 KEY `rule_name` (`rule_name`),
35 KEY `idx-auth_item-type` (`type`),
36 CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38
39-- Data exporting was unselected.
40-- Dumping structure for table yarsi_nita_ukm.auth_item_child
41CREATE TABLE IF NOT EXISTS `auth_item_child` (
42 `parent` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
43 `child` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
44 PRIMARY KEY (`parent`,`child`),
45 KEY `child` (`child`),
46 CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
47 CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
48) ENGINE=InnoDB DEFAULT CHARSET=utf8;
49
50-- Data exporting was unselected.
51-- Dumping structure for table yarsi_nita_ukm.auth_rule
52CREATE TABLE IF NOT EXISTS `auth_rule` (
53 `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
54 `data` blob,
55 `created_at` int(11) DEFAULT NULL,
56 `updated_at` int(11) DEFAULT NULL,
57 PRIMARY KEY (`name`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60-- Data exporting was unselected.
61-- Dumping structure for table yarsi_nita_ukm.configuration
62CREATE TABLE IF NOT EXISTS `configuration` (
63 `id` int(11) NOT NULL AUTO_INCREMENT,
64 `key` varchar(50) NOT NULL,
65 `value` longtext,
66 PRIMARY KEY (`id`),
67 KEY `key` (`key`)
68) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Configuration the app such as title, logo and etc';
69
70-- Data exporting was unselected.
71-- Dumping structure for table yarsi_nita_ukm.fakultas
72CREATE TABLE IF NOT EXISTS `fakultas` (
73 `id` int(11) NOT NULL AUTO_INCREMENT,
74 `nama` varchar(255) NOT NULL,
75 `parent_id` int(11) DEFAULT NULL,
76 PRIMARY KEY (`id`),
77 KEY `parent_id` (`parent_id`),
78 CONSTRAINT `FK_fakultas_fakultas` FOREIGN KEY (`parent_id`) REFERENCES `fakultas` (`id`)
79) ENGINE=InnoDB DEFAULT CHARSET=utf8;
80
81-- Data exporting was unselected.
82-- Dumping structure for table yarsi_nita_ukm.promosi_cek
83CREATE TABLE IF NOT EXISTS `promosi_cek` (
84 `proposal_id` int(11) NOT NULL,
85 `nama` int(11) NOT NULL,
86 `result` bit(1) NOT NULL DEFAULT b'0',
87 `jumlah` bit(1) DEFAULT NULL,
88 `keterangan` text,
89 `tipe` varchar(50) NOT NULL COMMENT '1. pengajuan peminjaman barang, 2. permohonan tambahan perlengkapan, 3. catatan',
90 `created_at` int(11) NOT NULL,
91 KEY `proposal_id` (`proposal_id`),
92 CONSTRAINT `FK_cek_promosi_proposal` FOREIGN KEY (`proposal_id`) REFERENCES `proposal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
93) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Form Pengecekan Permohonan Alat Promosi';
94
95-- Data exporting was unselected.
96-- Dumping structure for table yarsi_nita_ukm.proposal
97CREATE TABLE IF NOT EXISTS `proposal` (
98 `id` int(11) NOT NULL AUTO_INCREMENT,
99 `user_id` int(11) NOT NULL,
100 `nama_instansi` varchar(50) NOT NULL COMMENT 'nama fakultas / organisasi',
101 `posisi` varchar(50) NOT NULL COMMENT 'Posisi di kegiatan ini',
102 `nama_kegiatan` text NOT NULL COMMENT 'nama acara / kegiatan',
103 `waktu_dimulai` datetime NOT NULL,
104 `waktu_selesai` datetime NOT NULL,
105 `jumlah_peserta` int(11) NOT NULL,
106 `upload_proposal` varchar(255) NOT NULL COMMENT 'proposal yang di upload mahasiswa',
107 `no_dokumen` varchar(50) NOT NULL,
108 `keputusan` varchar(50) DEFAULT NULL,
109 `tanggal_keputusan` date DEFAULT NULL COMMENT '1: disetujui, 2: disetujui dengan perbaikan proposal, 3: tidak disetujui',
110 `mou` json DEFAULT NULL,
111 `created_at` int(11) NOT NULL COMMENT 'waktu proposal insert ke database',
112 PRIMARY KEY (`id`),
113 KEY `user_id` (`user_id`),
114 CONSTRAINT `FK_proposal_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
115) ENGINE=InnoDB DEFAULT CHARSET=utf8;
116
117-- Data exporting was unselected.
118-- Dumping structure for table yarsi_nita_ukm.proposal_verifikasi
119CREATE TABLE IF NOT EXISTS `proposal_verifikasi` (
120 `proposal_id` int(11) NOT NULL,
121 `lembar_pengesahan` bit(1) NOT NULL DEFAULT b'0',
122 `design` bit(1) NOT NULL DEFAULT b'0' COMMENT 'design poster / banner / spanduk / baju / dll',
123 `cv_pembicara_dari_luar` bit(1) NOT NULL DEFAULT b'0',
124 `rundown_kegiatan_acara` bit(1) NOT NULL DEFAULT b'0',
125 `surat_pengantar_kegiatan` bit(1) NOT NULL DEFAULT b'0' COMMENT 'khusus senat mahasiswa',
126 `rincian_anggaran` bit(1) NOT NULL DEFAULT b'0',
127 `anggaran_yang_dibutuhkan` int(12) NOT NULL,
128 `tor` bit(1) NOT NULL DEFAULT b'0' COMMENT 'khusus senat mahasiswa',
129 `denah_map` bit(1) NOT NULL DEFAULT b'0' COMMENT 'Denah / Map khusus kegiatan diluar kampus',
130 `denah_ruangan` bit(1) NOT NULL DEFAULT b'0',
131 `surat_pengajuan_peminjaman_ruangan` bit(1) NOT NULL DEFAULT b'0' COMMENT 'surat_pengajuan_peminjaman_ruangan',
132 `foto_ruangan` bit(1) NOT NULL DEFAULT b'0',
133 `ruangan` varchar(255) NOT NULL,
134 `undangan` bit(1) NOT NULL DEFAULT b'0',
135 PRIMARY KEY (`proposal_id`),
136 CONSTRAINT `FK_proposal_verifikasi_proposal` FOREIGN KEY (`proposal_id`) REFERENCES `proposal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
137) ENGINE=InnoDB DEFAULT CHARSET=utf8;
138
139-- Data exporting was unselected.
140-- Dumping structure for table yarsi_nita_ukm.route
141CREATE TABLE IF NOT EXISTS `route` (
142 `name` varchar(65) NOT NULL,
143 `alias` varchar(65) DEFAULT NULL,
144 `type` varchar(65) DEFAULT NULL,
145 `status` smallint(6) NOT NULL DEFAULT '1',
146 PRIMARY KEY (`name`)
147) ENGINE=InnoDB DEFAULT CHARSET=utf8;
148
149-- Data exporting was unselected.
150-- Dumping structure for table yarsi_nita_ukm.ruangan_cek
151CREATE TABLE IF NOT EXISTS `ruangan_cek` (
152 `proposal_id` int(11) NOT NULL,
153 `user_id` int(11) NOT NULL,
154 `catatan` text,
155 `menyetujui` text COMMENT 'Menyetujui (REKTOR & DPT) | Isinya data JSON {"rektor":{"nama":"REKTOR","tanggal_disetujui":"26 Jan 2019"},"dpt":{"nama":"DPT","tanggal_disetujui":"20 Jan 2019"}}',
156 `peminjam` text COMMENT 'Peminjam(REKTOR & DPT) | Isinya data JSON --- {"nama":"PEMINJAM","tanggal_disetujui":"20 Jan 2019"}',
157 `mou` json DEFAULT NULL,
158 `created_at` int(11) NOT NULL,
159 KEY `user_id` (`user_id`),
160 KEY `proposal_id` (`proposal_id`),
161 CONSTRAINT `FK_ruangan_cek_proposal` FOREIGN KEY (`proposal_id`) REFERENCES `proposal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
162 CONSTRAINT `FK_ruangan_cek_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
163) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cek List Peminjaman Ruangan';
164
165-- Data exporting was unselected.
166-- Dumping structure for table yarsi_nita_ukm.ruangan_cek_detail
167CREATE TABLE IF NOT EXISTS `ruangan_cek_detail` (
168 `ruangan_cek_id` int(11) NOT NULL,
169 `nama` varchar(50) NOT NULL COMMENT 'nama pengajuan peminjaman / permohonan tambahan perlengkapan',
170 `lampiran_tambahan` bit(1) NOT NULL DEFAULT b'0' COMMENT 'Isinya lampiran atau tambahan',
171 `jumlah` smallint(6) DEFAULT NULL,
172 `keterangan` text,
173 `tipe` enum('lampiran','tambahan') NOT NULL,
174 KEY `ruangan_cek_id` (`ruangan_cek_id`),
175 CONSTRAINT `FK_ruangan_cek_detail_ruangan_cek` FOREIGN KEY (`ruangan_cek_id`) REFERENCES `ruangan_cek` (`proposal_id`) ON DELETE CASCADE ON UPDATE CASCADE
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177
178-- Data exporting was unselected.
179-- Dumping structure for table yarsi_nita_ukm.ruangan_form
180CREATE TABLE IF NOT EXISTS `ruangan_form` (
181 `proposal_id` int(11) NOT NULL,
182 `user_id` int(11) NOT NULL,
183 `petugas` json DEFAULT NULL,
184 `catatan` longtext,
185 `mou` json DEFAULT NULL,
186 `created_at` int(11) DEFAULT NULL,
187 KEY `user_id` (`user_id`),
188 KEY `proposal_id` (`proposal_id`),
189 CONSTRAINT `FK_ruangan_form_proposal` FOREIGN KEY (`proposal_id`) REFERENCES `proposal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
190 CONSTRAINT `FK_ruangan_form_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
191) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Form Pengajuan';
192
193-- Data exporting was unselected.
194-- Dumping structure for table yarsi_nita_ukm.surat_disposisi
195CREATE TABLE IF NOT EXISTS `surat_disposisi` (
196 `id` int(11) NOT NULL,
197 `no_dokumen` varchar(50) NOT NULL,
198 `nama` varchar(255) NOT NULL,
199 `tempat` varchar(255) NOT NULL,
200 `tanggal` varchar(255) NOT NULL,
201 `pengirim` varchar(50) NOT NULL,
202 `created_at` int(11) NOT NULL,
203 PRIMARY KEY (`id`),
204 KEY `no_dokumen` (`no_dokumen`)
205) ENGINE=InnoDB DEFAULT CHARSET=utf8;
206
207-- Data exporting was unselected.
208-- Dumping structure for table yarsi_nita_ukm.surat_disposisi_detail
209CREATE TABLE IF NOT EXISTS `surat_disposisi_detail` (
210 `surat_disposisi_id` int(11) NOT NULL,
211 `tanggal_surat_diterima` date NOT NULL,
212 `pengirim` varchar(50) NOT NULL,
213 `kepada` varchar(50) NOT NULL,
214 `disposisi` text NOT NULL,
215 `tanggal_paraf` date NOT NULL,
216 `created_at` int(11) NOT NULL,
217 KEY `surat_disposisi_id` (`surat_disposisi_id`),
218 CONSTRAINT `FK_surat_disposisi_detail_surat_disposisi` FOREIGN KEY (`surat_disposisi_id`) REFERENCES `surat_disposisi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
219) ENGINE=InnoDB DEFAULT CHARSET=utf8;
220
221-- Data exporting was unselected.
222-- Dumping structure for table yarsi_nita_ukm.surat_pernyataan
223CREATE TABLE IF NOT EXISTS `surat_pernyataan` (
224 `id` int(11) NOT NULL AUTO_INCREMENT,
225 `proposal_id` int(11) DEFAULT NULL,
226 `user_id` int(11) DEFAULT NULL,
227 `nama_peminjam` varchar(50) NOT NULL,
228 `fakultas` varchar(255) NOT NULL,
229 `npm_nik` varchar(50) NOT NULL,
230 `no_telp` int(11) NOT NULL,
231 `nama_kegiatan` text NOT NULL,
232 `waktu_dimulai` datetime NOT NULL,
233 `waktu_selesai` datetime NOT NULL,
234 `created_at` int(11) NOT NULL COMMENT 'waktu insert ke database',
235 PRIMARY KEY (`id`),
236 KEY `user_id` (`user_id`),
237 KEY `proposal_id` (`proposal_id`),
238 CONSTRAINT `FK_surat_pernyataan_proposal` FOREIGN KEY (`proposal_id`) REFERENCES `proposal` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
239 CONSTRAINT `FK_surat_pernyataan_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
240) ENGINE=InnoDB DEFAULT CHARSET=utf8;
241
242-- Data exporting was unselected.
243-- Dumping structure for table yarsi_nita_ukm.user
244CREATE TABLE IF NOT EXISTS `user` (
245 `id` int(11) NOT NULL AUTO_INCREMENT,
246 `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
247 `auth_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
248 `password_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
249 `password_reset_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
250 `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
251 `status` smallint(6) NOT NULL DEFAULT '10' COMMENT '0: Inactive, 10: Active',
252 `created_at` int(11) DEFAULT NULL COMMENT 'waktu insert ke database',
253 `updated_at` int(11) DEFAULT NULL COMMENT 'waktu update ke database',
254 `created_by` int(11) DEFAULT NULL COMMENT 'info siapa yang create data',
255 `updated_by` int(11) DEFAULT NULL COMMENT 'info siapa yang update data ',
256 PRIMARY KEY (`id`)
257) ENGINE=InnoDB DEFAULT CHARSET=utf8;
258
259-- Data exporting was unselected.
260-- Dumping structure for table yarsi_nita_ukm.user_profile
261CREATE TABLE IF NOT EXISTS `user_profile` (
262 `user_id` int(11) NOT NULL,
263 `firstname` varchar(50) DEFAULT NULL,
264 `lastname` varchar(50) DEFAULT NULL,
265 `no_telp` varchar(50) DEFAULT NULL,
266 `avatar` varchar(225) DEFAULT NULL,
267 `alamat` text,
268 `type` varchar(255) DEFAULT NULL COMMENT 'Tipe User : mahasiswa, dpt, rektorat',
269 `fakultas` varchar(255) DEFAULT NULL,
270 `jurusan` varchar(255) DEFAULT NULL,
271 `created_at` int(11) DEFAULT NULL,
272 `created_by` int(11) DEFAULT NULL,
273 `updated_by` int(11) DEFAULT NULL,
274 `updated_at` int(11) DEFAULT NULL,
275 PRIMARY KEY (`user_id`),
276 CONSTRAINT `FK_user_profile_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
277) ENGINE=InnoDB DEFAULT CHARSET=utf8;
278
279-- Data exporting was unselected.
280/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
281/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
282/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;