m_payment_detail

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_gl_journal_entry.payment_details_id FK_acc_gl_journal_entry_m_payment_detailR
m_loan_transaction.payment_detail_id FK_m_loan_transaction_m_payment_detailR
m_savings_account_transaction.payment_detail_id FK_m_savings_account_transaction_m_payment_detailR
payment_type_id INT 10 √ NULL
m_payment_type.id FK_m_payment_detail_m_payment_typeR
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)
PRIMARY Primary key Asc id
FK_m_payment_detail_m_payment_type Performance Asc payment_type_id

Relationships

Close relationships within degrees of separation