CreditCard Table (AdventureWorks)
Contains customer credit card information such as the card number and expiration data.
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. |
Reference
Contact Table (AdventureWorks)ContactCreditCard Table (AdventureWorks)
Customer Table (AdventureWorks)
Individual Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)
Store Table (AdventureWorks)
