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
Other Resources
AdventureWorks Data Dictionary