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