CAREVIEW

Tables (20)

ALLERGY (allergies)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR

ALLERGY (user_allergies)

  • id (KEY) — INT — Foreign key → USER.id
  • id (Key) — INT — Foreign key → ALLERGY.id — NOT NULL

CONVENIENCE (set_composition)

  • set_id (Key) — INT — Foreign key → CONVENIENCE.set_id — NOT NULL
  • item_id (Key2) — INT — Foreign key → CONVENIENCE.item_id — NOT NULL
  • amount (Field) — FLOAT
  • unit (Field2) — VARCHAR(50)

CONVENIENCE (convenience_items)

  • item_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • calorie (Field2) — FLOAT
  • carbs (Field3) — FLOAT
  • portein (Field4) — FLOAT
  • fat (Field5) — FLOAT

CONVENIENCE (recipe_sets)

  • set_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • set_type (Field2) — VARCHAR(50)
  • image_url (Field3) — VARCHAR(500)
  • total_colorie (Field4) — FLOAT
  • total_carbs (Field5) — FLOAT
  • total_protein (Field6) — FLOAT
  • total_fat (Field7) — FLOAT

EXERCISE (user_exercise_link)

  • link_id (Key) — INT — Primary key — NOT NULL
  • id (KEY) — INT — Foreign key → EXERCISE.id
  • exercise_id (Key2) — INT — Foreign key → EXERCISE.exercise_id — NOT NULL
  • colorie_kcal (Field) — INT
  • duration_min (Field2) — INT

EXERCISE (exercise_master)

  • exercise_id (Key) — INT — Primary key — NOT NULL
  • step_name (Field) — VARCHAR(50)
  • movement_name (Field2) — VARCHAR(100)

EXERCISE (user_master)

  • id (KEY) — INT — Foreign key → USER.id
  • age_group (Field) — VARCHAR(10)
  • bmi_grade (Field2) — VARCHAR(20)

ONBOARDING (onboarding_configs)

  • id (Key) — INT — Primary key — NOT NULL
  • id (KEY) — INT — Foreign key → USER.id
  • goal (Field) — VARCHAR(50)
  • weekly_workout_schedule (Field2) — TEXT
  • workouts_per_week (Field3) — INT
  • date_of_birth (Field4) — DATE
  • height_cm (Field5) — FLOAT
  • intensity_level (Field6) — DATE
  • current_weight_kg (Field7) — FLOAT
  • target_weight_kg (Field8) — FLOAT
  • job_type (Field9) — VARCHAR
  • activity_level (Field10) — VARCHAR
  • is_onboarding_complete (Field11) — BOOLEAN

RECIPE (ingredients)

  • ingredient_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)

RECIPE (recipe_composition)

  • reciep_id (Key) — INT — Foreign key → RECIPE.reciep_id — NOT NULL
  • item_id (Key2) — INT — Foreign key → RECIPE.item_id — NOT NULL
  • amount (Field) — FLOAT
  • unit (Field2) — VARCHAR(255)

RECIPE (item_ingredient)

  • item_id (Key) — INT — Foreign key → RECIPE.item_id — NOT NULL
  • ingredient_id (Key2) — INT — Foreign key → RECIPE.ingredient_id — NOT NULL
  • amount (Field) — FLOAT
  • unit (Field2) — VARCHAR(50)

RECIPE (recipe_allergen)

  • reciep_id (Key) — INT — Foreign key → RECIPE.reciep_id — NOT NULL
  • id (Key2) — INT — Foreign key → ALLERGY.id — NOT NULL

RECIPE (ingredient_allergen)

  • ingredient_id (Key) — INT — Foreign key → RECIPE.ingredient_id — NOT NULL
  • id (Key2) — INT — Foreign key → ALLERGY.id — NOT NULL

RECIPE (cooking_steps)

  • step_id (Key) — INT — Primary key — NOT NULL
  • item_id (Key2) — INT — Foreign key → RECIPE.item_id — NOT NULL
  • step_number (Field) — INT
  • step_description (Field2) — INT

RECIPE (meal_items)

  • item_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)

RECIPE (recipe_nutrition)

  • reciep_id (Key) — INT — Foreign key → RECIPE.reciep_id — NOT NULL
  • calories (Field) — FLOAT
  • carbohydrates (Field2) — FLOAT
  • protein (Field3) — FLOAT
  • fat (Field4) — FLOAT

RECIPE (recipes)

  • reciep_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • description (Field2) — TEXT
  • meal_type (Field3) — VARCHAR(255)
  • image_url (Field4) — VARCHAR(255)

RECORD (health_matrics)

  • id (Key) — INT — Primary key — NOT NULL
  • id (KEY) — INT — Foreign key → USER.id
  • weight_kg (Field) — FLOAT
  • bmi (Field2) — FLOAT
  • sleep_duration_hours (Field3) — FLOAT
  • exercise_duration_hours (Field4) — FLOAT
  • recorded_at (Field5) — DATETIME

USER (users)

  • id (KEY) — INT — Primary key
  • email (Filed) — VARCHAR(255)
  • hashed_password (Field2) — VARCHAR(255)
  • is_active (Field3) — BOOLEAN
  • full_name (Field4) — VARCHAR(255)