Table: Ledger_Entry_Submittal
Columns
NameTypeConstraintsDescription
ledger_entry_KEYintNOT NULLThe ledger entry this submittal applies to.
submittal_status_KEYintNOT NULLThe status for this ledger entry.
credit_card_KEYintCredit card info used in this submittal.
update_date_utcdatetimeNOT NULL
update__staff_KEYintNOT NULL
order_numbernvarchar (40)NOT NULLUnique order number assigned by the program
swipebitNOT NULLIndicates the user chose to swipe the card on Secure Pay through an external browser
Primary key
NameColumnsDescription
PK_Ledger_Entry_Submittal$ledger_entry_KEYledger_entry_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Ledger_Entry_Submittal$credit_card_KEYcredit_card_KEYIndex supports foreign key FK_Ledger_Entry_Submittal__Credit_Card__credit_card_KEY
IX_Ledger_Entry_Submittal$submittal_status_KEYsubmittal_status_KEYIndex supports foreign key FK_Ledger_Entry_Submittal__Submittal_Status__submittal_status_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ledger_Entry_Submittal__Credit_Card__credit_card_KEYcredit_card_KEYCredit_Card
FK_Ledger_Entry_Submittal__Ledger_Entry__ledger_entry_KEYledger_entry_KEYLedger_Entryon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ledger_Entry_Submittal_Result__Ledger_Entry_Submittal__ledger_entry_KEYledger_entry_KEYLedger_Entry_Submittal_Resulton delete cascade;

Schema diagram