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
|