Table: History_Of_Contact
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
contact_KEYintNOT NULL
namenvarchar (250)NOT NULL
companynvarchar (250)NOT NULL
titlenvarchar (250)NOT NULL
salutationnvarchar (40)NOT NULL
urlnvarchar (2048)NOT NULL
phone_positionnvarchar (14)NOT NULL
address_positionnvarchar (4)NOT NULL
email_positionnvarchar (6)NOT NULL
primary__contact_phone_type_KEYintNOT NULL
primary__contact_address_type_KEYintNOT NULL
mailing__contact_address_type_KEYintNOT NULL
contact_type_KEYintNOT NULL
file_asnvarchar (250)NOT NULL
contact_guiduniqueidentifierNOT NULL
primary__contact_email_type_KEYintNOT NULL
portal_user_KEYint
preferred_localenvarchar (50)NOT NULL
time_zone_KEYsmallint (5)NOT NULL
digita_entityiduniqueidentifier
digita_metadatanvarchar (-1)
Primary key
NameColumnsDescription
PK_History_Of_Contact$contact_KEY$create__changeset_KEY$revise__changeset_KEYcontact_KEY, create__changeset_KEY, revise__changeset_KEYCLUSTERED

Schema diagram