environment  "star_env"


/* ===================== DATABASE: STAR ==================================== */

database       "star"
  type         flatfile
  indexprefix  "idx/STAR"


/* --------------------- TABLE: DIVISIONS ---------------------------------- */

table          "DIVISIONS"
  physical     "dat/div.dat"
  primary      "DIVISION"
  cardinality  5

column "DIVISION"        datatype TINYINT                     cardinality 5
column "DESCRIPTION"     datatype C STRING(31)                cardinality 5


/* --------------------- TABLE: DEPTS -------------------------------------- */

table          "DEPTS"
  physical     "dat/dpt.dat"
  primary      "DIVISION","DEPT"
  foreign      "DIVISION"         references "DIVISIONS"("DIVISION")
  cardinality  10

column "DIVISION"        datatype TINYINT                     cardinality 5
column "DEPT"            datatype SMALLINT                    cardinality 10
column "DESCRIPTION"     datatype C STRING(31)                cardinality 10


/* --------------------- TABLE: CATEGORIES --------------------------------- */

table          "CATEGORIES"
  physical     "dat/cat.dat"
  primary      "DIVISION","DEPT","CATEGORY"
  foreign      "DIVISION","DEPT"  references "DEPTS"("DIVISION","DEPT")
  cardinality  30

column "DIVISION"        datatype TINYINT                     cardinality 5
column "DEPT"            datatype SMALLINT                    cardinality 10
column "CATEGORY"        datatype INTEGER                     cardinality 30
column "DESCRIPTION"     datatype C STRING(31)                cardinality 30


/* --------------------- TABLE: MFRS --------------------------------------- */

table          "MFRS"
  physical     "dat/mfr.dat"
  primary      "MFR"
  cardinality  40

column "MFR"             datatype TINYINT                     cardinality 40
column "DESCRIPTION"     datatype C STRING(31)                cardinality 40


/* --------------------- TABLE: PRODUCTS ----------------------------------- */

table          "PRODUCTS"
  physical     "dat/prd.dat"
  primary      "PRODUCT_NO"
  foreign      "DIVISION","DEPT","CATEGORY"        
      references "CATEGORIES"("DIVISION","DEPT","CATEGORY")
  foreign      "MFR"              references "MFRS"("MFR")
  cardinality  100

column "PRODUCT_NO"      datatype CHARACTER(4)                cardinality 100
column "DESCRIPTION"     datatype C STRING(31)                cardinality 95
column "DIVISION"        datatype TINYINT                     cardinality 5
column "DEPT"            datatype SMALLINT                    cardinality 10
column "CATEGORY"        datatype INTEGER                     cardinality 30
column "MFR"             datatype TINYINT                     cardinality 40
column "MARGIN"          datatype FLOAT                       cardinality 4
column "WHOLESALE"       datatype FLOAT                       cardinality 64
column "COST"            datatype FLOAT                       cardinality 57
column "DISCOUNT_RT"     datatype FLOAT                       cardinality 45
        as "WHOLESALE * 100.0 / COST"


/* --------------------- TABLE: COUNTRIES  --------------------------------- */

table          "COUNTRIES"
  physical     "dat/cnt.dat"
  primary      "COUNTRY"
  cardinality  239

column "COUNTRY"         datatype CHARACTER(2)                cardinality 239
column "DESCRIPTION"     datatype C STRING(47)                cardinality 239
column "LATITUDE"        datatype FLOAT                       cardinality 168
column "LONGITUDE"       datatype FLOAT                       cardinality 188
column "CAPITAL"         datatype C STRING(31)                cardinality 217
column "CAPITAL_LAT"     datatype FLOAT                       cardinality 216
column "CAPITAL_LONG"    datatype FLOAT                       cardinality 215


/* --------------------- TABLE: REGIONS ------------------------------------ */

table          "REGIONS"
  physical     "dat/reg.dat"
  primary      "REGION"
  cardinality  7

column "REGION"          datatype CHARACTER(2)                cardinality 7
column "DESCRIPTION"     datatype C STRING(31)                cardinality 7


/* --------------------- TABLE: STATES  ------------------------------------ */

table          "STATES"
  physical     "dat/sta.dat"
  primary      "STATE"
  foreign      "REGION"           references "REGIONS"("REGION")
  foreign      "COUNTRY"          references "COUNTRIES"("COUNTRY")
  cardinality  73

column "STATE"           datatype CHARACTER(2)                cardinality 73
column "DESCRIPTION"     datatype C STRING(31)                cardinality 73
column "STATE_CODE"      datatype CHARACTER(2)                cardinality 53
column "REGION"          datatype CHARACTER(2)                cardinality 7
column "COUNTRY"         datatype CHARACTER(2)                cardinality 2
column "TAX_RATE"        datatype FLOAT                       cardinality 15


/* --------------------- TABLE: COUNTIES ----------------------------------- */

table          "COUNTIES"
  physical     "dat/cty.dat"
  primary      "STATE","COUNTY_CODE"
  foreign      "STATE"            references "STATES"("STATE")
  foreign      "REGION"           references "REGIONS"("REGION")
  foreign      "COUNTRY"          references "COUNTRIES"("COUNTRY")
  cardinality  3228

column "COUNTRY"         datatype CHARACTER(2)                cardinality 1
column "STATE"           datatype CHARACTER(2)                cardinality 57
column "STATE_CODE"      datatype CHARACTER(2)                cardinality 53
column "COUNTY_CODE"     datatype CHARACTER(3)                cardinality 328
column "COUNTY"          datatype C STRING(31)                cardinality 1930
column "REGION"          datatype CHARACTER(2)                cardinality 7
column "ACTIVE"          datatype CHARACTER(1)                cardinality 2
column "ELEVATION"       datatype SMALLINT                    cardinality 1730
column "SQ_MILES"        datatype INTEGER                     cardinality 1403


/* --------------------- TABLE: COUNTRY_CENSUS ----------------------------- */

table          "COUNTRY_CENSUS"
  physical     "dat/cnc.dat"
  primary      "COUNTRY","YR"
  foreign      "COUNTRY"          references "COUNTRIES"("COUNTRY")
  cardinality  4

