Owner: Sales 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 480 
Index Size KB: 16 
Rows: 19118 
Description: Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.  


Name Data Type Length NULL Default IsIdentity IsGUID Description
    ContactID  int          Customer identification number. Foreign key to Contact.ContactID. 
    CreditCardID  int          Credit card identification number. Foreign key to CreditCard.CreditCardID. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 3 column(s)


Index Primary Unique Description
  PK_ContactCreditCard_ContactID_CreditCardID      Primary key (clustered) constraint 
Total: 1 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Person.Contact  FK_ContactCreditCard_Contact_ContactID  PK_Contact_ContactID 
  Sales.CreditCard  FK_ContactCreditCard_CreditCard_CreditCardID  PK_CreditCard_CreditCardID 
Total: 2 table(s)

Objects that [Sales].[ContactCreditCard] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
  NameStyle  dbo  User Defined type 
  Phone  dbo  User Defined type 
  Contact  Person  Table 
  CreditCard  Sales  Table 
Total: 5 object(s)


CREATE TABLE [ContactCreditCard] (
    [ContactID] [int] NOT NULL ,
    [CreditCardID] [int] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ContactCreditCard_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_ContactCreditCard_ContactID_CreditCardID] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_ContactCreditCard_Contact_ContactID] FOREIGN KEY
    ) REFERENCES [Contact] (
    CONSTRAINT [FK_ContactCreditCard_CreditCard_CreditCardID] FOREIGN KEY
    ) REFERENCES [CreditCard] (

See Also

List of tables