m_wc_loan_transaction

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_wc_loan_charge_paid_by.wc_loan_transaction_id fk_wc_charge_paid_by_transaction R
m_wc_loan_transaction_allocation.wc_loan_transaction_id FK_m_wc_loan_transaction_allocation_transaction R
m_wc_loan_transaction_relation.from_loan_transaction_id fk_m_wc_loan_transaction_relation_on_from_loan_transaction R
m_wc_loan_transaction_relation.to_loan_transaction_id fk_m_wc_loan_transaction_relation_on_to_loan_transaction R
wc_loan_id int8 19 null
m_wc_loan.id FK_m_wc_loan_transaction_loan R
payment_detail_id int8 19 √ null
m_payment_detail.id FK_m_wc_loan_transaction_payment_detail R
classification_cv_id int4 10 √ null
m_code_value.id FK_m_wc_loan_transaction_classification_cv R
external_id varchar 100 √ null
transaction_type_id int2 5 null
transaction_date date 13 null
submitted_on_date date 13 null
transaction_amount numeric 19,6 null
version int2 5 0
created_by int8 19 null
m_appuser.id FK_m_wc_loan_transaction_created_by R
last_modified_by int8 19 null
m_appuser.id FK_m_wc_loan_transaction_last_modified_by R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
is_reversed bool 1 false
reversal_external_id varchar 100 √ null
reversed_on_date date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_m_wc_loan_transaction Primary key Asc id
IND_m_wc_loan_transaction_wc_loan_id Performance Asc wc_loan_id
wc_loan_transaction_external_id_UNIQUE Must be unique Asc external_id
wc_loan_transaction_reversal_external_id_UNIQUE Must be unique Asc reversal_external_id

Relationships

Close relationships within degrees of separation