Table db195.personnel Generated by
SchemaSpy
Implied relationships 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
PERSONNEL_ID smallint 5  √ 
account.PERSONNEL_ID account_ibfk_4
account_activity.PERSONNEL_ID Implied Constraint
account_flag_detail.CREATED_BY account_flag_detail_ibfk_3
account_notes.OFFICER_ID account_notes_ibfk_2
account_status_change_history.CHANGED_BY account_status_change_history_ibfk_4
batch_staff_summary.PERSONNEL_ID Implied Constraint
change_log.CHANGED_BY change_log_ibfk_1
checklist.CREATED_BY checklist_ibfk_2
checklist.UPDATED_BY checklist_ibfk_3
customer.CUSTOMER_FORMEDBY_ID customer_ibfk_5
customer.LOAN_OFFICER_ID customer_ibfk_4
customer_account_activity.CREATED_BY customer_account_activity_ibfk_3
customer_flag_detail.CREATED_BY customer_flag_detail_ibfk_3
customer_hierarchy.UPDATED_BY customer_hierarchy_ibfk_3
customer_movement.PERSONNEL_ID customer_movement_ibfk_3
customer_movement.UPDATED_BY customer_movement_ibfk_4
customer_note.FIELD_OFFICER_ID customer_note_ibfk_2
fees.CREATED_BY fees_ibfk_5
fees.UPDATED_BY fees_ibfk_6
financial_trxn.POSTED_BY financial_trxn_ibfk_8
loan_activity_details.CREATED_BY loan_activity_details_ibfk_1
office_hierarchy.UPDATED_BY office_hierarchy_ibfk_3
personnel.CREATED_BY personnel_ibfk_2
personnel.UPDATED_BY personnel_ibfk_6
personnel_custom_field.PERSONNEL_ID personnel_custom_field_ibfk_1
personnel_details.PERSONNEL_ID personnel_details_ibfk_1
personnel_hierarchy.PARENT_ID personnel_hierarchy_ibfk_1
personnel_hierarchy.PERSONNEL_ID personnel_hierarchy_ibfk_2
personnel_hierarchy.UPDATED_BY personnel_hierarchy_ibfk_3
personnel_movement.PERSONNEL_ID personnel_movement_ibfk_1
personnel_movement.UPDATED_BY personnel_movement_ibfk_2
personnel_notes.OFFICER_ID personnel_notes_ibfk_2
personnel_notes.PERSONNEL_ID personnel_notes_ibfk_1
personnel_role.PERSONNEL_ID personnel_role_ibfk_1
role.CREATED_BY role_ibfk_1
role.UPDATED_BY role_ibfk_2
savings_activity_details.CREATED_BY savings_activity_details_ibfk_1
survey_instance.CREATING_OFFICER_ID survey_instance_ibfk_5
survey_instance.OFFICER_ID survey_instance_ibfk_3
LEVEL_ID smallint 5
personnel_level.LEVEL_ID personnel_ibfk_3
GLOBAL_PERSONNEL_NUM varchar 100  √  null
OFFICE_ID smallint 5  √  null
office.OFFICE_ID personnel_ibfk_1
TITLE int 10  √  null
lookup_value.LOOKUP_ID personnel_ibfk_5
PERSONNEL_STATUS smallint 5  √  null
PREFERRED_LOCALE smallint 5  √  null
supported_locale.LOCALE_ID personnel_ibfk_4
SEARCH_ID varchar 100  √  null
MAX_CHILD_COUNT int 10  √  null
PASSWORD tinyblob 255  √  null
LOGIN_NAME varchar 200  √  null
EMAIL_ID varchar 255  √  null
PASSWORD_CHANGED smallint 5
DISPLAY_NAME varchar 200  √  null
CREATED_BY smallint 5
personnel.PERSONNEL_ID personnel_ibfk_2
CREATED_DATE date 0  √  null
UPDATED_BY smallint 5  √  null
personnel.PERSONNEL_ID personnel_ibfk_6
UPDATED_DATE date 0  √  null
LAST_LOGIN date 0  √  null
LOCKED smallint 5
NO_OF_TRIES smallint 5
VERSION_NO int 10

Table contained 1 rows at Tue May 13 16:59 PDT 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
PERSONNEL_ID Primary key Asc PRIMARY  
CREATED_BY Performance Asc CREATED_BY  
LEVEL_ID Performance Asc LEVEL_ID  
GLOBAL_PERSONNEL_NUM Must be unique Asc PERSONNEL_GLOBAL_IDX This unique column is also nullable
LOGIN_NAME Must be unique Asc PERSONNEL_LOGIN_IDX This unique column is also nullable
OFFICE_ID Performance Asc PERSONNEL_OFFICE_IDX  
SEARCH_ID Must be unique Asc PERSONNEL_SEARCH_IDX This unique column is also nullable
PREFERRED_LOCALE Performance Asc PREFERRED_LOCALE  
TITLE Performance Asc TITLE  
UPDATED_BY Performance Asc UPDATED_BY  

Close relationships  within one two degrees of separation :