public.employee_loans
iduuidtenant_iduuidloan_numbercharacter varyingemployee_iduuidloan_typecharacter varyingstatuscharacter varyingprincipalnumericinstalment_amountnumericrecovered_amountnumericdisbursed_ondaterecovery_startsdatenotestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zone
| id | tenant_id | loan_number | employee_id | loan_type | status | principal | instalment_amount | recovered_amount | disbursed_on | recovery_starts | notes | created_by | is_active | created_at | updated_at |