Table: Ledger_Entry_Service_Charge
Columns
Name | Type | Constraints | Description
ledger_entry_service_charge_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table
row_version | timestamp | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
service_charge__ledger_entry_KEY | int | NOT NULL | Key to the Ledger Entry that is the Service Charge.
past_due__ledger_entry_KEY | int | NOT NULL | Key to a Ledger Entry that was past due and was charged a fee.
amount | decimal (17, 2) | NOT NULL | Amount charged because past_due__ledger_entry_KEY has not been paid.
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Ledger_Entry_Service_Charge$ledger_entry_service_charge_KEY | ledger_entry_service_charge_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Ledger_Entry_Service_Charge__service_charge__ledger_entry_KEY__past_due__ledger_entry_KEY | service_charge__ledger_entry_KEY, past_due__ledger_entry_KEY | You can't have more than one charge per past due item on each service charge.
Indexes
Name | Columns | Description
IX_Ledger_Entry_Service_Charge$past_due__ledger_entry_KEY | past_due__ledger_entry_KEY | Index supports foreign key FK_Ledger_Entry_Service_Charge__Ledger_Entry__past_due__ledger_entry_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Ledger_Entry_Service_Charge__Ledger_Entry__past_due__ledger_entry_KEY | past_due__ledger_entry_KEY | Ledger_Entry |
FK_Ledger_Entry_Service_Charge__Ledger_Entry__service_charge__ledger_entry_KEY | service_charge__ledger_entry_KEY | Ledger_Entry |