| Latest revision |
Your text |
| Line 2: |
Line 2: |
| | | | |
| | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| − | |- valign="top" | + | |- |
| | | '''Table | | | '''Table |
| | | Person.Address | | | Person.Address |
| − | |- valign="top" | + | |- |
| − | | '''Description
| |
| − | | Street address information for customers, employees, and vendors.
| |
| | |} | | |} |
| | | | |
| − | === Columns ===
| + | |
| | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| | |- style="background:silver" | | |- style="background:silver" |
| Line 17: |
Line 15: |
| | | '''Nullable | | | '''Nullable |
| | | '''Default | | | '''Default |
| − | | '''Description | + | | '''PK |
| − | | + | | '''Index |
| − | |- valign="top" | + | |
| | + | |- |
| | | AddressID | | | AddressID |
| | | int | | | int |
| | | not null | | | not null |
| | | | | | |
| − | | Primary key for Address records. | + | | PK_Address_AddressID |
| − | |- valign="top" | + | | |
| | + | |- |
| | | AddressLine1 | | | AddressLine1 |
| | | nvarchar(60) | | | nvarchar(60) |
| | | not null | | | not null |
| | | | | | |
| − | | First street address line. | + | | |
| − | |- valign="top" | + | | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| | + | |- |
| | | AddressLine2 | | | AddressLine2 |
| | | nvarchar(60) | | | nvarchar(60) |
| | | null | | | null |
| | | | | | |
| − | | Second street address line. | + | | |
| − | |- valign="top" | + | | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| | + | |- |
| | | City | | | City |
| | | nvarchar(30) | | | nvarchar(30) |
| | | not null | | | not null |
| | | | | | |
| − | | Name of the city. | + | | |
| − | |- valign="top" | + | | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| | + | |- |
| | | StateProvinceID | | | StateProvinceID |
| | | int | | | int |
| | | not null | | | not null |
| | | | | | |
| − | | Unique identification number for the state or province. Foreign key to StateProvince table. | + | | |
| − | |- valign="top" | + | | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID |
| | + | |- |
| | | PostalCode | | | PostalCode |
| | | nvarchar(15) | | | nvarchar(15) |
| | | not null | | | not null |
| | | | | | |
| − | | Postal code for the street address. | + | | |
| − | |- valign="top" | + | | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| | + | |- |
| | | rowguid | | | rowguid |
| | | uniqueidentifier | | | uniqueidentifier |
| | | not null | | | not null |
| | | (newid()) | | | (newid()) |
| − | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | + | | |
| − | |- valign="top" | + | | AK_Address_rowguid |
| | + | |- |
| | | ModifiedDate | | | ModifiedDate |
| | | datetime | | | datetime |
| | | not null | | | not null |
| | | (getdate()) | | | (getdate()) |
| − | | Date and time the record was last updated.
| |
| − | |}
| |
| − |
| |
| − | === Primary Key ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Primary Key
| |
| − | | '''Columns
| |
| − | |- valign="top"
| |
| − | | PK_Address_AddressID
| |
| − | | AddressID
| |
| − | |}
| |
| − |
| |
| − | === Indexes ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Index
| |
| − | | '''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
| |
| | | | | | |
| − | | StateProvinceID
| |
| − | |}
| |
| − |
| |
| − | === Foreign Keys ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Relation
| |
| − | | '''Column
| |
| − | | '''Referenced Column
| |
| − |
| |
| − | |- valign="top"
| |
| − | | [[Person.StateProvince_(table)|Person.StateProvince]]
| |
| − | | StateProvinceID
| |
| − | | StateProvinceID
| |
| − | |}
| |
| − |
| |
| − | === Detail Tables ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Detail Table
| |
| − | | '''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
| |
| − | | AddressID
| |
| − | |}
| |
| − |
| |
| − | === References ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Dependency Type
| |
| − | | '''Object Type
| |
| − | | '''Referenced Object
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Schema
| |
| − | | Schema
| |
| − | | [[Person_(schema)|Person]]
| |
| − |
| |
| − | |}
| |
| − |
| |
| − | === Dependencies ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''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
| |
| − | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
| |
| − |
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | == automatically generated ==
| |
| − |
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |-
| |
| − | | '''Table
| |
| − | | Person.Address
| |
| − | |- valign="top"
| |
| − | | '''Description
| |
| − | | Street address information for customers, employees, and vendors.
| |
| − | |-
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Column
| |
| − | | '''Data Type
| |
| − | | '''Nullable
| |
| − | | '''Default
| |
| − | | '''Description / PK / Index
| |
| − |
| |
| − | |- valign="top"
| |
| − | | AddressID
| |
| − | | int
| |
| − | | not null
| |
| − | |
| |
| − | | 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
| |
| − | |- valign="top"
| |
| − | | AddressLine2
| |
| − | | nvarchar(60)
| |
| − | | null
| |
| − | |
| |
| − | | Second street address line.<br />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
| |
| − | |- 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
| |
| − | |- valign="top"
| |
| − | | PostalCode
| |
| − | | nvarchar(15)
| |
| − | | not null
| |
| − | |
| |
| − | | Postal code for the street address.<br />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
| |
| − | |- valign="top"
| |
| − | | ModifiedDate
| |
| − | | datetime
| |
| − | | not null
| |
| − | | (GETDATE())
| |
| − | | Date and time the record was last updated.<br />
| |
| | |} | | |} |
| | | | |
| Line 303: |
Line 117: |
| | | AddressID | | | AddressID |
| | | AddressID | | | AddressID |
| − | |}
| |
| − |
| |
| − |
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Dependency Type
| |
| − | | '''Object Type
| |
| − | | '''Referenced Object
| |
| − |
| |
| − | |-
| |
| − | | Schema
| |
| − | | Schema
| |
| − | | [[Person_(schema)|Person]]
| |
| − |
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''Referencing Object
| |
| − |
| |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
| |
| − |
| |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
| |
| − |
| |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
| |
| − |
| |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
| |
| − |
| |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
| |
| − |
| |
| | |} | | |} |
