362 lines
8.8 KiB
SQL
362 lines
8.8 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 5.2.1
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: 127.0.0.1
|
|
-- Waktu pembuatan: 12 Feb 2025 pada 08.56
|
|
-- Versi server: 10.4.28-MariaDB
|
|
-- Versi PHP: 8.2.4
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
START TRANSACTION;
|
|
SET time_zone = "+00:00";
|
|
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8mb4 */;
|
|
|
|
--
|
|
-- Database: `spk_vikor_laravel_10`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `alternatif`
|
|
--
|
|
|
|
CREATE TABLE `alternatif` (
|
|
`id_alternatif` int(11) NOT NULL,
|
|
`nama` varchar(100) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `alternatif`
|
|
--
|
|
|
|
INSERT INTO `alternatif` (`id_alternatif`, `nama`) VALUES
|
|
(23, 'Alternatif 1'),
|
|
(24, 'Alternatif 2'),
|
|
(25, 'Alternatif 3'),
|
|
(26, 'Alternatif 4'),
|
|
(27, 'Alternatif 5'),
|
|
(28, 'Alternatif 6');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `hasil`
|
|
--
|
|
|
|
CREATE TABLE `hasil` (
|
|
`id_hasil` int(11) NOT NULL,
|
|
`id_alternatif` int(11) NOT NULL,
|
|
`nilai` float NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `hasil`
|
|
--
|
|
|
|
INSERT INTO `hasil` (`id_hasil`, `id_alternatif`, `nilai`) VALUES
|
|
(1, 23, 0.402338),
|
|
(2, 24, 0.0795076),
|
|
(3, 25, 0.474194),
|
|
(4, 26, 0.913174),
|
|
(5, 27, 0),
|
|
(6, 28, 1);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `kriteria`
|
|
--
|
|
|
|
CREATE TABLE `kriteria` (
|
|
`id_kriteria` int(11) NOT NULL,
|
|
`keterangan` varchar(100) NOT NULL,
|
|
`kode_kriteria` varchar(100) NOT NULL,
|
|
`bobot` float NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `kriteria`
|
|
--
|
|
|
|
INSERT INTO `kriteria` (`id_kriteria`, `keterangan`, `kode_kriteria`, `bobot`) VALUES
|
|
(35, 'Efisiensi Keuangan', 'C1', 0.3),
|
|
(36, 'Absensi', 'C2', 0.15),
|
|
(37, 'Masa Jabatan', 'C3', 0.1),
|
|
(38, 'Memiliki Keterampilan Teknis', 'C4', 0.25),
|
|
(39, 'Inovatif', 'C5', 0.2);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `penilaian`
|
|
--
|
|
|
|
CREATE TABLE `penilaian` (
|
|
`id_penilaian` int(11) NOT NULL,
|
|
`id_alternatif` int(11) NOT NULL,
|
|
`id_kriteria` int(11) NOT NULL,
|
|
`nilai` int(100) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `penilaian`
|
|
--
|
|
|
|
INSERT INTO `penilaian` (`id_penilaian`, `id_alternatif`, `id_kriteria`, `nilai`) VALUES
|
|
(192, 23, 35, 129),
|
|
(193, 23, 36, 134),
|
|
(194, 23, 37, 138),
|
|
(195, 23, 38, 144),
|
|
(196, 23, 39, 147),
|
|
(197, 24, 35, 129),
|
|
(198, 24, 36, 133),
|
|
(199, 24, 37, 136),
|
|
(200, 24, 38, 144),
|
|
(201, 24, 39, 149),
|
|
(202, 25, 35, 129),
|
|
(203, 25, 36, 134),
|
|
(204, 25, 37, 135),
|
|
(205, 25, 38, 144),
|
|
(206, 25, 39, 147),
|
|
(207, 26, 35, 128),
|
|
(208, 26, 36, 131),
|
|
(209, 26, 37, 137),
|
|
(210, 26, 38, 144),
|
|
(211, 26, 39, 147),
|
|
(212, 27, 35, 129),
|
|
(213, 27, 36, 133),
|
|
(214, 27, 37, 137),
|
|
(215, 27, 38, 144),
|
|
(216, 27, 39, 149),
|
|
(217, 28, 35, 128),
|
|
(218, 28, 36, 130),
|
|
(219, 28, 37, 136),
|
|
(220, 28, 38, 142),
|
|
(221, 28, 39, 149);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `sub_kriteria`
|
|
--
|
|
|
|
CREATE TABLE `sub_kriteria` (
|
|
`id_sub_kriteria` int(11) NOT NULL,
|
|
`id_kriteria` int(11) NOT NULL,
|
|
`deskripsi` varchar(200) NOT NULL,
|
|
`nilai` float NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `sub_kriteria`
|
|
--
|
|
|
|
INSERT INTO `sub_kriteria` (`id_sub_kriteria`, `id_kriteria`, `deskripsi`, `nilai`) VALUES
|
|
(125, 35, 'Sangat Buruk', 10),
|
|
(126, 35, 'Buruk', 20),
|
|
(127, 35, 'Cukup', 30),
|
|
(128, 35, 'Baik', 40),
|
|
(129, 35, 'Sangat Baik', 50),
|
|
(130, 36, 'Sangat Buruk', 10),
|
|
(131, 36, 'Buruk', 20),
|
|
(132, 36, 'Cukup', 30),
|
|
(133, 36, 'Baik', 40),
|
|
(134, 36, 'Sangat Baik', 50),
|
|
(135, 37, 'Sangat Buruk', 10),
|
|
(136, 37, 'Buruk', 20),
|
|
(137, 37, 'Cukup', 30),
|
|
(138, 37, 'Baik', 40),
|
|
(139, 37, 'Sangat Baik', 50),
|
|
(140, 38, 'Sangat Buruk', 10),
|
|
(141, 38, 'Buruk', 20),
|
|
(142, 38, 'Cukup', 30),
|
|
(143, 38, 'Baik', 40),
|
|
(144, 38, 'Sangat Baik', 50),
|
|
(145, 39, 'Sangat Buruk', 10),
|
|
(146, 39, 'Buruk', 20),
|
|
(147, 39, 'Cukup', 30),
|
|
(148, 39, 'Baik', 40),
|
|
(149, 39, 'Sangat Baik', 50);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `user`
|
|
--
|
|
|
|
CREATE TABLE `user` (
|
|
`id_user` int(11) NOT NULL,
|
|
`id_user_level` int(11) NOT NULL,
|
|
`nama` varchar(200) NOT NULL,
|
|
`email` varchar(100) NOT NULL,
|
|
`username` varchar(100) NOT NULL,
|
|
`password` varchar(100) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `user`
|
|
--
|
|
|
|
INSERT INTO `user` (`id_user`, `id_user_level`, `nama`, `email`, `username`, `password`) VALUES
|
|
(1, 1, 'Admin', 'admin@gmail.com', 'admin', '21232f297a57a5a743894a0e4a801fc3'),
|
|
(7, 2, 'User', 'user@gmail.com', 'user', 'ee11cbb19052e40b07aac0ca060c23ee');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `user_level`
|
|
--
|
|
|
|
CREATE TABLE `user_level` (
|
|
`id_user_level` int(11) NOT NULL,
|
|
`user_level` varchar(100) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `user_level`
|
|
--
|
|
|
|
INSERT INTO `user_level` (`id_user_level`, `user_level`) VALUES
|
|
(1, 'Administrator'),
|
|
(2, 'User');
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indeks untuk tabel `alternatif`
|
|
--
|
|
ALTER TABLE `alternatif`
|
|
ADD PRIMARY KEY (`id_alternatif`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `hasil`
|
|
--
|
|
ALTER TABLE `hasil`
|
|
ADD PRIMARY KEY (`id_hasil`),
|
|
ADD KEY `id_alternatif` (`id_alternatif`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `kriteria`
|
|
--
|
|
ALTER TABLE `kriteria`
|
|
ADD PRIMARY KEY (`id_kriteria`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `penilaian`
|
|
--
|
|
ALTER TABLE `penilaian`
|
|
ADD PRIMARY KEY (`id_penilaian`),
|
|
ADD KEY `id_alternatif` (`id_alternatif`),
|
|
ADD KEY `id_kriteria` (`id_kriteria`),
|
|
ADD KEY `nilai` (`nilai`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `sub_kriteria`
|
|
--
|
|
ALTER TABLE `sub_kriteria`
|
|
ADD PRIMARY KEY (`id_sub_kriteria`),
|
|
ADD KEY `id_kriteria` (`id_kriteria`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `user`
|
|
--
|
|
ALTER TABLE `user`
|
|
ADD PRIMARY KEY (`id_user`),
|
|
ADD KEY `id_user_level` (`id_user_level`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `user_level`
|
|
--
|
|
ALTER TABLE `user_level`
|
|
ADD PRIMARY KEY (`id_user_level`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel yang dibuang
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `alternatif`
|
|
--
|
|
ALTER TABLE `alternatif`
|
|
MODIFY `id_alternatif` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `hasil`
|
|
--
|
|
ALTER TABLE `hasil`
|
|
MODIFY `id_hasil` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `kriteria`
|
|
--
|
|
ALTER TABLE `kriteria`
|
|
MODIFY `id_kriteria` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `penilaian`
|
|
--
|
|
ALTER TABLE `penilaian`
|
|
MODIFY `id_penilaian` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=222;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `sub_kriteria`
|
|
--
|
|
ALTER TABLE `sub_kriteria`
|
|
MODIFY `id_sub_kriteria` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=150;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `user`
|
|
--
|
|
ALTER TABLE `user`
|
|
MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `user_level`
|
|
--
|
|
ALTER TABLE `user_level`
|
|
MODIFY `id_user_level` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
|
|
--
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `hasil`
|
|
--
|
|
ALTER TABLE `hasil`
|
|
ADD CONSTRAINT `hasil_ibfk_1` FOREIGN KEY (`id_alternatif`) REFERENCES `alternatif` (`id_alternatif`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `penilaian`
|
|
--
|
|
ALTER TABLE `penilaian`
|
|
ADD CONSTRAINT `penilaian_ibfk_1` FOREIGN KEY (`id_alternatif`) REFERENCES `alternatif` (`id_alternatif`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `penilaian_ibfk_2` FOREIGN KEY (`id_kriteria`) REFERENCES `kriteria` (`id_kriteria`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `penilaian_ibfk_3` FOREIGN KEY (`nilai`) REFERENCES `sub_kriteria` (`id_sub_kriteria`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `sub_kriteria`
|
|
--
|
|
ALTER TABLE `sub_kriteria`
|
|
ADD CONSTRAINT `sub_kriteria_ibfk_1` FOREIGN KEY (`id_kriteria`) REFERENCES `kriteria` (`id_kriteria`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `user`
|
|
--
|
|
ALTER TABLE `user`
|
|
ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`id_user_level`) REFERENCES `user_level` (`id_user_level`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
COMMIT;
|
|
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|