Generated using SQL Data Dictionary demo version.
Customer credit card information.
| Column | Data Type | Identity | Nullable | Default | |
|---|---|---|---|---|---|
| PK | CreditCardID | int | X | ||
| Primary key for CreditCard records. | |||||
| CardType | nvarchar(50) | ||||
| Credit card name. | |||||
| UK | CardNumber | nvarchar(25) | |||
| Credit card number. | |||||
| ExpMonth | tinyint | ||||
| Credit card expiration month. | |||||
| ExpYear | smallint | ||||
| Credit card expiration year. | |||||
| ModifiedDate | datetime | getdate() | |||
| Date and time the record was last updated. | |||||
Primary key (clustered) constraint
Unique nonclustered index.