UMC_9th

Tables (11)

food_category

  • food_category_id — BIGINT
  • name — VARCHAR(255)

member

  • member_id — BIGINT
  • name — VARCHAR(255)
  • gender — ENUM('MALE', 'FEMALE', 'NONE')
  • birth — DATE
  • detail_address — VARCHAR(255)
  • social_type — ENUM('KAKAO', 'NAVER', 'APPLE', 'GOOGLE')
  • social_uid — VARCHAR(255)
  • point — INT
  • email — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

member_agree

  • member_agree_id — BIGINT
  • member_id — BIGINT
  • term_id — BIGINT
  • is_agreed — BOOLEAN

member_mission

  • member_mission_id — BIGINT
  • member_id — BIGINT
  • mission_id — BIGINT
  • status — ENUM('CHALLENGING', 'COMPLETE')

member_prefer

  • member_prefer_id — BIGINT
  • member_id — BIGINT
  • food_category_id — BIGINT

mission

  • mission_id — BIGINT
  • store_id — BIGINT
  • name — VARCHAR(255)
  • content — VARCHAR(255)
  • reward — INT

region

  • region_id — BIGINT
  • name — VARCHAR(255)

review

  • review_id — BIGINT
  • store_id — BIGINT
  • member_id — BIGINT
  • content — TEXT
  • score — INT
  • created_at — DATETIME
  • updated_at — DATETIME

review_image

  • review_image_id — BIGINT
  • review_id — BIGINT
  • url — VARCHAR(255)

store

  • store_id — BIGINT
  • name — VARCHAR(255)
  • address — VARCHAR(255)
  • region_id — BIGINT
  • food_category_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

term

  • term_id — BIGINT
  • name — ENUM('AGE', 'SERVICE', 'PRIVACY', 'LOCATION', 'MARKETING')