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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.CustomerAddress |- |} {| border="1" cellpadding="5" cellspacing="0" st...)
 
Line 52: Line 52:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Person.Address_(table)|Person.Address]]
 +
| AddressID
 +
| AddressID
 +
|-
 +
| [[Person.AddressType_(table)|Person.AddressType]]
 +
| AddressTypeID
 +
| AddressTypeID
 +
|-
 +
| [[Sales.Customer_(table)|Sales.Customer]]
 +
| CustomerID
 +
| CustomerID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.CustomerAddress
 +
|-
 +
 +
| '''Description
 +
| Cross-reference table mapping customers to their address(es).
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

wikibot

Table Sales.CustomerAddress


Column Data Type Nullable Default PK Index
CustomerID int not null PK_CustomerAddress_CustomerID_AddressID
AddressID int not null PK_CustomerAddress_CustomerID_AddressID
AddressTypeID int not null
rowguid uniqueidentifier not null (newid()) AK_CustomerAddress_rowguid
ModifiedDate datetime not null (getdate())


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

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.CustomerAddress_(table)&oldid=1088"