Difference between revisions of "Person.Address (table)"

From dbscript Online Help
Jump to: navigation, search
Line 118: Line 118:
 
| AddressID
 
| AddressID
 
|}
 
|}
−
 
 
== automatically generated ==
 
== automatically generated ==
  
Line 140: Line 139:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
 
|-
 
|-
Line 148: Line 146:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Address records.
+
| Primary key for Address records.PK_Address_AddressID
−
| PK_Address_AddressID
 
 
|-
 
|-
 
| AddressLine1
 
| AddressLine1
Line 155: Line 152:
 
| not null
 
| not null
 
|  
 
|  
−
| First street address line.
+
| First street address line.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
−
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
 
 
|-
 
|-
 
| AddressLine2
 
| AddressLine2
Line 162: Line 158:
 
| null
 
| null
 
|  
 
|  
−
| Second street address line.
+
| Second street address line.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
−
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
 
 
|-
 
|-
 
| City
 
| City
Line 169: Line 164:
 
| not null
 
| not null
 
|  
 
|  
−
| Name of the city.
+
| Name of the city.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
−
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
 
 
|-
 
|-
 
| StateProvinceID
 
| StateProvinceID
Line 176: Line 170:
 
| not null
 
| not null
 
|  
 
|  
−
| Unique identification number for the state or province. Foreign key to StateProvince table.
+
| Unique identification number for the state or province. Foreign key to StateProvince table.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID
−
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID
 
 
|-
 
|-
 
| PostalCode
 
| PostalCode
Line 183: Line 176:
 
| not null
 
| not null
 
|  
 
|  
−
| Postal code for the street address.
+
| Postal code for the street address.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
−
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
 
 
|-
 
|-
 
| rowguid
 
| rowguid
Line 190: Line 182:
 
| not null
 
| not null
 
| (NEWID())
 
| (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.AK_Address_rowguid
−
| AK_Address_rowguid
 
 
|-
 
|-
 
| ModifiedDate
 
| ModifiedDate
Line 198: Line 189:
 
| (GETDATE())
 
| (GETDATE())
 
| Date and time the record was last updated.
 
| Date and time the record was last updated.
−
|
 
 
|}
 
|}
  
Line 242: Line 232:
 
| AddressID
 
| AddressID
 
| AddressID
 
| AddressID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referencing Object
 +
| '''Object Type
 +
| '''Reference Type
 +
 +
|-
 +
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
| View
 +
| Select
 +
|-
 +
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
 +
| View
 +
| Select
 +
|-
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
| View
 +
| Select
 +
|-
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
| View
 +
| Select
 +
|-
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
| View
 +
| Select
 
|}
 
|}

Revision as of 00:52, 27 November 2009

wikibot

Table Person.Address


Column Data Type Nullable Default PK Index
AddressID int not null PK_Address_AddressID
AddressLine1 nvarchar(60) not null IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
AddressLine2 nvarchar(60) null IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
City nvarchar(30) not null IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
StateProvinceID int not null IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID
PostalCode nvarchar(15) not null IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
rowguid uniqueidentifier not null (newid()) AK_Address_rowguid
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Person.StateProvince StateProvinceID StateProvinceID


Detail Table Column Referencing Column
Sales.CustomerAddress AddressID AddressID
HumanResources.EmployeeAddress AddressID AddressID
Sales.SalesOrderHeader AddressID BillToAddressID
Sales.SalesOrderHeader AddressID ShipToAddressID
Purchasing.VendorAddress AddressID AddressID

automatically generated

Table Person.Address
Description Street address information for customers, employees, and vendors.


Column Data Type Nullable Default Description / PK / Index
AddressID int not null Primary key for Address records.PK_Address_AddressID
AddressLine1 nvarchar(60) not null First street address line.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
AddressLine2 nvarchar(60) null Second street address line.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
City nvarchar(30) not null Name of the city.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
StateProvinceID int not null Unique identification number for the state or province. Foreign key to StateProvince table.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID
PostalCode nvarchar(15) not null Postal code for the street address.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_Address_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.StateProvince StateProvinceID StateProvinceID


Detail Table Column Referencing Column
Sales.CustomerAddress AddressID AddressID
HumanResources.EmployeeAddress AddressID AddressID
Sales.SalesOrderHeader AddressID BillToAddressID
Sales.SalesOrderHeader AddressID ShipToAddressID
Purchasing.VendorAddress AddressID AddressID


Referencing Object Object Type Reference Type
HumanResources.vEmployee View Select
Purchasing.vVendor View Select
Sales.vIndividualCustomer View Select
Sales.vSalesPerson View Select
Sales.vStoreWithDemographics View Select
Retrieved from "http://dbshelp.devio.at/index.php?title=Person.Address_(table)&oldid=1174"