-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 20, 2016 at 09:42 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.6

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

--
-- Database: `db_adminfinance`
--

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

--
-- Table structure for table `bbm`
--

CREATE TABLE `bbm` (
  `id_bbm` char(5) NOT NULL,
  `jenis_bbm` varchar(30) NOT NULL,
  `harga` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bbm`
--

INSERT INTO `bbm` (`id_bbm`, `jenis_bbm`, `harga`) VALUES
('Pre01', 'Premium', 6450),
('SOL01', 'Solar', 5150);

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

--
-- Table structure for table `karyawan`
--

CREATE TABLE `karyawan` (
  `nip` varchar(20) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `tgl_lhir` varchar(15) NOT NULL,
  `jenkel` varchar(10) NOT NULL,
  `alamat` varchar(70) NOT NULL,
  `no_tlp` varchar(13) NOT NULL,
  `jabatan` varchar(50) NOT NULL,
  `cabang` varchar(30) NOT NULL,
  `stts` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karyawan`
--

INSERT INTO `karyawan` (`nip`, `nama`, `tgl_lhir`, `jenkel`, `alamat`, `no_tlp`, `jabatan`, `cabang`, `stts`) VALUES
('880OMI', 'I Ketut Rastika', '1964-06-08', 'Laki-laki', 'Malawe', '00', 'SDM', 'Pusat', 'Aktif'),
('BB01', 'Bambang', '2016-07-23', 'Laki-laki', '-', '0', 'staf', 'Mataram', 'Aktif'),
('IDR01', 'Indra', '1000-07-01', 'Laki-laki', '-', '0', 'Staff', 'Mataram', 'Aktif'),
('MRZ01', 'Marzuki', '1000-06-01', 'Laki-laki', '-', '0', 'Staff', 'Mataram', 'Aktif'),
('MTJ1', 'Mujtahid', '1000-07-14', 'Laki-laki', '-', '0', 'Staff', 'Mataram', 'Aktif'),
('MZ0N', 'Mirzon', '2016-07-13', 'Laki-laki', '-', '0', 'Manager Spare Part', 'Pusat', 'Aktif'),
('RSL01', 'RUSLI', '2016-06-20', 'Laki-laki', '-', '0', 'Staff', 'Mataram', 'Aktif');

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `userid` varchar(20) NOT NULL,
  `pass` varchar(30) NOT NULL,
  `cabang` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`userid`, `pass`, `cabang`) VALUES
('areni', 'krida2016', 'pusat'),
('bu5et', '4llahuak', 'pusat'),
('kridamataram', 'krida2016', 'mataram'),
('kridaselong', 'krida2016', 'selong');

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

--
-- Table structure for table `supir`
--

CREATE TABLE `supir` (
  `kode` int(11) NOT NULL,
  `nip` varchar(20) NOT NULL,
  `nopol` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supir`
--

INSERT INTO `supir` (`kode`, `nip`, `nopol`) VALUES
(5, 'MZ0N', 'DR888KT'),
(9, '880OMI', 'DR1200AC'),
(10, 'MTJ1', 'DR9119AD'),
(11, 'IDR01', 'DR9339AD'),
(12, 'MRZ01', 'DR9004'),
(13, 'BB01', 'DR9669AD'),
(14, 'RSL01', 'PDC');

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

--
-- Table structure for table `trasportasi`
--

CREATE TABLE `trasportasi` (
  `nopol` char(10) NOT NULL,
  `jenis` char(10) NOT NULL,
  `tipe` varchar(30) NOT NULL,
  `ket` varchar(20) NOT NULL,
  `coa` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trasportasi`
--

INSERT INTO `trasportasi` (`nopol`, `jenis`, `tipe`, `ket`, `coa`) VALUES
('DR1200AC', 'Mobil', 'Avanza', 'Operasional', '511.02.06'),
('DR888KT', 'Mobil', 'Avanza', 'Operasional', '511.02.06'),
('DR9004', 'Mobil', '-', 'Pengiriman Kendaraan', '511.02.08'),
('DR9119AD', 'Mobil', '-', 'Pengiriman Kendaraan', '511.02.08'),
('DR9339AD', 'Mobil', '-', 'Pengiriman Kendaraan', '511.02.08'),
('DR9669AD', 'Mobil', '-', 'Pengiriman Kendaraan', '511.02.08'),
('PDC', 'Motor', '-', 'Baru', '511.03.10');

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

--
-- Table structure for table `voucher`
--

CREATE TABLE `voucher` (
  `no_voucher` int(11) NOT NULL,
  `tgl_voucher` varchar(13) NOT NULL,
  `jam` varchar(13) NOT NULL,
  `nip` varchar(20) NOT NULL,
  `nopol` char(10) NOT NULL,
  `km_akhir` varchar(30) NOT NULL,
  `id_bbm` char(5) NOT NULL,
  `liter` varchar(12) NOT NULL,
  `total` decimal(10,0) DEFAULT NULL,
  `cabang` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voucher`
--

INSERT INTO `voucher` (`no_voucher`, `tgl_voucher`, `jam`, `nip`, `nopol`, `km_akhir`, `id_bbm`, `liter`, `total`, `cabang`) VALUES
(5, '23-07-2016', '10:36:02', 'BB01', 'DR9669AD', '8140', 'Pre01', '20', '129000', 'mataram'),
(6, '23-07-2016', '10:36:34', 'MRZ01', 'DR9004', '16251', 'Pre01', '20', '129000', 'mataram'),
(7, '20-06-2016', '10:47:11', 'RSL01', 'PDC', '1', 'Pre01', '20', '129000', 'mataram');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bbm`
--
ALTER TABLE `bbm`
  ADD PRIMARY KEY (`id_bbm`);

--
-- Indexes for table `karyawan`
--
ALTER TABLE `karyawan`
  ADD PRIMARY KEY (`nip`);

--
-- Indexes for table `login`
--
ALTER TABLE `login`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `supir`
--
ALTER TABLE `supir`
  ADD PRIMARY KEY (`kode`),
  ADD KEY `nip` (`nip`),
  ADD KEY `nopol` (`nopol`);

--
-- Indexes for table `trasportasi`
--
ALTER TABLE `trasportasi`
  ADD PRIMARY KEY (`nopol`);

--
-- Indexes for table `voucher`
--
ALTER TABLE `voucher`
  ADD PRIMARY KEY (`no_voucher`),
  ADD KEY `nip` (`nip`),
  ADD KEY `nopol` (`nopol`),
  ADD KEY `id_bbm` (`id_bbm`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `supir`
--
ALTER TABLE `supir`
  MODIFY `kode` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `voucher`
--
ALTER TABLE `voucher`
  MODIFY `no_voucher` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `supir`
--
ALTER TABLE `supir`
  ADD CONSTRAINT `supir_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `karyawan` (`nip`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `supir_ibfk_2` FOREIGN KEY (`nopol`) REFERENCES `trasportasi` (`nopol`) ON DELETE NO ACTION ON UPDATE CASCADE;

--
-- Constraints for table `voucher`
--
ALTER TABLE `voucher`
  ADD CONSTRAINT `voucher_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `karyawan` (`nip`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `voucher_ibfk_2` FOREIGN KEY (`nopol`) REFERENCES `trasportasi` (`nopol`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `voucher_ibfk_3` FOREIGN KEY (`id_bbm`) REFERENCES `bbm` (`id_bbm`) ON DELETE NO ACTION ON UPDATE CASCADE;

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