This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:expressioncols:declaration [2012/02/04 06:03] doc |
admin:features:expressioncols:declaration [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 9: | Line 9: | ||
[[admin:features:expressioncols:home|Overview]] | | [[admin:features:expressioncols:home|Overview]] | | ||
**[[admin:features:expressioncols:declaration|Declaring Expression-based Columns]]** | | **[[admin:features:expressioncols:declaration|Declaring Expression-based Columns]]** | | ||
- | [[admin:features:expressioncols:indexing|Indexing Expression-based Columns]] | | + | [[admin:features:expressioncols:optimization|Optimizing Queries]] |
- | [[admin:features:expressioncols:Optimization]] | + | |
---- | ---- | ||
Line 46: | Line 45: | ||
( | ( | ||
"INDIVIDUAL" CHARACTER(12), | "INDIVIDUAL" CHARACTER(12), | ||
- | "HOUSEHOLD" CHARACTER(12) , | + | "HOUSEHOLD" CHARACTER(12), |
"NAME" CHARACTER(50), | "NAME" CHARACTER(50), | ||
- | "GENDER" CHARACTER(1) , | + | "GENDER" CHARACTER(1), |
- | "BIRTHDATE" ANSI DATE , | + | "BIRTHDATE" ANSI DATE, |
"PHONE" CHARACTER(14), | "PHONE" CHARACTER(14), | ||
"EMAIL" CHARACTER(60), | "EMAIL" CHARACTER(60), | ||
Line 74: | Line 73: | ||
( | ( | ||
"INDIVIDUAL" CHARACTER(12), | "INDIVIDUAL" CHARACTER(12), | ||
- | "HOUSEHOLD" CHARACTER(12) , | + | "HOUSEHOLD" CHARACTER(12), |
"NAME" CHARACTER(50), | "NAME" CHARACTER(50), | ||
- | "GENDER" CHARACTER(1) , | + | "GENDER" CHARACTER(1), |
- | "BIRTHDATE" ANSI DATE , | + | "BIRTHDATE" ANSI DATE, |
"PHONE" CHARACTER(14), | "PHONE" CHARACTER(14), | ||
"EMAIL" CHARACTER(60), | "EMAIL" CHARACTER(60), | ||
Line 108: | Line 107: | ||
( | ( | ||
"INDIVIDUAL" CHARACTER(12), | "INDIVIDUAL" CHARACTER(12), | ||
- | "HOUSEHOLD" CHARACTER(12) , | + | "HOUSEHOLD" CHARACTER(12), |
"NAME" CHARACTER(50), | "NAME" CHARACTER(50), | ||
- | "GENDER" CHARACTER(1) , | + | "GENDER" CHARACTER(1), |
- | "BIRTHDATE" ANSI DATE , | + | "BIRTHDATE" ANSI DATE, |
"PHONE" CHARACTER(14), | "PHONE" CHARACTER(14), | ||
"EMAIL" CHARACTER(60), | "EMAIL" CHARACTER(60), | ||
Line 150: | Line 149: | ||
==== ==== | ==== ==== | ||
- | **[[admin:features:expressioncols:declaration|Next]]** | + | **[[admin:features:expressioncols:home|Prev]]** | |
+ | **[[admin:features:expressioncols:optimization|Next]]** | ||