| Column | Data Type | Nullable | Default | Description / PK / Index |
| CustomerID | int | not null | | Primary key for Customer records.
PK_Customer_CustomerID |
| TerritoryID | int | null | | ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
IX_Customer_TerritoryID |
| AccountNumber | | | | Unique number identifying the customer assigned by the accounting system.
AK_Customer_AccountNumber |
| CustomerType | nchar(1) | not null | | Customer type: I = Individual, S = Store
|
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Customer_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|