erd

Tables (6)

Untitled (diet)

  • Key (diet_id) — bigint — Primary key — NOT NULL
  • Field (image) — varchar — NOT NULL
  • Field (mealtime) — varchar(16) — NOT NULL
  • Field (low_fodmap_count) — int
  • Field (high_fodmap_count) — int
  • Field (created_date) — timestamp — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (member)

  • Key (member_id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (sex) — varchar(16) — NOT NULL
  • Field (birthyear) — date — NOT NULL
  • Field (kakao_id) — bigint — NOT NULL

Untitled (defecation)

  • Key (defecation_id) — bigint — Primary key — NOT NULL
  • Field (form) — varchar(16) — NOT NULL
  • Field (urgency) — int — NOT NULL
  • Field (color) — varchar(16) — NOT NULL
  • Field (satisfaction) — int — NOT NULL
  • Field (duration) — int — NOT NULL
  • Field (score) — int
  • Field (created_date) — timestamp — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (meal)

  • Key (meal_id) — bigint — Primary key — NOT NULL
  • Field (meal_name) — varchar — NOT NULL
  • Field (is_low_fodmap) — tinyint — NOT NULL
  • Field (fructose) — float — NOT NULL
  • Field (sucrose) — float — NOT NULL
  • Field (lactose) — float — NOT NULL
  • Field (maltose) — float — NOT NULL
  • Field (fiber) — float — NOT NULL

Untitled (diet_meal)

  • Key (diet_meal_id) — bigint — Primary key — NOT NULL
  • Key (diet_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (meal_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (stress)

  • Key (stress_id) — bigint — Primary key — NOT NULL
  • Field (degree) — int — NOT NULL
  • Field (created_date) — timestamp — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL