AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.ContactCreditCard
Description:Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
Primary Keys:ContactID
CreditCardID
FieldTypeDefaultsNulls?Comments
ContactIDintNoneNoCustomer identification number. Foreign key to Contact.ContactID.
CreditCardIDintNoneNoCredit card identification number. Foreign key to CreditCard.CreditCardID.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ContactCreditCard_ContactID_CreditCardIDYesYesContactID
CreditCardID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_ContactCreditCard_Contact_ContactIDContactIDPerson.Contact
FK_ContactCreditCard_CreditCard_CreditCardIDCreditCardIDSales.CreditCard

No primary keys as foreign key constraints
No triggers