UMC 1th assignment

Tables (9)

food_category (음식 종류)

  • id (음식종류ID) — UUID — Primary key — NOT NULL
  • name (이름) — VARCHAR(10)

mission (미션)

  • id (미션ID) — UUID — Primary key — NOT NULL
  • restaurant_id (식당ID) — UUID — Foreign key → restaurant.id — NOT NULL
  • description (미션 설명) — VARCHAR(100)
  • min_cost (미션달성금액) — INT
  • reward_points (적립포인트) — INT
  • deadline (미션기한) — DATETIME

restaurant (식당)

  • id (식당ID) — UUID — Primary key — NOT NULL
  • name (식당명) — VARCHAR(20)
  • food_category_id (음식종류ID) — UUID — Foreign key → food_category.id — NOT NULL
  • owner_number (사장구분번호) — VARCHAR(10)
  • longitude (위도) — DECIMAL(9,6)
  • latitude (경도) — DECIMAL(9,6)
  • region (지역) — VARCHAR(20)

review (리뷰)

  • id (리뷰ID) — UUID — Primary key — NOT NULL
  • rating (평점) — DECIMAL(2,1)
  • content (내용) — TEXT
  • created_at (작성일시) — DATETIME
  • user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
  • restaurant_id (식당ID) — UUID — Foreign key → restaurant.id — NOT NULL

review_image (리뷰 사진)

  • id (Key) — UUID — Primary key — NOT NULL
  • image_url (사진URL) — VARCHAR(255)
  • review_id (리뷰ID) — UUID — Foreign key → review.id — NOT NULL

social_account (소셜계정)

  • id (소셜ID) — UUID — Primary key — NOT NULL
  • user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
  • provider (제공자) — ENUM

user (유저)

  • id (유저ID) — UUID — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255)
  • name (이름) — VARCHAR(50)
  • age (나이) — INT
  • gender (성별) — ENUM(M,F,E)
  • address (주소) — VARCHAR(100)
  • birth_date (생년월일) — DATE
  • deleted_at (탈퇴일시) — DATETIME

user_mission (유저 미션 관계)

  • id (Key) — UUID — Primary key — NOT NULL
  • success_status (성공여부) — Boolean
  • user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
  • mission_id (미션ID) — UUID — Foreign key → mission.id — NOT NULL

user_preferred_food_kind (사용자 선호 음식 종류)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
  • category_id (음식종류ID) — UUID — Foreign key → food_category.id — NOT NULL