iknown2 + redis存储结构设计

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)

项目表 Repo

• repos:id => "id" 记录最新的主键序列
• repos:$name => "id" 通过name查找id
• repos:$id:url => "url" 通过id查找svn url
• repos:$id:local_dir => "local_dir" 通过id查找本地目录位置
• repos:$id:desc => "desc" 通过id查找项目描述
• repos:$id:last_version => "last_version" 通过id查找最新的版本号(svn)
• repos:valid => set["name1", "name2", ...] 记录所有的有效项目
• repos => list["name1","name2", ...] 记录所有的项目,用于列表展示

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找到对应的提交时间