sogong

Tables (6)

comments (Untitled4)

  • comment_id (PK) — INTEGER — Primary key — NOT NULL
  • post_id (PK2) — INTEGER — Foreign key → posts.post_id — NOT NULL
  • content (Field) — TEXT

meals (Untitled5)

  • meal_id (PK) — INTEGER — Primary key — NOT NULL
  • user_id (FK) — INTEGER — Foreign key → users.user_id — NOT NULL
  • dateTime (Field) — datetime
  • photo_path (Field2) — STRING

nutrients (Untitled6)

  • nutrient_id (PK) — INTEGER — Primary key — NOT NULL
  • meal_id (PK2) — INTEGER — Foreign key → meals.meal_id — NOT NULL
  • user_id (FK) — INTEGER — Foreign key → meals.user_id — NOT NULL
  • calories (Field) — FLOAT
  • protein (Field2) — FLOAT

posts (Untitled3)

  • post_id (PK) — INTEGER — Primary key — NOT NULL
  • user_id (PK2) — INTEGER — Foreign key → users.user_id — NOT NULL
  • likes (Field) — INTEGER
  • content (Field2) — TEXT

reminders (Untitled2)

  • reminder_id (PK) — INTEGER — Primary key — NOT NULL
  • user_id (PK2) — INTEGER — Foreign key → users.user_id — NOT NULL
  • type (Field) — ENUM
  • message (Field2) — TEXT

users (Untitled)

  • user_id (PK) — INTEGER — Primary key — NOT NULL
  • age (Field) — INTEGER