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 | Only used for Flat mode | |
| email_address_type | varchar(32) | Type to assign to Email Address | Only used for Flat mode | |
| identifier_type | varchar(32) | Type to assign to Identifier | Only used for Flat mode | |
| name_type | varchar(32) | Type to assign to Name | Only used for Flat mode | |
| telephone_number_type | varchar(32) | Type to assign to Telephone Number | Only used for Flat mode | |
| url_type | varchar(32) | Type to assign to URL | Only used for Flat mode |
Overview
Content Tools