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