AdventureWorks
| Table Name: | Sales.CreditCard |
| Description: | Customer credit card information. |
| Primary Keys: | CreditCardID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| CreditCardID | int - Identity | None | No | Primary key for CreditCard records. |
| CardType | nvarchar (50) | None | No | Credit card name. |
| CardNumber | nvarchar (25) | None | No | Credit card number. |
| ExpMonth | tinyint | None | No | Credit card expiration month. |
| ExpYear | smallint | None | No | Credit card expiration year. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_CreditCard_CreditCardID | Yes | Yes | CreditCardID |
| AK_CreditCard_CardNumber | No | Yes | CardNumber |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_ContactCreditCard_CreditCard_CreditCardID | Sales.ContactCreditCard | CreditCardID |
| FK_SalesOrderHeader_CreditCard_CreditCardID | Sales.SalesOrderHeader | CreditCardID |