column "COUNTRY"         datatype CHARACTER(2)                cardinality 2
column "YR"              datatype SMALLINT                    cardinality 4
column "POPULATION"      datatype BIGINT                      cardinality 4
column "MALE"            datatype BIGINT                      cardinality 3
column "FEMALE"          datatype BIGINT                      cardinality 3
column "AGE_UNDER_5"     datatype BIGINT                      cardinality 3
column "AGE_5_24"        datatype BIGINT                      cardinality 3
column "AGE_25_44"       datatype BIGINT                      cardinality 3
column "AGE_45_54"       datatype BIGINT                      cardinality 3
column "AGE_55_59"       datatype BIGINT                      cardinality 3
column "AGE_60_64"       datatype BIGINT                      cardinality 3
column "AGE_65_74"       datatype BIGINT                      cardinality 3
column "AGE_75_84"       datatype BIGINT                      cardinality 3
column "AGE_85_OVER"     datatype BIGINT                      cardinality 3
column "AGE_18_OVER"     datatype BIGINT                      cardinality 3
column "AGE_65_OVER"     datatype BIGINT                      cardinality 3
column "HOUSEHOLDS"      datatype BIGINT                      cardinality 3
column "HSHD_FAMILY"     datatype BIGINT                      cardinality 3
column "HSHD_MARRIED"    datatype BIGINT                      cardinality 3
column "HSHD_FEMALE"     datatype BIGINT                      cardinality 3
column "HSHD_NON_FAMILY" datatype BIGINT                      cardinality 3
column "HSHD_ALONE"      datatype BIGINT                      cardinality 3
column "HSHD_AVG_SIZE"   datatype FLOAT                       cardinality 4
column "FAMILY_AVG_SIZE" datatype FLOAT                       cardinality 2
column "YR_C"            datatype CHARACTER(4)                cardinality 2
        as "cast(YR as CHAR(4))"


/* --------------------- TABLE: STATE_CENSUS ------------------------------- */

table          "STATE_CENSUS"
  physical     "dat/stc.dat"
  primary      "STATE","YR"
  foreign      "STATE"            references "STATES"("STATE")
  foreign      "COUNTRY"          references "COUNTRIES"("COUNTRY")
  cardinality  129

column "COUNTRY"         datatype CHARACTER(2)                cardinality 2
column "STATE"           datatype CHARACTER(2)                cardinality 65
column "STATE_CODE"      datatype CHARACTER(2)                cardinality 53
column "YR"              datatype SMALLINT                    cardinality 4
column "POPULATION"      datatype BIGINT                      cardinality 129
column "MALE"            datatype BIGINT                      cardinality 104
column "FEMALE"          datatype BIGINT                      cardinality 104
column "AGE_UNDER_5"     datatype BIGINT                      cardinality 104
column "AGE_5_24"        datatype BIGINT                      cardinality 104
column "AGE_25_44"       datatype BIGINT                      cardinality 104
column "AGE_45_54"       datatype BIGINT                      cardinality 104
column "AGE_55_59"       datatype BIGINT                      cardinality 104
column "AGE_60_64"       datatype BIGINT                      cardinality 104
column "AGE_65_74"       datatype BIGINT                      cardinality 104
column "AGE_75_84"       datatype BIGINT                      cardinality 104
column "AGE_85_OVER"     datatype BIGINT                      cardinality 104
column "AGE_18_OVER"     datatype BIGINT                      cardinality 104
column "AGE_65_OVER"     datatype BIGINT                      cardinality 104
column "HOUSEHOLDS"      datatype BIGINT                      cardinality 104
column "HSHD_FAMILY"     datatype BIGINT                      cardinality 104
column "HSHD_MARRIED"    datatype BIGINT                      cardinality 104
column "HSHD_FEMALE"     datatype BIGINT                      cardinality 104
column "HSHD_NON_FAMILY" datatype BIGINT                      cardinality 104
column "HSHD_ALONE"      datatype BIGINT                      cardinality 104
column "HSHD_AVG_SIZE"   datatype FLOAT                       cardinality 111
column "FAMILY_AVG_SIZE" datatype FLOAT                       cardinality 53
column "YR_C"            datatype CHARACTER(4)                cardinality 2
        as "cast(YR as CHAR(4))"
column "AGE_25_54"       datatype BIGINT                      cardinality 104
        as "AGE_25_44 + AGE_45_54"
column "CHAR_HOUSEHOLDS" datatype CHARACTER(8)                cardinality 104
        as "cast(HOUSEHOLDS as char(8))"
column "STATE_SCODE_YR2" datatype CHARACTER(8)                cardinality 129
        as "STATE || STATE_CODE || cast(YR as CHAR(4))" 


/* --------------------- TABLE: COUNTY_CENSUS ------------------------------ */

table          "COUNTY_CENSUS"
  physical     "dat/ctc.dat"
  primary      "STATE","COUNTY_CODE","YR"
  foreign      "STATE","COUNTY_CODE"
                                  references "COUNTIES"("STATE","COUNTY_CODE")
  foreign      "STATE"            references "STATES"("STATE")
  foreign      "COUNTRY"          references "COUNTRIES"("COUNTRY")
  cardinality  6360

column "COUNTRY"         datatype CHARACTER(2)                cardinality 1
column "STATE"           datatype CHARACTER(2)                cardinality 52
column "STATE_CODE"      datatype CHARACTER(2)                cardinality 52
column "COUNTY_CODE"     datatype CHARACTER(3)                cardinality 326
column "YR"              datatype SMALLINT                    cardinality 2
column "POPULATION"      datatype INTEGER                     cardinality 6085
column "MALE"            datatype INTEGER                     cardinality 5862
column "FEMALE"          datatype INTEGER                     cardinality 5880
column "AGE_UNDER_5"     datatype INTEGER                     cardinality 3987
column "AGE_5_24"        datatype INTEGER                     cardinality 5541
column "AGE_25_44"       datatype INTEGER                     cardinality 5494
column "AGE_45_54"       datatype INTEGER                     cardinality 4701
column "AGE_55_59"       datatype INTEGER                     cardinality 3478
column "AGE_60_64"       datatype INTEGER                     cardinality 3352
column "AGE_65_74"       datatype INTEGER                     cardinality 4067
column "AGE_75_84"       datatype INTEGER                     cardinality 3393
column "AGE_85_OVER"     datatype INTEGER                     cardinality 2012
column "AGE_18_OVER"     datatype INTEGER                     cardinality 6014
column "AGE_65_OVER"     datatype INTEGER                     cardinality 4864
column "HOUSEHOLDS"      datatype INTEGER                     cardinality 5713
column "HSHD_FAMILY"     datatype INTEGER                     cardinality 5482
column "HSHD_MARRIED"    datatype INTEGER                     cardinality 5302
column "HSHD_FEMALE"     datatype INTEGER                     cardinality 3225
column "HSHD_NON_FAMILY" datatype INTEGER                     cardinality 4486
column "HSHD_ALONE"      datatype INTEGER                     cardinality 4261
column "HSHD_AVG_SIZE"   datatype FLOAT                       cardinality 173
column "FAMILY_AVG_SIZE" datatype FLOAT                       cardinality 139
column "YR_C"            datatype CHARACTER(4)                cardinality 2
        as "cast(YR as CHAR(4))"


/* --------------------- TABLE: ZIPCODES ----------------------------------- */

table          "ZIPCODES"
  physical     "dat/zip.dat"
  primary      "ZIP"
  foreign      "STATE","COUNTY_CODE"
                                  references "COUNTIES"("STATE","COUNTY_CODE")
  foreign      "STATE"            references "STATES"("STATE")
  foreign      "REGION"           references "REGIONS"("REGION")
  foreign      "COUNTRY"          references "COUNTRIES"("COUNTRY")
  cardinality  42192

column "ZIP"             datatype C STRING(9)                 cardinality 42192
column "CITY"            datatype C STRING(25)                cardinality 18941
column "COUNTY_CODE"     datatype CHARACTER(3)                cardinality 327
column "STATE"           datatype CHARACTER(2)                cardinality 57
column "REGION"          datatype CHARACTER(2)                cardinality 6
column "COUNTRY"         datatype CHARACTER(2)                cardinality 1
column "LATITUDE"        datatype CHARACTER(7)                cardinality 33080
column "LONGITUDE"       datatype CHARACTER(8)                cardinality 35490
column "TYPE"            datatype CHARACTER(2)                cardinality 3
column "AREACODES"       datatype CHARACTER(15)               cardinality 289
column "TIME_ZONE"       datatype TINYINT                     cardinality 12


/* --------------------- TABLE: AREACODES ---------------------------------- */

table          "AREACODES"
  physical     "dat/arc.dat"
  primary      "AREACODE"
  cardinality  800

column "AREACODE"        datatype CHARACTER(3)                cardinality 800
column "TYPE"            datatype C STRING(7)                 cardinality 2
column "TYPE_DESC"       datatype C STRING(31)                cardinality 2
column "ASSIGNABLE"      datatype CHARACTER(1)                cardinality 2
column "EXPLANATION"     datatype C STRING(31)                cardinality 9
column "RESERVED"        datatype CHARACTER(1)                cardinality 2
column "ASSIGNED"        datatype CHARACTER(1)                cardinality 2
column "ASSIGN_DATE"     datatype ASCII DATE                  cardinality 81
column "GEOGRAPHIC"      datatype CHARACTER(1)                cardinality 3
column "SERVICE"         datatype C STRING(39)                cardinality 11
column "STATES"          datatype CHARACTER(10)               cardinality 64
column "LOCATION"        datatype C STRING(31)                cardinality 87
column "COUNTRY"         datatype CHARACTER(2)                cardinality 20
column "AREA_SERVED"     datatype C STRING(511)               cardinality 197
column "IN_SERVICE"      datatype CHARACTER(1)                cardinality 2
column "IN_SERVICE_DATE" datatype ASCII DATE                  cardinality 173
column "OVERLAY"         datatype CHARACTER(1)                cardinality 3
column "OVERLAY_COMPLEX" datatype CHARACTER(20)               cardinality 57
column "PARENT"          datatype CHARACTER(32)               cardinality 121
column "TIME_ZONE1"      datatype CHARACTER(1)                cardinality 8
column "TIME_ZONE2"      datatype CHARACTER(1)                cardinality 5


/* --------------------- TABLE: COMPANY_TYPES ------------------------------ */

table          "COMPANY_TYPES"
  physical     "dat/ctp.dat"
  primary      "COMPANY_TYPE"
  cardinality  21

column "COMPANY_TYPE"    datatype TINYINT                     cardinality 21
column "DESCRIPTION"     datatype CHAR(40)                    cardinality 21

/* --------------------- TABLE: INDUSTRIES --------------------------------- */

table          "INDUSTRIES"
  physical     "dat/ind.dat"
  primary      "INDUSTRY"
  cardinality  620

column "INDUSTRY"        datatype SMALLINT                    cardinality 620
column "DESCRIPTION"     datatype C STRING(79)                cardinality 620

 
/* --------------------- TABLE: COMPANIES ---------------------------------- */

table          "COMPANIES"
  physical     "dat/cmp.dat"
  primary      "COMPANY_ID"
  foreign      "STATE"            references "STATES"("STATE")
  foreign      "ZIP"              references "ZIPCODES"("ZIP")
  foreign      "COUNTRY"          references "COUNTRIES"("COUNTRY")
  foreign      "COMPANY_TYPE"     references "COMPANY_TYPES"("COMPANY_TYPE")
  foreign      "INDUSTRY"         references "INDUSTRIES"("INDUSTRY")
  cardinality  31548

column "COMPANY_ID"      datatype INTEGER                     cardinality 31548
column "COMPANY"         datatype C STRING(59)                cardinality 31548
column "FIRST_NAME"      datatype CHAR(16)                    cardinality 3839
column "MIDDLE_NAME"     datatype CHAR(16)                    cardinality 414
column "LAST_NAME"       datatype CHAR(20)                    cardinality 17011
column "SUFFIX"          datatype CHAR(4)                     cardinality 7
column "TITLE"           datatype C STRING(79)                cardinality 1521
column "DUNS_NUMBER"     datatype CHAR(9)                     cardinality 30638
column "ADDRESS1"        datatype C STRING(59)                cardinality 28186
column "ADDRESS2"        datatype C STRING(59)                cardinality 2295
column "CITY"            datatype C STRING(25)                cardinality 3765
column "STATE"           datatype CHARACTER(2)                cardinality 52
column "ZIP"             datatype C STRING(9)                 cardinality 8081
column "COUNTRY"         datatype CHARACTER(2)                cardinality 1
column "PHONE"           datatype CHAR(12)                    cardinality 30588
column "FAX"             datatype CHAR(12)                    cardinality 29738
column "COMPANY_TYPE"    datatype TINYINT                     cardinality 21
column "US_SYMBOL"       datatype CHAR(8)                     cardinality 6890
column "INTL_SYMBOL"     datatype CHAR(10)                    cardinality 61
column "US_EXCHANGE"     datatype CHAR(16)                    cardinality 7
column "INTL_EXCHANGE"   datatype CHAR(20)                    cardinality 12
column "NUM_EMPLOYEES"   datatype INTEGER                     cardinality 3033
column "REVENUE"         datatype FLOAT                       cardinality 7721
column "MARKET_VALUE"    datatype FLOAT                       cardinality 4832
column "INDUSTRY"        datatype SMALLINT                    cardinality 620
column "WEB_ADDRESS"     datatype C STRING(79)                cardinality 29980
    
column "PH_ZP2"          datatype C STRING(18)                cardinality 30792
        as "substring(PHONE from 5 for 8) || ZIP"
column "PHONE2"          datatype C STRING(8)                 cardinality 28523
        as "substring(PHONE from 5 for 8)"
column "ST_ZP_CNTRY2"    datatype C STRING(13)                cardinality 8089
        as "STATE || ZIP || COUNTRY"
column "CTY_ST"          datatype C STRING(27)                cardinality 4625
        as "CITY || STATE"
column "CTY5_ST"         datatype C STRING(7)                 cardinality 4188
        as "substring(CITY from 1 for 5) || STATE"

 
/* --------------------- TABLE: SIC_CODES ---------------------------------- */

