Sales.ContactCreditCard

Table: 'Sales.ContactCreditCard'

3 fields. 24 bytes.

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

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ContactIDint   Not nullCustomer identification number. Foreign key to Contact.ContactID. 
CreditCardIDint   Not nullCredit card identification number. Foreign key to CreditCard.CreditCardID. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.ContactCreditCard'

Primary Key NameField Names
PK_ContactCreditCard_ContactID_CreditCardIDContactID, CreditCardID

Foreign keys for table 'Sales.ContactCreditCard', 2 items

ForeignPrimaryKey Name
ContactCreditCard.ContactIDContact.ContactIDFK_ContactCreditCard_Contact_ContactID
ContactCreditCard.CreditCardIDCreditCard.CreditCardIDFK_ContactCreditCard_CreditCard_CreditCardID

Indexes for table 'Sales.ContactCreditCard', 1 item

Index NameDescriptionClusteredUniqueFields
PK_ContactCreditCard_ContactID_CreditCardIDClustered index created by a primary key constraint.YesYesContactID, CreditCardID

Triggers for table 'Sales.ContactCreditCard', 1 item

NameDescriptionTypeEnabled
uContactCreditCardAFTER UPDATE trigger setting the ModifiedDate column in the ContactCreditCard table to the current date.after Update Yes

Dependencies for table 'Sales.ContactCreditCard', 1 item

Object NameTypeField Name
Sales.uContactCreditCardtriggerN/A