Sales.ContactCreditCard (table)

From dbscript Online Help
Revision as of 01:12, 27 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