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