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 |