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