This is an old revision of the document!
set wildcards *, ?, #
database “star”
type oracle
version "{$ORAVER}"
userclass "DEFAULT" user "{star$(basename $PWD)}"
password "{star$(basename $PWD)}"
indexprefix "idx/STAR"
table “DIVISIONS”
primary "DIVISION" cardinality 5
column “DIVISION” datatype INTEGER length 1 cardinality 5 column “DESCRIPTION” datatype C STRING length 32 cardinality 5
table “DEPTS”
primary "DEPT" cardinality 10
column “DEPT” datatype INTEGER length 1 cardinality 10 column “DESCRIPTION” datatype C STRING length 32 cardinality 10
table “CATEGORIES”
primary "CATEGORY" cardinality 30
column “CATEGORY” datatype INTEGER length 1 cardinality 30 column “DESCRIPTION” datatype C STRING length 32 cardinality 30
table “MFRS”
primary "MFR" cardinality 40
column “MFR” datatype INTEGER length 1 cardinality 40 column “DESCRIPTION” datatype C STRING length 32 cardinality 40
table “PRODUCTS”
primary "PRODUCT_NO" cardinality 100
column “PRODUCT_NO” datatype CHARACTER length 4 usage ROWID cardinality 100 column “DESCRIPTION” datatype C STRING length 32 cardinality 100 column “DIVISION” datatype INTEGER length 1 cardinality 5 column “DEPT” datatype INTEGER length 1 cardinality 10 column “CATEGORY” datatype INTEGER length 1 cardinality 30 column “MFR” datatype INTEGER length 1 cardinality 40 column “MARGIN” datatype FLOAT length 4 cardinality 4 column “WHOLESALE” datatype FLOAT length 4 cardinality 64 column “COST” datatype FLOAT length 4 cardinality 57 column “DISCOUNT_RT” datatype FLOAT length 4 as “WHOLESALE * 100.0 / COST”
table “STATES”
primary "STATE" cardinality 57
column “STATE” datatype CHARACTER length 2 usage ROWID cardinality 57 column “DESCRIPTION” datatype C STRING length 32 cardinality 57 column “REGION” datatype CHARACTER length 2 cardinality 6 column “TAX_RATE” datatype FLOAT length 4 cardinality 15
table “COUNTIES”
primary "COUNTY_CODE","STATE" cardinality 3223
column “COUNTY_CODE” datatype CHARACTER length 3 cardinality 327 column “COUNTY” datatype C STRING length 27 cardinality 1926 column “STATE” datatype CHARACTER length 2 cardinality 57 column “REGION” datatype CHARACTER length 2 cardinality 6 column “COUNTRY” datatype CHARACTER length 2 cardinality 1 column “ELEVATION” datatype INTEGER length 2 cardinality 1730 column “POPULATION” datatype INTEGER length 4 cardinality 3075 column “SQ_MILES” datatype INTEGER length 4 cardinality 1403 column “HOUSEHOLDS” datatype INTEGER length 4 cardinality 2947 column “PEOPLE_HSHD” datatype FLOAT length 4 cardinality 157 column “INCOME_HSHD” datatype INTEGER length 4 cardinality 2884 column “HOUSE_VALUE” datatype INTEGER length 4 cardinality 877
table “COUNTRIES”
primary "COUNTRY" cardinality 1
column “COUNTRY” datatype CHARACTER length 2 cardinality 1 column “DESCRIPTION” datatype C STRING length 32 cardinality 1
table “REGIONS”
primary "REGION" cardinality 6
column “REGION” datatype CHARACTER length 2 cardinality 6 column “DESCRIPTION” datatype C STRING length 32 cardinality 6
table “ZIPCODES”
primary "ZIP" cardinality 42190
column “ZIP” datatype C STRING length 10 cardinality 42190 column “CITY” datatype C STRING length 26 cardinality 18941 column “COUNTY_CODE” datatype CHARACTER length 3 cardinality 327 column “STATE” datatype CHARACTER length 2 cardinality 57 column “REGION” datatype CHARACTER length 2 cardinality 6 column “COUNTRY” datatype CHARACTER length 2 cardinality 1 column “LATITUDE” datatype CHARACTER length 7 cardinality 33080 column “LONGITUDE” datatype CHARACTER length 8 cardinality 35490 column “TYPE” datatype CHARACTER length 2 cardinality 3 column “AREA_CODES” datatype CHARACTER length 15 cardinality 289 column “TIME_ZONE” datatype INTEGER length 1 cardinality 12
table “COMPANIES”
primary "COMPANY" cardinality 6000
column “COMPANY” datatype C STRING length 40 usage ROWID cardinality 6000 column “ADDRESS1” datatype C STRING length 30 cardinality 5598 column “ADDRESS2” datatype C STRING length 30 cardinality 1296 column “CITY” datatype C STRING length 26 cardinality 1319 column “STATE” datatype CHARACTER length 2 cardinality 51 column “ZIP” datatype C STRING length 10 cardinality 2720 column “COUNTRY” datatype CHARACTER length 2 cardinality 1 column “PHONE” datatype C STRING length 16 cardinality 4426 column “PH_ZP2” datatype C STRING length 17 as “substring(PHONE from 4 for 7)||ZIP” column “PHONE2” datatype C STRING length 8 as “substring(PHONE from 4 for 7)” column “ST_ZP_CNTRY2” datatype C STRING length 14 as “state||zip||country” column “CTY_ST” datatype C STRING length 29 as “city||state” column “CTY5_ST” datatype C STRING length 8 as “substring(city from 1 for 5)||state”
table “GENDERS”
primary "GENDER" cardinality 2
column “GENDER” datatype CHARACTER length 1 cardinality 2 column “DESCRIPTION” datatype C STRING length 32 cardinality 2
table “MAILFLAGS”
primary "MAILFLAG" cardinality 4
column “MAILFLAG” datatype INTEGER length 1 cardinality 4 column “DESCRIPTION” datatype C STRING length 32 cardinality 4
table “MAILINGS”
primary "MAILING" cardinality 8
column “MAILING” datatype INTEGER length 1 cardinality 8 column “DESCRIPTION” datatype C STRING length 32 cardinality 8
table “INCOMES”
primary "INCOME" cardinality 16
column “INCOME” datatype INTEGER length 1 cardinality 16 column “DESCRIPTION” datatype C STRING length 32 cardinality 16
table “PROFESSIONS”
primary "PROFESSION" cardinality 10
column “PROFESSION” datatype INTEGER length 1 cardinality 10 column “DESCRIPTION” datatype C STRING length 32 cardinality 10
table “PROFILES”
primary "PROFILE" cardinality 6
column “PROFILE” datatype INTEGER length 1 cardinality 6 column “DESCRIPTION” datatype C STRING length 32 cardinality 6
table “DATES”
primary "DT" cardinality 4383 /* All dates from 1/1/1990 to 12/31/2001 */
column “DT” datatype ORACLE DATETIME length 7 cardinality 4383 column “YR” datatype INTEGER length 2 cardinality 12 column “MO” datatype CHARACTER length 3 cardinality 12 column “DY_OF_MO” datatype INTEGER length 1 cardinality 31 column “DY_OF_YR” datatype INTEGER length 2 cardinality 366 column “DY_OF_WK” datatype INTEGER length 1 cardinality 7 column “WK” datatype INTEGER length 1 cardinality 54 column “QTR” datatype INTEGER length 1 cardinality 4 column “FQTR” datatype INTEGER length 1 cardinality 4 column “FYR” datatype INTEGER length 2 cardinality 13 column “DESCRIPTION” datatype C STRING length 32 cardinality 4383
table “PROSPECTS”
primary "ACCT" cardinality 10 /* 10 */ /* 100 */ /* 10000 */ /* 1000000 */
column “ACCT” datatype INTEGER length 4 cardinality 10 column “COMPANY” datatype C STRING length 40 cardinality 10 column “CONTACT” datatype C STRING length 24 cardinality 10 column “CITY” datatype C STRING length 26 cardinality 10 column “STATE” datatype CHARACTER length 2 cardinality 10 column “ZIP” datatype C STRING length 10 cardinality 10 column “REGION” datatype CHARACTER length 2 cardinality 3 column “COUNTRY” datatype CHARACTER length 2 cardinality 1 column “PHONE” datatype C STRING length 16 cardinality 9 column “GENDER” datatype CHARACTER length 1 cardinality 2 column “MAILFLAG” datatype INTEGER length 1 cardinality 2 column “MAILING” datatype INTEGER length 1 cardinality 1 column “PROFESSION” datatype INTEGER length 1 cardinality 9 column “INCOME” datatype INTEGER length 1 cardinality 6 column “PROFILE” datatype INTEGER length 1 cardinality 4 column “PREFERRED” datatype INTEGER length 1 cardinality 2 column “FRQ_BUY_MBR” datatype INTEGER length 1 cardinality 2 column “CR_LIMIT” datatype INTEGER length 1 cardinality 5 column “DISCOUNT_RT” datatype INTEGER length 1 cardinality 4 column “CUST_SINCE” datatype INTEGER length 2 cardinality 6 column “LAST_ORDER” datatype ORACLE DATETIME length 7 cardinality 10 column “SEARCH_KEY” datatype CHARACTER length 12 cardinality 10 column “COMPANY_SDX” datatype C STRING length 25 as “$soundex(COMPANY)”
table “TICKLERS”
primary "TICKLER" cardinality 12
column “TICKLER” datatype CHARACTER length 2 cardinality 12 column “DESCRIPTION” datatype C STRING length 32 cardinality 12
table “INITIALS”
primary "INITIALS" cardinality 10
column “INITIALS” datatype CHARACTER length 4 cardinality 25 column “DESCRIPTION” datatype C STRING length 32 cardinality 25
table “ACTIVITY”
foreign "ACCT" references "PROSPECTS"("ACCT")
foreign "DT" references "DATES"("DT")
foreign "TICKLER" references "TICKLERS"("TICKLER")
foreign "INITIALS" references "INITIALS"("INITIALS")
cardinality 100 /* 100 */ /* 1000 */ /* 100000 */ /* 10000000 */
column “ACCT” datatype INTEGER length 4 cardinality 10 column “DT” datatype ORACLE DATETIME length 7 cardinality 40 column “TICKLER” datatype CHARACTER length 2 cardinality 7 column “INITIALS” datatype CHARACTER length 4 cardinality 4 column “REDEF_ROWID” datatype INTEGER length 4 usage ASCENDING AUTO ROWID
table “STATUSES”
primary "STATUS" cardinality 4
column “STATUS” datatype CHARACTER length 2 cardinality 4 column “DESCRIPTION” datatype C STRING length 32 cardinality 4
table “PMT_METHODS”
primary "PMT_METHOD" cardinality 10
column “PMT_METHOD” datatype INTEGER length 1 cardinality 10 column “DESCRIPTION” datatype C STRING length 32 cardinality 10
table “SOURCES”
primary "SOURCE" cardinality 6
column “SOURCE” datatype INTEGER length 1 cardinality 6 column “DESCRIPTION” datatype C STRING length 32 cardinality 6
table “ORDERS”
foreign "ACCT" references "PROSPECTS"("ACCT")
foreign "PRODUCT_NO" references "PRODUCTS"("PRODUCT_NO")
foreign "ORDER_DATE" references "DATES"("DT")
foreign "STATUS" references "STATUSES"("STATUS")
foreign "TAX_STATE" references "STATES"("STATE")
foreign "SOURCE" references "SOURCES"("SOURCE")
foreign "PMT_METHOD" references "PMT_METHODS"("PMT_METHOD")
cardinality 200 /* 200 */ /* 2000 */ /* 200000 */ /* 20000000 */
column “ACCT” datatype INTEGER length 4 cardinality 3 column “PRODUCT_NO” datatype CHARACTER length 4 cardinality 63 column “ORDER_DATE” datatype ORACLE DATETIME length 7 cardinality 68 column “STATUS” datatype CHARACTER length 2 cardinality 2 column “TAX_STATE” datatype CHARACTER length 2 cardinality 3 column “SOURCE” datatype INTEGER length 1 cardinality 6 column “PMT_METHOD” datatype INTEGER length 1 cardinality 10 column “DISCOUNT” datatype INTEGER length 1 cardinality 3 column “QUANTITY” datatype INTEGER length 1 cardinality 20 column “SALES_TAX” datatype FLOAT length 4 cardinality 111 column “AMOUNT” datatype FLOAT length 4 cardinality 64 column “TOTAL” datatype FLOAT length 4 cardinality 110
table “PROSPECTS_ROLLUP”
foreign "ACCT" references "PROSPECTS"("ACCT")
foreign "COMPANY" references "COMPANIES"("COMPANY")
foreign "STATE" references "STATES"("STATE")
foreign "ZIP" references "ZIPCODES"("ZIP")
foreign "REGION" references "REGIONS"("REGION")
foreign "COUNTRY" references "COUNTRIES"("COUNTRY")
foreign "GENDER" references "GENDERS"("GENDER")
foreign "MAILFLAG" references "MAILFLAGS"("MAILFLAG")
foreign "MAILING" references "MAILINGS"("MAILING")
foreign "PROFESSION" references "PROFESSIONS"("PROFESSION")
foreign "INCOME" references "INCOMES"("INCOME")
foreign "PROFILE" references "PROFILES"("PROFILE")
cardinality 12 /* 12 */ /* 194 */ /* 21028 */ /* 2091260 */
column “ACCT” datatype INTEGER length 4 cardinality 3 column “COMPANY” datatype C STRING length 40 cardinality 3 column “CONTACT” datatype C STRING length 24 cardinality 3 column “CITY” datatype C STRING length 26 cardinality 3 column “STATE” datatype CHARACTER length 2 cardinality 3 column “ZIP” datatype C STRING length 10 cardinality 3 column “REGION” datatype CHARACTER length 2 cardinality 1 column “COUNTRY” datatype CHARACTER length 2 cardinality 1 column “PHONE” datatype C STRING length 16 cardinality 3 column “GENDER” datatype CHARACTER length 1 cardinality 2 column “MAILFLAG” datatype INTEGER length 1 cardinality 2 column “MAILING” datatype INTEGER length 1 cardinality 1 column “PROFESSION” datatype INTEGER length 1 cardinality 3 column “INCOME” datatype INTEGER length 1 cardinality 3 column “PROFILE” datatype INTEGER length 1 cardinality 1 column “PREFERRED” datatype INTEGER length 1 cardinality 2 column “FRQ_BUY_MBR” datatype INTEGER length 1 cardinality 2 column “CR_LIMIT” datatype INTEGER length 1 cardinality 3 column “DISCOUNT_RT” datatype INTEGER length 1 cardinality 3 column “CUST_SINCE” datatype INTEGER length 2 cardinality 3 column “LAST_ORDER” datatype ORACLE DATETIME length 7 cardinality 3 column “SEARCH_KEY” datatype CHARACTER length 12 cardinality 3
column “YR” datatype INTEGER length 2 cardinality 7 column “NUM_ORDERS” datatype INTEGER length 4 cardinality 9 column “JAN_TOTAL” datatype FLOAT length 8 cardinality 9 column “JAN_DISC” datatype FLOAT length 8 cardinality 9 column “JAN_TAX” datatype FLOAT length 8 cardinality 9 column “JAN_MGN” datatype FLOAT length 8 cardinality 9 column “JAN_OR” datatype FLOAT length 8 cardinality 1 column “JAN_CN” datatype FLOAT length 8 cardinality 1 column “JAN_BO” datatype FLOAT length 8 cardinality 1 column “FEB_TOTAL” datatype FLOAT length 8 cardinality 10 column “FEB_DISC” datatype FLOAT length 8 cardinality 9 column “FEB_TAX” datatype FLOAT length 8 cardinality 10 column “FEB_MGN” datatype FLOAT length 8 cardinality 10 column “FEB_OR” datatype FLOAT length 8 cardinality 1 column “FEB_CN” datatype FLOAT length 8 cardinality 2 column “FEB_BO” datatype FLOAT length 8 cardinality 1 column “MAR_TOTAL” datatype FLOAT length 8 cardinality 8 column “MAR_DISC” datatype FLOAT length 8 cardinality 8 column “MAR_TAX” datatype FLOAT length 8 cardinality 8 column “MAR_MGN” datatype FLOAT length 8 cardinality 8 column “MAR_OR” datatype FLOAT length 8 cardinality 1 column “MAR_CN” datatype FLOAT length 8 cardinality 3 column “MAR_BO” datatype FLOAT length 8 cardinality 1 column “APR_TOTAL” datatype FLOAT length 8 cardinality 7 column “APR_DISC” datatype FLOAT length 8 cardinality 7 column “APR_TAX” datatype FLOAT length 8 cardinality 7 column “APR_MGN” datatype FLOAT length 8 cardinality 7 column “APR_OR” datatype FLOAT length 8 cardinality 1 column “APR_CN” datatype FLOAT length 8 cardinality 1 column “APR_BO” datatype FLOAT length 8 cardinality 1 column “MAY_TOTAL” datatype FLOAT length 8 cardinality 8 column “MAY_DISC” datatype FLOAT length 8 cardinality 8 column “MAY_TAX” datatype FLOAT length 8 cardinality 8 column “MAY_MGN” datatype FLOAT length 8 cardinality 8 column “MAY_OR” datatype FLOAT length 8 cardinality 1 column “MAY_CN” datatype FLOAT length 8 cardinality 1 column “MAY_BO” datatype FLOAT length 8 cardinality 1 column “JUN_TOTAL” datatype FLOAT length 8 cardinality 9 column “JUN_DISC” datatype FLOAT length 8 cardinality 9 column “JUN_TAX” datatype FLOAT length 8 cardinality 9 column “JUN_MGN” datatype FLOAT length 8 cardinality 9 column “JUN_OR” datatype FLOAT length 8 cardinality 1 column “JUN_CN” datatype FLOAT length 8 cardinality 2 column “JUN_BO” datatype FLOAT length 8 cardinality 1 column “JUL_TOTAL” datatype FLOAT length 8 cardinality 6 column “JUL_DISC” datatype FLOAT length 8 cardinality 6 column “JUL_TAX” datatype FLOAT length 8 cardinality 6 column “JUL_MGN” datatype FLOAT length 8 cardinality 6 column “JUL_OR” datatype FLOAT length 8 cardinality 1 column “JUL_CN” datatype FLOAT length 8 cardinality 1 column “JUL_BO” datatype FLOAT length 8 cardinality 1 column “AUG_TOTAL” datatype FLOAT length 8 cardinality 10 column “AUG_DISC” datatype FLOAT length 8 cardinality 10 column “AUG_TAX” datatype FLOAT length 8 cardinality 10 column “AUG_MGN” datatype FLOAT length 8 cardinality 10 column “AUG_OR” datatype FLOAT length 8 cardinality 1 column “AUG_CN” datatype FLOAT length 8 cardinality 1 column “AUG_BO” datatype FLOAT length 8 cardinality 1 column “SEP_TOTAL” datatype FLOAT length 8 cardinality 7 column “SEP_DISC” datatype FLOAT length 8 cardinality 7 column “SEP_TAX” datatype FLOAT length 8 cardinality 7 column “SEP_MGN” datatype FLOAT length 8 cardinality 7 column “SEP_OR” datatype FLOAT length 8 cardinality 1 column “SEP_CN” datatype FLOAT length 8 cardinality 2 column “SEP_BO” datatype FLOAT length 8 cardinality 1 column “OCT_TOTAL” datatype FLOAT length 8 cardinality 8 column “OCT_DISC” datatype FLOAT length 8 cardinality 9 column “OCT_TAX” datatype FLOAT length 8 cardinality 9 column “OCT_MGN” datatype FLOAT length 8 cardinality 9 column “OCT_OR” datatype FLOAT length 8 cardinality 1 column “OCT_CN” datatype FLOAT length 8 cardinality 2 column “OCT_BO” datatype FLOAT length 8 cardinality 1 column “NOV_TOTAL” datatype FLOAT length 8 cardinality 8 column “NOV_DISC” datatype FLOAT length 8 cardinality 8 column “NOV_TAX” datatype FLOAT length 8 cardinality 8 column “NOV_MGN” datatype FLOAT length 8 cardinality 8 column “NOV_OR” datatype FLOAT length 8 cardinality 1 column “NOV_CN” datatype FLOAT length 8 cardinality 2 column “NOV_BO” datatype FLOAT length 8 cardinality 1 column “DEC_TOTAL” datatype FLOAT length 8 cardinality 7 column “DEC_DISC” datatype FLOAT length 8 cardinality 7 column “DEC_TAX” datatype FLOAT length 8 cardinality 7 column “DEC_MGN” datatype FLOAT length 8 cardinality 7 column “DEC_OR” datatype FLOAT length 8 cardinality 1 column “DEC_CN” datatype FLOAT length 8 cardinality 1 column “DEC_BO” datatype FLOAT length 8 cardinality 1 column “TOTAL” datatype FLOAT length 8 cardinality 11 column “DISCOUNT” datatype FLOAT length 8 cardinality 11 column “SALES_TAX” datatype FLOAT length 8 cardinality 11 column “MARGIN” datatype FLOAT length 8 cardinality 11 column “ORDERED” datatype FLOAT length 8 cardinality 1 column “CANCELED” datatype FLOAT length 8 cardinality 6 column “BACKORDERED” datatype FLOAT length 8 cardinality 1 column “CASH” datatype FLOAT length 8 cardinality 9 column “CHECKS” datatype FLOAT length 8 cardinality 7 column “ATM” datatype FLOAT length 8 cardinality 10 column “VISA” datatype FLOAT length 8 cardinality 7 column “MC” datatype FLOAT length 8 cardinality 8 column “AMEX” datatype FLOAT length 8 cardinality 8 column “DISCOVER” datatype FLOAT length 8 cardinality 7 column “DINERSCLUB” datatype FLOAT length 8 cardinality 9 column “OTHERCC” datatype FLOAT length 8 cardinality 11 column “PO” datatype FLOAT length 8 cardinality 7 column “TELEPHONE” datatype FLOAT length 8 cardinality 9 column “FAX” datatype FLOAT length 8 cardinality 8 column “MAIL” datatype FLOAT length 8 cardinality 7 column “INTERNET” datatype FLOAT length 8 cardinality 6 column “CATALOGS” datatype FLOAT length 8 cardinality 10 column “RETAIL” datatype FLOAT length 8 cardinality 11 column “REGION_DESC” datatype CHARACTER length 9 as “case when REGION = 'MW' then 'MIDWEST' when REGION = 'NE' then 'NORTHEAST' when REGION = 'NW' then 'NORTHWEST' when REGION = 'SE' then 'SOUTHEAST' when REGION = 'SW' then 'SOUTHWEST' when REGION = 'TR' then 'TERRITORIES' else 'UNKNOWN' end” column “CUST_PRI” datatype INTEGER length 4 as “INCOME*10 + PREFERRED” column “CHAR_INC” datatype CHARACTER length 8 as “cast(income as char(8))”
table “PRODUCTS_ROLLUP”
foreign "PRODUCT_NO" references "PRODUCTS"("PRODUCT_NO")
foreign "DIVISION" references "DIVISIONS"("DIVISION")
foreign "DEPT" references "DEPTS"("DEPT")
foreign "CATEGORY" references "CATEGORIES"("CATEGORY")
foreign "MFR" references "MFRS"("MFR")
cardinality 152 /* 152 */ /* 602 */ /* 900 */ /* 900 */
column “PRODUCT_NO” datatype CHARACTER length 4 cardinality 63 column “DESCRIPTION” datatype C STRING length 32 cardinality 62 column “DIVISION” datatype INTEGER length 1 cardinality 5 column “DEPT” datatype INTEGER length 1 cardinality 9 column “CATEGORY” datatype INTEGER length 1 cardinality 26 column “MFR” datatype INTEGER length 1 cardinality 31
column “YR” datatype INTEGER length 2 cardinality 7 column “NUM_ORDERS” datatype INTEGER length 4 cardinality 4 column “JAN_TOTAL” datatype FLOAT length 8 cardinality 23 column “JAN_DISC” datatype FLOAT length 8 cardinality 23 column “JAN_TAX” datatype FLOAT length 8 cardinality 23 column “JAN_MGN” datatype FLOAT length 8 cardinality 23 column “JAN_OR” datatype FLOAT length 8 cardinality 1 column “JAN_CN” datatype FLOAT length 8 cardinality 1 column “JAN_BO” datatype FLOAT length 8 cardinality 1 column “FEB_TOTAL” datatype FLOAT length 8 cardinality 16 column “FEB_DISC” datatype FLOAT length 8 cardinality 15 column “FEB_TAX” datatype FLOAT length 8 cardinality 16 column “FEB_MGN” datatype FLOAT length 8 cardinality 16 column “FEB_OR” datatype FLOAT length 8 cardinality 1 column “FEB_CN” datatype FLOAT length 8 cardinality 2 column “FEB_BO” datatype FLOAT length 8 cardinality 1 column “MAR_TOTAL” datatype FLOAT length 8 cardinality 14 column “MAR_DISC” datatype FLOAT length 8 cardinality 14 column “MAR_TAX” datatype FLOAT length 8 cardinality 14 column “MAR_MGN” datatype FLOAT length 8 cardinality 14 column “MAR_OR” datatype FLOAT length 8 cardinality 1 column “MAR_CN” datatype FLOAT length 8 cardinality 3 column “MAR_BO” datatype FLOAT length 8 cardinality 1 column “APR_TOTAL” datatype FLOAT length 8 cardinality 11 column “APR_DISC” datatype FLOAT length 8 cardinality 11 column “APR_TAX” datatype FLOAT length 8 cardinality 11 column “APR_MGN” datatype FLOAT length 8 cardinality 11 column “APR_OR” datatype FLOAT length 8 cardinality 1 column “APR_CN” datatype FLOAT length 8 cardinality 1 column “APR_BO” datatype FLOAT length 8 cardinality 1 column “MAY_TOTAL” datatype FLOAT length 8 cardinality 12 column “MAY_DISC” datatype FLOAT length 8 cardinality 12 column “MAY_TAX” datatype FLOAT length 8 cardinality 12 column “MAY_MGN” datatype FLOAT length 8 cardinality 13 column “MAY_OR” datatype FLOAT length 8 cardinality 1 column “MAY_CN” datatype FLOAT length 8 cardinality 1 column “MAY_BO” datatype FLOAT length 8 cardinality 1 column “JUN_TOTAL” datatype FLOAT length 8 cardinality 16 column “JUN_DISC” datatype FLOAT length 8 cardinality 16 column “JUN_TAX” datatype FLOAT length 8 cardinality 16 column “JUN_MGN” datatype FLOAT length 8 cardinality 16 column “JUN_OR” datatype FLOAT length 8 cardinality 1 column “JUN_CN” datatype FLOAT length 8 cardinality 2 column “JUN_BO” datatype FLOAT length 8 cardinality 1 column “JUL_TOTAL” datatype FLOAT length 8 cardinality 16 column “JUL_DISC” datatype FLOAT length 8 cardinality 16 column “JUL_TAX” datatype FLOAT length 8 cardinality 16 column “JUL_MGN” datatype FLOAT length 8 cardinality 16 column “JUL_OR” datatype FLOAT length 8 cardinality 1 column “JUL_CN” datatype FLOAT length 8 cardinality 1 column “JUL_BO” datatype FLOAT length 8 cardinality 1 column “AUG_TOTAL” datatype FLOAT length 8 cardinality 16 column “AUG_DISC” datatype FLOAT length 8 cardinality 16 column “AUG_TAX” datatype FLOAT length 8 cardinality 16 column “AUG_MGN” datatype FLOAT length 8 cardinality 16 column “AUG_OR” datatype FLOAT length 8 cardinality 1 column “AUG_CN” datatype FLOAT length 8 cardinality 1 column “AUG_BO” datatype FLOAT length 8 cardinality 1 column “SEP_TOTAL” datatype FLOAT length 8 cardinality 13 column “SEP_DISC” datatype FLOAT length 8 cardinality 13 column “SEP_TAX” datatype FLOAT length 8 cardinality 13 column “SEP_MGN” datatype FLOAT length 8 cardinality 13 column “SEP_OR” datatype FLOAT length 8 cardinality 1 column “SEP_CN” datatype FLOAT length 8 cardinality 1 column “SEP_BO” datatype FLOAT length 8 cardinality 2 column “OCT_TOTAL” datatype FLOAT length 8 cardinality 1 column “OCT_DISC” datatype FLOAT length 8 cardinality 18 column “OCT_TAX” datatype FLOAT length 8 cardinality 19 column “OCT_MGN” datatype FLOAT length 8 cardinality 19 column “OCT_OR” datatype FLOAT length 8 cardinality 19 column “OCT_CN” datatype FLOAT length 8 cardinality 2 column “OCT_BO” datatype FLOAT length 8 cardinality 1 column “NOV_TOTAL” datatype FLOAT length 8 cardinality 15 column “NOV_DISC” datatype FLOAT length 8 cardinality 15 column “NOV_TAX” datatype FLOAT length 8 cardinality 15 column “NOV_MGN” datatype FLOAT length 8 cardinality 15 column “NOV_OR” datatype FLOAT length 8 cardinality 1 column “NOV_CN” datatype FLOAT length 8 cardinality 2 column “NOV_BO” datatype FLOAT length 8 cardinality 1 column “DEC_TOTAL” datatype FLOAT length 8 cardinality 15 column “DEC_DISC” datatype FLOAT length 8 cardinality 15 column “DEC_TAX” datatype FLOAT length 8 cardinality 15 column “DEC_MGN” datatype FLOAT length 8 cardinality 15 column “DEC_OR” datatype FLOAT length 8 cardinality 1 column “DEC_CN” datatype FLOAT length 8 cardinality 1 column “DEC_BO” datatype FLOAT length 8 cardinality 1 column “TOTAL” datatype FLOAT length 8 cardinality 109 column “DISCOUNT” datatype FLOAT length 8 cardinality 109 column “SALES_TAX” datatype FLOAT length 8 cardinality 111 column “MARGIN” datatype FLOAT length 8 cardinality 114 column “ORDERED” datatype FLOAT length 8 cardinality 1 column “CANCELED” datatype FLOAT length 8 cardinality 9 column “BACKORDERED” datatype FLOAT length 8 cardinality 1 column “CASH” datatype FLOAT length 8 cardinality 17 column “CHECKS” datatype FLOAT length 8 cardinality 15 column “ATM” datatype FLOAT length 8 cardinality 16 column “VISA” datatype FLOAT length 8 cardinality 11 column “MC” datatype FLOAT length 8 cardinality 18 column “AMEX” datatype FLOAT length 8 cardinality 26 column “DISCOVER” datatype FLOAT length 8 cardinality 15 column “DINERSCLUB” datatype FLOAT length 8 cardinality 23 column “OTHERCC” datatype FLOAT length 8 cardinality 23 column “PO” datatype FLOAT length 8 cardinality 19 column “TELEPHONE” datatype FLOAT length 8 cardinality 21 column “FAX” datatype FLOAT length 8 cardinality 11 column “MAIL” datatype FLOAT length 8 cardinality 12 column “INTERNET” datatype FLOAT length 8 cardinality 9 column “CATALOGS” datatype FLOAT length 8 cardinality 33 column “RETAIL” datatype FLOAT length 8 cardinality 66
table “ORDERS_ROLLUP”
cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* 9 */
column “YR” datatype INTEGER length 2 cardinality 7 column “NUM_ORDERS” datatype INTEGER length 4 cardinality 7 column “JAN_TOTAL” datatype FLOAT length 8 cardinality 7 column “JAN_DISC” datatype FLOAT length 8 cardinality 7 column “JAN_TAX” datatype FLOAT length 8 cardinality 7 column “JAN_MGN” datatype FLOAT length 8 cardinality 7 column “JAN_OR” datatype FLOAT length 8 cardinality 1 column “JAN_CN” datatype FLOAT length 8 cardinality 1 column “JAN_BO” datatype FLOAT length 8 cardinality 1 column “FEB_TOTAL” datatype FLOAT length 8 cardinality 7 column “FEB_DISC” datatype FLOAT length 8 cardinality 7 column “FEB_TAX” datatype FLOAT length 8 cardinality 7 column “FEB_MGN” datatype FLOAT length 8 cardinality 7 column “FEB_OR” datatype FLOAT length 8 cardinality 1 column “FEB_CN” datatype FLOAT length 8 cardinality 2 column “FEB_BO” datatype FLOAT length 8 cardinality 1 column “MAR_TOTAL” datatype FLOAT length 8 cardinality 6 column “MAR_DISC” datatype FLOAT length 8 cardinality 6 column “MAR_TAX” datatype FLOAT length 8 cardinality 6 column “MAR_MGN” datatype FLOAT length 8 cardinality 6 column “MAR_OR” datatype FLOAT length 8 cardinality 1 column “MAR_CN” datatype FLOAT length 8 cardinality 3 column “MAR_BO” datatype FLOAT length 8 cardinality 1 column “APR_TOTAL” datatype FLOAT length 8 cardinality 6 column “APR_DISC” datatype FLOAT length 8 cardinality 6 column “APR_TAX” datatype FLOAT length 8 cardinality 6 column “APR_MGN” datatype FLOAT length 8 cardinality 6 column “APR_OR” datatype FLOAT length 8 cardinality 1 column “APR_CN” datatype FLOAT length 8 cardinality 1 column “APR_BO” datatype FLOAT length 8 cardinality 1 column “MAY_TOTAL” datatype FLOAT length 8 cardinality 6 column “MAY_DISC” datatype FLOAT length 8 cardinality 6 column “MAY_TAX” datatype FLOAT length 8 cardinality 6 column “MAY_MGN” datatype FLOAT length 8 cardinality 6 column “MAY_OR” datatype FLOAT length 8 cardinality 1 column “MAY_CN” datatype FLOAT length 8 cardinality 1 column “MAY_BO” datatype FLOAT length 8 cardinality 1 column “JUN_TOTAL” datatype FLOAT length 8 cardinality 7 column “JUN_DISC” datatype FLOAT length 8 cardinality 7 column “JUN_TAX” datatype FLOAT length 8 cardinality 7 column “JUN_MGN” datatype FLOAT length 8 cardinality 7 column “JUN_OR” datatype FLOAT length 8 cardinality 1 column “JUN_CN” datatype FLOAT length 8 cardinality 2 column “JUN_BO” datatype FLOAT length 8 cardinality 1 column “JUL_TOTAL” datatype FLOAT length 8 cardinality 4 column “JUL_DISC” datatype FLOAT length 8 cardinality 4 column “JUL_TAX” datatype FLOAT length 8 cardinality 4 column “JUL_MGN” datatype FLOAT length 8 cardinality 4 column “JUL_OR” datatype FLOAT length 8 cardinality 1 column “JUL_CN” datatype FLOAT length 8 cardinality 1 column “JUL_BO” datatype FLOAT length 8 cardinality 1 column “AUG_TOTAL” datatype FLOAT length 8 cardinality 7 column “AUG_DISC” datatype FLOAT length 8 cardinality 7 column “AUG_TAX” datatype FLOAT length 8 cardinality 7 column “AUG_MGN” datatype FLOAT length 8 cardinality 7 column “AUG_OR” datatype FLOAT length 8 cardinality 1 column “AUG_CN” datatype FLOAT length 8 cardinality 1 column “AUG_BO” datatype FLOAT length 8 cardinality 1 column “SEP_TOTAL” datatype FLOAT length 8 cardinality 5 column “SEP_DISC” datatype FLOAT length 8 cardinality 5 column “SEP_TAX” datatype FLOAT length 8 cardinality 5 column “SEP_MGN” datatype FLOAT length 8 cardinality 5 column “SEP_OR” datatype FLOAT length 8 cardinality 1 column “SEP_CN” datatype FLOAT length 8 cardinality 2 column “SEP_BO” datatype FLOAT length 8 cardinality 1 column “OCT_TOTAL” datatype FLOAT length 8 cardinality 7 column “OCT_DISC” datatype FLOAT length 8 cardinality 7 column “OCT_TAX” datatype FLOAT length 8 cardinality 7 column “OCT_MGN” datatype FLOAT length 8 cardinality 7 column “OCT_OR” datatype FLOAT length 8 cardinality 1 column “OCT_CN” datatype FLOAT length 8 cardinality 2 column “OCT_BO” datatype FLOAT length 8 cardinality 1 column “NOV_TOTAL” datatype FLOAT length 8 cardinality 6 column “NOV_DISC” datatype FLOAT length 8 cardinality 6 column “NOV_TAX” datatype FLOAT length 8 cardinality 6 column “NOV_MGN” datatype FLOAT length 8 cardinality 6 column “NOV_OR” datatype FLOAT length 8 cardinality 1 column “NOV_CN” datatype FLOAT length 8 cardinality 2 column “NOV_BO” datatype FLOAT length 8 cardinality 1 column “DEC_TOTAL” datatype FLOAT length 8 cardinality 7 column “DEC_DISC” datatype FLOAT length 8 cardinality 7 column “DEC_TAX” datatype FLOAT length 8 cardinality 7 column “DEC_MGN” datatype FLOAT length 8 cardinality 7 column “DEC_OR” datatype FLOAT length 8 cardinality 1 column “DEC_CN” datatype FLOAT length 8 cardinality 1 column “DEC_BO” datatype FLOAT length 8 cardinality 1 column “TOTAL” datatype FLOAT length 8 cardinality 7 column “DISCOUNT” datatype FLOAT length 8 cardinality 7 column “SALES_TAX” datatype FLOAT length 8 cardinality 7 column “MARGIN” datatype FLOAT length 8 cardinality 7 column “ORDERED” datatype FLOAT length 8 cardinality 1 column “CANCELED” datatype FLOAT length 8 cardinality 6 column “BACKORDERED” datatype FLOAT length 8 cardinality 1 column “CASH” datatype FLOAT length 8 cardinality 7 column “CHECKS” datatype FLOAT length 8 cardinality 6 column “ATM” datatype FLOAT length 8 cardinality 7 column “VISA” datatype FLOAT length 8 cardinality 6 column “MC” datatype FLOAT length 8 cardinality 7 column “AMEX” datatype FLOAT length 8 cardinality 7 column “DISCOVER” datatype FLOAT length 8 cardinality 6 column “DINERSCLUB” datatype FLOAT length 8 cardinality 7 column “OTHERCC” datatype FLOAT length 8 cardinality 7 column “PO” datatype FLOAT length 8 cardinality 7 column “TELEPHONE” datatype FLOAT length 8 cardinality 7 column “FAX” datatype FLOAT length 8 cardinality 7 column “MAIL” datatype FLOAT length 8 cardinality 6 column “INTERNET” datatype FLOAT length 8 cardinality 6 column “CATALOGS” datatype FLOAT length 8 cardinality 7 column “RETAIL” datatype FLOAT length 8 cardinality 7
table “ORDERS_SVW”
foreign "ACCT" references "PROSPECTS"("ACCT")
foreign "STATE" references "STATES"("STATE")
foreign "ZIP" references "ZIPCODES"("ZIP")
foreign "REGION" references "REGIONS"("REGION")
foreign "COUNTRY" references "COUNTRIES"("COUNTRY")
foreign "GENDER" references "GENDERS"("GENDER")
foreign "MAILFLAG" references "MAILFLAGS"("MAILFLAG")
foreign "MAILING" references "MAILINGS"("MAILING")
foreign "PROFESSION" references "PROFESSIONS"("PROFESSION")
foreign "INCOME" references "INCOMES"("INCOME")
foreign "PROFILE" references "PROFILES"("PROFILE")
foreign "PRODUCT_NO" references "PRODUCTS"("PRODUCT_NO")
foreign "DIVISION" references "DIVISIONS"("DIVISION")
foreign "DEPT" references "DEPTS"("DEPT")
foreign "CATEGORY" references "CATEGORIES"("CATEGORY")
foreign "MFR" references "MFRS"("MFR")
foreign "ORDER_DATE" references "DATES"("DT")
foreign "STATUS" references "STATUSES"("STATUS")
foreign "TAX_STATE" references "STATES"("STATE")
foreign "SOURCE" references "SOURCES"("SOURCE")
foreign "PMT_METHOD" references "PMT_METHODS"("PMT_METHOD")
cardinality 199 /* 199 */ /* 2000 */ /* 200000 */ /* 20000000 */
column “ACCT” datatype INTEGER length 4 cardinality 3 column “STATE” datatype CHARACTER length 2 cardinality 3 column “ZIP” datatype C STRING length 10 cardinality 3 column “REGION” datatype CHARACTER length 2 cardinality 1 column “COUNTRY” datatype CHARACTER length 2 cardinality 1 column “GENDER” datatype CHARACTER length 1 cardinality 2 column “MAILFLAG” datatype INTEGER length 1 cardinality 2 column “MAILING” datatype INTEGER length 1 cardinality 1 column “PROFESSION” datatype INTEGER length 1 cardinality 3 column “INCOME” datatype INTEGER length 1 cardinality 3 column “PROFILE” datatype INTEGER length 1 cardinality 1 column “PREFERRED” datatype INTEGER length 1 cardinality 2 column “FRQ_BUY_MBR” datatype INTEGER length 1 cardinality 2 column “CR_LIMIT” datatype INTEGER length 1 cardinality 3 column “DISCOUNT_RT” datatype INTEGER length 1 cardinality 3 column “CUST_SINCE” datatype INTEGER length 2 cardinality 3 column “LAST_ORDER” datatype ORACLE DATETIME length 7 cardinality 3
column “PRODUCT_NO” datatype CHARACTER length 4 cardinality 63 column “DIVISION” datatype INTEGER length 1 cardinality 5 column “DEPT” datatype INTEGER length 1 cardinality 9 column “CATEGORY” datatype INTEGER length 1 cardinality 26 column “MFR” datatype INTEGER length 1 cardinality 31
column “ORDER_DATE” datatype ORACLE DATETIME length 7 cardinality 68 column “OR_YR” datatype INTEGER length 2 cardinality 7 column “OR_MO” datatype CHARACTER length 3 cardinality 12 column “OR_DY_OF_MO” datatype INTEGER length 1 cardinality 3 column “OR_DY_OF_YR” datatype INTEGER length 2 cardinality 22 column “OR_DY_OF_WK” datatype INTEGER length 1 cardinality 7 column “OR_WK” datatype INTEGER length 1 cardinality 23 column “OR_QTR” datatype INTEGER length 1 cardinality 4 column “OR_FQTR” datatype INTEGER length 1 cardinality 4 column “OR_FYR” datatype INTEGER length 2 cardinality 8 column “STATUS” datatype CHARACTER length 2 cardinality 2 column “TAX_STATE” datatype CHARACTER length 2 cardinality 3 column “SOURCE” datatype INTEGER length 1 cardinality 6 column “PMT_METHOD” datatype INTEGER length 1 cardinality 10 column “DISCOUNT” datatype INTEGER length 1 cardinality 3 column “QUANTITY” datatype INTEGER length 1 cardinality 20 column “SALES_TAX” datatype FLOAT length 4 cardinality 111 column “AMOUNT” datatype FLOAT length 4 cardinality 64 column “TOTAL” datatype FLOAT length 4 cardinality 110 index “DIVISIONS_DIVISION_PK”
type NATIVE SORTED as "DIVISIONS.DIVISION"
index “DEPTS_DEPT_PK”
type NATIVE SORTED as "DEPTS.DEPT"
index “CATEGORIES_CATEGORY_PK”
type NATIVE SORTED as "CATEGORIES.CATEGORY"
index “MFRS_MFR_PK”
type NATIVE SORTED as "MFRS.MFR"
index “PRODUCTS_PRODUCT_NO_PK”
type NATIVE SORTED as "PRODUCTS.PRODUCT_NO"
index “STATES_STATE_PK”
type NATIVE SORTED as "STATES.STATE"
index “COUNTIES_COUNTY_STATE_PK”
type NATIVE SORTED as "COUNTIES.COUNTY_CODE","COUNTIES.STATE"
index “COUNTRIES_COUNTRY_PK”
type NATIVE SORTED as "COUNTRIES.COUNTRY"
index “REGIONS_REGION_PK”
type NATIVE SORTED as "REGIONS.REGION"
index “ZIPCODES_ZIP_PK”
type NATIVE SORTED as "ZIPCODES.ZIP"
index “COMPANIES_COMPANY_PK”
type NATIVE SORTED as "COMPANIES.COMPANY"
index “GENDERS_GENDER_PK”
type NATIVE SORTED as "GENDERS.GENDER"
index “MAILFLAGS_MAILFLAG_PK”
type NATIVE SORTED as "MAILFLAGS.MAILFLAG"
index “MAILINGS_MAILING_PK”
type NATIVE SORTED as "MAILINGS.MAILING"
index “INCOMES_INCOME_PK”
type NATIVE SORTED as "INCOMES.INCOME"
index “PROFESSIONS_PROFESSION_PK”
type NATIVE SORTED as "PROFESSIONS.PROFESSION"
index “PROFILES_PROFILE_PK”
type NATIVE SORTED as "PROFILES.PROFILE"
index “DATES_DT_PK”
type NATIVE SORTED as "DATES.DT"
index “PROSPECTS_ACCT_PK”
type NATIVE SORTED as "PROSPECTS.ACCT"
index “TICKLERS_TICKLER_PK”
type NATIVE SORTED as "TICKLERS.TICKLER"
index “INITIALS_INITIALS_PK”
type NATIVE SORTED as "INITIALS.INITIALS"
index “STATUSES_STATUS_PK”
type NATIVE SORTED as "STATUSES.STATUS"
index “PMT_METHODS_PMT_METHOD_PK”
type NATIVE SORTED as "PMT_METHODS.PMT_METHOD"
index “SOURCES_SOURCE_PK”
type NATIVE SORTED as "SOURCES.SOURCE"
index “ACTIVITY_REDEF_ROWID_UK”
type NATIVE SORTED as "ACTIVITY.REDEF_ROWID"
<code>