RelDefGroupLink Table (49)
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
User group link table for RelDef, for MDO item hiding
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| reldefgrouplink_id | Primary key | PK | |
| reldef_id | Link to RelDef list table | FK relationdefinition | |
| group_id | Link to Group table | FK UserGroup | |
| 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 |
|---|---|---|
| reldefgrouplink_id | PK | Clustered, Unique |
| reldef_id | FK | Index |
| group_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| 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". |
| UserGroup | Secondary user groups |
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.