Object type: Table

Customer credit card information.

Columns 

Name	Data type	Nullable	Description
CreditCardID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for CreditCard records.
CardType	nvarchar(50)	No	Credit card name.
CardNumber	nvarchar(25)	No	Credit card number.
ExpMonth	tinyint	No	Credit card expiration month.
ExpYear	smallint	No	Credit card expiration year.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_CreditCard_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_CreditCard_CreditCardID	PRIMARY KEY	CreditCardID	Clustered index created by a primary key constraint.

Indices 

Name	Description
AK_CreditCard_CardNumber	Unique nonclustered index.

Triggers 

Name	Description
Sales.uCreditCard	AFTER UPDATE trigger setting the ModifiedDate column in the CreditCard table to the current date.

Linked tables 

Name	Description
Sales.ContactCreditCard	Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
Sales.SalesOrderHeader	General sales order information.

Modified by 

Name	Description
Sales.uCreditCard	AFTER UPDATE trigger setting the ModifiedDate column in the CreditCard table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation