m_office

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_accounting_rule.office_id FK_acc_accounting_rule_m_office R
acc_gl_closure.office_id FK_acc_gl_closure_m_office R
acc_gl_journal_entry.office_id FK_acc_gl_journal_entry_m_office R
m_account_transfer_details.from_office_id FK_m_account_transfer_details_from_office R
m_account_transfer_details.to_office_id FK_m_account_transfer_details_to_office R
m_appuser.office_id fkb3d587ce0dd567a R
m_client.office_id fkce00cab3e0dd567a R
m_client.transfer_to_office_id FK_m_client_m_office R
m_client_transfer_details.from_office_id FK_m_client_transfer_details_m_office R
m_client_transfer_details.to_office_id FK_m_client_transfer_details_m_office_2 R
m_group.office_id m_group_ibfk_1 R
m_holiday_office.office_id m_office_id_ibfk_2 R
m_journal_entry_aggregation_summary.office_id fk_gl_journal_entry_aggregation_summary_on_office_id R
m_loan_transaction.office_id FK_m_loan_transaction_m_office R
m_loanproduct_provisioning_entry.office_id m_loanproduct_provisioning_entry_ibfk_3 R
m_office.parent_id fk2291c477e2551dcc R
m_office_transaction.from_office_id fk1e37728b783c5c25 R
m_office_transaction.to_office_id fk1e37728b93c6c1b6 R
m_savings_account_transaction.office_id FK_m_savings_account_transaction_m_office R
m_staff.office_id FK_m_staff_m_office R
m_tellers.office_id FK_m_tellers_m_office R
parent_id int8 19 √ null
m_office.id fk2291c477e2551dcc R
hierarchy varchar 100 √ null
external_id varchar 100 √ null
name varchar 50 null
opening_date date 13 null

Indexes

Constraint Name Type Sort Column(s)
m_office_pkey Primary key Asc id
fk2291c477e2551dcc Performance Asc parent_id
m_office_external_id_key Must be unique Asc external_id
m_office_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation