Skip to content

Instantly share code, notes, and snippets.

@mccxj

mccxj/iknown2.md

Last active December 22, 2015 08:59
Show Gist options
  • Save mccxj/6449058 to your computer and use it in GitHub Desktop.
Save mccxj/6449058 to your computer and use it in GitHub Desktop.
Download ZIP
iknown2 + redis存储结构设计
Raw
iknown2.md

用户表 User

  • users:id => "id" 记录最新的主键序列
  • users:$account => "id" 通过account查找id
  • users:$id:name => "name" 通过id查找name
  • users:$id:email => "email" 通过id查找email
  • users:$id:last_login => "last_login" 通过id查找最后登录时间
  • users:admin => set["account1", "account2", ...] 记录所有管理员权限用户
  • users => list["account1","account2", ...] 记录所有的用户,用于列表展示(sort test alpha limit 2 1)
@mccxj
Copy link
Author

mccxj commented Sep 5, 2013

repos:$id:versions => list["version1", "version2", ...] 项目所有的版本提交记录

版本表 Version

  • versions:id => "id" 记录最新的主键序列
  • versions:$id:commit => "id" 通过id查找git commitid
  • versions:$id:repo => "repoid" 对应的repo
  • versions:$id:author => 'author id' 通过id找到对应的提交人
  • versions:$id:commit_at => 'commit_at' 通过id找到对应的提交时间

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment