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