Previous Topic: Design Tasks for Data Implementation ObjectsNext Topic: Task


RECORD (Record Definition)

All records are database tables. A record is either a data record or a link record depending on the value in the ROLE field.

A data record represents an implementation of an entity type or subtype. An entity type or subtype can be implemented by more than one record. Conversely, a record may implement more than one entity type or subtype. The Entity to Record Implementation defines the entity type to record intersection. For more information, see ENTITY_REC_IMPL.

A link record implements a many-to-many relationship between two entity types. A many-to-many relationship between Entity Type A and Entity Type B is equivalent to a one-to-many relationship between A and LINK and a one-to-many relationship between B and LINK, where LINK is an intersection entity type.

A link record is an implementation of such an intersection entity type. Link records have no data fields, only foreign key fields.