=== COMPREHENSIVE DATABASE ANALYSIS ===
Time: 2026-01-27 23:59:37

--- 1. Table Overview ---
users               : 2512 rows
profiles            : 2427 rows
activities          : 13 rows
activity_batches    : 7 rows
payments            : 0 rows
payment_methods     : 7 rows
activitiusers       : [MISSING]
activity_users      : 1206 rows

--- 2. Activity Configuration ---
ID: 0MV3C4 | Name: Rapat Awal Tahun 2026
   - Price: 15,000
   - Creator ID: C0VS51
   - Batches: 0
ID: 1VFD25 | Name: KONFERENSI KERJA I PGRI KABUPATEN SERANG
   - Price: 0
   - Creator ID: J375UK
   - Batches: 1
     > Batch ID: OC44D0 | Name: Masa Bakti XXIII Tahun 2024-2029 | Price: NULL (Follow Activity)
ID: 2T9N9Y | Name: HUT TNI AL
   - Price: 0
   - Creator ID: 07Q2UD
   - Batches: 0
ID: 2VC3M8 | Name: Workshop AI Gembira
   - Price: 15,000
   - Creator ID: 9GIC62
   - Batches: 1
     > Batch ID: 8CM8Y4 | Name: Batch 1 | Price: NULL (Follow Activity)
ID: 327PIE | Name: WEBINAR BELAJAR METODOLOGI PENELITIAN DAN STATISTIK DARI PAKAR
   - Price: 0
   - Creator ID: H3KP51
   - Batches: 0
ID: 40P7YR | Name: SEMINAR NASIONAL PENINGKATAN KOMPETENSI GURU
   - Price: 0
   - Creator ID: 2P2XP3
   - Batches: 1
     > Batch ID: 65BX9X | Name: Batch 1 | Price: NULL (Follow Activity)
ID: 484GTH | Name: CONFLICT_TEST
   - Price: 50,000
   - Creator ID: 004XNA
   - Batches: 0
ID: 6GW0C1 | Name: CONFLICT_TEST
   - Price: 50,000
   - Creator ID: 004XNA
   - Batches: 0
ID: B10P3F | Name: TEST_FREE
   - Price: 0
   - Creator ID: 004XNA
   - Batches: 0
ID: B96E4S | Name: KONFERENSI KERJA I PROVINSI BANTEN
   - Price: 0
   - Creator ID: AXZ046
   - Batches: 1
     > Batch ID: F45JM4 | Name: Batch 1 | Price: NULL (Follow Activity)
ID: D69I6B | Name: Rakernas BPLP PGRI dan YPLP PGRI Pusat
   - Price: 2,100,000
   - Creator ID: 0LC4S5
   - Batches: 1
     > Batch ID: U8B5B5 | Name: Batch 1 | Price: NULL (Follow Activity)
ID: M5W8F3 | Name: TEST_REG_FLOW
   - Price: 50,000
   - Creator ID: 004XNA
   - Batches: 1
     > Batch ID: J97AW3 | Name: Batch 1 | Price: NULL (Follow Activity)
ID: XV0T09 | Name: Webinar OGRI SLCC
   - Price: 15,000
   - Creator ID: C0VS51
   - Batches: 0

--- 3. User & Profile Consistency ---
Users without profile: 91
Orphaned Profiles: 0

--- 4. Payment Analysis ---
Payment Status Breakdown:
Payments requiring proof but empty: 0
Bulk Payments detected: 0

--- 5. Enrollment Table Check (activitiusers vs activity_users) ---
Table 'activity_users': 1206 rows
Table 'activitiusers': 0 rows (Likely ACTIVE)

--- Analysis Complete. ---