week1

mission

Tables (5)

Food Category (food_category)

  • PK (id) — biting — Primary key — NOT NULL
  • category name (category_name) — varchar(10)

Mission (mission)

  • PK (id) — bigint — Primary key — NOT NULL
  • 가게이름 (store_name) — varchar(20)
  • 미션 포인트 (mission_point) — int
  • 적립 퍼센트 (mission_percent) — float
  • 진행상태 (status) — varchar(10)
  • 미션 시작 날짜 (start_date) — DATE
  • 미션 종료 날짜 (end_date) — DATE

Mission_User (mission_user)

  • PK (id) — bigint — Primary key — NOT NULL
  • FK (Key) — bigint — Primary key — NOT NULL
  • FK (mission_id) — bigint — Primary key — NOT NULL
  • PK (id2) — bigint — Foreign key → Mission.PK — NOT NULL
  • UserId (id3) — bigint — Foreign key → User.UserId — NOT NULL

User

  • UserId (id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar(10)
  • 성별 (gender) — ENUM('남자', ''여자', ''선택 안 함')
  • 생년원일 (birth) — DATE
  • 주소 (address) — text
  • 위치정보동의 (location_consent) — boolean
  • 마케팅 동의 (marketing_consent) — boolean
  • 생성일시 (created_at) — datetime(6)
  • 수정일시 (updated_at) — datetime(6)
  • status — varcher(15)
  • 비활성화시기 (inactive_date) — datetime(6)

User Preference (user_preference)

  • FK (user_id) — bigint — Primary key — NOT NULL
  • PK (id) — biting — Primary key — NOT NULL
  • FK (category_id) — bigint — Primary key — NOT NULL
  • UserId (id2) — bigint — Foreign key → User.UserId — NOT NULL
  • PK (id3) — biting — Foreign key → Food Category.PK — NOT NULL