--------------------------------------------------------
--  File created - Sunday-March-31-2019   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table ORDERS
--------------------------------------------------------

  CREATE TABLE "ORDERS" ("ORDER_ID" NUMBER(20,0), "CREATEDDATE" DATE, "UPDATEDDATE" DATE DEFAULT NULL, "EMAIL_ADDRESS" VARCHAR2(45), "ORDER_STATUS" VARCHAR2(45), "ORDER_SUBTOTAL" NUMBER(10,2), "CUSTOMER_ID" NUMBER(10,0), "SHIPPING_ID" NUMBER(10,0))
REM INSERTING into ORDERS
SET DEFINE OFF;
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12188842071573416,to_date('02-FEB-18','DD-MON-RR'),to_date('02-FEB-18','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',164.88,604,290560413);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12188842074932864,to_date('02-FEB-18','DD-MON-RR'),to_date('02-FEB-18','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',164.88,604,290560413);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12188842075308552,to_date('02-FEB-18','DD-MON-RR'),to_date('02-FEB-18','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',185.13,604,290560413);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12188842077844144,to_date('02-FEB-18','DD-MON-RR'),to_date('02-FEB-18','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',500.45,604,211647978);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12188842080499328,to_date('02-FEB-18','DD-MON-RR'),to_date('02-FEB-18','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',38295,604,290560413);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (20180202122640,to_date('02-FEB-18','DD-MON-RR'),to_date('02-FEB-18','DD-MON-RR'),'raviteja@gmail.com','IN_PROCESS',185.13,1,338326);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12188841454681640,to_date('01-FEB-18','DD-MON-RR'),to_date('01-FEB-18','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',45045,604,290560413);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12188841454934112,to_date('01-FEB-18','DD-MON-RR'),to_date('01-FEB-18','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',45045,604,290560413);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12194943024703328,to_date('03-MAR-19','DD-MON-RR'),to_date('03-MAR-19','DD-MON-RR'),'ram@gmail.com','COMPLETED',56056,604,102378254);
Insert into ORDERS (ORDER_ID,CREATEDDATE,UPDATEDDATE,EMAIL_ADDRESS,ORDER_STATUS,ORDER_SUBTOTAL,CUSTOMER_ID,SHIPPING_ID) values (12194943031467524,to_date('03-MAR-19','DD-MON-RR'),to_date('03-MAR-19','DD-MON-RR'),'ram@gmail.com','IN_PROCESS',245245,604,202627629);
--------------------------------------------------------
--  DDL for Index PK_ORDERID
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_ORDERID" ON "ORDERS" ("ORDER_ID")
--------------------------------------------------------
--  Constraints for Table ORDERS
--------------------------------------------------------

  ALTER TABLE "ORDERS" MODIFY ("CREATEDDATE" NOT NULL ENABLE)
  ALTER TABLE "ORDERS" MODIFY ("EMAIL_ADDRESS" NOT NULL ENABLE)
  ALTER TABLE "ORDERS" MODIFY ("ORDER_STATUS" NOT NULL ENABLE)
  ALTER TABLE "ORDERS" MODIFY ("ORDER_SUBTOTAL" NOT NULL ENABLE)
  ALTER TABLE "ORDERS" MODIFY ("CUSTOMER_ID" NOT NULL ENABLE)
  ALTER TABLE "ORDERS" MODIFY ("SHIPPING_ID" NOT NULL ENABLE)
  ALTER TABLE "ORDERS" ADD CONSTRAINT "PK_ORDERID" PRIMARY KEY ("ORDER_ID") ENABLE
