id|uuid
code|text
application_id|uuid
customer_id|uuid
principal|numeric
interest_rate_monthly|numeric
term_count|integer
term_period|USER-DEFINED
start_date|date
end_date|date
total_interest|numeric
total_payable|numeric
installment_amount|numeric
disbursement_bank|text
disbursement_account_no|text
disbursement_account_name|text
status|USER-DEFINED
approved_by|uuid
approved_at|timestamp with time zone
approval_notes|text
contract_pdf_url|text
grace_days|integer
defaulted_at|timestamp with time zone
closed_at|timestamp with time zone
created_by|uuid
created_at|timestamp with time zone
updated_at|timestamp with time zone
is_secured|boolean
preferred_collection|USER-DEFINED