Table | sql_sources |
|---|---|
Description | SQL Source definitions |
| Plugin | SQL Source Plugin |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
external_identity_source_id | integer, foreign key | External Identity Source ID | | ||
| server_id | integer, foreign key | Server ID, of type SQL | servers:id | | |
| table_mode | varchar(2) | Table Mode |
| | |
source_table | varchar(80) | Source Table Name | | Used as a prefix in Relational mode | |
| address_type_id | integer, foreign key | Type to assign to Address | types:id | Only used for Flat mode | |
| email_address_type_id | integer, foreign key | Type to assign to Email Address | types:id | Only used for Flat mode | |
| identifier_type_id | integer, foreign key | Type to assign to Identifier | types:id | Only used for Flat mode | |
| name_type_id | integer, foreign key | Type to assign to Name | types:id | Only used for Flat mode | |
| pronouns_type_id | integer, foreign key | Type to assign to Pronouns | types:id | Only used for Flat mode | |
| telephone_number_type_id | integer, foreign key | Type to assign to Telephone Number | types:id | Only used for Flat mode | |
| url_type_id | integer, foreign key | Type to assign to URL | types:id | Only used for Flat mode | |
| threshold_check | integer | Percentage of changed records to abort a sync job | |||
| threshold_override | boolean | Whether to ignore threshold_check for the next sync job |
|