Database
Every table this install keeps, row by row. Read anything; change a row only when you mean to.
- Tables
- 20
- SQLite · sidecarr.db
- Rows
- 126
- across all of them
- On disk
- 18.4 MB
- with its indexes
- Last backup
- Today, 4:00 AM
- Instance keeps the schedule
Tables
-
The keys the server uses to talk to other services. Only whether one is set ever reaches this page — the secret itself stays on the server.
2 rows · 5 columns
-
Who did what, and when — the Audit log reads this table. It is the record of what this page does too, so it can be read here but never changed.
9 rows · 8 columns
Read-only
-
Requests with a reward on them. The Service Record lists the ones you posted.
1 row · 5 columns
-
The server’s conversation — the thread in the corner of every page.
4 rows · 7 columns
-
Communities around what people love. `joined` is 1 for the clubs you are in.
8 rows · 7 columns
-
Reviews members have written. The Hot Take Hub and each member’s Service Record read this table.
8 rows · 8 columns
-
Invite codes and who they are for. The Admin Panel lists the same three.
3 rows · 5 columns
-
People asking to join. Empty for as long as the server is invite-only — Server settings decides who may ask.
0 rows · 4 columns
-
Which roles each member holds. A member may hold several; what they may do is the union of them.
10 rows · 2 columns
-
Everyone on this server. Members reads this table; the roles each one holds are in member_roles.
9 rows · 11 columns
-
What the bell has to say. `is_read` turns to 1 when you open one.
6 rows · 6 columns
-
The choices in each poll. An open poll keeps its share NULL until it closes, so the tally cannot steer the vote.
7 rows · 5 columns
-
Every poll and bracket on the server. Their choices are in poll_options.
3 rows · 6 columns
-
What each role may do, one permission a row. The Roles matrix is this table; the owner holds everything and is never listed.
23 rows · 2 columns
-
The roles on this server — the ones Sidecarr ships and any you make. Roles reads this table.
5 rows · 6 columns
-
The changelog. Server Updates reads this table; News tells the same story at length.
6 rows · 6 columns
-
The server’s own settings, one per row. Server settings and the Admin Panel write here.
11 rows · 2 columns
-
What a member gets for what they pay you. NULL in a limit means unlimited.
3 rows · 7 columns
-
The Live Trivia leaderboard: every player’s running score and their best streak.
5 rows · 3 columns
-
Parties that are running. Watch Parties lists them; each has a room.
3 rows · 6 columns
No table is called thatNothing here is named that or holds it. Try part of a word — “member”, “poll”, “key”.
Run a query
Ran.
| columnTEXT | columnTEXT | columnTEXT |
|---|---|---|
| value | NULL | Hidden |
Changes you made here are kept in this browser until there is a server.
There is no database behind this page yet: it shows the same mock data every other screen does. A query runs in your browser against a copy of it, and anything you change is kept in this browser until there is a server.