AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.CreditCard
Description:Customer credit card information.
Primary Keys:CreditCardID
FieldTypeDefaultsNulls?Comments
CreditCardIDint - IdentityNoneNoPrimary key for CreditCard records.
CardTypenvarchar (50)NoneNoCredit card name.
CardNumbernvarchar (25)NoneNoCredit card number.
ExpMonthtinyintNoneNoCredit card expiration month.
ExpYearsmallintNoneNoCredit card expiration year.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_CreditCard_CreditCardIDYesYesCreditCardID
AK_CreditCard_CardNumberNoYesCardNumber

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ContactCreditCard_CreditCard_CreditCardIDSales.ContactCreditCardCreditCardID
FK_SalesOrderHeader_CreditCard_CreditCardIDSales.SalesOrderHeaderCreditCardID

No triggers