» » Rancangan Database

Rancangan Database

 By Sistem Informasi PKL  on Jumat, 10 Mei 2019     Label: Rancangan 









-- phpMyAdmin SQL Dump
-- version 4.3.11
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 09, 2019 at 07:46 PM
-- Server version: 5.6.24
-- PHP Version: 5.6.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `pkl`
--

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

--
-- Table structure for table `ambil_pkl`
--

CREATE TABLE IF NOT EXISTS `ambil_pkl` (
  `id_kelompok` varchar(5) NOT NULL,
  `nim` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `baak`
--

CREATE TABLE IF NOT EXISTS `baak` (
  `id_baak` varchar(15) NOT NULL,
  `nama_baak` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bimbing_pkl`
--

CREATE TABLE IF NOT EXISTS `bimbing_pkl` (
  `id_kelompok` varchar(5) NOT NULL,
  `nip_dosen` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dosen`
--

CREATE TABLE IF NOT EXISTS `dosen` (
  `nip_dosen` varchar(15) NOT NULL,
  `nama_dosen` varchar(50) NOT NULL,
  `email_dosen` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `judul_pkl`
--

CREATE TABLE IF NOT EXISTS `judul_pkl` (
  `id_kelompok` varchar(5) NOT NULL,
  `judul` varchar(250) NOT NULL,
  `tempat` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `laporan`
--

CREATE TABLE IF NOT EXISTS `laporan` (
  `nim` varchar(15) NOT NULL,
  `file` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `mahasiswa`
--

CREATE TABLE IF NOT EXISTS `mahasiswa` (
  `nim` varchar(15) NOT NULL,
  `nama_mhs` varchar(50) NOT NULL,
  `email_mhs` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `nilai`
--

CREATE TABLE IF NOT EXISTS `nilai` (
  `nim` varchar(15) NOT NULL,
  `nilai_pkl` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `progdi`
--

CREATE TABLE IF NOT EXISTS `progdi` (
  `nip_progdi` varchar(15) NOT NULL,
  `nama_progdi` varchar(50) NOT NULL,
  `email_progdi` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `progres`
--

CREATE TABLE IF NOT EXISTS `progres` (
  `nim` varchar(15) NOT NULL,
  `catat1` text NOT NULL,
  `catat2` text NOT NULL,
  `catat3` text NOT NULL,
  `catat4` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `level` int(11) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `userlevelpermissions`
--

CREATE TABLE IF NOT EXISTS `userlevelpermissions` (
  `userlevelid` int(11) NOT NULL,
  `tablename` varchar(80) NOT NULL,
  `permission` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userlevelpermissions`
--

INSERT INTO `userlevelpermissions` (`userlevelid`, `tablename`, `permission`) VALUES
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}ambil_pkl', 0),
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}baak', 0),
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}bimbing_pkl', 0),
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}dosen', 0),
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}judul_pkl', 0),
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}mahasiswa', 0),
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}progdi', 0),
(-2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}user', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}ambil_pkl', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}baak', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}bimbing_pkl', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}dosen', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}judul_pkl', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}mahasiswa', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}progdi', 0),
(0, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}user', 0),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}ambil_pkl', 111),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}baak', 111),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}bimbing_pkl', 111),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}dosen', 111),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}judul_pkl', 111),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}mahasiswa', 111),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}progdi', 111),
(1, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}user', 111),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}ambil_pkl', 104),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}baak', 104),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}bimbing_pkl', 104),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}dosen', 104),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}judul_pkl', 104),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}mahasiswa', 104),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}progdi', 104),
(2, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}user', 104),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}ambil_pkl', 111),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}baak', 111),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}bimbing_pkl', 111),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}dosen', 111),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}judul_pkl', 111),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}mahasiswa', 111),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}progdi', 111),
(3, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}user', 111),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}ambil_pkl', 104),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}baak', 104),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}bimbing_pkl', 104),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}dosen', 104),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}judul_pkl', 104),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}mahasiswa', 104),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}progdi', 104),
(4, '{17E20CD8-4891-43BC-9B7C-DAA1269451AB}user', 104);

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

--
-- Table structure for table `userlevels`
--

CREATE TABLE IF NOT EXISTS `userlevels` (
  `userlevelid` int(11) NOT NULL,
  `userlevelname` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userlevels`
--

INSERT INTO `userlevels` (`userlevelid`, `userlevelname`) VALUES
(-2, 'Anonymous'),
(-1, 'Administrator'),
(0, 'Default'),
(1, 'mahasiswa'),
(2, 'dosen'),
(3, 'baak'),
(4, 'progdi');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ambil_pkl`
--
ALTER TABLE `ambil_pkl`
  ADD PRIMARY KEY (`id_kelompok`);

--
-- Indexes for table `baak`
--
ALTER TABLE `baak`
  ADD PRIMARY KEY (`id_baak`);

--
-- Indexes for table `bimbing_pkl`
--
ALTER TABLE `bimbing_pkl`
  ADD PRIMARY KEY (`id_kelompok`);

--
-- Indexes for table `dosen`
--
ALTER TABLE `dosen`
  ADD PRIMARY KEY (`nip_dosen`);

--
-- Indexes for table `judul_pkl`
--
ALTER TABLE `judul_pkl`
  ADD PRIMARY KEY (`id_kelompok`);

--
-- Indexes for table `laporan`
--
ALTER TABLE `laporan`
  ADD PRIMARY KEY (`nim`);

--
-- Indexes for table `mahasiswa`
--
ALTER TABLE `mahasiswa`
  ADD PRIMARY KEY (`nim`);

--
-- Indexes for table `nilai`
--
ALTER TABLE `nilai`
  ADD PRIMARY KEY (`nim`);

--
-- Indexes for table `progdi`
--
ALTER TABLE `progdi`
  ADD PRIMARY KEY (`nip_progdi`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`username`), ADD KEY `idx_user` (`username`);

--
-- Indexes for table `userlevelpermissions`
--
ALTER TABLE `userlevelpermissions`
  ADD PRIMARY KEY (`userlevelid`,`tablename`);

--
-- Indexes for table `userlevels`
--
ALTER TABLE `userlevels`
  ADD PRIMARY KEY (`userlevelid`);

/*!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 */;




download















  


















By



di












Label:



















Tidak ada komentar:















Posting Komentar




















        

      






















 ↑ 
J-Theme