/*
SQLyog Community v12.5.1 (64 bit)
MySQL - 5.7.21-log : Database - penjualan
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`penjualan` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `penjualan`;

/*Table structure for table `barang` */

DROP TABLE IF EXISTS `barang`;

CREATE TABLE `barang` (
  `id_barang` char(4) NOT NULL,
  `nama` varchar(25) NOT NULL,
  `stok` int(11) NOT NULL,
  `harga` decimal(10,0) NOT NULL,
  `persen_laba` decimal(10,0) DEFAULT NULL,
  `diskon` decimal(10,0) DEFAULT NULL,
  `id_jenis_brg` char(4) NOT NULL,
  `id_suplier` char(4) DEFAULT NULL,
  PRIMARY KEY (`id_barang`),
  KEY `fk_jenis_barang_barang` (`id_jenis_brg`),
  KEY `fk_suplier_barang` (`id_suplier`),
  CONSTRAINT `fk_jenis_barang_barang` FOREIGN KEY (`id_jenis_brg`) REFERENCES `jenis_barang` (`id_jenis_brg`),
  CONSTRAINT `fk_suplier_barang` FOREIGN KEY (`id_suplier`) REFERENCES `suplier` (`id_suplier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `detail_transaksi` */

DROP TABLE IF EXISTS `detail_transaksi`;

CREATE TABLE `detail_transaksi` (
  `kode_transaksi` char(4) DEFAULT NULL,
  `id_barang` char(4) DEFAULT NULL,
  `jumlah` int(11) DEFAULT NULL,
  KEY `fk_transaksi_detail_transaksi` (`kode_transaksi`),
  KEY `fk__barang_detail_transaksi` (`id_barang`),
  CONSTRAINT `fk__barang_detail_transaksi` FOREIGN KEY (`id_barang`) REFERENCES `barang` (`id_barang`),
  CONSTRAINT `fk_transaksi_detail_transaksi` FOREIGN KEY (`kode_transaksi`) REFERENCES `transaksi` (`kode_transaksi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `jenis_barang` */

DROP TABLE IF EXISTS `jenis_barang`;

CREATE TABLE `jenis_barang` (
  `id_jenis_brg` char(4) NOT NULL,
  `nama_jenis_brg` varbinary(20) NOT NULL,
  PRIMARY KEY (`id_jenis_brg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `karyawan` */

DROP TABLE IF EXISTS `karyawan`;

CREATE TABLE `karyawan` (
  `id_karyawan` char(4) NOT NULL,
  `nama` varchar(25) NOT NULL,
  `alamat` varchar(50) NOT NULL,
  `telepon` char(12) DEFAULT NULL,
  `tgl_lahir` date NOT NULL,
  `gaji` decimal(10,0) NOT NULL,
  PRIMARY KEY (`id_karyawan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `pelanggan` */

DROP TABLE IF EXISTS `pelanggan`;

CREATE TABLE `pelanggan` (
  `id_pelanggan` char(4) NOT NULL,
  `nama` varchar(25) NOT NULL,
  `jenis_kelamin` char(1) DEFAULT NULL,
  `alamat` varchar(50) NOT NULL,
  `telepon` char(12) DEFAULT NULL,
  `tgl_lahir` date NOT NULL,
  `jenis_pelanggan` enum('S','G') NOT NULL,
  PRIMARY KEY (`id_pelanggan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `suplier` */

DROP TABLE IF EXISTS `suplier`;

CREATE TABLE `suplier` (
  `id_suplier` char(4) NOT NULL,
  `nama` varchar(25) NOT NULL,
  `alamat` varchar(50) NOT NULL,
  `telepon` char(12) DEFAULT NULL,
  PRIMARY KEY (`id_suplier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `transaksi` */

DROP TABLE IF EXISTS `transaksi`;

CREATE TABLE `transaksi` (
  `kode_transaksi` char(4) NOT NULL,
  `tgl_transaksi` date NOT NULL,
  `id_pelanggan` char(4) DEFAULT NULL,
  `id_karyawan` char(4) NOT NULL,
  PRIMARY KEY (`kode_transaksi`),
  KEY `fk_pelanggan_transaksi` (`id_pelanggan`),
  KEY `fk_karyawan_transaksi` (`id_karyawan`),
  CONSTRAINT `fk_karyawan_transaksi` FOREIGN KEY (`id_karyawan`) REFERENCES `karyawan` (`id_karyawan`),
  CONSTRAINT `fk_pelanggan_transaksi` FOREIGN KEY (`id_pelanggan`) REFERENCES `pelanggan` (`id_pelanggan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;