IV. Database schema

Shortcuts

• <bn> — board name
• <pn> — post number
• <tn> — thread number
• <fn> — file name

Value types

• ZSET — ordered set
• SET-M — multi-set (using multiple keys)
• HASH-M — multi-hash (using multiple keys)
• ZSET-M — ordered multi-set (using multiple keys)

Note: Refer to http://redis.io/topics/data-types

Schema

Key name	Value key	Value value	Type
postCounters	bn	pn	HASH
threads:bn	tn	JSON(...)	HASH-M
archivedThreads:bn	tn	JSON(...)	HASH-M
threadUpdateTimes:bn	tn	time	HASH-M
threadPostNumbers:bn:tn		pn	SET-M
threadsPlannedForDeletion		bn:tn	SET
posts	bn:pn	JSON(...)	HASH
referencedPosts:bn:pn	bn:pn	JSON(...)	HASH-M
referringPosts:bn:pn	bn:pn	JSON(...)	HASH-M
postFileInfoNames:bn:pn		fn	SET-M
postExtraData	bn:pn	JSON	HASH
fileInfos	fn	JSON(...)	HASH
fileHashes:hash		JSON(...)	SET-M
postSearchIndex:token		JSON(...)	SET-M
voteUsers:pn		IP	SET-M
voteVariantUsers:pn:id		IP	SET-M
postsPlannedForDeletion		bn:pn	SET
captchaQuotas	bn:IP	quota	HASH
registeredUsers	hashpass	JSON(...)	HASH
registeredUserHashes	IP	hash	HASH
userPostNumbers:IP:bn		pn	SET-M
userBans:IP:bn		JSON(...)	KEY-M
chats:hash		bn:pn	HASH-M
chat:bn:pn		JSON(...)	ZSET-M
synchronizationData:key		JSON(...)	SET-M
deletedThreads		bn:tn	SET