UMC
Tables (11)
alarm (10)
- id (alarm_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → user.id — NOT NULL
- mission_received (alarm_mission)
- review_received (alarm_review)
- inquiry_received (alarm_inquiry)
category (3)
- id (category_id) — Primary key — NOT NULL
- name (category_name)
inquriy (11)
- id (imquriy_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → user.id — NOT NULL
- title (inquiry_title)
- content (inquiry_content)
- picture (inquiry_picture)
map (6)
- id (map_id) — Primary key — NOT NULL
- spot (map_spot)
menu (5)
- id (menu_id) — Primary key — NOT NULL
- id (restaurant_id) — Foreign key → restaurant.id — NOT NULL
- id (category_id) — Foreign key → restaurant.id — NOT NULL
- id (map_id) — Foreign key → restaurant.id — NOT NULL
- name (menu_name)
- picture (menu_picture)
- price (menu_price)
mission (8)
- id (mission_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → user.id — NOT NULL
- id (restaurant_id) — Foreign key → restaurant.id — NOT NULL
- id (category_id) — Foreign key → restaurant.id — NOT NULL
- id (map_id) — Foreign key → restaurant.id — NOT NULL
- title (mission_title)
- content (mission_content)
- status (mission_status)
- benefit (mission_benefit)
order (9)
- id (order_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → user.id — NOT NULL
- id (restaurant_id) — Foreign key → restaurant.id — NOT NULL
- id (category_id) — Foreign key → restaurant.id — NOT NULL
- id (map_id) — Foreign key → restaurant.id — NOT NULL
restaurant (4)
- id (restaurant_id) — Primary key — NOT NULL
- id (category_id) — Foreign key → category.id — NOT NULL
- id (map_id) — Foreign key → map.id — NOT NULL
- name (restaurant_name)
- closed (restaurant_closed)
- location (restaurant_location)
review (7)
- id (review_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → user.id — NOT NULL
- id (restaurant_id) — Foreign key → restaurant.id — NOT NULL
- id (category_id) — Foreign key → restaurant.id — NOT NULL
- id (map_id) — Foreign key → restaurant.id — NOT NULL
- title (review_title)
- content (review_content)
- grade (review_grade)
- picture (review_picture)
user (1)
- id (user_id) — Primary key — NOT NULL
- name (user_name)
- gender (user_gender)
- birth (user_birth)
- address (user_address)
- favorite_food (user_food)
- point (user_point)
user_category (2)
- id (user_category_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → user.id — NOT NULL
- id (category_id) — Foreign key → category.id — NOT NULL