What Student groups holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| orgs_orgs | school_id, reg_no, name, campus, kind, description, state, registered_by, seconded_by, activated_at, closed_at, slot_dow, slot_minute, slot_len, slot_every, slot_tz, slot_mode, slot_seats, slot_host | Lists the group at its college, says which two officers registered and confirmed it, and holds its regular meeting time. It says nothing about who belongs. | While the group exists. A registration nobody confirms is removed after 21 days. Your name comes off it if you erase your account. | Row E21 |
| orgs_roles | org_id, member_id, role_key, state, from_ym, ends_ym, to_ym, renew_to_ym, heir_id, confirms, record_state | Records which officer role you hold in a group, its dates, and how many other officers confirmed it, for the group's page and a line on The Record. | While you have an account. A role nobody confirms is removed after 21 days. | Row E23 |
| orgs_role_confirms | role_id, confirmer_id, what, created_at, withdrawn_at | Records that an officer confirmed another officer's role, so the Record can say how many did. | With the role. If you erase your account your name comes off and the count stays. | Row E23 |
| orgs_meetings | org_id, kind, title, starts_at, ends_at, state, present, pots | Counts how many people came to a group's standing table. It holds counts only, never who came. | 24 months. | Row E24 |