Sales.CreditCard

Columns

• //

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

  ${escapify(column.description)}
  CardType
  [nvarchar](50) NOT NULL
• //

  ${escapify(column.description)}
  CardNumber
  [nvarchar](25) NOT NULL
• //

  ${escapify(column.description)}
  ExpMonth
  [tinyint] NOT NULL
• //

  ${escapify(column.description)}
  ExpYear
  [smallint] NOT NULL
• //

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

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_CreditCard_CreditCardID
  UNIQUE CLUSTERED
  CreditCardID
• //

  Unique nonclustered index.
  AK_CreditCard_CardNumber
  UNIQUE NONCLUSTERED
  CardNumber

Sample Data