밀헬퍼

테이블 (6)

food (Untitled2)

  • id (PK) — int — 기본 키 — NOT NULL
  • id (Key) — int — 외래 키 → menu.id — NOT NULL
  • name (Field) — String
  • calorie (Field2) — int

meal (Untitled)

  • id (PK) — int — 기본 키 — NOT NULL
  • name (Field) — String
  • morning (Field2) — String
  • lunch (Field3) — String
  • dinner (Field4) — String
  • snack1 (Field5) — String
  • snack2 (Field7) — String
  • calorie (Field6) — int
  • gender (Field8) — Enum
  • purpose (Field9) — Enum

meal_menu_dinner (CopyOfCopyOfUntitled4)

  • menu_id (Key) — int — 외래 키 → menu.id — NOT NULL
  • meal_id (PK) — int — 외래 키 → meal.id — NOT NULL

meal_menu_lunch (CopyOfUntitled4)

  • menu_id (Key) — int — 외래 키 → menu.id — NOT NULL
  • meal_id (PK) — int — 외래 키 → meal.id — NOT NULL

meal_menu_morning (Untitled4)

  • menu_id (Key) — int — 외래 키 → menu.id — NOT NULL
  • meal_id (PK) — int — 외래 키 → meal.id — NOT NULL

menu (Untitled3)

  • id (Key) — int — 기본 키 — NOT NULL
  • food1 (Field) — String
  • food2 (Field2) — String
  • food3 (Field3) — String
  • food4 (Field4) — String
  • food5 (Field5) — String
  • food6 (Field7)
  • calorie (Field6) — int