| tables views procedures functions indexes triggers | all changed |
zdback_devdbDeveloper databaselocalhost:3306/zdback_devdb |
zdback_uatdbProduction databaselocalhost:3306/zdback_uatdb |
address_types [PRIMARY] 1
|
address_types [PRIMARY] 1
|
address_types [canceled_by] 1
|
address_types [canceled_by] 1
|
address_types [created_by] 1
|
address_types [created_by] 1
|
address_types [status] 1
|
address_types [status] 1
|
address_types [updated_by] 1
|
address_types [updated_by] 1
|
amlo_customer_match_details [PRIMARY] 1
|
amlo_customer_match_details [PRIMARY] 1
|
amlo_customer_match_details [idx_amlo_entity_id] 1
|
amlo_customer_match_details [idx_amlo_entity_id] 1
|
amlo_customer_match_details [idx_customer_id] 1
|
amlo_customer_match_details [idx_customer_id] 1
|
amlo_customer_match_details [idx_match_method] 1
|
amlo_customer_match_details [idx_match_method] 1
|
amlo_customer_match_details [idx_run_id] 1
|
amlo_customer_match_details [idx_run_id] 1
|
amlo_scheduler_run_logs [PRIMARY] 1
|
amlo_scheduler_run_logs [PRIMARY] 1
|
amlo_scheduler_run_logs [uq_run_date] 1
|
amlo_scheduler_run_logs [uq_run_date] 1
|
application_beneficiaries [PRIMARY] 1
|
application_beneficiaries [PRIMARY] 1
|
application_beneficiaries [application_form_id] 1
|
application_beneficiaries [application_form_id] 1
|
application_beneficiaries [canceled_by] 1
|
application_beneficiaries [canceled_by] 1
|
application_beneficiaries [created_by] 1
|
application_beneficiaries [created_by] 1
|
application_beneficiaries [prefix_name_id] 1
|
application_beneficiaries [prefix_name_id] 1
|
application_beneficiaries [relationship_id] 1
|
application_beneficiaries [relationship_id] 1
|
application_beneficiaries [status] 1
|
application_beneficiaries [status] 1
|
application_beneficiaries [updated_by] 1
|
application_beneficiaries [updated_by] 1
|
application_collaterals [PRIMARY] 1
|
application_collaterals [PRIMARY] 1
|
application_collaterals [application_form_id] 1
|
application_collaterals [application_form_id] 1
|
application_collaterals [canceled_by] 1
|
application_collaterals [canceled_by] 1
|
application_collaterals [car_modification_id] 1
|
application_collaterals [car_modification_id] 1
|
application_collaterals [car_type_group_id] 1
|
application_collaterals [car_type_group_id] 1
|
application_collaterals [created_by] 1
|
application_collaterals [created_by] 1
|
application_collaterals [gas_installation_id] 1
|
application_collaterals [gas_installation_id] 1
|
application_collaterals [idx_collaterals_application] 2
|
application_collaterals [idx_collaterals_application] 2
|
application_collaterals [status] 1
|
application_collaterals [status] 1
|
application_collaterals [updated_by] 1
|
application_collaterals [updated_by] 1
|
application_contacts [PRIMARY] 1
|
application_contacts [PRIMARY] 1
|
application_contacts [application_form_id] 1
|
application_contacts [application_form_id] 1
|
application_contacts [canceled_by] 1
|
application_contacts [canceled_by] 1
|
application_contacts [created_by] 1
|
application_contacts [created_by] 1
|
application_contacts [prefix_name_id] 1
|
application_contacts [prefix_name_id] 1
|
application_contacts [relationship_id] 1
|
application_contacts [relationship_id] 1
|
application_contacts [status] 1
|
application_contacts [status] 1
|
application_contacts [updated_by] 1
|
application_contacts [updated_by] 1
|
application_documents [PRIMARY] 1
|
application_documents [PRIMARY] 1
|
application_documents [application_form_id] 1
|
application_documents [application_form_id] 1
|
application_documents [canceled_by] 1
|
application_documents [canceled_by] 1
|
application_documents [created_by] 1
|
application_documents [created_by] 1
|
application_documents [image_group_id] 1
|
application_documents [image_group_id] 1
|
application_documents [image_id] 1
|
application_documents [image_id] 1
|
application_documents [status] 1
|
application_documents [status] 1
|
application_documents [updated_by] 1
|
application_documents [updated_by] 1
|
application_form_types [PRIMARY] 1
|
application_form_types [PRIMARY] 1
|
application_form_types [canceled_by] 1
|
application_form_types [canceled_by] 1
|
application_form_types [created_by] 1
|
application_form_types [created_by] 1
|
application_form_types [status] 1
|
application_form_types [status] 1
|
application_form_types [updated_by] 1
|
application_form_types [updated_by] 1
|
application_forms [PRIMARY] 1
|
application_forms [PRIMARY] 1
|
application_forms [application_form_type_id] 1
|
application_forms [application_form_type_id] 1
|
application_forms [application_no] 1
|
application_forms [application_no] 1
|
application_forms [branch_id] 1
|
application_forms [branch_id] 1
|
application_forms [canceled_by] 1
|
application_forms [canceled_by] 1
|
application_forms [created_by] 1
|
application_forms [created_by] 1
|
application_forms [credit_checker_user_id] 1
|
application_forms [credit_checker_user_id] 1
|
application_forms [customer_id] 1
|
application_forms [customer_id] 1
|
application_forms [insurance_company_id] 1
|
application_forms [insurance_company_id] 1
|
application_forms [loan_officer_user_id] 1
|
application_forms [loan_officer_user_id] 1
|
application_forms [loan_type_id] 1
|
application_forms [loan_type_id] 1
|
application_forms [manager_user_id] 1
|
application_forms [manager_user_id] 1
|
application_forms [migration_id] 1
|
application_forms [migration_id] 1
|
application_forms [reference_no] 1
|
application_forms [reference_no] 1
|
application_forms [status] 1
|
application_forms [status] 1
|
application_forms [updated_by] 1
|
application_forms [updated_by] 1
|
application_guarantors [PRIMARY] 1
|
application_guarantors [PRIMARY] 1
|
application_guarantors [application_form_id] 1
|
application_guarantors [application_form_id] 1
|
application_guarantors [canceled_by] 1
|
application_guarantors [canceled_by] 1
|
application_guarantors [created_by] 1
|
application_guarantors [created_by] 1
|
application_guarantors [customer_id] 1
|
application_guarantors [customer_id] 1
|
application_guarantors [relationship_id] 1
|
application_guarantors [relationship_id] 1
|
application_guarantors [status] 1
|
application_guarantors [status] 1
|
application_guarantors [updated_by] 1
|
application_guarantors [updated_by] 1
|
application_land_collaterals [PRIMARY] 1
|
application_land_collaterals [PRIMARY] 1
|
application_land_collaterals [application_land_collaterals_application_form_id_index] 1
|
application_land_collaterals [application_land_collaterals_application_form_id_index] 1
|
application_land_collaterals [application_land_collaterals_building_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_building_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_canceled_by_index] 1
|
application_land_collaterals [application_land_collaterals_canceled_by_index] 1
|
application_land_collaterals [application_land_collaterals_car_enter_exit_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_car_enter_exit_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_created_by_index] 1
|
application_land_collaterals [application_land_collaterals_created_by_index] 1
|
application_land_collaterals [application_land_collaterals_entrance_exit_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_entrance_exit_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_land_characteristic_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_land_characteristic_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_land_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_land_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_road_characteristic_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_road_characteristic_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_road_width_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_road_width_type_id_index] 1
|
application_land_collaterals [application_land_collaterals_status_index] 1
|
application_land_collaterals [application_land_collaterals_status_index] 1
|
application_land_collaterals [application_land_collaterals_updated_by_index] 1
|
application_land_collaterals [application_land_collaterals_updated_by_index] 1
|
application_land_collaterals [land_collaterals_building_characteristic_type_id_index] 1
|
application_land_collaterals [land_collaterals_building_characteristic_type_id_index] 1
|
application_land_mortgagors [PRIMARY] 1
|
application_land_mortgagors [PRIMARY] 1
|
application_land_mortgagors [application_land_mortgagors_application_form_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_application_form_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_canceled_by_index] 1
|
application_land_mortgagors [application_land_mortgagors_canceled_by_index] 1
|
application_land_mortgagors [application_land_mortgagors_created_by_index] 1
|
application_land_mortgagors [application_land_mortgagors_created_by_index] 1
|
application_land_mortgagors [application_land_mortgagors_customer_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_customer_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_father_prefix_name_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_father_prefix_name_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_mother_prefix_name_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_mother_prefix_name_id_index] 1
|
application_land_mortgagors [application_land_mortgagors_status_index] 1
|
application_land_mortgagors [application_land_mortgagors_status_index] 1
|
application_land_mortgagors [application_land_mortgagors_updated_by_index] 1
|
application_land_mortgagors [application_land_mortgagors_updated_by_index] 1
|
appointment_attachments [PRIMARY] 1
|
appointment_attachments [PRIMARY] 1
|
appointment_attachments [appointment_id] 1
|
appointment_attachments [appointment_id] 1
|
appointment_attachments [canceled_by] 1
|
appointment_attachments [canceled_by] 1
|
appointment_attachments [created_by] 1
|
appointment_attachments [created_by] 1
|
appointment_car_statuses [PRIMARY] 1
|
appointment_car_statuses [PRIMARY] 1
|
appointment_car_statuses [canceled_by] 1
|
appointment_car_statuses [canceled_by] 1
|
appointment_car_statuses [created_by] 1
|
appointment_car_statuses [created_by] 1
|
appointment_car_statuses [status] 1
|
appointment_car_statuses [status] 1
|
appointment_car_statuses [updated_by] 1
|
appointment_car_statuses [updated_by] 1
|
appointment_remarks [PRIMARY] 1
|
appointment_remarks [PRIMARY] 1
|
appointment_remarks [canceled_by] 1
|
appointment_remarks [canceled_by] 1
|
appointment_remarks [contract_id] 1
|
appointment_remarks [contract_id] 1
|
appointment_remarks [created_by] 1
|
appointment_remarks [created_by] 1
|
appointments [PRIMARY] 1
|
appointments [PRIMARY] 1
|
appointments [appointment_car_status_id] 1
|
appointments [appointment_car_status_id] 1
|
appointments [appointment_date] 1
|
appointments [appointment_date] 1
|
appointments [canceled_by] 1
|
appointments [canceled_by] 1
|
appointments [contract_id] 1
|
appointments [contract_id] 1
|
appointments [created_by] 1
|
appointments [created_by] 1
|
ar_agings [PRIMARY] 1
|
ar_agings [PRIMARY] 1
|
ar_agings [canceled_by] 1
|
ar_agings [canceled_by] 1
|
ar_agings [code] 1
|
ar_agings [code] 1
|
ar_agings [created_by] 1
|
ar_agings [created_by] 1
|
ar_agings [status] 1
|
ar_agings [status] 1
|
ar_agings [updated_by] 1
|
ar_agings [updated_by] 1
|
auction_companies [PRIMARY] 1
|
auction_companies [PRIMARY] 1
|
auction_companies [auction_companies_canceled_by_index] 1
|
auction_companies [auction_companies_canceled_by_index] 1
|
auction_companies [auction_companies_created_by_index] 1
|
auction_companies [auction_companies_created_by_index] 1
|
auction_companies [auction_companies_region_id_index] 1
|
auction_companies [auction_companies_region_id_index] 1
|
auction_companies [auction_companies_status_index] 1
|
auction_companies [auction_companies_status_index] 1
|
auction_companies [auction_companies_updated_by_index] 1
|
auction_companies [auction_companies_updated_by_index] 1
|
bank_statement_types [PRIMARY] 1
|
bank_statement_types [PRIMARY] 1
|
bank_statement_types [bank_statement_types_canceled_by_index] 1
|
bank_statement_types [bank_statement_types_canceled_by_index] 1
|
bank_statement_types [bank_statement_types_created_by_index] 1
|
bank_statement_types [bank_statement_types_created_by_index] 1
|
bank_statement_types [bank_statement_types_status_index] 1
|
bank_statement_types [bank_statement_types_status_index] 1
|
bank_statement_types [bank_statement_types_type_of_used_index] 1
|
bank_statement_types [bank_statement_types_type_of_used_index] 1
|
bank_statement_types [bank_statement_types_updated_by_index] 1
|
bank_statement_types [bank_statement_types_updated_by_index] 1
|
bank_statements [PRIMARY] 1
|
bank_statements [PRIMARY] 1
|
bank_statements [bank_statements_bank_statement_type_id_index] 1
|
bank_statements [bank_statements_bank_statement_type_id_index] 1
|
bank_statements [bank_statements_book_bank_id_index] 1
|
bank_statements [bank_statements_book_bank_id_index] 1
|
bank_statements [bank_statements_canceled_by_index] 1
|
bank_statements [bank_statements_canceled_by_index] 1
|
bank_statements [bank_statements_created_by_index] 1
|
bank_statements [bank_statements_created_by_index] 1
|
bank_statements [bank_statements_from_book_bank_id_index] 1
|
bank_statements [bank_statements_from_book_bank_id_index] 1
|
bank_statements [bank_statements_reff_no_index] 1
|
bank_statements [bank_statements_reff_no_index] 1
|
bank_statements [bank_statements_statement_date_index] 1
|
bank_statements [bank_statements_statement_date_index] 1
|
bank_statements [bank_statements_statement_no_index] 1
|
bank_statements [bank_statements_statement_no_index] 1
|
bank_statements [bank_statements_status_index] 1
|
bank_statements [bank_statements_status_index] 1
|
bank_statements [bank_statements_updated_by_index] 1
|
bank_statements [bank_statements_updated_by_index] 1
|
banks [PRIMARY] 1
|
banks [PRIMARY] 1
|
banks [banks_canceled_by_index] 1
|
banks [banks_canceled_by_index] 1
|
banks [banks_code_unique] 1
|
banks [banks_code_unique] 1
|
banks [banks_created_by_index] 1
|
banks [banks_created_by_index] 1
|
banks [banks_status_index] 1
|
banks [banks_status_index] 1
|
banks [banks_updated_by_index] 1
|
banks [banks_updated_by_index] 1
|
bill_payment_lots [PRIMARY] 1
|
bill_payment_lots [PRIMARY] 1
|
bill_payment_lots [bank_id] 1
|
bill_payment_lots [bank_id] 1
|
bill_payment_lots [canceled_by] 1
|
bill_payment_lots [canceled_by] 1
|
bill_payment_lots [created_by] 1
|
bill_payment_lots [created_by] 1
|
bill_payment_lots [effective_date] 1
|
bill_payment_lots [effective_date] 1
|
bill_payment_lots [migration_id] 1
|
bill_payment_lots [migration_id] 1
|
bill_payment_lots [status] 1
|
bill_payment_lots [status] 1
|
bill_payment_lots [updated_by] 1
|
bill_payment_lots [updated_by] 1
|
bill_payments [PRIMARY] 1
|
bill_payments [PRIMARY] 1
|
bill_payments [bank_id] 1
|
bill_payments [bank_id] 1
|
bill_payments [bill_payment_lot_id] 1
|
bill_payments [bill_payment_lot_id] 1
|
bill_payments [canceled_by] 1
|
bill_payments [canceled_by] 1
|
bill_payments [created_by] 1
|
bill_payments [created_by] 1
|
bill_payments [migration_id] 1
|
bill_payments [migration_id] 1
|
bill_payments [receipt_id] 1
|
bill_payments [receipt_id] 1
|
bill_payments [ref_1] 1
|
bill_payments [ref_1] 1
|
bill_payments [ref_2] 1
|
bill_payments [ref_2] 1
|
bill_payments [ref_3] 1
|
bill_payments [ref_3] 1
|
bill_payments [status] 1
|
bill_payments [status] 1
|
bill_payments [updated_by] 1
|
bill_payments [updated_by] 1
|
book_bank_types [PRIMARY] 1
|
book_bank_types [PRIMARY] 1
|
book_bank_types [book_bank_types_canceled_by_index] 1
|
book_bank_types [book_bank_types_canceled_by_index] 1
|
book_bank_types [book_bank_types_created_by_index] 1
|
book_bank_types [book_bank_types_created_by_index] 1
|
book_bank_types [book_bank_types_status_index] 1
|
book_bank_types [book_bank_types_status_index] 1
|
book_bank_types [book_bank_types_updated_by_index] 1
|
book_bank_types [book_bank_types_updated_by_index] 1
|
book_banks [PRIMARY] 1
|
book_banks [PRIMARY] 1
|
book_banks [book_banks_bank_id_index] 1
|
book_banks [book_banks_bank_id_index] 1
|
book_banks [book_banks_book_bank_type_id_index] 1
|
book_banks [book_banks_book_bank_type_id_index] 1
|
book_banks [book_banks_branch_id_index] 1
|
book_banks [book_banks_branch_id_index] 1
|
book_banks [book_banks_canceled_by_index] 1
|
book_banks [book_banks_canceled_by_index] 1
|
book_banks [book_banks_created_by_index] 1
|
book_banks [book_banks_created_by_index] 1
|
book_banks [book_banks_status_index] 1
|
book_banks [book_banks_status_index] 1
|
book_banks [book_banks_updated_by_index] 1
|
book_banks [book_banks_updated_by_index] 1
|
branches [PRIMARY] 1
|
branches [PRIMARY] 1
|
branches [branches_canceled_by_index] 1
|
branches [branches_canceled_by_index] 1
|
branches [branches_code_unique] 1
|
branches [branches_code_unique] 1
|
branches [branches_created_by_index] 1
|
branches [branches_created_by_index] 1
|
branches [branches_status_index] 1
|
branches [branches_status_index] 1
|
branches [branches_updated_by_index] 1
|
branches [branches_updated_by_index] 1
|
brand_ltvs [PRIMARY] 1
|
brand_ltvs [PRIMARY] 1
|
brand_ltvs [model_ltvs_brand_id_index] 1
|
brand_ltvs [model_ltvs_brand_id_index] 1
|
brand_ltvs [model_ltvs_canceled_by_index] 1
|
brand_ltvs [model_ltvs_canceled_by_index] 1
|
brand_ltvs [model_ltvs_car_type_id_index] 1
|
brand_ltvs [model_ltvs_car_type_id_index] 1
|
brand_ltvs [model_ltvs_created_by_index] 1
|
brand_ltvs [model_ltvs_created_by_index] 1
|
brand_ltvs [model_ltvs_status_index] 1
|
brand_ltvs [model_ltvs_status_index] 1
|
brand_ltvs [model_ltvs_updated_by_index] 1
|
brand_ltvs [model_ltvs_updated_by_index] 1
|
brands [PRIMARY] 1
|
brands [PRIMARY] 1
|
brands [brands_canceled_by_index] 1
|
brands [brands_canceled_by_index] 1
|
brands [brands_created_by_index] 1
|
brands [brands_created_by_index] 1
|
brands [brands_status_index] 1
|
brands [brands_status_index] 1
|
brands [brands_updated_by_index] 1
|
brands [brands_updated_by_index] 1
|
building_characteristic_types [PRIMARY] 1
|
building_characteristic_types [PRIMARY] 1
|
building_characteristic_types [building_characteristic_types_canceled_by_index] 1
|
building_characteristic_types [building_characteristic_types_canceled_by_index] 1
|
building_characteristic_types [building_characteristic_types_created_by_index] 1
|
building_characteristic_types [building_characteristic_types_created_by_index] 1
|
building_characteristic_types [building_characteristic_types_status_index] 1
|
building_characteristic_types [building_characteristic_types_status_index] 1
|
building_characteristic_types [building_characteristic_types_updated_by_index] 1
|
building_characteristic_types [building_characteristic_types_updated_by_index] 1
|
building_types [PRIMARY] 1
|
building_types [PRIMARY] 1
|
building_types [building_types_canceled_by_index] 1
|
building_types [building_types_canceled_by_index] 1
|
building_types [building_types_created_by_index] 1
|
building_types [building_types_created_by_index] 1
|
building_types [building_types_status_index] 1
|
building_types [building_types_status_index] 1
|
building_types [building_types_updated_by_index] 1
|
building_types [building_types_updated_by_index] 1
|
business_types [PRIMARY] 1
|
business_types [PRIMARY] 1
|
business_types [canceled_by] 1
|
business_types [canceled_by] 1
|
business_types [created_by] 1
|
business_types [created_by] 1
|
business_types [status] 1
|
business_types [status] 1
|
business_types [updated_by] 1
|
business_types [updated_by] 1
|
car_enter_exit_types [PRIMARY] 1
|
car_enter_exit_types [PRIMARY] 1
|
car_enter_exit_types [car_enter_exit_types_canceled_by_index] 1
|
car_enter_exit_types [car_enter_exit_types_canceled_by_index] 1
|
car_enter_exit_types [car_enter_exit_types_created_by_index] 1
|
car_enter_exit_types [car_enter_exit_types_created_by_index] 1
|
car_enter_exit_types [car_enter_exit_types_status_index] 1
|
car_enter_exit_types [car_enter_exit_types_status_index] 1
|
car_enter_exit_types [car_enter_exit_types_updated_by_index] 1
|
car_enter_exit_types [car_enter_exit_types_updated_by_index] 1
|
car_modifications [PRIMARY] 1
|
car_modifications [PRIMARY] 1
|
car_modifications [model_ltvs_canceled_by_index] 1
|
car_modifications [model_ltvs_canceled_by_index] 1
|
car_modifications [model_ltvs_created_by_index] 1
|
car_modifications [model_ltvs_created_by_index] 1
|
car_modifications [model_ltvs_status_index] 1
|
car_modifications [model_ltvs_status_index] 1
|
car_modifications [model_ltvs_updated_by_index] 1
|
car_modifications [model_ltvs_updated_by_index] 1
|
car_type_groups [PRIMARY] 1
|
car_type_groups [PRIMARY] 1
|
car_type_groups [car_types_canceled_by_index] 1
|
car_type_groups [car_types_canceled_by_index] 1
|
car_type_groups [car_types_created_by_index] 1
|
car_type_groups [car_types_created_by_index] 1
|
car_type_groups [car_types_status_index] 1
|
car_type_groups [car_types_status_index] 1
|
car_type_groups [car_types_updated_by_index] 1
|
car_type_groups [car_types_updated_by_index] 1
|
car_types [PRIMARY] 1
|
car_types [PRIMARY] 1
|
car_types [car_type_group_id] 1
|
car_types [car_type_group_id] 1
|
car_types [car_types_canceled_by_index] 1
|
car_types [car_types_canceled_by_index] 1
|
car_types [car_types_created_by_index] 1
|
car_types [car_types_created_by_index] 1
|
car_types [car_types_status_index] 1
|
car_types [car_types_status_index] 1
|
car_types [car_types_updated_by_index] 1
|
car_types [car_types_updated_by_index] 1
|
cash_and_transfer_debtors [PRIMARY] 1
|
cash_and_transfer_debtors [PRIMARY] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_canceled_by_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_canceled_by_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_cash_and_transfer_type_id_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_cash_and_transfer_type_id_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_created_by_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_created_by_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_debtor_id_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_debtor_id_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_status_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_status_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_updated_by_index] 1
|
cash_and_transfer_debtors [cash_and_transfer_debtors_updated_by_index] 1
|
cash_and_transfer_types [PRIMARY] 1
|
cash_and_transfer_types [PRIMARY] 1
|
cash_and_transfer_types [bank_statement_types_canceled_by_index] 1
|
cash_and_transfer_types [bank_statement_types_canceled_by_index] 1
|
cash_and_transfer_types [bank_statement_types_created_by_index] 1
|
cash_and_transfer_types [bank_statement_types_created_by_index] 1
|
cash_and_transfer_types [bank_statement_types_status_index] 1
|
cash_and_transfer_types [bank_statement_types_status_index] 1
|
cash_and_transfer_types [bank_statement_types_type_of_used_index] 1
|
cash_and_transfer_types [bank_statement_types_type_of_used_index] 1
|
cash_and_transfer_types [bank_statement_types_updated_by_index] 1
|
cash_and_transfer_types [bank_statement_types_updated_by_index] 1
|
cash_and_transfers [PRIMARY] 1
|
cash_and_transfers [PRIMARY] 1
|
cash_and_transfers [bank_statements_bank_statement_type_id_index] 1
|
cash_and_transfers [bank_statements_bank_statement_type_id_index] 1
|
cash_and_transfers [bank_statements_canceled_by_index] 1
|
cash_and_transfers [bank_statements_canceled_by_index] 1
|
cash_and_transfers [bank_statements_created_by_index] 1
|
cash_and_transfers [bank_statements_created_by_index] 1
|
cash_and_transfers [bank_statements_statement_date_index] 1
|
cash_and_transfers [bank_statements_statement_date_index] 1
|
cash_and_transfers [bank_statements_statement_no_index] 1
|
cash_and_transfers [bank_statements_statement_no_index] 1
|
cash_and_transfers [bank_statements_status_index] 1
|
cash_and_transfers [bank_statements_status_index] 1
|
cash_and_transfers [bank_statements_updated_by_index] 1
|
cash_and_transfers [bank_statements_updated_by_index] 1
|
cash_and_transfers [from_book_bank_id] 1
|
cash_and_transfers [from_book_bank_id] 1
|
cash_and_transfers [reff_no] 1
|
cash_and_transfers [reff_no] 1
|
channels [PRIMARY] 1
|
channels [PRIMARY] 1
|
channels [canceled_by] 1
|
channels [canceled_by] 1
|
channels [created_by] 1
|
channels [created_by] 1
|
channels [status] 1
|
channels [status] 1
|
channels [updated_by] 1
|
channels [updated_by] 1
|
collection_assignments [PRIMARY] 1
|
collection_assignments [PRIMARY] 1
|
collection_assignments [collection_assignments_canceled_by_index] 1
|
collection_assignments [collection_assignments_canceled_by_index] 1
|
collection_assignments [collection_assignments_collection_worklist_id_index] 1
|
collection_assignments [collection_assignments_collection_worklist_id_index] 1
|
collection_assignments [collection_assignments_created_by_index] 1
|
collection_assignments [collection_assignments_created_by_index] 1
|
collection_assignments [collection_assignments_user_id_index] 1
|
collection_assignments [collection_assignments_user_id_index] 1
|
collection_targets [PRIMARY] 1
|
collection_targets [PRIMARY] 1
|
collection_targets [collection_targets_ar_aging_id_index] 1
|
collection_targets [collection_targets_ar_aging_id_index] 1
|
collection_targets [collection_targets_branch_id_index] 1
|
collection_targets [collection_targets_branch_id_index] 1
|
collection_targets [collection_targets_canceled_by_index] 1
|
collection_targets [collection_targets_canceled_by_index] 1
|
collection_targets [collection_targets_created_by_index] 1
|
collection_targets [collection_targets_created_by_index] 1
|
collection_targets [collection_targets_target_date_index] 1
|
collection_targets [collection_targets_target_date_index] 1
|
collection_targets [collection_targets_updated_by_index] 1
|
collection_targets [collection_targets_updated_by_index] 1
|
collection_worklists [PRIMARY] 1
|
collection_worklists [PRIMARY] 1
|
collection_worklists [collection_worklists_branch_id_index] 1
|
collection_worklists [collection_worklists_branch_id_index] 1
|
collection_worklists [collection_worklists_canceled_by_index] 1
|
collection_worklists [collection_worklists_canceled_by_index] 1
|
collection_worklists [collection_worklists_contract_id_index] 1
|
collection_worklists [collection_worklists_contract_id_index] 1
|
collection_worklists [collection_worklists_contract_no_index] 1
|
collection_worklists [collection_worklists_contract_no_index] 1
|
collection_worklists [collection_worklists_created_by_index] 1
|
collection_worklists [collection_worklists_created_by_index] 1
|
collection_worklists [collection_worklists_customer_id_index] 1
|
collection_worklists [collection_worklists_customer_id_index] 1
|
collection_worklists [collection_worklists_status_index] 1
|
collection_worklists [collection_worklists_status_index] 1
|
collection_worklists [collection_worklists_updated_by_index] 1
|
collection_worklists [collection_worklists_updated_by_index] 1
|
collection_worklists [collection_worklists_user_id_index] 1
|
collection_worklists [collection_worklists_user_id_index] 1
|
collection_worklists [collection_worklists_working_date_index] 1
|
collection_worklists [collection_worklists_working_date_index] 1
|
colors [PRIMARY] 1
|
colors [PRIMARY] 1
|
colors [canceled_by] 1
|
colors [canceled_by] 1
|
colors [created_by] 1
|
colors [created_by] 1
|
colors [status] 1
|
colors [status] 1
|
colors [updated_by] 1
|
colors [updated_by] 1
|
commission_rates [PRIMARY] 1
|
commission_rates [PRIMARY] 1
|
commission_rates [model_ltvs_brand_id_index] 1
|
commission_rates [model_ltvs_brand_id_index] 1
|
commission_rates [model_ltvs_canceled_by_index] 1
|
commission_rates [model_ltvs_canceled_by_index] 1
|
commission_rates [model_ltvs_car_type_id_index] 1
|
commission_rates [model_ltvs_car_type_id_index] 1
|
commission_rates [model_ltvs_created_by_index] 1
|
commission_rates [model_ltvs_created_by_index] 1
|
commission_rates [model_ltvs_status_index] 1
|
commission_rates [model_ltvs_status_index] 1
|
commission_rates [model_ltvs_updated_by_index] 1
|
commission_rates [model_ltvs_updated_by_index] 1
|
companies [PRIMARY] 1
|
companies [PRIMARY] 1
|
companies [companies_canceled_by_index] 1
|
companies [companies_canceled_by_index] 1
|
companies [companies_created_by_index] 1
|
companies [companies_created_by_index] 1
|
companies [companies_status_index] 1
|
companies [companies_status_index] 1
|
companies [companies_updated_by_index] 1
|
companies [companies_updated_by_index] 1
|
contract_addresses [PRIMARY] 1
|
contract_addresses [PRIMARY] 1
|
contract_addresses [address_type_id] 1
|
contract_addresses [address_type_id] 1
|
contract_addresses [canceled_by] 1
|
contract_addresses [canceled_by] 1
|
contract_addresses [contract_id] 1
|
contract_addresses [contract_id] 1
|
contract_addresses [created_by] 1
|
contract_addresses [created_by] 1
|
contract_addresses [status] 1
|
contract_addresses [status] 1
|
contract_addresses [updated_by] 1
|
contract_addresses [updated_by] 1
|
contract_adjustments [PRIMARY] 1
|
contract_adjustments [PRIMARY] 1
|
contract_adjustments [contract_adjustments_applied_by_foreign] 1
|
contract_adjustments [contract_adjustments_applied_by_foreign] 1
|
contract_adjustments [contract_adjustments_applied_index] 1
|
contract_adjustments [contract_adjustments_applied_index] 1
|
contract_adjustments [contract_adjustments_confirmed_applied_index] 2
|
contract_adjustments [contract_adjustments_confirmed_applied_index] 2
|
contract_adjustments [contract_adjustments_confirmed_by_foreign] 1
|
contract_adjustments [contract_adjustments_confirmed_by_foreign] 1
|
contract_adjustments [contract_adjustments_confirmed_index] 1
|
contract_adjustments [contract_adjustments_confirmed_index] 1
|
contract_adjustments [contract_adjustments_contract_id_confirmed_applied_index] 3
|
contract_adjustments [contract_adjustments_contract_id_confirmed_applied_index] 3
|
contract_adjustments [contract_adjustments_contract_id_index] 1
|
contract_adjustments [contract_adjustments_contract_id_index] 1
|
contract_adjustments [contract_adjustments_contract_no_index] 1
|
contract_adjustments [contract_adjustments_contract_no_index] 1
|
contract_adjustments [contract_adjustments_created_by_foreign] 1
|
contract_adjustments [contract_adjustments_created_by_foreign] 1
|
contract_adjustments [contract_adjustments_customer_id_foreign] 1
|
contract_adjustments [contract_adjustments_customer_id_foreign] 1
|
contract_comment_histories [PRIMARY] 1
|
contract_comment_histories [PRIMARY] 1
|
contract_comment_histories [application_form_id] 1
|
contract_comment_histories [application_form_id] 1
|
contract_comment_histories [contract_id] 1
|
contract_comment_histories [contract_id] 1
|
contract_comment_histories [contract_status_id] 1
|
contract_comment_histories [contract_status_id] 1
|
contract_comment_histories [user_id] 1
|
contract_comment_histories [user_id] 1
|
contract_creditors [PRIMARY] 1
|
contract_creditors [PRIMARY] 1
|
contract_creditors [bank_id] 1
|
contract_creditors [bank_id] 1
|
contract_creditors [canceled_by] 1
|
contract_creditors [canceled_by] 1
|
contract_creditors [contract_id] 1
|
contract_creditors [contract_id] 1
|
contract_creditors [created_by] 1
|
contract_creditors [created_by] 1
|
contract_creditors [dealer_id] 1
|
contract_creditors [dealer_id] 1
|
contract_creditors [debtor_id] 1
|
contract_creditors [debtor_id] 1
|
contract_creditors [paid_type_id] 1
|
contract_creditors [paid_type_id] 1
|
contract_creditors [reference_id] 1
|
contract_creditors [reference_id] 1
|
contract_creditors [status] 1
|
contract_creditors [status] 1
|
contract_creditors [updated_by] 1
|
contract_creditors [updated_by] 1
|
contract_creditors [user_id] 1
|
contract_creditors [user_id] 1
|
contract_debt_tables [PRIMARY] 1
|
contract_debt_tables [PRIMARY] 1
|
contract_debt_tables [canceled_by] 1
|
contract_debt_tables [canceled_by] 1
|
contract_debt_tables [contract_id] 1
|
contract_debt_tables [contract_id] 1
|
contract_debt_tables [created_by] 1
|
contract_debt_tables [created_by] 1
|
contract_debt_tables [term_no] 1
|
contract_debt_tables [term_no] 1
|
contract_payment_tables [PRIMARY] 1
|
contract_payment_tables [PRIMARY] 1
|
contract_payment_tables [canceled_by] 1
|
contract_payment_tables [canceled_by] 1
|
contract_payment_tables [contract_id] 1
|
contract_payment_tables [contract_id] 1
|
contract_payment_tables [created_by] 1
|
contract_payment_tables [created_by] 1
|
contract_payment_tables [due_date] 1
|
contract_payment_tables [due_date] 1
|
contract_payment_tables [idx_contract_canceled_term] 3
|
contract_payment_tables [idx_contract_canceled_term] |
contract_payment_tables [idx_payments_contract_date] 4
|
contract_payment_tables [idx_payments_contract_date] 4
|
contract_payment_tables [receipt_id] 1
|
contract_payment_tables [receipt_id] 1
|
contract_payment_tables [status] 1
|
contract_payment_tables [status] 1
|
contract_payment_tables [term_no] 1
|
contract_payment_tables [term_no] 1
|
contract_payment_tables [updated_by] 1
|
contract_payment_tables [updated_by] 1
|
contract_statuses [PRIMARY] 1
|
contract_statuses [PRIMARY] 1
|
contract_statuses [canceled_by] 1
|
contract_statuses [canceled_by] 1
|
contract_statuses [created_by] 1
|
contract_statuses [created_by] 1
|
contract_statuses [status] 1
|
contract_statuses [status] 1
|
contract_statuses [updated_by] 1
|
contract_statuses [updated_by] 1
|
contract_telephones [PRIMARY] 1
|
contract_telephones [PRIMARY] 1
|
contract_telephones [canceled_by] 1
|
contract_telephones [canceled_by] 1
|
contract_telephones [contract_id] 1
|
contract_telephones [contract_id] 1
|
contract_telephones [created_by] 1
|
contract_telephones [created_by] 1
|
contract_telephones [status] 1
|
contract_telephones [status] 1
|
contract_telephones [type] 1
|
contract_telephones [type] 1
|
contract_telephones [updated_by] 1
|
contract_telephones [updated_by] 1
|
contracts [PRIMARY] 1
|
contracts [PRIMARY] 1
|
contracts [agent_id] 1
|
contracts [agent_id] 1
|
contracts [application_form_id] 1
|
contracts [application_form_id] 1
|
contracts [branch_id] 1
|
contracts [branch_id] 1
|
contracts [canceled_by] 1
|
contracts [canceled_by] 1
|
contracts [channel_id] 1
|
contracts [channel_id] 1
|
contracts [contract_no] 1
|
contracts [contract_no] 1
|
contracts [contract_status_id] 1
|
contracts [contract_status_id] 1
|
contracts [created_by] 1
|
contracts [created_by] 1
|
contracts [customer_id] 1
|
contracts [customer_id] 1
|
contracts [dealer_id] 1
|
contracts [dealer_id] 1
|
contracts [idx_contracts_filtered_closed] 3
|
contracts [idx_contracts_filtered_closed] 3
|
contracts [insurance_company_id] 1
|
contracts [insurance_company_id] 1
|
contracts [loan_type_id] 1
|
contracts [loan_type_id] 1
|
contracts [migration_id] 1
|
contracts [migration_id] 1
|
contracts [sale_user_id] 1
|
contracts [sale_user_id] 1
|
contracts [updated_by] 1
|
contracts [updated_by] 1
|
customer_addresses [PRIMARY] 1
|
customer_addresses [PRIMARY] 1
|
customer_addresses [address_type_id] 1
|
customer_addresses [address_type_id] 1
|
customer_addresses [canceled_by] 1
|
customer_addresses [canceled_by] 1
|
customer_addresses [created_by] 1
|
customer_addresses [created_by] 1
|
customer_addresses [customer_id] 1
|
customer_addresses [customer_id] 1
|
customer_addresses [status] 1
|
customer_addresses [status] 1
|
customer_addresses [updated_by] 1
|
customer_addresses [updated_by] 1
|
customer_telephones [PRIMARY] 1
|
customer_telephones [PRIMARY] 1
|
customer_telephones [canceled_by] 1
|
customer_telephones [canceled_by] 1
|
customer_telephones [created_by] 1
|
customer_telephones [created_by] 1
|
customer_telephones [customer_id] 1
|
customer_telephones [customer_id] 1
|
customer_telephones [status] 1
|
customer_telephones [status] 1
|
customer_telephones [updated_by] 1
|
customer_telephones [updated_by] 1
|
customer_types [PRIMARY] 1
|
customer_types [PRIMARY] 1
|
customer_types [canceled_by] 1
|
customer_types [canceled_by] 1
|
customer_types [created_by] 1
|
customer_types [created_by] 1
|
customer_types [status] 1
|
customer_types [status] 1
|
customer_types [updated_by] 1
|
customer_types [updated_by] 1
|
customers [PRIMARY] 1
|
customers [PRIMARY] 1
|
customers [bank_id] 1
|
customers [bank_id] 1
|
customers [business_type_id] 1
|
customers [business_type_id] 1
|
customers [canceled_by] 1
|
customers [canceled_by] 1
|
customers [created_by] 1
|
customers [created_by] 1
|
customers [customer_type_id] 1
|
customers [customer_type_id] 1
|
customers [employment_status_id] 1
|
customers [employment_status_id] 1
|
customers [id_card_type_id] 1
|
customers [id_card_type_id] 1
|
customers [is_agent] 1
|
customers [is_agent] 1
|
customers [is_dealer] 1
|
customers [is_dealer] 1
|
customers [is_seller] 1
|
customers [is_seller] 1
|
customers [job_id] 1
|
customers [job_id] 1
|
customers [marital_status_id] 1
|
customers [marital_status_id] 1
|
customers [migration_id] 1
|
customers [migration_id] 1
|
customers [prefix_name_id] 1
|
customers [prefix_name_id] 1
|
customers [residential_style_id] 1
|
customers [residential_style_id] 1
|
customers [status] 1
|
customers [status] 1
|
customers [updated_by] 1
|
customers [updated_by] 1
|
daily_report_details [PRIMARY] 1
|
daily_report_details [PRIMARY] 1
|
daily_report_details [canceled_by] 1
|
daily_report_details [canceled_by] 1
|
daily_report_details [created_by] 1
|
daily_report_details [created_by] 1
|
daily_report_details [daily_report_group_detail_id] 1
|
daily_report_details [daily_report_group_detail_id] 1
|
daily_report_details [daily_report_group_id] 1
|
daily_report_details [daily_report_group_id] 1
|
daily_report_details [status] 1
|
daily_report_details [status] 1
|
daily_report_details [updated_by] 1
|
daily_report_details [updated_by] 1
|
daily_report_group_detail_items [PRIMARY] 1
|
daily_report_group_detail_items [PRIMARY] 1
|
daily_report_group_detail_items [canceled_by] 1
|
daily_report_group_detail_items [canceled_by] 1
|
daily_report_group_detail_items [created_by] 1
|
daily_report_group_detail_items [created_by] 1
|
daily_report_group_detail_items [daily_report_group_id] 1
|
daily_report_group_detail_items [daily_report_group_id] 1
|
daily_report_group_detail_items [item_id] 1
|
daily_report_group_detail_items [item_id] 1
|
daily_report_group_detail_items [status] 1
|
daily_report_group_detail_items [status] 1
|
daily_report_group_detail_items [updated_by] 1
|
daily_report_group_detail_items [updated_by] 1
|
daily_report_group_details [PRIMARY] 1
|
daily_report_group_details [PRIMARY] 1
|
daily_report_group_details [canceled_by] 1
|
daily_report_group_details [canceled_by] 1
|
daily_report_group_details [created_by] 1
|
daily_report_group_details [created_by] 1
|
daily_report_group_details [daily_report_group_id] 1
|
daily_report_group_details [daily_report_group_id] 1
|
daily_report_group_details [operation] 1
|
daily_report_group_details [operation] 1
|
daily_report_group_details [status] 1
|
daily_report_group_details [status] 1
|
daily_report_group_details [updated_by] 1
|
daily_report_group_details [updated_by] 1
|
daily_report_groups [PRIMARY] 1
|
daily_report_groups [PRIMARY] 1
|
daily_report_groups [canceled_by] 1
|
daily_report_groups [canceled_by] 1
|
daily_report_groups [created_by] 1
|
daily_report_groups [created_by] 1
|
daily_report_groups [status] 1
|
daily_report_groups [status] 1
|
daily_report_groups [updated_by] 1
|
daily_report_groups [updated_by] 1
|
daily_reports [PRIMARY] 1
|
daily_reports [PRIMARY] 1
|
daily_reports [approved_by] 1
|
daily_reports [approved_by] 1
|
daily_reports [book_bank_id] 1
|
daily_reports [book_bank_id] 1
|
daily_reports [canceled_by] 1
|
daily_reports [canceled_by] 1
|
daily_reports [created_by] 1
|
daily_reports [created_by] 1
|
daily_reports [daily_report_group_id] 1
|
daily_reports [daily_report_group_id] 1
|
daily_reports [daily_reports_hq_approved_by_IDX] 1
|
daily_reports [daily_reports_hq_approved_by_IDX] 1
|
daily_reports [report_date] 1
|
daily_reports [report_date] 1
|
daily_reports [status] 1
|
daily_reports [status] 1
|
daily_reports [updated_by] 1
|
daily_reports [updated_by] 1
|
debt_buyers [PRIMARY] 1
|
debt_buyers [PRIMARY] 1
|
debt_buyers [canceled_by] 1
|
debt_buyers [canceled_by] 1
|
debt_buyers [created_by] 1
|
debt_buyers [created_by] 1
|
debt_buyers [status] 1
|
debt_buyers [status] 1
|
debt_buyers [updated_by] 1
|
debt_buyers [updated_by] 1
|
debtor_statuses [PRIMARY] 2
|
debtor_statuses [PRIMARY] 2
|
debtor_statuses [debtor_statuses_ar_aging_id_index] 1
|
debtor_statuses [debtor_statuses_ar_aging_id_index] 1
|
debtor_statuses [debtor_statuses_branch_id_index] 1
|
debtor_statuses [debtor_statuses_branch_id_index] 1
|
debtor_statuses [debtor_statuses_contract_id_index] 1
|
debtor_statuses [debtor_statuses_contract_id_index] 1
|
debtor_statuses [debtor_statuses_contract_no_index] 1
|
debtor_statuses [debtor_statuses_contract_no_index] 1
|
debtor_statuses [debtor_statuses_customer_id_index] 1
|
debtor_statuses [debtor_statuses_customer_id_index] 1
|
debtor_statuses [debtor_statuses_previous_ar_aging_id_index] 1
|
debtor_statuses [debtor_statuses_previous_ar_aging_id_index] 1
|
debtor_statuses [debtor_statuses_report_date_index] 1
|
debtor_statuses [debtor_statuses_report_date_index] 1
|
debtors [PRIMARY] 1
|
debtors [PRIMARY] 1
|
debtors [canceled_by] 1
|
debtors [canceled_by] 1
|
debtors [created_by] 1
|
debtors [created_by] 1
|
debtors [status] 1
|
debtors [status] 1
|
debtors [updated_by] 1
|
debtors [updated_by] 1
|
debtors [with_vat] 1
|
debtors [with_vat] 1
|
debtors [withholding_tax] 1
|
debtors [withholding_tax] 1
|
employment_statuses [PRIMARY] 1
|
employment_statuses [PRIMARY] 1
|
employment_statuses [canceled_by] 1
|
employment_statuses [canceled_by] 1
|
employment_statuses [created_by] 1
|
employment_statuses [created_by] 1
|
employment_statuses [status] 1
|
employment_statuses [status] 1
|
employment_statuses [updated_by] 1
|
employment_statuses [updated_by] 1
|
entrance_exit_types [PRIMARY] 1
|
entrance_exit_types [PRIMARY] 1
|
entrance_exit_types [entrance_exit_types_canceled_by_index] 1
|
entrance_exit_types [entrance_exit_types_canceled_by_index] 1
|
entrance_exit_types [entrance_exit_types_created_by_index] 1
|
entrance_exit_types [entrance_exit_types_created_by_index] 1
|
entrance_exit_types [entrance_exit_types_status_index] 1
|
entrance_exit_types [entrance_exit_types_status_index] 1
|
entrance_exit_types [entrance_exit_types_updated_by_index] 1
|
entrance_exit_types [entrance_exit_types_updated_by_index] 1
|
failed_jobs [PRIMARY] 1
|
failed_jobs [PRIMARY] 1
|
gas_installations [PRIMARY] 1
|
gas_installations [PRIMARY] 1
|
gas_installations [model_ltvs_canceled_by_index] 1
|
gas_installations [model_ltvs_canceled_by_index] 1
|
gas_installations [model_ltvs_created_by_index] 1
|
gas_installations [model_ltvs_created_by_index] 1
|
gas_installations [model_ltvs_status_index] 1
|
gas_installations [model_ltvs_status_index] 1
|
gas_installations [model_ltvs_updated_by_index] 1
|
gas_installations [model_ltvs_updated_by_index] 1
|
id_card_types [PRIMARY] 1
|
id_card_types [PRIMARY] 1
|
id_card_types [canceled_by] 1
|
id_card_types [canceled_by] 1
|
id_card_types [created_by] 1
|
id_card_types [created_by] 1
|
id_card_types [status] 1
|
id_card_types [status] 1
|
id_card_types [updated_by] 1
|
id_card_types [updated_by] 1
|
image_groups [PRIMARY] 1
|
image_groups [PRIMARY] 1
|
image_groups [canceled_by] 1
|
image_groups [canceled_by] 1
|
image_groups [created_by] 1
|
image_groups [created_by] 1
|
image_groups [order_by] 1
|
image_groups [order_by] 1
|
image_groups [status] 1
|
image_groups [status] 1
|
image_groups [updated_by] 1
|
image_groups [updated_by] 1
|
images [PRIMARY] 1
|
images [PRIMARY] 1
|
images [canceled_by] 1
|
images [canceled_by] 1
|
images [created_by] 1
|
images [created_by] 1
|
images [group_id] 1
|
images [group_id] 1
|
images [name] 1
|
images [name] 1
|
images [order] 1
|
images [order] 1
|
images [status] 1
|
images [status] 1
|
images [updated_by] 1
|
images [updated_by] 1
|
insurance_car_type_groups [PRIMARY] 1
|
insurance_car_type_groups [PRIMARY] 1
|
insurance_car_type_groups [car_type_group_id] 1
|
insurance_car_type_groups [car_type_group_id] 1
|
insurance_car_type_groups [car_types_canceled_by_index] 1
|
insurance_car_type_groups [car_types_canceled_by_index] 1
|
insurance_car_type_groups [car_types_created_by_index] 1
|
insurance_car_type_groups [car_types_created_by_index] 1
|
insurance_car_type_groups [insurance_company_id] 1
|
insurance_car_type_groups [insurance_company_id] 1
|
insurance_companies [PRIMARY] 1
|
insurance_companies [PRIMARY] 1
|
insurance_companies [insurance_companies_canceled_by_index] 1
|
insurance_companies [insurance_companies_canceled_by_index] 1
|
insurance_companies [insurance_companies_created_by_index] 1
|
insurance_companies [insurance_companies_created_by_index] 1
|
insurance_companies [insurance_companies_insurance_id_IDX] 1
|
insurance_companies [insurance_companies_insurance_id_IDX] 1
|
insurance_companies [insurance_companies_status_index] 1
|
insurance_companies [insurance_companies_status_index] 1
|
insurance_companies [insurance_companies_updated_by_index] 1
|
insurance_companies [insurance_companies_updated_by_index] 1
|
insurance_rates [PRIMARY] 1
|
insurance_rates [PRIMARY] 1
|
insurance_rates [insurance_company_id] 1
|
insurance_rates [insurance_company_id] 1
|
insurance_rates [insurance_rates_canceled_by_index] 1
|
insurance_rates [insurance_rates_canceled_by_index] 1
|
insurance_rates [insurance_rates_created_by_index] 1
|
insurance_rates [insurance_rates_created_by_index] 1
|
insurance_rates [insurance_rates_status_index] 1
|
insurance_rates [insurance_rates_status_index] 1
|
insurance_rates [insurance_rates_updated_by_index] 1
|
insurance_rates [insurance_rates_updated_by_index] 1
|
insurance_sales [PRIMARY] 1
|
insurance_sales [PRIMARY] 1
|
insurance_sales [insurance_sales_branch_id_index] 1
|
insurance_sales [insurance_sales_branch_id_index] 1
|
insurance_sales [insurance_sales_canceled_by_index] 1
|
insurance_sales [insurance_sales_canceled_by_index] 1
|
insurance_sales [insurance_sales_contract_id_index] 1
|
insurance_sales [insurance_sales_contract_id_index] 1
|
insurance_sales [insurance_sales_created_by_index] 1
|
insurance_sales [insurance_sales_created_by_index] 1
|
insurance_sales [insurance_sales_customer_id_index] 1
|
insurance_sales [insurance_sales_customer_id_index] 1
|
insurance_sales [insurance_sales_insurance_company_id_index] 1
|
insurance_sales [insurance_sales_insurance_company_id_index] 1
|
insurance_sales [insurance_sales_insurance_id_index] 1
|
insurance_sales [insurance_sales_insurance_id_index] 1
|
insurance_sales [insurance_sales_receipt_id_index] 1
|
insurance_sales [insurance_sales_receipt_id_index] 1
|
insurance_sales [insurance_sales_sale_date_index] 1
|
insurance_sales [insurance_sales_sale_date_index] 1
|
insurance_sales [insurance_sales_status_index] 1
|
insurance_sales [insurance_sales_status_index] 1
|
insurance_sales [insurance_sales_updated_by_index] 1
|
insurance_sales [insurance_sales_updated_by_index] 1
|
insurance_types [PRIMARY] 1
|
insurance_types [PRIMARY] 1
|
insurance_types [canceled_by] 1
|
insurance_types [canceled_by] 1
|
insurance_types [created_by] 1
|
insurance_types [created_by] 1
|
insurance_types [status] 1
|
insurance_types [status] 1
|
insurance_types [updated_by] 1
|
insurance_types [updated_by] 1
|
insurances [PRIMARY] 1
|
insurances [PRIMARY] 1
|
insurances [canceled_by] 1
|
insurances [canceled_by] 1
|
insurances [created_by] 1
|
insurances [created_by] 1
|
insurances [insurance_type_id] 1
|
insurances [insurance_type_id] 1
|
insurances [status] 1
|
insurances [status] 1
|
insurances [updated_by] 1
|
insurances [updated_by] 1
|
jobs [PRIMARY] 1
|
jobs [PRIMARY] 1
|
jobs [business_type_id] 1
|
jobs [business_type_id] 1
|
jobs [canceled_by] 1
|
jobs [canceled_by] 1
|
jobs [created_by] 1
|
jobs [created_by] 1
|
jobs [status] 1
|
jobs [status] 1
|
jobs [updated_by] 1
|
jobs [updated_by] 1
|
land_characteristic_types [PRIMARY] 1
|
land_characteristic_types [PRIMARY] 1
|
land_characteristic_types [land_characteristic_types_canceled_by_index] 1
|
land_characteristic_types [land_characteristic_types_canceled_by_index] 1
|
land_characteristic_types [land_characteristic_types_created_by_index] 1
|
land_characteristic_types [land_characteristic_types_created_by_index] 1
|
land_characteristic_types [land_characteristic_types_status_index] 1
|
land_characteristic_types [land_characteristic_types_status_index] 1
|
land_characteristic_types [land_characteristic_types_updated_by_index] 1
|
land_characteristic_types [land_characteristic_types_updated_by_index] 1
|
land_types [PRIMARY] 1
|
land_types [PRIMARY] 1
|
land_types [land_types_canceled_by_index] 1
|
land_types [land_types_canceled_by_index] 1
|
land_types [land_types_created_by_index] 1
|
land_types [land_types_created_by_index] 1
|
land_types [land_types_status_index] 1
|
land_types [land_types_status_index] 1
|
land_types [land_types_updated_by_index] 1
|
land_types [land_types_updated_by_index] 1
|
litigation_appointment_attachments [PRIMARY] 1
|
litigation_appointment_attachments [PRIMARY] 1
|
litigation_appointment_attachments [litigation_appointment_attachments_canceled_by_index] 1
|
litigation_appointment_attachments [litigation_appointment_attachments_canceled_by_index] 1
|
litigation_appointment_attachments [litigation_appointment_attachments_created_by_index] 1
|
litigation_appointment_attachments [litigation_appointment_attachments_created_by_index] 1
|
litigation_appointment_attachments [litigation_appointment_id] 1
|
litigation_appointment_attachments [litigation_appointment_id] 1
|
litigation_appointment_car_statuses [PRIMARY] 1
|
litigation_appointment_car_statuses [PRIMARY] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_canceled_by_index] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_canceled_by_index] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_created_by_index] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_created_by_index] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_status_index] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_status_index] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_updated_by_index] 1
|
litigation_appointment_car_statuses [litigation_appointment_car_statuses_updated_by_index] 1
|
litigation_appointment_remarks [PRIMARY] 1
|
litigation_appointment_remarks [PRIMARY] 1
|
litigation_appointment_remarks [litigation_appointment_remarks_canceled_by_index] 1
|
litigation_appointment_remarks [litigation_appointment_remarks_canceled_by_index] 1
|
litigation_appointment_remarks [litigation_appointment_remarks_contract_id_index] 1
|
litigation_appointment_remarks [litigation_appointment_remarks_contract_id_index] 1
|
litigation_appointment_remarks [litigation_appointment_remarks_created_by_index] 1
|
litigation_appointment_remarks [litigation_appointment_remarks_created_by_index] 1
|
litigation_appointments [PRIMARY] 1
|
litigation_appointments [PRIMARY] 1
|
litigation_appointments [litigation_appointment_car_status_id] 1
|
litigation_appointments [litigation_appointment_car_status_id] 1
|
litigation_appointments [litigation_appointments_appointment_date_index] 1
|
litigation_appointments [litigation_appointments_appointment_date_index] 1
|
litigation_appointments [litigation_appointments_canceled_by_index] 1
|
litigation_appointments [litigation_appointments_canceled_by_index] 1
|
litigation_appointments [litigation_appointments_contract_id_index] 1
|
litigation_appointments [litigation_appointments_contract_id_index] 1
|
litigation_appointments [litigation_appointments_created_by_index] 1
|
litigation_appointments [litigation_appointments_created_by_index] 1
|
litigation_asset_types [PRIMARY] 1
|
litigation_asset_types [PRIMARY] 1
|
litigation_asset_types [canceled_by] 1
|
litigation_asset_types [canceled_by] 1
|
litigation_asset_types [created_by] 1
|
litigation_asset_types [created_by] 1
|
litigation_asset_types [status] 1
|
litigation_asset_types [status] 1
|
litigation_asset_types [updated_by] 1
|
litigation_asset_types [updated_by] 1
|
litigation_assets [PRIMARY] 1
|
litigation_assets [PRIMARY] 1
|
litigation_assets [application_form_id] 1
|
litigation_assets [application_form_id] 1
|
litigation_assets [canceled_by] 1
|
litigation_assets [canceled_by] 1
|
litigation_assets [created_by] 1
|
litigation_assets [created_by] 1
|
litigation_assets [litigation_asset_type_id] 1
|
litigation_assets [litigation_asset_type_id] 1
|
litigation_assets [status] 1
|
litigation_assets [status] 1
|
litigation_assets [updated_by] 1
|
litigation_assets [updated_by] 1
|
litigation_auction_events [PRIMARY] 1
|
litigation_auction_events [PRIMARY] 1
|
litigation_auction_events [canceled_by] 1
|
litigation_auction_events [canceled_by] 1
|
litigation_auction_events [created_by] 1
|
litigation_auction_events [created_by] 1
|
litigation_auction_events [status] 1
|
litigation_auction_events [status] 1
|
litigation_auction_events [updated_by] 1
|
litigation_auction_events [updated_by] 1
|
litigation_auctions [PRIMARY] 1
|
litigation_auctions [PRIMARY] 1
|
litigation_auctions [canceled_by] 1
|
litigation_auctions [canceled_by] 1
|
litigation_auctions [created_by] 1
|
litigation_auctions [created_by] 1
|
litigation_auctions [litigation_asset_id] 1
|
litigation_auctions [litigation_asset_id] 1
|
litigation_auctions [litigation_contract_id] 1
|
litigation_auctions [litigation_contract_id] 1
|
litigation_auctions [status] 1
|
litigation_auctions [status] 1
|
litigation_auctions [updated_by] 1
|
litigation_auctions [updated_by] 1
|
litigation_collection_assignments [PRIMARY] 1
|
litigation_collection_assignments [PRIMARY] 1
|
litigation_collection_assignments [litigation_collection_assignments_canceled_by_index] 1
|
litigation_collection_assignments [litigation_collection_assignments_canceled_by_index] 1
|
litigation_collection_assignments [litigation_collection_assignments_created_by_index] 1
|
litigation_collection_assignments [litigation_collection_assignments_created_by_index] 1
|
litigation_collection_assignments [litigation_collection_assignments_user_id_index] 1
|
litigation_collection_assignments [litigation_collection_assignments_user_id_index] 1
|
litigation_collection_assignments [litigation_collection_worklist_id] 1
|
litigation_collection_assignments [litigation_collection_worklist_id] 1
|
litigation_collection_worklists [PRIMARY] 1
|
litigation_collection_worklists [PRIMARY] 1
|
litigation_collection_worklists [litigation_collection_worklists_branch_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_branch_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_canceled_by_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_canceled_by_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_contract_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_contract_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_contract_no_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_contract_no_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_created_by_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_created_by_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_customer_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_customer_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_status_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_status_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_updated_by_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_updated_by_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_user_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_user_id_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_working_date_index] 1
|
litigation_collection_worklists [litigation_collection_worklists_working_date_index] 1
|
litigation_contract_types [PRIMARY] 1
|
litigation_contract_types [PRIMARY] 1
|
litigation_contract_types [canceled_by] 1
|
litigation_contract_types [canceled_by] 1
|
litigation_contract_types [created_by] 1
|
litigation_contract_types [created_by] 1
|
litigation_contract_types [status] 1
|
litigation_contract_types [status] 1
|
litigation_contract_types [updated_by] 1
|
litigation_contract_types [updated_by] 1
|
litigation_contracts [PRIMARY] 1
|
litigation_contracts [PRIMARY] 1
|
litigation_contracts [canceled_by] 1
|
litigation_contracts [canceled_by] 1
|
litigation_contracts [contract_id] 1
|
litigation_contracts [contract_id] 1
|
litigation_contracts [contract_no] 1
|
litigation_contracts [contract_no] 1
|
litigation_contracts [created_by] 1
|
litigation_contracts [created_by] 1
|
litigation_contracts [customer_id] 1
|
litigation_contracts [customer_id] 1
|
litigation_contracts [litigation_contract_type_id] 1
|
litigation_contracts [litigation_contract_type_id] 1
|
litigation_contracts [loan_type_id] 1
|
litigation_contracts [loan_type_id] 1
|
litigation_contracts [updated_by] 1
|
litigation_contracts [updated_by] 1
|
litigation_contracts_pending_approval [PRIMARY] 1
|
litigation_contracts_pending_approval [PRIMARY] 1
|
litigation_contracts_pending_approval [contract_id] 1
|
litigation_contracts_pending_approval [contract_id] 1
|
litigation_contracts_pending_approval [contract_no] 1
|
litigation_contracts_pending_approval [contract_no] 1
|
litigation_contracts_pending_approval [created_by] 1
|
litigation_contracts_pending_approval [created_by] 1
|
litigation_contracts_pending_approval [customer_id] 1
|
litigation_contracts_pending_approval [customer_id] 1
|
litigation_contracts_pending_approval [litigation_contract_type_id] 1
|
litigation_contracts_pending_approval [litigation_contract_type_id] 1
|
litigation_contracts_pending_approval [loan_type_id] 1
|
litigation_contracts_pending_approval [loan_type_id] 1
|
litigation_contracts_pending_approval [reviewed_by] 1
|
litigation_contracts_pending_approval [reviewed_by] 1
|
litigation_contracts_pending_approval [updated_by] 1
|
litigation_contracts_pending_approval [updated_by] 1
|
litigation_discounts [PRIMARY] 1
|
litigation_discounts [PRIMARY] 1
|
litigation_discounts [canceled_by] 1
|
litigation_discounts [canceled_by] 1
|
litigation_discounts [created_by] 1
|
litigation_discounts [created_by] 1
|
litigation_discounts [litigation_contract_id] 1
|
litigation_discounts [litigation_contract_id] 1
|
litigation_discounts [receipt_id] 1
|
litigation_discounts [receipt_id] 1
|
litigation_discounts [status] 1
|
litigation_discounts [status] 1
|
litigation_discounts [updated_by] 1
|
litigation_discounts [updated_by] 1
|
litigation_documents [PRIMARY] 1
|
litigation_documents [PRIMARY] 1
|
litigation_documents [application_form_id] 1
|
litigation_documents [application_form_id] 1
|
litigation_documents [canceled_by] 1
|
litigation_documents [canceled_by] 1
|
litigation_documents [created_by] 1
|
litigation_documents [created_by] 1
|
litigation_documents [status] 1
|
litigation_documents [status] 1
|
litigation_documents [updated_by] 1
|
litigation_documents [updated_by] 1
|
litigation_payment_tables [PRIMARY] 1
|
litigation_payment_tables [PRIMARY] 1
|
litigation_payment_tables [canceled_by] 1
|
litigation_payment_tables [canceled_by] 1
|
litigation_payment_tables [created_by] 1
|
litigation_payment_tables [created_by] 1
|
litigation_payment_tables [due_date] 1
|
litigation_payment_tables [due_date] 1
|
litigation_payment_tables [litigation_contract_id] 1
|
litigation_payment_tables [litigation_contract_id] 1
|
litigation_payment_tables [receipt_id] 1
|
litigation_payment_tables [receipt_id] 1
|
litigation_payment_tables [status] 1
|
litigation_payment_tables [status] 1
|
litigation_payment_tables [term_no] 1
|
litigation_payment_tables [term_no] 1
|
litigation_payment_tables [updated_by] 1
|
litigation_payment_tables [updated_by] 1
|
loan_periods [PRIMARY] 1
|
loan_periods [PRIMARY] 1
|
loan_periods [loan_periods_canceled_by_index] 1
|
loan_periods [loan_periods_canceled_by_index] 1
|
loan_periods [loan_periods_created_by_index] 1
|
loan_periods [loan_periods_created_by_index] 1
|
loan_periods [loan_periods_status_index] 1
|
loan_periods [loan_periods_status_index] 1
|
loan_periods [loan_periods_updated_by_index] 1
|
loan_periods [loan_periods_updated_by_index] 1
|
loan_targets [PRIMARY] 1
|
loan_targets [PRIMARY] 1
|
loan_targets [loan_targets_branch_id_index] 1
|
loan_targets [loan_targets_branch_id_index] 1
|
loan_targets [loan_targets_canceled_by_index] 1
|
loan_targets [loan_targets_canceled_by_index] 1
|
loan_targets [loan_targets_created_by_index] 1
|
loan_targets [loan_targets_created_by_index] 1
|
loan_targets [loan_targets_target_date_index] 1
|
loan_targets [loan_targets_target_date_index] 1
|
loan_targets [loan_targets_updated_by_index] 1
|
loan_targets [loan_targets_updated_by_index] 1
|
loan_types [PRIMARY] 1
|
loan_types [PRIMARY] 1
|
loan_types [loan_types_canceled_by_index] 1
|
loan_types [loan_types_canceled_by_index] 1
|
loan_types [loan_types_created_by_index] 1
|
loan_types [loan_types_created_by_index] 1
|
loan_types [loan_types_status_index] 1
|
loan_types [loan_types_status_index] 1
|
loan_types [loan_types_updated_by_index] 1
|
loan_types [loan_types_updated_by_index] 1
|
marital_status_types [PRIMARY] 1
|
marital_status_types [PRIMARY] 1
|
marital_status_types [canceled_by] 1
|
marital_status_types [canceled_by] 1
|
marital_status_types [created_by] 1
|
marital_status_types [created_by] 1
|
marital_status_types [status] 1
|
marital_status_types [status] 1
|
marital_status_types [updated_by] 1
|
marital_status_types [updated_by] 1
|
menus [PRIMARY] 1
|
menus [PRIMARY] 1
|
menus [menus_canceled_by_index] 1
|
menus [menus_canceled_by_index] 1
|
menus [menus_created_by_index] 1
|
menus [menus_created_by_index] 1
|
menus [menus_parent_id_index] 1
|
menus [menus_parent_id_index] 1
|
menus [menus_updated_by_index] 1
|
menus [menus_updated_by_index] 1
|
migrations [PRIMARY] 1
|
migrations [PRIMARY] 1
|
model_detail_images [PRIMARY] 1
|
model_detail_images [PRIMARY] 1
|
model_detail_images [model_detail_name] 1
|
model_detail_images [model_detail_name] 1
|
model_detail_images [model_images_canceled_by_index] 1
|
model_detail_images [model_images_canceled_by_index] 1
|
model_detail_images [model_images_created_by_index] 1
|
model_detail_images [model_images_created_by_index] 1
|
model_detail_images [model_images_status_index] 1
|
model_detail_images [model_images_status_index] 1
|
model_details [PRIMARY] 1
|
model_details [PRIMARY] 1
|
model_details [model_details_canceled_by_index] 1
|
model_details [model_details_canceled_by_index] 1
|
model_details [model_details_created_by_index] 1
|
model_details [model_details_created_by_index] 1
|
model_details [model_details_model_id_index] 1
|
model_details [model_details_model_id_index] 1
|
model_details [model_details_status_index] 1
|
model_details [model_details_status_index] 1
|
model_details [model_details_updated_by_index] 1
|
model_details [model_details_updated_by_index] 1
|
model_details [name] 1
|
model_details [name] 1
|
model_images [PRIMARY] 1
|
model_images [PRIMARY] 1
|
model_images [model_images_canceled_by_index] 1
|
model_images [model_images_canceled_by_index] 1
|
model_images [model_images_created_by_index] 1
|
model_images [model_images_created_by_index] 1
|
model_images [model_images_model_id_index] 1
|
model_images [model_images_model_id_index] 1
|
model_images [model_images_status_index] 1
|
model_images [model_images_status_index] 1
|
models [PRIMARY] 1
|
models [PRIMARY] 1
|
models [car_type_id] 1
|
models [car_type_id] 1
|
models [models_brand_id_index] 1
|
models [models_brand_id_index] 1
|
models [models_canceled_by_index] 1
|
models [models_canceled_by_index] 1
|
models [models_created_by_index] 1
|
models [models_created_by_index] 1
|
models [models_status_index] 1
|
models [models_status_index] 1
|
models [models_updated_by_index] 1
|
models [models_updated_by_index] 1
|
notice_letters [PRIMARY] 1
|
notice_letters [PRIMARY] 1
|
notice_letters [notice_letters_branch_id_index] 1
|
notice_letters [notice_letters_branch_id_index] 1
|
notice_letters [notice_letters_brand_id_index] 1
|
notice_letters [notice_letters_brand_id_index] 1
|
notice_letters [notice_letters_canceled_by_index] 1
|
notice_letters [notice_letters_canceled_by_index] 1
|
notice_letters [notice_letters_car_type_id_index] 1
|
notice_letters [notice_letters_car_type_id_index] 1
|
notice_letters [notice_letters_contract_id_index] 1
|
notice_letters [notice_letters_contract_id_index] 1
|
notice_letters [notice_letters_contract_no_index] 1
|
notice_letters [notice_letters_contract_no_index] 1
|
notice_letters [notice_letters_created_by_index] 1
|
notice_letters [notice_letters_created_by_index] 1
|
notice_letters [notice_letters_customer_id_index] 1
|
notice_letters [notice_letters_customer_id_index] 1
|
notice_letters [notice_letters_guarantor1_id_index] 1
|
notice_letters [notice_letters_guarantor1_id_index] 1
|
notice_letters [notice_letters_guarantor2_id_index] 1
|
notice_letters [notice_letters_guarantor2_id_index] 1
|
notice_letters [notice_letters_guarantor3_id_index] 1
|
notice_letters [notice_letters_guarantor3_id_index] 1
|
notice_letters [notice_letters_model_detail_id_index] 1
|
notice_letters [notice_letters_model_detail_id_index] 1
|
notice_letters [notice_letters_model_id_index] 1
|
notice_letters [notice_letters_model_id_index] 1
|
notice_letters [notice_letters_notice_date_index] 1
|
notice_letters [notice_letters_notice_date_index] 1
|
notice_letters [notice_letters_notice_no_index] 1
|
notice_letters [notice_letters_notice_no_index] 1
|
notice_letters [notice_letters_status_index] 1
|
notice_letters [notice_letters_status_index] 1
|
notice_letters [notice_letters_updated_by_index] 1
|
notice_letters [notice_letters_updated_by_index] 1
|
paid_types [PRIMARY] 1
|
paid_types [PRIMARY] 1
|
paid_types [canceled_by] 1
|
paid_types [canceled_by] 1
|
paid_types [created_by] 1
|
paid_types [created_by] 1
|
paid_types [status] 1
|
paid_types [status] 1
|
paid_types [updated_by] 1
|
paid_types [updated_by] 1
|
parking_lots [PRIMARY] 1
|
parking_lots [PRIMARY] 1
|
parking_lots [parking_lots_canceled_by_index] 1
|
parking_lots [parking_lots_canceled_by_index] 1
|
parking_lots [parking_lots_created_by_index] 1
|
parking_lots [parking_lots_created_by_index] 1
|
parking_lots [parking_lots_parent_id_index] 1
|
parking_lots [parking_lots_parent_id_index] 1
|
parking_lots [parking_lots_status_index] 1
|
parking_lots [parking_lots_status_index] 1
|
parking_lots [parking_lots_updated_by_index] 1
|
parking_lots [parking_lots_updated_by_index] 1
|
password_resets [password_resets_email_index] 1
|
password_resets [password_resets_email_index] 1
|
pay_contract_lots [PRIMARY] 1
|
pay_contract_lots [PRIMARY] 1
|
pay_contract_lots [canceled_by] 1
|
pay_contract_lots [canceled_by] 1
|
pay_contract_lots [created_by] 1
|
pay_contract_lots [created_by] 1
|
pay_contract_lots [status] 1
|
pay_contract_lots [status] 1
|
pay_contract_lots [updated_by] 1
|
pay_contract_lots [updated_by] 1
|
pay_contracts [PRIMARY] 1
|
pay_contracts [PRIMARY] 1
|
pay_contracts [approved_by] 1
|
pay_contracts [approved_by] 1
|
pay_contracts [bank_id] 1
|
pay_contracts [bank_id] 1
|
pay_contracts [branch_id] 1
|
pay_contracts [branch_id] 1
|
pay_contracts [canceled_by] 1
|
pay_contracts [canceled_by] 1
|
pay_contracts [contract_id] 1
|
pay_contracts [contract_id] 1
|
pay_contracts [created_by] 1
|
pay_contracts [created_by] 1
|
pay_contracts [customer_id] 1
|
pay_contracts [customer_id] 1
|
pay_contracts [done_by] 1
|
pay_contracts [done_by] 1
|
pay_contracts [pay_contract_lot_id] 1
|
pay_contracts [pay_contract_lot_id] 1
|
pay_contracts [payment_voucher_id] 1
|
pay_contracts [payment_voucher_id] 1
|
pay_contracts [status] 1
|
pay_contracts [status] 1
|
pay_contracts [updated_by] 1
|
pay_contracts [updated_by] 1
|
pay_contracts [user_id] 1
|
pay_contracts [user_id] 1
|
payment_voucher_details [PRIMARY] 1
|
payment_voucher_details [PRIMARY] 1
|
payment_voucher_details [canceled_by] 1
|
payment_voucher_details [canceled_by] 1
|
payment_voucher_details [created_by] 1
|
payment_voucher_details [created_by] 1
|
payment_voucher_details [debtor_id] 1
|
payment_voucher_details [debtor_id] 1
|
payment_voucher_details [payment_voucher_id] 1
|
payment_voucher_details [payment_voucher_id] 1
|
payment_voucher_details [status] 1
|
payment_voucher_details [status] 1
|
payment_voucher_details [updated_by] 1
|
payment_voucher_details [updated_by] 1
|
payment_vouchers [PRIMARY] 1
|
payment_vouchers [PRIMARY] 1
|
payment_vouchers [branch_id] 1
|
payment_vouchers [branch_id] 1
|
payment_vouchers [canceled_by] 1
|
payment_vouchers [canceled_by] 1
|
payment_vouchers [contract_id] 1
|
payment_vouchers [contract_id] 1
|
payment_vouchers [created_by] 1
|
payment_vouchers [created_by] 1
|
payment_vouchers [customer_id] 1
|
payment_vouchers [customer_id] 1
|
payment_vouchers [dealer_id] 1
|
payment_vouchers [dealer_id] 1
|
payment_vouchers [status] 1
|
payment_vouchers [status] 1
|
payment_vouchers [updated_by] 1
|
payment_vouchers [updated_by] 1
|
payment_vouchers [voucher_no] 1
|
payment_vouchers [voucher_no] 1
|
permissions [PRIMARY] 1
|
permissions [PRIMARY] 1
|
permissions [permissions_canceled_by_index] 1
|
permissions [permissions_canceled_by_index] 1
|
permissions [permissions_created_by_index] 1
|
permissions [permissions_created_by_index] 1
|
permissions [permissions_menu_id_index] 1
|
permissions [permissions_menu_id_index] 1
|
permissions [permissions_role_id_index] 1
|
permissions [permissions_role_id_index] 1
|
permissions [permissions_updated_by_index] 1
|
permissions [permissions_updated_by_index] 1
|
prefix_names [PRIMARY] 1
|
prefix_names [PRIMARY] 1
|
prefix_names [prefix_names_canceled_by_index] 1
|
prefix_names [prefix_names_canceled_by_index] 1
|
prefix_names [prefix_names_created_by_index] 1
|
prefix_names [prefix_names_created_by_index] 1
|
prefix_names [prefix_names_status_index] 1
|
prefix_names [prefix_names_status_index] 1
|
prefix_names [prefix_names_updated_by_index] 1
|
prefix_names [prefix_names_updated_by_index] 1
|
price_list_histories [PRIMARY] 1
|
price_list_histories [PRIMARY] 1
|
price_list_histories [car_type_id] 1
|
price_list_histories [car_type_id] 1
|
price_list_histories [log_by] 1
|
price_list_histories [log_by] 1
|
price_list_histories [price_list_id] 1
|
price_list_histories [price_list_id] 1
|
price_list_histories [price_lists_brand_id_index] 1
|
price_list_histories [price_lists_brand_id_index] 1
|
price_list_histories [price_lists_canceled_by_index] 1
|
price_list_histories [price_lists_canceled_by_index] 1
|
price_list_histories [price_lists_created_by_index] 1
|
price_list_histories [price_lists_created_by_index] 1
|
price_list_histories [price_lists_model_detail_id_index] 1
|
price_list_histories [price_lists_model_detail_id_index] 1
|
price_list_histories [price_lists_model_id_index] 1
|
price_list_histories [price_lists_model_id_index] 1
|
price_list_histories [price_lists_price_list_version_id_index] 1
|
price_list_histories [price_lists_price_list_version_id_index] 1
|
price_list_histories [price_lists_status_index] 1
|
price_list_histories [price_lists_status_index] 1
|
price_list_histories [price_lists_updated_by_index] 1
|
price_list_histories [price_lists_updated_by_index] 1
|
price_list_versions [PRIMARY] 1
|
price_list_versions [PRIMARY] 1
|
price_list_versions [price_list_versions_canceled_by_index] 1
|
price_list_versions [price_list_versions_canceled_by_index] 1
|
price_list_versions [price_list_versions_created_by_index] 1
|
price_list_versions [price_list_versions_created_by_index] 1
|
price_list_versions [price_list_versions_status_index] 1
|
price_list_versions [price_list_versions_status_index] 1
|
price_list_versions [price_list_versions_updated_by_index] 1
|
price_list_versions [price_list_versions_updated_by_index] 1
|
price_lists [PRIMARY] 1
|
price_lists [PRIMARY] 1
|
price_lists [car_type_id] 1
|
price_lists [car_type_id] 1
|
price_lists [price_lists_brand_id_index] 1
|
price_lists [price_lists_brand_id_index] 1
|
price_lists [price_lists_canceled_by_index] 1
|
price_lists [price_lists_canceled_by_index] 1
|
price_lists [price_lists_created_by_index] 1
|
price_lists [price_lists_created_by_index] 1
|
price_lists [price_lists_model_detail_id_index] 1
|
price_lists [price_lists_model_detail_id_index] 1
|
price_lists [price_lists_model_id_index] 1
|
price_lists [price_lists_model_id_index] 1
|
price_lists [price_lists_price_list_version_id_index] 1
|
price_lists [price_lists_price_list_version_id_index] 1
|
price_lists [price_lists_status_index] 1
|
price_lists [price_lists_status_index] 1
|
price_lists [price_lists_updated_by_index] 1
|
price_lists [price_lists_updated_by_index] 1
|
receipt_details [PRIMARY] 1
|
receipt_details [PRIMARY] 1
|
receipt_details [canceled_by] 1
|
receipt_details [canceled_by] 1
|
receipt_details [created_by] 1
|
receipt_details [created_by] 1
|
receipt_details [debtor_id] 1
|
receipt_details [debtor_id] 1
|
receipt_details [receipt_id] 1
|
receipt_details [receipt_id] 1
|
receipt_details [status] 1
|
receipt_details [status] 1
|
receipt_details [updated_by] 1
|
receipt_details [updated_by] 1
|
receipts [PRIMARY] 1
|
receipts [PRIMARY] 1
|
receipts [bill_payment_id] 1
|
receipts [bill_payment_id] 1
|
receipts [branch_id] 1
|
receipts [branch_id] 1
|
receipts [canceled_by] 1
|
receipts [canceled_by] 1
|
receipts [contract_id] 1
|
receipts [contract_id] 1
|
receipts [created_by] 1
|
receipts [created_by] 1
|
receipts [customer_id] 1
|
receipts [customer_id] 1
|
receipts [dealer_id] 1
|
receipts [dealer_id] 1
|
receipts [migration_id] 1
|
receipts [migration_id] 1
|
receipts [receipt_no] 1
|
receipts [receipt_no] 1
|
receipts [status] 1
|
receipts [status] 1
|
receipts [updated_by] 1
|
receipts [updated_by] 1
|
regions [PRIMARY] 1
|
regions [PRIMARY] 1
|
regions [regions_canceled_by_index] 1
|
regions [regions_canceled_by_index] 1
|
regions [regions_created_by_index] 1
|
regions [regions_created_by_index] 1
|
regions [regions_status_index] 1
|
regions [regions_status_index] 1
|
regions [regions_updated_by_index] 1
|
regions [regions_updated_by_index] 1
|
relationships [PRIMARY] 1
|
relationships [PRIMARY] 1
|
relationships [canceled_by] 1
|
relationships [canceled_by] 1
|
relationships [created_by] 1
|
relationships [created_by] 1
|
relationships [status] 1
|
relationships [status] 1
|
relationships [updated_by] 1
|
relationships [updated_by] 1
|
residential_styles [PRIMARY] 1
|
residential_styles [PRIMARY] 1
|
residential_styles [canceled_by] 1
|
residential_styles [canceled_by] 1
|
residential_styles [created_by] 1
|
residential_styles [created_by] 1
|
residential_styles [status] 1
|
residential_styles [status] 1
|
residential_styles [updated_by] 1
|
residential_styles [updated_by] 1
|
road_characteristic_types [PRIMARY] 1
|
road_characteristic_types [PRIMARY] 1
|
road_characteristic_types [road_characteristic_types_canceled_by_index] 1
|
road_characteristic_types [road_characteristic_types_canceled_by_index] 1
|
road_characteristic_types [road_characteristic_types_created_by_index] 1
|
road_characteristic_types [road_characteristic_types_created_by_index] 1
|
road_characteristic_types [road_characteristic_types_status_index] 1
|
road_characteristic_types [road_characteristic_types_status_index] 1
|
road_characteristic_types [road_characteristic_types_updated_by_index] 1
|
road_characteristic_types [road_characteristic_types_updated_by_index] 1
|
road_width_types [PRIMARY] 1
|
road_width_types [PRIMARY] 1
|
road_width_types [road_width_types_canceled_by_index] 1
|
road_width_types [road_width_types_canceled_by_index] 1
|
road_width_types [road_width_types_created_by_index] 1
|
road_width_types [road_width_types_created_by_index] 1
|
road_width_types [road_width_types_status_index] 1
|
road_width_types [road_width_types_status_index] 1
|
road_width_types [road_width_types_updated_by_index] 1
|
road_width_types [road_width_types_updated_by_index] 1
|
roles [PRIMARY] 1
|
roles [PRIMARY] 1
|
roles [roles_canceled_by_index] 1
|
roles [roles_canceled_by_index] 1
|
roles [roles_created_by_index] 1
|
roles [roles_created_by_index] 1
|
roles [roles_status_index] 1
|
roles [roles_status_index] 1
|
roles [roles_updated_by_index] 1
|
roles [roles_updated_by_index] 1
|
seized_car_documents [PRIMARY] 1
|
seized_car_documents [PRIMARY] 1
|
seized_car_documents [seized_car_documents_canceled_by_index] 1
|
seized_car_documents [seized_car_documents_canceled_by_index] 1
|
seized_car_documents [seized_car_documents_created_by_index] 1
|
seized_car_documents [seized_car_documents_created_by_index] 1
|
seized_car_documents [seized_car_documents_image_group_id_index] 1
|
seized_car_documents [seized_car_documents_image_group_id_index] 1
|
seized_car_documents [seized_car_documents_image_id_index] 1
|
seized_car_documents [seized_car_documents_image_id_index] 1
|
seized_car_documents [seized_car_documents_seized_car_id_index] 1
|
seized_car_documents [seized_car_documents_seized_car_id_index] 1
|
seized_car_documents [seized_car_documents_status_index] 1
|
seized_car_documents [seized_car_documents_status_index] 1
|
seized_car_documents [seized_car_documents_updated_by_index] 1
|
seized_car_documents [seized_car_documents_updated_by_index] 1
|
seized_car_prices [PRIMARY] 1
|
seized_car_prices [PRIMARY] 1
|
seized_car_prices [seized_car_prices_auction_date_index] 1
|
seized_car_prices [seized_car_prices_auction_date_index] 1
|
seized_car_prices [seized_car_prices_canceled_by_index] 1
|
seized_car_prices [seized_car_prices_canceled_by_index] 1
|
seized_car_prices [seized_car_prices_created_by_index] 1
|
seized_car_prices [seized_car_prices_created_by_index] 1
|
seized_car_prices [seized_car_prices_seized_car_id_index] 1
|
seized_car_prices [seized_car_prices_seized_car_id_index] 1
|
seized_car_prices [seized_car_prices_status_index] 1
|
seized_car_prices [seized_car_prices_status_index] 1
|
seized_car_prices [seized_car_prices_updated_by_index] 1
|
seized_car_prices [seized_car_prices_updated_by_index] 1
|
seized_cars [PRIMARY] 1
|
seized_cars [PRIMARY] 1
|
seized_cars [idx_seized_cars_contract_date] 3
|
seized_cars [idx_seized_cars_contract_date] 3
|
seized_cars [litigation_contract_id] 1
|
seized_cars [litigation_contract_id] 1
|
seized_cars [seized_cars_ar_aging_code_index] 1
|
seized_cars [seized_cars_ar_aging_code_index] 1
|
seized_cars [seized_cars_ar_aging_id_index] 1
|
seized_cars [seized_cars_ar_aging_id_index] 1
|
seized_cars [seized_cars_auction_company_id_index] 1
|
seized_cars [seized_cars_auction_company_id_index] 1
|
seized_cars [seized_cars_branch_id_index] 1
|
seized_cars [seized_cars_branch_id_index] 1
|
seized_cars [seized_cars_canceled_by_index] 1
|
seized_cars [seized_cars_canceled_by_index] 1
|
seized_cars [seized_cars_contract_id_index] 1
|
seized_cars [seized_cars_contract_id_index] 1
|
seized_cars [seized_cars_created_by_index] 1
|
seized_cars [seized_cars_created_by_index] 1
|
seized_cars [seized_cars_customer_id_index] 1
|
seized_cars [seized_cars_customer_id_index] 1
|
seized_cars [seized_cars_parking_lot_id_index] 1
|
seized_cars [seized_cars_parking_lot_id_index] 1
|
seized_cars [seized_cars_report_date_index] 1
|
seized_cars [seized_cars_report_date_index] 1
|
seized_cars [seized_cars_seized_car_date_index] 1
|
seized_cars [seized_cars_seized_car_date_index] 1
|
seized_cars [seized_cars_selled_date_index] 1
|
seized_cars [seized_cars_selled_date_index] 1
|
seized_cars [seized_cars_status_index] 1
|
seized_cars [seized_cars_status_index] 1
|
seized_cars [seized_cars_temporary_date_index] 1
|
seized_cars [seized_cars_temporary_date_index] 1
|
seized_cars [seized_cars_updated_by_index] 1
|
seized_cars [seized_cars_updated_by_index] 1
|
temp_import_contracts [PRIMARY] 1
|
temp_import_contracts [PRIMARY] 1
|
temp_import_contracts [temp_import_contracts_branch_code_IDX] 1
|
temp_import_contracts [temp_import_contracts_branch_code_IDX] 1
|
temp_import_customers [PRIMARY] 1
|
temp_import_customers [PRIMARY] 1
|
user_roles [PRIMARY] 1
|
user_roles [PRIMARY] 1
|
user_roles [branch_id] 1
|
user_roles [branch_id] 1
|
user_roles [canceled_by] 1
|
user_roles [canceled_by] 1
|
user_roles [created_by] 1
|
user_roles [created_by] 1
|
user_roles [role_id] 1
|
user_roles [role_id] 1
|
user_roles [status] 1
|
user_roles [status] 1
|
user_roles [user_id] 1
|
user_roles [user_id] 1
|
users [PRIMARY] 1
|
users [PRIMARY] 1
|
users [users_branch_id_index] 1
|
users [users_branch_id_index] 1
|
users [users_canceled_by_index] 1
|
users [users_canceled_by_index] 1
|
users [users_created_by_index] 1
|
users [users_created_by_index] 1
|
users [users_email_unique] 1
|
users [users_email_unique] 1
|
users [users_prefix_name_id_index] 1
|
users [users_prefix_name_id_index] 1
|
users [users_role_id_index] 1
|
users [users_role_id_index] 1
|
users [users_status_index] 1
|
users [users_status_index] 1
|
users [users_updated_by_index] 1
|
users [users_updated_by_index] 1
|
withholding_taxes [PRIMARY] 1
|
withholding_taxes [PRIMARY] 1
|
withholding_taxes [withholding_taxes_branch_id_index] 1
|
withholding_taxes [withholding_taxes_branch_id_index] 1
|
withholding_taxes [withholding_taxes_canceled_by_index] 1
|
withholding_taxes [withholding_taxes_canceled_by_index] 1
|
withholding_taxes [withholding_taxes_created_by_index] 1
|
withholding_taxes [withholding_taxes_created_by_index] 1
|
withholding_taxes [withholding_taxes_customer_id_index] 1
|
withholding_taxes [withholding_taxes_customer_id_index] 1
|
withholding_taxes [withholding_taxes_debtor_id_index] 1
|
withholding_taxes [withholding_taxes_debtor_id_index] 1
|
withholding_taxes [withholding_taxes_payment_voucher_id_index] 1
|
withholding_taxes [withholding_taxes_payment_voucher_id_index] 1
|
withholding_taxes [withholding_taxes_status_index] 1
|
withholding_taxes [withholding_taxes_status_index] 1
|
withholding_taxes [withholding_taxes_tax_date_index] 1
|
withholding_taxes [withholding_taxes_tax_date_index] 1
|
withholding_taxes [withholding_taxes_tax_no_index] 1
|
withholding_taxes [withholding_taxes_tax_no_index] 1
|
withholding_taxes [withholding_taxes_updated_by_index] 1
|
withholding_taxes [withholding_taxes_updated_by_index] 1
|
worklist_access_histories [PRIMARY] 1
|
worklist_access_histories [PRIMARY] 1
|
worklist_access_histories [user_id] 1
|
worklist_access_histories [user_id] 1
|
worklist_access_histories [worklist_id] 1
|
worklist_access_histories [worklist_id] 1
|
worklist_users [PRIMARY] 1
|
worklist_users [PRIMARY] 1
|
worklist_users [branch_id] 1
|
worklist_users [branch_id] 1
|
worklist_users [canceled_by] 1
|
worklist_users [canceled_by] 1
|
worklist_users [created_by] 1
|
worklist_users [created_by] 1
|
worklist_users [role_id] 1
|
worklist_users [role_id] 1
|
worklist_users [status] 1
|
worklist_users [status] 1
|
worklist_users [user_id] 1
|
worklist_users [user_id] 1
|
worklist_users [worklist_id] 1
|
worklist_users [worklist_id] 1
|
worklists [PRIMARY] 1
|
worklists [PRIMARY] 1
|
worklists [canceled_by] 1
|
worklists [canceled_by] 1
|
worklists [created_by] 1
|
worklists [created_by] 1
|
worklists [name] 1
|
worklists [name] 1
|
worklists [status] 1
|
worklists [status] 1
|
worklists [updated_by] 1
|
worklists [updated_by] 1
|
worklists [worked_by] 1
|
worklists [worked_by] 1
|
For more information go to compalex.net