Table: Ledger_Entry_Service_Charge
Columns
NameTypeConstraintsDescription
ledger_entry_service_charge_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
service_charge__ledger_entry_KEYintNOT NULLKey to the Ledger Entry that is the Service Charge.
past_due__ledger_entry_KEYintNOT NULLKey to a Ledger Entry that was past due and was charged a fee.
amountdecimal (17, 2)NOT NULLAmount charged because past_due__ledger_entry_KEY has not been paid.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Ledger_Entry_Service_Charge$ledger_entry_service_charge_KEYledger_entry_service_charge_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Ledger_Entry_Service_Charge$service_charge__ledger_entry_KEY$past_due__ledger_entry_KEYservice_charge__ledger_entry_KEY, past_due__ledger_entry_KEYYou can't have more than one charge per past due item on each service charge.
Indexes
NameColumnsDescription
IX_Ledger_Entry_Service_Charge$past_due__ledger_entry_KEYpast_due__ledger_entry_KEYIndex supports foreign key FK_Ledger_Entry_Service_Charge__Ledger_Entry__past_due__ledger_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ledger_Entry_Service_Charge__Ledger_Entry__past_due__ledger_entry_KEYpast_due__ledger_entry_KEYLedger_Entry
FK_Ledger_Entry_Service_Charge__Ledger_Entry__service_charge__ledger_entry_KEYservice_charge__ledger_entry_KEYLedger_Entry

Schema diagram