restaurant

Tables (3)

restaurant (Untitled)

  • restaurant_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • address (Field2) — varchar
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

restaurant_menu (Untitled2)

  • restaurant_menu_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • price (Field2) — int
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • restaurant_id (Key2) — int — Foreign key → restaurant.restaurant_id — NOT NULL

review (Untitled3)

  • review_id (Key) — int — Primary key — NOT NULL
  • content (Field) — varchar
  • score (Field2) — double
  • created_at (Field3) — timestamp
  • Field4
  • restaurant_id (Key2) — int — Foreign key → restaurant.restaurant_id — NOT NULL