Table: Credit_Card_Type
Tags: read-only Content:
0 | NONE | None | NONE
1 | MC | Master Card | MC
2 | VISA | Visa | VISA
3 | AMEX | American Express | AMEX
4 | DISC | Discover | DISC
Columns
Name | Type | Constraints | Description
credit_card_type_KEY | int | NOT NULL | Database assigned key for this record.
credit_card_id | nvarchar (4) | NOT NULL | ID (abbreviation) for the credit card type.
description | nvarchar (20) | NOT NULL | Description for this record
credit_card_id_sortable | varchar (48) | NOT NULL | A representation of the credit_card_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of credit_card_id.

Primary key
Name | Columns | Description
PK_Credit_Card_Type$credit_card_type_KEY | credit_card_type_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Credit_Card_Type__credit_card_id | credit_card_id | Each credit card id must be unique.
UK_Credit_Card_Type__credit_card_id_sortable | credit_card_id_sortable | An index by the sortable ID is desired, and the algorithm ends up producing unique values.
UK_Credit_Card_Type__description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Credit_Card__Credit_Card_Type__credit_card_type_KEY | credit_card_type_KEY | Credit_Card |