caujmtgr

Tables (4)

Restaurant

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • location (Field2)
  • type (Field3)
  • phone (Field4)
  • mainmenu (Field5)
  • Field6
  • closeTime (Field7)

Restaurant_picture

  • id (Key) — r_id — Foreign key → Restaurant.id — NOT NULL
  • Field — auto_increment
  • link (Field2)

User

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • passwd (Field3)

User_review

  • id (key1) — user id — Foreign key → Restaurant.id — NOT NULL
  • id (Key4) — restaurant id — Foreign key → User.id — NOT NULL
  • star (Field)
  • comment (Field2)
  • day (Field3)