-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Waktu pembuatan: 06 Mar 2023 pada 01.37
-- Versi server: 5.7.36
-- Versi PHP: 8.0.13

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: `siami`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_admin`
--

DROP TABLE IF EXISTS `ami_admin`;
CREATE TABLE IF NOT EXISTS `ami_admin` (
  `id_admin` int(11) NOT NULL AUTO_INCREMENT,
  `nm_admin` varchar(150) NOT NULL,
  `jabatan` varchar(100) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `nidn` varchar(10) NOT NULL,
  `password` varchar(200) NOT NULL,
  `foto` text,
  `id_siklus` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_admin`),
  UNIQUE KEY `nidn` (`nidn`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `ami_admin`
--

INSERT INTO `ami_admin` (`id_admin`, `nm_admin`, `jabatan`, `email`, `nidn`, `password`, `foto`, `id_siklus`) VALUES
(3, 'Muhammad Anwari, S.Kom', 'Staf LPM', '', '3030303030', '$2b$10$ofQYacJ6u3AQ.gjYvG11sOu9YaLa9fTcdTkFgyl.vdoADVs4U0VWG', 'default.png', 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_ami`
--

DROP TABLE IF EXISTS `ami_ami`;
CREATE TABLE IF NOT EXISTS `ami_ami` (
  `id_ami` int(11) NOT NULL AUTO_INCREMENT,
  `id_fakultas` int(11) NOT NULL,
  `id_prodi` int(11) NOT NULL,
  `id_auditor_ketua` int(11) NOT NULL,
  `id_anggota1` int(11) DEFAULT NULL,
  `id_anggota2` int(11) DEFAULT NULL,
  `id_siklus` int(11) NOT NULL,
  `status` varchar(10) DEFAULT NULL,
  `tgl_rtm` date DEFAULT NULL,
  `tgl_selesai` date DEFAULT NULL,
  PRIMARY KEY (`id_ami`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_audit`
--

DROP TABLE IF EXISTS `ami_audit`;
CREATE TABLE IF NOT EXISTS `ami_audit` (
  `id_audit` int(11) NOT NULL AUTO_INCREMENT,
  `id_ami` int(11) NOT NULL,
  `id_standar` int(11) NOT NULL,
  `id_kts` int(11) NOT NULL,
  `uraian` text NOT NULL,
  `tindakan` text,
  `target` text,
  `status` varchar(50) NOT NULL,
  `tgl` datetime NOT NULL,
  `id_auditor` int(11) NOT NULL,
  `tgl_perbaikan` date DEFAULT NULL,
  PRIMARY KEY (`id_audit`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_auditor`
--

DROP TABLE IF EXISTS `ami_auditor`;
CREATE TABLE IF NOT EXISTS `ami_auditor` (
  `id_auditor` int(11) NOT NULL AUTO_INCREMENT,
  `id_fakultas` int(11) NOT NULL,
  `id_prodi` int(11) NOT NULL,
  `auditor` varchar(200) NOT NULL,
  `nidn` varchar(10) NOT NULL,
  `niknip` varchar(20) DEFAULT NULL,
  `telp` varchar(15) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `foto` text,
  `password` varchar(200) NOT NULL,
  `id_siklus` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_auditor`),
  UNIQUE KEY `nidn` (`nidn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_fakultas`
--

DROP TABLE IF EXISTS `ami_fakultas`;
CREATE TABLE IF NOT EXISTS `ami_fakultas` (
  `id_fakultas` int(11) NOT NULL AUTO_INCREMENT,
  `fakultas` varchar(100) NOT NULL,
  `dekan` varchar(100) NOT NULL,
  `nidn` varchar(10) NOT NULL,
  `niknip` varchar(20) DEFAULT NULL,
  `telp` varchar(15) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `foto` text,
  `password` varchar(200) NOT NULL,
  `id_siklus` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_fakultas`),
  UNIQUE KEY `fakultas` (`fakultas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_files`
--

DROP TABLE IF EXISTS `ami_files`;
CREATE TABLE IF NOT EXISTS `ami_files` (
  `id_file` int(11) NOT NULL AUTO_INCREMENT,
  `id_siklus` int(11) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `file` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `id_admin` int(11) NOT NULL,
  PRIMARY KEY (`id_file`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_files_prodi`
--

DROP TABLE IF EXISTS `ami_files_prodi`;
CREATE TABLE IF NOT EXISTS `ami_files_prodi` (
  `id_file` int(11) NOT NULL AUTO_INCREMENT,
  `id_siklus` int(11) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `file` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `id_admin` int(11) NOT NULL,
  PRIMARY KEY (`id_file`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_foto`
--

DROP TABLE IF EXISTS `ami_foto`;
CREATE TABLE IF NOT EXISTS `ami_foto` (
  `id_foto` int(11) NOT NULL AUTO_INCREMENT,
  `id_ami` int(11) NOT NULL,
  `foto` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `id_auditor` int(11) NOT NULL,
  PRIMARY KEY (`id_foto`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_jenjang`
--

DROP TABLE IF EXISTS `ami_jenjang`;
CREATE TABLE IF NOT EXISTS `ami_jenjang` (
  `id_jenjang` int(11) NOT NULL AUTO_INCREMENT,
  `jenjang` varchar(20) NOT NULL,
  PRIMARY KEY (`id_jenjang`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `ami_jenjang`
--

INSERT INTO `ami_jenjang` (`id_jenjang`, `jenjang`) VALUES
(1, 'Diploma'),
(2, 'Sarjana'),
(3, 'Magister'),
(4, 'Doktor');

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_kesimpulan`
--

DROP TABLE IF EXISTS `ami_kesimpulan`;
CREATE TABLE IF NOT EXISTS `ami_kesimpulan` (
  `id_kesimpulan` int(11) NOT NULL AUTO_INCREMENT,
  `id_ami` int(11) NOT NULL,
  `ckp_lengkap` varchar(10) NOT NULL,
  `sebutkan` text,
  `tgl` datetime DEFAULT NULL,
  `id_auditor` int(11) NOT NULL,
  PRIMARY KEY (`id_kesimpulan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_kts`
--

DROP TABLE IF EXISTS `ami_kts`;
CREATE TABLE IF NOT EXISTS `ami_kts` (
  `id_kts` int(11) NOT NULL AUTO_INCREMENT,
  `kts` varchar(20) NOT NULL,
  PRIMARY KEY (`id_kts`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `ami_kts`
--

INSERT INTO `ami_kts` (`id_kts`, `kts`) VALUES
(1, 'Mayor'),
(2, 'Minor'),
(3, 'Observasi');

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_mekanisme`
--

DROP TABLE IF EXISTS `ami_mekanisme`;
CREATE TABLE IF NOT EXISTS `ami_mekanisme` (
  `id_mekanisme` int(11) NOT NULL AUTO_INCREMENT,
  `id_ami` int(11) NOT NULL,
  `question1` varchar(5) NOT NULL,
  `question2` varchar(5) NOT NULL,
  `question3` varchar(5) NOT NULL,
  `question4` varchar(5) NOT NULL,
  `question5` varchar(5) NOT NULL,
  `question6` varchar(5) NOT NULL,
  `tgl` datetime DEFAULT NULL,
  `id_auditor` int(11) NOT NULL,
  PRIMARY KEY (`id_mekanisme`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_prodi`
--

DROP TABLE IF EXISTS `ami_prodi`;
CREATE TABLE IF NOT EXISTS `ami_prodi` (
  `id_prodi` int(11) NOT NULL AUTO_INCREMENT,
  `id_fakultas` int(11) NOT NULL,
  `prodi` varchar(100) NOT NULL,
  `jenjang` varchar(10) NOT NULL,
  `kaprodi` varchar(200) NOT NULL,
  `nidn` varchar(10) NOT NULL,
  `niknip` varchar(20) DEFAULT NULL,
  `telp` varchar(15) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `foto` text,
  `password` varchar(200) NOT NULL,
  `id_siklus` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_prodi`),
  UNIQUE KEY `prodi` (`prodi`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_setting`
--

DROP TABLE IF EXISTS `ami_setting`;
CREATE TABLE IF NOT EXISTS `ami_setting` (
  `id_setting` int(11) NOT NULL AUTO_INCREMENT,
  `nm_pt` varchar(200) NOT NULL,
  `footer` varchar(200) NOT NULL,
  `favicon` varchar(100) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `kampus` varchar(100) NOT NULL,
  PRIMARY KEY (`id_setting`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `ami_setting`
--

INSERT INTO `ami_setting` (`id_setting`, `nm_pt`, `footer`, `favicon`, `logo`, `kampus`) VALUES
(1, 'Universitas Islam Kalimantan Muhammad Arsyad Al Banjari Banjarmasin', 'LPMutu Uniska', '640165608fc46.png', '640165608fed5.png', '6401656c50399.jpeg');

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_siklus`
--

DROP TABLE IF EXISTS `ami_siklus`;
CREATE TABLE IF NOT EXISTS `ami_siklus` (
  `id_siklus` int(11) NOT NULL AUTO_INCREMENT,
  `tahun` year(4) NOT NULL,
  PRIMARY KEY (`id_siklus`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `ami_siklus`
--

INSERT INTO `ami_siklus` (`id_siklus`, `tahun`) VALUES
(1, 2022);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ami_standar`
--

DROP TABLE IF EXISTS `ami_standar`;
CREATE TABLE IF NOT EXISTS `ami_standar` (
  `id_standar` int(11) NOT NULL AUTO_INCREMENT,
  `standar` varchar(200) DEFAULT NULL,
  `utk_pilihan` text NOT NULL,
  `isi` text NOT NULL,
  `id_siklus` int(11) NOT NULL,
  PRIMARY KEY (`id_standar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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 */;