DB設計する

[iamsmith06]

Table設計

• Users

Name	Type	Description
id	int	primarykey(auto increment)
name	string
permission	int
email	string
created_at	date
updated_at	date
deleted_at	date

• Events

Name	Type	Description
id	int	primarykey(auto increment)
name	string
start	date
end	date
description	string
is_anonymous	boolean
created_at	date
updated_at	date
deleted_at	date

• EventItems

Name	Type	Description
id	int	primarykey(auto increment)
name	string
description	string
seats	int	numnber of winning people
max_choice	int
min_choice	int
event_id	int	foreign key restriction

• Candidates

Name	Type	Description
id	int	primarykey(auto increment)
event_item_id	int	foreign key restriction
user_id	int	foreign key restriction
description	string

• Votes

Name	Type	Description
id	int	primarykey(auto increment)
event_id	int	foreign key restriction
user_id	int	foreign key restriction
created_at	date

• VoteItems

Name	Type	Description
id	int	primarykey(auto increment)
vote_id	int	foreign key restriction
candidate_id	int	foreign key restriction

[conhumi]

https://github.com/sato-mh/savoten/wiki

に記述したのでクローズします。