Entity Tables

Entity table records has some standard fields in addition to any entity specific fields. Standard fields:

• A serial number primary key with the field name [table name]ID.
• A display name usually having the field name [table name]DisplayName.
• A timestamp with the name CreateDt

Relationship Tables

Relationship tables are many-to-many relationships between two entity tables. For example the contribution table shows the relationships between people (records in the Person table) and Tracks. A track can have any number of contributions from any person and from any number of people. A person can contribute to any number of tracks.

Mapping Tables

Mapping tables are kind of reverse lookup tables. Over time I’ll add to these tables to group values in free-form fields.

Lookup Tables

Normalized tables for indicators display names.