Table: Credit_Card
Columns
NameTypeConstraintsDescription
credit_card_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned key for this record.
credit_card_type_KEYintNOT NULLDatabase assigned key for this credit card type.
cardholder_namenvarchar (50)NOT NULLCredit card holder name.
billing_namenvarchar (50)NOT NULLName on billing information.
billing__address_KEYintNOT NULLBilling address.
update_date_utcdatetimeNOT NULL
update__staff_KEYintNOT NULL
expiration_monthintNOT NULLCredit card expiration date month
expiration_yearintNOT NULLCredit card expiration date year
Primary key
NameColumnsDescription
PK_Credit_Card$credit_card_KEYcredit_card_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Credit_Card$billing__address_KEYbilling__address_KEYIndex supports foreign key FK_Credit_Card__Address__billing__address_KEY
IX_Credit_Card$credit_card_type_KEYcredit_card_type_KEYIndex supports foreign key FK_Credit_Card__Credit_Card_Type__credit_card_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Credit_Card__Address__billing__address_KEYbilling__address_KEYAddress
FK_Credit_Card__Credit_Card_Type__credit_card_type_KEYcredit_card_type_KEYCredit_Card_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ledger_Entry_Submittal__Credit_Card__credit_card_KEYcredit_card_KEYLedger_Entry_Submittal

Schema diagram