Table sALEs Name NUI? NOT NULLI NUMBER CUST_ID NOT NULLNUMBER TIME ID NOT NULLI DATE CHANNELID NOT NULL NUMBER PROMO_ID NOT NULL NUMBER QUANTITY_SOLD NOT NULL NUMBER(10, 2) Table CUSTOMERS Name CUST ID NULI TBER CUST_FIRST_NAME OTI NULL VARCHAR2 (20 CUST L八 ST NAME NOT NULL VARCHAR2(40 CUST GEN DER NOT NULL CHAR(1) CUST_YEAR_OF_BIRTH NOT NULL NUMBER(4) CUST_MARITIAL_STATUS VARCHAR2 20] CUST_STREET_ ADDRESS NOT NULL VARCHAR2 (40) CUST_POSTAL_CODE NOT NULL VARCHAR2(10) CUsT CITY NOT NULL VARCHAR2(30) CUST.STATE PROVINCE NOT NULL VARCHAR2 (40) COUNTRY ID NOT NULLI NUMBER CUST INCOME LEVEL VARCHAR2 (30] CUST_CREDIT_LIMIT NUMBER CUST ELIAIL VARCHAR2 ( 30 Table PROMOTIONS Name Null? D PROMO D NOT NULLI NUMBER(6) PROMO NAME NOT NULLIVARCHAR2(30 PROMO SUBCATEGORY NOT NULLIVARCHAR2(301 PROMO SUBCATEGORY ID NOT NULL NUMBER PROMO CATEGORY NOT NULL VARCHAR2(3 PROMO CATEGORY D NOT NULLINUMBER PROMO COST NOT NULLI NUM日ER102 PROMO BEGIN DATE NOT NULLDATE PROMO END DATE I NOT NULL DATE Table products Name Null? PROD_ NOT NULLI NUMBER(6) PROD_NAME NOT NULLI VARCHAR2(50) PROD DESC NOT NULL VARCHAR2(4000 PROD CATEGORY NOT NULL VARCHAR2(501 PROD_CATEGORY_ID NOT NULL NUMBER PROD UNIT OF MEASURE VARCHAR2(20) UPPLIER I NOT NULL NUMBER(6) NOT NULL VARCHAR2(20) PROD LSST PRGE NOT NULL NUMBER(B 2) PROD NIN PRCE NOT NULL NUMBER(&, 2) Table froducts Name Null? NOT NULL NUMBER(G) PROD_NAME NOT NULLI VARCHAR2(50) PROD DESC NOT NULL I VARCHAR2ddDD PROD CATEGORY NOT NULLI VARCHAR2(50) PROD CATEGORY D NOT NULL I NUMBER PROD UNIT OF ME真sURE VARCHAR2(201 UPPLER D NOT NULLI NUMBER(6) NOT NULL VARCHAR2(20) ZOD LIST PRICE NOT NULL NUMBER(8. 2) PROD_MIN_PRICE NOT NULL I NUMBER(8. 2) CUSTONERS CUST IO CUST NAME TsC工 CUST CRED工工工M工工 101 F工G 10囗囗 102 GREEN BosT○rT 1500囗 SCOTT 工 OWDON 104 IT五 BT○ M卫 LOYEES ENATE H工RED真TE S卫工 COMPur 工卫H 1 -DEC-OU 已囗U 工工E 20-FEB-99 160 300 而RD 2_FEB-95 125 50 02-A卫R_98 29了5 鸡FTT 2日一SE卫一99 1250 14口0 BLAKE 01-M盈Y-9 2日5