[Dev]

Dumped 2024-02-01

Table: m_users, Row Count: 101

*It appears the only users are employee's*


m_users has passwords+emails, members is seemingly employee records

Sample:

Sample Data - users Spoiler

(1,50,20,'Indra Pramana','indra.pramana@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','192.168.22.1','SUPERADMIN','0','1',NULL,'#e7d1be',NULL,NULL,NULL,NULL,55,'2023-08-31 17:00:13',NULL), (2,56,20,'Fajar Riyanto Suryadi','fajar.riyan@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','115.85.78.34','SUPERADMIN','1','0',NULL,'#8c5e18',NULL,'2024-01-30 08:42:16',NULL,NULL,55,'2024-01-30 08:42:16',NULL), (3,48,20,'Inri Sairath','programmer03@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','192.168.22.1','SUPERADMIN','0','1',NULL,'#997193',NULL,NULL,NULL,NULL,55,'2023-08-31 17:00:13',NULL), (4,47,15,'Cindy Patricia','cindy.patricia@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','::1','MANAGER CLAIM','0','1',NULL,'#d14423',NULL,NULL,NULL,NULL,55,'2023-08-31 17:00:13',NULL), (5,46,15,'Sienny Siaul','sienny.siaul@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','192.168.22.1','MANAGER CLAIM','0','1',NULL,'#cad89d',NULL,NULL,NULL,NULL,55,'2023-08-31 17:00:13',NULL), (6,8,1,'Muhammad Sofian','muhammad.sofian@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','115.85.78.34','ADMIN','1','0',NULL,'#f50c74',NULL,'2024-01-31 06:03:06',NULL,NULL,55,'2024-01-31 06:03:06',NULL), (7,27,1,'Tirsa Hardiyanti','admin1@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','192.168.22.1','ADMIN','0','1',NULL,'#604da8',NULL,NULL,NULL,NULL,55,'2023-08-31 17:00:13',NULL), (8,28,7,'Beti Depiyana','beti.depiyana@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','115.85.78.34','CLAIM','1','0',NULL,'#a393ef',NULL,'2024-01-09 06:01:40',NULL,NULL,55,'2024-01-09 06:01:40',NULL), (9,51,7,'Agung Permanajati','agung.permanajati@ibsrisk.com','$2y$10$T0uMcbC6ivzgUhBzT1hyJOGmmGTe.838TW3CxYa.d3i.GjEfvmUSS','::1','CLAIM','0','1',NULL,'#f3084e',NULL,NULL,NULL,NULL,55,'2023-08-31 17:00:13',NULL), (10,73,7,'Dewi Margo Nurwulan','dewi.margo@ibsrisk.com','$2y$10$8scmIxe7dZCxpLEJGAaqiuHKX4H1FjuuyZBYwp/ikyVUGPvOaDrlG','115.85.78.34','CLAIM','1','0',NULL,'#b11ba4',NULL,'2024-01-09 02:56:59',NULL,NULL,55,'2024-01-09 02:56:59',NULL),

Sample Data - Members Spoiler

(1603,'1067',23,70,'1','init','52033-3','52033','52033','VIA RAHMADIAN TINAS','MAZISHA AUDREY MAYUVARA','2011-02-11','F','C','','2019-04-18','2019-04-18',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-11 07:26:06',1,NULL,NULL), (1604,'1068',23,70,'1','init','52034-2','52034','52034','SILVIA MARYANI SIBUEA','DODY JUPANTRI SILITONGA','1985-06-09','M','S','','2019-04-18','2019-04-18',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-11 07:26:06',1,NULL,NULL), (1605,'1069',23,70,'1','init','52034-3','52034','52034','SILVIA MARYANI SIBUEA','MARIO VIDY PUTRA SILITONGA','2012-03-03','M','C','','2019-04-18','2019-04-18',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-11 07:26:06',1,NULL,NULL),

Table Names + Row Count Spoiler

Table: failed_jobs, Row Count: 638 Table: m_agents, Row Count: 29 Table: m_banks, Row Count: 74 Table: m_cities, Row Count: 82361 Table: m_client_groups, Row Count: 44 Table: m_client_histories, Row Count: 2 Table: m_client_line_businesses, Row Count: 92 Table: m_client_pics, Row Count: 44 Table: m_client_policies, Row Count: 660 Table: m_clients, Row Count: 1299 Table: m_conditions, Row Count: 49 Table: m_counters, Row Count: 17 Table: m_documents, Row Count: 42 Table: m_emails, Row Count: 28 Table: m_individuals, Row Count: 56 Table: m_insurances, Row Count: 78 Table: m_kurs, Row Count: 23 Table: m_members, Row Count: 199349 Table: m_menu, Row Count: 90 Table: m_menu_roles, Row Count: 348 Table: m_reason_cases, Row Count: 40 Table: m_references, Row Count: 516 Table: m_roles, Row Count: 27 Table: m_ssls, Row Count: 27 Table: m_targets, Row Count: 3 Table: m_template_member, Row Count: 11 Table: m_user_clients, Row Count: 53 Table: m_user_employees, Row Count: 114 Table: m_user_family, Row Count: 2 Table: m_users, Row Count: 101 Table: migrations, Row Count: 146 Table: notifications, Row Count: 5507 Table: password_resets, Row Count: 71 Table: personal_access_tokens, Row Count: 1043 Table: register_employee, Row Count: 8 Table: t_benefit_plans, Row Count: 6637 Table: t_billings, Row Count: 12 Table: t_claim_adhoc, Row Count: 15 Table: t_claim_adhoc_member, Row Count: 29 Table: t_claim_detail_reasons, Row Count: 3 Table: t_claim_details, Row Count: 990 Table: t_claim_files, Row Count: 1871 Table: t_claim_import, Row Count: 855297 Table: t_claim_import_template, Row Count: 183 Table: t_claim_parent, Row Count: 444 Table: t_claim_report, Row Count: 136 Table: t_claims, Row Count: 1556 Table: t_excess_detail_reasons, Row Count: 39 Table: t_excess_details, Row Count: 413 Table: t_excess_files, Row Count: 367 Table: t_excesses, Row Count: 50 Table: t_handovers, Row Count: 5841 Table: t_individual_invoices, Row Count: 79 Table: t_individual_quotation_files, Row Count: 292 Table: t_individual_quotation_insurances, Row Count: 82 Table: t_individual_quotation_member_premiums, Row Count: 86 Table: t_individual_quotation_members, Row Count: 86 Table: t_individual_quotations, Row Count: 82 Table: t_letters, Row Count: 7498 Table: t_logs, Row Count: 549 Table: t_logs_email, Row Count: 70 Table: t_meeting_attendances, Row Count: 1488 Table: t_meeting_files, Row Count: 21 Table: t_meeting_issues, Row Count: 1 Table: t_meeting_sources, Row Count: 260 Table: t_meetings, Row Count: 240 Table: t_member_request_file, Row Count: 6 Table: t_members_batch, Row Count: 8 Table: t_members_pre, Row Count: 122 Table: t_message_claims_detail, Row Count: 714 Table: t_message_claims_header, Row Count: 1417 Table: t_pipeline_benefits, Row Count: 67 Table: t_pipeline_contacts, Row Count: 536 Table: t_pipeline_covers, Row Count: 120 Table: t_pipeline_issues, Row Count: 53 Table: t_pipelines, Row Count: 536 Table: t_placing_condition_ps, Row Count: 11528 Table: t_placing_condition_qs, Row Count: 10380 Table: t_placing_files, Row Count: 252 Table: t_placings, Row Count: 62 Table: t_proposal_files, Row Count: 1735 Table: t_proposal_insurance_details, Row Count: 1459 Table: t_proposal_insurances, Row Count: 1450 Table: t_proposal_revisions, Row Count: 21 Table: t_proposals, Row Count: 690 Table: t_request_claims, Row Count: 1980 Table: t_request_coverages, Row Count: 2119 Table: t_request_files, Row Count: 2218 Table: t_request_history_pic, Row Count: 3 Table: t_request_maintains, Row Count: 2037 Table: t_requests, Row Count: 945 Table: t_ssl_activities, Row Count: 1 Table: t_ssl_detail_files, Row Count: 34 Table: t_ssl_details, Row Count: 153 Table: t_ssls, Row Count: 268

Download:

Hidden Content

You must register or login to view this content.