Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales ContactCreditCard (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:02


wikibot

TableSales.ContactCreditCard
DescriptionCross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.

ColumnData TypeNullableDefaultDescription / PK / Index
ContactIDintnot null Customer identification number. Foreign key to Contact.ContactID.
PK_ContactCreditCard_ContactID_CreditCardID
CreditCardIDintnot null Credit card identification number. Foreign key to CreditCard.CreditCardID.
PK_ContactCreditCard_ContactID_CreditCardID
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Person.ContactContactIDContactID
Sales.CreditCardCreditCardIDCreditCardID

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