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

ImportRelation Table (188)

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

Relations between import objects

Fields

Name Description Type Null
ImportRelation_id Primary key PK
source The dependent object (source of relation edge) FK ImportObject
target The primary object (target of relation edge) FK ImportObject
edgeColour 1=Red, 2=Black UShort
foreignKey The database field ID of the foreign key field in the dependent table. NOTE If it is 0, it means this relation should NOT lead to an edge in the graph. FieldId
forcePrimary 1=Forces creation of primary object as soon as dependent is created 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
isBuiltin 1 = This row populated and maintained by SuperOffice UShort ●

ImportRelation table relationship diagram

Indexes

Fields Types Description
ImportRelation_id PK Clustered, Unique
source FK Index
target FK Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
ImportObject Import object types - see localetext for names.

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