wt0BeR1L

1-- phpMyAdmin SQL Dump
2-- version 4.5.2
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 10, 2016 at 10:22 PM
7-- Server version: 5.7.9
8-- PHP Version: 5.6.16
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 utf8mb4 */;
18
19--
20-- Database: `spkbeasiswa`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `beasiswa`
27--
28
29DROP TABLE IF EXISTS `beasiswa`;
30CREATE TABLE IF NOT EXISTS `beasiswa` (
31  `beasiswa_id` int(11) NOT NULL AUTO_INCREMENT,
32  `judul` varchar(200) NOT NULL,
33  `keterangan` longtext NOT NULL,
34  `tahun` int(4) NOT NULL,
35  `kuota` int(11) NOT NULL,
36  PRIMARY KEY (`beasiswa_id`)
37) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
38
39--
40-- Dumping data for table `beasiswa`
41--
42
43INSERT INTO `beasiswa` (`beasiswa_id`, `judul`, `keterangan`, `tahun`, `kuota`) VALUES
44(3, 'Beasiswa Kurang mampu', 'bla bla bla', 2016, 2);
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `kriteria`
50--
51
52DROP TABLE IF EXISTS `kriteria`;
53CREATE TABLE IF NOT EXISTS `kriteria` (
54  `kriteria_id` int(11) NOT NULL AUTO_INCREMENT,
55  `nama_kriteria` varchar(50) NOT NULL,
56  PRIMARY KEY (`kriteria_id`)
57) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
58
59--
60-- Dumping data for table `kriteria`
61--
62
63INSERT INTO `kriteria` (`kriteria_id`, `nama_kriteria`) VALUES
64(1, 'Nilai Rapor'),
65(2, 'Prestasi Akademik'),
66(3, 'Prestasi Non Akademik'),
67(4, 'Penghasilan Orang Tua'),
68(5, 'Tanggungan Orang Tua');
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `kriteria_nilai`
74--
75
76DROP TABLE IF EXISTS `kriteria_nilai`;
77CREATE TABLE IF NOT EXISTS `kriteria_nilai` (
78  `kriteria_nilai_id` int(11) NOT NULL AUTO_INCREMENT,
79  `beasiswa_id` int(11) NOT NULL,
80  `kriteria_id_dari` int(11) NOT NULL,
81  `kriteria_id_tujuan` int(11) NOT NULL,
82  `nilai` int(1) NOT NULL,
83  PRIMARY KEY (`kriteria_nilai_id`)
84) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
85
86--
87-- Dumping data for table `kriteria_nilai`
88--
89
90INSERT INTO `kriteria_nilai` (`kriteria_nilai_id`, `beasiswa_id`, `kriteria_id_dari`, `kriteria_id_tujuan`, `nilai`) VALUES
91(1, 3, 1, 2, 3),
92(2, 3, 1, 3, 5),
93(3, 3, 1, 4, 6),
94(4, 3, 1, 5, 6),
95(5, 3, 2, 3, 3),
96(6, 3, 2, 4, 4),
97(7, 3, 2, 5, 4),
98(8, 3, 3, 4, 2),
99(9, 3, 3, 5, 2),
100(10, 3, 4, 5, 1);
101
102-- --------------------------------------------------------
103
104--
105-- Table structure for table `nilai_kategori`
106--
107
108DROP TABLE IF EXISTS `nilai_kategori`;
109CREATE TABLE IF NOT EXISTS `nilai_kategori` (
110  `nilai_id` int(11) NOT NULL AUTO_INCREMENT,
111  `nama_nilai` varchar(40) NOT NULL,
112  PRIMARY KEY (`nilai_id`)
113) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
114
115--
116-- Dumping data for table `nilai_kategori`
117--
118
119INSERT INTO `nilai_kategori` (`nilai_id`, `nama_nilai`) VALUES
120(1, 'Sangat Baik'),
121(2, 'Baik'),
122(3, 'Cukup'),
123(4, 'Kurang');
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `pengguna`
129--
130
131DROP TABLE IF EXISTS `pengguna`;
132CREATE TABLE IF NOT EXISTS `pengguna` (
133  `user_id` int(11) NOT NULL AUTO_INCREMENT,
134  `nama` varchar(60) NOT NULL,
135  `username` varchar(30) NOT NULL,
136  `password` varchar(40) NOT NULL,
137  `akses` enum('siswa','tu','walikelas','wakasis','admin') NOT NULL,
138  `photo` varchar(100) NOT NULL,
139  PRIMARY KEY (`user_id`)
140) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
141
142--
143-- Dumping data for table `pengguna`
144--
145
146INSERT INTO `pengguna` (`user_id`, `nama`, `username`, `password`, `akses`, `photo`) VALUES
147(1, 'Administrator', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin', 'ava-c4ca4238a0b923820dcc509a6f75849b.jpg'),
148(3, 'Tata Usaha', 'tu', 'b6b4ce6df035dcfaa26f3bc32fb89e6a', 'tu', 'ava-eccbc87e4b5ce2fe28308fd9f2a7baf3.jpg'),
149(5, 'Waka Siswa2', 'wakasis', 'bc5810a0e11508bae24473d70a0bd72e', 'wakasis', 'ava-e4da3b7fbbce2345d7772b0674a318d5.jpg'),
150(6, 'Wali Kelas 1', 'wali', 'bf8cd26e6c6732b8df17a31b54800ed8', 'walikelas', ''),
151(15, 'Peserta Satu', '123456', 'e10adc3949ba59abbe56e057f20f883e', 'siswa', ''),
152(16, 'Peserta Dua', '23456', 'adcaec3805aa912c0d0b14a81bedb6ff', 'siswa', '');
153
154-- --------------------------------------------------------
155
156--
157-- Table structure for table `peserta`
158--
159
160DROP TABLE IF EXISTS `peserta`;
161CREATE TABLE IF NOT EXISTS `peserta` (
162  `peserta_id` int(11) NOT NULL AUTO_INCREMENT,
163  `beasiswa_id` int(11) NOT NULL,
164  `siswa_id` int(11) NOT NULL,
165  `status` enum('daftar','lolos','tidak lolos') NOT NULL,
166  `total` double NOT NULL,
167  PRIMARY KEY (`peserta_id`)
168) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
169
170--
171-- Dumping data for table `peserta`
172--
173
174INSERT INTO `peserta` (`peserta_id`, `beasiswa_id`, `siswa_id`, `status`, `total`) VALUES
175(2, 3, 3, 'lolos', 3.9012057519557),
176(3, 3, 4, 'lolos', 0);
177
178-- --------------------------------------------------------
179
180--
181-- Table structure for table `peserta_nilai`
182--
183
184DROP TABLE IF EXISTS `peserta_nilai`;
185CREATE TABLE IF NOT EXISTS `peserta_nilai` (
186  `peserta_nilai_id` int(11) NOT NULL AUTO_INCREMENT,
187  `peserta_id` int(11) NOT NULL,
188  `kriteria_id` int(11) NOT NULL,
189  `nilai_id` int(11) NOT NULL,
190  PRIMARY KEY (`peserta_nilai_id`)
191) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
192
193--
194-- Dumping data for table `peserta_nilai`
195--
196
197INSERT INTO `peserta_nilai` (`peserta_nilai_id`, `peserta_id`, `kriteria_id`, `nilai_id`) VALUES
198(11, 2, 1, 1),
199(12, 2, 2, 8),
200(13, 2, 3, 15),
201(14, 2, 4, 16),
202(15, 2, 5, 21),
203(16, 3, 1, 5),
204(17, 3, 2, 8),
205(18, 3, 3, 12),
206(19, 3, 4, 17),
207(20, 3, 5, 23);
208
209-- --------------------------------------------------------
210
211--
212-- Table structure for table `siswa`
213--
214
215DROP TABLE IF EXISTS `siswa`;
216CREATE TABLE IF NOT EXISTS `siswa` (
217  `siswa_id` int(11) NOT NULL AUTO_INCREMENT,
218  `nisn` varchar(30) NOT NULL,
219  `nama` varchar(100) NOT NULL,
220  `tempat_lahir` varchar(30) NOT NULL,
221  `tgl_lahir` date NOT NULL,
222  `jenkel` enum('pria','wanita') NOT NULL,
223  `alamat` varchar(200) NOT NULL,
224  `tahun` int(4) NOT NULL,
225  `kelas` varchar(10) NOT NULL,
226  `jurusan` varchar(30) NOT NULL,
227  `semester` int(1) NOT NULL,
228  `walikelas_id` int(11) NOT NULL,
229  `anak_ke` int(2) NOT NULL,
230  `saudara` int(11) NOT NULL,
231  `nama_ayah` varchar(60) NOT NULL,
232  `pekerjaan_ayah` varchar(60) NOT NULL,
233  `nama_ibu` varchar(60) NOT NULL,
234  `pekerjaan_ibu` varchar(60) NOT NULL,
235  `nama_bank` varchar(30) NOT NULL,
236  `no_rek` varchar(30) NOT NULL,
237  `user_id` int(11) NOT NULL,
238  PRIMARY KEY (`siswa_id`)
239) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
240
241--
242-- Dumping data for table `siswa`
243--
244
245INSERT INTO `siswa` (`siswa_id`, `nisn`, `nama`, `tempat_lahir`, `tgl_lahir`, `jenkel`, `alamat`, `tahun`, `kelas`, `jurusan`, `semester`, `walikelas_id`, `anak_ke`, `saudara`, `nama_ayah`, `pekerjaan_ayah`, `nama_ibu`, `pekerjaan_ibu`, `nama_bank`, `no_rek`, `user_id`) VALUES
246(3, '123456', 'Eli Sugigi', 'Padang', '2000-07-19', 'pria', 'Jalan Padang', 2014, '1', 'TIK', 2, 3, 2, 4, 'Ayah Peserta Satu', 'Pekerjaan Ayah peserta satu', 'Ibu Peserta satu', 'Pekerjaan Ibu peserta satu', '', '', 15),
247(4, '23456', 'Peserta Dua', 'Jakarta', '2000-02-16', 'wanita', 'Jalan jakarta', 2014, '1', 'TIK', 2, 3, 1, 2, 'Ayah Peserta Dua', 'Pekerjaan ayah', 'Ibu Peserta Dua', 'Pekerjaan Ibu', '', '', 16);
248
249-- --------------------------------------------------------
250
251--
252-- Table structure for table `subkriteria`
253--
254
255DROP TABLE IF EXISTS `subkriteria`;
256CREATE TABLE IF NOT EXISTS `subkriteria` (
257  `subkriteria_id` int(11) NOT NULL AUTO_INCREMENT,
258  `nama_subkriteria` varchar(50) NOT NULL,
259  `kriteria_id` int(11) NOT NULL,
260  `tipe` enum('teks','nilai') NOT NULL,
261  `nilai_minimum` double DEFAULT NULL,
262  `nilai_maksimum` double DEFAULT NULL,
263  `op_min` varchar(4) DEFAULT NULL,
264  `op_max` varchar(4) DEFAULT NULL,
265  `nilai_id` int(11) NOT NULL,
266  PRIMARY KEY (`subkriteria_id`)
267) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
268
269--
270-- Dumping data for table `subkriteria`
271--
272
273INSERT INTO `subkriteria` (`subkriteria_id`, `nama_subkriteria`, `kriteria_id`, `tipe`, `nilai_minimum`, `nilai_maksimum`, `op_min`, `op_max`, `nilai_id`) VALUES
274(1, '> 90  90', 1, 'nilai', 90, 90, '>', NULL, 1),
275(5, '< 80 <= 90', 1, 'nilai', 80, 90, '<', '<=', 2),
276(6, '< 70 <= 80', 1, 'nilai', 70, 80, '<', '<=', 3),
277(7, '<= 70 < 70', 1, 'nilai', 70, 70, '<=', '<', 4),
278(8, 'Nasional', 2, 'teks', NULL, NULL, NULL, NULL, 1),
279(9, 'Provinsi / Kota', 2, 'teks', NULL, NULL, NULL, NULL, 2),
280(10, 'Sekolah', 2, 'teks', NULL, NULL, NULL, NULL, 3),
281(11, 'Tidak Ada', 2, 'teks', NULL, NULL, NULL, NULL, 4),
282(12, 'Nasional', 3, 'teks', NULL, NULL, NULL, NULL, 1),
283(13, 'Provinsi / Kota', 3, 'teks', NULL, NULL, NULL, NULL, 2),
284(14, 'Sekolah', 3, 'teks', NULL, NULL, NULL, NULL, 3),
285(15, 'Tidak Ada', 3, 'teks', NULL, NULL, NULL, NULL, 4),
286(16, '<= 1500000 < 1500000', 4, 'nilai', 1500000, 1500000, '<=', '<', 1),
287(17, '< 1500000 <= 2500000', 4, 'nilai', 1500000, 2500000, '<', '<=', 2),
288(18, '< 2500000 <= 3500000', 4, 'nilai', 2500000, 3500000, '<', '<=', 3),
289(19, '=> 3500000 > 3500000', 4, 'nilai', 3500000, 3500000, '=>', '>', 4),
290(20, '= 4  4', 5, 'nilai', 4, 4, '=', NULL, 1),
291(21, '> 4  > 4', 5, 'nilai', 4, 4, '>', '>', 2),
292(22, '= 3 = 3', 5, 'nilai', 3, 3, '=', '=', 3),
293(23, '<= 2 <= 2', 5, 'nilai', 2, 2, '<=', '<=', 4);
294
295-- --------------------------------------------------------
296
297--
298-- Table structure for table `subkriteria_hasil`
299--
300
301DROP TABLE IF EXISTS `subkriteria_hasil`;
302CREATE TABLE IF NOT EXISTS `subkriteria_hasil` (
303  `subkriteria_hasil_id` int(11) NOT NULL AUTO_INCREMENT,
304  `beasiswa_id` int(11) NOT NULL,
305  `subkriteria_id` int(11) NOT NULL,
306  `prioritas` double NOT NULL,
307  PRIMARY KEY (`subkriteria_hasil_id`)
308) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
309
310--
311-- Dumping data for table `subkriteria_hasil`
312--
313
314INSERT INTO `subkriteria_hasil` (`subkriteria_hasil_id`, `beasiswa_id`, `subkriteria_id`, `prioritas`) VALUES
315(1, 3, 16, 1),
316(2, 3, 17, 0.6088913020841081),
317(3, 3, 18, 0.2782827306130342),
318(4, 3, 19, 0.20898353242193896),
319(5, 3, 1, 1),
320(6, 3, 5, 0.4652226971611079),
321(7, 3, 6, 0.20150479274158797),
322(8, 3, 7, 0.1264838604896141),
323(9, 3, 8, 1),
324(10, 3, 9, 0.5949526134405514),
325(11, 3, 10, 0.34577828834003443),
326(12, 3, 11, 0.20602383687535897),
327(13, 3, 12, 1),
328(14, 3, 13, 0.4301845987904696),
329(15, 3, 14, 0.25758657541918056),
330(16, 3, 15, 0.15612791814736754),
331(17, 3, 20, 1),
332(18, 3, 21, 0.7450778338083753),
333(19, 3, 22, 0.2948147336110502),
334(20, 3, 23, 0.16278228458671345);
335
336-- --------------------------------------------------------
337
338--
339-- Table structure for table `subkriteria_nilai`
340--
341
342DROP TABLE IF EXISTS `subkriteria_nilai`;
343CREATE TABLE IF NOT EXISTS `subkriteria_nilai` (
344  `subkriteria_nilai_id` int(11) NOT NULL AUTO_INCREMENT,
345  `beasiswa_id` int(11) NOT NULL,
346  `kriteria_id` int(11) NOT NULL,
347  `subkriteria_id_dari` int(11) NOT NULL,
348  `subkriteria_id_tujuan` int(11) NOT NULL,
349  `nilai` int(1) NOT NULL,
350  PRIMARY KEY (`subkriteria_nilai_id`)
351) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=latin1;
352
353--
354-- Dumping data for table `subkriteria_nilai`
355--
356
357INSERT INTO `subkriteria_nilai` (`subkriteria_nilai_id`, `beasiswa_id`, `kriteria_id`, `subkriteria_id_dari`, `subkriteria_id_tujuan`, `nilai`) VALUES
358(91, 3, 1, 1, 5, 3),
359(92, 3, 1, 1, 6, 5),
360(93, 3, 1, 1, 7, 6),
361(94, 3, 1, 5, 6, 3),
362(95, 3, 1, 5, 7, 4),
363(96, 3, 1, 6, 7, 2),
364(97, 3, 2, 8, 9, 2),
365(98, 3, 2, 8, 10, 3),
366(99, 3, 2, 8, 11, 4),
367(100, 3, 2, 9, 10, 2),
368(101, 3, 2, 9, 11, 3),
369(102, 3, 2, 10, 11, 2),
370(103, 3, 3, 12, 13, 3),
371(104, 3, 3, 12, 14, 4),
372(105, 3, 3, 12, 15, 5),
373(106, 3, 3, 13, 14, 2),
374(107, 3, 3, 13, 15, 3),
375(108, 3, 3, 14, 15, 2),
376(109, 3, 4, 16, 17, 2),
377(110, 3, 4, 16, 18, 3),
378(111, 3, 4, 16, 19, 5),
379(112, 3, 4, 17, 18, 2),
380(113, 3, 4, 17, 19, 4),
381(114, 3, 4, 18, 19, 1),
382(115, 3, 5, 20, 21, 2),
383(116, 3, 5, 20, 22, 4),
384(117, 3, 5, 20, 23, 4),
385(118, 3, 5, 21, 22, 4),
386(119, 3, 5, 21, 23, 5),
387(120, 3, 5, 22, 23, 3);
388
389-- --------------------------------------------------------
390
391--
392-- Table structure for table `tata_usaha`
393--
394
395DROP TABLE IF EXISTS `tata_usaha`;
396CREATE TABLE IF NOT EXISTS `tata_usaha` (
397  `tata_usaha_id` int(11) NOT NULL AUTO_INCREMENT,
398  `nuptk` varchar(30) NOT NULL,
399  `nama` varchar(60) NOT NULL,
400  `tempat` varchar(40) NOT NULL,
401  `tgl_lahir` date NOT NULL,
402  `jenkel` enum('pria','wanita') NOT NULL,
403  `user_id` int(11) NOT NULL,
404  PRIMARY KEY (`tata_usaha_id`)
405) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
406
407--
408-- Dumping data for table `tata_usaha`
409--
410
411INSERT INTO `tata_usaha` (`tata_usaha_id`, `nuptk`, `nama`, `tempat`, `tgl_lahir`, `jenkel`, `user_id`) VALUES
412(2, 'tu', 'Tata Usaha', 'Jakarta', '1998-08-10', 'pria', 3);
413
414-- --------------------------------------------------------
415
416--
417-- Table structure for table `waka_siswa`
418--
419
420DROP TABLE IF EXISTS `waka_siswa`;
421CREATE TABLE IF NOT EXISTS `waka_siswa` (
422  `waka_siswa_id` int(11) NOT NULL AUTO_INCREMENT,
423  `nuptk` varchar(30) NOT NULL,
424  `nama` varchar(60) NOT NULL,
425  `tempat` varchar(40) NOT NULL,
426  `tgl_lahir` date NOT NULL,
427  `jenkel` enum('pria','wanita') NOT NULL,
428  `user_id` int(11) NOT NULL,
429  PRIMARY KEY (`waka_siswa_id`)
430) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
431
432--
433-- Dumping data for table `waka_siswa`
434--
435
436INSERT INTO `waka_siswa` (`waka_siswa_id`, `nuptk`, `nama`, `tempat`, `tgl_lahir`, `jenkel`, `user_id`) VALUES
437(2, 'wakasis', 'Waka Siswa2', 'padang', '1978-04-20', 'pria', 5);
438
439-- --------------------------------------------------------
440
441--
442-- Table structure for table `wali_kelas`
443--
444
445DROP TABLE IF EXISTS `wali_kelas`;
446CREATE TABLE IF NOT EXISTS `wali_kelas` (
447  `wali_kelas_id` int(11) NOT NULL AUTO_INCREMENT,
448  `nuptk` varchar(30) NOT NULL,
449  `kelas` varchar(30) NOT NULL,
450  `jurusan` varchar(30) NOT NULL,
451  `nama` varchar(60) NOT NULL,
452  `tempat` varchar(40) NOT NULL,
453  `tgl_lahir` date NOT NULL,
454  `jenkel` enum('pria','wanita') NOT NULL,
455  `user_id` int(11) NOT NULL,
456  PRIMARY KEY (`wali_kelas_id`)
457) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
458
459--
460-- Dumping data for table `wali_kelas`
461--
462
463INSERT INTO `wali_kelas` (`wali_kelas_id`, `nuptk`, `kelas`, `jurusan`, `nama`, `tempat`, `tgl_lahir`, `jenkel`, `user_id`) VALUES
464(3, 'wali', '1', 'TIK', 'Wali Kelas 1', 'Padang', '1989-04-03', 'wanita', 6);
465
466/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
467/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
468/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;