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 Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
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			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.ContactCreditCard'

Primary Key Name	Field Names
PK_ContactCreditCard_ContactID_CreditCardID	ContactID, CreditCardID

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

Foreign	Primary	Key Name
ContactCreditCard.ContactID	Contact.ContactID	FK_ContactCreditCard_Contact_ContactID
ContactCreditCard.CreditCardID	CreditCard.CreditCardID	FK_ContactCreditCard_CreditCard_CreditCardID

Indexes for table 'Sales.ContactCreditCard', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_ContactCreditCard_ContactID_CreditCardID	Clustered index created by a primary key constraint.	Yes	Yes	ContactID, CreditCardID

Triggers for table 'Sales.ContactCreditCard', 1 item

Name	Description	Type	Enabled
uContactCreditCard	AFTER 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 Name	Type	Field Name
Sales.uContactCreditCard	trigger	N/A