Table: Credit_Card_Type
Tags: read-only

Content:
0NONENoneNONE
1MCMaster CardMC
2VISAVisaVISA
3AMEXAmerican ExpressAMEX
4DISCDiscoverDISC
Columns
NameTypeConstraintsDescription
credit_card_type_KEYintNOT NULLDatabase assigned key for this record.
credit_card_idnvarchar (4)NOT NULLID (abbreviation) for the credit card type.
descriptionnvarchar (20)NOT NULLDescription for this record
credit_card_id_sortablevarchar (48)NOT NULLA 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
NameColumnsDescription
PK_Credit_Card_Type$credit_card_type_KEYcredit_card_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Credit_Card_Type$credit_card_idcredit_card_idEach credit card id must be unique.
UK_Credit_Card_Type$credit_card_id_sortablecredit_card_id_sortableAn index by the sortable ID is desired, and the algorithm ends up producing unique values.
UK_Credit_Card_Type$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Credit_Card__Credit_Card_Type__credit_card_type_KEYcredit_card_type_KEYCredit_Card

Schema diagram