Created
November 20, 2021 14:09
-
-
Save Razor-Sec/c0e4648d37c615ea404d6bf1c06d38d4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Kelompok Net | |
DROP DATABASE IF EXISTS sisdat_tokped; | |
CREATE DATABASE IF NOT EXISTS sisdat_tokped; | |
USE sisdat_tokped; | |
DROP TABLE IF EXISTS penjual; | |
CREATE TABLE penjual ( | |
id_penjual INT NOT NULL AUTO_INCREMENT, | |
nama VARCHAR(255), | |
kota VARCHAR(50), | |
desc_penjual VARCHAR(255) DEFAULT NULL, | |
no_telp VARCHAR(10) DEFAULT NULL, | |
PRIMARY KEY (id_penjual) | |
); | |
DROP TABLE IF EXISTS barang; | |
CREATE TABLE barang ( | |
kode_barang VARCHAR(10) NOT NULL, | |
id_penjual INT NOT NULL, | |
nama_barang VARCHAR(200), | |
stok_barang INT NOT NULL, | |
berat_barang DECIMAL(5,2), | |
berat_satuan VARCHAR(3), | |
harga_barang DECIMAL(10,2), | |
desc_barang VARCHAR(500), | |
PRIMARY KEY (kode_barang), | |
FOREIGN KEY (id_penjual) REFERENCES penjual (id_penjual) | |
); | |
DROP TABLE IF EXISTS pembeli; | |
CREATE TABLE pembeli ( | |
user_id INT NOT NULL AUTO_INCREMENT, | |
nama_pembeli VARCHAR(255), | |
alamat VARCHAR(255), | |
kode_pos VARCHAR(10), | |
no_telp VARCHAR(15), | |
PRIMARY KEY (user_id) | |
); | |
DROP TABLE IF EXISTS kurir; | |
CREATE TABLE kurir ( | |
kode_kurir VARCHAR(10), | |
nama_kurir VARCHAR(50), | |
desc_kurir VARCHAR(100), | |
PRIMARY KEY (kode_kurir) | |
); | |
DROP TABLE IF EXISTS kurir_detail; | |
CREATE TABLE kurir_detail ( | |
kode_detail_kurir VARCHAR(15), | |
detail_kurir VARCHAR(20), | |
kode_kurir VARCHAR(10), | |
harga_kurir INT, | |
PRIMARY KEY (kode_detail_kurir), | |
FOREIGN KEY (kode_kurir) REFERENCES kurir (kode_kurir) | |
); | |
DROP TABLE IF EXISTS transaksi; | |
CREATE TABLE transaksi ( | |
no_invoice VARCHAR(30) NOT NULL, | |
id_pembeli INT NOT NULL, | |
kode_detail_kurir VARCHAR(15) NOT NULL, | |
tanggal DATE NOT NULL, | |
total_harga DECIMAL(10, 3) NOT NULL, | |
metode_pembayaran VARCHAR(100) NOT NULL, | |
ansuransi DECIMAL(10, 3), | |
PRIMARY KEY (no_invoice), | |
FOREIGN KEY (id_pembeli) REFERENCES pembeli (user_id), | |
FOREIGN KEY (kode_detail_kurir) REFERENCES kurir_detail (kode_detail_kurir) | |
); | |
DROP TABLE IF EXISTS transaksi_detail; | |
CREATE TABLE transaksi_detail ( | |
no_invoice VARCHAR(30) NOT NULL, | |
kode_barang VARCHAR(10), | |
kuantitas INT, | |
FOREIGN KEY (no_invoice) REFERENCES transaksi (no_invoice), | |
FOREIGN KEY (kode_barang) REFERENCES barang (kode_barang) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment