DRAFT
environment "star_env"
set wildcards *, ?, #
/* ===================== DATABASE: STAR ==================================== */
database "star"
type flatfile
indexprefix "idx/STAR"
/* --------------------- TABLE: DIVISIONS ---------------------------------- */
table "DIVISIONS"
physical "dat/div.dat"
primary "DIVISION"
cardinality 5
column "DIVISION" datatype INTEGER length 1 cardinality 5
column "DESCRIPTION" datatype C STRING length 32 cardinality 5
/* --------------------- TABLE: DEPTS -------------------------------------- */
table "DEPTS"
physical "dat/dpt.dat"
primary "DEPT"
cardinality 10
column "DEPT" datatype INTEGER length 1 cardinality 10
column "DESCRIPTION" datatype C STRING length 32 cardinality 10
/* --------------------- TABLE: CATEGORIES --------------------------------- */
table "CATEGORIES"
physical "dat/cat.dat"
primary "CATEGORY"
cardinality 30
column "CATEGORY" datatype INTEGER length 1 cardinality 30
column "DESCRIPTION" datatype C STRING length 32 cardinality 30
/* --------------------- TABLE: MFRS --------------------------------------- */
table "MFRS"
physical "dat/mfr.dat"
primary "MFR"
cardinality 40
column "MFR" datatype INTEGER length 1 cardinality 40
column "DESCRIPTION" datatype C STRING length 32 cardinality 40
/* --------------------- TABLE: PRODUCTS ----------------------------------- */
table "PRODUCTS"
physical "dat/prd.dat"
primary "PRODUCT_NO"
cardinality 100
column "PRODUCT_NO" datatype CHARACTER length 4 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: COUNTRIES --------------------------------- */
table "COUNTRIES"
physical "dat/cnt.dat"
primary "COUNTRY"
cardinality 1
column "COUNTRY" datatype CHARACTER length 2 cardinality 1
column "DESCRIPTION" datatype C STRING length 32 cardinality 1
/* --------------------- TABLE: REGIONS ------------------------------------ */
table "REGIONS"
physical "dat/reg.dat"
primary "REGION"
cardinality 6
column "REGION" datatype CHARACTER length 2 cardinality 6
column "DESCRIPTION" datatype C STRING length 32 cardinality 6
/* --------------------- TABLE: STATES ------------------------------------ */
table "STATES"
physical "dat/sta.dat"
primary "STATE"
cardinality 57
column "STATE" datatype CHARACTER length 2 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 ----------------------------------- */
table "COUNTIES"
physical "dat/cty.dat"
primary "COUNTY_CODE","STATE"
cardinality 3223
column "COUNTY_CODE" datatype CHARACTER length 3 cardinality 327
column "COUNTY" datatype C STRING length 26 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: ZIPCODES ----------------------------------- */
table "ZIPCODES"
physical "dat/zip.dat"
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 ---------------------------------- */
table "COMPANIES"
physical "dat/cmp.dat"
primary "COMPANY"
cardinality 6000
column "COMPANY" datatype C STRING length 40 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 ------------------------------------ */
table "GENDERS"
physical "dat/gdr.dat"
primary "GENDER"
cardinality 2
column "GENDER" datatype CHARACTER length 1 cardinality 2
column "DESCRIPTION" datatype C STRING length 32 cardinality 2
/* --------------------- TABLE: MAILFLAGS ---------------------------------- */
table "MAILFLAGS"
physical "dat/mlf.dat"
primary "MAILFLAG"
cardinality 4
column "MAILFLAG" datatype INTEGER length 1 cardinality 4
column "DESCRIPTION" datatype C STRING length 32 cardinality 4
/* --------------------- TABLE: MAILINGS ----------------------------------- */
table "MAILINGS"
physical "dat/mal.dat"
primary "MAILING"
cardinality 8
column "MAILING" datatype INTEGER length 1 cardinality 8
column "DESCRIPTION" datatype C STRING length 32 cardinality 8
/* --------------------- TABLE: INCOMES ------------------------------------ */
table "INCOMES"
physical "dat/inc.dat"
primary "INCOME"
cardinality 16
column "INCOME" datatype INTEGER length 1 cardinality 16
column "DESCRIPTION" datatype C STRING length 32 cardinality 16
/* --------------------- TABLE: PROFESSIONS -------------------------------- */
table "PROFESSIONS"
physical "dat/prf.dat"
primary "PROFESSION"
cardinality 10
column "PROFESSION" datatype INTEGER length 1 cardinality 10
column "DESCRIPTION" datatype C STRING length 32 cardinality 10
/* --------------------- TABLE: PROFILES ----------------------------------- */
table "PROFILES"
physical "dat/pfl.dat"
primary "PROFILE"
cardinality 6
column "PROFILE" datatype INTEGER length 1 cardinality 6
column "DESCRIPTION" datatype C STRING length 32 cardinality 6
/* --------------------- TABLE: DATES -------------------------------------- */
table "DATES"
physical "dat/dat.dat"
primary "DT"
cardinality 4383 /* All dates from 1/1/1990 to 12/31/2001 */
column "DT" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 4383
column "YR" datatype OMNIDEX DATE length 2 format YYYY cardinality 12
column "MO" datatype OMNIDEX DATE length 1 format MM cardinality 12
column "DY_OF_MO" datatype OMNIDEX DATE length 1 format DD 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 OMNIDEX DATE length 2 format YYYY cardinality 13
column "DESCRIPTION" datatype C STRING length 32 cardinality 4383
/* --------------------- TABLE: PROSPECTS ---------------------------------- */
table "PROSPECTS"
physical "dat/pro.dat"
primary "ACCT"
cardinality 10 /* 10 */ /* 100 */ /* 10000 */ /* 1000000 */
column "ACCT" datatype INTEGER length 4 cardinality 10 /* 10 */ /* 100 */ /* 10000 */ /* 1000000 */
column "COMPANY" datatype C STRING length 40 cardinality 10 /* 10 */ /* 100 */ /* 4836 */ /* 6000 */
column "CONTACT" datatype C STRING length 24 cardinality 10 /* 10 */ /* 100 */ /* 9960 */ /* 817780 */
column "CITY" datatype C STRING length 26 cardinality 10 /* 10 */ /* 82 */ /* 1180 */ /* 1319 */
column "STATE" datatype CHARACTER length 2 cardinality 10 /* 10 */ /* 29 */ /* 51 */ /* 51 */
column "ZIP" datatype C STRING length 10 cardinality 10 /* 10 */ /* 97 */ /* 2395 */ /* 2720 */
column "REGION" datatype CHARACTER length 2 cardinality 3 /* 3 */ /* 6 */ /* 6 */ /* 6 */
column "COUNTRY" datatype CHARACTER length 2 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* 1 */
column "PHONE" datatype C STRING length 16 cardinality 9
column "GENDER" datatype CHARACTER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* 2 */
column "MAILFLAG" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 4 */ /* 4 */ /* 4 */
column "MAILING" datatype INTEGER length 1 cardinality 1 /* 1 */ /* 8 */ /* 8 */ /* 8 */
column "PROFESSION" datatype INTEGER length 1 cardinality 9 /* 9 */ /* 10 */ /* 10 */ /* 10 */
column "INCOME" datatype INTEGER length 1 cardinality 6 /* 6 */ /* 15 */ /* 15 */ /* 15 */
column "PROFILE" datatype INTEGER length 1 cardinality 4 /* 4 */ /* 6 */ /* 6 */ /* 6 */
column "PREFERRED" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* 2 */
column "FRQ_BUY_MBR" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* 2 */
column "CR_LIMIT" datatype INTEGER length 1 cardinality 5 /* 5 */ /* 14 */ /* 14 */ /* 14 */
column "DISCOUNT_RT" datatype INTEGER length 1 cardinality 4 /* 4 */ /* 5 */ /* 5 */ /* 5 */
column "CUST_SINCE" datatype OMNIDEX DATE length 2 format YYYY cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* 9 */
column "LAST_ORDER" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 10 /* 10 */ /* 94 */ /* 1720 */ /* 3286 */
column "SEARCH_KEY" datatype CHARACTER length 12 cardinality 10
column "COMPANY_SDX" datatype C STRING length 25 as "$soundex(COMPANY)"
/* --------------------- TABLE: TICKLERS ----------------------------------- */
table "TICKLERS"
physical "dat/tkl.dat"
primary "TICKLER"
cardinality 12
column "TICKLER" datatype CHARACTER length 2 cardinality 12
column "DESCRIPTION" datatype C STRING length 32 cardinality 12
/* --------------------- TABLE: INITIALS ----------------------------------- */
table "INITIALS"
physical "dat/itl.dat"
primary "INITIALS"
cardinality 10
column "INITIALS" datatype CHARACTER length 4 cardinality 25
column "DESCRIPTION" datatype C STRING length 32 cardinality 25
/* --------------------- TABLE: ACTIVITY ----------------------------------- */
table "ACTIVITY"
physical "dat/act.dat"
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 /* 10 */ /* 93 */ /* 9049 */ /* 863606 */
column "DT" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 40 /* 40 */ /* 114 */ /* 1323 */ /* 2693 */
column "TICKLER" datatype CHARACTER length 2 cardinality 7 /* 7 */ /* 12 */ /* 12 */ /* 12 */
column "INITIALS" datatype CHARACTER length 4 cardinality 4 /* 4 */ /* 19 */ /* 25 */ /* 25 */
/* --------------------- TABLE: STATUSES ----------------------------------- */
table "STATUSES"
physical "dat/sts.dat"
primary "STATUS"
cardinality 4
column "STATUS" datatype CHARACTER length 2 cardinality 4
column "DESCRIPTION" datatype C STRING length 32 cardinality 4
/* --------------------- TABLE: PMT_METHODS -------------------------------- */
table "PMT_METHODS"
physical "dat/pmt.dat"
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 ------------------------------------ */
table "SOURCES"
physical "dat/src.dat"
primary "SOURCE"
cardinality 6
column "SOURCE" datatype INTEGER length 1 cardinality 6
column "DESCRIPTION" datatype C STRING length 32 cardinality 6
/* --------------------- TABLE: ORDERS ------------------------------------- */
table "ORDERS"
physical "dat/ord.dat"
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 /* 3 */ /* 100 */ /* 10000 */ /* 1000000 */
column "PRODUCT_NO" datatype CHARACTER length 4 cardinality 63 /* 63 */ /* 100 */ /* 100 */ /* 100 */
column "ORDER_DATE" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 68 /* 68 */ /* 200 */ /* 1774 */ /* 3286 */
column "STATUS" datatype CHARACTER length 2 cardinality 2 /* 2 */ /* 4 */ /* 4 */ /* 4 */
column "TAX_STATE" datatype CHARACTER length 2 cardinality 3 /* 3 */ /* 29 */ /* 51 */ /* 51 */
column "SOURCE" datatype INTEGER length 1 cardinality 6 /* 6 */ /* 6 */ /* 6 */ /* 6 */
column "PMT_METHOD" datatype INTEGER length 1 cardinality 10 /* 10 */ /* 10 */ /* 10 */ /* 10 */
column "DISCOUNT" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 5 */ /* 5 */ /* 5 */
column "QUANTITY" datatype INTEGER length 1 cardinality 20 /* 20 */ /* 20 */ /* 21 */ /* 21 */
column "SALES_TAX" datatype FLOAT length 4 cardinality 111 /* 111 */ /* 742 */ /* 8003 */ /* 20988 */
column "AMOUNT" datatype FLOAT length 4 cardinality 64 /* 64 */ /* 217 */ /* 262 */ /* 262 */
column "TOTAL" datatype FLOAT length 4 cardinality 110 /* 110 */ /* 553 */ /* 2412 */ /* 2901 */
/* --------------------- TABLE: PROSPECTS_ROLLUP --------------------------- */
table "PROSPECTS_ROLLUP"
physical "dat/prr.dat"
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 /* 3 */ /* 100 */ /* 10000 */ /* */
column "COMPANY" datatype C STRING length 40 cardinality 3 /* 3 */ /* 100 */ /* 4836 */ /* */
column "CONTACT" datatype C STRING length 24 cardinality 3 /* 3 */ /* 100 */ /* 9960 */ /* */
column "CITY" datatype C STRING length 26 cardinality 3 /* 3 */ /* 82 */ /* 1180 */ /* */
column "STATE" datatype CHARACTER length 2 cardinality 3 /* 3 */ /* 29 */ /* 51 */ /* */
column "ZIP" datatype C STRING length 10 cardinality 3 /* 3 */ /* 97 */ /* 2395 */ /* */
column "REGION" datatype CHARACTER length 2 cardinality 1 /* 1 */ /* 6 */ /* 6 */ /* */
column "COUNTRY" datatype CHARACTER length 2 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "PHONE" datatype C STRING length 16 cardinality 3
column "GENDER" datatype CHARACTER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* */
column "MAILFLAG" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 4 */ /* 4 */ /* */
column "MAILING" datatype INTEGER length 1 cardinality 1 /* 1 */ /* 8 */ /* 8 */ /* */
column "PROFESSION" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 10 */ /* 10 */ /* */
column "INCOME" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 15 */ /* 15 */ /* */
column "PROFILE" datatype INTEGER length 1 cardinality 1 /* 1 */ /* 6 */ /* 6 */ /* */
column "PREFERRED" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* */
column "FRQ_BUY_MBR" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* */
column "CR_LIMIT" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 14 */ /* 14 */ /* */
column "DISCOUNT_RT" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 5 */ /* 5 */ /* */
column "CUST_SINCE" datatype OMNIDEX DATE length 2 format YYYY cardinality 3 /* 3 */ /* 9 */ /* 9 */ /* */
column "LAST_ORDER" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 3 /* 3 */ /* 94 */ /* 1720 */ /* */
column "SEARCH_KEY" datatype CHARACTER length 12 cardinality 3
/* Rollup columns */
column "YR" datatype OMNIDEX DATE length 2 format YYYY cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "NUM_ORDERS" datatype INTEGER length 4 cardinality 9 /* 9 */ /* 40 */ /* 72 */ /* */
column "JAN_TOTAL" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 88 */ /* 4243 */ /* */
column "JAN_DISC" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 56 */ /* 3682 */ /* */
column "JAN_TAX" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 89 */ /* 5299 */ /* */
column "JAN_MGN" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 87 */ /* 5038 */ /* */
column "JAN_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JAN_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JAN_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "FEB_TOTAL" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 92 */ /* 4043 */ /* */
column "FEB_DISC" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 57 */ /* 3445 */ /* */
column "FEB_TAX" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 89 */ /* 5133 */ /* */
column "FEB_MGN" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 94 */ /* 4889 */ /* */
column "FEB_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "FEB_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 7 */ /* 347 */ /* */
column "FEB_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAR_TOTAL" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 76 */ /* 3852 */ /* */
column "MAR_DISC" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 47 */ /* 3255 */ /* */
column "MAR_TAX" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 82 */ /* 4974 */ /* */
column "MAR_MGN" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 79 */ /* 4684 */ /* */
column "MAR_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAR_CN" datatype FLOAT length 8 cardinality 3 /* 3 */ /* 10 */ /* 306 */ /* */
column "MAR_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "APR_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 81 */ /* 3657 */ /* */
column "APR_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 45 */ /* 3087 */ /* */
column "APR_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 82 */ /* 4753 */ /* */
column "APR_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 83 */ /* 4498 */ /* */
column "APR_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "APR_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 5 */ /* 281 */ /* */
column "APR_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAY_TOTAL" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 80 */ /* 3524 */ /* */
column "MAY_DISC" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 44 */ /* 2932 */ /* */
column "MAY_TAX" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 79 */ /* 4617 */ /* */
column "MAY_MGN" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 79 */ /* 4372 */ /* */
column "MAY_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAY_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 10 */ /* 269 */ /* */
column "MAY_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUN_TOTAL" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 73 */ /* 3455 */ /* */
column "JUN_DISC" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 44 */ /* 2831 */ /* */
column "JUN_TAX" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 72 */ /* 4542 */ /* */
column "JUN_MGN" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 74 */ /* 4262 */ /* */
column "JUN_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUN_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 9 */ /* 281 */ /* */
column "JUN_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUL_TOTAL" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 63 */ /* 2702 */ /* */
column "JUL_DISC" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 34 */ /* 2162 */ /* */
column "JUL_TAX" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 59 */ /* 3692 */ /* */
column "JUL_MGN" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 65 */ /* 3390 */ /* */
column "JUL_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 14 */ /* 715 */ /* */
column "JUL_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 4 */ /* 238 */ /* */
column "JUL_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 6 */ /* 320 */ /* */
column "AUG_TOTAL" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 55 */ /* 2699 */ /* */
column "AUG_DISC" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 31 */ /* 2126 */ /* */
column "AUG_TAX" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 51 */ /* 3636 */ /* */
column "AUG_MGN" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 55 */ /* 3374 */ /* */
column "AUG_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 8 */ /* 564 */ /* */
column "AUG_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 3 */ /* 216 */ /* */
column "AUG_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 11 */ /* 294 */ /* */
column "SEP_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 53 */ /* 2618 */ /* */
column "SEP_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 32 */ /* 2100 */ /* */
column "SEP_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 52 */ /* 3560 */ /* */
column "SEP_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 53 */ /* 3280 */ /* */
column "SEP_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 8 */ /* 453 */ /* */
column "SEP_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 3 */ /* 216 */ /* */
column "SEP_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 6 */ /* 223 */ /* */
column "OCT_TOTAL" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 50 */ /* 2594 */ /* */
column "OCT_DISC" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 26 */ /* 2053 */ /* */
column "OCT_TAX" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 49 */ /* 3498 */ /* */
column "OCT_MGN" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 49 */ /* 3203 */ /* */
column "OCT_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 8 */ /* 353 */ /* */
column "OCT_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 2 */ /* 202 */ /* */
column "OCT_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 173 */ /* */
column "NOV_TOTAL" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 49 */ /* 2545 */ /* */
column "NOV_DISC" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 27 */ /* 2051 */ /* */
column "NOV_TAX" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 49 */ /* 3410 */ /* */
column "NOV_MGN" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 49 */ /* 3134 */ /* */
column "NOV_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 5 */ /* 246 */ /* */
column "NOV_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 8 */ /* 206 */ /* */
column "NOV_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 4 */ /* 123 */ /* */
column "DEC_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 42 */ /* 2526 */ /* */
column "DEC_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 23 */ /* 2011 */ /* */
column "DEC_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 35 */ /* 3403 */ /* */
column "DEC_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 42 */ /* 3151 */ /* */
column "DEC_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 127 */ /* */
column "DEC_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 3 */ /* 207 */ /* */
column "DEC_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 60 */ /* */
column "TOTAL" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 178 */ /* 11975 */ /* */
column "DISCOUNT" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 64 */ /* 7511 */ /* */
column "SALES_TAX" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 167 */ /* 15628 */ /* */
column "MARGIN" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 185 */ /* 15853 */ /* */
column "ORDERED" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 20 */ /* 983 */ /* */
column "CANCELED" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 45 */ /* 1868 */ /* */
column "BACKORDERED" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 16 */ /* 678 */ /* */
column "CASH" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 86 */ /* 4244 */ /* */
column "CHECKS" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 85 */ /* 4329 */ /* */
column "ATM" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 83 */ /* 4269 */ /* */
column "VISA" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 82 */ /* 4271 */ /* */
column "MC" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 97 */ /* 4341 */ /* */
column "AMEX" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 93 */ /* 4352 */ /* */
column "DISCOVER" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 89 */ /* 4315 */ /* */
column "DINERSCLUB" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 87 */ /* 4330 */ /* */
column "OTHERCC" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 91 */ /* 4299 */ /* */
column "PO" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 19 */ /* 1330 */ /* */
column "TELEPHONE" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 84 */ /* 4030 */ /* */
column "FAX" datatype FLOAT length 8 cardinality 8 /* 8 */ /* 55 */ /* 2604 */ /* */
column "MAIL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 70 */ /* 3325 */ /* */
column "INTERNET" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 48 */ /* 1778 */ /* */
column "CATALOGS" datatype FLOAT length 8 cardinality 10 /* 10 */ /* 124 */ /* 7479 */ /* */
column "RETAIL" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 146 */ /* 9914 */ /* */
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 ---------------------------- */
table "PRODUCTS_ROLLUP"
physical "dat/pdr.dat"
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 /* 63 */ /* 100 */ /* 100 */ /* */
column "DESCRIPTION" datatype C STRING length 32 cardinality 62 /* 62 */ /* 95 */ /* 95 */ /* */
column "DIVISION" datatype INTEGER length 1 cardinality 5 /* 5 */ /* 5 */ /* 5 */ /* */
column "DEPT" datatype INTEGER length 1 cardinality 9 /* 9 */ /* 10 */ /* 10 */ /* */
column "CATEGORY" datatype INTEGER length 1 cardinality 26 /* 26 */ /* 30 */ /* 30 */ /* */
column "MFR" datatype INTEGER length 1 cardinality 31 /* 31 */ /* 40 */ /* 40 */ /* */
/* Rollup columns */
column "YR" datatype OMNIDEX DATE length 2 format YYYY cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "NUM_ORDERS" datatype INTEGER length 4 cardinality 4 /* 4 */ /* 17 */ /* 425 */ /* */
column "JAN_TOTAL" datatype FLOAT length 8 cardinality 23 /* 23 */ /* 164 */ /* 854 */ /* */
column "JAN_DISC" datatype FLOAT length 8 cardinality 23 /* 23 */ /* 135 */ /* 781 */ /* */
column "JAN_TAX" datatype FLOAT length 8 cardinality 23 /* 23 */ /* 173 */ /* 874 */ /* */
column "JAN_MGN" datatype FLOAT length 8 cardinality 23 /* 23 */ /* 169 */ /* 867 */ /* */
column "JAN_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JAN_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JAN_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "FEB_TOTAL" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 126 */ /* 865 */ /* */
column "FEB_DISC" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 95 */ /* 780 */ /* */
column "FEB_TAX" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 135 */ /* 874 */ /* */
column "FEB_MGN" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 134 */ /* 869 */ /* */
column "FEB_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "FEB_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 7 */ /* 306 */ /* */
column "FEB_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAR_TOTAL" datatype FLOAT length 8 cardinality 14 /* 14 */ /* 108 */ /* 845 */ /* */
column "MAR_DISC" datatype FLOAT length 8 cardinality 14 /* 14 */ /* 86 */ /* 755 */ /* */
column "MAR_TAX" datatype FLOAT length 8 cardinality 14 /* 14 */ /* 118 */ /* 866 */ /* */
column "MAR_MGN" datatype FLOAT length 8 cardinality 14 /* 14 */ /* 115 */ /* 855 */ /* */
column "MAR_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAR_CN" datatype FLOAT length 8 cardinality 3 /* 3 */ /* 11 */ /* 309 */ /* */
column "MAR_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "APR_TOTAL" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 120 */ /* 857 */ /* */
column "APR_DISC" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 83 */ /* 768 */ /* */
column "APR_TAX" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 127 */ /* 874 */ /* */
column "APR_MGN" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 129 */ /* 871 */ /* */
column "APR_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "APR_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 5 */ /* 276 */ /* */
column "APR_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAY_TOTAL" datatype FLOAT length 8 cardinality 12 /* 12 */ /* 127 */ /* 850 */ /* */
column "MAY_DISC" datatype FLOAT length 8 cardinality 12 /* 12 */ /* 88 */ /* 764 */ /* */
column "MAY_TAX" datatype FLOAT length 8 cardinality 12 /* 12 */ /* 130 */ /* 866 */ /* */
column "MAY_MGN" datatype FLOAT length 8 cardinality 13 /* 13 */ /* 135 */ /* 868 */ /* */
column "MAY_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAY_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 10 */ /* 274 */ /* */
column "MAY_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUN_TOTAL" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 109 */ /* 860 */ /* */
column "JUN_DISC" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 85 */ /* 761 */ /* */
column "JUN_TAX" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 116 */ /* 866 */ /* */
column "JUN_MGN" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 118 */ /* 865 */ /* */
column "JUN_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUN_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 9 */ /* 279 */ /* */
column "JUN_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUL_TOTAL" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 87 */ /* 839 */ /* */
column "JUL_DISC" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 61 */ /* 725 */ /* */
column "JUL_TAX" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 83 */ /* 867 */ /* */
column "JUL_MGN" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 90 */ /* 856 */ /* */
column "JUL_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 25 */ /* 101 */ /* */
column "JUL_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 4 */ /* 227 */ /* */
column "JUL_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 11 */ /* 98 */ /* */
column "AUG_TOTAL" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 74 */ /* 837 */ /* */
column "AUG_DISC" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 48 */ /* 705 */ /* */
column "AUG_TAX" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 73 */ /* 856 */ /* */
column "AUG_MGN" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 77 */ /* 848 */ /* */
column "AUG_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 17 */ /* 101 */ /* */
column "AUG_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 3 */ /* 222 */ /* */
column "AUG_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 12 */ /* 97 */ /* */
column "SEP_TOTAL" datatype FLOAT length 8 cardinality 13 /* 13 */ /* 75 */ /* 839 */ /* */
column "SEP_DISC" datatype FLOAT length 8 cardinality 13 /* 13 */ /* 49 */ /* 727 */ /* */
column "SEP_TAX" datatype FLOAT length 8 cardinality 13 /* 13 */ /* 76 */ /* 848 */ /* */
column "SEP_MGN" datatype FLOAT length 8 cardinality 13 /* 13 */ /* 78 */ /* 847 */ /* */
column "SEP_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 14 */ /* 101 */ /* */
column "SEP_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 3 */ /* 216 */ /* */
column "SEP_BO" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 10 */ /* 95 */ /* */
column "OCT_TOTAL" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 66 */ /* 834 */ /* */
column "OCT_DISC" datatype FLOAT length 8 cardinality 18 /* 18 */ /* 41 */ /* 705 */ /* */
column "OCT_TAX" datatype FLOAT length 8 cardinality 19 /* 19 */ /* 64 */ /* 861 */ /* */
column "OCT_MGN" datatype FLOAT length 8 cardinality 19 /* 19 */ /* 66 */ /* 853 */ /* */
column "OCT_OR" datatype FLOAT length 8 cardinality 19 /* 19 */ /* 11 */ /* 100 */ /* */
column "OCT_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 2 */ /* 208 */ /* */
column "OCT_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 87 */ /* */
column "NOV_TOTAL" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 64 */ /* 838 */ /* */
column "NOV_DISC" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 39 */ /* 722 */ /* */
column "NOV_TAX" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 66 */ /* 861 */ /* */
column "NOV_MGN" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 65 */ /* 861 */ /* */
column "NOV_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 13 */ /* 99 */ /* */
column "NOV_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 9 */ /* 202 */ /* */
column "NOV_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 5 */ /* 79 */ /* */
column "DEC_TOTAL" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 55 */ /* 835 */ /* */
column "DEC_DISC" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 36 */ /* 724 */ /* */
column "DEC_TAX" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 49 */ /* 860 */ /* */
column "DEC_MGN" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 55 */ /* 864 */ /* */
column "DEC_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 92 */ /* */
column "DEC_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 3 */ /* 212 */ /* */
column "DEC_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 53 */ /* */
column "TOTAL" datatype FLOAT length 8 cardinality 109 /* 109 */ /* 502 */ /* 899 */ /* */
column "DISCOUNT" datatype FLOAT length 8 cardinality 109 /* 109 */ /* 375 */ /* 898 */ /* */
column "SALES_TAX" datatype FLOAT length 8 cardinality 111 /* 111 */ /* 532 */ /* 900 */ /* */
column "MARGIN" datatype FLOAT length 8 cardinality 114 /* 114 */ /* 529 */ /* 900 */ /* */
column "ORDERED" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 54 */ /* 101 */ /* */
column "CANCELED" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 59 */ /* 777 */ /* */
column "BACKORDERED" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 32 */ /* 101 */ /* */
column "CASH" datatype FLOAT length 8 cardinality 17 /* 17 */ /* 139 */ /* 867 */ /* */
column "CHECKS" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 131 */ /* 865 */ /* */
column "ATM" datatype FLOAT length 8 cardinality 16 /* 16 */ /* 125 */ /* 871 */ /* */
column "VISA" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 113 */ /* 886 */ /* */
column "MC" datatype FLOAT length 8 cardinality 18 /* 18 */ /* 132 */ /* 868 */ /* */
column "AMEX" datatype FLOAT length 8 cardinality 26 /* 26 */ /* 134 */ /* 872 */ /* */
column "DISCOVER" datatype FLOAT length 8 cardinality 15 /* 15 */ /* 137 */ /* 861 */ /* */
column "DINERSCLUB" datatype FLOAT length 8 cardinality 23 /* 23 */ /* 120 */ /* 863 */ /* */
column "OTHERCC" datatype FLOAT length 8 cardinality 23 /* 23 */ /* 135 */ /* 865 */ /* */
column "PO" datatype FLOAT length 8 cardinality 19 /* 19 */ /* 42 */ /* 664 */ /* */
column "TELEPHONE" datatype FLOAT length 8 cardinality 21 /* 21 */ /* 121 */ /* 870 */ /* */
column "FAX" datatype FLOAT length 8 cardinality 11 /* 11 */ /* 77 */ /* 825 */ /* */
column "MAIL" datatype FLOAT length 8 cardinality 12 /* 12 */ /* 107 */ /* 849 */ /* */
column "INTERNET" datatype FLOAT length 8 cardinality 9 /* 9 */ /* 56 */ /* 772 */ /* */
column "CATALOGS" datatype FLOAT length 8 cardinality 33 /* 33 */ /* 226 */ /* 896 */ /* */
column "RETAIL" datatype FLOAT length 8 cardinality 66 /* 66 */ /* 343 */ /* 898 */ /* */
/* --------------------- TABLE: ORDERS_ROLLUP ------------------------------ */
table "ORDERS_ROLLUP"
physical "dat/orr.dat"
cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* 9 */
/* Rollup columns */
column "YR" datatype OMNIDEX DATE length 2 format YYYY cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "NUM_ORDERS" datatype INTEGER length 4 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JAN_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JAN_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JAN_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JAN_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JAN_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JAN_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JAN_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "FEB_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "FEB_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "FEB_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "FEB_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "FEB_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "FEB_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 5 */ /* 9 */ /* */
column "FEB_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAR_TOTAL" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAR_DISC" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAR_TAX" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAR_MGN" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAR_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAR_CN" datatype FLOAT length 8 cardinality 3 /* 3 */ /* 5 */ /* 9 */ /* */
column "MAR_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "APR_TOTAL" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "APR_DISC" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "APR_TAX" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "APR_MGN" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "APR_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "APR_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 4 */ /* 9 */ /* */
column "APR_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAY_TOTAL" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAY_DISC" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAY_TAX" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAY_MGN" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MAY_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "MAY_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 5 */ /* 9 */ /* */
column "MAY_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUN_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JUN_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JUN_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JUN_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "JUN_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUN_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 6 */ /* 9 */ /* */
column "JUN_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "JUL_TOTAL" datatype FLOAT length 8 cardinality 4 /* 4 */ /* 9 */ /* 9 */ /* */
column "JUL_DISC" datatype FLOAT length 8 cardinality 4 /* 4 */ /* 9 */ /* 9 */ /* */
column "JUL_TAX" datatype FLOAT length 8 cardinality 4 /* 4 */ /* 9 */ /* 9 */ /* */
column "JUL_MGN" datatype FLOAT length 8 cardinality 4 /* 4 */ /* 9 */ /* 9 */ /* */
column "JUL_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "JUL_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 4 */ /* 9 */ /* */
column "JUL_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "AUG_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "AUG_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "AUG_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "AUG_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "AUG_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "AUG_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 3 */ /* 9 */ /* */
column "AUG_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "SEP_TOTAL" datatype FLOAT length 8 cardinality 5 /* 5 */ /* 9 */ /* 9 */ /* */
column "SEP_DISC" datatype FLOAT length 8 cardinality 5 /* 5 */ /* 9 */ /* 9 */ /* */
column "SEP_TAX" datatype FLOAT length 8 cardinality 5 /* 5 */ /* 9 */ /* 9 */ /* */
column "SEP_MGN" datatype FLOAT length 8 cardinality 5 /* 5 */ /* 9 */ /* 9 */ /* */
column "SEP_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "SEP_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 3 */ /* 9 */ /* */
column "SEP_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "OCT_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "OCT_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "OCT_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "OCT_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "OCT_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "OCT_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 2 */ /* 9 */ /* */
column "OCT_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "NOV_TOTAL" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "NOV_DISC" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "NOV_TAX" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "NOV_MGN" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "NOV_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "NOV_CN" datatype FLOAT length 8 cardinality 2 /* 2 */ /* 6 */ /* 9 */ /* */
column "NOV_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "DEC_TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "DEC_DISC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 8 */ /* 9 */ /* */
column "DEC_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "DEC_MGN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "DEC_OR" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "DEC_CN" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 3 */ /* 9 */ /* */
column "DEC_BO" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 1 */ /* 2 */ /* */
column "TOTAL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "DISCOUNT" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "SALES_TAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "MARGIN" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "ORDERED" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "CANCELED" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "BACKORDERED" datatype FLOAT length 8 cardinality 1 /* 1 */ /* 2 */ /* 2 */ /* */
column "CASH" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "CHECKS" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "ATM" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "VISA" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "MC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "AMEX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "DISCOVER" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "DINERSCLUB" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "OTHERCC" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "PO" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "TELEPHONE" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "FAX" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "MAIL" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "INTERNET" datatype FLOAT length 8 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* */
column "CATALOGS" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "RETAIL" datatype FLOAT length 8 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
/* --------------------- TABLE: ORDERS_SVW --------------------------------- */
table "ORDERS_SVW"
physical "dat/osv.dat"
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 /* 3 */ /* 100 */ /* 10000 */ /* */
column "STATE" datatype CHARACTER length 2 cardinality 3 /* 3 */ /* 29 */ /* 51 */ /* */
column "ZIP" datatype C STRING length 10 cardinality 3 /* 3 */ /* 97 */ /* 2395 */ /* */
column "REGION" datatype CHARACTER length 2 cardinality 1 /* 1 */ /* 6 */ /* 6 */ /* */
column "COUNTRY" datatype CHARACTER length 2 cardinality 1 /* 1 */ /* 1 */ /* 1 */ /* */
column "GENDER" datatype CHARACTER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* */
column "MAILFLAG" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 4 */ /* 4 */ /* */
column "MAILING" datatype INTEGER length 1 cardinality 1 /* 1 */ /* 8 */ /* 8 */ /* */
column "PROFESSION" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 10 */ /* 10 */ /* */
column "INCOME" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 15 */ /* 15 */ /* */
column "PROFILE" datatype INTEGER length 1 cardinality 1 /* 1 */ /* 6 */ /* 6 */ /* */
column "PREFERRED" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* */
column "FRQ_BUY_MBR" datatype INTEGER length 1 cardinality 2 /* 2 */ /* 2 */ /* 2 */ /* */
column "CR_LIMIT" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 14 */ /* 14 */ /* */
column "DISCOUNT_RT" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 5 */ /* 5 */ /* */
column "CUST_SINCE" datatype OMNIDEX DATE length 2 format YYYY cardinality 3 /* 3 */ /* 9 */ /* 9 */ /* */
column "LAST_ORDER" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 3 /* 3 */ /* 94 */ /* 1720 */ /* */
column "PRODUCT_NO" datatype CHARACTER length 4 cardinality 63 /* 63 */ /* 100 */ /* 100 */ /* */
column "DIVISION" datatype INTEGER length 1 cardinality 5 /* 5 */ /* 5 */ /* 5 */ /* */
column "DEPT" datatype INTEGER length 1 cardinality 9 /* 9 */ /* 10 */ /* 10 */ /* */
column "CATEGORY" datatype INTEGER length 1 cardinality 26 /* 26 */ /* 30 */ /* 30 */ /* */
column "MFR" datatype INTEGER length 1 cardinality 31 /* 31 */ /* 40 */ /* 40 */ /* */
column "ORDER_DATE" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 68 /* 68 */ /* 200 */ /* 1774 */ /* */
column "OR_YR" datatype OMNIDEX DATE length 2 format YYYY cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */
column "OR_MO" datatype OMNIDEX DATE length 1 format MM cardinality 12 /* 12 */ /* 12 */ /* 12 */ /* */
column "OR_DY_OF_MO" datatype OMNIDEX DATE length 1 format DD cardinality 3 /* 3 */ /* 30 */ /* 31 */ /* */
column "OR_DY_OF_YR" datatype INTEGER length 2 cardinality 22 /* 22 */ /* 107 */ /* 366 */ /* */
column "OR_DY_OF_WK" datatype INTEGER length 1 cardinality 7 /* 7 */ /* 7 */ /* 7 */ /* */
column "OR_WK" datatype INTEGER length 1 cardinality 23 /* 23 */ /* 49 */ /* 53 */ /* */
column "OR_QTR" datatype INTEGER length 1 cardinality 4 /* 4 */ /* 4 */ /* 4 */ /* */
column "OR_FQTR" datatype INTEGER length 1 cardinality 4 /* 4 */ /* 4 */ /* 4 */ /* */
column "OR_FYR" datatype OMNIDEX DATE length 2 format YYYY cardinality 8 /* 8 */ /* 10 */ /* 10 */ /* */
column "STATUS" datatype CHARACTER length 2 cardinality 2 /* 2 */ /* 4 */ /* 4 */ /* */
column "TAX_STATE" datatype CHARACTER length 2 cardinality 3 /* 3 */ /* 29 */ /* 51 */ /* */
column "SOURCE" datatype INTEGER length 1 cardinality 6 /* 6 */ /* 6 */ /* 6 */ /* */
column "PMT_METHOD" datatype INTEGER length 1 cardinality 10 /* 10 */ /* 10 */ /* 10 */ /* */
column "DISCOUNT" datatype INTEGER length 1 cardinality 3 /* 3 */ /* 5 */ /* 5 */ /* */
column "QUANTITY" datatype INTEGER length 1 cardinality 20 /* 20 */ /* 20 */ /* 21 */ /* */
column "SALES_TAX" datatype FLOAT length 4 cardinality 111 /* 111 */ /* 742 */ /* 8003 */ /* */
column "AMOUNT" datatype FLOAT length 4 cardinality 64 /* 64 */ /* 217 */ /* 262 */ /* */
column "TOTAL" datatype FLOAT length 4 cardinality 110 /* 110 */ /* 553 */ /* 2412 */ /* */