POZIT

Tables (17)

course_spots

  • id — BIGSERIAL — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • tourist_spot_id — BIGINT — Foreign key → tourist_spots.id — NOT NULL
  • order_index — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — NOT_VISITED | VISITING | VISITED

courses

  • id — BIGSERIAL — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → travels.id — NOT NULL
  • day_number — INT — NOT NULL
  • date — DATE — NOT NULL
  • version — BIGINT — 낙관적 락

feedbacks

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → members.id — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

likes

  • id — BIGSERIAL — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → travels.id — NOT NULL
  • user_id — BIGINT — Foreign key → members.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

members

  • id — BIGSERIAL — Primary key — NOT NULL
  • provider — VARCHAR(255) — NOT NULL — KAKAO | APPLE
  • social_id — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(255) — UNIQUE
  • role — VARCHAR(255) — NOT NULL — USER | ADMIN
  • status — VARCHAR(30) — NOT NULL — ACTIVE | WITHDRAWN
  • push_enabled — BOOLEAN — NOT NULL
  • noti_travel_enabled — BOOLEAN — NOT NULL
  • noti_group_enabled — BOOLEAN — NOT NULL
  • noti_pozing_enabled — BOOLEAN — NOT NULL
  • noti_course_enabled — BOOLEAN — NOT NULL
  • noti_notice_enabled — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMP — 탈퇴 시각 (소프트 삭제)

notifications

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → members.id — NOT NULL
  • travel_id — BIGINT — Foreign key → travels.id — NOTICE 등 여행 무관 알림은 NULL
  • type — VARCHAR(20) — NOT NULL — TRAVEL_START | TRAVEL_LOG | COURSE | NOTICE | TIMELAPSE | TRAVEL_JOIN
  • content — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

pozing_edit_jobs

  • id — BIGSERIAL — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → travels.id — NOT NULL
  • request_user_id — BIGINT — Foreign key → members.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL — QUEUED | PROCESSING | COMPLETED | FAILED | EXPIRED | DELETED | DELETE_FAILED
  • result_s3_key — VARCHAR(255)
  • error_message — VARCHAR(1000)
  • retry_count — INT — NOT NULL
  • cleanup_retry_count — INT — NOT NULL
  • cleanup_last_attempt_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • expires_at — TIMESTAMP — 결과물 만료 시각

pozings

  • id — BIGSERIAL — Primary key — NOT NULL
  • course_spot_id — BIGINT — Foreign key → course_spots.id — NOT NULL
  • user_id — BIGINT — Foreign key → members.id — NOT NULL
  • pozing_object_key — VARCHAR(255) — NOT NULL — S3 오브젝트 키 (URL 아님)
  • thumbnail_object_key — VARCHAR(255)
  • thumbnail_status — VARCHAR(255) — PENDING | COMPLETED | FAILED
  • created_at — TIMESTAMP — NOT NULL

regions

  • code — VARCHAR(5) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • parent_code — VARCHAR(5) — Foreign key → regions.code — 상위 지역 (자기참조)

tags

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(20) — NOT NULL

term_agreements

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → members.id — NOT NULL
  • term_type — VARCHAR(30) — NOT NULL
  • agreed — BOOLEAN — NOT NULL
  • agreed_version — VARCHAR(255)
  • agreed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

terms

  • id — BIGSERIAL — Primary key — NOT NULL
  • type — VARCHAR(255) — NOT NULL — SERVICE | PRIVACY | LOCATION | AGE_OVER_14
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • version — VARCHAR(255) — NOT NULL
  • effective_date — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

timelapse_manifests

  • id — BIGSERIAL — Primary key — NOT NULL
  • pozing_edit_jobs_id — BIGSERIAL — Foreign key → pozing_edit_jobs.id — NOT NULL
  • travel_id — BIGINT — Foreign key → travels.id — NOT NULL
  • manifest_version — INT — NOT NULL
  • manifest_json — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tourist_spots

  • id — BIGSERIAL — Primary key — NOT NULL
  • content_id — VARCHAR(50) — NOT NULL — TourAPI contentid, UNIQUE
  • content_type_id — VARCHAR(10)
  • name — VARCHAR(255) — NOT NULL
  • legal_dong_region_code — VARCHAR(10)
  • legal_dong_sigungu_code — VARCHAR(10)
  • address — VARCHAR(500)
  • latitude — DECIMAL(10, 7) — mapy
  • longitude — DECIMAL(11, 7) — mapx
  • image_url — VARCHAR(555) — firstimage
  • region_id — VARCHAR(5) — Foreign key → regions.code — regions.code 참조

travel_members

  • id — BIGSERIAL — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → travels.id — NOT NULL
  • user_id — BIGINT — Foreign key → members.id — NOT NULL
  • role — VARCHAR(10) — NOT NULL — LEADER | MEMBER
  • joined_at — TIMESTAMP — NOT NULL

travel_tags

  • id — BIGSERIAL — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → travels.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tags.id — NOT NULL

travels

  • id — BIGSERIAL — Primary key — NOT NULL
  • leader_id — BIGINT — Foreign key → members.id
  • title — VARCHAR(50) — NOT NULL
  • destination — VARCHAR(30) — NOT NULL
  • region_code — VARCHAR(255) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — VARCHAR(15) — NOT NULL — BEFORE | IN_PROGRESS | DONE
  • transportation — VARCHAR(255) — CAR | WALK | PUBLIC
  • travel_style — VARCHAR(255) — RELAXED | NORMAL | TIGHT
  • is_public — BOOLEAN — NOT NULL
  • invite_code — VARCHAR(5) — UNIQUE
  • background_image_url — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL