[Royal_Empire]

                                                             HELLO DARKFORUMS COMMUNITY,

Today, I am documenting the database structure associated with Carsworld.id, an automotive service and merchant marketplace platform operating in Indonesia. The dataset appears to support merchant listings, service management, and platform operations.

📊 Database Information:
• 🌍 Domain: carsworld.id
• 🗂️ Platform Type: Automotive Services / Merchant Marketplace
• 📦 File Type: SQL database
• 📏 Size: ~2.88 MB
• 👥 Estimated Records: ~213,303 (reported lines)
• 🌏 Region: Indonesia (ID)

📌 Compromised Data:
• Merchant identifiers and category mappings
• Business names and descriptive fields
• Contact details (email, phone, WhatsApp)
• Geographic hierarchy (province, city, district, village)
• Address and location coordinates (latitude/longitude)
• Service availability and scheduling data
• Operating hours (opening/closing times)
• Ratings and feature flags
• Media references (image URLs)
• System metadata (creation and update timestamps, external IDs)

🗄️ Key Database Tables:
• t_merchant – merchant listings, contact, location, ratings, and service details
• t_artikel_konsultasi – consultation articles and category content
• t_workshop_owner – workshop owner profiles and account status information
• t_workshop_owner_session – session logs including device, IP, and user agent metadata

--- ### **1️⃣ t_merchant (10 rows)** ```sql INSERT INTO `t_merchant` (`id`, `category_id`, `name`, `deskripsi`, `email`, `phone`, `whatsapp`, `propinsi`, `kota`, `kecamatan`, `kelurahan`, `id_wilayah`, `alamat_lengkap`, `image_url`, `rating`, `latitude`, `longitude`, `enabled`, `home_services`, `is_featured`, `booking_time`, `open_operation`, `close_operation`, `external_id`, `created`, `updated_at`, `updated_by`) VALUES (1, 1, '[DEV] CARfix WR Supratman', '', '[email protected]', '', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Semarang Barat', 'Gisikdrono', '33.74.13', 'Jl. WR. Soepratman No.18 Semarang', 'https://images.ved.carsworld.id/i/7763a3b7652586e522136474565a5cc1.jpg', 4.4, -6.98901586, 110.38562056, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:54:15', '2020-10-15 15:37:33', 'pandu.wiliantoro'), (2, 1, '[DEV] CARfix Brigjend Sudiarto', '', '[email protected]', '02476719060', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Pedurungan', 'Palebon', '33.74.06', 'Jl. Brigjend Sudiarto No.426, Semarang', 'https://static.carsworld.id/images/g/n/gn.jpg', 4.4, -7.01007027, 110.47011595, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:54:53', '2021-01-11 19:33:23', 'pandu.wiliantoro'), (3, 1, '[DEV] CARfix Tentara Pelajar', '', '[email protected]', '02486452880', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Candisari', 'Jomblang', '33.74.08', 'Jl. Tentara Pelajar No.25, Semarang', 'https://images.ved.carsworld.id/i/6e60426bd294de5b125a060de6264a63.jpg', 4.5, -7.00911164, 110.43353213, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:55:22', '2021-01-11 19:33:23', 'pandu.wiliantoro'), (4, 1, '[DEV] CARfix Wali Songo', '', '[email protected]', '0248662321', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Tugu', 'Karanganyar', '33.74.16', 'Jl. Walisongo KM11 No.203 Tugu Semarang', 'https://images.ved.carsworld.id/i/6e391be2ad90ce466a3ae1d363fafb67.jpg', 4.3, -6.98379520, 110.33873166, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:55:44', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (5, 1, '[DEV] CARfix Veteran Solo', '', '[email protected]', '0271710177', '+628112982288', 'Jawa Tengah', 'Kota Surakarta', 'Pasar Kliwon', 'Pasar Kliwon', '33.72.03', 'Jl. Veteran No.278, Tipes, Solo', 'https://images.ved.carsworld.id/i/b0ba40fbf789fe2b1bdec47b712c2e10.jpg', 4.4, -7.57895105, 110.81007154, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 12:19:50', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (6, 1, '[DEV] CARfix Ringroad Selatan', '', '[email protected]', '02744342941', '+628112982288', 'DIY Yogyakarta', 'Kab. Bantul', 'Kasihan', 'Tamantirto', '34.02.16', 'Jl. Ringroad Selatan, Taman Tirto, Bantul', 'https://images.ved.carsworld.id/i/365ebbbc6c5966bfdb1c2c5e3037aa14.jpg', 4.5, -7.82166594, 110.32450466, 1, 0, 0, '["9:00","10:00","11:00","13:00","14:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:50:23', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (7, 1, '[DEV] CARfix Dr. Cipto', '', '[email protected]', '0248318120', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Semarang Timur', 'Karangtempel', '33.74.03', 'Jl. Dr.Cipto No.218, Semarang', 'https://images.ved.carsworld.id/i/c18d1191f55807ecf3adf4c1435f8c8c.jpg', 4.8, -6.99073938, 110.43450286, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 12:10:48', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (8, 1, '[DEV] CARfix Setiabudi', '', '[email protected]', '02476405427', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Banyumanik', 'Srondol Kulon', '33.74.11', 'Jl. Setiabudi No.229, Semarang', 'https://images.ved.carsworld.id/i/3d13a36b29695af48166c8576fb4dbdd.jpg', 4.5, -7.06204434, 110.41278127, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 12:12:55', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (9, 1, '[DEV] CARfix Kendal', '', '[email protected]', '02943690970', '+628112982288', 'Jawa Tengah', 'Kab. Kendal', 'Kendal', 'Ketapang', '33.24.15', 'Jl. Soekarno-Hatta No.60 Kendal', 'https://images.ved.carsworld.id/i/3029b2a133be32623d7 ```

Telegram: RoyalxEmpire

Telegram Channel: @RoyalEmpireHQ