Database
Every table this install keeps, row by row. Read anything; change a row only when you mean to.
members
9 rows · 11 columns · keyed by id
Everyone on this server. Members reads this table; the roles each one holds are in member_roles.
| Edit | id PKTEXT | nameTEXT | handleTEXT | emailTEXT | membershipTEXT | tier_idTEXT | librariesTEXT | joined_onTEXT | last_seenTEXT | guest_pass_endsTEXT | noteTEXT |
|---|---|---|---|---|---|---|---|---|---|---|---|
| m-avery | Avery Quinn | avery_q | avery.quinn@example.com | active | lifetime | ["Films","TV","Audiobooks","Music","Kids"] | 2024-03-02 | Watching now | NULL | NULL | |
| m-jordan | Jordan Ellis | jordan_e | jordan@example.com | active | pro | ["Films","TV","Audiobooks","Music","Kids"] | 2024-04-18 | 2 hours ago | NULL | NULL | |
| m-sam | Sam Okafor | sam_o | sam@example.com | active | pro | ["Films","TV","Audiobooks"] | 2024-06-01 | Yesterday | NULL | NULL | |
| m-mira | Mira Patel | mira_p | mira@example.com | active | pro | ["Films","TV"] | 2025-01-11 | 3 days ago | NULL | NULL | |
| m-josh | Josh Byrne | josh_99 | josh@example.com | active | free | ["Films","TV"] | 2025-05-20 | 1 hour ago | NULL | NULL | |
| m-noor | Noor Haddad | noor_h | noor@example.com | active | free | ["Films","Kids"] | 2025-08-04 | Last week | NULL | NULL | |
| m-kai | Kai Fletcher | kai_f | kai@example.com | invited | free | ["Films"] | NULL | Never | NULL | NULL | |
| m-rowan | Rowan Doyle | rowan_d | rowan@example.com | suspended | free | [] | 2025-02-09 | 2 months ago | NULL | Suspended after sharing their sign-in. | |
| m-guest | Cinema club (guest) | guest_pass | club@example.com | active | free | ["Films"] | 2026-09-14 | Today | 2026-09-28 | NULL |
Nothing in members yetNo row has been written to this table. It fills as the server writes to it.
No row matches thatNothing in members contains it. Try part of a word, or search every column.
Rows 1–9 of 9
Changes you made to this table are kept in this browser until there is a server.
Run a query
Ran.
The query matched nothingIt ran, and no row answered it. Loosen the WHERE, or check the value's spelling and case.
| columnTEXT | columnTEXT | columnTEXT |
|---|---|---|
| value | NULL | Hidden |
| Edit | id PKTEXT | nameTEXT | handleTEXT | emailTEXT | membershipTEXT | tier_idTEXT | librariesTEXT | joined_onTEXT | last_seenTEXT | guest_pass_endsTEXT | noteTEXT |
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | name | handle | membership | tier_id | libraries | joined_on | last_seen | guest_pass_ends | note |