§model
Any changes in these tables should be handled with care and usually
involve data migration, otherwise data might be lost.
§user
| tree | key | value |
|---|
| default | “users_count” | N |
| “users” | uid | User |
| “usernames” | username | uid |
| “user_following” | uid#uid | &[] |
| “user_followers” | uid#uid | &[] |
| “user_stats” | timestamp_uid_type | N |
| “user_uploads” | uid#img_id | image_hash.ext |
| default | “imgs_count” | N |
| “home_pages” | uid | u8 |
| “tan” | ctype#id | &[] |
§notification
| tree | key | value |
|---|
| default | “notifications_count” | N |
| “notifications” | uid#nid#nt_type | id1#id2#is_read |
§captcha
| tree | key | value |
|---|
| “captcha” | timestamp_nanoid | captcha_chars |
§solo
| tree | key | value |
|---|
| default | “solos_count” | N |
| “solos” | sid | Solo |
| “user_solos” | uid#sid | solo_type |
| “user_solos_like” | uid#sid | &[] |
| “solo_users_like” | sid#uid | &[] |
| “solo_timeline” | sid | uid#solo_type |
| “hashtags” | hashtag#sid | &[] |
§session
| tree | key | value |
|---|
| “sessions” | timestamp_nanoid | Claim |
§site config
§inn
| tree | key | value |
|---|
| default | “inns_count” | N |
| “inns” | iid | Inn |
| “inn_names” | inn_name | iid |
| “topics” | topic#iid | &[] |
| “mod_inns” | uid#iid | &[] |
| “user_inns” | uid#iid | &[] |
| “inn_apply” | iid#uid | &[] |
| “inn_users” | iid#uid | &[1/2/3/4/5/8/10] |
| “inns_private” | iid | &[] |
| “drafts” | uid | FormPost |
| “inn_feeds” | iid#feed_id | uid |
| “inn_items” | iid#item_id | &[] |
§post
| tree | key | value |
|---|
| default | “posts_count” | N |
| “posts” | pid | Post |
| “inn_posts” | iid#pid | &[] |
| “user_posts” | uid#pid | iid#inn_type |
| “tags” | tag#pid | &[] |
| “post_upvotes” | pid#uid | &[] |
| “post_downvotes” | pid#uid | &[] |
| “post_timeline_idx” | iid#pid | timestamp#inn_type |
| “post_timeline” | timestamp#iid#pid | inn_type |
| “post_pageviews” | pid | N |
| “post_pins” | iid#pid | &[] |
| tree | key | value |
|---|
| “post_comments_count” | pid | N |
| “post_comments” | pid#cid | Comment |
| “user_comments” | uid#pid#cid | &[] |
| “comment_upvotes” | pid#cid#uid | &[] |
| “comment_downvotes” | pid#cid#uid | &[] |
| tree | key | value |
|---|
| default | “feeds_count” | N |
| default | “items_count” | N |
| “user_folders” | uid#folder#feed_id | &[0/1] |
| “feeds” | feed_id | Feed |
| “feed_errs” | feed_id | “error msg” |
| “feed_items” | feed_id#item_id | timestamp |
| “feed_links” | feed_link | feed_id |
| “item_links” | item_link | item_id |
| “items” | item_id | Item |
| “read” | uid#item_id | &[] |
| “star” | uid#item_id | timestamp |
§e2ee message
| tree | key | value |
|---|
| default | “messages_count” | N |
| “messages” | mid | #uid#uid#message |
| “pub_keys” | uid | pub_key |
| “user_messages” | uid#mid | &[] |