Compalex.net

address_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

address_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

amlo_customer_match_details ¹⁹

• match_id bigint(20) unsigned
• run_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• customer_first_name varchar(255)
• customer_last_name varchar(255)
• customer_id_card_number varchar(50)
• customer_id_card_type varchar(50)
• amlo_entity_id varchar(30)
• amlo_brief_name varchar(255)
• amlo_single_string_name text
• amlo_matched_id_value varchar(500)
• amlo_info_source varchar(20)
• match_method varchar(50)
• match_timestamp datetime
• is_false_positive tinyint(1)
• review_status varchar(50)
• reviewer_notes text
• reviewed_by varchar(100)
• reviewed_at datetime

amlo_customer_match_details ¹⁹

• match_id bigint(20) unsigned
• run_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• customer_first_name varchar(255)
• customer_last_name varchar(255)
• customer_id_card_number varchar(50)
• customer_id_card_type varchar(50)
• amlo_entity_id varchar(30)
• amlo_brief_name varchar(255)
• amlo_single_string_name text
• amlo_matched_id_value varchar(500)
• amlo_info_source varchar(20)
• match_method varchar(50)
• match_timestamp datetime
• is_false_positive tinyint(1)
• review_status varchar(50)
• reviewer_notes text
• reviewed_by varchar(100)
• reviewed_at datetime

amlo_scheduler_run_logs ¹⁵

• run_id bigint(20) unsigned
• run_date date
• start_timestamp datetime
• end_timestamp datetime
• run_duration_seconds int(11)
• run_status varchar(50)
• total_customers_processed int(11)
• total_unique_matches_found int(11)
• matches_by_id_card_count int(11)
• matches_by_full_name_count int(11)
• matches_by_last_name_count int(11)
• matches_by_first_name_count int(11)
• error_message text
• notes text
• created_at timestamp

amlo_scheduler_run_logs ¹⁵

• run_id bigint(20) unsigned
• run_date date
• start_timestamp datetime
• end_timestamp datetime
• run_duration_seconds int(11)
• run_status varchar(50)
• total_customers_processed int(11)
• total_unique_matches_found int(11)
• matches_by_id_card_count int(11)
• matches_by_full_name_count int(11)
• matches_by_last_name_count int(11)
• matches_by_first_name_count int(11)
• error_message text
• notes text
• created_at timestamp

application_beneficiaries ¹⁵

• id bigint(20)
• application_form_id bigint(20)
• prefix_name_id bigint(20) unsigned
• first_name varchar(255)
• last_name varchar(255)
• relationship_id bigint(20)
• telephone_numbers varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_beneficiaries ¹⁵

• id bigint(20)
• application_form_id bigint(20)
• prefix_name_id bigint(20) unsigned
• first_name varchar(255)
• last_name varchar(255)
• relationship_id bigint(20)
• telephone_numbers varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_collaterals ²⁰

• id bigint(20)
• application_form_id bigint(20)
• price_list_id bigint(20) unsigned
• color varchar(50)
• car_modification_id bigint(20) unsigned
• gas_installation_id bigint(20) unsigned
• engine_number varchar(255)
• chassis_number varchar(255)
• mileage float(12,2)
• registration_no varchar(50)
• registration_province varchar(255)
• registration_date date
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_collaterals ²⁰

• id bigint(20)
• application_form_id bigint(20)
• price_list_id bigint(20) unsigned
• color varchar(50)
• car_modification_id bigint(20) unsigned
• gas_installation_id bigint(20) unsigned
• engine_number varchar(255)
• chassis_number varchar(255)
• mileage float(12,2)
• registration_no varchar(50)
• registration_province varchar(255)
• registration_date date
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_contacts ¹⁵

• id bigint(20)
• application_form_id bigint(20)
• prefix_name_id bigint(20) unsigned
• first_name varchar(255)
• last_name varchar(255)
• relationship_id bigint(20)
• telephone_numbers varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_contacts ¹⁵

• id bigint(20)
• application_form_id bigint(20)
• prefix_name_id bigint(20) unsigned
• first_name varchar(255)
• last_name varchar(255)
• relationship_id bigint(20)
• telephone_numbers varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_documents ¹³

• id bigint(20)
• application_form_id bigint(20)
• image_group_id bigint(20)
• image_id bigint(20)
• file_name varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_documents ¹³

• id bigint(20)
• application_form_id bigint(20)
• image_group_id bigint(20)
• image_id bigint(20)
• file_name varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_form_types ¹⁴

• id bigint(20) unsigned
• bot_code varchar(50)
• name varchar(255)
• status tinyint(3) unsigned
• required_collateral tinyint(3) unsigned
• required_reference tinyint(3) unsigned
• for_loan_types text
• order_by int(10) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_form_types ¹⁴

• id bigint(20) unsigned
• bot_code varchar(50)
• name varchar(255)
• status tinyint(3) unsigned
• required_collateral tinyint(3) unsigned
• required_reference tinyint(3) unsigned
• for_loan_types text
• order_by int(10) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_forms ⁴⁵

