IV. Database schema

Schema

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

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