Database Reference
In-Depth Information
•
General Elements:
Field Name, Parent Table, Label, Specification Type, Source
Specification, Shared By, Alias(es), Description
•
Physical Elements:
Data Type, Length, Decimal Places, Character Support, Input
Mask, Display Format
•
Logical Elements:
Key Type, Key Structure, Uniqueness, Null Support, Values
Entered By, Required Value, Default Value, Range of Values, Edit Rule, Comparis-
ons Allowed, Operations Allowed
Figure 9.1
shows an example of a Field Specifications sheet. We'll use this sheet (or vari-
ous portions of it) as we work on field specification examples throughout the remainder of
the topic.