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