RelDefHeadingLink Table (50)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
Heading link table for RelDef, for MDO headers
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| reldefheadinglink_id | Primary key | PK | |
| reldef_id | Link to RelDef list table | FK relationdefinition | |
| heading_id | Link to Heading table | FK Heading | |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| reldefheadinglink_id | PK | Clustered, Unique |
| reldef_id | FK | Index |
| heading_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| Heading | Heading items for all MDO lists, lists that are grouped and filtered. |
| relationdefinition | Definition of a relation. This table defines the relations that can exist in the database. Each relation has an active text and a passive text. The table RelationTarget specifies which pairs of tables this relation can connect. Use of the active and passive texts is dependent on which direction the relation is viewed in, e.g., active text = "Owns" and passive text = "Is owned by". |
Replication Flags
- Replicate changes DOWN from central to satellites and travellers.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.