Compalex.net

Database schema compare tool

tables views procedures functions indexes triggers  all changed

zdback_devdb

Developer database

localhost:3306/zdback_devdb

zdback_uatdb

Production database

localhost:3306/zdback_uatdb

v_ar_aging_export 22

  • report_date date
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • total bigint(21)
  • principal_balance decimal(34,2)
  • 0dpd_total decimal(22,0)
  • 0dpd_port decimal(34,2)
  • 30dpd_total decimal(22,0)
  • 30dpd_port decimal(34,2)
  • 60dpd_total decimal(22,0)
  • 60dpd_port decimal(34,2)
  • 90dpd_total decimal(22,0)
  • 90dpd_port decimal(34,2)
  • 120dpd_total decimal(22,0)
  • 120dpd_port decimal(34,2)
  • 150dpd_total decimal(22,0)
  • 150dpd_port decimal(34,2)
  • 365dpd_total decimal(22,0)
  • 365dpd_port decimal(34,2)
  • 366dpd_total decimal(22,0)
  • 366dpd_port decimal(34,2)
Sample data (100 rows)

v_ar_aging_export 22

  • report_date date
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • total bigint(21)
  • principal_balance decimal(34,2)
  • 0dpd_total decimal(22,0)
  • 0dpd_port decimal(34,2)
  • 30dpd_total decimal(22,0)
  • 30dpd_port decimal(34,2)
  • 60dpd_total decimal(22,0)
  • 60dpd_port decimal(34,2)
  • 90dpd_total decimal(22,0)
  • 90dpd_port decimal(34,2)
  • 120dpd_total decimal(22,0)
  • 120dpd_port decimal(34,2)
  • 150dpd_total decimal(22,0)
  • 150dpd_port decimal(34,2)
  • 365dpd_total decimal(22,0)
  • 365dpd_port decimal(34,2)
  • 366dpd_total decimal(22,0)
  • 366dpd_port decimal(34,2)
Sample data (100 rows)

v_car_brand_models 8

  • brand_id bigint(20) unsigned
  • brand_name varchar(255)
  • model_id bigint(20) unsigned
  • model_name varchar(255)
  • model_detail_id bigint(20) unsigned
  • model_detail_name varchar(255)
  • cc decimal(8,2)
  • year int(10) unsigned
Sample data (100 rows)

v_car_brand_models 8

  • brand_id bigint(20) unsigned
  • brand_name varchar(255)
  • model_id bigint(20) unsigned
  • model_name varchar(255)
  • model_detail_id bigint(20) unsigned
  • model_detail_name varchar(255)
  • cc decimal(8,2)
  • year int(10) unsigned
Sample data (100 rows)

v_collection_by_branch 18

  • report_date date
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • total bigint(21)
  • principal_balance decimal(34,2)
  • current_total decimal(22,0)
  • current_port decimal(34,2)
  • xday_total decimal(22,0)
  • xday_port decimal(34,2)
  • 30pdp_total decimal(22,0)
  • 30pdp_port decimal(34,2)
  • 60dpd_total decimal(22,0)
  • 60dpd_port decimal(34,2)
  • 90dpd_total decimal(22,0)
  • 90dpd_port decimal(34,2)
  • over90dpd_total decimal(22,0)
  • over90dpd_port decimal(34,2)
Sample data (100 rows)

v_collection_by_branch 18

  • report_date date
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • total bigint(21)
  • principal_balance decimal(34,2)
  • current_total decimal(22,0)
  • current_port decimal(34,2)
  • xday_total decimal(22,0)
  • xday_port decimal(34,2)
  • 30pdp_total decimal(22,0)
  • 30pdp_port decimal(34,2)
  • 60dpd_total decimal(22,0)
  • 60dpd_port decimal(34,2)
  • 90dpd_total decimal(22,0)
  • 90dpd_port decimal(34,2)
  • over90dpd_total decimal(22,0)
  • over90dpd_port decimal(34,2)
Sample data (100 rows)

