Difference between revisions of "Sales.CustomerAddress (table)"

From dbscript Online Help
Jump to: navigation, search
 
(8 intermediate revisions by the same user not shown)
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
 
| Sales.CustomerAddress
 
| Sales.CustomerAddress
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping customers to their address(es).
 
|}
 
|}
  
−
 
+
=== 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 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| CustomerID
 
| CustomerID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_CustomerAddress_CustomerID_AddressID
+
| Primary key. Foreign key to Customer.CustomerID.
−
|
+
|- valign="top"
−
|-
 
 
| AddressID
 
| AddressID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_CustomerAddress_CustomerID_AddressID
+
| Primary key. Foreign key to Address.AddressID.
−
|
+
|- valign="top"
−
|-
 
 
| AddressTypeID
 
| AddressTypeID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Address type. Foreign key to AddressType.AddressTypeID.
−
|
+
|- valign="top"
−
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (newid())
 
| (newid())
−
|  
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
−
| AK_CustomerAddress_rowguid
+
|- valign="top"
−
|-
 
 
| 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_CustomerAddress_CustomerID_AddressID
 +
| CustomerID, AddressID
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_CustomerAddress_rowguid
 +
| Unique
 +
| rowguid
 +
|}
 +
 +
=== Foreign Keys ===
 
{| 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 62: Line 80:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Person.Address_(table)|Person.Address]]
 
| [[Person.Address_(table)|Person.Address]]
 
| AddressID
 
| AddressID
 
| AddressID
 
| AddressID
−
|-
+
|- valign="top"
 
| [[Person.AddressType_(table)|Person.AddressType]]
 
| [[Person.AddressType_(table)|Person.AddressType]]
 
| AddressTypeID
 
| AddressTypeID
 
| AddressTypeID
 
| AddressTypeID
−
|-
+
|- valign="top"
 
| [[Sales.Customer_(table)|Sales.Customer]]
 
| [[Sales.Customer_(table)|Sales.Customer]]
 
| CustomerID
 
| CustomerID
 
| CustomerID
 
| CustomerID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 82: Line 135:
 
| '''Table
 
| '''Table
 
| Sales.CustomerAddress
 
| Sales.CustomerAddress
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Cross-reference table mapping customers to their address(es).
 
| Cross-reference table mapping customers to their address(es).
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 156: Line 207:
 
{| 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"
−
| '''Referencing Object
+
| '''Dependency Type
 
| '''Object Type
 
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 
| '''Reference Type
 
| '''Reference Type
−
+
| '''Object Type
 +
| '''Referencing Object
 +
 
 
|-
 
|-
 +
| Select
 +
| View
 
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|-
 +
| Select
 
| View
 
| View
−
| Select
 
−
|-
 
 
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
−
| View
+
 
−
| Select
 
 
|}
 
|}

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Sales.CustomerAddress
Description Cross-reference table mapping customers to their address(es).

Columns[edit]

Column Data Type Nullable Default Description
CustomerID int not null Primary key. Foreign key to Customer.CustomerID.
AddressID int not null Primary key. Foreign key to Address.AddressID.
AddressTypeID int not null Address type. Foreign key to AddressType.AddressTypeID.
rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_CustomerAddress_CustomerID_AddressID CustomerID, AddressID

Indexes[edit]

Index Type Columns
AK_CustomerAddress_rowguid Unique rowguid

Foreign Keys[edit]

Relation Column Referenced Column
Person.Address AddressID AddressID
Person.AddressType AddressTypeID AddressTypeID
Sales.Customer CustomerID CustomerID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales

Dependencies[edit]

Reference Type Object Type Referencing Object
Select View Sales.vIndividualCustomer
Select View Sales.vStoreWithDemographics


automatically generated[edit]

Table Sales.CustomerAddress
Description Cross-reference table mapping customers to their address(es).


Column Data Type Nullable Default Description / PK / Index
CustomerID int not null Primary key. Foreign key to Customer.CustomerID.
PK_CustomerAddress_CustomerID_AddressID
AddressID int not null Primary key. Foreign key to Address.AddressID.
PK_CustomerAddress_CustomerID_AddressID
AddressTypeID int not null Address type. Foreign key to AddressType.AddressTypeID.
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_CustomerAddress_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.Address AddressID AddressID
Person.AddressType AddressTypeID AddressTypeID
Sales.Customer CustomerID CustomerID


Dependency Type Object Type Referenced Object
Schema Schema Sales


Reference Type Object Type Referencing Object
Select View Sales.vIndividualCustomer
Select View Sales.vStoreWithDemographics
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.CustomerAddress_(table)&oldid=2665"