informationSystemIntroduce
Tables (6)
FavoriteFoods (Untitled3)
- (Key) — Primary key — NOT NULL
- food_id (Key2) — bigint — Foreign key → foods.food_id — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- user_id (user_id2) — bigint — Foreign key → foods.user_id — NOT NULL
- created_at (Field)
MealPlans (Untitled4)
- plan_id (Key) — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- food_id (Key2) — bigint — Foreign key → foods.food_id — NOT NULL
- user_id (user_id2) — bigint — Foreign key → foods.user_id — NOT NULL
- meal_type (Field) — enum
- status (Field2) — enum
- plan_date (Field3) — date
MealRecords (Untitled5)
- recoed_id (Key2) — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- food_id (Key) — bigint — Foreign key → foods.food_id — NOT NULL
- user_id (user_id2) — bigint — Foreign key → foods.user_id — NOT NULL
- record_id (Field) — bigint
- calories (Field3) — int
- protein (Field4) — int
- fat (Field5) — int
- meal_type (Field6) — enum
- ate_at (Field7) — datetime
- image_url (Field8) — vatchar
UserProfiles (Users)
- user_profile_id (Key) — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- gender (Field) — enum
- birthdate (Field2) — date
- height (Field3) — float
- weight (Field4) — float
- body_fat_percentage (Field5) — float
- skeletal_muscle_mass (Field6) — float
- app_purpose (Field7) — enum
- goal_state_date (Field8) — date
- goal_end_date (Field9) — date
- target_calories (Field10) — int
foods (Untitled)
- food_id (Key) — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- name (Field) — varchar
- calories (Field2) — int
- protein (Field3) — int
- carbs (Field4) — int
- fat (Field5) — int
- image_url (Field6) — varchar
- usage_count (Field7) — int
- is_custom (Field8) — boolean
- created_at (Field9) — datetime(6)
- updated_at (Field10) — datetime(6)
users (Untitled2)
- user_id — bigint — Primary key — NOT NULL
- email — varchar
- nickname — varchar
- password ([assword) — varchar
- created_a — datetime(6)