Report total durasi per peserta per tanggal/meeting (gabungan multiple sessions) - Menggunakan tabel original
| Kolom | Header | Isi | Contoh |
|---|---|---|---|
| A | Name | Nama (Bersih) | Christine Gozali |
| B | UserEmail | christine@example.com | |
| C | JoinTIME | Join Pertama (WIB) mm/dd/yyyy hh:mm | 03/15/2024 09:00 |
| D | LeaveTime | Leave Terakhir (WIB) mm/dd/yyyy hh:mm | 03/15/2024 11:30 |
| E | Duration | Total Durasi (menit) | 150 |
| Waktu UTC di DB | → | Format WIB di Report/CSV |
|---|---|---|
| 2024-03-15 02:00:00 | → | 03/15/2024 09:00 |
| 2024-03-15 04:30:00 | → | 03/15/2024 11:30 |
| 2024-12-31 16:45:00 | → | 12/31/2024 23:45 |
| Tabel | Digunakan untuk | Keterangan |
|---|---|---|
| meetings | Data meeting | Informasi meeting sesi 1 |
| participants | Data peserta | Informasi peserta sesi 1 |
| participant_sessions | Sesi peserta | Join/leave time dan durasi sesi 1 |
| breakout_rooms | Breakout rooms | Data breakout rooms sesi 1 |