AdventureWorks
| Table Name: | Person.Address |
| Description: | Street address information for customers, employees, and vendors. |
| Primary Keys: | AddressID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| AddressID | int - Identity | None | No | Primary key for Address records. |
| AddressLine1 | nvarchar (60) | None | No | First street address line. |
| AddressLine2 | nvarchar (60) | None | Yes | Second street address line. |
| City | nvarchar (30) | None | No | Name of the city. |
| StateProvinceID | int | None | No | Unique identification number for the state or province. Foreign key to StateProvince table. |
| PostalCode | nvarchar (15) | None | No | Postal code for the street address. |
| 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_Address_AddressID | Yes | Yes | AddressID |
| AK_Address_rowguid | No | Yes | rowguid |
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode | No | Yes | AddressLine1 AddressLine2 City StateProvinceID PostalCode |
| IX_Address_StateProvinceID | No | No | StateProvinceID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_Address_StateProvince_StateProvinceID | StateProvinceID | Person.StateProvince |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_CustomerAddress_Address_AddressID | Sales.CustomerAddress | AddressID |
| FK_EmployeeAddress_Address_AddressID | HumanResources.EmployeeAddress | AddressID |
| FK_SalesOrderHeader_Address_BillToAddressID | Sales.SalesOrderHeader | BillToAddressID |
| FK_SalesOrderHeader_Address_ShipToAddressID | Sales.SalesOrderHeader | ShipToAddressID |
| FK_VendorAddress_Address_AddressID | Purchasing.VendorAddress | AddressID |