Week1

Tables (19)

address (주소)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • 시/도 (city) — varchar(10)
  • 동 (town) — varchar(10)

inquiry (문의)

  • Key — bigint — Primary key — NOT NULL
  • Key (id) — bigint — Foreign key → member.Key — NOT NULL
  • Field (title) — varchar(20)
  • Field (detail) — text

member (유저)

  • Key (id) — bigint — Primary key — NOT NULL
  • 유저명 (name) — varchar(15)
  • 닉네임 (nickname) — varchar(15)
  • 성별 (gender) — varchar(15)
  • 생년월일 (birth) — varchar(8)
  • 생성일 (created_at) — datetime(6)
  • 업뎃일 (updated_at) — datetime(6)
  • 비활성화일 (deactive_at) — datetime(6)
  • 유저상태 (status) — enum
  • 이메일 (email) — varchar(20)
  • 계정타입 (account_type) — varchar(10)
  • 전화번호 (phoneNum) — varchar(13)

member_mission (유저 미션)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → mission.Key — NOT NULL
  • Key (id2) — bigint — Foreign key → mission.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → mission.Key — NOT NULL
  • Field (status) — varchar(10)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

member_point (유저가 보유한 포인트)

  • Key (point_id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Key (missionPoint_id) — bigint — Foreign key → mission_point.Key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → mission_point.Key — NOT NULL
  • Key (id2) — bigint — Foreign key → mission_point.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → mission_point.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

member_policy (유저 정책 동의)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Key (policy_id) — bigint — Foreign key → policy.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

member_preference (유저 선호도)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (preference_id) — bigint — Foreign key → preferences.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

member_setting (유저별 세팅값)

  • Key — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Key (Key2) — bigint — Foreign key → setting.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

mission (미션)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → store.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → store.Key — NOT NULL
  • 미션이름 (title) — varchar(20)
  • 미션상세 (body) — text
  • 미션보상 (reward) — varchar(20)
  • 미션생성일 (created_at) — datetime(6)
  • 미션업뎃일 (updated_at) — datetime(6)

mission_point (미션당 부여된 포인트)

  • Key (missionPoint_id) — bigint — Primary key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → mission.Key — NOT NULL
  • Key (id2) — bigint — Foreign key → mission.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → mission.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

new_mission (새로운 미션 알림)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (notification_id) — bigint — Foreign key → notification.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → notification.Key — NOT NULL
  • Field (title) — varchar(20)
  • Field (body) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

notification (알림)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Field (is_confirmed) — boolean
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

policy (정책)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(40)
  • Field (details) — text
  • 필수 (essential) — boolean
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

preferences (선호도)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

region (지역)

  • Key — bigint — Primary key — NOT NULL
  • 시/도 (state) — varchar(20)
  • 시/군/구 (city) — varchar(20)
  • 동/읍/면 (town) — varchar(20)
  • 도로명주소 (address_road) — varchar(20)
  • 위도 (latitude) — decimal
  • 경도 (longitude) — decimal
  • Field (created_at) — datetime(6)
  • Field4 (updated_at) — datetime(6)

request_review (리뷰 요청 알림)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (notification_id) — bigint — Foreign key → notification.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → notification.Key — NOT NULL
  • Field (title) — varchar(20)
  • Field (body) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

review (리뷰)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Key (store_id) — bigint — Foreign key → store.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → store.Key — NOT NULL
  • Field (rate) — int
  • Field (description) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

setting (세팅)

  • Key — bigint — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Field (status) — boolean
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

store (가게 관련)

  • Key (store_id) — bigint — Primary key — NOT NULL
  • Key (region_id) — bigint — Foreign key → region.Key — NOT NULL
  • Field (name) — varchar(20)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)