ContactCreditCard Table (AdventureWorks)

Maps customers in the Contact table to their credit card information in the ContactCreditCard table.

ContactCreditCard Table Definition

The ContactCreditCard table is contained in the Sales schema.

Column Data type Nullability 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

Date and time the row was last updated.

See Also

Reference

Contact Table (AdventureWorks)
CreditCard Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)

Concepts

Sales and Marketing Scenario

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance