Advertisement
ehardi19

[DDL]_Kelompok 7_Biro Perjalanan

Nov 14th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.54 KB | None | 0 0
  1. CREATE TABLE PAKET
  2. (
  3. ID_PAKET VARCHAR2(10) NOT NULL,
  4. DESTINASI VARCHAR2 (50),
  5. TRANSPORTASI VARCHAR2(50),
  6. KONSUMSI VARCHAR(50),
  7. KARGO NUMBER,
  8. CONSTRAINT PAKET_PK PRIMARY KEY (ID_PAKET)
  9. );
  10.  
  11. CREATE TABLE TOUR_GUIDE
  12. (
  13. ID_TOUR_GUIDE VARCHAR2(10) NOT NULL,
  14. NAMA VARCHAR2(50),
  15. EMAIL VARCHAR2(20),
  16. NO_TELP VARCHAR2(15),
  17. ALAMAT VARCHAR2(50),
  18. KEMAMPUAN_BAHASA VARCHAR2(20),
  19. ID_PAKET VARCHAR2(10),
  20. CONSTRAINT TOUR_GUIDE_PK PRIMARY KEY (ID_TOUR_GUIDE),
  21. CONSTRAINT TOUR_GUIDE_FK FOREIGN KEY (ID_PAKET) REFERENCES PAKET(ID_PAKET)
  22. );
  23.  
  24. CREATE TABLE ADMIN
  25. (
  26. ID_ADMIN VARCHAR2(10) NOT NULL,
  27. NAMA VARCHAR2(50),
  28. EMAIL VARCHAR2(20),
  29. NO_TELP VARCHAR2(15),
  30. ALAMAT VARCHAR2(50),
  31. CONSTRAINT ADMIN_PK PRIMARY KEY (ID_ADMIN)
  32. );
  33.  
  34.  
  35. CREATE TABLE CUSTOMER
  36. (
  37. ID_CUSTOMER VARCHAR2(10) NOT NULL,
  38. NAMA VARCHAR2(50),
  39. TGL_LAHIR DATE,
  40. EMAIL VARCHAR2(20),
  41. NO_TELP VARCHAR2(15),
  42. ALAMAT VARCHAR2(50),
  43. ID_ADMIN VARCHAR(10),
  44. CONSTRAINT CUSTOMER_PK PRIMARY KEY (ID_CUSTOMER),
  45. CONSTRAINT CUSTOMER_FK FOREIGN KEY (ID_ADMIN) REFERENCES ADMIN(ID_ADMIN)
  46. );
  47.  
  48. CREATE TABLE BANK
  49. (
  50. ID_BANK VARCHAR2(10) NOT NULL,
  51. NAMA VARCHAR2(50),
  52. EMAIL VARCHAR2(20),
  53. NO_TELP VARCHAR2(15),
  54. ALAMAT VARCHAR2(50),
  55. CONSTRAINT BANK_PK PRIMARY KEY (ID_BANK)
  56. );
  57.  
  58. CREATE TABLE MEMESAN
  59. (
  60. ID_PESAN VARCHAR2(10) NOT NULL,
  61. ID_PAKET VARCHAR2(10),
  62. ID_CUSTOMER VARCHAR2(10),
  63. CONSTRAINT MEMESAN_PK PRIMARY KEY (ID_PESAN),
  64. CONSTRAINT MEMESAN_FK1 FOREIGN KEY (ID_PAKET) REFERENCES PAKET(ID_PAKET),
  65. CONSTRAINT MEMESAN_FK2 FOREIGN KEY (ID_CUSTOMER) REFERENCES CUSTOMER(ID_CUSTOMER)
  66. );
  67.  
  68. CREATE TABLE DETIL_MEMESAN
  69. (
  70. ID_PESAN VARCHAR2(10),
  71. TGL_PESAN DATE,
  72. JUMLAH_ORANG NUMBER,
  73. TGL_BERANGKAT DATE,
  74. TGL_PULANG DATE,
  75. CONSTRAINT DETIL_MEMESAN_FK FOREIGN KEY (ID_PESAN) REFERENCES MEMESAN(ID_PESAN)
  76. );
  77.  
  78. CREATE TABLE PEMBAYARAN
  79. (
  80. ID_PEMBAYARAN VARCHAR2(10) NOT NULL,
  81. ID_PESAN VARCHAR2(10),
  82. ID_BANK VARCHAR2(10),
  83. CONSTRAINT PEMBAYARAN_PK PRIMARY KEY (ID_PEMBAYARAN),
  84. CONSTRAINT PEMBAYARAN_FK1 FOREIGN KEY (ID_PESAN) REFERENCES MEMESAN(ID_PESAN),
  85. CONSTRAINT PEMBAYARAN_FK2 FOREIGN KEY (ID_BANK) REFERENCES BANK(ID_BANK)
  86. );
  87.  
  88. CREATE TABLE DETIL_PEMBAYARAN
  89. (
  90. ID_PEMBAYARAN VARCHAR2(10),
  91. METODE VARCHAR2(20),
  92. TGL_PEMBAYARAN DATE,
  93. JAM_PEMBAYARAN TIMESTAMP,
  94. JUMLAH_HARGA NUMBER,
  95. CONSTRAINT DETIL_PEMBAYARAN_FK FOREIGN KEY (ID_PEMBAYARAN) REFERENCES PEMBAYARAN(ID_PEMBAYARAN)
  96. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement