This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:features:rollups:create [2012/02/17 16:35] doc |
admin:features:rollups:create [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 16: | Line 16: | ||
| <code> | <code> | ||
| create table "INDIVIDUALS" | create table "INDIVIDUALS" | ||
| - | physical "dat\individuals.dat" | + | physical "dat/individuals.dat" |
| ( | ( | ||
| - | "INDIVIDUAL" CHARACTER(12) omnidex, | + | "INDIVIDUAL" CHARACTER(12), |
| - | "HOUSEHOLD" CHARACTER(12) omnidex, | + | "HOUSEHOLD" CHARACTER(12), |
| - | "NAME" CHARACTER(50) quicktext, | + | "NAME" CHARACTER(50), |
| - | "GENDER" CHARACTER(1) omnidex bitmap, | + | "GENDER" CHARACTER(1), |
| - | "BIRTHDATE" ANSI DATE omnidex, | + | "BIRTHDATE" ANSI DATE, |
| - | "PHONE" CHARACTER(14) omnidex, | + | "PHONE" CHARACTER(14), |
| - | "EMAIL" CHARACTER(60) quicktext, | + | "EMAIL" CHARACTER(60), |
| constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | ||
| constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", | constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", | ||
| Line 32: | Line 32: | ||
| create table "INDIVIDUALS_BY_HOUSEHOLD" | create table "INDIVIDUALS_BY_HOUSEHOLD" | ||
| - | physical "dat\individuals_by_household.dat" | + | physical "dat/individuals_by_household.dat" |
| ( | ( | ||
| - | "HOUSEHOLD" CHARACTER(12) omnidex, | + | "HOUSEHOLD" CHARACTER(12), |
| - | "GENDER" CHARACTER(1) omnidex bitmap, | + | "GENDER" CHARACTER(1), |
| - | "BIRTHDATE" ANSI DATE omnidex, | + | "BIRTHDATE" ANSI DATE, |
| "NUM_INDIVIDUALS" UNSIGNED INTEGER, | "NUM_INDIVIDUALS" UNSIGNED INTEGER, | ||
| constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", | constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", | ||
| Line 53: | Line 53: | ||
| create table "INDIVIDUALS_BY_DEMO" | create table "INDIVIDUALS_BY_DEMO" | ||
| - | physical "dat\individuals_by_demo.dat" | + | physical "dat/individuals_by_demo.dat" |
| ( | ( | ||
| - | "GENDER" CHARACTER(1) omnidex bitmap, | + | "GENDER" CHARACTER(1), |
| - | "BIRTHDATE" ANSI DATE omnidex, | + | "BIRTHDATE" ANSI DATE, |
| "NUM_INDIVIDUALS" UNSIGNED INTEGER, | "NUM_INDIVIDUALS" UNSIGNED INTEGER, | ||
| constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS", | constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS", | ||