AdventureWorks
| Table Name: | Sales.CustomerAddress |
| Description: | Cross-reference table mapping customers to their address(es). |
| Primary Keys: | CustomerID AddressID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| CustomerID | int | None | No | Primary key. Foreign key to Customer.CustomerID. |
| AddressID | int | None | No | Primary key. Foreign key to Address.AddressID. |
| AddressTypeID | int | None | No | Address type. Foreign key to AddressType.AddressTypeID. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_CustomerAddress_CustomerID_AddressID | Yes | Yes | CustomerID AddressID |
| AK_CustomerAddress_rowguid | No | Yes | rowguid |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_CustomerAddress_Address_AddressID | AddressID | Person.Address |
| FK_CustomerAddress_AddressType_AddressTypeID | AddressTypeID | Person.AddressType |
| FK_CustomerAddress_Customer_CustomerID | CustomerID | Sales.Customer |