ImportRelation Table (188)
•
Environment: onsite, online
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 | ● |
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.