5u6u6puX

1drop table if exists kategoriProduk;
2create table kategoriProduk (
3id BIGINT(20) not null auto_increment primary key,
4nama varchar(255)
5);
6
7drop table if exists produk;
8create table produk (
9id BIGINT(20) not null auto_increment primary key,
10idKategori BIGINT(20) null,
11nama varchar(255) not null,
12harga double(10, 2) not null,
13stok int(10) not null,
14diskon double(10, 2) null,
15foreign key (IDKategori) references kategoriProduk(ID) on delete cascade on update cascade
16);
17
18drop table if exists supplier;
19create table supplier (
20id BIGINT(20) not null auto_increment primary key,
21nama varchar(255) not null,
22alamat varchar(255) not null,
23kota varchar(32) not null,
24no_telepon varchar(16) not null
25);
26
27drop table if exists pembelian;
28create table pembelian (
29id BIGINT(20) not null auto_increment primary key,
30idSupplier bigint(20) null,
31no_nota varchar(16) not null unique,
32tanggal date not null,
33status_pembayaran enum('1', '2') default 1 comment '1=lunas, 2=belum lunas',
34metode_pembayaran varchar(32) not null,
35diskon double(10, 2) null,
36status_pengiriman enum('1', '2', '3') default 1 comment '1=belum dikirim, 2=dalam pengiriman, 3=sudah sampai',
37biaya_pengiriman double(10, 2) not null,
38total_harga double(10, 2) not null,
39keterangan text null,
40foreign key (idSupplier) references supplier (id) on delete set null on update cascade);
41
42drop table if exists detailPembelian;
43create table detailPembelian (
44id BIGINT(20) not null auto_increment primary key,
45idPembelian BIGINT(20) null,
46idProduk BIGINT(20) null,
47jumlah_pembelian int(10) not null,
48harga double(10, 2) not null,
49foreign key (idPembelian) references pembelian (id) on delete cascade on update cascade,
50foreign key (idProduk) references produk (id) on delete cascade on update cascade);