Sales.ContactCreditCard Table

Description

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

Properties

Creation Date	08/01/2010 08:40
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	19118
Data Space Used	480.00 KB
Index Space Used	16.00 KB

Columns

Column Name	Description	Datatype	Length	Default
ContactID	Customer identification number. Foreign key to Contact.ContactID.	int	4
CreditCardID	Credit card identification number. Foreign key to CreditCard.CreditCardID.	int	4
ModifiedDate	Date and time the record was last updated.	datetime	4	(getdate())

Indexes

Index	Description	Primary	Unique
PK_ContactCreditCard_ContactID_CreditCardID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_ContactCreditCard_Contact_ContactID	Foreign key constraint referencing Contact.ContactID.
FK_ContactCreditCard_CreditCard_CreditCardID	Foreign key constraint referencing CreditCard.CreditCardID.

Objects that Sales.ContactCreditCard depends on

Database Object	Object Type	Description	Dep Level
Person.Contact	Table	Names of each employee, customer contact, and vendor contact.	1
Sales.CreditCard	Table	Customer credit card information.	1
dbo.Name	User Defined Data Type		2
dbo.NameStyle	User Defined Data Type		2
dbo.Phone	User Defined Data Type		2

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[ContactCreditCard](
	[ContactID] [int] NOT NULL,
	[CreditCardID] [int] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ContactCreditCard_ContactID_CreditCardID] PRIMARY KEY CLUSTERED 
(
	[ContactID] ASC,
	[CreditCardID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Sales].[ContactCreditCard]  WITH CHECK ADD  CONSTRAINT [FK_ContactCreditCard_Contact_ContactID] FOREIGN KEY([ContactID])
REFERENCES [Contact] ([ContactID])
ALTER TABLE [Sales].[ContactCreditCard] CHECK CONSTRAINT [FK_ContactCreditCard_Contact_ContactID]
ALTER TABLE [Sales].[ContactCreditCard]  WITH CHECK ADD  CONSTRAINT [FK_ContactCreditCard_CreditCard_CreditCardID] FOREIGN KEY([CreditCardID])
REFERENCES [CreditCard] ([CreditCardID])
ALTER TABLE [Sales].[ContactCreditCard] CHECK CONSTRAINT [FK_ContactCreditCard_CreditCard_CreditCardID]
ALTER TABLE [Sales].[ContactCreditCard] ADD  CONSTRAINT [DF_ContactCreditCard_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects

Sales Schema
AdventureWorks Database