データ構造 - littlekbt/three GitHub Wiki

users

key	type	memo
id	string	auto increment
email	string
auth_type	number	0:email, 1: facebook
name	string
sex	number	0,1
birthday	string
city	number
photo	string
genres	Array<genre>
tags	Array<tag>
device_id	string
groups	Array<group>	sub collection
invitated_groups	Array<group>	sub collection
like_groups	Array<user>	sub collection
dislike_groups	Array<user>	sub collection
initilized	boolean
last_logined_at	timestamp
created_at	timestamp
updated_at	timestamp

groups

key	type	memo
id	string	auto
name	string
admin	user	sub collection
members	Array<user>	sub collection
phrase	string
stances	Array<stance>	sub collection
areas	Array<area>	sub collection
desc	string
user_liked	Array<user>	sub collection
member_liked_history	{group_id: [{user_id: boolean, user_id: boolean, user_id: boolean}]}	groupidをキーとして、所属メンバーのいいねの履歴を保持する
created_at	timestamp
updated_at	timestamp

genres

key	type	memo
name	string
value	string

tags

key	type	memo
name	string
value	string
parent	string
parent_name	string
trend	boolean

stances

key	type	memo
name	string
value	string

areas

key	type	memo
name	string
value	string