Person.AddressType
Documentation | AdventureWorks |
Schema | Person |
Name | AddressType |
Module | People |
Types of addresses stored in the Address table.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | AddressTypeID | int | Identity | Primary key for AddressType records. | ||||
Primary key for AddressType records. Identity |
||||||||
2 | Name | nvarchar(50) | Address type description. For example, Billing, Home, or Shipping. | |||||
Address type description. For example, Billing, Home, or Shipping. |
||||||||
3 | rowguid | uniqueidentifier | Default: newid() | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | ||||
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid() |
||||||||
4 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
Date and time the record was last updated. Default: getdate() |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Person.BusinessEntityAddress | Person.AddressType | Person.BusinessEntityAddress.AddressTypeID = Person.AddressType.AddressTypeID | FK_BusinessEntityAddress_AddressType_AddressTypeID Foreign key constraint referencing AddressType.AddressTypeID. |
|
Person.BusinessEntityAddress.AddressTypeID = Person.AddressType.AddressTypeID Name: FK_BusinessEntityAddress_AddressType_AddressTypeIDForeign key constraint referencing AddressType.AddressTypeID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_AddressType_AddressTypeID | AddressTypeID | Primary key (clustered) constraint | |
Primary key (clustered) constraint | |||
AK_AddressType_Name | Name | Unique nonclustered index. | |
Unique nonclustered index. | |||
AK_AddressType_rowguid | rowguid | Unique nonclustered index. Used to support replication samples. | |
Unique nonclustered index. Used to support replication samples. |
Used by
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56