Table | cm_sql_sources |
|---|---|
Description | SQL Organizational Identity Sources |
Plugin |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
org_identity_source_id | integer, foreign key | Organizational Identity Source ID | ||
| server_id | integer, foreign key | Server ID for SQL Server | cm_servers:id | Note foreign key is to Server model, not to SqlServer model |
| table_mode | varchar(2) | Table Mode |
| |
source_table | varchar(80) | Source Table Name | Used as a prefix in Relational mode | |
| address_type | varchar(32) | Type to assign to Address | cm_identifiers:identifier | Only used for Flat mode |
| email_address_type | varchar(32) | Type to assign to Email Address | cm_identifiers:identifier | Only used for Flat mode |
| identifier_type | varchar(32) | Type to assign to Identifier | cm_identifiers:identifier | Only used for Flat mode |
| name_type | varchar(32) | Type to assign to Name | cm_identifiers:identifier | Only used for Flat mode |
| telephone_number_type | varchar(32) | Type to assign to Telephone Number | cm_identifiers:identifier | Only used for Flat mode |
| url_type | varchar(32) | Type to assign to URL | cm_identifiers:identifier | Only used for Flat mode |