• id bigint(20)
• branch_id bigint(20) unsigned
• application_date date
• application_no varchar(50)
• reference_no varchar(50)
• loan_type_id bigint(20) unsigned
• application_form_type_id bigint(20)
• customer_id bigint(20) unsigned
• credit_limit decimal(12,2) unsigned
• down_amount decimal(12,2) unsigned
• down_percentage decimal(5,2) unsigned
• loan_amount decimal(12,2) unsigned
• insurance_id bigint(20) unsigned
• insurance_company_id bigint(20) unsigned
• insurance_rate decimal(7,4) unsigned
• insurance_premium decimal(12,2) unsigned
• insurance_application_no varchar(50)
• non_life_insurance_id bigint(20) unsigned
• non_life_insurance_premium decimal(12,2) unsigned
• term int(10) unsigned
• loan_interest_rate decimal(7,4) unsigned
• fee_rate decimal(7,4) unsigned
• interest_rate decimal(7,4) unsigned
• penalty_rate decimal(7,4) unsigned
• debt_amount_before_insurance decimal(12,2) unsigned
• debt_amount decimal(12,2) unsigned
• interest_amount decimal(12,2) unsigned
• installment_amount decimal(12,2) unsigned
• first_due_date date
• contract_status_id bigint(20) unsigned
• is_employee_contract tinyint(3)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• loan_officer_user_id bigint(20) unsigned
• loan_officer_user_at timestamp
• manager_user_id bigint(20) unsigned
• manager_user_at timestamp
• credit_checker_user_id bigint(20) unsigned
• credit_checker_user_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

application_forms ⁴⁵

• id bigint(20)
• branch_id bigint(20) unsigned
• application_date date
• application_no varchar(50)
• reference_no varchar(50)
• loan_type_id bigint(20) unsigned
• application_form_type_id bigint(20)
• customer_id bigint(20) unsigned
• credit_limit decimal(12,2) unsigned
• down_amount decimal(12,2) unsigned
• down_percentage decimal(5,2) unsigned
• loan_amount decimal(12,2) unsigned
• insurance_id bigint(20) unsigned
• insurance_company_id bigint(20) unsigned
• insurance_rate decimal(7,4) unsigned
• insurance_premium decimal(12,2) unsigned
• insurance_application_no varchar(50)
• non_life_insurance_id bigint(20) unsigned
• non_life_insurance_premium decimal(12,2) unsigned
• term int(10) unsigned
• loan_interest_rate decimal(7,4) unsigned
• fee_rate decimal(7,4) unsigned
• interest_rate decimal(7,4) unsigned
• penalty_rate decimal(7,4) unsigned
• debt_amount_before_insurance decimal(12,2) unsigned
• debt_amount decimal(12,2) unsigned
• interest_amount decimal(12,2) unsigned
• installment_amount decimal(12,2) unsigned
• first_due_date date
• contract_status_id bigint(20) unsigned
• is_employee_contract tinyint(3)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• loan_officer_user_id bigint(20) unsigned
• loan_officer_user_at timestamp
• manager_user_id bigint(20) unsigned
• manager_user_at timestamp
• credit_checker_user_id bigint(20) unsigned
• credit_checker_user_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

application_guarantors ¹⁵

• id bigint(20)
• application_form_id bigint(20)
• customer_id bigint(20)
• relationship_id bigint(20)
• telephone_numbers varchar(255)
• guarantor_type tinyint(3)
• guarantor_number tinyint(3)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_guarantors ¹⁵

• id bigint(20)
• application_form_id bigint(20)
• customer_id bigint(20)
• relationship_id bigint(20)
• telephone_numbers varchar(255)
• guarantor_type tinyint(3)
• guarantor_number tinyint(3)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_land_collaterals ⁴³

• id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• father_prefix_name_id bigint(20) unsigned
• father_first_name varchar(255)
• father_last_name varchar(255)
• mother_prefix_name_id bigint(20) unsigned
• mother_first_name varchar(255)
• mother_last_name varchar(255)
• mortgage tinyint(3) unsigned
• building_estimated_price decimal(12,2) unsigned
• land_estimated_price decimal(12,2) unsigned
• land_type_id bigint(20) unsigned
• land_type_other varchar(255)
• building_type_id bigint(20) unsigned
• building_characteristic_type_id bigint(20) unsigned
• building_characteristic_type_other varchar(255)
• number_of_floor int(10) unsigned
• land_characteristic_type_id bigint(20) unsigned
• land_characteristic_type_other varchar(255)
• entrance_exit_type_id bigint(20) unsigned
• car_enter_exit_type_id bigint(20) unsigned
• road_characteristic_type_id bigint(20) unsigned
• road_width_type_id bigint(20) unsigned
• title_deed_number varchar(255)
• volume_number varchar(255)
• page_number varchar(255)
• tonnage_number varchar(255)
• rai int(10) unsigned
• ngan int(10) unsigned
• square_wa float(5,2)
• land_number varchar(255)
• sub_district_no varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_land_collaterals ⁴³

• id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• father_prefix_name_id bigint(20) unsigned
• father_first_name varchar(255)
• father_last_name varchar(255)
• mother_prefix_name_id bigint(20) unsigned
• mother_first_name varchar(255)
• mother_last_name varchar(255)
• mortgage tinyint(3) unsigned
• building_estimated_price decimal(12,2) unsigned
• land_estimated_price decimal(12,2) unsigned
• land_type_id bigint(20) unsigned
• land_type_other varchar(255)
• building_type_id bigint(20) unsigned
• building_characteristic_type_id bigint(20) unsigned
• building_characteristic_type_other varchar(255)
• number_of_floor int(10) unsigned
• land_characteristic_type_id bigint(20) unsigned
• land_characteristic_type_other varchar(255)
• entrance_exit_type_id bigint(20) unsigned
• car_enter_exit_type_id bigint(20) unsigned
• road_characteristic_type_id bigint(20) unsigned
• road_width_type_id bigint(20) unsigned
• title_deed_number varchar(255)
• volume_number varchar(255)
• page_number varchar(255)
• tonnage_number varchar(255)
• rai int(10) unsigned
• ngan int(10) unsigned
• square_wa float(5,2)
• land_number varchar(255)
• sub_district_no varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_land_mortgagors ¹⁷

