AdventureWorks
| 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 |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ContactID | int | None | No | Customer identification number. Foreign key to Contact.ContactID. |
| CreditCardID | int | None | No | Credit card identification number. Foreign key to CreditCard.CreditCardID. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ContactCreditCard_ContactID_CreditCardID | Yes | Yes | ContactID CreditCardID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_ContactCreditCard_Contact_ContactID | ContactID | Person.Contact |
| FK_ContactCreditCard_CreditCard_CreditCardID | CreditCardID | Sales.CreditCard |