What Messages holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| notes_messages | conversation_id, seq, sender_id, body, sys, state, created_at | Delivers messages between people who are connected, and keeps them so you can read them again. | Cleared twelve months after the message was sent. A message you take back loses its words at once. | Row C1 |
| notes_conversations | pub, kind, title, purpose, owner_id, state, member_count, last_seq, last_at, last_nonce | Holds the list of conversations, a group conversation's name and who started it. | Until nobody is in it. A closed group conversation is deleted after 30 days. | Row C4 |
| notes_members | conversation_id, member_id, state, invited_by, invite_expires, join_seq, read_seq, muted, sent_day, changed_at | Records who is in each conversation or group conversation, what they have read and whether they muted it. | While the conversation exists. | Row C4 |
| notes_outbox | conversation_id, sender_id, body, state, reason, case_id, created_at, decided_at | Holds a message that the safety tools stopped, for its author only, until it is checked. | 14 days after it is decided or goes unchecked. | Row C3 |
| notes_kept | conversation_id, seq, why, body, purge_at, created_at | Keeps the words of a message taken back in case it is reported. | 14 days. | Row C2 |
| notes_nods | from_id, to_id, state, ctx, misses, sent_at, expires_at | Records who asked whom to connect and how they found each other, so a request can be answered, and so one person cannot send the same request again and again. A request that is not shown to the other person is kept and shown to nobody. | A request nobody answers lapses after 14 days. The record goes 180 days after it was sent, or when you erase your account. A connection that came of it stays a connection. | Row C5 |
| notes_intros | by_id, a_id, b_id, reason, line, a_answer, b_answer, state, created_at, expires_at | Records that one member proposed that two others meet, the one line they wrote, and each person's answer. A no is kept and shown to nobody. | 180 days after it was made, or when any of the three of you erases an account. A connection that came of it stays a connection. | Row C5 |
| notes_reactions | conversation_id, seq, member_id, kind, created_at | Shows which small reaction you gave to a message. | With the message. | Row C6 |
| notes_people | member_id, other_id, memo, remind_on, changed_at | Holds the memo and the follow-up day you wrote about one connection. Nobody else sees it, staff included. | Until you change it or erase your account. | Row C7 |
| notes_prefs | member_id, hold_brewing, away_until, away_reason, changed_at | Remembers whether messages wait while you are studying, and the away line you set. | Until you change them or erase your account. | Row C7 |
| notes_find | member_id, who_finds, about, about_state, case_id, paused_until, pause_from, changed_at | Remembers who may find you by name in Find people, the one line you wrote about yourself for the people who find you (screened, and shown to others only if you let them find you), and whether your connection requests are paused because many were not accepted. | Until you change it or erase your account. | Row C7 |
| notes_calls | pub, conversation_id, caller_id, state, why, started_at, answered_at, ended_at | Records who called whom from which conversation, and when, so that something said in a call can be reported. Calls are never recorded and nothing anyone says is kept. | Twelve months after the call. Your part goes when you erase your account. | Row C8 |
| notes_call_people | call_id, member_id, state, rang_at, joined_at, left_at, seen_at, tab_at, mic, tab, rt_session, rt_track | Records who was rung, who answered, and when each person joined and left a call. While you are in a call it also holds whether your microphone is on and which browser tab the call is in; those go when you leave. | Twelve months after the call. Yours go when you erase your account. | Row C8 |
| notes_call_prefs | member_id, notice_seen | Remembers that you have read the short notice shown before your first call, so it is not shown again. | Until you erase your account. | Row C7 |