ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

PoweredBy

Discuss (0)View Page Code History

Sales.ContactCreditCard_(table)

Modified: 2011/08/27 10:14 by wikibot - Uncategorized

» Sales.ContactCreditCard_(table)

wikibot

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

Columns

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

Primary Key

Primary Key	Columns
PK_ContactCreditCard_ContactID_CreditCardID	ContactID, CreditCardID

Foreign Keys

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

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.