/*
 Navicat Premium Data Transfer

 Source Server         : Localhost
 Source Server Type    : MySQL
 Source Server Version : 100316
 Source Host           : localhost:3306
 Source Schema         : akreditasi

 Target Server Type    : MySQL
 Target Server Version : 100316
 File Encoding         : 65001

 Date: 15/01/2021 15:04:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth
-- ----------------------------
DROP TABLE IF EXISTS `auth`;
CREATE TABLE `auth`  (
  `id_auth` int(11) NOT NULL AUTO_INCREMENT,
  `kriteria` int(11) NULL DEFAULT NULL,
  `username` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `password` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `id_hak_akses` int(11) NOT NULL,
  PRIMARY KEY (`id_auth`) USING BTREE,
  INDEX `idx_id_kriteria`(`kriteria`) USING BTREE,
  INDEX `idx_id_hak_akses`(`id_hak_akses`) USING BTREE,
  INDEX `idx_id_pengguna`(`id_auth`) USING BTREE,
  CONSTRAINT `fk_id_hak_akses_auth` FOREIGN KEY (`id_hak_akses`) REFERENCES `hak_akses` (`id_hak_akses`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `fk_id_kriteria_auth` FOREIGN KEY (`kriteria`) REFERENCES `kriteria` (`id_kriteria`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `fk_id_pengguna_auth` FOREIGN KEY (`id_auth`) REFERENCES `pengguna` (`id_pengguna`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of auth
-- ----------------------------
INSERT INTO `auth` VALUES (1, NULL, 'admin', 'admin', 1);
INSERT INTO `auth` VALUES (2, NULL, 'admin2', 'admin2', 1);
INSERT INTO `auth` VALUES (3, 0, 'kaprodi', 'kaprodi', 3);
INSERT INTO `auth` VALUES (4, 1, 'tim1', 'tim', 2);
INSERT INTO `auth` VALUES (5, 2, 'tim2', 'tim', 2);
INSERT INTO `auth` VALUES (6, 3, 'tim3', 'tim', 2);
INSERT INTO `auth` VALUES (7, 4, 'tim4', 'tim', 2);
INSERT INTO `auth` VALUES (8, 5, 'tim5', 'tim', 2);
INSERT INTO `auth` VALUES (9, 6, 'tim6', 'tim', 2);
INSERT INTO `auth` VALUES (10, 7, 'tim7', 'tim', 2);
INSERT INTO `auth` VALUES (11, 8, 'tim8', 'tim', 2);
INSERT INTO `auth` VALUES (12, 9, 'tim9', 'tim', 2);

-- ----------------------------
-- Table structure for dokumen
-- ----------------------------
DROP TABLE IF EXISTS `dokumen`;
CREATE TABLE `dokumen`  (
  `id_dokumen` int(11) NOT NULL AUTO_INCREMENT,
  `kriteria` int(11) NOT NULL,
  `judul_dokumen` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `nama_dokumen` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `path` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `penyusun` int(11) NOT NULL,
  `status_dokumen` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `tanggal_upload` datetime(0) NOT NULL DEFAULT current_timestamp(0),
  `tanggal_validasi` datetime(0) NULL DEFAULT current_timestamp(0),
  PRIMARY KEY (`id_dokumen`) USING BTREE,
  INDEX `idx_id_kriteria`(`kriteria`) USING BTREE,
  INDEX `idx_id_pengguna`(`penyusun`) USING BTREE,
  CONSTRAINT `fk_id_kriteria_dok` FOREIGN KEY (`kriteria`) REFERENCES `kriteria` (`id_kriteria`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `fk_id_pengguna_dok` FOREIGN KEY (`penyusun`) REFERENCES `pengguna` (`id_pengguna`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dokumen_pelengkap
-- ----------------------------
DROP TABLE IF EXISTS `dokumen_pelengkap`;
CREATE TABLE `dokumen_pelengkap`  (
  `id_dokumen_pl` int(11) NOT NULL AUTO_INCREMENT,
  `judul_dokumen` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `nama_dokumen` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `path` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `penyusun` int(11) NOT NULL,
  `tanggal_upload` datetime(0) NOT NULL DEFAULT current_timestamp(0),
  PRIMARY KEY (`id_dokumen_pl`) USING BTREE,
  INDEX `idx_id_pengguna`(`penyusun`) USING BTREE,
  CONSTRAINT `fk_id_pengguna_dokpl` FOREIGN KEY (`penyusun`) REFERENCES `pengguna` (`id_pengguna`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for hak_akses
-- ----------------------------
DROP TABLE IF EXISTS `hak_akses`;
CREATE TABLE `hak_akses`  (
  `id_hak_akses` int(11) NOT NULL AUTO_INCREMENT,
  `hak_akses` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id_hak_akses`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hak_akses
-- ----------------------------
INSERT INTO `hak_akses` VALUES (1, 'Administrator');
INSERT INTO `hak_akses` VALUES (2, 'Tim Akreditasi');
INSERT INTO `hak_akses` VALUES (3, 'Ketua Program Studi');

-- ----------------------------
-- Table structure for kriteria
-- ----------------------------
DROP TABLE IF EXISTS `kriteria`;
CREATE TABLE `kriteria`  (
  `id_kriteria` int(11) NOT NULL AUTO_INCREMENT,
  `kriteria` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `nama_kriteria` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id_kriteria`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kriteria
-- ----------------------------
INSERT INTO `kriteria` VALUES (1, 'Kriteria 1', 'Visi, Misi, Tujuan, dan Strategi');
INSERT INTO `kriteria` VALUES (2, 'Kriteria 2', 'Tata Pamong, Tata Kelola, dan Kerjasama');
INSERT INTO `kriteria` VALUES (3, 'Kriteria 3', 'Mahasiswa');
INSERT INTO `kriteria` VALUES (4, 'Kriteria 4', 'Sumber Daya Manusia');
INSERT INTO `kriteria` VALUES (5, 'Kriteria 5', 'Keuangan, Sarana, dan Prasarana');
INSERT INTO `kriteria` VALUES (6, 'Kriteria 6', 'Pendidikan');
INSERT INTO `kriteria` VALUES (7, 'Kriteria 7', 'Penelitian');
INSERT INTO `kriteria` VALUES (8, 'Kriteria 8', 'Pengabdian Kepada Masyarakat');
INSERT INTO `kriteria` VALUES (9, 'Kriteria 9', 'Luaran dan Capaian Tridharma');
INSERT INTO `kriteria` VALUES (10, '', 'Tidak Ada');

-- ----------------------------
-- Table structure for pengguna
-- ----------------------------
DROP TABLE IF EXISTS `pengguna`;
CREATE TABLE `pengguna`  (
  `id_pengguna` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `nidn` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `jabatan` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `homebase` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id_pengguna`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pengguna
-- ----------------------------
INSERT INTO `pengguna` VALUES (1, 'Hery Kristianto', '-', 'Kepala Tata Usaha', 'Fakultas Teknologi Informasi');
INSERT INTO `pengguna` VALUES (2, 'M. Fatkhur Rizal', '-', 'Staf Tata Usaha', 'Fakultas Teknologi Informasi');
INSERT INTO `pengguna` VALUES (3, 'Aries Dwi Indriyanti', '0012048006', 'Ketua Program Studi', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (4, 'Dzulkiflih', '0019047004', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (5, 'Dyah Listianing Tyas', '0716119003', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (6, 'Radityo Wiratsongko', '0719028005', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (7, 'Pujo Hari Saputro', '0720079001', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (8, 'Mahrus Ali', '0716068601', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (9, 'Indana Lazulfa', '0729079101', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (10, 'Iftitaahul Mufarrihah', '0720059002', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (11, 'Tim8', '0000000000', 'Tenaga Pengajar', 'S1 Teknik Informatika');
INSERT INTO `pengguna` VALUES (12, 'Tim9', '0000000000', 'Tenaga Pengajar', 'S1 Teknik Informatika');

SET FOREIGN_KEY_CHECKS = 1;