These relationships link a parent table to one or more child tables. They can apply to both list and transaction tables. The format for these relationships is:
Parent.ListID -> Child.PARENT_IDKEY for list tables
Parent.TxnID -> Child.PARENT_IDKEY for transaction tables
Reference relationships
These relationships link list entries to other list or transaction tables. The format these links use is:
TableNameRef_ListID
TableNameRef_FullName
TableName will indicate the table being referenced. For example, the column named CustomerRef_ListID refers to the ListID field in the customer table.
For related tables that do not contain a FullName column, the Ref_FullName column will refer to the Name column in the target table.
Adding Relationships
Relationships defined within the database schema do not support referential integrity constraints. You should only define the relationships to be used within your queries.
