UMC

Tables (6)

food (foodInfo)

  • PK (food_id) — NotNull — Primary key — NOT NULL
  • FK (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
  • (food_name) — NotNull
  • (food_pay) — NotNull

foodCategory (categoryInfo)

  • PK (category_Id) — NotNull — Primary key — NOT NULL
  • FK (user_id) — NotNull — Foreign key → user.PK — NOT NULL
  • FK (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
  • (category_name) — NotNull

mission (missionInfo)

  • PK (mission_id) — NotNull — Primary key — NOT NULL
  • Fk (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
  • FK (user_id) — NotNull — Foreign key → user.PK — NOT NULL
  • (mission_point) — NotNull
  • (mission_more_than_pay) — NotNull
  • (mission_date) — NotNull

restaurant (restaurantInfo)

  • PK (restaurant_id) — NotNull — Primary key — NOT NULL
  • (restaurant_name) — NotNull
  • (retaurant_address) — NotNull
  • (restaureant_food_category) — NotNull
  • (restaurant_food_list) — NotNull
  • (restaurant_operation) — NotNull

review (reviewInfo)

  • PK (review_id) — NotNull — Primary key — NOT NULL
  • FK (user_id) — NotNull — Foreign key → user.PK — NOT NULL
  • FK (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
  • (review_star) — NotNull
  • (review_content) — NotNull

user (userInfo)

  • PK (user_id) — NotNull — Primary key — NOT NULL
  • (user_name) — NotNull
  • (user_gender) — NotNull
  • (user_birth) — NotNull
  • (user_address) — NotNull
  • (user_marketing) — NotNull
  • (user_location) — NotNull
  • (user_mission_count) — NotNull
  • (user_favorite_category) — Null
  • (user_nickname) — NotNull