CreditCard Table (AdventureWorks)
Contains customer credit card information such as the card number and expiration data.
CreditCard Table Definition
The CreditCard table is contained in the Sales schema.
Column |
Data type |
Nullability |
Description |
|---|---|---|---|
CreditCardID |
int |
Not null |
Primary key for CreditCard rows. |
CardType |
nvarchar(50) |
Not null |
Credit card name. |
CardNumber |
nvarchar(25) |
Null |
Credit card number. |
ExpMonth |
tinyint |
Null |
Credit card expiration month. |
ExpYear |
smallint |
Not null |
Credit card expiration year. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |