Stiglo je novo izdanje. Osvježi stranu.
Pripadanje je izbor. Pravo na odlazak jednako je važno kao pravo na ulazak. Manifest
Privatnost
Ne tražimo pravno ime ni adresu elektronske pošte. Lozinka se čuva kao argon2id sažetak, identifikator sesije kao sažetak. Grad je dobrovoljan. IP se koristi samo za ograničenje zahtjeva u radnoj memoriji. Nema analitike ni spoljnog praćenja. Dnevne rezervne kopije čuvaju se sedam dana; završna kopija izdanja 1 ostaje arhiva migracije. Brisanje uklanja profil i pristup; javni tragovi transakcija ostaju radi provjerljivosti. Povratnica važi 90 dana. Izvoz ne sadrži tuđe izbore pri glasanju. U nastavku je tačan popis tabela i polja.
| Tabela | Polja |
|---|---|
meta | key, value |
users | id, handle, display, pass_hash, role, level, city, bio, avatar, hue, member_no, dinar, created_at, last_visit_at, prev_visit_at, banned, deleted, is_seed, is_test, city_id, pismo, abuse_contact, invited_by |
sessions | id_hash, user_id, csrf, created_at, expires_at |
categories | id, slug, name, description, icon, position, admin_only |
threads | id, category_id, user_id, title, created_at, last_post_at, last_post_user, reply_count, views, pinned, locked, deleted, lang |
posts | id, thread_id, user_id, body, created_at, edited_at, deleted, lang |
search | title, body, post_id, thread_id |
reactions | post_id, user_id, kind, created_at |
reports | id, post_id, user_id, reason, created_at, resolved_by, resolved_at, outcome |
notifications | id, user_id, kind, actor_id, thread_id, post_id, created_at, read |
thread_reads | user_id, thread_id, read_at |
ledger | id, user_id, delta, reason, ref, created_at |
user_cards | id, user_id, edition, serial, price, created_at |
mod_log | id, actor_id, action, target, note, created_at |
names | name, skeleton, owner_id, kind, net, origin, service_id, status, trust, sequence, expires_at, policy_version, created_at, updated_at, sig, key_id |
reg_keys | key_id, public_key, created_at, retired_at |
reg_log | seq, at, action, name, actor_id, payload, prev_hash, hash, sig, key_id |
approvals | id, subject, subject_id, steward_id, at |
projects | id, owner_id, title, kind, summary, city_id, name, url, lang, created_at |
pages | name, owner_id, title, body, published, updated_at |
follows | user_id, kind, target_id, at |
listings | id, seller_id, title, body, kind, price_eur_text, price_dinar, stock, status, created_at |
orders | id, listing_id, buyer_id, seller_id, amount, status, created_at, updated_at, release_at |
ratings | order_id, from_id, to_id, score, note, at |
disputes | id, kind, ref, opener_id, respondent_id, statement, response, reviewer_id, decision, status, deadline_at, appeal_of, redact, created_at, decided_at |
proposals | id, kind, title, body, options, author_id, thread_id, opens_at, closes_at, quorum, threshold, status, result |
ballots | proposal_id, user_id, choice, at |
candidates | proposal_id, user_id, seat, statement |
mandates | id, user_id, seat, starts_at, ends_at, proposal_id |
mirrors | id, owner_id, url, city_id, note, created_at, simulated |
invites | code, user_id, created_at, uses |
returns | handle, code_hash, member_no, payload, expires_at |
lesson_done | user_id, lesson, at |
counters | key, day, n |
docs | slug, title, body, version, updated_at |
card_instances | id, edition, serial, owner_id, minted_at, source, sig, key_id |
card_transfers | id, card_id, from_id, to_id, kind, trade_id, at |
trades | id, from_id, to_id, give_json, want_json, dinar, status, created_at, decided_at |
card_shares | token, user_id, fields_json, created_at, revoked |
name_transfers | name, from_id, to_id, expires_at |
work_submissions | id, user_id, lesson, lang, body, reviewer_id, completed_at, created_at |
activities | id, user_id, kind, ref, at |