Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

Appendix

Sample Databases

Environment Source

Index Installation Script

 

Orders

 

Appendix

Star

The Star database is a flat file star schema database that is used in many of the examples throughout this documentation as well as in DISC QA testing. Following is the environment source declaration.

 

environment "star_env"


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

database "star"
type flatfile
indexprefix "c:\demos\env\ffl\star\idx\STAR"


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

table "DIVISIONS"
physical "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\dpt.dat"
primary "DIVISION","DEPT"
foreign "DIVISION" references "DIVISIONS"("DIVISION")
cardinality 10

column "DIVISION" datatype INTEGER length 1 cardinality 5
column "DEPT" datatype INTEGER length 2 cardinality 10
column "DESCRIPTION" datatype C STRING length 32 cardinality 10


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

table "CATEGORIES"
physical "c:\demos\data\ffl\star\cat.dat"
primary "DIVISION","DEPT","CATEGORY"
foreign "DIVISION","DEPT" references "DEPTS"("DIVISION","DEPT")
cardinality 30

column "DIVISION" datatype INTEGER length 1 cardinality 5
column "DEPT" datatype INTEGER length 2 cardinality 10
column "CATEGORY" datatype INTEGER length 4 cardinality 30
column "DESCRIPTION" datatype C STRING length 32 cardinality 30


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

table "MFRS"
physical "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\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 length 4 cardinality 100
column "DESCRIPTION" datatype C STRING length 32 cardinality 95
column "DIVISION" datatype INTEGER length 1 cardinality 5
column "DEPT" datatype INTEGER length 2 cardinality 10
column "CATEGORY" datatype INTEGER length 4 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 cardinality 45
as "WHOLESALE * 100.0 / COST"


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

table "COUNTRIES"
physical "c:\demos\data\ffl\star\cnt.dat"
primary "COUNTRY"
cardinality 239

column "COUNTRY" datatype CHARACTER length 2 cardinality 239
column "DESCRIPTION" datatype C STRING length 48 cardinality 239
column "LATITUDE" datatype FLOAT length 4 cardinality 168
column "LONGITUDE" datatype FLOAT length 4 cardinality 188
column "CAPITAL" datatype C STRING length 32 cardinality 217
column "CAPITAL_LAT" datatype FLOAT length 4 cardinality 216
column "CAPITAL_LONG" datatype FLOAT length 4 cardinality 215


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

table "REGIONS"
physical "c:\demos\data\ffl\star\reg.dat"
primary "REGION"
cardinality 7

column "REGION" datatype CHARACTER length 2 cardinality 7
column "DESCRIPTION" datatype C STRING length 32 cardinality 7


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

table "STATES"
physical "c:\demos\data\ffl\star\sta.dat"
primary "STATE"
foreign "REGION" references "REGIONS"("REGION")
foreign "COUNTRY" references "COUNTRIES"("COUNTRY")
cardinality 73

column "STATE" datatype CHARACTER length 2 cardinality 73
column "DESCRIPTION" datatype C STRING length 32 cardinality 73
column "STATE_CODE" datatype CHARACTER length 2 cardinality 53
column "REGION" datatype CHARACTER length 2 cardinality 7
column "COUNTRY" datatype CHARACTER length 2 cardinality 2
column "TAX_RATE" datatype FLOAT length 4 cardinality 15


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

table "COUNTIES"
physical "c:\demos\data\ffl\star\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 length 2 cardinality 1
column "STATE" datatype CHARACTER length 2 cardinality 57
column "STATE_CODE" datatype CHARACTER length 2 cardinality 53
column "COUNTY_CODE" datatype CHARACTER length 3 cardinality 328
column "COUNTY" datatype C STRING length 32 cardinality 1930
column "REGION" datatype CHARACTER length 2 cardinality 7
column "ACTIVE" datatype CHARACTER length 1 cardinality 2
column "ELEVATION" datatype INTEGER length 2 cardinality 1730
column "SQ_MILES" datatype INTEGER length 4 cardinality 1403


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

table "COUNTY_CENSUS"
physical "c:\demos\data\ffl\star\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 length 2 cardinality 1
column "STATE" datatype CHARACTER length 2 cardinality 52
column "STATE_CODE" datatype CHARACTER length 2 cardinality 52
column "COUNTY_CODE" datatype CHARACTER length 3 cardinality 326
column "YR" datatype CHARACTER length 4 cardinality 2
column "POPULATION" datatype INTEGER length 4 cardinality 6085
column "MALE" datatype INTEGER length 4 cardinality 5862
column "FEMALE" datatype INTEGER length 4 cardinality 5880
column "AGE_UNDER_5" datatype INTEGER length 4 cardinality 3987
column "AGE_5_24" datatype INTEGER length 4 cardinality 5541
column "AGE_25_44" datatype INTEGER length 4 cardinality 5494
column "AGE_45_54" datatype INTEGER length 4 cardinality 4701
column "AGE_55_59" datatype INTEGER length 4 cardinality 3478
column "AGE_60_64" datatype INTEGER length 4 cardinality 3352
column "AGE_65_74" datatype INTEGER length 4 cardinality 4067
column "AGE_75_84" datatype INTEGER length 4 cardinality 3393
column "AGE_85_OVER" datatype INTEGER length 4 cardinality 2012
column "AGE_18_OVER" datatype INTEGER length 4 cardinality 6014
column "AGE_65_OVER" datatype INTEGER length 4 cardinality 4864
column "HOUSEHOLDS" datatype INTEGER length 4 cardinality 5713
column "HSHD_FAMILY" datatype INTEGER length 4 cardinality 5482
column "HSHD_MARRIED" datatype INTEGER length 4 cardinality 5302
column "HSHD_FEMALE" datatype INTEGER length 4 cardinality 3225
column "HSHD_NON_FAMILY" datatype INTEGER length 4 cardinality 4486
column "HSHD_ALONE" datatype INTEGER length 4 cardinality 4261
column "HSHD_AVG_SIZE" datatype FLOAT length 4 cardinality 173
column "FAMILY_AVG_SIZE" datatype FLOAT length 4 cardinality 139


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

table "STATE_CENSUS"
physical "c:\demos\data\ffl\star\stc.dat"
primary "STATE","YR"
foreign "STATE" references "STATES"("STATE")
foreign "COUNTRY" references "COUNTRIES"("COUNTRY")
cardinality 129

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


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

table "COUNTRY_CENSUS"
physical "c:\demos\data\ffl\star\cnc.dat"
primary "COUNTRY","YR"
foreign "COUNTRY" references "COUNTRIES"("COUNTRY")
cardinality 4

column "COUNTRY" datatype CHARACTER length 2 cardinality 2
column "YR" datatype CHARACTER length 4 cardinality 4
column "POPULATION" datatype INTEGER length 8 cardinality 4
column "MALE" datatype INTEGER length 8 cardinality 3
column "FEMALE" datatype INTEGER length 8 cardinality 3
column "AGE_UNDER_5" datatype INTEGER length 8 cardinality 3
column "AGE_5_24" datatype INTEGER length 8 cardinality 3
column "AGE_25_44" datatype INTEGER length 8 cardinality 3
column "AGE_45_54" datatype INTEGER length 8 cardinality 3
column "AGE_55_59" datatype INTEGER length 8 cardinality 3
column "AGE_60_64" datatype INTEGER length 8 cardinality 3
column "AGE_65_74" datatype INTEGER length 8 cardinality 3
column "AGE_75_84" datatype INTEGER length 8 cardinality 3
column "AGE_85_OVER" datatype INTEGER length 8 cardinality 3
column "AGE_18_OVER" datatype INTEGER length 8 cardinality 3
column "AGE_65_OVER" datatype INTEGER length 8 cardinality 3
column "HOUSEHOLDS" datatype INTEGER length 8 cardinality 3
column "HSHD_FAMILY" datatype INTEGER length 8 cardinality 3
column "HSHD_MARRIED" datatype INTEGER length 8 cardinality 3
column "HSHD_FEMALE" datatype INTEGER length 8 cardinality 3
column "HSHD_NON_FAMILY" datatype INTEGER length 8 cardinality 3
column "HSHD_ALONE" datatype INTEGER length 8 cardinality 3
column "HSHD_AVG_SIZE" datatype FLOAT length 4 cardinality 4
column "FAMILY_AVG_SIZE" datatype FLOAT length 4 cardinality 2


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

table "ZIPCODES"
physical "c:\demos\data\ffl\star\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 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 "AREACODES" datatype CHARACTER length 15 cardinality 289
column "TIME_ZONE" datatype INTEGER length 1 cardinality 12


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

table "COMPANIES"
physical "c:\demos\data\ffl\star\cmp.dat"
primary "COMPANY"
foreign "STATE" references "STATES"("STATE")
foreign "ZIP" references "ZIPCODES"("ZIP")
foreign "COUNTRY" references "COUNTRIES"("COUNTRY")
cardinality 6000

column "COMPANY" datatype C STRING length 40 cardinality 6000
column "ADDRESS1" datatype C STRING length 30 cardinality 5592
column "ADDRESS2" datatype C STRING length 30 cardinality 1312
column "CITY" datatype C STRING length 26 cardinality 1323
column "STATE" datatype CHARACTER length 2 cardinality 51
column "ZIP" datatype C STRING length 10 cardinality 2737
column "COUNTRY" datatype CHARACTER length 2 cardinality 1
column "PHONE" datatype C STRING length 16 cardinality 4427
column "PH_ZP2" datatype C STRING length 17 cardinality 5344
as "substring(PHONE from 4 for 7) || ZIP"
column "PHONE2" datatype C STRING length 8 cardinality 4418
as "substring(PHONE from 4 for 7)"
column "ST_ZP_CNTRY2" datatype C STRING length 14 cardinality 2737
as "STATE || ZIP || COUNTRY"
column "CTY_ST" datatype C STRING length 29 cardinality 1439
as "CITY || STATE"
column "CTY5_ST" datatype C STRING length 8 cardinality 1371
as "substring(CITY from 1 for 5) || STATE"


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

table "GENDERS"
physical "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\mlf.dat"
primary "MAILFLAG"
cardinality 4

column "MAILFLAG" datatype CHARACTER length 1 cardinality 4
column "DESCRIPTION" datatype C STRING length 32 cardinality 4


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

table "MAILINGS"
physical "c:\demos\data\ffl\star\mal.dat"
primary "MAILING"
cardinality 8

column "MAILING" datatype CHARACTER length 1 cardinality 8
column "DESCRIPTION" datatype C STRING length 32 cardinality 8


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

table "INCOMES"
physical "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\pfl.dat"
primary "PROFILE"
cardinality 6

column "PROFILE" datatype CHARACTER length 1 cardinality 6
column "DESCRIPTION" datatype C STRING length 32 cardinality 6


/* --------------------- TABLE: DATES -------------------------------------- */

table "DATES"
physical "c:\demos\data\ffl\star\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: AREACODES ---------------------------------- */

table "AREACODES"
physical "c:\demos\data\ffl\star\arc.dat"
primary "AREACODE"
cardinality 800

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


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

table "PROSPECTS"
physical "c:\demos\data\ffl\star\pro.dat"
primary "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")
foreign "LAST_ORDER" references "DATES"("DT")
cardinality 1000000

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


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

table "TICKLERS"
physical "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\itl.dat"
primary "INITIALS"
cardinality 10

column "INITIALS" datatype CHARACTER length 4 cardinality 10
column "DESCRIPTION" datatype C STRING length 32 cardinality 10


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

table "ACTIVITY"
physical "c:\demos\data\ffl\star\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 10000000

column "ACCT" datatype INTEGER length 4 cardinality 10
column "DT" datatype OMNIDEX DATE length 4 format YYYYMMDD cardinality 40
column "TICKLER" datatype CHARACTER length 2 cardinality 7
column "INITIALS" datatype CHARACTER length 4 cardinality 4


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

table "STATUSES"
physical "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\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 "c:\demos\data\ffl\star\src.dat"
primary "SOURCE"
cardinality 6

column "SOURCE" datatype INTEGER length 1 cardinality 6
column "DESCRIPTION" datatype C STRING length 32 cardinality 6


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

table "ORDERS"
physical "c:\demos\data\ffl\star\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 20000000

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


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

table "PROSPECTS_ROLLUP"
physical "c:\demos\data\ffl\star\prr.dat"
primary "ACCT"
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")
cardinality 710023

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

/* Rollup columns */

column "NUM_ORDERS" datatype INTEGER length 4 cardinality 9
column "TOTAL" datatype FLOAT length 8 cardinality 12
column "DISCOUNT" datatype FLOAT length 8 cardinality 12
column "SALES_TAX" datatype FLOAT length 8 cardinality 12
column "MARGIN" datatype FLOAT length 8 cardinality 12
column "ORDERED" datatype FLOAT length 8 cardinality 1
column "CANCELED" datatype FLOAT length 8 cardinality 6
column "BACKORDERED" datatype FLOAT length 8 cardinality 1


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

table "PRODUCTS_ROLLUP"
physical "c:\demos\data\ffl\star\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 1201

column "PRODUCT_NO" datatype CHARACTER length 4 cardinality 63
column "DESCRIPTION" datatype C STRING length 32 cardinality 62
column "DIVISION" datatype INTEGER length 1 cardinality 5
column "DEPT" datatype INTEGER length 2 cardinality 9
column "CATEGORY" datatype INTEGER length 4 cardinality 26
column "MFR" datatype INTEGER length 1 cardinality 31

/* Rollup columns */

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


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

table "ORDERS_ROLLUP"
physical "c:\demos\data\ffl\star\orr.dat"
primary "YR"
cardinality 13

/* Rollup columns */

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


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

table "ORDERS_SVW"
physical "c:\demos\data\ffl\star\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","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 20000000

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

column "PRODUCT_NO" datatype CHARACTER length 4 cardinality 63
column "DIVISION" datatype INTEGER length 1 cardinality 5
column "DEPT" datatype INTEGER length 2 cardinality 9
column "CATEGORY" datatype INTEGER length 4 cardinality 26
column "MFR" datatype INTEGER length 1 cardinality 31

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

 

Top