Beachhousesmauritius.com Travel & Real Estate Marketplace [ 2.8M Records ]

HELLO DNA COMMUNITY,

The beachhousesmauritius.com dataset appears to be associated with a property rental and hospitality platform serving the Mauritius market. Based on the observed database structure, the environment utilizes a Vtiger CRM deployment containing contact management, account records, email-related information, address data, and activity-tracking components.

Dataset Information:

• Source: beachhousesmauritius.com
• Original File: beachhousesmauritius.com sql ( 44,081,513 bytes )
• Approximate Records: 2,876,619
• Compressed Size: 42 MB
• Language: English

Observed Database Artifacts:

• vtiger_contactdetails
• vtiger_account
• vtiger_emaildetails
• vtiger_leadaddress
• vtiger_modtracker_detail

Database Characteristics:

• Storage Engine: InnoDB
• Character Set: utf8

Code:
Sample Records INSERT INTO vtiger_account (accountid, account_no, accountname, parentid, accounttype, industry, annualrevenue, phone, otherphone, fax, email1, email2, website, ownership, employees, rating, siccode, tickersymbol, emailoptout, notify_owner) VALUES (1001, 'ACC1001', 'Acme Consulting Ltd', 0, 'Customer', 'Consulting', NULL, '+1-555-1001', '', '', 'contact@acmeconsulting.com', '', 'https://www.acmeconsulting.com', '', NULL, '', '', '', 0, 1), (1002, 'ACC1002', 'Global Retail Group', 0, 'Customer', 'Retail', NULL, '+1-555-1002', '', '', 'info@globalretail.com', '', 'https://www.globalretail.com', '', NULL, '', '', '', 0, 1), (1003, 'ACC1003', 'John Smith', 0, '', '', NULL, '+1-555-1003', '', '', 'john.smith@example.com', '', '', '', NULL, '', '', '', 0, 1), (1004, 'ACC1004', 'Sunrise Properties', 0, 'Partner', 'Real Estate', NULL, '+1-555-1004', '', '', 'sales@sunriseproperties.com', '', 'https://www.sunriseproperties.com', '', NULL, '', '', '', 0, 1), (1005, 'ACC1005', 'TechNova Solutions', 0, 'Customer', 'Technology', NULL, '+1-555-1005', '', '', 'support@technova.com', 'billing@technova.com', 'https://www.technova.com', '', NULL, '', '', '', 1, 0);


Code:
INSERT INTO vtiger_emaildetails (emailid, from_email, to_email, cc_email, bcc_email, attachment, relation, email_flag) VALUES (1001, 'sales@acmeconsulting.com', '["info@globalretail.com"]', '[""]', '[""]', '', '1001@1|', 'SENT'), (1002, 'contact@globalretail.com', '["john.smith@example.com"]', '[""]', '[""]', '', '1002@1|', 'SENT'), (1003, 'john.smith@example.com', '["sales@acmeconsulting.com"]', '[""]', '[""]', '', '1003@-1|', 'MailManager'), (1004, 'support@technova.com', '["contact@sunriseproperties.com"]', '["manager@sunriseproperties.com"]', '[""]', '', '1004@1|', 'SENT'), (1005, 'contact@sunriseproperties.com', '["support@technova.com"]', '[""]', '[""]', '', '1005@-1|', 'MailManager'), (1006, 'billing@technova.com', '["accounts@globalretail.com"]', '["finance@globalretail.com"]', '[""]', '', '1006@1|', 'SENT'), (1007, 'accounts@globalretail.com', '["billing@technova.com"]', '[""]', '[""]', '', '1007@-1|', 'MailManager'), (1008, 'sales@acmeconsulting.com', '["ceo@technova.com"]', '["assistant@technova.com"]', '[""]', '', '1008@1|', 'SENT'), (1009, 'ceo@technova.com', '["sales@acmeconsulting.com"]', '[""]', '[""]', '', '1009@-1|', 'MailManager'), (1010, 'info@globalretail.com', '["contact@sunriseproperties.com"]', '[""]', '[""]', '', '1010@1|', 'SENT');


Files:
Original SQL: beachhousesmauritius.com sql
Vouch center: