数据库表设计 - potatola/sbapp_backend GitHub Wiki

accounts

title	tpye
uid	int, primary
username	string, unique
password	string(md5)
phone	string
realname	string
gender	byte
age	int
job	string

activities

title	tpye
aid	int, primary
title	string
content	string
cover_url	string

user_activity_join

title	tpye
uid	int
aid	int
time	time
operation	byte
op_time	time

user_activity_act

title	tpye
uid	int
aid	int
time	time
act	int(0：签到，1：图片，2：说话)
location	string
content	string