Table db157.customer 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
CUSTOMER_ID int 11  √ 
account.CUSTOMER_ID account_ibfk_3
account_trxn.CUSTOMER_ID account_trxn_ibfk_6
client_initial_savings_offering.CUSTOMER_ID client_initial_savings_offering_ibfk_1
client_perf_history.CUSTOMER_ID client_perf_history_ibfk_1
cust_perf_history.CUSTOMER_ID cust_perf_history_ibfk_1
customer_address_detail.CUSTOMER_ID customer_address_detail_ibfk_1
customer_attendance.CUSTOMER_ID customer_attendance_ibfk_1
customer_custom_field.CUSTOMER_ID customer_custom_field_ibfk_2
customer_detail.CUSTOMER_ID customer_detail_ibfk_1
customer_flag_detail.CUSTOMER_ID customer_flag_detail_ibfk_1
customer_hierarchy.CUSTOMER_ID customer_hierarchy_ibfk_1
customer_hierarchy.PARENT_ID customer_hierarchy_ibfk_2
customer_historical_data.CUSTOMER_ID customer_historical_data_ibfk_1
customer_meeting.CUSTOMER_ID customer_meeting_ibfk_1
customer_movement.CUSTOMER_ID customer_movement_ibfk_1
customer_name_detail.CUSTOMER_ID customer_name_detail_ibfk_1
customer_note.CUSTOMER_ID customer_note_ibfk_1
customer_picture.CUSTOMER_ID customer_picture_ibfk_1
customer_position.CUSTOMER_ID customer_position_ibfk_1
customer_program.CUSTOMER_ID customer_program_ibfk_1
customer_schedule.CUSTOMER_ID customer_schedule_ibfk_3
group_perf_history.CUSTOMER_ID group_perf_history_ibfk_1
inherited_meeting.CUSTOMER_ID inherited_meeting_ibfk_1
loan_arrears_aging.CUSTOMER_ID loan_arrears_aging_ibfk_2
loan_arrears_aging.PARENT_CUSTOMER_ID loan_arrears_aging_ibfk_3
loan_schedule.CUSTOMER_ID loan_schedule_ibfk_13
saving_schedule.CUSTOMER_ID saving_schedule_ibfk_5
survey_instance.CUSTOMER_ID survey_instance_ibfk_2
CUSTOMER_LEVEL_ID smallint 6
customer_level.LEVEL_ID customer_ibfk_1
GLOBAL_CUST_NUM varchar 100  √  null
LOAN_OFFICER_ID smallint 6  √  null
personnel.PERSONNEL_ID customer_ibfk_4
CUSTOMER_FORMEDBY_ID smallint 6  √  null
personnel.PERSONNEL_ID customer_ibfk_5
STATUS_ID smallint 6  √  null
customer_state.STATUS_ID customer_ibfk_2
BRANCH_ID smallint 6  √  null
office.OFFICE_ID customer_ibfk_3
DISPLAY_NAME varchar 200  √  null
FIRST_NAME varchar 200  √  null
LAST_NAME varchar 200  √  null
SECOND_LAST_NAME varchar 200  √  null
DISPLAY_ADDRESS varchar 500  √  null
EXTERNAL_ID varchar 50  √  null
DATE_OF_BIRTH date 10  √  null
GROUP_FLAG smallint 6  √  null
TRAINED smallint 6  √  null
TRAINED_DATE date 10  √  null
PARENT_CUSTOMER_ID int 11  √  null
CREATED_DATE date 10  √  null
UPDATED_DATE date 10  √  null
SEARCH_ID varchar 100  √  null
MAX_CHILD_COUNT int 11  √  null
HO_UPDATED smallint 6  √  null
CLIENT_CONFIDENTIAL smallint 6  √  null
MFI_JOINING_DATE date 10  √  null
GOVERNMENT_ID varchar 50  √  null
CUSTOMER_ACTIVATION_DATE date 10  √  null
CREATED_BY smallint 6  √  null
UPDATED_BY smallint 6  √  null
BLACKLISTED smallint 6  √  null
DISCRIMINATOR varchar 20  √  null
VERSION_NO int 11

Table contained 0 rows at Sat Nov 10 18:16 PST 2007

Indexes:
Column(s) Type Sort Constraint Name Anomalies
CUSTOMER_ID Primary key Asc PRIMARY  
BRANCH_ID Performance Asc BRANCH_ID  
CUSTOMER_FORMEDBY_ID Performance Asc CUSTOMER_FORMEDBY_ID  
LOAN_OFFICER_ID + CUSTOMER_LEVEL_ID + DISPLAY_NAME + FIRST_NAME + LAST_NAME + SECOND_LAST_NAME Performance Asc/Asc/Asc/Asc/Asc/Asc CUSTOMER_LO_NAME_IDX  
CUSTOMER_LEVEL_ID + FIRST_NAME + LAST_NAME + SECOND_LAST_NAME Performance Asc/Asc/Asc/Asc CUSTOMER_NAME_IDX  
GLOBAL_CUST_NUM Must be unique Asc CUST_GLOBAL_IDX This unique column is also nullable
LOAN_OFFICER_ID + BRANCH_ID Performance Asc/Asc CUST_LO_IDX  
SEARCH_ID Performance Asc CUST_SEARCH_IDX  
STATUS_ID Performance Asc STATUS_ID  

Close relationships  within one two degrees of separation :