table          "SIC_CODES"
  physical     "dat/sic.dat"
  primary      "SIC_CODE"
  cardinality  1086

column "SIC_CODE"        datatype CHAR(4)                     cardinality 1086
column "DESCRIPTION"     datatype C STRING(119)               cardinality 1084


/* --------------------- TABLE: NAICS_CODES -------------------------------- */

table          "NAICS_CODES"
  physical     "dat/ncs.dat"
  primary      "NAICS_CODE"
  cardinality  2341

column "NAICS_CODE"      datatype CHAR(6)                     cardinality 2341
column "DESCRIPTION"     datatype C STRING(119)               cardinality 1658


/* --------------------- TABLE: SIC_NAICS ---------------------------------- */

table          "SIC_NAICS"
  physical     "dat/snx.dat"
  foreign      "SIC_CODE"         references "SIC_CODES"("SIC_CODE")
  foreign      "NAICS_CODE"       references "NAICS_CODES"("NAICS_CODE")
  cardinality  2164

column "SIC_CODE"        datatype CHAR(4)                     cardinality 1004
column "NAICS_CODE"      datatype CHAR(6)                     cardinality 1176


/* --------------------- TABLE: COMPANY_SICS ------------------------------- */

table          "COMPANY_SICS"
  physical     "dat/csc.dat"
  foreign      "COMPANY_ID"       references "COMPANIES"("COMPANY_ID")
  foreign      "SIC_CODE"         references "SIC_CODES"("SIC_CODE")
  cardinality  110177

column "COMPANY_ID"      datatype INTEGER                     cardinality 33841
column "SIC_CODE"        datatype CHAR(4)                     cardinality 1020


/* --------------------- TABLE: COMPANY_NAICS ------------------------------ */

table          "COMPANY_NAICS"
  physical     "dat/cns.dat"
  foreign      "COMPANY_ID"       references "COMPANIES"("COMPANY_ID")
  foreign      "NAICS_CODE"       references "NAICS_CODES"("NAICS_CODE")
  cardinality  112854

column "COMPANY_ID"      datatype INTEGER                     cardinality 33841
column "NAICS_CODE"      datatype CHAR(6)                     cardinality 1476


/* --------------------- TABLE: GENDERS ------------------------------------ */

table          "GENDERS"
  physical     "dat/gdr.dat"
  primary      "GENDER"
  cardinality  2

column "GENDER"          datatype CHARACTER(1)                cardinality 2
column "DESCRIPTION"     datatype C STRING(31)                cardinality 2


/* --------------------- TABLE: MAILFLAGS ---------------------------------- */

table          "MAILFLAGS"
  physical     "dat/mlf.dat"
  primary      "MAILFLAG"
  cardinality  4

column "MAILFLAG"        datatype CHARACTER(1)                cardinality 4
column "DESCRIPTION"     datatype C STRING(31)                cardinality 4


/* --------------------- TABLE: MAILINGS ----------------------------------- */

table          "MAILINGS"
  physical     "dat/mal.dat"
  primary      "MAILING"
  cardinality  8

column "MAILING"         datatype CHARACTER(1)                cardinality 8
column "DESCRIPTION"     datatype C STRING(31)                cardinality 8


/* --------------------- TABLE: INCOMES ------------------------------------ */

table          "INCOMES"
  physical     "dat/inc.dat"
  primary      "INCOME"
  cardinality  16

column "INCOME"          datatype TINYINT                     cardinality 16
column "DESCRIPTION"     datatype C STRING(31)                cardinality 16


/* --------------------- TABLE: PROFESSIONS -------------------------------- */

table          "PROFESSIONS"
  physical     "dat/prf.dat"
  primary      "PROFESSION"
  cardinality  10

column "PROFESSION"      datatype TINYINT                     cardinality 10
column "DESCRIPTION"     datatype C STRING(31)                cardinality 10


/* --------------------- TABLE: PROFILES ----------------------------------- */

table          "PROFILES"
  physical     "dat/pfl.dat"
  primary      "PROFILE"
  cardinality  6

column "PROFILE"         datatype CHARACTER(1)                cardinality 6
column "DESCRIPTION"     datatype C STRING(31)                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(8) format YYYYMMDD cardinality 4383
column "YR"          datatype OMNIDEX DATE(4) format YYYY     cardinality 12
column "MO"          datatype OMNIDEX DATE(2) format MM       cardinality 12
column "DY_OF_MO"    datatype OMNIDEX DATE(2) format DD       cardinality 31
column "DY_OF_YR"    datatype SMALLINT                        cardinality 366
column "DY_OF_WK"    datatype TINYINT                         cardinality 7
column "WK"          datatype TINYINT                         cardinality 54
column "QTR"         datatype TINYINT                         cardinality 4
column "FQTR"        datatype TINYINT                         cardinality 4
column "FYR"         datatype OMNIDEX DATE(4) format YYYY     cardinality 13
column "DESCRIPTION" datatype C STRING(31)                    cardinality 4383


/* --------------------- TABLE: PROSPECTS ---------------------------------- */

table          "PROSPECTS"
  physical     "dat/pro.dat"
  primary      "ACCT"
  foreign      "COMPANY_ID"       references "COMPANIES"("COMPANY_ID")
  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      "LAST_ORDER"       references "DATES"("DT")
  cardinality  10  

column "ACCT"            datatype INTEGER                     cardinality 10 
column "COMPANY_ID"      datatype INTEGER                     cardinality 10 
column "COMPANY"         datatype C STRING(59)                cardinality 10 
column "CONTACT"         datatype C STRING(23)                cardinality 10 
column "CITY"            datatype C STRING(25)                cardinality 10 
column "STATE"           datatype CHARACTER(2)                cardinality 9  
column "ZIP"             datatype C STRING(9)                 cardinality 10 
column "REGION"          datatype CHARACTER(2)                cardinality 3  
column "COUNTRY"         datatype CHARACTER(2)                cardinality 1  
column "PHONE"           datatype C STRING(15)                cardinality 9
column "GENDER"          datatype CHARACTER(1)                cardinality 2  
column "MAILFLAG"        datatype CHARACTER(1)                cardinality 2  
column "MAILING"         datatype CHARACTER(1)                cardinality 1  
column "PROFESSION"      datatype TINYINT                     cardinality 9  
column "INCOME"          datatype TINYINT                     cardinality 6  
column "PROFILE"         datatype CHARACTER(1)                cardinality 4  
column "PREFERRED"       datatype CHARACTER(1)                cardinality 2  
column "FRQ_BUY_MBR"     datatype CHARACTER(1)                cardinality 2  
column "CR_LIMIT"        datatype TINYINT                     cardinality 5  
column "DISCOUNT_RT"     datatype TINYINT                     cardinality 4  
column "CUST_SINCE"      datatype OMNIDEX DATE(4) format YYYY cardinality 6  
column "LAST_ORDER"      datatype OMNIDEX DATE                cardinality 10 
column "SEARCH_KEY"      datatype CHARACTER(12)               cardinality 10
column "COMPANY_SDX"     datatype C STRING(24)                cardinality 10
        as "$soundex(COMPANY)"


/* --------------------- TABLE: TICKLERS ----------------------------------- */

table          "TICKLERS"
  physical     "dat/tkl.dat"
  primary      "TICKLER"
  cardinality  12

column "TICKLER"         datatype CHARACTER(2)                cardinality 12
column "DESCRIPTION"     datatype C STRING(31)                cardinality 12


/* --------------------- TABLE: INITIALS ----------------------------------- */

table          "INITIALS"
  physical     "dat/itl.dat"
  primary      "INITIALS"
  cardinality  10

column "INITIALS"        datatype C STRING(4)                 cardinality 10
column "DESCRIPTION"     datatype C STRING(31)                cardinality 10


/* --------------------- TABLE: ACTIVITY ----------------------------------- */

table          "ACTIVITY"
  physical     "dat/act.dat"
  primary      "ACCT","DT","TICKLER","INITIALS"
  foreign      "ACCT"       references "PROSPECTS"("ACCT")
  foreign      "DT"         references "DATES"("DT")
  foreign      "TICKLER"    references "TICKLERS"("TICKLER")
  foreign      "INITIALS"   references "INITIALS"("INITIALS")
  cardinality  100  

column "ACCT"            datatype INTEGER                     cardinality 10 
column "DT"              datatype OMNIDEX DATE                cardinality 40 
column "TICKLER"         datatype CHARACTER(2)                cardinality 7  
column "INITIALS"        datatype CHARACTER(4)                cardinality 4  


/* --------------------- TABLE: STATUSES ----------------------------------- */

table          "STATUSES"
  physical     "dat/sts.dat"
  primary      "STATUS"
  cardinality  4

column "STATUS"          datatype CHARACTER(2)                cardinality 4
column "DESCRIPTION"     datatype C STRING(31)                cardinality 4


/* --------------------- TABLE: PMT_METHODS -------------------------------- */

table          "PMT_METHODS"
  physical     "dat/pmt.dat"
  primary      "PMT_METHOD"
  cardinality  10

column "PMT_METHOD"      datatype TINYINT                     cardinality 10
column "DESCRIPTION"     datatype C STRING(31)                cardinality 10


/* --------------------- TABLE: SOURCES ------------------------------------ */

table          "SOURCES"
  physical     "dat/src.dat"
  primary      "SOURCE"
  cardinality  6

column "SOURCE"          datatype TINYINT                     cardinality 6
column "DESCRIPTION"     datatype C STRING(31)                cardinality 6


/* --------------------- TABLE: ORDERS ------------------------------------- */

table          "ORDERS"
  physical     "dat/ord.dat"
  foreign      "ACCT"       references "PROSPECTS"("ACCT")
  foreign      "PRODUCT_NO" references "PRODUCTS"("PRODUCT_NO")
  foreign      "ORDER_DATE" references "DATES"("DT")
  foreign      "STATUS"     references "STATUSES"("STATUS")
  foreign      "TAX_STATE"  references "STATES"("STATE")
  foreign      "SOURCE"     references "SOURCES"("SOURCE")
  foreign      "PMT_METHOD" references "PMT_METHODS"("PMT_METHOD")
  cardinality  200  

column "ACCT"            datatype INTEGER                     cardinality 3   
column "PRODUCT_NO"      datatype CHARACTER(4)                cardinality 63  
column "ORDER_DATE"      datatype OMNIDEX DATE                cardinality 68  
column "STATUS"          datatype CHARACTER(2)                cardinality 2   
column "TAX_STATE"       datatype CHARACTER(2)                cardinality 3   
column "SOURCE"          datatype TINYINT                     cardinality 6   
column "PMT_METHOD"      datatype TINYINT                     cardinality 10  
column "DISCOUNT"        datatype TINYINT                     cardinality 3   
column "QUANTITY"        datatype TINYINT                     cardinality 20  
column "SALES_TAX"       datatype FLOAT                       cardinality 111 
column "AMOUNT"          datatype FLOAT                       cardinality 64  
column "TOTAL"           datatype FLOAT                       cardinality 110 


/* --------------------- TABLE: PROSPECTS_ROLLUP --------------------------- */

table          "PROSPECTS_ROLLUP"
  physical     "dat/prr.dat"
  primary      "ACCT"
  foreign      "ACCT"       references "PROSPECTS"("ACCT")
  foreign      "COMPANY_ID" references "COMPANIES"("COMPANY_ID")
  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  3  

column "ACCT"            datatype INTEGER                     cardinality 3  
column "COMPANY_ID"      datatype INTEGER                     cardinality 3  
column "STATE"           datatype CHARACTER(2)                cardinality 3  
column "ZIP"             datatype C STRING(9)                 cardinality 3  
column "REGION"          datatype CHARACTER(2)                cardinality 1  
column "COUNTRY"         datatype CHARACTER(2)                cardinality 1  
column "GENDER"          datatype CHARACTER(1)                cardinality 2  
column "MAILFLAG"        datatype CHARACTER(1)                cardinality 2  
column "MAILING"         datatype CHARACTER(1)                cardinality 1  
column "PROFESSION"      datatype TINYINT                     cardinality 3  
column "INCOME"          datatype TINYINT                     cardinality 3  
column "PROFILE"         datatype CHARACTER(1)                cardinality 1  
column "PREFERRED"       datatype CHARACTER(1)                cardinality 2  
column "FRQ_BUY_MBR"     datatype CHARACTER(1)                cardinality 2  
column "CR_LIMIT"        datatype TINYINT                     cardinality 3  
column "DISCOUNT_RT"     datatype TINYINT                     cardinality 3  
column "CUST_SINCE"      datatype OMNIDEX DATE(4) format YYYY cardinality 3  
column "LAST_ORDER"      datatype OMNIDEX DATE                cardinality 3  

/* Rollup columns */

column "NUM_ORDERS"      datatype INTEGER                     cardinality 3  
column "TOTAL"           datatype DOUBLE                      cardinality 3  
column "DISCOUNT"        datatype DOUBLE                      cardinality 3  
column "SALES_TAX"       datatype DOUBLE                      cardinality 3  
column "MARGIN"          datatype DOUBLE                      cardinality 3  
column "ORDERED"         datatype DOUBLE                      cardinality 1  
column "CANCELED"        datatype DOUBLE                      cardinality 2  
column "BACKORDERED"     datatype DOUBLE                      cardinality 1  


/* --------------------- TABLE: PRODUCTS_ROLLUP ---------------------------- */

table          "PRODUCTS_ROLLUP"
  physical     "dat/pdr.dat"
  primary      "PRODUCT_NO","YR"
  foreign      "PRODUCT_NO" references "PRODUCTS"("PRODUCT_NO")
  foreign      "DIVISION","DEPT","CATEGORY"        
      references "CATEGORIES"("DIVISION","DEPT","CATEGORY")
  foreign      "MFR"        references "MFRS"("MFR")
  cardinality  153  

column "PRODUCT_NO"      datatype CHARACTER(4)                cardinality 63  
column "DESCRIPTION"     datatype C STRING(31)                cardinality 62  
column "DIVISION"        datatype TINYINT                     cardinality 5   
column "DEPT"            datatype SMALLINT                    cardinality 9   
column "CATEGORY"        datatype INTEGER                     cardinality 26  
column "MFR"             datatype TINYINT                     cardinality 31  

/* Rollup columns */

column "YR"              datatype OMNIDEX DATE(4) format YYYY cardinality 7   
column "NUM_ORDERS"      datatype INTEGER                     cardinality 4   
column "JAN_TOTAL"       datatype DOUBLE                      cardinality 23  
column "JAN_DISC"        datatype DOUBLE                      cardinality 23  
column "JAN_TAX"         datatype DOUBLE                      cardinality 23  
column "JAN_MGN"         datatype DOUBLE                      cardinality 23  
column "JAN_OR"          datatype DOUBLE                      cardinality 1   
column "JAN_CN"          datatype DOUBLE                      cardinality 1   
column "JAN_BO"          datatype DOUBLE                      cardinality 1   
column "FEB_TOTAL"       datatype DOUBLE                      cardinality 16  
column "FEB_DISC"        datatype DOUBLE                      cardinality 15  
column "FEB_TAX"         datatype DOUBLE                      cardinality 16  
column "FEB_MGN"         datatype DOUBLE                      cardinality 16  
column "FEB_OR"          datatype DOUBLE                      cardinality 1   
column "FEB_CN"          datatype DOUBLE                      cardinality 2   
column "FEB_BO"          datatype DOUBLE                      cardinality 1   
column "MAR_TOTAL"       datatype DOUBLE                      cardinality 14  
column "MAR_DISC"        datatype DOUBLE                      cardinality 14  
column "MAR_TAX"         datatype DOUBLE                      cardinality 14  
column "MAR_MGN"         datatype DOUBLE                      cardinality 14  
column "MAR_OR"          datatype DOUBLE                      cardinality 1   
column "MAR_CN"          datatype DOUBLE                      cardinality 3   
column "MAR_BO"          datatype DOUBLE                      cardinality 1   
column "APR_TOTAL"       datatype DOUBLE                      cardinality 11  
column "APR_DISC"        datatype DOUBLE                      cardinality 11  
column "APR_TAX"         datatype DOUBLE                      cardinality 11  
column "APR_MGN"         datatype DOUBLE                      cardinality 11  
column "APR_OR"          datatype DOUBLE                      cardinality 1   
column "APR_CN"          datatype DOUBLE                      cardinality 1   
column "APR_BO"          datatype DOUBLE                      cardinality 1   
column "MAY_TOTAL"       datatype DOUBLE                      cardinality 12  
column "MAY_DISC"        datatype DOUBLE                      cardinality 12  
column "MAY_TAX"         datatype DOUBLE                      cardinality 12  
column "MAY_MGN"         datatype DOUBLE                      cardinality 13  
column "MAY_OR"          datatype DOUBLE                      cardinality 1   
column "MAY_CN"          datatype DOUBLE                      cardinality 1   
column "MAY_BO"          datatype DOUBLE                      cardinality 1   
column "JUN_TOTAL"       datatype DOUBLE                      cardinality 16  
column "JUN_DISC"        datatype DOUBLE                      cardinality 16  
column "JUN_TAX"         datatype DOUBLE                      cardinality 16  
column "JUN_MGN"         datatype DOUBLE                      cardinality 16  
column "JUN_OR"          datatype DOUBLE                      cardinality 1   
column "JUN_CN"          datatype DOUBLE                      cardinality 2   
column "JUN_BO"          datatype DOUBLE                      cardinality 1   
column "JUL_TOTAL"       datatype DOUBLE                      cardinality 16  
column "JUL_DISC"        datatype DOUBLE                      cardinality 16  
column "JUL_TAX"         datatype DOUBLE                      cardinality 16  
column "JUL_MGN"         datatype DOUBLE                      cardinality 16  
column "JUL_OR"          datatype DOUBLE                      cardinality 1   
column "JUL_CN"          datatype DOUBLE                      cardinality 1   
column "JUL_BO"          datatype DOUBLE                      cardinality 1   
column "AUG_TOTAL"       datatype DOUBLE                      cardinality 16  
column "AUG_DISC"        datatype DOUBLE                      cardinality 16  
column "AUG_TAX"         datatype DOUBLE                      cardinality 16  
column "AUG_MGN"         datatype DOUBLE                      cardinality 16  
column "AUG_OR"          datatype DOUBLE                      cardinality 1   
column "AUG_CN"          datatype DOUBLE                      cardinality 1   
column "AUG_BO"          datatype DOUBLE                      cardinality 1   
column "SEP_TOTAL"       datatype DOUBLE                      cardinality 13  
column "SEP_DISC"        datatype DOUBLE                      cardinality 13  
column "SEP_TAX"         datatype DOUBLE                      cardinality 13  
column "SEP_MGN"         datatype DOUBLE                      cardinality 13  
column "SEP_OR"          datatype DOUBLE                      cardinality 1   
column "SEP_CN"          datatype DOUBLE                      cardinality 2   
column "SEP_BO"          datatype DOUBLE                      cardinality 1   
column "OCT_TOTAL"       datatype DOUBLE                      cardinality 18  
column "OCT_DISC"        datatype DOUBLE                      cardinality 19  
column "OCT_TAX"         datatype DOUBLE                      cardinality 19  
column "OCT_MGN"         datatype DOUBLE                      cardinality 19  
column "OCT_OR"          datatype DOUBLE                      cardinality 1   
column "OCT_CN"          datatype DOUBLE                      cardinality 2   
column "OCT_BO"          datatype DOUBLE                      cardinality 1   
column "NOV_TOTAL"       datatype DOUBLE                      cardinality 15  
column "NOV_DISC"        datatype DOUBLE                      cardinality 15  
column "NOV_TAX"         datatype DOUBLE                      cardinality 15  
column "NOV_MGN"         datatype DOUBLE                      cardinality 15  
column "NOV_OR"          datatype DOUBLE                      cardinality 1   
column "NOV_CN"          datatype DOUBLE                      cardinality 2   
column "NOV_BO"          datatype DOUBLE                      cardinality 1   
column "DEC_TOTAL"       datatype DOUBLE                      cardinality 15  
column "DEC_DISC"        datatype DOUBLE                      cardinality 15  
column "DEC_TAX"         datatype DOUBLE                      cardinality 15  
column "DEC_MGN"         datatype DOUBLE                      cardinality 15  
column "DEC_OR"          datatype DOUBLE                      cardinality 1   
column "DEC_CN"          datatype DOUBLE                      cardinality 1   
column "DEC_BO"          datatype DOUBLE                      cardinality 1   
column "TOTAL"           datatype DOUBLE                      cardinality 109 
column "DISCOUNT"        datatype DOUBLE                      cardinality 109 
column "SALES_TAX"       datatype DOUBLE                      cardinality 111 
column "MARGIN"          datatype DOUBLE                      cardinality 114 
column "ORDERED"         datatype DOUBLE                      cardinality 1   
column "CANCELED"        datatype DOUBLE                      cardinality 9   
column "BACKORDERED"     datatype DOUBLE                      cardinality 1   
column "CASH"            datatype DOUBLE                      cardinality 17  
column "CHECKS"          datatype DOUBLE                      cardinality 15  
column "ATM"             datatype DOUBLE                      cardinality 16  
column "VISA"            datatype DOUBLE                      cardinality 11  
column "MC"              datatype DOUBLE                      cardinality 18  
column "AMEX"            datatype DOUBLE                      cardinality 26  
column "DISCOVER"        datatype DOUBLE                      cardinality 15  
column "DINERSCLUB"      datatype DOUBLE                      cardinality 23  
column "OTHERCC"         datatype DOUBLE                      cardinality 23  
column "PO"              datatype DOUBLE                      cardinality 19  
column "TELEPHONE"       datatype DOUBLE                      cardinality 21  
column "FAX"             datatype DOUBLE                      cardinality 11  
column "MAIL"            datatype DOUBLE                      cardinality 12  
column "INTERNET"        datatype DOUBLE                      cardinality 9   
column "CATALOGS"        datatype DOUBLE                      cardinality 33  
column "RETAIL"          datatype DOUBLE                      cardinality 66  


/* --------------------- TABLE: ORDERS_ROLLUP ------------------------------ */

table          "ORDERS_ROLLUP"
  physical     "dat/orr.dat"
  primary      "YR"
  cardinality  7  

/* Rollup columns */

column "YR"              datatype OMNIDEX DATE(4) format YYYY cardinality 7 
column "NUM_ORDERS"      datatype INTEGER                     cardinality 7 
column "JAN_TOTAL"       datatype DOUBLE                      cardinality 7 
column "JAN_DISC"        datatype DOUBLE                      cardinality 7 
column "JAN_TAX"         datatype DOUBLE                      cardinality 7 
column "JAN_MGN"         datatype DOUBLE                      cardinality 7 
column "JAN_OR"          datatype DOUBLE                      cardinality 1 
column "JAN_CN"          datatype DOUBLE                      cardinality 1 
column "JAN_BO"          datatype DOUBLE                      cardinality 1 
column "FEB_TOTAL"       datatype DOUBLE                      cardinality 7 
column "FEB_DISC"        datatype DOUBLE                      cardinality 7 
column "FEB_TAX"         datatype DOUBLE                      cardinality 7 
column "FEB_MGN"         datatype DOUBLE                      cardinality 7 
column "FEB_OR"          datatype DOUBLE                      cardinality 1 
column "FEB_CN"          datatype DOUBLE                      cardinality 2 
column "FEB_BO"          datatype DOUBLE                      cardinality 1 
column "MAR_TOTAL"       datatype DOUBLE                      cardinality 6 
column "MAR_DISC"        datatype DOUBLE                      cardinality 6 
column "MAR_TAX"         datatype DOUBLE                      cardinality 6 
column "MAR_MGN"         datatype DOUBLE                      cardinality 6 
column "MAR_OR"          datatype DOUBLE                      cardinality 1 
column "MAR_CN"          datatype DOUBLE                      cardinality 3 
column "MAR_BO"          datatype DOUBLE                      cardinality 1 
column "APR_TOTAL"       datatype DOUBLE                      cardinality 6 
column "APR_DISC"        datatype DOUBLE                      cardinality 6 
column "APR_TAX"         datatype DOUBLE                      cardinality 6 
column "APR_MGN"         datatype DOUBLE                      cardinality 6 
column "APR_OR"          datatype DOUBLE                      cardinality 1 
column "APR_CN"          datatype DOUBLE                      cardinality 1 
column "APR_BO"          datatype DOUBLE                      cardinality 1 
column "MAY_TOTAL"       datatype DOUBLE                      cardinality 6 
column "MAY_DISC"        datatype DOUBLE                      cardinality 6 
column "MAY_TAX"         datatype DOUBLE                      cardinality 6 
column "MAY_MGN"         datatype DOUBLE                      cardinality 6 
column "MAY_OR"          datatype DOUBLE                      cardinality 1 
column "MAY_CN"          datatype DOUBLE                      cardinality 1 
column "MAY_BO"          datatype DOUBLE                      cardinality 1 
column "JUN_TOTAL"       datatype DOUBLE                      cardinality 7 
column "JUN_DISC"        datatype DOUBLE                      cardinality 7 
column "JUN_TAX"         datatype DOUBLE                      cardinality 7 
column "JUN_MGN"         datatype DOUBLE                      cardinality 7 
column "JUN_OR"          datatype DOUBLE                      cardinality 1 
column "JUN_CN"          datatype DOUBLE                      cardinality 2 
column "JUN_BO"          datatype DOUBLE                      cardinality 1 
column "JUL_TOTAL"       datatype DOUBLE                      cardinality 4 
column "JUL_DISC"        datatype DOUBLE                      cardinality 4 
column "JUL_TAX"         datatype DOUBLE                      cardinality 4 
column "JUL_MGN"         datatype DOUBLE                      cardinality 4 
column "JUL_OR"          datatype DOUBLE                      cardinality 1 
column "JUL_CN"          datatype DOUBLE                      cardinality 1 
column "JUL_BO"          datatype DOUBLE                      cardinality 1 
column "AUG_TOTAL"       datatype DOUBLE                      cardinality 7 
column "AUG_DISC"        datatype DOUBLE                      cardinality 7 
column "AUG_TAX"         datatype DOUBLE                      cardinality 7 
column "AUG_MGN"         datatype DOUBLE                      cardinality 7 
column "AUG_OR"          datatype DOUBLE                      cardinality 1 
column "AUG_CN"          datatype DOUBLE                      cardinality 1 
column "AUG_BO"          datatype DOUBLE                      cardinality 1 
column "SEP_TOTAL"       datatype DOUBLE                      cardinality 5 
column "SEP_DISC"        datatype DOUBLE                      cardinality 5 
column "SEP_TAX"         datatype DOUBLE                      cardinality 5 
column "SEP_MGN"         datatype DOUBLE                      cardinality 5 
column "SEP_OR"          datatype DOUBLE                      cardinality 1 
column "SEP_CN"          datatype DOUBLE                      cardinality 2 
column "SEP_BO"          datatype DOUBLE                      cardinality 1 
column "OCT_TOTAL"       datatype DOUBLE                      cardinality 7 
column "OCT_DISC"        datatype DOUBLE                      cardinality 7 
column "OCT_TAX"         datatype DOUBLE                      cardinality 7 
column "OCT_MGN"         datatype DOUBLE                      cardinality 7 
column "OCT_OR"          datatype DOUBLE                      cardinality 1 
column "OCT_CN"          datatype DOUBLE                      cardinality 2 
column "OCT_BO"          datatype DOUBLE                      cardinality 1 
column "NOV_TOTAL"       datatype DOUBLE                      cardinality 6 
column "NOV_DISC"        datatype DOUBLE                      cardinality 6 
column "NOV_TAX"         datatype DOUBLE                      cardinality 6 
column "NOV_MGN"         datatype DOUBLE                      cardinality 6 
column "NOV_OR"          datatype DOUBLE                      cardinality 1 
column "NOV_CN"          datatype DOUBLE                      cardinality 2 
column "NOV_BO"          datatype DOUBLE                      cardinality 1 
column "DEC_TOTAL"       datatype DOUBLE                      cardinality 7 
column "DEC_DISC"        datatype DOUBLE                      cardinality 7 
column "DEC_TAX"         datatype DOUBLE                      cardinality 7 
column "DEC_MGN"         datatype DOUBLE                      cardinality 7 
column "DEC_OR"          datatype DOUBLE                      cardinality 1 
column "DEC_CN"          datatype DOUBLE                      cardinality 1 
column "DEC_BO"          datatype DOUBLE                      cardinality 1 
column "TOTAL"           datatype DOUBLE                      cardinality 7 
column "DISCOUNT"        datatype DOUBLE                      cardinality 7 
column "SALES_TAX"       datatype DOUBLE                      cardinality 7 
column "MARGIN"          datatype DOUBLE                      cardinality 7 
column "ORDERED"         datatype DOUBLE                      cardinality 1 
column "CANCELED"        datatype DOUBLE                      cardinality 6 
column "BACKORDERED"     datatype DOUBLE                      cardinality 1 
column "CASH"            datatype DOUBLE                      cardinality 7 
column "CHECKS"          datatype DOUBLE                      cardinality 6 
column "ATM"             datatype DOUBLE                      cardinality 7 
column "VISA"            datatype DOUBLE                      cardinality 6 
column "MC"              datatype DOUBLE                      cardinality 7 
column "AMEX"            datatype DOUBLE                      cardinality 7 
column "DISCOVER"        datatype DOUBLE                      cardinality 6 
column "DINERSCLUB"      datatype DOUBLE                      cardinality 7 
column "OTHERCC"         datatype DOUBLE                      cardinality 7 
column "PO"              datatype DOUBLE                      cardinality 7 
column "TELEPHONE"       datatype DOUBLE                      cardinality 7 
column "FAX"             datatype DOUBLE                      cardinality 7 
column "MAIL"            datatype DOUBLE                      cardinality 6 
column "INTERNET"        datatype DOUBLE                      cardinality 6 
column "CATALOGS"        datatype DOUBLE                      cardinality 7 
column "RETAIL"          datatype DOUBLE                      cardinality 7 


/* --------------------- TABLE: ORDERS_SVW --------------------------------- */

table          "ORDERS_SVW"
  physical     "dat/osv.dat"
  foreign      "ACCT"       references "PROSPECTS"("ACCT")
  foreign      "COMPANY_ID" references "COMPANIES"("COMPANY_ID")
  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","DEPT","CATEGORY"        
      references "CATEGORIES"("DIVISION","DEPT","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  

column "ACCT"            datatype INTEGER                     cardinality 3   
column "COMPANY_ID"      datatype INTEGER                     cardinality 3   
column "STATE"           datatype CHARACTER(2)                cardinality 3   
column "ZIP"             datatype C STRING(9)                 cardinality 3   
column "REGION"          datatype CHARACTER(2)                cardinality 1   
column "COUNTRY"         datatype CHARACTER(2)                cardinality 1   
column "GENDER"          datatype CHARACTER(1)                cardinality 2   
column "MAILFLAG"        datatype CHARACTER(1)                cardinality 2   
column "MAILING"         datatype CHARACTER(1)                cardinality 1   
column "PROFESSION"      datatype TINYINT                     cardinality 3   
column "INCOME"          datatype TINYINT                     cardinality 3   
column "PROFILE"         datatype CHARACTER(1)                cardinality 1   
column "PREFERRED"       datatype CHARACTER(1)                cardinality 2   
column "FRQ_BUY_MBR"     datatype CHARACTER(1)                cardinality 2   
column "CR_LIMIT"        datatype TINYINT                     cardinality 3   
column "DISCOUNT_RT"     datatype TINYINT                     cardinality 3   
column "CUST_SINCE"      datatype OMNIDEX DATE(4) format YYYY cardinality 3   
column "LAST_ORDER"      datatype OMNIDEX DATE                cardinality 3   

column "PRODUCT_NO"      datatype CHARACTER(4)                cardinality 63  
column "DIVISION"        datatype TINYINT                     cardinality 5   
column "DEPT"            datatype SMALLINT                    cardinality 9   
column "CATEGORY"        datatype INTEGER                     cardinality 26  
column "MFR"             datatype TINYINT                     cardinality 31  

column "ORDER_DATE"      datatype OMNIDEX DATE                cardinality 68  
column "OR_YR"           datatype OMNIDEX DATE(4) format YYYY cardinality 7   
column "OR_MO"           datatype OMNIDEX DATE(2) format MM   cardinality 12  
column "OR_DY_OF_MO"     datatype OMNIDEX DATE(2) format DD   cardinality 3   
column "OR_DY_OF_YR"     datatype SMALLINT                    cardinality 22  
column "OR_DY_OF_WK"     datatype TINYINT                     cardinality 7   
column "OR_WK"           datatype TINYINT                     cardinality 23  
column "OR_QTR"          datatype TINYINT                     cardinality 4   
column "OR_FQTR"         datatype TINYINT                     cardinality 4   
column "OR_FYR"          datatype OMNIDEX DATE(4) format YYYY cardinality 8   
column "STATUS"          datatype CHARACTER(2)                cardinality 2   
column "TAX_STATE"       datatype CHARACTER(2)                cardinality 3   
column "SOURCE"          datatype TINYINT                     cardinality 6   
column "PMT_METHOD"      datatype TINYINT                     cardinality 10  
column "DISCOUNT"        datatype TINYINT                     cardinality 3   
column "QUANTITY"        datatype TINYINT                     cardinality 20  
column "SALES_TAX"       datatype FLOAT                       cardinality 111 
column "AMOUNT"          datatype FLOAT                       cardinality 64  
column "TOTAL"           datatype FLOAT                       cardinality 110 
