Person.Address (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:16Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:23Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:00Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:39Z

Bot at 05:38, 30 November 2009

2009-11-30T05:38:50Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:17Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:17Z

Bot at 23:09, 26 November 2009

2009-11-26T23:09:40Z

Bot at 22:56, 26 November 2009

2009-11-26T22:56:39Z

Bot at 22:52, 26 November 2009

2009-11-26T22:52:18Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Person.Address
@@ Line 8: / Line 8: @@
 | '''Description
 | Street address information for customers, employees, and vendors.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | AddressID
@@ Line 76: / Line 74: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Address_AddressID
 | AddressID
@@ Line 87: / Line 85: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_Address_rowguid
 | Unique
 | rowguid
-|-
+|- valign="top"
 | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
 | Unique
 | AddressLine1, AddressLine2, City, StateProvinceID, PostalCode
-|-
+|- valign="top"
 | IX_Address_StateProvinceID
+|
@@ Line 108: / Line 106: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.StateProvince_(table)|Person.StateProvince]]
 | StateProvinceID
@@ Line 121: / Line 119: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
 | AddressID
 | AddressID
-|-
+|- valign="top"
 | [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
 | AddressID
 | AddressID
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | AddressID
 | BillToAddressID
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | AddressID
 | ShipToAddressID
-|-
+|- valign="top"
 | [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
 | AddressID
@@ Line 151: / Line 149: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 165: / Line 163: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
-|-
+|- valign="top"
 | Select
 | View
 | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
-|-
+|- valign="top"
 | Select
 | View
 | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
-|-
+|- valign="top"
 | Select
 | View
 | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
-|-
+|- valign="top"
 | Select
 | View

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for Address records.<br />PK_Address_AddressID
+| Primary key for Address records.
 |- valign="top"
 | AddressLine1
@@ Line 31: / Line 32: @@
 | not null
+|
-| First street address line.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+| First street address line.
 |- valign="top"
 | AddressLine2
@@ Line 37: / Line 38: @@
 | null
+|
-| Second street address line.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+| Second street address line.
 |- valign="top"
 | City
@@ Line 43: / Line 44: @@
 | not null
+|
-| Name of the city.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+| Name of the city.
 |- valign="top"
 | StateProvinceID
@@ Line 49: / Line 50: @@
 | not null
+|
-| Unique identification number for the state or province. Foreign key to StateProvince table.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID
+| Unique identification number for the state or province. Foreign key to StateProvince table.
 |- valign="top"
 | PostalCode
@@ Line 55: / Line 56: @@
 | not null
+|
-| Postal code for the street address.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+| Postal code for the street address.
 |- valign="top"
 | rowguid
@@ Line 61: / Line 62: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Address_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 67: / Line 68: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 84: / Line 115: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 113: / Line 144: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 146: / Line 191: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Person.Address
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | AddressID
 | int
 | not null
+|
-| PK_Address_AddressID
+| Primary key for Address records.<br />PK_Address_AddressID
+|- valign="top"
 | AddressLine1
 | nvarchar(60)
 | not null
+|
+| First street address line.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
-| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+|- valign="top"
 | AddressLine2
 | nvarchar(60)
 | null
+|
+| Second street address line.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
-| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+|- valign="top"
 | City
 | nvarchar(30)
 | not null
+|
+| Name of the city.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
-| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+|- valign="top"
 | StateProvinceID
 | int
 | not null
+|
+| Unique identification number for the state or province. Foreign key to StateProvince table.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID
-| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID
+|- valign="top"
 | PostalCode
 | nvarchar(15)
 | not null
+|
+| Postal code for the street address.<br />IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
-| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Address_rowguid
-| AK_Address_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 118: / Line 112: @@
 | AddressID
 |}
 == automatically generated ==

@@ Line 125: / Line 125: @@
 | Person.Address
 |- valign="top"
 | '''Description
 | Street address information for customers, employees, and vendors.
 |-
 |}

@@ Line 237: / Line 237: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}
@@ Line 250: / Line 251: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 | View
 | Select
 |-
-| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
+| Select
 | View
-| Select
+| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 |-
 | Select
 | View
 | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
-| View
 |}

@@ Line 232: / Line 232: @@
 | AddressID
 | AddressID
 |}
@@ Line 240: / Line 253: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]