> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ImportRelation table

> Relations between import objects

## ImportRelation Table (188)

Relations between import objects

## Fields

| Name                      | Description                                                                                                                                             | Type                                  | Nullable |
| ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------- | :------: |
| ImportRelation\_id        | Primary key                                                                                                                                             | PK                                    |    No    |
| source                    | The dependent object (source of relation edge)                                                                                                          | FK [ImportObject](./importobject.mdx) |    No    |
| target                    | The primary object (target of relation edge)                                                                                                            | FK [ImportObject](./importobject.mdx) |    No    |
| edgeColour                | 1=Red, 2=Black                                                                                                                                          | UShort                                |    No    |
| 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                               |    No    |
| forcePrimary              | 1=Forces creation of primary object as soon as dependent is created                                                                                     | UShort                                |    No    |
| registered                | Registered when                                                                                                                                         | UtcDateTime                           |    No    |
| registered\_associate\_id | Registered by whom                                                                                                                                      | FK [associate](./associate.mdx)       |    No    |
| updated                   | Last updated when                                                                                                                                       | UtcDateTime                           |    No    |
| updated\_associate\_id    | Last updated by whom                                                                                                                                    | FK [associate](./associate.mdx)       |    No    |
| updatedCount              | Number of updates made to this record                                                                                                                   | UShort                                |    No    |
| isBuiltin                 | 1 = This row populated and maintained by SuperOffice                                                                                                    | UShort                                |    Yes   |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/ImportRelation.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=70c4bb381e82c077cc90613109a7429e" alt="ImportRelation table relationship diagram" width="699" height="59" data-path="media/loc/en/database/tables/ImportRelation.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |
| source | FK    | Index       |
| target | FK    | Index       |

## Relationships

| Table                          | Description                                                        |
| ------------------------------ | ------------------------------------------------------------------ |
| [associate](./associate)       | Employees, resources and other users - except for External persons |
| [ImportObject](./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.


## Related topics

- [ImportObject table](/en/database/tables/importobject.md)
- [ImportDefault table](/en/database/tables/importdefault.md)
- [ImportField table](/en/database/tables/importfield.md)
- [locking table](/en/database/tables/locking.md)
- [mail_in_filter table](/en/database/tables/mail-in-filter.md)
- [Export and import of typical search](/en/api/search/find-selection/import-export-typical-search.md)