AdventureWorks
| Table Name: | Person.AddressType |
| Description: | Types of addresses stored in the Address table. |
| Primary Keys: | AddressTypeID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| AddressTypeID | int - Identity | None | No | Primary key for AddressType records. |
| Name | nvarchar (50) | None | No | Address type description. For example, Billing, Home, or Shipping. |
| 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_AddressType_AddressTypeID | Yes | Yes | AddressTypeID |
| AK_AddressType_rowguid | No | Yes | rowguid |
| AK_AddressType_Name | No | Yes | Name |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_CustomerAddress_AddressType_AddressTypeID | Sales.CustomerAddress | AddressTypeID |
| FK_VendorAddress_AddressType_AddressTypeID | Purchasing.VendorAddress | AddressTypeID |