UMC-Mission

Tables (8)

food_categories (선호 음식 카테고리)

  • id — Primary key — NOT NULL
  • name
  • Field

inquiries

  • id — Primary key — NOT NULL
  • id (id2) — Foreign key → stores.id — NOT NULL
  • title
  • content
  • image
  • type

missions

  • Key — Primary key — NOT NULL
  • id — Foreign key → stores.id — NOT NULL
  • id (id2) — Foreign key → users.id — NOT NULL
  • goal
  • reward
  • state (status)
  • time_limit

review_images

  • id — Primary key — NOT NULL
  • store_id — Foreign key → reviews.id — NOT NULL
  • user_id — Foreign key → reviews.store_id — NOT NULL
  • review_id — Foreign key → reviews.user_id — NOT NULL
  • image_url

reviews

  • id — Primary key — NOT NULL
  • store_id — Foreign key → stores.id — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • content
  • rate

stores

  • id — Primary key — NOT NULL
  • name
  • address
  • state

user_prefer_food (선호 음식)

  • id — Primary key — NOT NULL
  • user_Id (user_id) — Foreign key → users.id — NOT NULL
  • food
  • category_id — Foreign key → food_categories.id — NOT NULL

users

  • id — Primary key — NOT NULL
  • name
  • gender
  • birth
  • address
  • email
  • point
  • phone_number