• id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• father_prefix_name_id bigint(20) unsigned
• father_first_name varchar(255)
• father_last_name varchar(255)
• mother_prefix_name_id bigint(20) unsigned
• mother_first_name varchar(255)
• mother_last_name varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

application_land_mortgagors ¹⁷

• id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• father_prefix_name_id bigint(20) unsigned
• father_first_name varchar(255)
• father_last_name varchar(255)
• mother_prefix_name_id bigint(20) unsigned
• mother_first_name varchar(255)
• mother_last_name varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointment_attachments ⁸

• id bigint(20)
• appointment_id bigint(20) unsigned
• file_name varchar(255)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointment_attachments ⁸

• id bigint(20)
• appointment_id bigint(20) unsigned
• file_name varchar(255)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointment_car_statuses ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointment_car_statuses ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointment_remarks ⁷

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• note text
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointment_remarks ⁷

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• note text
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointments ¹¹

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• appointment_date date
• is_meet_customer tinyint(1)
• appointment_car_status_id bigint(20)
• note text
• location point
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

appointments ¹¹

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• appointment_date date
• is_meet_customer tinyint(1)
• appointment_car_status_id bigint(20)
• note text
• location point
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

ar_agings ¹¹

• id bigint(20) unsigned
• code varchar(10)
• term_to_be_paid int(10) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

ar_agings ¹¹

• id bigint(20) unsigned
• code varchar(10)
• term_to_be_paid int(10) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

auction_companies ¹⁵

• id bigint(20) unsigned
• region_id bigint(20) unsigned
• name varchar(255)
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

auction_companies ¹⁵

• id bigint(20) unsigned
• region_id bigint(20) unsigned
• name varchar(255)
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

bank_statement_types ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• type_of_used tinyint(3) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

bank_statement_types ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• type_of_used tinyint(3) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

bank_statements ¹⁶

• id bigint(20) unsigned
• statement_no varchar(255)
• statement_date date
• bank_statement_type_id bigint(20) unsigned
• book_bank_id bigint(20) unsigned
• from_book_bank_id bigint(20) unsigned
• reff_no varchar(255)
• statement_amount decimal(12,2)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

bank_statements ¹⁶

• id bigint(20) unsigned
• statement_no varchar(255)
• statement_date date
• bank_statement_type_id bigint(20) unsigned
• book_bank_id bigint(20) unsigned
• from_book_bank_id bigint(20) unsigned
• reff_no varchar(255)
• statement_amount decimal(12,2)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

banks ¹²

• id bigint(20) unsigned
• code varchar(255)
• name varchar(255)
• initials varchar(255)
• logo text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

banks ¹²

• id bigint(20) unsigned
• code varchar(255)
• name varchar(255)
• initials varchar(255)
• logo text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

bill_payment_lots ¹⁹

• id bigint(20) unsigned
• file_name varchar(255)
• effective_date date
• bank_id bigint(20)
• bank_code varchar(255)
• company_account varchar(255)
• company_name varchar(255)
• service_code varchar(255)
• total_amount decimal(12,2)
• total_transaction int(11)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

bill_payment_lots ¹⁹

• id bigint(20) unsigned
• file_name varchar(255)
• effective_date date
• bank_id bigint(20)
• bank_code varchar(255)
• company_account varchar(255)
• company_name varchar(255)
• service_code varchar(255)
• total_amount decimal(12,2)
• total_transaction int(11)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

bill_payments ²⁹

• id bigint(20) unsigned
• bill_payment_lot_id bigint(20)
• receipt_id bigint(20)
• sequence_no varchar(255)
• bank_id bigint(20)
• bank_code varchar(255)
• company_account varchar(255)
• payment_date datetime
• customer_name varchar(255)
• ref_1 varchar(255)
• ref_2 varchar(255)
• ref_3 varchar(255)
• branch_no varchar(255)
• teller_no varchar(255)
• kind_of_transaction varchar(255)
• transaction_code varchar(255)
• cheque_no varchar(255)
• amount decimal(12,2)
• cheque_bank_code varchar(255)
• zone varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

bill_payments ²⁹

• id bigint(20) unsigned
• bill_payment_lot_id bigint(20)
• receipt_id bigint(20)
• sequence_no varchar(255)
• bank_id bigint(20)
• bank_code varchar(255)
• company_account varchar(255)
• payment_date datetime
• customer_name varchar(255)
• ref_1 varchar(255)
• ref_2 varchar(255)
• ref_3 varchar(255)
• branch_no varchar(255)
• teller_no varchar(255)
• kind_of_transaction varchar(255)
• transaction_code varchar(255)
• cheque_no varchar(255)
• amount decimal(12,2)
• cheque_bank_code varchar(255)
• zone varchar(255)
• status tinyint(3) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

