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" as "select * from ORDERS01 union all select * from ORDERS02 union all select * from ORDERS03" 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 "ORDERS01" physical "dat/ord01.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") partition by "TAX_STATE IN ('AK','AZ','CT','FL','GU','ID','KS','MA','MH','MO','MT','NE','NM','OH','PA','RI','TN','VA','WI')" columns from "ORDERS" table "ORDERS02" physical "dat/ord02.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") partition by "TAX_STATE IN ('AL','CA','DC','FM','HI','IL','KY','MD','MI','MP','NC','NH','NV','OK','PR','SC','TX','VT','WV')" columns from "ORDERS" table "ORDERS03" physical "dat/ord03.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") /* No partition clause on purpose to force this partition to always be checked */ columns from "ORDERS" /* --------------------- 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 */ /* */