Table db167.account 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
ACCOUNT_ID int 11  √ 
account_activity.ACCOUNT_ID account_activity_ibfk_1
account_custom_field.ACCOUNT_ID account_custom_field_ibfk_2
account_fees.ACCOUNT_ID account_fees_ibfk_1
account_flag_detail.ACCOUNT_ID account_flag_detail_ibfk_1
account_notes.ACCOUNT_ID account_notes_ibfk_1
account_payment.ACCOUNT_ID account_payment_ibfk_1
account_status_change_history.ACCOUNT_ID account_status_change_history_ibfk_1
account_trxn.ACCOUNT_ID account_trxn_ibfk_1
customer_account.ACCOUNT_ID customer_account_ibfk_1
customer_account_activity.ACCOUNT_ID customer_account_activity_ibfk_1
customer_schedule.ACCOUNT_ID customer_schedule_ibfk_1
loan_account.ACCOUNT_ID loan_account_ibfk_1
loan_account.PARENT_ACCOUNT_ID loan_account_ibfk_12
loan_activity_details.ACCOUNT_ID loan_activity_details_ibfk_2
loan_arrears_aging.ACCOUNT_ID loan_arrears_aging_ibfk_1
loan_perf_history.ACCOUNT_ID loan_perf_history_ibfk_1
loan_schedule.ACCOUNT_ID loan_schedule_ibfk_1
saving_schedule.ACCOUNT_ID saving_schedule_ibfk_1
savings_account.ACCOUNT_ID savings_account_ibfk_1
savings_activity_details.ACCOUNT_ID savings_activity_details_ibfk_2
savings_performance.ACCOUNT_ID savings_performance_ibfk_1
survey_instance.ACCOUNT_ID survey_instance_ibfk_4
GLOBAL_ACCOUNT_NUM varchar 100  √  null
CUSTOMER_ID int 11  √  null
customer.CUSTOMER_ID account_ibfk_3
ACCOUNT_STATE_ID smallint 6  √  null
account_state.ACCOUNT_STATE_ID account_ibfk_1
ACCOUNT_TYPE_ID smallint 6
account_type.ACCOUNT_TYPE_ID account_ibfk_2
OFFICE_ID smallint 6  √  null
office.OFFICE_ID account_ibfk_5
PERSONNEL_ID smallint 6  √  null
personnel.PERSONNEL_ID account_ibfk_4
CREATED_BY smallint 6
CREATED_DATE date 10
UPDATED_BY smallint 6  √  null
UPDATED_DATE date 10  √  null
CLOSED_DATE date 10  √  null
VERSION_NO int 11  √  null
OFFSETTING_ALLOWABLE smallint 6

Table contained 0 rows at Wed Dec 26 12:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ACCOUNT_ID Primary key Asc PRIMARY  
GLOBAL_ACCOUNT_NUM Must be unique Asc ACCOUNT_GLOBAL_IDX This unique column is also nullable
ACCOUNT_STATE_ID Performance Asc ACCOUNT_STATE_ID  
ACCOUNT_TYPE_ID Performance Asc ACCOUNT_TYPE_ID  
CUSTOMER_ID Performance Asc CUSTOMER_ID_ACCOUNT_IDX  
OFFICE_ID Performance Asc OFFICE_ID  
PERSONNEL_ID Performance Asc PERSONNEL_ID  

Close relationships  within one two degrees of separation :