Object type: Table

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

Columns 

Name	Data type	Nullable	Description
ContactID	int	No	Customer identification number. Foreign key to Contact.ContactID.
CreditCardID	int	No	Credit card identification number. Foreign key to CreditCard.CreditCardID.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_ContactCreditCard_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_ContactCreditCard_ContactID_CreditCardID	PRIMARY KEY	ContactID CreditCardID	Clustered index created by a primary key constraint.
FK_ContactCreditCard_Contact_ContactID	FOREIGN KEY	ContactID	Reference table: Person.Contact Foreign key constraint referencing Contact.ContactID.
FK_ContactCreditCard_CreditCard_CreditCardID	FOREIGN KEY	CreditCardID	Reference table: Sales.CreditCard Foreign key constraint referencing CreditCard.CreditCardID.

Triggers 

Name	Description
Sales.uContactCreditCard	AFTER UPDATE trigger setting the ModifiedDate column in the ContactCreditCard table to the current date.

Modified by 

Name	Description
Sales.uContactCreditCard	AFTER UPDATE trigger setting the ModifiedDate column in the ContactCreditCard table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation