Recommend Lunch

Tables (5)

Member (Untitled3)

  • id (MemberKey) — int — Primary key — NOT NULL
  • phone (Field) — string
  • name (Field2) — string
  • email (Field3) — string
  • password (Field4) — string

Menu (Untitled4)

  • id (MenuKey) — int — Primary key — NOT NULL
  • Id (RestaurantKey) — int — Foreign key → Restaurant.Id — NOT NULL
  • name (Field) — string
  • price (Field2) — int
  • orderable (Field3) — boolean

Order (Untitled2)

  • Id (OrderKey) — int — Primary key — NOT NULL
  • Id (restaurant_id) — int — Foreign key → Restaurant.Id — NOT NULL
  • id (member_id) — int — Foreign key → Member.id — NOT NULL
  • OrderMenu (MenuKey2) — list OrderMenu — Foreign key → OrderMenu.id — NOT NULL
  • status (Field) — enum
  • personCount (Field2) — int

OrderMenu (Untitled5)

  • id (MenuKey) — int — Foreign key → Menu.id — NOT NULL
  • count (Field) — int

Restaurant (Untitled)

  • Id (RestaurantKey) — int — Primary key — NOT NULL
  • name (RestaurantName) — String
  • orderable (Field2)
  • naverId (Field) — String