Sales.PersonCreditCard

Columns

• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  CreditCardID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_PersonCreditCard_BusinessEntityID_CreditCardID
  UNIQUE CLUSTERED
  BusinessEntityID , CreditCardID

Foreign Keys

• //

  Foreign key constraint referencing CreditCard.CreditCardID.
  FK_PersonCreditCard_CreditCard_CreditCardID
  Sales.CreditCard
  CreditCardID ⥱ CreditCardID
• //

  Foreign key constraint referencing Person.BusinessEntityID.
  FK_PersonCreditCard_Person_BusinessEntityID
  Person.Person
  BusinessEntityID ⥱ BusinessEntityID

Sample Data