· 3 years ago · May 08, 2022, 09:40 PM
1-- phpMyAdmin SQL Dump
2-- version 3.4.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 20, 2014 at 11:08 AM
7-- Server version: 5.5.16
8-- PHP Version: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `nasdo`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `error_nasabah`
27--
28
29CREATE TABLE IF NOT EXISTS `error_nasabah` (
30 `error_id` int(20) NOT NULL AUTO_INCREMENT,
31 `jenis_error` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
32 `total` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
33 `no_proposal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
34 PRIMARY KEY (`error_id`)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
36
37-- --------------------------------------------------------
38
39--
40-- Table structure for table `mtb_agama`
41--
42
43CREATE TABLE IF NOT EXISTS `mtb_agama` (
44 `agama_id` int(2) NOT NULL AUTO_INCREMENT,
45 `nama` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
46 PRIMARY KEY (`agama_id`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
48
49--
50-- Dumping data for table `mtb_agama`
51--
52
53INSERT INTO `mtb_agama` (`agama_id`, `nama`) VALUES
54(1, 'Islam'),
55(2, 'Katholik'),
56(3, 'Protestan'),
57(4, 'Hindu'),
58(5, 'Budha'),
59(6, 'Konghuchu');
60
61-- --------------------------------------------------------
62
63--
64-- Table structure for table `mtb_daftar_nasabah`
65--
66
67CREATE TABLE IF NOT EXISTS `mtb_daftar_nasabah` (
68 `nasabah_id` int(10) NOT NULL AUTO_INCREMENT,
69 `kartukeluarga_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
70 `nama` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
71 `alamat` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
72 `status` int(2) DEFAULT '1',
73 PRIMARY KEY (`nasabah_id`)
74) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
75
76--
77-- Dumping data for table `mtb_daftar_nasabah`
78--
79
80INSERT INTO `mtb_daftar_nasabah` (`nasabah_id`, `kartukeluarga_id`, `nama`, `alamat`, `status`) VALUES
81(1, '35151', 'Ulil', 'Malang', 3),
82(2, '351512', 'Coe Ing', 'Koto Gadang', 4),
83(3, '351513', 'Bambang', 'Suko Lilo', 4),
84(4, '351514', 'Jacko', 'Medan', 1),
85(6, '351516', 'Sandra', 'Manado', 1),
86(7, '351517', 'Dita', 'Kuala Namu', 1),
87(8, '351518', 'Masa', 'Graha Bakti', 1);
88
89-- --------------------------------------------------------
90
91--
92-- Table structure for table `mtb_email_notif`
93--
94
95CREATE TABLE IF NOT EXISTS `mtb_email_notif` (
96 `email_notif_id` int(2) NOT NULL,
97 `nama` text COLLATE utf8_unicode_ci NOT NULL,
98 PRIMARY KEY (`email_notif_id`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
100
101--
102-- Dumping data for table `mtb_email_notif`
103--
104
105INSERT INTO `mtb_email_notif` (`email_notif_id`, `nama`) VALUES
106(1, 'Semua (Email notifikasi saat input proposal, nasabah ditolak dan approval)'),
107(2, 'Proposal (Email notifikasi saat input proposal)'),
108(3, 'Approval (Email notifikasi saat proses approval)'),
109(4, 'Nasabah Tolak (Email notifikasi saat input nasabah di tolak)'),
110(5, 'Tidak Aktif');
111
112-- --------------------------------------------------------
113
114--
115-- Table structure for table `mtb_hak_akses`
116--
117
118CREATE TABLE IF NOT EXISTS `mtb_hak_akses` (
119 `id_hak_akses` int(3) NOT NULL,
120 `nama_hak_akses` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
121 PRIMARY KEY (`id_hak_akses`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
123
124--
125-- Dumping data for table `mtb_hak_akses`
126--
127
128INSERT INTO `mtb_hak_akses` (`id_hak_akses`, `nama_hak_akses`) VALUES
129(1, 'Admin'),
130(2, 'Approval'),
131(3, 'Inputer'),
132(4, 'User');
133
134-- --------------------------------------------------------
135
136--
137-- Table structure for table `mtb_jabatan`
138--
139
140CREATE TABLE IF NOT EXISTS `mtb_jabatan` (
141 `id_jabatan` int(3) NOT NULL AUTO_INCREMENT,
142 `nama_jabatan` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
143 PRIMARY KEY (`id_jabatan`)
144) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ;
145
146--
147-- Dumping data for table `mtb_jabatan`
148--
149
150INSERT INTO `mtb_jabatan` (`id_jabatan`, `nama_jabatan`) VALUES
151(13, 'Administrator'),
152(14, 'Branch Manager'),
153(15, 'Sub Branch Manager'),
154(16, 'Marketing Manager (MM)'),
155(17, 'Area Sales Manager (ASM)'),
156(18, 'Kepala Warung Mikro (KWM)'),
157(19, 'Retail Banking Officer (RBO)'),
158(20, 'Sales Assistant (SA)'),
159(21, 'Asisten Analis Mikro (AAM)'),
160(22, 'Pelaksana Penaksir Gadai (PPG)');
161
162-- --------------------------------------------------------
163
164--
165-- Table structure for table `mtb_jenis_identitas`
166--
167
168CREATE TABLE IF NOT EXISTS `mtb_jenis_identitas` (
169 `identitas_id` int(2) NOT NULL,
170 `nama` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
171 PRIMARY KEY (`identitas_id`)
172) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
173
174--
175-- Dumping data for table `mtb_jenis_identitas`
176--
177
178INSERT INTO `mtb_jenis_identitas` (`identitas_id`, `nama`) VALUES
179(1, 'KTP'),
180(2, 'SIM'),
181(3, 'Passport');
182
183-- --------------------------------------------------------
184
185--
186-- Table structure for table `mtb_kolektabilitas`
187--
188
189CREATE TABLE IF NOT EXISTS `mtb_kolektabilitas` (
190 `kolektabilitas_id` int(11) NOT NULL AUTO_INCREMENT,
191 `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
192 PRIMARY KEY (`kolektabilitas_id`)
193) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
194
195--
196-- Dumping data for table `mtb_kolektabilitas`
197--
198
199INSERT INTO `mtb_kolektabilitas` (`kolektabilitas_id`, `nama`) VALUES
200(1, 'Lancar'),
201(5, 'Dalam Perhatian Khusus'),
202(6, 'Kurang Lancar'),
203(7, 'Diragukan'),
204(8, 'Macet');
205
206-- --------------------------------------------------------
207
208--
209-- Table structure for table `mtb_level_jabatan`
210--
211
212CREATE TABLE IF NOT EXISTS `mtb_level_jabatan` (
213 `level_jabatan_id` int(3) NOT NULL AUTO_INCREMENT,
214 `nama_jabatan` varchar(50) COLLATE utf8_bin DEFAULT NULL,
215 PRIMARY KEY (`level_jabatan_id`)
216) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
217
218--
219-- Dumping data for table `mtb_level_jabatan`
220--
221
222INSERT INTO `mtb_level_jabatan` (`level_jabatan_id`, `nama_jabatan`) VALUES
223(1, 'Supervisor'),
224(2, 'Officer'),
225(3, 'Pelaksana');
226
227-- --------------------------------------------------------
228
229--
230-- Table structure for table `mtb_list_email`
231--
232
233CREATE TABLE IF NOT EXISTS `mtb_list_email` (
234 `id_list_email` int(10) NOT NULL AUTO_INCREMENT,
235 `email_address` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
236 `nama_pengguna` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
237 `jabatan_id` int(3) DEFAULT NULL,
238 `status` tinyint(2) NOT NULL,
239 `NIP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
240 PRIMARY KEY (`id_list_email`)
241) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
242
243--
244-- Dumping data for table `mtb_list_email`
245--
246
247INSERT INTO `mtb_list_email` (`id_list_email`, `email_address`, `nama_pengguna`, `jabatan_id`, `status`, `NIP`) VALUES
248(4, 'rnur1780@bsm.co.id', 'Ridwan Nur', 15, 1, '047871780');
249
250-- --------------------------------------------------------
251
252--
253-- Table structure for table `mtb_mailer`
254--
255
256CREATE TABLE IF NOT EXISTS `mtb_mailer` (
257 `mail_id` int(1) NOT NULL,
258 `host` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
259 `nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
260 `password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
261 `port` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
262 `proposal_baru` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
263 `nasabah_tolak` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
264 `approval` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
265 PRIMARY KEY (`mail_id`)
266) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
267
268--
269-- Dumping data for table `mtb_mailer`
270--
271
272INSERT INTO `mtb_mailer` (`mail_id`, `host`, `nama`, `password`, `port`, `proposal_baru`, `nasabah_tolak`, `approval`) VALUES
273(1, 'ssl://smtp.gmail.com', 'drankoto25@gmail.com', 'rimbha02', '465', '0', '0', '0');
274
275-- --------------------------------------------------------
276
277--
278-- Table structure for table `mtb_pegawai`
279--
280
281CREATE TABLE IF NOT EXISTS `mtb_pegawai` (
282 `pegawai_id` int(4) NOT NULL AUTO_INCREMENT,
283 `no_urut` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
284 `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
285 `NIP` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
286 `jabatan` int(3) DEFAULT NULL,
287 `no_handphone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
288 `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
289 `unit_kerja` int(2) DEFAULT NULL,
290 `email_atasan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
291 `level_jabatan` int(3) DEFAULT NULL,
292 PRIMARY KEY (`pegawai_id`)
293) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
294
295--
296-- Dumping data for table `mtb_pegawai`
297--
298
299INSERT INTO `mtb_pegawai` (`pegawai_id`, `no_urut`, `nama`, `NIP`, `jabatan`, `no_handphone`, `email`, `unit_kerja`, `email_atasan`, `level_jabatan`) VALUES
300(2, '010', 'Alhuda Djannis', '007270489', 14, '0816-1368853', 'alhuda@bsm.co.id', 2, 'ddurachman@bsm.co.id', 1),
301(3, '011', 'Ridwan Nur', '047871780', 15, '0853-76102270', 'rnur1780@bsm.co.id', 3, 'alhuda@bsm.co.id', 2),
302(4, '020', 'Silvany Riza', '118278205', 20, '0812-6524091', 'sriza@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
303(5, '021', 'Nicko Gemayel', '148713908', 20, '0852-71589848', 'ngemayel@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
304(6, '022', 'Andi Rachman Guci', '118478201', 20, '0813-74005586', 'arguci@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
305(7, '023', 'Maria Gunarti', '108676080', 21, '0813-74190906', 'mgunarti@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
306(8, '024', 'Ekko Febrian', '118678196', 22, '0823-8766616', 'efebrian@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
307(9, '002', 'Ulil', '123', 11, '', '', NULL, '', 1),
308(11, '001', 'ERRI', '76102270', 13, '0853-76102270', 'drankoto25@gmail.com', 3, 'rnur1780@bsm.co.id', 1);
309
310-- --------------------------------------------------------
311
312--
313-- Table structure for table `mtb_segmen`
314--
315
316CREATE TABLE IF NOT EXISTS `mtb_segmen` (
317 `segmen_id` int(2) NOT NULL AUTO_INCREMENT,
318 `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
319 PRIMARY KEY (`segmen_id`)
320) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
321
322--
323-- Dumping data for table `mtb_segmen`
324--
325
326INSERT INTO `mtb_segmen` (`segmen_id`, `nama`) VALUES
327(1, 'Komersial'),
328(4, 'Konsumer'),
329(5, 'Small'),
330(6, 'Mikro'),
331(7, 'Gadai');
332
333-- --------------------------------------------------------
334
335--
336-- Table structure for table `mtb_status_nasabah`
337--
338
339CREATE TABLE IF NOT EXISTS `mtb_status_nasabah` (
340 `id_status` int(2) NOT NULL AUTO_INCREMENT,
341 `nama_status` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
342 PRIMARY KEY (`id_status`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
344
345--
346-- Dumping data for table `mtb_status_nasabah`
347--
348
349INSERT INTO `mtb_status_nasabah` (`id_status`, `nama_status`) VALUES
350(1, 'Baru'),
351(2, 'Ditolak'),
352(3, 'Diterima'),
353(4, 'Applied');
354
355-- --------------------------------------------------------
356
357--
358-- Table structure for table `mtb_status_proposal`
359--
360
361CREATE TABLE IF NOT EXISTS `mtb_status_proposal` (
362 `status_id` int(3) NOT NULL AUTO_INCREMENT,
363 `nama` varchar(30) COLLATE utf8_bin DEFAULT NULL,
364 PRIMARY KEY (`status_id`)
365) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
366
367--
368-- Dumping data for table `mtb_status_proposal`
369--
370
371INSERT INTO `mtb_status_proposal` (`status_id`, `nama`) VALUES
372(1, 'Proposal'),
373(2, 'Pengajuan Tolak'),
374(3, 'Tolak');
375
376-- --------------------------------------------------------
377
378--
379-- Table structure for table `mtb_unit_kerja`
380--
381
382CREATE TABLE IF NOT EXISTS `mtb_unit_kerja` (
383 `unit_kerja_id` int(3) NOT NULL AUTO_INCREMENT,
384 `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
385 PRIMARY KEY (`unit_kerja_id`)
386) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
387
388--
389-- Dumping data for table `mtb_unit_kerja`
390--
391
392INSERT INTO `mtb_unit_kerja` (`unit_kerja_id`, `nama`) VALUES
393(2, 'KC Bukittinggi'),
394(3, 'KCP Lubuk Sikaping'),
395(4, 'KCP Padang Panjang'),
396(5, 'KCP Pasaman Barat'),
397(6, 'KCP Lubuk Basung'),
398(7, 'KCP Batusangkar'),
399(8, 'KCP Pasar Aur'),
400(9, 'KCP Sawahlunto');
401
402-- --------------------------------------------------------
403
404--
405-- Table structure for table `mtb_user`
406--
407
408CREATE TABLE IF NOT EXISTS `mtb_user` (
409 `user_id` int(10) NOT NULL AUTO_INCREMENT,
410 `user_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
411 `email_address` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
412 `jabatan_id` int(2) NOT NULL DEFAULT '0',
413 `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
414 `hak_akses` int(2) NOT NULL DEFAULT '0',
415 `NIP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
416 `id_pegawai` int(5) DEFAULT NULL,
417 PRIMARY KEY (`user_id`)
418) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ;
419
420--
421-- Dumping data for table `mtb_user`
422--
423
424INSERT INTO `mtb_user` (`user_id`, `user_name`, `email_address`, `jabatan_id`, `password`, `hak_akses`, `NIP`, `id_pegawai`) VALUES
425(25, 'ERRI', 'drankoto25@gmail.com', 13, '$2a$13$tjTeUFOupQIhIImk7sDaUuKY3WB4lKpOLlACmSwF4e5OHN8s6lWvC', 1, '76102270', 11),
426(26, 'Silvany Riza', 'sriza@bsm.co.id', 20, '$2a$13$OH7kFE7XhPWcRJkeBIqQH.cWah8e4Dx4SvYRwykQ0Qc8lRO1ZuY0m', 3, '118278205', 4),
427(27, 'Nicko Gemayel', 'ngemayel@bsm.co.id', 20, '$2a$13$d/U.shgYagOxMScEJ1kJke/0IeWJgFYkWO.A7knAmBrFeldPqtwju', 3, '148713908', 5),
428(28, 'Maria Gunarti', 'mgunarti@bsm.co.id', 21, '$2a$13$yB8MdwM5o1jF7NCmov/LPOuNQbSMjqhXNKqjaYiNnXdWpEoJkOkm2', 3, '108676080', 7),
429(29, 'Ekko Febrian', 'efebrian@bsm.co.id', 22, '$2a$13$q.7/cSAbBFAC2tRddbtbt.x4wrSqNhr1kMPfx4fGr/81SMUzPzeVq', 3, '118678196', 8),
430(30, 'Ridwan Nur', 'rnur1780@bsm.co.id', 15, '$2a$13$6A3J6tEhVRZgUTR36Qa9POEHJ7LcOqcwB1xlHo87t2CSTxZv4SiUG', 2, '047871780', 3);
431
432-- --------------------------------------------------------
433
434--
435-- Table structure for table `pelunasan`
436--
437
438CREATE TABLE IF NOT EXISTS `pelunasan` (
439 `pelunasan_id` int(10) NOT NULL AUTO_INCREMENT,
440 `tanggal_pelunasan` date DEFAULT NULL,
441 `penyebab` text COLLATE utf8_bin,
442 `segmen` int(2) DEFAULT NULL,
443 `jenis_usaha` varchar(50) COLLATE utf8_bin DEFAULT NULL,
444 `nama_nasabah` varchar(100) COLLATE utf8_bin DEFAULT NULL,
445 `no_CIF` varchar(50) COLLATE utf8_bin DEFAULT NULL,
446 `no_rekening` varchar(50) COLLATE utf8_bin DEFAULT NULL,
447 `plafon_awal` varchar(20) COLLATE utf8_bin DEFAULT NULL,
448 `OS_pokok_terakhir` varchar(20) COLLATE utf8_bin DEFAULT NULL,
449 `angsuran` varchar(20) COLLATE utf8_bin DEFAULT NULL,
450 `kolektibilitas_terakhir` varchar(20) COLLATE utf8_bin DEFAULT NULL,
451 `alamat_nasabah` text COLLATE utf8_bin,
452 `jenis_pembiayaan` int(2) DEFAULT NULL,
453 `margin` varchar(8) COLLATE utf8_bin DEFAULT NULL,
454 `tunggakan_terakhir` varchar(20) COLLATE utf8_bin DEFAULT NULL,
455 `status_pelunasan` varchar(2) COLLATE utf8_bin DEFAULT '1',
456 PRIMARY KEY (`pelunasan_id`)
457) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=6 ;
458
459--
460-- Dumping data for table `pelunasan`
461--
462
463INSERT INTO `pelunasan` (`pelunasan_id`, `tanggal_pelunasan`, `penyebab`, `segmen`, `jenis_usaha`, `nama_nasabah`, `no_CIF`, `no_rekening`, `plafon_awal`, `OS_pokok_terakhir`, `angsuran`, `kolektibilitas_terakhir`, `alamat_nasabah`, `jenis_pembiayaan`, `margin`, `tunggakan_terakhir`, `status_pelunasan`) VALUES
464(2, '2014-10-01', 'tess Lain-lain', 4, '', 'Jaka', '11111111', '1111111111', '11', '111.111', '1.111', '6', '', 3, '', '', '1'),
465(3, '2014-10-01', 'Penjualan Agunan', 4, '', 'Testing', '', '1212121111', '', '', '', '', 'Makasar', 3, '', '', '1'),
466(4, '2014-10-20', 'Lainya', 5, 'Pertambangan', 'Ukaka', '1422412', '342222113', '2000000', '950000', '300000', '6', 'Papuaa', 2, '95.9', '400000', '3'),
467(5, '2014-10-20', 'Pasca Restrukturisasi', 4, 'Bengkel Ban', 'Tuan G', '77877767', '7064311764', '150000000', '75000000', '1500000', '5', 'Panti', 1, '15', '25000000', '3');
468
469-- --------------------------------------------------------
470
471--
472-- Table structure for table `pelunasan_jenis_pembiayaan`
473--
474
475CREATE TABLE IF NOT EXISTS `pelunasan_jenis_pembiayaan` (
476 `pembiayaan_id` int(2) NOT NULL AUTO_INCREMENT,
477 `nama` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
478 PRIMARY KEY (`pembiayaan_id`)
479) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
480
481--
482-- Dumping data for table `pelunasan_jenis_pembiayaan`
483--
484
485INSERT INTO `pelunasan_jenis_pembiayaan` (`pembiayaan_id`, `nama`) VALUES
486(1, 'Murabahah'),
487(2, 'Salam'),
488(3, 'Istishna'),
489(4, 'Qardh'),
490(5, 'Musyarakah'),
491(6, 'Mudharabah'),
492(7, 'Ijarah');
493
494-- --------------------------------------------------------
495
496--
497-- Table structure for table `pelunasan_sebab`
498--
499
500CREATE TABLE IF NOT EXISTS `pelunasan_sebab` (
501 `id_sebab` int(2) NOT NULL AUTO_INCREMENT,
502 `nama` varchar(50) COLLATE utf8_bin DEFAULT NULL,
503 PRIMARY KEY (`id_sebab`)
504) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
505
506--
507-- Dumping data for table `pelunasan_sebab`
508--
509
510INSERT INTO `pelunasan_sebab` (`id_sebab`, `nama`) VALUES
511(1, 'Write Off'),
512(2, 'Pasca Restrukturisasi'),
513(3, 'Penjualan Agunan'),
514(4, 'Lelang Agunan'),
515(5, 'Litigasi'),
516(6, 'Lain-lain');
517
518-- --------------------------------------------------------
519
520--
521-- Table structure for table `proposal`
522--
523
524CREATE TABLE IF NOT EXISTS `proposal` (
525 `proposal_id` int(10) NOT NULL AUTO_INCREMENT,
526 `plafon` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
527 `tanggal_pengajuan` date DEFAULT NULL,
528 `segmen` int(2) NOT NULL,
529 `jenis_usaha` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
530 `marketing` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
531 `no_kartu_keluarga` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
532 `no_buku_nikah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
533 `no_ktp` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
534 `no_proposal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
535 `status_pengajuan` varchar(3) COLLATE utf8_unicode_ci DEFAULT '1',
536 `jenis_nasabah` int(2) DEFAULT NULL,
537 `existing_plafon` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
538 `existing_os` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
539 `existing_angsuran` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
540 `existing_kolektabilitas` int(2) DEFAULT NULL,
541 `referal_nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
542 `referal_alamat` text COLLATE utf8_unicode_ci,
543 `referal_telp` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
544 `referal_sektor_usaha` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
545 `referal_fasilitas` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
546 `referal_kolektabilitas` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
547 `del_flag` int(11) DEFAULT '0',
548 `nama_nasabah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
549 `jenis_identitas` int(2) DEFAULT NULL,
550 `tanggal_kartu_keluarga` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
551 PRIMARY KEY (`proposal_id`)
552) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;
553
554--
555-- Dumping data for table `proposal`
556--
557
558INSERT INTO `proposal` (`proposal_id`, `plafon`, `tanggal_pengajuan`, `segmen`, `jenis_usaha`, `marketing`, `no_kartu_keluarga`, `no_buku_nikah`, `no_ktp`, `no_proposal`, `status_pengajuan`, `jenis_nasabah`, `existing_plafon`, `existing_os`, `existing_angsuran`, `existing_kolektabilitas`, `referal_nama`, `referal_alamat`, `referal_telp`, `referal_sektor_usaha`, `referal_fasilitas`, `referal_kolektabilitas`, `del_flag`, `nama_nasabah`, `jenis_identitas`, `tanggal_kartu_keluarga`) VALUES
559(7, '', '2014-10-18', 1, 'Pertambangan`', '10', '1221', '', '1211', '0001/10/2014', '1', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'tuan C', 1, NULL),
560(4, '250000000', '2014-10-01', 4, 'Toko Elektronik', '4', '123456789-KK', '123456789-BK', '123456789A', '001', '3', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'Tuan A', 1, NULL),
561(5, '275000000', '2014-10-01', 5, 'Dagang Kelontong', '4', '111111-KK', '111111-BN', '111111A', '002', '1', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'Tuan B', 1, NULL),
562(6, '75000000', '2014-10-01', 6, 'Kelontong', '7', '222222-KK', '222222-BN', '222222A', '003', '1', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'Tuan C', 1, NULL),
563(8, '', '2014-10-22', 4, 're', '10', '1212121', '', '122', '0002/10/2014', '3', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'tuanD', 1, '2014-10-21'),
564(9, '121', '2014-10-18', 6, 'js', '10', '1221', '', '123', '0003/10/2014', '1', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'Ulil', 1, '2014-10-22'),
565(10, '150000000', '2014-10-17', 4, 'Elektronik', '4', 'KK-E', 'BK-E', '111111111-E', '0004/10/2014', '1', 2, '150000000', '75000000', '1500000', 1, '', '', '', '', '', '', 0, 'Tuan E', 1, '1980-10-13'),
566(11, '500000000', '2014-10-20', 5, 'Heler', '4', 'KK-F1', 'BK-F1', '1111111-F', '0005/10/2014', '1', 3, '', '', '', NULL, 'Zaki', 'Rao', '0853111111', 'Bengkel Ban', '250000000', '5', 0, 'Tuan F', 1, '1982-10-22'),
567(14, '150000000', '2014-10-20', 5, 'Toko Kue', '4', '123456789-KK', '123456789-BK', '123456789', '0006/10/2014', '1', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'Istri Tuan A', 1, '1980-11-01');
568
569-- --------------------------------------------------------
570
571--
572-- Table structure for table `proposal_buku_nikah`
573--
574
575CREATE TABLE IF NOT EXISTS `proposal_buku_nikah` (
576 `proposal_id` int(5) DEFAULT NULL,
577 `no_buku_nikah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
578 `tgl_buku_nikah` date DEFAULT NULL
579) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
580
581--
582-- Dumping data for table `proposal_buku_nikah`
583--
584
585INSERT INTO `proposal_buku_nikah` (`proposal_id`, `no_buku_nikah`, `tgl_buku_nikah`) VALUES
586(4, '123456789-BK', '1980-10-01'),
587(5, '111111-BN', '1983-10-01'),
588(6, '222222-BN', '2000-10-01'),
589(10, 'BK-E', '1980-10-13'),
590(11, 'BK-F1', '1981-10-22'),
591(14, '123456789-BK', '1980-10-01');
592
593-- --------------------------------------------------------
594
595--
596-- Table structure for table `proposal_kartu_keluarga`
597--
598
599CREATE TABLE IF NOT EXISTS `proposal_kartu_keluarga` (
600 `no_kartu_keluarga` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
601 `nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
602 `tanggal_lahir` date DEFAULT NULL,
603 `no_ktp` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
604 `proposal_id` int(5) DEFAULT NULL,
605 `tempat_lahir` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
606) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
607
608--
609-- Dumping data for table `proposal_kartu_keluarga`
610--
611
612INSERT INTO `proposal_kartu_keluarga` (`no_kartu_keluarga`, `nama`, `tanggal_lahir`, `no_ktp`, `proposal_id`, `tempat_lahir`) VALUES
613('123456789-KK', 'Istri Tuan A', '1961-10-01', '123456789B', 4, 'Rao'),
614('123456789-KK', 'Anak Tuan A', '1975-10-01', '123456789C', 4, 'Rao'),
615('111111-KK', 'Anak Tuan B', '1985-10-01', '111111-B', 5, 'Rao'),
616('222222-KK', 'Istri Tuan C', '1985-10-01', '222222-C', 6, 'rao'),
617('KK-E', 'Istri Tuan E', '1960-11-13', '22222222-E', 10, 'Panti'),
618('KK-E', 'Anak Tuan E', '1981-10-13', '33333333-E', 10, 'Panti'),
619('KK-F1', 'Istri Tuan F', '1960-10-22', '22222222-F', 11, 'Rao');
620
621-- --------------------------------------------------------
622
623--
624-- Table structure for table `proposal_ktp`
625--
626
627CREATE TABLE IF NOT EXISTS `proposal_ktp` (
628 `proposal_ktp_id` int(50) NOT NULL AUTO_INCREMENT,
629 `no_ktp` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
630 `tempat_lahir` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
631 `tanggal_lahir` date DEFAULT NULL,
632 `alamat` text COLLATE utf8_unicode_ci,
633 `agama` int(2) DEFAULT NULL,
634 `status_perkawinan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
635 `pekerjaan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
636 `kewarganegaraan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
637 `masa_berlaku` date DEFAULT NULL,
638 `proposal_id` int(5) DEFAULT NULL,
639 `desa` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
640 PRIMARY KEY (`proposal_ktp_id`)
641) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;
642
643--
644-- Dumping data for table `proposal_ktp`
645--
646
647INSERT INTO `proposal_ktp` (`proposal_ktp_id`, `no_ktp`, `tempat_lahir`, `tanggal_lahir`, `alamat`, `agama`, `status_perkawinan`, `pekerjaan`, `kewarganegaraan`, `masa_berlaku`, `proposal_id`, `desa`) VALUES
648(7, '1211', '', '2014-10-10', '', 1, 'Tidak Kawin', '', '', '2014-10-15', 7, ''),
649(4, '123456789A', 'Rao', '1960-10-01', 'Rao', 1, 'Kawin', 'Wiraswasta', 'Indonesia', '2015-10-01', 4, 'Rao'),
650(5, '111111A', 'Rao', '1963-10-01', 'Rao', 1, 'Kawin', 'PNS', 'Indonesia', '2014-10-01', 5, 'Rao'),
651(6, '222222A', 'Rao', '1990-10-01', 'Rao', 1, 'Kawin', 'Wiraswasta', 'Indonesia', '2015-10-01', 6, 'Rao'),
652(8, '122', '', '2014-10-10', '', 1, 'Tidak Kawin', '', '', '2014-10-09', 8, ''),
653(9, '123', '', '2014-10-10', '', 1, 'Tidak Kawin', '', '', '2014-10-09', 9, ''),
654(10, '111111111-E', 'Panti', '1960-10-13', 'Panti', 1, 'Kawin', 'Pedagang', 'Indonesia', '2015-10-13', 10, 'Panti'),
655(11, '1111111-F', 'Panti', '1959-10-22', 'rao', 1, 'Kawin', 'Pedagang', 'Indonesia', '2015-10-22', 11, 'Rao'),
656(14, '123456789', 'Rao', '1961-10-01', 'Rao', 1, 'Kawin', 'Pedagang', 'Indonesia', '2015-10-01', 14, 'Rao');
657
658-- --------------------------------------------------------
659
660--
661-- Table structure for table `tolak`
662--
663
664CREATE TABLE IF NOT EXISTS `tolak` (
665 `tolak_id` int(20) NOT NULL AUTO_INCREMENT,
666 `proposal_id` int(5) DEFAULT NULL,
667 `tanggal_tolak` date DEFAULT NULL,
668 `alasan_ditolak` text COLLATE utf8_unicode_ci,
669 `tahap_penolakan` text COLLATE utf8_unicode_ci,
670 PRIMARY KEY (`tolak_id`)
671) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
672
673--
674-- Dumping data for table `tolak`
675--
676
677INSERT INTO `tolak` (`tolak_id`, `proposal_id`, `tanggal_tolak`, `alasan_ditolak`, `tahap_penolakan`) VALUES
678(3, 8, '2014-10-01', 'fd', 'OTS Usaha'),
679(4, 4, '2014-10-20', 'Kol.5 di Bank Lain', 'BI Checking');
680
681-- --------------------------------------------------------
682
683--
684-- Table structure for table `tolak_tahapan`
685--
686
687CREATE TABLE IF NOT EXISTS `tolak_tahapan` (
688 `tahapan_id` int(3) NOT NULL AUTO_INCREMENT,
689 `nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
690 PRIMARY KEY (`tahapan_id`)
691) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
692
693--
694-- Dumping data for table `tolak_tahapan`
695--
696
697INSERT INTO `tolak_tahapan` (`tahapan_id`, `nama`) VALUES
698(1, 'BI Checking'),
699(2, 'DHN BI'),
700(3, 'Blacklist PPATK'),
701(4, 'OTS Usaha'),
702(5, 'OTS Agunan'),
703(6, 'Komite'),
704(7, 'Lain-lain');
705
706-- --------------------------------------------------------
707
708--
709-- Table structure for table `vote_jawab`
710--
711
712CREATE TABLE IF NOT EXISTS `vote_jawab` (
713 `id_jawab` int(5) NOT NULL AUTO_INCREMENT,
714 `soal_id` int(3) DEFAULT NULL,
715 `jawaban` varchar(20) COLLATE utf8_bin DEFAULT NULL,
716 `id_pegawai` varchar(50) COLLATE utf8_bin DEFAULT NULL,
717 `tanggal_vote` date DEFAULT NULL,
718 PRIMARY KEY (`id_jawab`)
719) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=25 ;
720
721--
722-- Dumping data for table `vote_jawab`
723--
724
725INSERT INTO `vote_jawab` (`id_jawab`, `soal_id`, `jawaban`, `id_pegawai`, `tanggal_vote`) VALUES
726(1, 1, 'Tidak Penting', '10', '2014-10-17'),
727(2, 2, 'Penting', '10', '2014-10-17'),
728(3, 3, 'Tidak Penting', '10', '2014-10-17'),
729(4, 4, 'Cukup Penting', '10', '2014-10-17'),
730(5, 5, 'Tidak Penting', '10', '2014-10-17'),
731(6, 6, 'Sangat Penting', '10', '2014-10-17'),
732(7, 1, 'Tidak Penting', '4', '2014-10-17'),
733(8, 2, 'Tidak Penting', '4', '2014-10-17'),
734(9, 3, 'Cukup Penting', '4', '2014-10-17'),
735(10, 4, 'Penting', '4', '2014-10-17'),
736(11, 5, 'Penting', '4', '2014-10-17'),
737(12, 6, 'Tidak Penting', '4', '2014-10-17'),
738(13, 1, 'Tidak Penting', '3', '2014-10-17'),
739(14, 2, 'Cukup Penting', '3', '2014-10-17'),
740(15, 3, 'Tidak Penting', '3', '2014-10-17'),
741(16, 4, 'Tidak Penting', '3', '2014-10-17'),
742(17, 5, 'Cukup Penting', '3', '2014-10-17'),
743(18, 6, 'Penting', '3', '2014-10-17'),
744(19, 1, 'Sangat Penting ', '10', '2014-10-18'),
745(20, 2, 'Sangat Penting', '10', '2014-10-18'),
746(21, 3, 'Tidak Penting', '10', '2014-10-18'),
747(22, 4, 'Penting', '10', '2014-10-18'),
748(23, 5, 'Cukup Penting', '10', '2014-10-18'),
749(24, 6, 'Cukup Penting', '10', '2014-10-18');
750
751-- --------------------------------------------------------
752
753--
754-- Table structure for table `vote_soal`
755--
756
757CREATE TABLE IF NOT EXISTS `vote_soal` (
758 `id_soal` int(3) NOT NULL AUTO_INCREMENT,
759 `soal` text COLLATE utf8_bin,
760 `group_soal` int(3) DEFAULT NULL,
761 `rank` int(3) DEFAULT NULL,
762 `pilihan_jawaban` text COLLATE utf8_bin,
763 PRIMARY KEY (`id_soal`)
764) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
765
766--
767-- Dumping data for table `vote_soal`
768--
769
770INSERT INTO `vote_soal` (`id_soal`, `soal`, `group_soal`, `rank`, `pilihan_jawaban`) VALUES
771(1, 'Apakah Aplikasi membantu dalam melaksanakan proses pembiayaan sesuai ketentuan di BSM?', 1, 1, 'Tidak Penting,Cukup Penting,Penting,Sangat Penting '),
772(2, 'Apakah Aplikasi membantu dalam proses pemeriksaan internal di tahap investigasi pembiayaan?', 1, 2, 'Tidak Penting,Cukup Penting,Penting,Sangat Penting'),
773(3, 'Apakah aplikasi membantu Ka.Unit dalam pengambilan keputusan pembiayaan?\r\n', 1, 3, 'Tidak Penting,Cukup Penting,Penting,Sangat Penting'),
774(4, 'Apakah Aplikasi membantu dalam menghindari potensi pembiayaan bermasalah?', 1, 4, 'Tidak Penting,Cukup Penting,Penting,Sangat Penting'),
775(5, 'Apakah Aplikasi membantu Ka.Unit dalam mereview produktivitas marketing?', 1, 5, 'Tidak Penting,Cukup Penting,Penting,Sangat Penting'),
776(6, 'Apakah Aplikasi PENTING dalam memitigasi resiko dan penerapan prudensial banking?\r\n', 1, 6, 'Tidak Penting,Cukup Penting,Penting,Sangat Penting');
777
778/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
779/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
780/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;