book_bank_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

book_bank_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

book_banks ¹⁶

• id bigint(20) unsigned
• bank_id bigint(20) unsigned
• branch_id bigint(20) unsigned
• account_number varchar(255)
• account_name varchar(255)
• bank_branch_name varchar(255)
• book_bank_type_id bigint(20) unsigned
• open_date date
• open_amount decimal(12,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

book_banks ¹⁶

• id bigint(20) unsigned
• bank_id bigint(20) unsigned
• branch_id bigint(20) unsigned
• account_number varchar(255)
• account_name varchar(255)
• bank_branch_name varchar(255)
• book_bank_type_id bigint(20) unsigned
• open_date date
• open_amount decimal(12,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

branches ²²

• id bigint(20) unsigned
• parent_id bigint(20)
• company_id bigint(20)
• code varchar(255)
• ib_code varchar(50)
• name varchar(255)
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• telephone_number varchar(255)
• fax_number varchar(255)
• latitude decimal(10,8)
• longitude decimal(11,8)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

branches ²²

• id bigint(20) unsigned
• parent_id bigint(20)
• company_id bigint(20)
• code varchar(255)
• ib_code varchar(50)
• name varchar(255)
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• telephone_number varchar(255)
• fax_number varchar(255)
• latitude decimal(10,8)
• longitude decimal(11,8)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

brand_ltvs ¹¹

• id int(10) unsigned
• brand_id bigint(20) unsigned
• car_type_id bigint(20) unsigned
• rate decimal(5,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

brand_ltvs ¹¹

• id int(10) unsigned
• brand_id bigint(20) unsigned
• car_type_id bigint(20) unsigned
• rate decimal(5,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

brands ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

brands ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

building_characteristic_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

building_characteristic_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

building_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

building_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

business_types ¹⁰

• id bigint(20) unsigned
• bot_code varchar(50)
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

business_types ¹⁰

• id bigint(20) unsigned
• bot_code varchar(50)
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_enter_exit_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_enter_exit_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_modifications ¹¹

• id int(10) unsigned
• name varchar(255)
• rate decimal(5,4)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_modifications ¹¹

• id int(10) unsigned
• name varchar(255)
• rate decimal(5,4)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_type_groups ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_type_groups ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_types ¹²

• id bigint(20) unsigned
• bot_code varchar(50)
• car_type_group_id bigint(20)
• name varchar(255)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

car_types ¹²

• id bigint(20) unsigned
• bot_code varchar(50)
• car_type_group_id bigint(20)
• name varchar(255)
• description text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

cash_and_transfer_debtors ¹⁰

• id bigint(20) unsigned
• cash_and_transfer_type_id bigint(20) unsigned
• debtor_id bigint(20) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

cash_and_transfer_debtors ¹⁰

• id bigint(20) unsigned
• cash_and_transfer_type_id bigint(20) unsigned
• debtor_id bigint(20) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

cash_and_transfer_types ¹¹

• id bigint(20) unsigned
• name varchar(255)
• paid_type_id bigint(20) unsigned
• type_of_used tinyint(3) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

cash_and_transfer_types ¹¹

• id bigint(20) unsigned
• name varchar(255)
• paid_type_id bigint(20) unsigned
• type_of_used tinyint(3) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

cash_and_transfers ¹⁵

• id bigint(20) unsigned
• document_no varchar(255)
• document_date date
• cash_and_transfer_type_id bigint(20) unsigned
• from_book_bank_id bigint(20) unsigned
• reff_no varchar(255)
• amount decimal(12,2)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

cash_and_transfers ¹⁵

• id bigint(20) unsigned
• document_no varchar(255)
• document_date date
• cash_and_transfer_type_id bigint(20) unsigned
• from_book_bank_id bigint(20) unsigned
• reff_no varchar(255)
• amount decimal(12,2)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

channels ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

channels ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

collection_assignments ⁸

• id bigint(20) unsigned
• collection_worklist_id bigint(20) unsigned
• user_id bigint(20) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

collection_assignments ⁸

• id bigint(20) unsigned
• collection_worklist_id bigint(20) unsigned
• user_id bigint(20) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

collection_targets ¹²

• id bigint(20) unsigned
• ar_aging_id bigint(20) unsigned
• branch_id bigint(20) unsigned
• target_date date
• target_percent decimal(5,2)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

collection_targets ¹²

• id bigint(20) unsigned
• ar_aging_id bigint(20) unsigned
• branch_id bigint(20) unsigned
• target_date date
• target_percent decimal(5,2)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

collection_worklists ²⁴

• id bigint(20) unsigned
• working_date date
• branch_id bigint(20) unsigned
• branch_code varchar(255)
• branch_name varchar(255)
• contract_id bigint(20) unsigned
• contract_no varchar(255)
• customer_id bigint(20) unsigned
• prefix_name varchar(255)
• first_name varchar(255)
• last_name varchar(255)
• collection_telephone varchar(255)
• address_collection text
• user_id bigint(20) unsigned
• user_prefix_name varchar(255)
• user_first_name varchar(255)
• user_last_name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

collection_worklists ²⁴

• id bigint(20) unsigned
• working_date date
• branch_id bigint(20) unsigned
• branch_code varchar(255)
• branch_name varchar(255)
• contract_id bigint(20) unsigned
• contract_no varchar(255)
• customer_id bigint(20) unsigned
• prefix_name varchar(255)
• first_name varchar(255)
• last_name varchar(255)
• collection_telephone varchar(255)
• address_collection text
• user_id bigint(20) unsigned
• user_prefix_name varchar(255)
• user_first_name varchar(255)
• user_last_name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

colors ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

colors ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

commission_rates ¹⁴

• id int(10) unsigned
• loan_type_id bigint(20) unsigned
• application_form_type_id bigint(20) unsigned
• car_type_group_id bigint(20) unsigned
• rate decimal(5,4)
• max decimal(12,2) unsigned
• status tinyint(3) unsigned
• effectived_at date
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

commission_rates ¹⁴

• id int(10) unsigned
• loan_type_id bigint(20) unsigned
• application_form_type_id bigint(20) unsigned
• car_type_group_id bigint(20) unsigned
• rate decimal(5,4)
• max decimal(12,2) unsigned
• status tinyint(3) unsigned
• effectived_at date
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

companies ¹⁸

• id bigint(20) unsigned
• name varchar(255)
• tin varchar(255)
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• telephone_number varchar(255)
• fax_number varchar(255)
• photo_url varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

companies ¹⁸

• id bigint(20) unsigned
• name varchar(255)
• tin varchar(255)
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• telephone_number varchar(255)
• fax_number varchar(255)
• photo_url varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_addresses ¹⁶

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• address_type_id bigint(20) unsigned
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_addresses ¹⁶

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• address_type_id bigint(20) unsigned
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_adjustments ³⁰

• id bigint(20) unsigned
• contract_id bigint(20)
• contract_no varchar(50)
• customer_id bigint(20) unsigned
• customer_name varchar(255)
• loan_amount decimal(12,2)
• term int(10) unsigned
• interest_rate decimal(7,4)
• installment_amount decimal(12,2)
• total_adjustment_amount decimal(12,2)
• affected_terms text
• affected_term_count int(10) unsigned
• calculation_details text
• calculation_summary text
• distribution_method enum('NEXT_TERM','SPREAD_REMAINING','CASCADE')
• starting_term int(10) unsigned
• unpaid_terms_count int(10) unsigned
• confirmed tinyint(1)
• confirmed_at timestamp
• confirmed_by bigint(20) unsigned
• applied tinyint(1)
• applied_at timestamp
• applied_by bigint(20) unsigned
• payment_table_ids text
• error_message text
• retry_count int(10) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_at timestamp
• deleted_at timestamp

contract_adjustments ³⁰

• id bigint(20) unsigned
• contract_id bigint(20)
• contract_no varchar(50)
• customer_id bigint(20) unsigned
• customer_name varchar(255)
• loan_amount decimal(12,2)
• term int(10) unsigned
• interest_rate decimal(7,4)
• installment_amount decimal(12,2)
• total_adjustment_amount decimal(12,2)
• affected_terms text
• affected_term_count int(10) unsigned
• calculation_details text
• calculation_summary text
• distribution_method enum('NEXT_TERM','SPREAD_REMAINING','CASCADE')
• starting_term int(10) unsigned
• unpaid_terms_count int(10) unsigned
• confirmed tinyint(1)
• confirmed_at timestamp
• confirmed_by bigint(20) unsigned
• applied tinyint(1)
• applied_at timestamp
• applied_by bigint(20) unsigned
• payment_table_ids text
• error_message text
• retry_count int(10) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_at timestamp
• deleted_at timestamp

contract_comment_histories ⁷

• id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• contract_id bigint(20) unsigned
• user_id bigint(20) unsigned
• contract_status_id bigint(20) unsigned
• remark text
• created_at timestamp

contract_comment_histories ⁷

• id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• contract_id bigint(20) unsigned
• user_id bigint(20) unsigned
• contract_status_id bigint(20) unsigned
• remark text
• created_at timestamp

contract_creditors ²³

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• user_id bigint(20) unsigned
• debtor_id bigint(20) unsigned
• reference_id bigint(20) unsigned
• amount decimal(12,2)
• vat_rate decimal(5,4)
• vat decimal(12,2)
• net decimal(12,2)
• paid_type_id bigint(20) unsigned
• bank_id bigint(20) unsigned
• bank_branch_name varchar(50)
• bank_account_number varchar(50)
• book_bank_file_name varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_creditors ²³

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• user_id bigint(20) unsigned
• debtor_id bigint(20) unsigned
• reference_id bigint(20) unsigned
• amount decimal(12,2)
• vat_rate decimal(5,4)
• vat decimal(12,2)
• net decimal(12,2)
• paid_type_id bigint(20) unsigned
• bank_id bigint(20) unsigned
• bank_branch_name varchar(50)
• bank_account_number varchar(50)
• book_bank_file_name varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_debt_tables ¹²

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• term_no int(11)
• due_date date
• installment_amount decimal(12,2)
• principal_amount decimal(12,2)
• interest_amount decimal(12,2)
• principal_balance decimal(12,2)
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_debt_tables ¹²

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• term_no int(11)
• due_date date
• installment_amount decimal(12,2)
• principal_amount decimal(12,2)
• interest_amount decimal(12,2)
• principal_balance decimal(12,2)
• created_by bigint(20) unsigned
• created_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_payment_tables ³³

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• term_no int(11)
• due_date date
• interest_day int(11)
• installment_amount decimal(12,2)
• bring_forward_principal_amount decimal(12,2)
• principal_amount decimal(12,2)
• bring_forward_interest_amount decimal(12,2)
• interest_amount decimal(12,2)
• bring_forward_fee decimal(12,2)
• fee decimal(12,2)
• bring_forward_fine decimal(12,2)
• fine decimal(12,2)
• bring_forward_collection_fee decimal(12,2)
• collection_fee decimal(12,2)
• receipt_id bigint(20)
• receipt_date date
• paid_installment_amount decimal(12,2)
• paid_principal_amount decimal(12,2)
• paid_interest_amount decimal(12,2)
• paid_fee decimal(12,2)
• paid_fine decimal(12,2)
• paid_collection_fee decimal(12,2)
• principal_balance decimal(12,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_remark text

contract_payment_tables ³³

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• term_no int(11)
• due_date date
• interest_day int(11)
• installment_amount decimal(12,2)
• bring_forward_principal_amount decimal(12,2)
• principal_amount decimal(12,2)
• bring_forward_interest_amount decimal(12,2)
• interest_amount decimal(12,2)
• bring_forward_fee decimal(12,2)
• fee decimal(12,2)
• bring_forward_fine decimal(12,2)
• fine decimal(12,2)
• bring_forward_collection_fee decimal(12,2)
• collection_fee decimal(12,2)
• receipt_id bigint(20)
• receipt_date date
• paid_installment_amount decimal(12,2)
• paid_principal_amount decimal(12,2)
• paid_interest_amount decimal(12,2)
• paid_fee decimal(12,2)
• paid_fine decimal(12,2)
• paid_collection_fee decimal(12,2)
• principal_balance decimal(12,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_remark text

contract_statuses ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• order_by int(10) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_statuses ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• order_by int(10) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_telephones ¹²

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• type varchar(50)
• telephone_number varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contract_telephones ¹²

• id bigint(20) unsigned
• contract_id bigint(20) unsigned
• type varchar(50)
• telephone_number varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

contracts ⁴⁵

• id bigint(20)
• branch_id bigint(20) unsigned
• channel_id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• contract_date date
• closed_date date
• contract_no varchar(50)
• loan_type_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• dealer_id bigint(20) unsigned
• agent_id bigint(20) unsigned
• sale_user_id bigint(20) unsigned
• credit_limit decimal(12,2) unsigned
• down_amount decimal(12,2) unsigned
• down_percentage decimal(5,2) unsigned
• loan_amount decimal(12,2) unsigned
• insurance_id bigint(20) unsigned
• insurance_company_id bigint(20) unsigned
• insurance_rate decimal(7,4) unsigned
• insurance_premium decimal(12,2) unsigned
• non_life_insurance_id bigint(20) unsigned
• non_life_insurance_premium decimal(12,2) unsigned
• term int(10) unsigned
• loan_interest_rate decimal(7,4) unsigned
• fee_rate decimal(7,4) unsigned
• interest_rate decimal(7,4) unsigned
• penalty_rate decimal(7,4) unsigned
• debt_amount_before_insurance decimal(12,2) unsigned
• debt_amount decimal(12,2) unsigned
• interest_amount decimal(12,2) unsigned
• installment_amount decimal(12,2) unsigned
• first_due_date date
• principal_balance decimal(12,2) unsigned
• last_paid_date date
• grace_period int(10)
• pays varchar(50)
• contract_status_id bigint(20) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

contracts ⁴⁵

• id bigint(20)
• branch_id bigint(20) unsigned
• channel_id bigint(20) unsigned
• application_form_id bigint(20) unsigned
• contract_date date
• closed_date date
• contract_no varchar(50)
• loan_type_id bigint(20) unsigned
• customer_id bigint(20) unsigned
• dealer_id bigint(20) unsigned
• agent_id bigint(20) unsigned
• sale_user_id bigint(20) unsigned
• credit_limit decimal(12,2) unsigned
• down_amount decimal(12,2) unsigned
• down_percentage decimal(5,2) unsigned
• loan_amount decimal(12,2) unsigned
• insurance_id bigint(20) unsigned
• insurance_company_id bigint(20) unsigned
• insurance_rate decimal(7,4) unsigned
• insurance_premium decimal(12,2) unsigned
• non_life_insurance_id bigint(20) unsigned
• non_life_insurance_premium decimal(12,2) unsigned
• term int(10) unsigned
• loan_interest_rate decimal(7,4) unsigned
• fee_rate decimal(7,4) unsigned
• interest_rate decimal(7,4) unsigned
• penalty_rate decimal(7,4) unsigned
• debt_amount_before_insurance decimal(12,2) unsigned
• debt_amount decimal(12,2) unsigned
• interest_amount decimal(12,2) unsigned
• installment_amount decimal(12,2) unsigned
• first_due_date date
• principal_balance decimal(12,2) unsigned
• last_paid_date date
• grace_period int(10)
• pays varchar(50)
• contract_status_id bigint(20) unsigned
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp
• migration_id bigint(20)

customer_addresses ¹⁶

• id bigint(20) unsigned
• customer_id bigint(20) unsigned
• address_type_id bigint(20) unsigned
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

customer_addresses ¹⁶

• id bigint(20) unsigned
• customer_id bigint(20) unsigned
• address_type_id bigint(20) unsigned
• address varchar(255)
• sub_district varchar(255)
• district varchar(255)
• province varchar(255)
• zipcode varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

customer_telephones ¹¹

• id bigint(20) unsigned
• customer_id bigint(20) unsigned
• telephone_number varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

customer_telephones ¹¹

• id bigint(20) unsigned
• customer_id bigint(20) unsigned
• telephone_number varchar(255)
• remark text
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

customer_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

customer_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

customers ⁵⁹

• id bigint(20) unsigned
• customer_data_type bigint(20)
• customer_type_id bigint(20) unsigned
• prefix_name_id bigint(20) unsigned
• photo_url varchar(255)
• first_name varchar(255)
• last_name varchar(255)
• nick_name varchar(255)
• gender tinyint(4)
• date_of_birth date
• id_card_type_id bigint(20) unsigned
• id_card_number varchar(50)
• id_card_issuer varchar(255)
• id_card_expire_date date
• nationality varchar(50)
• race varchar(50)
• marital_status_type_id bigint(20) unsigned
• employment_status_id bigint(20) unsigned
• job_id bigint(20) unsigned
• job_other varchar(255)
• business_type_id bigint(20) unsigned
• residential_style_id bigint(20) unsigned
• bank_id bigint(20) unsigned
• bank_branch_name varchar(50)
• bank_account_number varchar(50)
• status tinyint(3) unsigned
• email varchar(255)
• line_id varchar(255)
• workplace_name varchar(255)
• monthly_income_amount decimal(12,2)
• monthly_expense_amount decimal(12,2)
• yearly_bonus_amount decimal(12,2)
• credit_limit_amount decimal(12,2)
• income_source text
• is_dealer tinyint(3)
• is_mortgagor tinyint(3)
• is_agent tinyint(3)
• book_bank_file_name varchar(255)
• spouse_prefix_name_id bigint(20) unsigned
• spouse_first_name varchar(255)
• spouse_last_name varchar(255)
• spouse_nick_name varchar(255)
• spouse_gender tinyint(4) unsigned
• spouse_date_of_birth date
• spouse_nationality varchar(50)
• spouse_telephone_number varchar(255)
• spouse_address varchar(255)
• spouse_sub_district varchar(255)
• spouse_district varchar(255)
• spouse_province varchar(255)
• spouse_zipcode varchar(255)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_at timestamp
• migration_id bigint(20)
• canceled_by bigint(20) unsigned

customers ⁵⁹

• id bigint(20) unsigned
• customer_data_type bigint(20)
• customer_type_id bigint(20) unsigned
• prefix_name_id bigint(20) unsigned
• photo_url varchar(255)
• first_name varchar(255)
• last_name varchar(255)
• nick_name varchar(255)
• gender tinyint(4)
• date_of_birth date
• id_card_type_id bigint(20) unsigned
• id_card_number varchar(50)
• id_card_issuer varchar(255)
• id_card_expire_date date
• nationality varchar(50)
• race varchar(50)
• marital_status_type_id bigint(20) unsigned
• employment_status_id bigint(20) unsigned
• job_id bigint(20) unsigned
• job_other varchar(255)
• business_type_id bigint(20) unsigned
• residential_style_id bigint(20) unsigned
• bank_id bigint(20) unsigned
• bank_branch_name varchar(50)
• bank_account_number varchar(50)
• status tinyint(3) unsigned
• email varchar(255)
• line_id varchar(255)
• workplace_name varchar(255)
• monthly_income_amount decimal(12,2)
• monthly_expense_amount decimal(12,2)
• yearly_bonus_amount decimal(12,2)
• credit_limit_amount decimal(12,2)
• income_source text
• is_dealer tinyint(3)
• is_mortgagor tinyint(3)
• is_agent tinyint(3)
• book_bank_file_name varchar(255)
• spouse_prefix_name_id bigint(20) unsigned
• spouse_first_name varchar(255)
• spouse_last_name varchar(255)
• spouse_nick_name varchar(255)
• spouse_gender tinyint(4) unsigned
• spouse_date_of_birth date
• spouse_nationality varchar(50)
• spouse_telephone_number varchar(255)
• spouse_address varchar(255)
• spouse_sub_district varchar(255)
• spouse_district varchar(255)
• spouse_province varchar(255)
• spouse_zipcode varchar(255)
• remark text
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_at timestamp
• migration_id bigint(20)
• canceled_by bigint(20) unsigned

daily_report_details ¹¹

• id bigint(20) unsigned
• daily_report_id bigint(20) unsigned
• daily_report_group_detail_id bigint(20) unsigned
• amount decimal(12,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_report_details ¹¹

• id bigint(20) unsigned
• daily_report_id bigint(20) unsigned
• daily_report_group_detail_id bigint(20) unsigned
• amount decimal(12,2)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_report_group_detail_items ¹¹

• id bigint(20) unsigned
• daily_report_group_detail_id bigint(20) unsigned
• item_id bigint(20) unsigned
• item_model_name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_report_group_detail_items ¹¹

• id bigint(20) unsigned
• daily_report_group_detail_id bigint(20) unsigned
• item_id bigint(20) unsigned
• item_model_name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_report_group_details ¹²

• id bigint(20) unsigned
• daily_report_group_id bigint(20) unsigned
• operation tinyint(3) unsigned
• name varchar(255)
• order_by int(10) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_report_group_details ¹²

• id bigint(20) unsigned
• daily_report_group_id bigint(20) unsigned
• operation tinyint(3) unsigned
• name varchar(255)
• order_by int(10) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_report_groups ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• order_by int(10) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_report_groups ¹⁰

• id bigint(20) unsigned
• name varchar(255)
• order_by int(10) unsigned
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_reports ¹⁸

• id bigint(20) unsigned
• report_date date
• book_bank_id bigint(20) unsigned
• daily_report_group_id bigint(20) unsigned
• bring_forward decimal(12,2) unsigned
• amount decimal(12,2)
• remark text
• status tinyint(3) unsigned
• approved_by bigint(20) unsigned
• approved_at timestamp
• hq_approved_by bigint(20) unsigned
• hq_approved_at timestamp
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

daily_reports ¹⁸

• id bigint(20) unsigned
• report_date date
• book_bank_id bigint(20) unsigned
• daily_report_group_id bigint(20) unsigned
• bring_forward decimal(12,2) unsigned
• amount decimal(12,2)
• remark text
• status tinyint(3) unsigned
• approved_by bigint(20) unsigned
• approved_at timestamp
• hq_approved_by bigint(20) unsigned
• hq_approved_at timestamp
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

debt_buyers ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

debt_buyers ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

debtor_statuses ³⁸

• report_date date
• updated_at timestamp
• previous_ar_aging_id bigint(20) unsigned
• previous_ar_aging_code varchar(10)
• previous_ar_aging_name varchar(255)
• ar_aging_id bigint(20) unsigned
• ar_aging_code varchar(10)
• ar_aging_name varchar(255)
• branch_id bigint(20) unsigned
• branch_code varchar(255)
• branch_name varchar(255)
• customer_id bigint(20) unsigned
• prefix_name varchar(255)
• first_name varchar(255)
• last_name varchar(255)
• contract_id bigint(20) unsigned
• contract_no varchar(255)
• contract_date date
• first_due_date date
• loan_interest_rate decimal(7,4)
• loan_amount decimal(12,2)
• interest_amount decimal(12,2)
• term int(10) unsigned
• installment_amount decimal(12,2)
• paid_principal_amount decimal(12,2)
• paid_interest_amount decimal(12,2)
• principal_balance decimal(12,2)
• day_past_due int(10) unsigned
• term_past_due int(10) unsigned
• due_date date
• term_no int(10) unsigned
• pay_amount decimal(12,2)
• amount_past_due decimal(12,2)
• principal_past_due decimal(12,2)
• interest_past_due decimal(12,2)
• fine_past_due decimal(12,2) unsigned
• collection_fee_past_due decimal(12,2) unsigned
• last_payment_date date

debtor_statuses ³⁸

• report_date date
• updated_at timestamp
• previous_ar_aging_id bigint(20) unsigned
• previous_ar_aging_code varchar(10)
• previous_ar_aging_name varchar(255)
• ar_aging_id bigint(20) unsigned
• ar_aging_code varchar(10)
• ar_aging_name varchar(255)
• branch_id bigint(20) unsigned
• branch_code varchar(255)
• branch_name varchar(255)
• customer_id bigint(20) unsigned
• prefix_name varchar(255)
• first_name varchar(255)
• last_name varchar(255)
• contract_id bigint(20) unsigned
• contract_no varchar(255)
• contract_date date
• first_due_date date
• loan_interest_rate decimal(7,4)
• loan_amount decimal(12,2)
• interest_amount decimal(12,2)
• term int(10) unsigned
• installment_amount decimal(12,2)
• paid_principal_amount decimal(12,2)
• paid_interest_amount decimal(12,2)
• principal_balance decimal(12,2)
• day_past_due int(10) unsigned
• term_past_due int(10) unsigned
• due_date date
• term_no int(10) unsigned
• pay_amount decimal(12,2)
• amount_past_due decimal(12,2)
• principal_past_due decimal(12,2)
• interest_past_due decimal(12,2)
• fine_past_due decimal(12,2) unsigned
• collection_fee_past_due decimal(12,2) unsigned
• last_payment_date date

debtors ¹⁴

• id bigint(20) unsigned
• name varchar(255)
• with_vat tinyint(3)
• withholding_tax tinyint(3)
• insurance_id bigint(20)
• status tinyint(3) unsigned
• effectived_at date
• expired_at date
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

debtors ¹⁴

• id bigint(20) unsigned
• name varchar(255)
• with_vat tinyint(3)
• withholding_tax tinyint(3)
• insurance_id bigint(20)
• status tinyint(3) unsigned
• effectived_at date
• expired_at date
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

employment_statuses ¹⁰

• id bigint(20) unsigned
• bot_code varchar(20)
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

employment_statuses ¹⁰

• id bigint(20) unsigned
• bot_code varchar(20)
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

entrance_exit_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

entrance_exit_types ⁹

• id bigint(20) unsigned
• name varchar(255)
• status tinyint(3) unsigned
• created_by bigint(20) unsigned
• created_at timestamp
• updated_by bigint(20) unsigned
• updated_at timestamp
• canceled_by bigint(20) unsigned
• canceled_at timestamp

failed_jobs ⁶

• id bigint(20) unsigned
• connection text
• queue text
• payload longtext
• exception longtext
• failed_at timestamp

failed_jobs ⁶

• id bigint(20) unsigned
• connection text
• queue text
• payload longtext
• exception longtext
• failed_at timestamp

gas_installations ¹¹