What Study sessions holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| sessions_meetings | host_id, title, note, tags, mode, room_key, seats, seats_taken, starts_at, ends_at, state, cancel_key, host_seconds, guests_present | Lists the table on the board, says who hosts it and when, and, once it has met, how it was counted. | A table that was called off or did not meet, 90 days after it was due. A table that met stays as a count for the people who sat at it; if the host's account is erased its title and note are blanked. | Row E6 |
| sessions_rsvps | meeting_id, member_id, state, show_name | Holds a seat for you, says whether you came, and whether you chose to have your name shown to others at the table. | 90 days after the table, or when you erase your account. | Row E7 |
| sessions_attendance | meeting_id, member_id, host_id, role, seconds, present, had_seat, day | Counted from the study rooms' visit log, not typed in by anyone. It decides whether a table counts and what the host's line on The Record says. | 400 days, or until you erase your account. | Row E8 |
| sessions_host_terms | host_id, term_key, tables, attendances, people | Adds up a host's counted tables, the different people who came and how many came back, for the line on The Record. | While the host has an account. | Row E9 |