
1. If an attribute is a primary key, it is underlined.
2. If an attribute is a foreign key, FK follows its name in parenthesis.
3. The type of an attribute is CAPITALIZED.
4. The types are:
INT – integer
LONG – long integer, used
for automatically generated integers
TEXT(size) – text, where
"size" is the number of characters allowed in the field
CURRENCY – currency in US
dollars and cents
DATE – date
GUID – an enumerated type
with restricted number of pre-specified values