Table: History_Of_Contact | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
revise__changeset_KEY | int | NOT NULL | |
history_action_KEY | tinyint (3) | NOT NULL | |
contact_KEY | int | NOT NULL | |
name | nvarchar (250) | NOT NULL | |
company | nvarchar (250) | NOT NULL | |
title | nvarchar (250) | NOT NULL | |
salutation | nvarchar (40) | NOT NULL | |
url | nvarchar (2048) | NOT NULL | |
phone_position | nvarchar (14) | NOT NULL | |
address_position | nvarchar (4) | NOT NULL | |
email_position | nvarchar (6) | NOT NULL | |
primary__contact_phone_type_KEY | int | NOT NULL | |
primary__contact_address_type_KEY | int | NOT NULL | |
mailing__contact_address_type_KEY | int | NOT NULL | |
contact_type_KEY | int | NOT NULL | |
file_as | nvarchar (250) | NOT NULL | |
contact_guid | uniqueidentifier | NOT NULL | |
primary__contact_email_type_KEY | int | NOT NULL | |
portal_user_KEY | int | ||
preferred_locale | nvarchar (50) | NOT NULL | |
time_zone_KEY | smallint (5) | NOT NULL | |
digita_entityid | uniqueidentifier | ||
digita_metadata | nvarchar (-1) |
Primary key | |||
Name | Columns | Description | |
PK_History_Of_Contact$contact_KEY$create__changeset_KEY$revise__changeset_KEY | contact_KEY, create__changeset_KEY, revise__changeset_KEY | CLUSTERED |