Page-1



Legend.

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