fish

Tables (4)

Store (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • name (Field)
  • address (Field2)
  • startTime (Field3)
  • deleteTime (Field4)

User (Untitled)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • pw (Field2)
  • name (Field3)
  • nickname (Field4)
  • profileIcon (Field5)

menu (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • store_id (Key2) — Foreign key → Store.id — NOT NULL
  • menuName (Field)
  • price (Field2)

review (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Store.id — NOT NULL
  • store_id (Key3) — Foreign key → User.id — NOT NULL
  • star (Field)