Table: 'Sales.CreditCard'

6 fields. 173 bytes.

Customer credit card information.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
CreditCardIDint identity int Not nullPrimary key for CreditCard records. 
CardTypenvarchar50  Not nullCredit card name. 
CardNumbernvarchar25  Not nullCredit card number. 
ExpMonthtinyint   Not nullCredit card expiration month. 
ExpYearsmallint   Not nullCredit card expiration year. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.CreditCard'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Sales.CreditCard', 2 items

Index NameDescriptionClusteredUniqueFields
PK_CreditCard_CreditCardIDClustered index created by a primary key constraint.YesYesCreditCardID
AK_CreditCard_CardNumberUnique nonclustered index.NoYesCardNumber

Triggers for table 'Sales.CreditCard', 1 item

uCreditCardAFTER UPDATE trigger setting the ModifiedDate column in the CreditCard table to the current date.after Update Yes

Dependencies for table 'Sales.CreditCard', 1 item

Object NameTypeField Name