• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

RelDefHeadingLink Table (50)

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

RelDefHeadingLink table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top