v_insurance_export 41

  • report_date date
  • insurance_id decimal(20,0)
  • insurance_name varchar(255)
  • id varchar(21)
  • branch_id bigint(20) unsigned
  • branch_code varchar(50)
  • branch_name varchar(255)
  • contract_no varchar(50)
  • id_card_number varchar(50)
  • application_id bigint(20)
  • application_no varchar(50)
  • application_date date
  • prefix_name varchar(255)
  • first_name varchar(255)
  • last_name varchar(255)
  • gender tinyint(4)
  • nationality varchar(50)
  • age int(5)
  • date_of_birth date
  • job_id varchar(50)
  • job_name varchar(255)
  • address varchar(255)
  • sub_district varchar(255)
  • district varchar(255)
  • province varchar(255)
  • zipcode varchar(255)
  • telephone_number varchar(255)
  • seller_id varchar(50)
  • seller_user varchar(511)
  • initials varchar(255)
  • contract_date date
  • effective_date date
  • first_due_date date
  • last_due_date date
  • loan_amount decimal(13,2) unsigned
  • term int(10) unsigned
  • loan_interest_rate decimal(7,4) unsigned
  • installment_amount decimal(12,2) unsigned
  • insurance_premium decimal(12,2) unsigned
  • debt_amount_before_insurance decimal(12,2) unsigned
  • debt_amount decimal(12,2) unsigned
Sample data (100 rows)

v_insurance_export 41

  • report_date date
  • insurance_id decimal(20,0)
  • insurance_name varchar(255)
  • id varchar(21)
  • branch_id bigint(20) unsigned
  • branch_code varchar(50)
  • branch_name varchar(255)
  • contract_no varchar(50)
  • id_card_number varchar(50)
  • application_id bigint(20)
  • application_no varchar(50)
  • application_date date
  • prefix_name varchar(255)
  • first_name varchar(255)
  • last_name varchar(255)
  • gender tinyint(4)
  • nationality varchar(50)
  • age int(5)
  • date_of_birth date
  • job_id varchar(50)
  • job_name varchar(255)
  • address varchar(255)
  • sub_district varchar(255)
  • district varchar(255)
  • province varchar(255)
  • zipcode varchar(255)
  • telephone_number varchar(255)
  • seller_id varchar(50)
  • seller_user varchar(511)
  • initials varchar(255)
  • contract_date date
  • effective_date date
  • first_due_date date
  • last_due_date date
  • loan_amount decimal(13,2) unsigned
  • term int(10) unsigned
  • loan_interest_rate decimal(7,4) unsigned
  • installment_amount decimal(12,2) unsigned
  • insurance_premium decimal(12,2) unsigned
  • debt_amount_before_insurance decimal(12,2) unsigned
  • debt_amount decimal(12,2) unsigned
Sample data (100 rows)

v_insurance_rates 9

  • id bigint(20) unsigned
  • name varchar(255)
  • initials varchar(255)
  • min_age int(10) unsigned
  • max_age int(10) unsigned
  • insurance_year int(10) unsigned
  • male_rate decimal(7,4)
  • female_rate decimal(7,4)
  • started_date datetime
Sample data (100 rows)

v_insurance_rates 9

  • id bigint(20) unsigned
  • name varchar(255)
  • initials varchar(255)
  • min_age int(10) unsigned
  • max_age int(10) unsigned
  • insurance_year int(10) unsigned
  • male_rate decimal(7,4)
  • female_rate decimal(7,4)
  • started_date datetime
Sample data (100 rows)

v_insurances 24

  • id varchar(21)
  • contract_id bigint(20)
  • receipt_id decimal(20,0)
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • contract_date date
  • contract_no varchar(50)
  • customer_id bigint(20) unsigned
  • prefix_name varchar(255)
  • first_name varchar(255)
  • last_name varchar(255)
  • id_card_number varchar(50)
  • gender tinyint(4)
  • date_of_birth date
  • insurance_id decimal(20,0)
  • insurance_name varchar(255)
  • insurance_company_id decimal(20,0)
  • insurance_company_name varchar(255)
  • insurance_company_initials varchar(255)
  • insurance_premium decimal(12,2)
  • contract_status_id bigint(20) unsigned
  • report_date date
  • canceled_at timestamp /* mariadb-5.3 */
Sample data (100 rows)

v_insurances 24

  • id varchar(21)
  • contract_id bigint(20)
  • receipt_id decimal(20,0)
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • contract_date date
  • contract_no varchar(50)
  • customer_id bigint(20) unsigned
  • prefix_name varchar(255)
  • first_name varchar(255)
  • last_name varchar(255)
  • id_card_number varchar(50)
  • gender tinyint(4)
  • date_of_birth date
  • insurance_id decimal(20,0)
  • insurance_name varchar(255)
  • insurance_company_id decimal(20,0)
  • insurance_company_name varchar(255)
  • insurance_company_initials varchar(255)
  • insurance_premium decimal(12,2)
  • contract_status_id bigint(20) unsigned
  • report_date date
  • canceled_at timestamp /* mariadb-5.3 */
Sample data (100 rows)

v_non_life_insurances 18

  • id decimal(20,0)
  • contract_id bigint(20)
  • receipt_id decimal(20,0)
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • contract_date date
  • contract_no varchar(50)
  • customer_id bigint(20) unsigned
  • prefix_name varchar(255)
  • first_name varchar(255)
  • last_name varchar(255)
  • non_life_insurance_id decimal(20,0)
  • non_life_insurance_name varchar(255)
  • non_life_insurance_premium decimal(12,2)
  • contract_status_id bigint(20) unsigned
  • report_date date
  • canceled_at timestamp /* mariadb-5.3 */
Sample data (100 rows)

v_non_life_insurances 18

  • id decimal(20,0)
  • contract_id bigint(20)
  • receipt_id decimal(20,0)
  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • contract_date date
  • contract_no varchar(50)
  • customer_id bigint(20) unsigned
  • prefix_name varchar(255)
  • first_name varchar(255)
  • last_name varchar(255)
  • non_life_insurance_id decimal(20,0)
  • non_life_insurance_name varchar(255)
  • non_life_insurance_premium decimal(12,2)
  • contract_status_id bigint(20) unsigned
  • report_date date
  • canceled_at timestamp /* mariadb-5.3 */
Sample data (100 rows)

v_price_lists 15

  • id bigint(20) unsigned
  • price_list_version_id bigint(20) unsigned
  • car_type_id bigint(20) unsigned
  • car_type_name varchar(255)
  • brand_id bigint(20) unsigned
  • brand_name varchar(255)
  • model_id bigint(20) unsigned
  • model_name varchar(255)
  • model_detail_id bigint(20) unsigned
  • model_detail_name varchar(255)
  • cc decimal(8,2)
  • year int(10) unsigned
  • price decimal(12,2)
  • ltv_rate decimal(5,2)
  • amount decimal(17,4)
Sample data (100 rows)

v_price_lists 15

  • id bigint(20) unsigned
  • price_list_version_id bigint(20) unsigned
  • car_type_id bigint(20) unsigned
  • car_type_name varchar(255)
  • brand_id bigint(20) unsigned
  • brand_name varchar(255)
  • model_id bigint(20) unsigned
  • model_name varchar(255)
  • model_detail_id bigint(20) unsigned
  • model_detail_name varchar(255)
  • cc decimal(8,2)
  • year int(10) unsigned
  • price decimal(12,2)
  • ltv_rate decimal(5,2)
  • amount decimal(17,4)
Sample data (100 rows)

v_pt40s 20

  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • receipt_id bigint(20) unsigned
  • receipt_no varchar(50)
  • receipt_date date
  • contract_id bigint(20) unsigned
  • contract_no varchar(50)
  • customer_id bigint(20) unsigned
  • received_from varchar(255)
  • fee_amount decimal(34,2)
  • interest_amount decimal(34,2)
  • fine_amount decimal(34,2)
  • collection_fee_amount decimal(34,2)
  • amount decimal(34,2)
  • net decimal(12,2)
  • specific_business_tax decimal(36,2)
  • local_tax decimal(38,2)
  • total_tax decimal(39,2)
  • remark text
Sample data (100 rows)

v_pt40s 20

  • branch_id bigint(20) unsigned
  • branch_code varchar(255)
  • branch_name varchar(255)
  • receipt_id bigint(20) unsigned
  • receipt_no varchar(50)
  • receipt_date date
  • contract_id bigint(20) unsigned
  • contract_no varchar(50)
  • customer_id bigint(20) unsigned
  • received_from varchar(255)
  • fee_amount decimal(34,2)
  • interest_amount decimal(34,2)
  • fine_amount decimal(34,2)
  • collection_fee_amount decimal(34,2)
  • amount decimal(34,2)
  • net decimal(12,2)
  • specific_business_tax decimal(36,2)
  • local_tax decimal(38,2)
  • total_tax decimal(39,2)
  • remark text
Sample data (100 rows)

v_users 7

  • id bigint(20) unsigned
  • branch_id bigint(20)
  • role_id bigint(20)
  • prefix_name_id bigint(20) unsigned
  • first_name varchar(255)
  • last_name varchar(255)
  • full_name text
Sample data (100 rows)

v_users 7

  • id bigint(20) unsigned
  • branch_id bigint(20)
  • role_id bigint(20)
  • prefix_name_id bigint(20) unsigned
  • first_name varchar(255)
  • last_name varchar(255)
  • full_name text
Sample data (100 rows)

 

For more information go to compalex.net