CREATE TABLE  "CUSTOMER" 
   (	"C_CUSTKEY" NUMBER(*,0) NOT NULL ENABLE, 
	"C_NAME" VARCHAR2(25), 
	"C_ADDRESS" VARCHAR2(25), 
	"C_CITY" CHAR(10), 
	"C_NATION" CHAR(15), 
	"C_REGION" CHAR(12), 
	"C_PHONE" CHAR(15), 
	"C_MKTSEGMENT" CHAR(10), 
	 CONSTRAINT "CUSTOMER_PK" PRIMARY KEY ("C_CUSTKEY") ENABLE
   )
/
CREATE TABLE  "DATE2" 
   (	"D_DATEKEY" NUMBER(*,0) NOT NULL ENABLE, 
	"D_DATE" CHAR(18), 
	"D_DAYOFWEEK" CHAR(9), 
	"D_MONTH" CHAR(9), 
	"D_YEAR" NUMBER(*,0), 
	"D_YEARMONTHNUM" NUMBER(*,0), 
	"D_YEARMONTH" CHAR(7), 
	"D_DAYNUMINWEEK" NUMBER(*,0), 
	"D_DAYNUMINMONTH" NUMBER(*,0), 
	"D_DAYNUMINYEAR" NUMBER(*,0), 
	"D_MONTHNUMINYEAR" NUMBER(*,0), 
	"D_WEEKNUMINYEAR" NUMBER(*,0), 
	"D_SELLINGSEASON" VARCHAR2(12), 
	"D_LASTDAYINWEEKFL" NUMBER(*,0), 
	"D_LASTDAYINMONTHFL" NUMBER(*,0), 
	"D_HOLIDAYFL" NUMBER(*,0), 
	"D_WEEKDAYFL" NUMBER(*,0), 
	 CONSTRAINT "DATE_PK" PRIMARY KEY ("D_DATEKEY") ENABLE
   )
/
CREATE TABLE  "LINEORDER" 
   (	"LO_ORDERKEY" NUMBER(*,0) NOT NULL ENABLE, 
	"LO_LINENUMBER" NUMBER(*,0) NOT NULL ENABLE, 
	"LO_CUSTKEY" NUMBER(*,0), 
	"LO_PARTKEY" NUMBER(*,0), 
	"LO_SUPPKEY" NUMBER(*,0), 
	"LO_ORDERDATE" NUMBER(*,0), 
	"LO_ORDERPRIORITY" CHAR(15), 
	"LO_SHIPPRIORITY" CHAR(1), 
	"LO_QUANTITY" NUMBER(*,0), 
	"LO_EXTENDEDPRICE" FLOAT(126), 
	"LO_ORDTOTALPRICE" FLOAT(126), 
	"LO_DISCOUNT" FLOAT(126), 
	"LO_REVENUE" FLOAT(126), 
	"LO_SUPPLYCOST" FLOAT(126), 
	"LO_TAX" FLOAT(126), 
	"LO_COMMITDATE" NUMBER(*,0), 
	"LO_SHIPMODE" CHAR(10)
   )
/
CREATE TABLE  "PART" 
   (	"P_PARTKEY" NUMBER(*,0) NOT NULL ENABLE, 
	"P_NAME" VARCHAR2(22), 
	"P_MFGR" CHAR(6), 
	"P_CATEGORY" CHAR(7), 
	"P_BRAND1" CHAR(9), 
	"P_COLOR" VARCHAR2(11), 
	"P_TYPE" VARCHAR2(25), 
	"P_SIZE" NUMBER(*,0), 
	"P_CONTAINER" CHAR(10), 
	 CONSTRAINT "PART_PK" PRIMARY KEY ("P_PARTKEY") ENABLE
   )
/
CREATE TABLE  "SUPPLIER" 
   (	"S_SUPPKEY" NUMBER(*,0) NOT NULL ENABLE, 
	"S_NAME" CHAR(25), 
	"S_ADDRESS" VARCHAR2(25), 
	"S_CITY" CHAR(10), 
	"S_NATION" CHAR(15), 
	"S_REGION" CHAR(12), 
	"S_PHONE" CHAR(15), 
	 CONSTRAINT "SUPPLIER_PK" PRIMARY KEY ("S_SUPPKEY") ENABLE
   )
/

----------------------------------------------------------------

CREATE TABLE  "NCUSTOMER" 
   (	"C_CUSTKEY" NUMBER(*,0) NOT NULL ENABLE, 
	"C_NAME" VARCHAR2(25), 
	"C_ADDRESS" VARCHAR2(25), 
	"C_PHONE" CHAR(15), 
	"C_MKTSEGMENT" CHAR(10), 
	"C_CITYKEY" NUMBER
   )
/
CREATE TABLE  "NSUPPLIER" 
   (	"S_SUPPKEY" NUMBER(*,0) NOT NULL ENABLE, 
	"S_NAME" CHAR(25), 
	"S_ADDRESS" VARCHAR2(25), 
	"S_PHONE" CHAR(15), 
	"S_CITYKEY" NUMBER
   )
/
CREATE TABLE  "REGION" 
   (	"R_REGKEY" NUMBER NOT NULL ENABLE, 
	"R_REGION" CHAR(12) NOT NULL ENABLE, 
	 CONSTRAINT "REGION_PK" PRIMARY KEY ("R_REGKEY") ENABLE
   )
/
CREATE TABLE  "NATION" 
   (	"N_NATKEY" NUMBER, 
	"N_NATION" CHAR(15), 
	"N_REGKEY" NUMBER, 
	 CONSTRAINT "NATION_PK" PRIMARY KEY ("N_NATKEY") ENABLE, 
	 CONSTRAINT "NATION_FK" FOREIGN KEY ("N_REGKEY")
	  REFERENCES  "REGION" ("R_REGKEY") ENABLE
   )
/
CREATE TABLE  "CITY" 
   (	"CI_CITYKEY" NUMBER, 
	"CI_CITY" CHAR(10), 
	"CI_NATKEY" NUMBER, 
	 CONSTRAINT "CITY_PK" PRIMARY KEY ("CI_CITYKEY") ENABLE, 
	 CONSTRAINT "CITY_FK" FOREIGN KEY ("CI_NATKEY")
	  REFERENCES  "NATION" ("N_NATKEY") ENABLE
   )
/