environment "star_env" set wildcards *, ?, # /* ===================== DATABASE: STAR ==================================== */ database "star" type oracle version "{$ORAVER}" userclass "DEFAULT" user "{star$(basename $PWD)}" password "{star$(basename $PWD)}" indexprefix "idx/STAR" /* --------------------- TABLE: DIVISIONS ---------------------------------- */ 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 -------------------------------------- */ 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 --------------------------------- */ 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 --------------------------------------- */ 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 ----------------------------------- */ 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 ------------------------------------ */ 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 ----------------------------------- */ 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 --------------------------------- */ 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 ------------------------------------ */ 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 ----------------------------------- */ 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 ---------------------------------- */ 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 ------------------------------------ */ 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 ---------------------------------- */ 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 ----------------------------------- */ 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 ------------------------------------ */ 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 -------------------------------- */ 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 ----------------------------------- */ 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 -------------------------------------- */ 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 ---------------------------------- */ table "PROSPECTS" 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 INTEGER length 2 cardinality 6 /* 6 */ /* 9 */ /* 9 */ /* 9 */ column "LAST_ORDER" datatype ORACLE DATETIME length 7 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" 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" 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" 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 ORACLE DATETIME length 7 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 */ column "REDEF_ROWID" datatype INTEGER length 4 usage ASCENDING AUTO ROWID /* --------------------- TABLE: STATUSES ----------------------------------- */ 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 -------------------------------- */ 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 ------------------------------------ */ 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 ------------------------------------- */ 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 /* 3 */ /* 100 */ /* 10000 */ /* 1000000 */ column "PRODUCT_NO" datatype CHARACTER length 4 cardinality 63 /* 63 */ /* 100 */ /* 100 */ /* 100 */ column "ORDER_DATE" datatype ORACLE DATETIME length 7 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" 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 INTEGER length 2 cardinality 3 /* 3 */ /* 9 */ /* 9 */ /* */ column "LAST_ORDER" datatype ORACLE DATETIME length 7 cardinality 3 /* 3 */ /* 94 */ /* 1720 */ /* */ column "SEARCH_KEY" datatype CHARACTER length 12 cardinality 3 /* Rollup columns */ column "YR" datatype INTEGER length 2 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" 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 INTEGER length 2 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" cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* 9 */ /* Rollup columns */ column "YR" datatype INTEGER length 2 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" 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 INTEGER length 2 cardinality 3 /* 3 */ /* 9 */ /* 9 */ /* */ column "LAST_ORDER" datatype ORACLE DATETIME length 7 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 ORACLE DATETIME length 7 cardinality 68 /* 68 */ /* 200 */ /* 1774 */ /* */ column "OR_YR" datatype INTEGER length 2 cardinality 7 /* 7 */ /* 9 */ /* 9 */ /* */ column "OR_MO" datatype CHARACTER length 3 cardinality 12 /* 12 */ /* 12 */ /* 12 */ /* */ column "OR_DY_OF_MO" datatype INTEGER length 1 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 INTEGER length 2 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 */ /* */ /* primary key indexes */ 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" /* no foreign key indexes - FK constraints are not indexes */