m_office

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_accounting_rule.office_id FK_acc_accounting_rule_m_officeR
acc_gl_closure.office_id FK_acc_gl_closure_m_officeR
acc_gl_journal_entry.office_id FK_acc_gl_journal_entry_m_officeR
m_account_transfer_details.from_office_id FK_m_account_transfer_details_from_officeR
m_account_transfer_details.to_office_id FK_m_account_transfer_details_to_officeR
m_appuser.office_id FKB3D587CE0DD567AR
m_client.office_id FKCE00CAB3E0DD567AR
m_client.transfer_to_office_id FK_m_client_m_officeR
m_client_transfer_details.from_office_id FK_m_client_transfer_details_m_officeR
m_client_transfer_details.to_office_id FK_m_client_transfer_details_m_office_2R
m_group.office_id m_group_ibfk_1R
m_holiday_office.office_id m_office_id_ibfk_2R
m_loan_transaction.office_id FK_m_loan_transaction_m_officeR
m_loanproduct_provisioning_entry.office_id m_loanproduct_provisioning_entry_ibfk_3R
m_office.parent_id FK2291C477E2551DCCR
m_office_transaction.from_office_id FK1E37728B783C5C25R
m_office_transaction.to_office_id FK1E37728B93C6C1B6R
m_savings_account_transaction.office_id FK_m_savings_account_transaction_m_officeR
m_staff.office_id FK_m_staff_m_officeR
m_tellers.office_id FK_m_tellers_m_officeR
parent_id BIGINT 19 √ NULL
m_office.id FK2291C477E2551DCCR
hierarchy VARCHAR 100 √ NULL
external_id VARCHAR 100 √ NULL
name VARCHAR 50 null
opening_date DATE 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
external_id Must be unique Asc external_id
FK2291C477E2551DCC Performance Asc parent_id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation