Sales.ContactCreditCard (table)

From dbscript Online Help
Revision as of 06:23, 30 November 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table Sales.ContactCreditCard


Column Data Type Nullable Default PK Index
ContactID int not null PK_ContactCreditCard_ContactID_CreditCardID
CreditCardID int not null PK_ContactCreditCard_ContactID_CreditCardID
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Person.Contact ContactID ContactID
Sales.CreditCard CreditCardID CreditCardID

automatically generated

Table Sales.ContactCreditCard
Description Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.


Column Data Type Nullable Default Description / PK / Index
ContactID int not null Customer identification number. Foreign key to Contact.ContactID.
PK_ContactCreditCard_ContactID_CreditCardID
CreditCardID int not null Credit card identification number. Foreign key to CreditCard.CreditCardID.
PK_ContactCreditCard_ContactID_CreditCardID
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.Contact ContactID ContactID
Sales.CreditCard CreditCardID CreditCardID


Referenced Object Object Type Dependency Type
.Sales Schema Schema