RE:SET

Tables (13)

achievement (성취)

  • id (성취id) — bigint — Primary key — NOT NULL
  • type (타입) — varchar(50)
  • name (이름) — varchar(100)
  • description (설명) — varchar(255)
  • condition_type (조건타입) — varchar
  • condition_value (조건값) — int

achievement_missison (미션에 등록된 성취)

  • id (미션성취id) — bigint — Primary key — NOT NULL
  • mission_id (미션id) — bigint — Foreign key → mission.id — NOT NULL
  • achievement_id (성취id) — bigint — Foreign key → achievement.id — NOT NULL

emotion (감정)

  • id (감정id) — int — Primary key — NOT NULL
  • name (이름) — varchar
  • context (컨텍스트) — varchar
  • level (레벨) — int

mission (미션)

  • id (미션id) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(50)
  • goal (목표) — varchar(50)
  • instruction (지시) — varchar(255)
  • category (카테고리) — varchar
  • estimated_minute (추정시간(분)) — int
  • level (레벨) — int
  • room_type_id (방종류id) — int — Foreign key → room_type.id — NOT NULL

room_status (방상태)

  • id (방상태id) — int — Primary key — NOT NULL
  • name (이름) — varchar
  • level (레벨) — int

room_type (방종류)

  • id (방종류id) — int — Primary key — NOT NULL
  • name (이름) — varchar

user (유저)

  • id (유저id) — bigint — Primary key — NOT NULL
  • uuid (유저 UUID) — uuid — NOT NULL
  • device_id (디바이스id) — varchar(255)
  • nickname (닉네임) — varchar(50)
  • email (이메일) — varchar(255)
  • profile_image_url (프로필이미지URL) — varchar(255)
  • last_login_at (최근로그인일시) — datetime
  • login_type (로그인타입) — enum
  • timezone (타임존) — varchar
  • deleted_at (탈퇴일시) — datetime

user_achievement (유저성취)

  • id (유저성취id) — bigint — Primary key — NOT NULL
  • achievement_id (성취id) — bigint — Foreign key → achievement.id — NOT NULL
  • user_mission_id (유저미션id) — bigint — Foreign key → user_mission.id — NOT NULL

user_emotion_note (유저감정기록)

  • id (감정노트id) — bigint — Primary key — NOT NULL
  • note (노트) — varchar(255)
  • user_id (유저id) — bigint — Foreign key → user.id — NOT NULL
  • emotion_id (감정id) — int — Foreign key → emotion.id — NOT NULL

user_mission (유저미션-감정,방상태고려)

  • id (유저미션id) — bigint — Primary key — NOT NULL
  • message (메시지) — varchar(50)
  • status (상태) — enum
  • start_at (시작일시) — datetime
  • end_at (종료일시) — datetime
  • mission_id (미션id) — bigint — Foreign key → mission.id — NOT NULL
  • user_id (유저id) — bigint — Foreign key → user.id — NOT NULL
  • after_usser_emotion_note_id (이전유저감정기록id) — bigint — Foreign key → user_emotion_note.id — NOT NULL
  • before_user_emotion_note_id (이후유저감정기록id) — bigint — Foreign key → user_emotion_note.id — NOT NULL
  • user_room_note_id (유저방기록id) — bigint — Foreign key → user_room_note.id — NOT NULL

user_mission_photo (유저 미션 사진)

  • id (유저미션사진id) — bigint — Primary key — NOT NULL
  • photo_url (사진URL) — varchar(255)
  • type (사진타입) — enum
  • user_mission_id (유저미션id) — bigint — Foreign key → user_mission.id — NOT NULL

user_mission_report (유저 미션 리포트)

  • id (유저미션리포트id) — bigint — Primary key — NOT NULL
  • feedback (피드백) — text
  • user_mission_id (유저미션id) — bigint — Foreign key → user_mission.id — NOT NULL

user_room_note (유저방기록)

  • id (유저방노트id) — bigint — Primary key — NOT NULL
  • status (상태) — enum
  • user_id (유저id) — bigint — Foreign key → user.id — NOT NULL
  • room_type_id (방종류id) — int — Foreign key → room_type.id — NOT NULL
  • room_status_id (방상태id) — int — Foreign key → room_status.id — NOT NULL