1mCxWBF9

1DROP TABLE IF EXISTS `transaksi` ;
2 
3CREATE TABLE IF NOT EXISTS `transaksi` (
4  `id_transaksi` INT NOT NULL AUTO_INCREMENT,
5  `tanggal_produk` DATETIME NULL,
6  `total_transaksi` DECIMAL(8,2) NULL,
7  `diskon` DECIMAL(8,2) NULL,
8  `total_setelah_diskon` DECIMAL(8,2) NULL,
9  PRIMARY KEY (`id_transaksi`))
10ENGINE = InnoDB;
11 
12 
13-- -----------------------------------------------------
14-- Table `transaksi_detail`
15-- -----------------------------------------------------
16DROP TABLE IF EXISTS `transaksi_detail` ;
17 
18CREATE TABLE IF NOT EXISTS `transaksi_detail` (
19  `id_transaksi_detail` INT NOT NULL AUTO_INCREMENT,
20  `kode_produk` VARCHAR(8) NULL,
21  `qty` SMALLINT NULL,
22  `id_transaksi` INT NOT NULL,
23  PRIMARY KEY (`id_transaksi_detail`),
24  INDEX `fk_transaksi_detail_transaksi_idx` (`id_transaksi` ASC),
25  CONSTRAINT `fk_transaksi_detail_transaksi`
26    FOREIGN KEY (`id_transaksi`)
27    REFERENCES `transaksi` (`id_transaksi`)
28    ON DELETE CASCADE
29    ON UPDATE CASCADE)
30ENGINE = InnoDB;