dreamteam-2
Tables (12)
BASIC_QUESTION_RESPONSE
- response_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id
- round_no — INT
- 응답 — VARCHAR(100)
- answered_at — DATETIME
COUNTRY_STAMP
- country_code — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- country_name — VARCHAR(50)
MCM_PRODUCT
- tag_id — VARCHAR(100) — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id
- product_type — ENUM
- product_name — VARCHAR(100)
- registered_at — DATETIME
- 태그 — 횟수`
PHOTO
- photo_id — INT — Primary key — NOT NULL
- pin_id — INT — Foreign key → PIN.pin_id
- captured_at — DATETIME
- 위도 — DECIMAL(10,6)
- 경도 — DECIMAL(10,6)
- source_type — VARCHAR(30)
- 사진 — 경로`
- 핀의 — 대표사진
PHOTOBOOK
- photobook_id — INT — Primary key — NOT NULL
- segment_id — INT — Foreign key → TRAVEL_SEGMENT.segment_id — NOT NULL
- 포토북 — 이름`
- generated_at — DATETIME
PIN
- pin_id — INT — Primary key — NOT NULL
- photobook_id — INT — Foreign key → PHOTOBOOK.photobook_id
- segment_id — INT — Foreign key → TRAVEL_SEGMENT.segment_id — NOT NULL
- 위도 — DECIMAL(10,6)
- 경도 — DECIMAL(10,6)
- place_name — VARCHAR(150)
- 태깅시간 — DATETIME
- text_note — VARCHAR(500)
- saved_at — DATETIME
- 도시 — STRING
SELECTION_PHOTO
- 사진 — 아이디` — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id
- round_no — INT
- 상태 — BOOLEAN
- selected_at — DATETIME
TASTE_PROFILE
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- last_updated_at — DATETIME
- taste — Text
TASTE_PROFILE_AXIS
- axis_code — VARCHAR(50) — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- value — INT
- 상태 — ENUM
TRAVEL_SEGMENT
- segment_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id
- name — VARCHAR(100)
- start_at — DATETIME
- end_at — DATETIME
- status — BOOLEAN
- 대표사진 — String
USER
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(150)
- created_at — DATETIME
- onboarding_completed — BOOLEAN
- permission_intro_shown — BOOLEAN
- 계정 — 식별자`
VOICE_MEMO
- voice_memo_id — INT — Primary key — NOT NULL
- pin_id — INT — Foreign key → PIN.pin_id — NOT NULL
- 음성 — 파일`
- saved_at — DATETIME