pocketEats

Tables (4)

Restaurant (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • coverImage (Field3)
  • Owner (Key2) — Foreign key → User.id — NOT NULL
  • Category (Key3) — Foreign key → category.id — NOT NULL

User (Untitled)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • role (Field3)
  • verified (Field4)
  • resturants (Field5)

Verification (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • code (Field2)
  • User (Key2) — Foreign key → User.id — NOT NULL

category (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • coverImage (Field2)
  • restaurant (Field3)