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)