| Column | Data Type | Nullable | Default | Description / PK / Index |
| CustomerID | int | not null | | Primary key. Foreign key to Customer.CustomerID.
PK_Store_CustomerID |
| Name | dbo.Name | not null | | Name of the store.
|
| SalesPersonID | int | null | | ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID.
IX_Store_SalesPersonID |
| Demographics | xml | null | | Demographic informationg about the store such as the number of employees, annual sales and store type.
PXML_Store_Demographics |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Store_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|