/*
 Navicat Premium Data Transfer

 Source Server         : localhost_11
 Source Server Type    : MySQL
 Source Server Version : 100134
 Source Host           : 192.168.100.11:3306
 Source Schema         : akreditasi

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

 Date: 18/01/2021 12:01:01
*/

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 = 17 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of auth
-- ----------------------------
INSERT INTO `auth` VALUES (1, NULL, 'admin', 'upttik', 1);
INSERT INTO `auth` VALUES (2, NULL, 'admin2', 'upttik', 1);
INSERT INTO `auth` VALUES (3, 0, 'proditrjt', 'trjt2021', 3);
INSERT INTO `auth` VALUES (4, 1, 'tim1', 'tim2021', 2);
INSERT INTO `auth` VALUES (6, 3, 'tim3', 'tim2021', 2);
INSERT INTO `auth` VALUES (7, 4, 'tim4', 'tim2021', 2);
INSERT INTO `auth` VALUES (8, 5, 'tim5', 'tim2021', 2);
INSERT INTO `auth` VALUES (11, 8, 'tim8', 'tim2021', 2);
INSERT INTO `auth` VALUES (12, 9, 'tim9', 'tim2021', 2);
INSERT INTO `auth` VALUES (14, 2, 'tim2', 'tim2021', 2);
INSERT INTO `auth` VALUES (15, 6, 'tim6', 'tim2021', 2);
INSERT INTO `auth` VALUES (16, 7, 'tim7', 'tim2021', 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(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id_pengguna`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pengguna
-- ----------------------------
INSERT INTO `pengguna` VALUES (1, 'UPT TIK', '-', 'Staf UPT TIK', 'UPT TIK');
INSERT INTO `pengguna` VALUES (2, 'UPT TIK 2', '-', 'Staf UPT TIK', 'UPT TIK');
INSERT INTO `pengguna` VALUES (3, 'Teknologi Rekayasa jaringan Telekomunikasi', '-', 'Ketua Program Studi', 'D4 Teknologi Rekayasa jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (4, 'Tim 1 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (6, 'Tim 3 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (7, 'Tim 4 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (8, 'Tim 5 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (11, 'Tim 8 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (12, 'Tim 9 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (14, 'Tim 2 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (15, 'Tim 6 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');
INSERT INTO `pengguna` VALUES (16, 'Tim 7 - TRJT', '-', 'Tim Akreditasi', 'D4 Teknologi Rekayasa Jaringan Telekomunikasi');

SET FOREIGN_KEY_CHECKS = 1;