テーブルスキーマ一覧

[t4t5u0]

• user_table
• daily_mission_table
• weekly_mission_table
• daily_history_table
• weekly_history_table
• all_history_table
• region_table

[t4t5u0]

user_table

name	type
id	int
name	str
mail	str
region	int -> region_id
has_car	bool
has_aircon	bool
has_tv	bool
total_point	int

daily_mission_table

name	type
id	int
name	str
content	str
tag_id	int -> tag_table
point	int

weekly_mission_table

name	type
id	int
name	str
content	str
tag_id	int -> tag_table
point	int

daily_history_table

name	type
id	int
complete_date	datetime
user_id	int
mission_id	int

weekly_history_table

name	type
id	int
complete_date	datetime
user_id	int
mission_id	int

all_history_table

name	type
id	int
complete_date	datetime
user_id	int
mission_category	str
mission_id	int

region_table

name	type
region_id	int
name	str

tag_table

name	type
tag_id	int
tag	str