mp

Tables (6)

facility (Untitled4)

  • facility_id — int — Primary key — NOT NULL
  • rest_area_id — int — Foreign key → rest_area.rest_area_id — NOT NULL
  • name — String
  • description — String

favorite (Untitled6)

  • favorite_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • rest_area_id — int — Foreign key → rest_area.rest_area_id — NOT NULL
  • description — String

food (Untitled3)

  • food_id — int — Primary key — NOT NULL
  • rest_area_id — int — Foreign key → rest_area.rest_area_id — NOT NULL
  • food_name — String
  • price — String
  • is_signature — String
  • description — String

rest_area (Untitled2)

  • rest_area_id — int — Primary key — NOT NULL
  • name — String
  • direction — String
  • code — String
  • tel — String
  • address — String
  • routeName — String
  • x_value (xValue) — String
  • y_value (yValue) — String

review (Untitled5)

  • review_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • rest_area_id — int — Foreign key → rest_area.rest_area_id — NOT NULL
  • rating — String
  • comment — String
  • created_at — Date

user (Untitled)

  • user_id — int — Primary key — NOT NULL
  • user_email — String
  • password — String
  • user_nickname — String
  • created_at — Date