A table is an implementation of an entity type appearing in the data model. A table is associated with the data model entity type that it implements.
Each table is attached to at least one index, the contents of which uniquely identify an occurrence of the table in the database.
Each table may be attached to RI constraints, which are implementations of relationships from the data model.
A table will be placed in the Data Structure List for each of the M:N relationships. The table will be named by the M:N relationship itself. This type of table is relatively rare. Such tables contain foreign key columns to both participants in the relationship.
Each table created by a M:M relationship is granted two unique entry points. Each entry point contains the two foreign key columns in each of the two possible sequences. The only columns appearing on this type of a table are the foreign keys to the two participants in the relationship.
|
Copyright © 2013 CA.
All rights reserved.
|
|