https://dbdiagram.io/d/5d330720ced98361d6dcd76e



Enum exercise_types {
  ruecken
  brust
  ausdauer
 }

Enum workout_plan_types {
reps_and_sets
time_range
time_and_distance
time_and_weight
}

Enum amount_value{
  L
  essloeffel
  g
  teeloeffel
  prise
  stk
  //Weitere??
}

Enum training_goal_val{
  muskelaufbau
  fettabbau
  ausdauer
  allgemein
}

Enum meals {
  breakfast
  lunch
  dinner
  snack
  pre_workout
  post_workout
}

Table users
{
	id varchar [pk] //uuid
	email varchar //?
	sms varchar //?
	password varchar //(hash)?
	register_date date
//
//PASSWORT RESET??
  last_login datetime
  pw_reset_code varchar
  review_count int
}

Table instagram_connection
{
	fk_user_id varchar [ref: > users.id] //uuid
	instagram_id int [pk]
	instagram_name varchar
	follower int
	profilepic varchar //(link)
//##
  instagram_access_token varchar
  instagram_full_name varchar
}

Table purchase{
  id varchar //enum
  fk_user_id varchar [pk, ref: > users.id] //uuid
  purchase_date Date [default: `now()`]
}

Table user_workout_plan_purchase
{
	fk_purchase_id varchar [pk, ref: > purchase.id] //uuid
	fk_workout_plan_id varchar [pk, ref: > workout_plan.id] //uuid

  //##
  //MoreDetails??
}

Table user_nutrition_plan_purchase
{
	fk_purchase_id varchar [pk, ref: > purchase.id] //uuid
	fk_nutrition_plan_id varchar [pk, ref: > nutrition_plan.id] //uuid

  //##
  //MoreDetails??
}

Table workout_plan
{
	id varchar [pk]//uuid
	fk_user_id varchar [ref: > users.id] //uuid
	name  varchar
	description varchar
	create_date Date [default: `now()`]
	review_rating float
  review_reliability float [note: "how reliable is this review"]
  review_amount int
  level int
  goal training_goal_val //Enum

}

Table exercise
{
	id varchar [pk] //uuid
	fk_user_id varchar [ref: > users.id] //uuid
	name varchar
	description varchar
	image varchar //(link to our server)
	video varchar //(link)?
	type exercise_types //ENUM
	public bool //-> to discuss
}

Table workout_plan_exercise
{
	fk_workout_plan_id varchar [pk, ref: > workout_plan.id] //uuid
	fk_exercise_id varchar [pk, ref: > exercise.id] //uuid
	day int [pk]
	position int [pk]
	description varchar//?
	type workout_plan_types //ENUM
	properties JSON
	//JSON Data??
	//	sets_min int
	//	sets_max int
	//	rep_min int
	//	rep_max int
	//	weight float

	//	time_range int //(second)

	//	distance int
		//(pause_min: int)
		//(pause_max: int)
}

Table ingredient {
	id varchar [pk] //uuid
	fk_user_id varchar [ref: > users.id] //uuid
	name varchar
	description varchar
	nutrition_values JSON //alternative varchar
		//protein,
		//fat,
		//..

}

Table recipe
{

  id varchar [pk] //uuid
  fk_user_id varchar [ref: > users.id] //uuid
	description varchar
	cooking_time time
	instruction varchar [note: "JSON ARRAY with steps"]
	public bool

}

Table recipe_ingredients{
  fk_recipe_id varchar [pk, ref: > recipe.id] //uuid
  fk_ingredient_id varchar [pk, ref: > ingredient.id] //uuid
  ingredient_amount_value amount_value
  ingredient_amount int
}

//Mehrer Wochen??


Table nutrition_plan {
  id varchar [pk] //uuid
  fk_user_id varchar [ref: > users.id] //uuid
	name  varchar
	description varchar
	create_date Date [default: `now()`]
	review_rating float
  review_reliability float [note: "how reliable is this review"]
  review_amount int
}

Table nutrition_plan_recipe {
  fk_nutrition_plan  varchar [pk, ref: > nutrition_plan.id] //uuid
  fk_user_id varchar [pk, ref: > recipe.id] //uuid
  days int [note: "1-7"]
  meal meals //enum

}



Table workout_plan_user_review{
  //joinen
  fk_workout_plan varchar [pk, ref: > workout_plan.id] //uuid
  fk_user_id varchar [pk, ref: > users.id] //uuid
  comment varchar
  rating float
  reliability float [note: "how reliable is this review"]
}

Table nutrition_plan_user_review{
  //joinen
  fk_nutrition_plan varchar [pk, ref: > nutrition_plan.id] //uuid
  fk_user_id varchar [pk, ref: > users.id] //uuid
  rating float
  comment varchar
  reliability float [note: "how reliable is this review"]
}