m_payment_detail

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_gl_journal_entry.payment_details_id FK_acc_gl_journal_entry_m_payment_detail R
m_account_transfer_transaction.payment_detail_id FK_m_account_transfer_transaction_m_payment_detail R
m_loan_transaction.payment_detail_id FK_m_loan_transaction_m_payment_detail R
m_savings_account_transaction.payment_detail_id FK_m_savings_account_transaction_m_payment_detail R
m_wc_loan_transaction.payment_detail_id FK_m_wc_loan_transaction_payment_detail R
payment_type_id int4 10 √ null
m_payment_type.id FK_m_payment_detail_m_payment_type R
account_number varchar 100 √ null
check_number varchar 100 √ null
receipt_number varchar 100 √ null
bank_number varchar 100 √ null
routing_code varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
m_payment_detail_pkey Primary key Asc id
FK_m_payment_detail_m_payment_type Performance Asc payment_type_id
idx_m_payment_detail_check_number Performance Asc check_number
idx_m_payment_detail_receipt_number Performance Asc receipt_number
idx_m_payment_detail_routing_code Performance Asc routing_code

Relationships

Close relationships within degrees of separation