Table: Online_Payment
Information about Payments that have been received from the online bill pay service.
Columns
NameTypeConstraintsDescription
ledger_entry_KEYintNOT NULLPrimary key for this row and the key of the associated Payment.
online_payment_guiduniqueidentifierNOT NULLA unique value that is used to identify this payment on the portal and in online payments.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Online_Payment$ledger_entry_KEYledger_entry_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Online_Payment$online_payment_guidonline_payment_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Online_Payment__Ledger_Entry__ledger_entry_KEYledger_entry_KEYLedger_Entryon delete cascade;

Schema diagram