Table: History_Of_Contact_Address
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_address_KEY | int | NOT NULL |
contact_KEY | int | NOT NULL |
contact_address_type_KEY | int | NOT NULL |
address_1 | nvarchar (40) | NOT NULL |
address_2 | nvarchar (40) | NOT NULL |
city | nvarchar (40) | NOT NULL |
state_abbreviation | nvarchar (2) | NOT NULL |
postal_code | nvarchar (10) | NOT NULL |
county | nvarchar (25) | NOT NULL |
country | nvarchar (25) | NOT NULL |
address_3 | nvarchar (128) | NOT NULL |

Primary key
Name | Columns | Description
PK_History_Of_Contact_Address$contact_address_KEY$create__changeset_KEY$revise__changeset_KEY | contact_address_KEY, create__changeset_KEY, revise__changeset_KEY | CLUSTERED