Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE PAKET
- (
- ID_PAKET VARCHAR2(10) NOT NULL,
- DESTINASI VARCHAR2 (50),
- TRANSPORTASI VARCHAR2(50),
- KONSUMSI VARCHAR(50),
- KARGO NUMBER,
- CONSTRAINT PAKET_PK PRIMARY KEY (ID_PAKET)
- );
- CREATE TABLE TOUR_GUIDE
- (
- ID_TOUR_GUIDE VARCHAR2(10) NOT NULL,
- NAMA VARCHAR2(50),
- EMAIL VARCHAR2(20),
- NO_TELP VARCHAR2(15),
- ALAMAT VARCHAR2(50),
- KEMAMPUAN_BAHASA VARCHAR2(20),
- ID_PAKET VARCHAR2(10),
- CONSTRAINT TOUR_GUIDE_PK PRIMARY KEY (ID_TOUR_GUIDE),
- CONSTRAINT TOUR_GUIDE_FK FOREIGN KEY (ID_PAKET) REFERENCES PAKET(ID_PAKET)
- );
- CREATE TABLE ADMIN
- (
- ID_ADMIN VARCHAR2(10) NOT NULL,
- NAMA VARCHAR2(50),
- EMAIL VARCHAR2(20),
- NO_TELP VARCHAR2(15),
- ALAMAT VARCHAR2(50),
- CONSTRAINT ADMIN_PK PRIMARY KEY (ID_ADMIN)
- );
- CREATE TABLE CUSTOMER
- (
- ID_CUSTOMER VARCHAR2(10) NOT NULL,
- NAMA VARCHAR2(50),
- TGL_LAHIR DATE,
- EMAIL VARCHAR2(20),
- NO_TELP VARCHAR2(15),
- ALAMAT VARCHAR2(50),
- ID_ADMIN VARCHAR(10),
- CONSTRAINT CUSTOMER_PK PRIMARY KEY (ID_CUSTOMER),
- CONSTRAINT CUSTOMER_FK FOREIGN KEY (ID_ADMIN) REFERENCES ADMIN(ID_ADMIN)
- );
- CREATE TABLE BANK
- (
- ID_BANK VARCHAR2(10) NOT NULL,
- NAMA VARCHAR2(50),
- EMAIL VARCHAR2(20),
- NO_TELP VARCHAR2(15),
- ALAMAT VARCHAR2(50),
- CONSTRAINT BANK_PK PRIMARY KEY (ID_BANK)
- );
- CREATE TABLE MEMESAN
- (
- ID_PESAN VARCHAR2(10) NOT NULL,
- ID_PAKET VARCHAR2(10),
- ID_CUSTOMER VARCHAR2(10),
- CONSTRAINT MEMESAN_PK PRIMARY KEY (ID_PESAN),
- CONSTRAINT MEMESAN_FK1 FOREIGN KEY (ID_PAKET) REFERENCES PAKET(ID_PAKET),
- CONSTRAINT MEMESAN_FK2 FOREIGN KEY (ID_CUSTOMER) REFERENCES CUSTOMER(ID_CUSTOMER)
- );
- CREATE TABLE DETIL_MEMESAN
- (
- ID_PESAN VARCHAR2(10),
- TGL_PESAN DATE,
- JUMLAH_ORANG NUMBER,
- TGL_BERANGKAT DATE,
- TGL_PULANG DATE,
- CONSTRAINT DETIL_MEMESAN_FK FOREIGN KEY (ID_PESAN) REFERENCES MEMESAN(ID_PESAN)
- );
- CREATE TABLE PEMBAYARAN
- (
- ID_PEMBAYARAN VARCHAR2(10) NOT NULL,
- ID_PESAN VARCHAR2(10),
- ID_BANK VARCHAR2(10),
- CONSTRAINT PEMBAYARAN_PK PRIMARY KEY (ID_PEMBAYARAN),
- CONSTRAINT PEMBAYARAN_FK1 FOREIGN KEY (ID_PESAN) REFERENCES MEMESAN(ID_PESAN),
- CONSTRAINT PEMBAYARAN_FK2 FOREIGN KEY (ID_BANK) REFERENCES BANK(ID_BANK)
- );
- CREATE TABLE DETIL_PEMBAYARAN
- (
- ID_PEMBAYARAN VARCHAR2(10),
- METODE VARCHAR2(20),
- TGL_PEMBAYARAN DATE,
- JAM_PEMBAYARAN TIMESTAMP,
- JUMLAH_HARGA NUMBER,
- CONSTRAINT DETIL_PEMBAYARAN_FK FOREIGN KEY (ID_PEMBAYARAN) REFERENCES PEMBAYARAN(ID_PEMBAYARAN)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement