SchemaSpy - Table db164.lookup

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

√

null

lookup_entity.ENTITY_ID

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

Indexes:

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