Hindware Limited Database

Dump size : 5GB unzipped
Format .sql
22M Rows , Good Data 100K+
date: Nov 08, 2023

customer Name , Phone number ...




INSERT INTO `complaints_master` (`id`, `userid`, `job_no`, `sub_job_no`, `catalogue_no`, `priority`, `call_type`, `service_call_type`, `open_date`, `open_time`, `serial_no`, `repeat_call`, `mfd`, `manufactured_expiry_date`, `dop`, `date_install`, `bill_exp_date`, `purchase_invoice`, `warranty_status`, `amc_end_date`, `ledgerid`, `amt_received`, `sol_given`, `battery_detail`, `p_sno`, `plant`, `customer_id`, `productid`, `modelid`, `address`, `problem`, `img`, `call_attend_date`, `call_attend_time`, `engg_attend_date`, `engg_attend_time`, `close_date`, `close_time`, `sm_date`, `tat`, `new_sm_date`, `tat_time`, `attend_by`, `engg_assign`, `closed_by`, `status`, `pending_remark`, `branch_remark`, `mds_no`, `foundok`, `solutiongiven`, `BatteryMake`, `ModificatonDone`, `ProblemObserved`, `BatteryRating`, `reason`, `problem_detail`, `locationa_id`, `stateid`, `cityid`, `dealer_name`, `dealer_mobile`, `dealer_address`, `amcno`, `remark`, `prevoius_job_no`, `invoice_no`, `invoice_flag`, `invoice_date`, `invoice_total_amt`, `updated_by`, `closed_remark`, `cancel_remark`, `company_id`, `range_id`, `brand_id`, `division_id`, `warranty_end_date`, `visit1_rmk`, `visit2_rmk`, `visit3_rmk`, `visit4_rmk`, `visit5_rmk`, `visit6_rmk`, `eng_visit1`, `eng_visit2`, `eng_visit3`, `eng_visit4`, `eng_visit5`, `eng_visit6`, `eng_visit1_date`, `eng_visit2_date`, `eng_visit3_date`, `eng_visit4_date`, `eng_visit5_date`, `eng_visit6_date`, `part_warranty_status`, `defectdetect`, `reminder`, `unit_install`, `complaint_type`, `f_o_c`, `img_path1`, `img_path2`, `img_path3`, `img_path4`, `signature`, `travel_type`, `distance`, `travel_date`, `SCM`, `S_C_M`, `app_part_consume`, `happy_flag`, `happy_remark`, `call_center_remark`, `branch_cancel_remark`, `affected_area`, `work_done`, `field_closure`, `final_closure`, `c_set_status`, `customer_feedback`, `manual_call_done`, `mag_type`, `replacement_request`, `replacement_date`, `replacement_rej_rmk`, `approved_by`, `waiver_by`, `cns_csat_remark`, `csat_flag`, `calling_number`, `happy_code`, `total_call`, `faucet_call`, `sw_call`, `apd_call`, `dialer_response`, `reopen_date`, `person_name`, `person_contact`, `war_img_name1`, `war_img_path1`, `status_warranty`, `redirect_flag`, `ivr_response`, `response_datetime`, `response_date`, `dop_invoice_name`, `cancelremark`, `inv_flag`, `tempid`, `m`, `y`, `edit`, `warranty_month`, `final_tat`, `cust_invoice`, `mode_payment`, `payment_amt`, `cr_no_app`, `cr_date_app`, `jobstatus`, `cancel_reason`, `dis_remark`, `redrct_reason`, `redrct_rmk`, `billing`, `caller_name`, `caller_type`, `dl_rmk`, `dealer_state`, `dealer_city`, `agency_name`, `dealer_code`, `lbr_app`, `cust_mobile`, `call_assign_date`, `video_path`, `escalation_to`, `sap_material_code`, `repeat_flag_val`, `repeat_flag`, `repeat_appr`, `repeat_appr_rmk`, `repeat_appr_date`, `repeat_appr_by`, `repeat_old_job`, `ssi_app_flg`, `discount_flag`, `foc_lb_wrty`, `discount_flag_rmk`, `discount_flag_by`, `discount_flag_date`, `app_cost`, `sys_approve_cost`, `sys_claim_date`, `claim_product_count`, `claim_app_flag`, `claim_app_date`, `claim_no`, `claim_reject_reason`, `cust_feedback_flg`, `replacement_inquery_request`, `replacement_inquery_remark`, `ho_appr`, `ho_user_id`, `ho_appr_by`, `ho_appr_date`, `ho_appr_rmk`, `repl_email_file`, `defectdetect_by_qa`, `district_nm`, `foc_pdf`, `eng_assign_date`, `repeat_call_closure`, `sap_billing`, `sap_so_no`, `closed_by_flag`, `cron_closed_jobseq`, `appointment_date`, `appointment_time`, `ivr_map_flg`, `last_update`, `link_type`, `lang_id`, `lbr_warranty`, `promo_flag`, `promo_status`, `promo_appr_by`, `promo_appr_date`, `promo_appr_rmk`) VALUES

Can+never+get+enough+tuts,+thanks+for+sharing!