m_code_value

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
acc_gl_account.tag_id fkglacc000000002 R
acc_product_mapping.buydown_fee_classification_id fk_acc_product_mapping_buydown_fee_classification R
acc_product_mapping.capitalized_income_classification_id fk_acc_product_mapping_capitalized_income_classification R
acc_product_mapping.charge_off_reason_id fk_acc_product_mapping_charge_off_reason R
acc_rule_tags.tag_id FK_m_code_value_id R
m_address.country_id address_fields_codefk2 R
m_address.state_province_id address_fields_codefk1 R
m_client.client_classification_cv_id FK_m_client_classification_m_code_value R
m_client.client_type_cv_id FK_m_client_type_m_code_value R
m_client.closure_reason_cv_id FK_m_client_m_code R
m_client.gender_cv_id FK1_m_client_gender_m_code_value R
m_client.reject_reason_cv_id FK_m_client_type_mcode_value_reject R
m_client.sub_status FK_m_client_substatus_m_code_value R
m_client.withdraw_reason_cv_id FK_m_client_type_m_code_value_withdraw R
m_client_address.address_type_id address_codefk R
m_client_identifier.document_type_id FK_m_client_document_m_code_value R
m_family_members.gender_cv_id FK_m_family_members_gender_m_code_value R
m_family_members.marital_status_cv_id FK_m_family_members_marital_status_m_code_value R
m_family_members.profession_cv_id FK_m_family_members_profession_m_code_value R
m_family_members.relationship_cv_id FK_m_family_members_relationship_m_code_value R
m_group.closure_reason_cv_id FK_m_group_m_code R
m_group_roles.role_cv_id FK_grouprole_m_codevalue R
m_guarantor.client_reln_cv_id FK_m_guarantor_m_code_value R
m_loan.loanpurpose_cv_id FK_m_loanpurpose_codevalue R
m_loan.writeoff_reason_cv_id FK_writeoffreason_m_loan_m_code_value R
m_loan_collateral.type_cv_id FK_collateral_code_value R
m_loan_originator.channel_type_cv_id FK_loan_originator_channel_cv R
m_loan_originator.originator_type_cv_id FK_loan_originator_type_cv R
m_loan_reage_parameter.reage_reason_code_value_id FK_reage_reason_code_m_code_value R
m_loan_reamortization_parameter.reamortization_reason_code_value_id FK_reamortization_reason_code_m_code_value R
m_loan_reschedule_request.reschedule_reason_cv_id m_loan_reschedule_request_ibfk_2 R
m_wc_loan.charge_off_reason_cv_id FK_m_wc_loan_charge_off_reason R
m_wc_loan.write_off_reason_cv_id FK_m_wc_loan_write_off_reason R
m_wc_loan_transaction.classification_cv_id FK_m_wc_loan_transaction_classification_cv R
code_id int4 10 null
m_code.id fkcfcea42640be071z R
code_value varchar 100 √ null
code_description varchar 500 √ null
order_position int4 10 0
code_score int4 10 √ null
is_active bool 1 true
is_mandatory bool 1 false

Indexes

Constraint Name Type Sort Column(s)
m_code_value_pkey Primary key Asc id
code_value Must be unique Asc/Asc code_id + code_value
fkcfcea42640be071z Performance Asc code_id

Relationships