db_reservation.sql

--------------------------------------------------------
--  File created - Thursday-July-02-2020   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Sequence SEQ_ADDITIONAL_CHARGE
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_ADDITIONAL_CHARGE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 15 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_CUSTOMER
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_CUSTOMER"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 47 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_PAYMENT_STATUS
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_PAYMENT_STATUS"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 7 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_PAYMENT_TYPE
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_PAYMENT_TYPE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 7 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_RESERVATION
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_RESERVATION"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 12 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_RESERVATION_PAYMENT
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_RESERVATION_PAYMENT"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 11 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_RESERVATION_STATUS
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_RESERVATION_STATUS"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 7 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_RESERVATION_TYPE
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_RESERVATION_TYPE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 4 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_ROLE_USER
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_ROLE_USER"  MINVALUE 1 MAXVALUE 99 INCREMENT BY 1 START WITH 11 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_ROOM
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_ROOM"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 15 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_ROOM_RATE
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_ROOM_RATE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 13 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_ROOM_TYPE
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_ROOM_TYPE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 13 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_TRAVEL_AGENT
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_TRAVEL_AGENT"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 18 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_USER
--------------------------------------------------------

   CREATE SEQUENCE  "SYARIFUDDIN_06989"."SEQ_USER"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 24 NOCACHE  NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Table ADDITIONAL_CHARGE
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."ADDITIONAL_CHARGE" 
   (	"ID_ADDITIONAL_CHARGE" NUMBER(*,0), 
	"NAME_CHARGE" VARCHAR2(150 BYTE), 
	"AMOUNT_CHARGE" NUMBER(19,0), 
	"ID_RESERVATION" NUMBER(*,0), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table CUSTOMER
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."CUSTOMER" 
   (	"ID_CUSTOMER" NUMBER(*,0), 
	"NAME" VARCHAR2(150 BYTE), 
	"EMAIL" VARCHAR2(150 BYTE), 
	"PHONE_NUMBER" VARCHAR2(16 BYTE), 
	"ADDRESS" VARCHAR2(255 BYTE), 
	"NIK" VARCHAR2(100 BYTE), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table PAYMENT_STATUS
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."PAYMENT_STATUS" 
   (	"ID_PAYMENT_STATUS" NUMBER(*,0), 
	"NAME_PAYMENT_STATUS" VARCHAR2(100 BYTE), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table PAYMENT_TYPE
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."PAYMENT_TYPE" 
   (	"ID_PAYMENT_TYPE" NUMBER(*,0), 
	"NAME_PAYMENT_TYPE" VARCHAR2(100 BYTE), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table RESERVATION
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."RESERVATION" 
   (	"ID_RESERVATION" NUMBER(*,0), 
	"CODE_RESERVATION" VARCHAR2(16 BYTE), 
	"DATE_RESERVATION" TIMESTAMP (6), 
	"ARRIVAL_DATE" TIMESTAMP (6), 
	"DEPARTURE_DATE" TIMESTAMP (6), 
	"LONG_STAY" NUMBER(*,0), 
	"CHECKIN_DATE" TIMESTAMP (6), 
	"CHECKOUT_DATE" TIMESTAMP (6), 
	"ID_CUSTOMER" NUMBER(*,0), 
	"ID_ROOM" NUMBER(*,0), 
	"RESERVATION_STATUS" NUMBER(*,0), 
	"RESERVATION_TYPE" NUMBER(*,0), 
	"CHECKIN_BY" NUMBER(*,0), 
	"CHECKOUT_BY" NUMBER(*,0), 
	"TRAVEL_AGENT" NUMBER(*,0), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table RESERVATION_PAYMENT
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" 
   (	"ID_RESERVATION_PAYMENT" NUMBER(*,0), 
	"ID_RESERVATION" NUMBER(*,0), 
	"PAYMENT_TYPE" NUMBER(*,0), 
	"PAYMENT_STATUS" NUMBER(*,0), 
	"AMOUNT_PAYMENT" NUMBER(19,0), 
	"AMOUNT_ADDITIONAL_CHARGE" NUMBER(19,0), 
	"GRAND_TOTAL_PAYMENT" NUMBER(19,0), 
	"DATE_PAYMENT" TIMESTAMP (6), 
	"CREATED_BY" NUMBER(*,0), 
	"MODIFIED_BY" NUMBER(*,0), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table RESERVATION_STATUS
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."RESERVATION_STATUS" 
   (	"ID_RESERVATION_STATUS" NUMBER(*,0), 
	"NAME_RESERVATION_STATUS" VARCHAR2(150 BYTE), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table RESERVATION_TYPE
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."RESERVATION_TYPE" 
   (	"ID_RESERVATION_TYPE" NUMBER(*,0), 
	"NAME_RESERVATION_TYPE" VARCHAR2(150 BYTE), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table ROLE_USER
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."ROLE_USER" 
   (	"ID_ROLE" NUMBER(*,0), 
	"NAME_ROLE" VARCHAR2(100 BYTE), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table ROOM
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."ROOM" 
   (	"ID_ROOM" NUMBER(*,0), 
	"ROOM_NUMBER" NUMBER(*,0), 
	"ROOM_TYPE" NUMBER(*,0), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table ROOM_RATE
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."ROOM_RATE" 
   (	"ID_ROOM_RATE" NUMBER(*,0), 
	"NAME_ROOM_RATE" VARCHAR2(100 BYTE), 
	"PRICE_ROOM_RATE" NUMBER(19,0), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table ROOM_TYPE
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."ROOM_TYPE" 
   (	"ID_ROOM_TYPE" NUMBER(*,0), 
	"NAME_ROOM_TYPE" VARCHAR2(100 BYTE), 
	"ROOM_RATE" NUMBER(*,0), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table TRAVEL_AGENT
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."TRAVEL_AGENT" 
   (	"ID_TRAVEL_AGENT" NUMBER(*,0), 
	"CODE_TRAVEL_AGENT" VARCHAR2(16 BYTE), 
	"NAME_TRAVEL_AGENT" VARCHAR2(150 BYTE), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Table USERS
--------------------------------------------------------

  CREATE TABLE "SYARIFUDDIN_06989"."USERS" 
   (	"ID_USER" NUMBER(*,0), 
	"NAME_USER" VARCHAR2(150 BYTE), 
	"EMAIL_USER" VARCHAR2(150 BYTE), 
	"USERNAME" VARCHAR2(25 BYTE), 
	"ADDRESS_USER" VARCHAR2(255 BYTE), 
	"ROLE_USER" NUMBER(*,0), 
	"CREATED_AT" TIMESTAMP (6), 
	"MODIFIED_AT" TIMESTAMP (6), 
	"PASSWORD" VARCHAR2(255 BYTE), 
	"NIK_USER" VARCHAR2(100 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for View AVERAGE_MIN_MAX_CHARGE
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "SYARIFUDDIN_06989"."AVERAGE_MIN_MAX_CHARGE" ("RATA_RATA", "MAXIMUM", "MINIMUM") AS 
  SELECT AVG(ac.AMOUNT_CHARGE) AS rata_rata, MAX(ac.AMOUNT_CHARGE) AS maximum,MIN(ac.AMOUNT_CHARGE) AS minimum FROM RESERVATION res
RIGHT JOIN ADDITIONAL_CHARGE ac ON ac.ID_RESERVATION = res.ID_RESERVATION
RIGHT JOIN RESERVATION_PAYMENT resp ON resp.ID_RESERVATION = res.ID_RESERVATION
WHERE resp.PAYMENT_STATUS != 3 AND resp.AMOUNT_ADDITIONAL_CHARGE > 10000 
;
--------------------------------------------------------
--  DDL for View LIST_CUSTOMER
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "SYARIFUDDIN_06989"."LIST_CUSTOMER" ("ID_CUSTOMER", "NAME", "EMAIL", "PHONE_NUMBER", "ADDRESS", "NIK", "CREATED_AT", "MODIFIED_AT") AS 
  SELECT "ID_CUSTOMER","NAME","EMAIL","PHONE_NUMBER","ADDRESS","NIK","CREATED_AT","MODIFIED_AT" FROM CUSTOMER
;
--------------------------------------------------------
--  DDL for View LIST_ROOM_RATE
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "SYARIFUDDIN_06989"."LIST_ROOM_RATE" ("ID_ROOM_RATE", "NAME_ROOM_RATE", "PRICE_ROOM_RATE", "CREATED_AT", "MODIFIED_AT") AS 
  SELECT "ID_ROOM_RATE","NAME_ROOM_RATE","PRICE_ROOM_RATE","CREATED_AT","MODIFIED_AT" FROM SYARIFUDDIN_06989.ROOM_RATE
;
--------------------------------------------------------
--  DDL for View LIST_USER
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "SYARIFUDDIN_06989"."LIST_USER" ("NAME_USER", "USERNAME", "EMAIL_USER", "ADDRESS_USER", "NIK_USER", "NAME_ROLE") AS 
  SELECT u.NAME_USER,u.USERNAME,u.EMAIL_USER,u.ADDRESS_USER,u.NIK_USER,ru.NAME_ROLE FROM USERS u JOIN ROLE_USER ru ON ru.ID_ROLE = u.ROLE_USER
;
--------------------------------------------------------
--  DDL for View RESERVATION_PAYMENT_CHARGE
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "SYARIFUDDIN_06989"."RESERVATION_PAYMENT_CHARGE" ("CODE_RESERVATION", "DATE_RESERVATION", "ARRIVAL_DATE", "DEPARTURE_DATE", "AMOUNT_PAYMENT", "GRAND_TOTAL_PAYMENT", "AMOUNT_ADDITIONAL_CHARGE", "PAYMENT_STATUS", "PAYMENT_TYPE", "DATE_PAYMENT") AS 
  SELECT res.CODE_RESERVATION,res.DATE_RESERVATION,res.ARRIVAL_DATE,res.DEPARTURE_DATE,respay.AMOUNT_PAYMENT,respay.GRAND_TOTAL_PAYMENT,respay.AMOUNT_ADDITIONAL_CHARGE,respay.PAYMENT_STATUS,respay.PAYMENT_TYPE,respay.DATE_PAYMENT FROM RESERVATION res JOIN RESERVATION_PAYMENT respay ON respay.ID_RESERVATION = res.ID_RESERVATION WHERE res.ID_RESERVATION = 3
;
--------------------------------------------------------
--  DDL for View TOTAL_CHARGE_RESERVATION
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "SYARIFUDDIN_06989"."TOTAL_CHARGE_RESERVATION" ("CODE_RESERVATION", "AMOUNT_ADDITIONAL_CHARGE", "PAYMENT_STATUS", "PAYMENT_TYPE", "DATE_PAYMENT") AS 
  SELECT res.CODE_RESERVATION,
(SELECT sum(AMOUNT_CHARGE) FROM ADDITIONAL_CHARGE WHERE ID_ADDITIONAL_CHARGE = res.ID_RESERVATION) AS amount_additional_charge,
respay.PAYMENT_STATUS,respay.PAYMENT_TYPE,respay.DATE_PAYMENT
FROM RESERVATION res
LEFT JOIN ADDITIONAL_CHARGE ac ON ac.ID_RESERVATION = res.ID_RESERVATION
LEFT JOIN RESERVATION_PAYMENT respay ON respay.ID_RESERVATION = res.ID_RESERVATION
WHERE respay.AMOUNT_ADDITIONAL_CHARGE IS NOT NULL
;
REM INSERTING into SYARIFUDDIN_06989.ADDITIONAL_CHARGE
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (1,'Minibar',12000,1,to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (2,'Room Service',50000,1,to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (3,'Cafe',24000,2,to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (4,'Minibar',70000,2,to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (5,'Room Service',90000,3,to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.16.281168000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (11,'Gelas Pecah',25000,1,null,null);
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (13,'Pecah Gelas',25000,1,null,null);
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (14,'Snack',100000,1,null,null);
Insert into SYARIFUDDIN_06989.ADDITIONAL_CHARGE (ID_ADDITIONAL_CHARGE,NAME_CHARGE,AMOUNT_CHARGE,ID_RESERVATION,CREATED_AT,MODIFIED_AT) values (12,'Pecah Gelas',25000,1,null,null);
REM INSERTING into SYARIFUDDIN_06989.CUSTOMER
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (1,'Doni Setiawan','doni@email.com','123','Surabaya','1',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (2,'Dewi Sulis','sulis@email.com','345','Surabaya','2',to_timestamp('15-MAY-20 08.24.35.297623000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.35.297623000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (3,'Andri Pratama','pratama@email.com','456','Surabaya','3',to_timestamp('15-MAY-20 08.24.35.297623000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.35.297623000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (4,'Tina Setyawati','tina@email.com','678','Surabaya','4',to_timestamp('15-MAY-20 08.24.35.297623000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.24.35.297623000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (5,'Syarif','syarif@email.com','891','Surabaya','53232',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (24,'wqwq','4rer@rer','3232','ererer','323',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (25,'ewew','eww@fff','323','ewew','3232',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (26,'wqwq','ewew2@fdf','223','dfdf','211',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (27,'wqw2','wre@fd','323','fdfdf','32',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (29,'ewewe','23ew@ffd','323','ffdf','232323',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (30,'sasas','3a@ffdd','323','fdfdf','2323',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (31,'sasa','sdsd@dsd','2121','ewew','2121',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (32,'seew','32ew@e','3232','erfdvgdf','232',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (33,'wqw','ewew@rfdfd','323','dfdfd','2323',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (34,'dsds','ewew@','212','fdff','212',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (35,'dsds','ewe!@fdfd','2323','fddfdf','2223',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (36,'dsds','dsds@dfd','323','edfdg','2132332',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (37,'ssaa','ddsd@ffd','2343','dfgfg','222',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (38,'sasas','wew@fdfd','323','fdfdf','2323',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (39,'sasa','rere@fdfd','212','fdfdf','2121',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (40,'sas','eew@dfd','323','dfdfd','232',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (42,'sas','ewe@ffdf','3232','fdfe','221',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (43,'xsdsd','ee@fdf','212','fdfd','2121',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (44,'sasa','ddf@fdf','212','fdfdf','2121',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (45,'wqwq','22eewew','212','ewewe','2121',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (46,'wqwq','fdf@fdf','212','fdfdf','212',null,null);
Insert into SYARIFUDDIN_06989.CUSTOMER (ID_CUSTOMER,NAME,EMAIL,PHONE_NUMBER,ADDRESS,NIK,CREATED_AT,MODIFIED_AT) values (41,'sdsd','ewew@ewe','232','reerr','2121',null,null);
REM INSERTING into SYARIFUDDIN_06989.PAYMENT_STATUS
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.PAYMENT_STATUS (ID_PAYMENT_STATUS,NAME_PAYMENT_STATUS,CREATED_AT,MODIFIED_AT) values (1,'Success',to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_STATUS (ID_PAYMENT_STATUS,NAME_PAYMENT_STATUS,CREATED_AT,MODIFIED_AT) values (2,'Pending',to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_STATUS (ID_PAYMENT_STATUS,NAME_PAYMENT_STATUS,CREATED_AT,MODIFIED_AT) values (3,'Cancel',to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_STATUS (ID_PAYMENT_STATUS,NAME_PAYMENT_STATUS,CREATED_AT,MODIFIED_AT) values (4,'Blocked',to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_STATUS (ID_PAYMENT_STATUS,NAME_PAYMENT_STATUS,CREATED_AT,MODIFIED_AT) values (5,'Rejected',to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.16.031018000 PM','DD-MON-RR HH.MI.SSXFF AM'));
REM INSERTING into SYARIFUDDIN_06989.PAYMENT_TYPE
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.PAYMENT_TYPE (ID_PAYMENT_TYPE,NAME_PAYMENT_TYPE,CREATED_AT,MODIFIED_AT) values (1,'Cash',to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_TYPE (ID_PAYMENT_TYPE,NAME_PAYMENT_TYPE,CREATED_AT,MODIFIED_AT) values (2,'Transfer',to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_TYPE (ID_PAYMENT_TYPE,NAME_PAYMENT_TYPE,CREATED_AT,MODIFIED_AT) values (3,'Merchant',to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_TYPE (ID_PAYMENT_TYPE,NAME_PAYMENT_TYPE,CREATED_AT,MODIFIED_AT) values (4,'Credit Card',to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.PAYMENT_TYPE (ID_PAYMENT_TYPE,NAME_PAYMENT_TYPE,CREATED_AT,MODIFIED_AT) values (5,'Online Payment',to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.36.49.606960000 PM','DD-MON-RR HH.MI.SSXFF AM'));
REM INSERTING into SYARIFUDDIN_06989.RESERVATION
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.RESERVATION (ID_RESERVATION,CODE_RESERVATION,DATE_RESERVATION,ARRIVAL_DATE,DEPARTURE_DATE,LONG_STAY,CHECKIN_DATE,CHECKOUT_DATE,ID_CUSTOMER,ID_ROOM,RESERVATION_STATUS,RESERVATION_TYPE,CHECKIN_BY,CHECKOUT_BY,TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (1,'RES-00001',to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('17-MAY-20 08.38.41.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),2,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),1,1,2,1,2,1,5,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION (ID_RESERVATION,CODE_RESERVATION,DATE_RESERVATION,ARRIVAL_DATE,DEPARTURE_DATE,LONG_STAY,CHECKIN_DATE,CHECKOUT_DATE,ID_CUSTOMER,ID_ROOM,RESERVATION_STATUS,RESERVATION_TYPE,CHECKIN_BY,CHECKOUT_BY,TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (2,'RES-00002',to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('17-MAY-20 08.38.41.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),2,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),2,1,2,1,2,1,null,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION (ID_RESERVATION,CODE_RESERVATION,DATE_RESERVATION,ARRIVAL_DATE,DEPARTURE_DATE,LONG_STAY,CHECKIN_DATE,CHECKOUT_DATE,ID_CUSTOMER,ID_ROOM,RESERVATION_STATUS,RESERVATION_TYPE,CHECKIN_BY,CHECKOUT_BY,TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (3,'RES-00003',to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('17-MAY-20 08.38.41.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),2,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),5,2,3,1,2,1,1,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION (ID_RESERVATION,CODE_RESERVATION,DATE_RESERVATION,ARRIVAL_DATE,DEPARTURE_DATE,LONG_STAY,CHECKIN_DATE,CHECKOUT_DATE,ID_CUSTOMER,ID_ROOM,RESERVATION_STATUS,RESERVATION_TYPE,CHECKIN_BY,CHECKOUT_BY,TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (4,'RES-00004',to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('17-MAY-20 08.38.41.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),2,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),3,2,1,1,2,1,null,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION (ID_RESERVATION,CODE_RESERVATION,DATE_RESERVATION,ARRIVAL_DATE,DEPARTURE_DATE,LONG_STAY,CHECKIN_DATE,CHECKOUT_DATE,ID_CUSTOMER,ID_ROOM,RESERVATION_STATUS,RESERVATION_TYPE,CHECKIN_BY,CHECKOUT_BY,TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (5,'RES-00005',to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('17-MAY-20 08.38.41.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),2,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),4,2,1,1,2,1,null,to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.41.469415000 PM','DD-MON-RR HH.MI.SSXFF AM'));
REM INSERTING into SYARIFUDDIN_06989.RESERVATION_PAYMENT
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.RESERVATION_PAYMENT (ID_RESERVATION_PAYMENT,ID_RESERVATION,PAYMENT_TYPE,PAYMENT_STATUS,AMOUNT_PAYMENT,AMOUNT_ADDITIONAL_CHARGE,GRAND_TOTAL_PAYMENT,DATE_PAYMENT,CREATED_BY,MODIFIED_BY,CREATED_AT,MODIFIED_AT) values (1,1,1,3,500000,62000,562000,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),1,2,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_PAYMENT (ID_RESERVATION_PAYMENT,ID_RESERVATION,PAYMENT_TYPE,PAYMENT_STATUS,AMOUNT_PAYMENT,AMOUNT_ADDITIONAL_CHARGE,GRAND_TOTAL_PAYMENT,DATE_PAYMENT,CREATED_BY,MODIFIED_BY,CREATED_AT,MODIFIED_AT) values (2,2,2,2,700000,94000,794000,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),1,2,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_PAYMENT (ID_RESERVATION_PAYMENT,ID_RESERVATION,PAYMENT_TYPE,PAYMENT_STATUS,AMOUNT_PAYMENT,AMOUNT_ADDITIONAL_CHARGE,GRAND_TOTAL_PAYMENT,DATE_PAYMENT,CREATED_BY,MODIFIED_BY,CREATED_AT,MODIFIED_AT) values (3,3,3,3,900000,90000,990000,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),1,2,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_PAYMENT (ID_RESERVATION_PAYMENT,ID_RESERVATION,PAYMENT_TYPE,PAYMENT_STATUS,AMOUNT_PAYMENT,AMOUNT_ADDITIONAL_CHARGE,GRAND_TOTAL_PAYMENT,DATE_PAYMENT,CREATED_BY,MODIFIED_BY,CREATED_AT,MODIFIED_AT) values (4,4,2,3,1100000,null,1100000,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),1,2,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_PAYMENT (ID_RESERVATION_PAYMENT,ID_RESERVATION,PAYMENT_TYPE,PAYMENT_STATUS,AMOUNT_PAYMENT,AMOUNT_ADDITIONAL_CHARGE,GRAND_TOTAL_PAYMENT,DATE_PAYMENT,CREATED_BY,MODIFIED_BY,CREATED_AT,MODIFIED_AT) values (5,5,1,2,1300000,null,1300000,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),1,2,to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.37.08.849944000 PM','DD-MON-RR HH.MI.SSXFF AM'));
REM INSERTING into SYARIFUDDIN_06989.RESERVATION_STATUS
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.RESERVATION_STATUS (ID_RESERVATION_STATUS,NAME_RESERVATION_STATUS,CREATED_AT,MODIFIED_AT) values (1,'Confirmed',to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_STATUS (ID_RESERVATION_STATUS,NAME_RESERVATION_STATUS,CREATED_AT,MODIFIED_AT) values (2,'Booked',to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_STATUS (ID_RESERVATION_STATUS,NAME_RESERVATION_STATUS,CREATED_AT,MODIFIED_AT) values (3,'Reserved',to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_STATUS (ID_RESERVATION_STATUS,NAME_RESERVATION_STATUS,CREATED_AT,MODIFIED_AT) values (4,'Pending',to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_STATUS (ID_RESERVATION_STATUS,NAME_RESERVATION_STATUS,CREATED_AT,MODIFIED_AT) values (5,'Rejected',to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.15.067966000 PM','DD-MON-RR HH.MI.SSXFF AM'));
REM INSERTING into SYARIFUDDIN_06989.RESERVATION_TYPE
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.RESERVATION_TYPE (ID_RESERVATION_TYPE,NAME_RESERVATION_TYPE,CREATED_AT,MODIFIED_AT) values (1,'Personal',to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_TYPE (ID_RESERVATION_TYPE,NAME_RESERVATION_TYPE,CREATED_AT,MODIFIED_AT) values (2,'Company',to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_TYPE (ID_RESERVATION_TYPE,NAME_RESERVATION_TYPE,CREATED_AT,MODIFIED_AT) values (3,'Online Travel Agent',to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_TYPE (ID_RESERVATION_TYPE,NAME_RESERVATION_TYPE,CREATED_AT,MODIFIED_AT) values (4,'Goverment',to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.RESERVATION_TYPE (ID_RESERVATION_TYPE,NAME_RESERVATION_TYPE,CREATED_AT,MODIFIED_AT) values (5,'Bussnis',to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.26.798838000 PM','DD-MON-RR HH.MI.SSXFF AM'));
REM INSERTING into SYARIFUDDIN_06989.ROLE_USER
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.ROLE_USER (ID_ROLE,NAME_ROLE,CREATED_AT,MODIFIED_AT) values (1,'Administrator',to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROLE_USER (ID_ROLE,NAME_ROLE,CREATED_AT,MODIFIED_AT) values (2,'Staff',to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROLE_USER (ID_ROLE,NAME_ROLE,CREATED_AT,MODIFIED_AT) values (3,'Roomboy',to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROLE_USER (ID_ROLE,NAME_ROLE,CREATED_AT,MODIFIED_AT) values (4,'Waitres',to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROLE_USER (ID_ROLE,NAME_ROLE,CREATED_AT,MODIFIED_AT) values (5,'Cashier',to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.38.51.323714000 PM','DD-MON-RR HH.MI.SSXFF AM'));
REM INSERTING into SYARIFUDDIN_06989.ROOM
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.ROOM (ID_ROOM,ROOM_NUMBER,ROOM_TYPE,CREATED_AT,MODIFIED_AT) values (1,101,1,to_timestamp('15-MAY-20 08.39.47.684231000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.47.684231000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM (ID_ROOM,ROOM_NUMBER,ROOM_TYPE,CREATED_AT,MODIFIED_AT) values (2,102,2,to_timestamp('15-MAY-20 08.39.47.684231000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.47.684231000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM (ID_ROOM,ROOM_NUMBER,ROOM_TYPE,CREATED_AT,MODIFIED_AT) values (3,103,4,null,null);
Insert into SYARIFUDDIN_06989.ROOM (ID_ROOM,ROOM_NUMBER,ROOM_TYPE,CREATED_AT,MODIFIED_AT) values (4,104,4,to_timestamp('15-MAY-20 08.39.47.684231000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.47.684231000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM (ID_ROOM,ROOM_NUMBER,ROOM_TYPE,CREATED_AT,MODIFIED_AT) values (5,105,2,null,null);
Insert into SYARIFUDDIN_06989.ROOM (ID_ROOM,ROOM_NUMBER,ROOM_TYPE,CREATED_AT,MODIFIED_AT) values (14,456,2,null,null);
Insert into SYARIFUDDIN_06989.ROOM (ID_ROOM,ROOM_NUMBER,ROOM_TYPE,CREATED_AT,MODIFIED_AT) values (13,345,1,null,null);
REM INSERTING into SYARIFUDDIN_06989.ROOM_RATE
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.ROOM_RATE (ID_ROOM_RATE,NAME_ROOM_RATE,PRICE_ROOM_RATE,CREATED_AT,MODIFIED_AT) values (1,'Basic',250000,to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_RATE (ID_ROOM_RATE,NAME_ROOM_RATE,PRICE_ROOM_RATE,CREATED_AT,MODIFIED_AT) values (2,'Standard',350000,to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_RATE (ID_ROOM_RATE,NAME_ROOM_RATE,PRICE_ROOM_RATE,CREATED_AT,MODIFIED_AT) values (3,'Premium',450000,to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_RATE (ID_ROOM_RATE,NAME_ROOM_RATE,PRICE_ROOM_RATE,CREATED_AT,MODIFIED_AT) values (4,'Gold',550000,to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_RATE (ID_ROOM_RATE,NAME_ROOM_RATE,PRICE_ROOM_RATE,CREATED_AT,MODIFIED_AT) values (5,'Platinum',650000,to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.06.571682000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_RATE (ID_ROOM_RATE,NAME_ROOM_RATE,PRICE_ROOM_RATE,CREATED_AT,MODIFIED_AT) values (12,'Platinum Plus',850000,null,null);
REM INSERTING into SYARIFUDDIN_06989.ROOM_TYPE
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.ROOM_TYPE (ID_ROOM_TYPE,NAME_ROOM_TYPE,ROOM_RATE,CREATED_AT,MODIFIED_AT) values (1,'DELUXE 1',1,to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_TYPE (ID_ROOM_TYPE,NAME_ROOM_TYPE,ROOM_RATE,CREATED_AT,MODIFIED_AT) values (2,'DELUXE 2',2,to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_TYPE (ID_ROOM_TYPE,NAME_ROOM_TYPE,ROOM_RATE,CREATED_AT,MODIFIED_AT) values (3,'DELUXE 3',3,to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_TYPE (ID_ROOM_TYPE,NAME_ROOM_TYPE,ROOM_RATE,CREATED_AT,MODIFIED_AT) values (4,'DELUXE 4',4,to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_TYPE (ID_ROOM_TYPE,NAME_ROOM_TYPE,ROOM_RATE,CREATED_AT,MODIFIED_AT) values (5,'DELUXE 5',5,to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.23.364945000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.ROOM_TYPE (ID_ROOM_TYPE,NAME_ROOM_TYPE,ROOM_RATE,CREATED_AT,MODIFIED_AT) values (11,'BALCONY TWIN',2,null,null);
Insert into SYARIFUDDIN_06989.ROOM_TYPE (ID_ROOM_TYPE,NAME_ROOM_TYPE,ROOM_RATE,CREATED_AT,MODIFIED_AT) values (12,'DELUXE 5',3,null,null);
REM INSERTING into SYARIFUDDIN_06989.TRAVEL_AGENT
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.TRAVEL_AGENT (ID_TRAVEL_AGENT,CODE_TRAVEL_AGENT,NAME_TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (1,'TRA','Traveloka',to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.TRAVEL_AGENT (ID_TRAVEL_AGENT,CODE_TRAVEL_AGENT,NAME_TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (2,'BOO','Booking.com',to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.TRAVEL_AGENT (ID_TRAVEL_AGENT,CODE_TRAVEL_AGENT,NAME_TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (3,'PEG','Pegi Pegi',to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.TRAVEL_AGENT (ID_TRAVEL_AGENT,CODE_TRAVEL_AGENT,NAME_TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (4,'ALA','Mr Aladin',to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.TRAVEL_AGENT (ID_TRAVEL_AGENT,CODE_TRAVEL_AGENT,NAME_TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (5,'AGO','Agoda.com',to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.39.56.738643000 PM','DD-MON-RR HH.MI.SSXFF AM'));
Insert into SYARIFUDDIN_06989.TRAVEL_AGENT (ID_TRAVEL_AGENT,CODE_TRAVEL_AGENT,NAME_TRAVEL_AGENT,CREATED_AT,MODIFIED_AT) values (17,'PGOO','Pergio',null,null);
REM INSERTING into SYARIFUDDIN_06989.USERS
SET DEFINE OFF;
Insert into SYARIFUDDIN_06989.USERS (ID_USER,NAME_USER,EMAIL_USER,USERNAME,ADDRESS_USER,ROLE_USER,CREATED_AT,MODIFIED_AT,PASSWORD,NIK_USER) values (1,'Administrator','admin@email.com','admin','Surabaya',1,to_timestamp('15-MAY-20 08.40.05.457277000 PM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-MAY-20 08.40.05.457277000 PM','DD-MON-RR HH.MI.SSXFF AM'),'1','123');
Insert into SYARIFUDDIN_06989.USERS (ID_USER,NAME_USER,EMAIL_USER,USERNAME,ADDRESS_USER,ROLE_USER,CREATED_AT,MODIFIED_AT,PASSWORD,NIK_USER) values (2,'rere','ere@ewwe','1','32323',5,null,null,'1','2323');
Insert into SYARIFUDDIN_06989.USERS (ID_USER,NAME_USER,EMAIL_USER,USERNAME,ADDRESS_USER,ROLE_USER,CREATED_AT,MODIFIED_AT,PASSWORD,NIK_USER) values (4,'Waitres','waitres@email.com','waitres','Surabaya',3,null,null,null,'6789');
Insert into SYARIFUDDIN_06989.USERS (ID_USER,NAME_USER,EMAIL_USER,USERNAME,ADDRESS_USER,ROLE_USER,CREATED_AT,MODIFIED_AT,PASSWORD,NIK_USER) values (5,'Cashier','cashier@email.com','cashier','Surabaya',4,null,null,'1','891');
Insert into SYARIFUDDIN_06989.USERS (ID_USER,NAME_USER,EMAIL_USER,USERNAME,ADDRESS_USER,ROLE_USER,CREATED_AT,MODIFIED_AT,PASSWORD,NIK_USER) values (22,'ewe','gfg@ewew','2','rerer',2,null,null,'2','2323');
Insert into SYARIFUDDIN_06989.USERS (ID_USER,NAME_USER,EMAIL_USER,USERNAME,ADDRESS_USER,ROLE_USER,CREATED_AT,MODIFIED_AT,PASSWORD,NIK_USER) values (23,'Staff','staff@email','staff','Surabya',2,null,null,'1','23456');
--------------------------------------------------------
--  DDL for Index PK_ID_RESERVATION
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_RESERVATION" ON "SYARIFUDDIN_06989"."RESERVATION" ("ID_RESERVATION") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_RESERVATION_TYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_RESERVATION_TYPE" ON "SYARIFUDDIN_06989"."RESERVATION_TYPE" ("ID_RESERVATION_TYPE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_RESERVATION_STATUS
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_RESERVATION_STATUS" ON "SYARIFUDDIN_06989"."RESERVATION_STATUS" ("ID_RESERVATION_STATUS") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_ADDITIONAL_CHARGE
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_ADDITIONAL_CHARGE" ON "SYARIFUDDIN_06989"."ADDITIONAL_CHARGE" ("ID_ADDITIONAL_CHARGE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index EMAIL_UNIQUE
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."EMAIL_UNIQUE" ON "SYARIFUDDIN_06989"."CUSTOMER" ("EMAIL") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_PAYMENT_TYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_PAYMENT_TYPE" ON "SYARIFUDDIN_06989"."PAYMENT_TYPE" ("ID_PAYMENT_TYPE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_ROOM_RATE
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_ROOM_RATE" ON "SYARIFUDDIN_06989"."ROOM_RATE" ("ID_ROOM_RATE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_RESERVATION_PAYMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_RESERVATION_PAYMENT" ON "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" ("ID_RESERVATION_PAYMENT") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_ROLE
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_ROLE" ON "SYARIFUDDIN_06989"."ROLE_USER" ("ID_ROLE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_ROOM
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_ROOM" ON "SYARIFUDDIN_06989"."ROOM" ("ID_ROOM") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_USER
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_USER" ON "SYARIFUDDIN_06989"."USERS" ("ID_USER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_PAYMENT_STATUS
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_PAYMENT_STATUS" ON "SYARIFUDDIN_06989"."PAYMENT_STATUS" ("ID_PAYMENT_STATUS") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_ROOM_TYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_ROOM_TYPE" ON "SYARIFUDDIN_06989"."ROOM_TYPE" ("ID_ROOM_TYPE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_CUSTOMER
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_CUSTOMER" ON "SYARIFUDDIN_06989"."CUSTOMER" ("ID_CUSTOMER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  DDL for Index PK_ID_TRAVEL_AGENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYARIFUDDIN_06989"."PK_ID_TRAVEL_AGENT" ON "SYARIFUDDIN_06989"."TRAVEL_AGENT" ("ID_TRAVEL_AGENT") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989" ;
--------------------------------------------------------
--  Constraints for Table ROOM_TYPE
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ROOM_TYPE" ADD CONSTRAINT "PK_ID_ROOM_TYPE" PRIMARY KEY ("ID_ROOM_TYPE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."ROOM_TYPE" MODIFY ("ROOM_RATE" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."ROOM_TYPE" MODIFY ("ID_ROOM_TYPE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table PAYMENT_STATUS
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."PAYMENT_STATUS" ADD CONSTRAINT "PK_ID_PAYMENT_STATUS" PRIMARY KEY ("ID_PAYMENT_STATUS")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."PAYMENT_STATUS" MODIFY ("ID_PAYMENT_STATUS" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ROLE_USER
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ROLE_USER" ADD CONSTRAINT "PK_ID_ROLE" PRIMARY KEY ("ID_ROLE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."ROLE_USER" MODIFY ("ID_ROLE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table RESERVATION_TYPE
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_TYPE" ADD CONSTRAINT "PK_ID_RESERVATION_TYPE" PRIMARY KEY ("ID_RESERVATION_TYPE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_TYPE" MODIFY ("ID_RESERVATION_TYPE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table RESERVATION_STATUS
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_STATUS" ADD CONSTRAINT "PK_ID_RESERVATION_STATUS" PRIMARY KEY ("ID_RESERVATION_STATUS")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_STATUS" MODIFY ("ID_RESERVATION_STATUS" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ADDITIONAL_CHARGE
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ADDITIONAL_CHARGE" ADD CONSTRAINT "PK_ID_ADDITIONAL_CHARGE" PRIMARY KEY ("ID_ADDITIONAL_CHARGE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."ADDITIONAL_CHARGE" MODIFY ("ID_ADDITIONAL_CHARGE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ROOM
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ROOM" ADD CONSTRAINT "PK_ID_ROOM" PRIMARY KEY ("ID_ROOM")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."ROOM" MODIFY ("ROOM_TYPE" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."ROOM" MODIFY ("ROOM_NUMBER" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."ROOM" MODIFY ("ID_ROOM" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table PAYMENT_TYPE
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."PAYMENT_TYPE" ADD CONSTRAINT "PK_ID_PAYMENT_TYPE" PRIMARY KEY ("ID_PAYMENT_TYPE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."PAYMENT_TYPE" MODIFY ("ID_PAYMENT_TYPE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table CUSTOMER
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."CUSTOMER" ADD CONSTRAINT "EMAIL_UNIQUE" UNIQUE ("EMAIL")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."CUSTOMER" ADD CONSTRAINT "PK_ID_CUSTOMER" PRIMARY KEY ("ID_CUSTOMER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."CUSTOMER" MODIFY ("ID_CUSTOMER" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ROOM_RATE
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ROOM_RATE" ADD CONSTRAINT "PK_ID_ROOM_RATE" PRIMARY KEY ("ID_ROOM_RATE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."ROOM_RATE" MODIFY ("ID_ROOM_RATE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table USERS
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."USERS" ADD CONSTRAINT "EMAIL_USER_UNIQUE" UNIQUE ("EMAIL_USER") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."USERS" ADD CONSTRAINT "PK_ID_USER" PRIMARY KEY ("ID_USER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."USERS" MODIFY ("ROLE_USER" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."USERS" MODIFY ("ID_USER" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table RESERVATION_PAYMENT
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" ADD CONSTRAINT "PK_ID_RESERVATION_PAYMENT" PRIMARY KEY ("ID_RESERVATION_PAYMENT")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" MODIFY ("ID_RESERVATION_PAYMENT" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table RESERVATION
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "PK_ID_RESERVATION" PRIMARY KEY ("ID_RESERVATION")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" MODIFY ("RESERVATION_TYPE" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" MODIFY ("RESERVATION_STATUS" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" MODIFY ("ID_ROOM" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" MODIFY ("ID_CUSTOMER" NOT NULL ENABLE);
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" MODIFY ("ID_RESERVATION" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table TRAVEL_AGENT
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."TRAVEL_AGENT" ADD CONSTRAINT "PK_ID_TRAVEL_AGENT" PRIMARY KEY ("ID_TRAVEL_AGENT")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYARIFUDDIN_06989"  ENABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."TRAVEL_AGENT" MODIFY ("ID_TRAVEL_AGENT" NOT NULL ENABLE);
--------------------------------------------------------
--  Ref Constraints for Table ADDITIONAL_CHARGE
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ADDITIONAL_CHARGE" ADD CONSTRAINT "FK_ID_RESERVATION" FOREIGN KEY ("ID_RESERVATION")
	  REFERENCES "SYARIFUDDIN_06989"."RESERVATION" ("ID_RESERVATION") DISABLE;
--------------------------------------------------------
--  Ref Constraints for Table RESERVATION
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "FK_CHECKIN_BY" FOREIGN KEY ("CHECKIN_BY")
	  REFERENCES "SYARIFUDDIN_06989"."USERS" ("ID_USER") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "FK_CHECKOUT_BY" FOREIGN KEY ("CHECKOUT_BY")
	  REFERENCES "SYARIFUDDIN_06989"."USERS" ("ID_USER") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "FK_ID_CUSTOMER" FOREIGN KEY ("ID_CUSTOMER")
	  REFERENCES "SYARIFUDDIN_06989"."CUSTOMER" ("ID_CUSTOMER") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "FK_ID_ROOM" FOREIGN KEY ("ID_ROOM")
	  REFERENCES "SYARIFUDDIN_06989"."ROOM" ("ID_ROOM") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "FK_RESERVATION_STATUS" FOREIGN KEY ("RESERVATION_STATUS")
	  REFERENCES "SYARIFUDDIN_06989"."RESERVATION_STATUS" ("ID_RESERVATION_STATUS") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "FK_RESERVATION_TYPE" FOREIGN KEY ("RESERVATION_TYPE")
	  REFERENCES "SYARIFUDDIN_06989"."RESERVATION_TYPE" ("ID_RESERVATION_TYPE") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION" ADD CONSTRAINT "FK_TRAVEL_AGENT" FOREIGN KEY ("TRAVEL_AGENT")
	  REFERENCES "SYARIFUDDIN_06989"."TRAVEL_AGENT" ("ID_TRAVEL_AGENT") DISABLE;
--------------------------------------------------------
--  Ref Constraints for Table RESERVATION_PAYMENT
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" ADD CONSTRAINT "FK_CREATED_BY" FOREIGN KEY ("CREATED_BY")
	  REFERENCES "SYARIFUDDIN_06989"."USERS" ("ID_USER") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" ADD CONSTRAINT "FK_MODIFIED_BY" FOREIGN KEY ("MODIFIED_BY")
	  REFERENCES "SYARIFUDDIN_06989"."USERS" ("ID_USER") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" ADD CONSTRAINT "FK_PAYMENT_STATUS" FOREIGN KEY ("PAYMENT_STATUS")
	  REFERENCES "SYARIFUDDIN_06989"."PAYMENT_STATUS" ("ID_PAYMENT_STATUS") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" ADD CONSTRAINT "FK_PAYMENT_TYPE" FOREIGN KEY ("PAYMENT_TYPE")
	  REFERENCES "SYARIFUDDIN_06989"."PAYMENT_TYPE" ("ID_PAYMENT_TYPE") DISABLE;
  ALTER TABLE "SYARIFUDDIN_06989"."RESERVATION_PAYMENT" ADD CONSTRAINT "FK_RESERVATION_ID" FOREIGN KEY ("ID_RESERVATION")
	  REFERENCES "SYARIFUDDIN_06989"."RESERVATION" ("ID_RESERVATION") DISABLE;
--------------------------------------------------------
--  Ref Constraints for Table ROOM
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ROOM" ADD CONSTRAINT "FK_ROOM_TYPE" FOREIGN KEY ("ROOM_TYPE")
	  REFERENCES "SYARIFUDDIN_06989"."ROOM_TYPE" ("ID_ROOM_TYPE") DISABLE;
--------------------------------------------------------
--  Ref Constraints for Table ROOM_TYPE
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."ROOM_TYPE" ADD CONSTRAINT "FK_ROOM_RATE" FOREIGN KEY ("ROOM_RATE")
	  REFERENCES "SYARIFUDDIN_06989"."ROOM_RATE" ("ID_ROOM_RATE") DISABLE;
--------------------------------------------------------
--  Ref Constraints for Table USERS
--------------------------------------------------------

  ALTER TABLE "SYARIFUDDIN_06989"."USERS" ADD CONSTRAINT "FK_ROLE_USER" FOREIGN KEY ("ROLE_USER")
	  REFERENCES "SYARIFUDDIN_06989"."ROLE_USER" ("ID_ROLE") DISABLE;