HSD

Tables (5)

CATEGORY (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)

  • category_id (Key) — Primary key — NOT NULL
  • title (Field)
  • level (Field2)
  • parent (Field3)

MENU (CopyOfUntitled)

  • menu_id (Key) — Primary key — NOT NULL
  • category_id (Key2) — Foreign key → CATEGORY.category_id — NOT NULL
  • name (Field)
  • description (Field2)
  • img_url (Field3)
  • price (Field4)
  • calorie (Field5)

MENU_OPTION (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled)

  • menu_option_id (Key) — Primary key — NOT NULL
  • option_id (Key2) — Foreign key → OPTION.option_id — NOT NULL
  • menu_id (Key3) — Foreign key → MENU.menu_id — NOT NULL

OPTION (CopyOfCopyOfCopyOfCopyOfUntitled)

  • option_id (Key) — Primary key — NOT NULL
  • option_name (Field)
  • price (Field2)

USER (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • id (Field)
  • pw (Field2)
  • email (Field3)
  • phone (Field4)