Sales.ContactCreditCard Table

Information

Name	ContactCreditCard
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:54

Extended Properties

Name	Type	Property Name	Value
ContactCreditCard	TABLE	MS_Description	Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.

Columns

Name	Data Type	References	Default
ContactID	int	Person.Contact.ContactID
CreditCardID	int	Sales.CreditCard.CreditCardID
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ContactCreditCard_ContactID_CreditCardID	Clustered			ContactID, CreditCardID

Foreign Key Constraints

Name	Type	Referenced Table
FK_ContactCreditCard_Contact_ContactID	Foreign key	Person.Contact
FK_ContactCreditCard_CreditCard_CreditCardID	Foreign key	Sales.CreditCard

SQL Script

CREATE TABLE [Sales].[ContactCreditCard] (
    [ContactID] int NOT NULL,
    [CreditCardID] int NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);