Table: Credit_Card_Type | |||||||||||||||||||||||
Tags: read-only Content:
| |||||||||||||||||||||||
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 |