Table db164.office Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
OFFICE_ID smallint 6  √ 
account.OFFICE_ID account_ibfk_5
branch_ho_update.OFFICE_ID branch_ho_update_ibfk_1
customer.BRANCH_ID customer_ibfk_3
customer_movement.OFFICE_ID customer_movement_ibfk_2
fees.OFFICE_ID fees_ibfk_4
holiday.OFFICE_ID holiday_ibfk_1
loan_arrears_aging.OFFICE_ID loan_arrears_aging_ibfk_4
mfi_attribute.OFFICE_ID mfi_attribute_ibfk_1
office.PARENT_OFFICE_ID office_ibfk_2
office_action_payment_type.OFFICE_ID office_action_payment_type_ibfk_2
office_address.OFFICE_ID office_address_ibfk_1
office_custom_field.OFFICE_ID office_custom_field_ibfk_1
office_hierarchy.OFFICE_ID office_hierarchy_ibfk_1
office_hierarchy.PARENT_ID office_hierarchy_ibfk_2
penalty.OFFICE_ID penalty_ibfk_4
personnel.OFFICE_ID personnel_ibfk_1
personnel_movement.OFFICE_ID personnel_movement_ibfk_3
prd_category.OFFICE_ID Implied Constraint
prd_offering.OFFICE_ID prd_offering_ibfk_2
program.OFFICE_ID program_ibfk_3
system_configuration.OFFICE_ID system_configuration_ibfk_1
GLOBAL_OFFICE_NUM varchar 100
OFFICE_LEVEL_ID smallint 6
office_level.LEVEL_ID office_ibfk_1
SEARCH_ID varchar 100
MAX_CHILD_COUNT int 11
LOCAL_REMOTE_FLAG smallint 6
DISPLAY_NAME varchar 200
CREATED_BY smallint 6  √  null
CREATED_DATE date 10  √  null
UPDATED_BY smallint 6  √  null
UPDATED_DATE date 10  √  null
OFFICE_SHORT_NAME varchar 4
PARENT_OFFICE_ID smallint 6  √  null
office.OFFICE_ID office_ibfk_2
STATUS_ID smallint 6
office_status.STATUS_ID office_ibfk_3
VERSION_NO int 11
OFFICE_CODE_ID smallint 6  √  null
office_code.CODE_ID office_ibfk_4

Table contained 1 rows at Thu Dec 13 21:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
OFFICE_ID Primary key Asc PRIMARY
GLOBAL_OFFICE_NUM Must be unique Asc GLOBAL_OFFICE_NUM
OFFICE_CODE_ID Performance Asc OFFICE_CODE_ID
GLOBAL_OFFICE_NUM Must be unique Asc OFFICE_GLOBAL_IDX
OFFICE_LEVEL_ID Performance Asc OFFICE_LEVEL_ID
PARENT_OFFICE_ID Performance Asc PARENT_OFFICE_ID
STATUS_ID Performance Asc STATUS_ID

Close relationships  within one two degrees of separation :