Table db165.lookup_value 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
LOOKUP_ID int 11  √ 
account_action.LOOKUP_ID account_action_ibfk_1
account_state.LOOKUP_ID account_state_ibfk_1
account_state_flag.LOOKUP_ID account_state_flag_ibfk_2
account_type.LOOKUP_ID account_type_ibfk_1
activity.ACTIVITY_NAME_LOOKUP_ID activity_ibfk_2
activity.DESCRIPTION_LOOKUP_ID activity_ibfk_3
category_type.CATEGORY_LOOKUP_ID category_type_ibfk_1
collateral_type.LOOKUP_ID collateral_type_ibfk_1
customer_attendance_types.ATTENDANCE_LOOKUP_ID customer_attendance_types_ibfk_1
customer_detail.CITIZENSHIP customer_detail_ibfk_2
customer_detail.EDUCATION_LEVEL customer_detail_ibfk_3
customer_detail.ETHINICITY customer_detail_ibfk_4
customer_detail.HANDICAPPED customer_detail_ibfk_5
customer_detail.MARITAL_STATUS customer_detail_ibfk_6
customer_detail.POVERTY_STATUS customer_detail_ibfk_7
customer_name_detail.SALUTATION customer_name_detail_ibfk_2
customer_state.STATUS_LOOKUP_ID customer_state_ibfk_2
customer_state_flag.FLAG_LOOKUP_ID customer_state_flag_ibfk_2
fee_formula_master.FORUMLA_LOOKUP_ID fee_formula_master_ibfk_1
fee_frequency_type.LOOKUP_ID fee_frequency_type_ibfk_1
fee_payment.FEE_PAYMENT_LOOKUP_ID fee_payment_ibfk_1
fee_status.STATUS_LOOKUP_ID fee_status_ibfk_1
fee_update_type.LOOKUP_ID fee_update_type_ibfk_1
freq_of_deposits.LOOKUP_ID freq_of_deposits_ibfk_1
grace_period_type.LOOKUP_ID grace_period_type_ibfk_1
interest_calc_rule.LOOKUP_ID interest_calc_rule_ibfk_1
interest_calculation_types.INTEREST_CALCULATION_LOOKUP_ID interest_calculation_types_ibfk_1
interest_types.LOOKUP_ID interest_types_ibfk_2
language.LOOKUP_ID language_ibfk_1
loan_account.BUSINESS_ACTIVITIES_ID loan_account_ibfk_10
lookup_value_locale.LOOKUP_ID lookup_value_locale_ibfk_1
office_code.LOOKUP_ID office_code_ibfk_1
office_status.LOOKUP_ID office_status_ibfk_1
payment_type.PAYMENT_TYPE_LOOKUP_ID payment_type_ibfk_1
penalty.LOOKUP_ID penalty_ibfk_3
personnel.TITLE personnel_ibfk_5
personnel_details.GENDER personnel_details_ibfk_2
personnel_details.MARITAL_STATUS personnel_details_ibfk_3
personnel_level.LEVEL_NAME_ID personnel_level_ibfk_2
personnel_status.LOOKUP_ID personnel_status_ibfk_1
position.LOOKUP_ID position_ibfk_1
prd_applicable_master.LOOKUP_ID prd_applicable_master_ibfk_1
prd_category_status.LOOKUP_ID prd_category_status_ibfk_1
prd_state.PRD_STATE_LOOKUP_ID prd_state_ibfk_1
prd_type.PRD_TYPE_LOOKUP_ID prd_type_ibfk_1
program.LOOKUP_ID program_ibfk_2
rank_days_master.LOOKUP_ID rank_days_master_ibfk_1
recommended_amnt_unit.LOOKUP_ID recommended_amnt_unit_ibfk_1
repayment_rule.REPAYMENT_RULE_LOOKUP_ID repayment_rule_ibfk_1
savings_type.LOOKUP_ID savings_type_ibfk_1
spouse_father_lookup.LOOKUP_ID spouse_father_lookup_ibfk_1
week_days_master.LOOKUP_ID week_days_master_ibfk_1
yes_no_master.LOOKUP_ID yes_no_master_ibfk_1
ENTITY_ID smallint 6  √  null
lookup_entity.ENTITY_ID lookup_value_ibfk_1
LOOKUP_NAME varchar 100  √  null

Table contained 581 rows at Fri Dec 14 17:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
LOOKUP_ID Primary key Asc PRIMARY
ENTITY_ID Performance Asc LOOKUP_VALUE_IDX

Close relationships  within one two degrees of separation :