What the study rooms hold
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| shop_shops | owner_id, school_id, name, purpose, tags, entry, access, invite_code, hours | Lists the room in the lobby (or keeps it by invitation only, with the code you hand out) and decides who may go in. | Until you close the room or delete your account. A room nobody visits for 14 days closes by itself. | Row B15 |
| shop_visits | member_id, shop_id, floor, arrived_at, left_at, study_seconds, table_label, alongside | Shows you how long you studied, at which table and alongside whom. Nobody else is shown it. | 30 days after the visit ends. | Row B4 |
| shop_study_totals | member_id, seconds, updated_at | Shows you the total of your study time beside your last 7 days. Added to everyone else's with no names, it makes the one house total Tillyard House shows. | Until you delete your account. | Row B16 |
| shop_settings | member_id, live_activity, last_seen, sound, chatter, volume, view, headline, linkedin, visits | Remembers your sound and view choices, whether connections may see which room you are in and when you were last in one, and the headline and LinkedIn address shown to people you shake hands with. | Until you change them or delete your account. | Row B13 |
| shop_invites | shop_id, member_id, via, invited_at | Lets people into a study room that is by invitation only, and keeps out someone the owner removed. | Until the owner removes you, closes the room, or you delete your account. | Row B13 |
| shop_prefs | member_id, chat_beside, voice_seen, push_key, keys, ambience | Remembers whether you keep the table's chat beside the room, that you have read the notice shown before you first join voice, whether push-to-talk is on, the keys you changed, and the room sound you chose. | Until you change it or delete your account. | Row B13 |
| shop_queue | shop_id, member_id, joined_at, seen_at, admitted_at | Keeps your place in the queue for a study room with no free seat, and lets you in when it is your turn. | Until you go in or leave the queue, or a minute after you leave the page. | Row B3 |
| shop_handshakes | from_id, to_id, shop_id, state, created_at | Applies the limits on handshake offers. A connection that was made is kept with your other connections. | 30 days. | Row B7 |