fodmap

Tables (3)

Food (음식)

  • id (Key) — Long — Primary key — NOT NULL
  • ingredient_id (fk) — Long — Foreign key → Ingredient.id — NOT NULL
  • name (이름) — String
  • category (Field2) — Enum

Ingredient (식재료)

  • id — Long — Primary key — NOT NULL
  • category_id (fk) — Long — Foreign key → major_category.id — NOT NULL
  • name (이름) — String
  • english_name (영문명) — String
  • fodmap (Field) — Int
  • property (특징) — String

major_category (Untitled)

  • id — Long — Primary key — NOT NULL
  • name (이름) — String