Table: Invoice_Office
Columns
NameTypeConstraintsDescription
ledger_entry_KEYintNOT NULLKey of the Ledger Entry.
office_KEYintNOT NULLKey of the Office of the Staff who billed this invoice.
Primary key
NameColumnsDescription
PK_Invoice_Office$ledger_entry_KEYledger_entry_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Invoice_Office$office_KEYoffice_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Invoice_Office__Invoice__ledger_entry_KEYledger_entry_KEYInvoiceon delete cascade;
FK_Invoice_Office__Office__office_KEYoffice_KEYOffice

Schema diagram