| Column | Data Type | Nullable | Default | Description / PK / Index |
| CustomerID | int | not null | | Store identification number. Foreign key to Customer.CustomerID.
PK_StoreContact_CustomerID_ContactID |
| ContactID | int | not null | | Contact (store employee) identification number. Foreign key to Contact.ContactID.
PK_StoreContact_CustomerID_ContactIDIX_StoreContact_ContactID |
| ContactTypeID | int | not null | | Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.
IX_StoreContact_ContactTypeID |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_StoreContact_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|