AdventureWorks Database > Person Schema : Person.AddressType Table |
Creation Date | 08/01/2010 08:40 |
File Group | PRIMARY |
Text File Group | |
System Object | ![]() |
Published for Replication | ![]() |
Rows | 6 |
Data Space Used | 8.00 KB |
Index Space Used | 40.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
![]() | AddressTypeID | Primary key for AddressType records. | int | 4 | |||
Name | Address type description. For example, Billing, Home, or Shipping. | dbo.Name | 50 | ||||
rowguid | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | uniqueidentifier | 16 | (newid()) | |||
ModifiedDate | Date and time the record was last updated. | datetime | 4 | (getdate()) |
Index | Description | Primary | Unique |
---|---|---|---|
AK_AddressType_Name | Unique nonclustered index. | ![]() | |
AK_AddressType_rowguid | Unique nonclustered index. Used to support replication samples. | ![]() | |
PK_AddressType_AddressTypeID | Primary key (clustered) constraint | ![]() | ![]() |
Relationship | Description |
---|---|
FK_CustomerAddress_AddressType_AddressTypeID | Foreign key constraint referencing AddressType.AddressTypeID. |
FK_VendorAddress_AddressType_AddressTypeID | Foreign key constraint referencing AddressType.AddressTypeID. |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | Sales.CustomerAddress | Table | Cross-reference table mapping customers to their address(es). | 1 |
![]() | Purchasing.VendorAddress | Table | Cross-reference mapping vendors and addresses. | 1 |
![]() | Sales.vIndividualCustomer | View | Individual customers (names and addresses) that purchase Adventure Works Cycles products online. | 1 |
![]() | Sales.vStoreWithDemographics | View | Stores (names and addresses) that sell Adventure Works Cycles products to consumers. | 1 |
![]() | Purchasing.vVendor | View | Vendor (company) names and addresses and the names of vendor employees to contact. | 2 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | dbo.Name | User Defined Data Type | 1 |
|