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)