Table: Online_Invoice
Information about Invoices that have been sent to the online bill pay service.
Columns
NameTypeConstraintsDescription
ledger_entry_KEYintNOT NULLPrimary key for this row and the key of the associated Invoice.
online_invoice_guiduniqueidentifierNOT NULLA unique value that is used to identify this invoice on the portal and in online payments.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Online_Invoice$ledger_entry_KEYledger_entry_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Online_Invoice$online_invoice_guidonline_invoice_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Online_Invoice__Invoice__ledger_entry_KEYledger_entry_KEYInvoiceon delete cascade;

Schema diagram