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

From dbscript Online Help
Jump to: navigation, search
Line 5: Line 5:
 
| '''Table
 
| '''Table
 
| Sales.CustomerAddress
 
| Sales.CustomerAddress
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping customers to their address(es).
 
|-
 
|-
 
|}
 
|}
Line 15: Line 18:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description / PK / Index
| '''Index
 
 
 
|-
+
|- valign="top"
 
| CustomerID
 
| CustomerID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_CustomerAddress_CustomerID_AddressID
+
| Primary key. Foreign key to Customer.CustomerID.<br />PK_CustomerAddress_CustomerID_AddressID
|
+
|- valign="top"
|-
 
 
| AddressID
 
| AddressID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_CustomerAddress_CustomerID_AddressID
+
| Primary key. Foreign key to Address.AddressID.<br />PK_CustomerAddress_CustomerID_AddressID
|
+
|- valign="top"
|-
 
 
| AddressTypeID
 
| AddressTypeID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
|  
+
| Address type. Foreign key to AddressType.AddressTypeID.<br />
|
+
|- 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.<br />AK_CustomerAddress_rowguid
| AK_CustomerAddress_rowguid
+
|- valign="top"
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
|  
+
| Date and time the record was last updated.<br />
|
 
 
|}
 
|}
  
Line 76: Line 73:
 
| CustomerID
 
| CustomerID
 
|}
 
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
 +
|}
 +
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  

Revision as of 23:54, 28 December 2009

wikibot

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


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


automatically generated

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