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

relationtarget Table (51)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

Definition of targets for a relation. Links a relation definition (RelDef) to source and target tables. In general, a relation can be created between any pair of tables. This table is used for specifying which table pairs a particular relation can be used for. A relation definition should have at least one row in this table, and can have more. Note; The 5.0 Maintenance and GUI only support contact and person as valid values for the source_table and destination_table fields, in any combination. Other relations will not be shown, and relation definitions pointing to other tables will not be editable from the Maintenance GUI; however, nothing will crash.

Fields

Name Description Type Null
reltarget_id Primary key PK
reldef_id Reference to definition FK relationdefinition
source_table Source table number (contact/person in 5.0) TableNumber
destination_table Target table number (contact/person in 5.0) TableNumber
bidirectional Is relation bidirectional UShort ●
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

relationtarget table relationship diagram

Indexes

Fields Types Description
reltarget_id PK Clustered, Unique
reldef_id FK Index
source_table TableNumber Index
destination_table TableNumber Index
bidirectional UShort 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".

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