pozit-demo
Tables (14)
course
- 코스ID (id) — BIGSERIAL — Primary key — NOT NULL
- 여행ID (travel_id) — BIGINT — Foreign key → travel.여행ID — NOT NULL
- 일차 (day_number) — INT — NOT NULL
- 날짜 (date) — DATE — NOT NULL
course_spot
- 코스장소ID (id) — BIGSERIAL — Primary key — NOT NULL
- 코스ID (course_id) — BIGINT — Foreign key → course.코스ID — NOT NULL
- 장소ID (tourist_spot_id) — BIGINT — Foreign key → tourist_spot.장소ID — NOT NULL
- 방문순서 (order_index) — INT — NOT NULL
- 방문상태 (status) — VARCHAR(20) — NOT NULL — 방문상태 (NOT_VISITED | VISITING | VISITED)
feedback (Untitled)
- 피드백ID (Key) — Primary key — NOT NULL
- 사용자ID (id) — BIGSERIAL — Foreign key → members.사용자ID — NOT NULL
- 피드백내용 (content)
- 생성일자 (created_at)
like (wish)
- 위시ID (id) — BIGSERIAL — Primary key — NOT NULL
- 사용자ID (user_id) — BIGINT — Foreign key → members.사용자ID — NOT NULL
- 여행ID (travel_id) — BIGINT — Foreign key → travel.여행ID — NOT NULL
- 생성일자] (created_at) — TIMESTAMP — NOT NULL
members (user)
- 사용자ID (id) — BIGSERIAL — Primary key — NOT NULL
- 닉네임 (nickname) — VARCHAR(30) — NOT NULL
- 소셜플랫폼 (social_provider) — VARCHAR(10) — NOT NULL — KAKAO | GOOGLE APPLE
- 소셜고유ID (social_id) — VARCHAR(100) — NOT NULL
- 이메일 (email) — VARCHAR(100) — 소셜로그인에서 받아오기
- 약관동의여부 (is_agreed_terms) — BOOLEAN — NOT NULL
- 푸시알림여부 (push_enabled) — BOOLEAN — NOT NULL
- 여행시작종료알림여부 (noti_travel_enabled) — BOOLEAN — NOT NULL
- 그룹활동알림여부 (noti_group_enabled) — BOOLEAN — NOT NULL
- Pozing등록알림여부 (noti_pozing_enabled) — BOOLEAN\ — NOT NULL
- 코스진행알림여부 (noti_course_enabled) — BOOLEAN — NOT NULL
- 공지이벤트알림여부 (noti_notice_enabled) — BOOLEAN — NOT NULL
- 상태 (status) — VARCHAR(20) — ACTIVE | INACTIVE
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
notification
- 알림ID (id) — BIGSERIAL — Primary key — NOT NULL
- 사용자ID (user_id) — BIGINT — Foreign key → members.사용자ID — NOT NULL
- 알림타입 (type) — VARCHAR(20) — NOT NULL — INVITE | TRAVEL_START | TRAVEL_END | POZING | COURSE | NOTICE
- 알람내용 (content) — VARCHAR(200) — NOT NULL
- 읽음여부 (is_read) — BOOLEAN — NOT NULL
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
pozing
- 포징ID (id) — BIGSERIAL — Primary key — NOT NULL
- 코스장소ID (course_spot_id) — BIGINT — Foreign key → course_spot.코스장소ID — NOT NULL
- 사용자ID (user_id) — BIGINT — Foreign key → members.사용자ID — NOT NULL
- 포징영상URL (pozing_url) — VARCHAR(255) — NOT NULL
- 썸네일URL (thumbnail_url) — VARCHAR(255)
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
tag
- 태그ID (id) — BIGSERIAL — Primary key — NOT NULL
- 태그명 (name) — VARCHAR(20) — NOT NULL
term (Untitled2)
- 약관ID (Key) — Primary key — NOT NULL
- 약관타입 (Field) — SERVICE | PRIVACY
- 약관제목 (Field2)
- 약관내용 (Field3)
- 약관버전 (Field4)
- 생성일자 (Field5)
tourist_spot
- 장소ID (id) — BIGSERIAL — Primary key — NOT NULL
- 콘텐츠ID (content_id) — VARCHAR(50) — NOT NULL — UNIQUE
- 콘텐츠타입ID (content_type_id) — VARCHAR(10)
- 장소명 (name) — VARCHAR(255) — NOT NULL
- 지역코드 (area_code) — VARCHAR(30)
- 시군구코드 (sigungu_code) — VARCHAR(30)
- 주소 (address) — VARCHAR(500)
- 위도 (latitude) — DECIMAL(10, 7) — mapy
- 경도 (longitude) — DECIMAL(11, 7) — mapx
- 이미지URL (image_url) — VARCHAR(555) — firstimage
travel
- 여행ID (id) — BIGSERIAL — Primary key — NOT NULL
- 팀장ID (leader_id) — BIGINT — Foreign key → members.사용자ID — NOT NULL
- 여행명 (title) — VARCHAR(50) — NOT NULL
- 여행지 (destination) — VARCHAR(30) — NOT NULL
- 시작일자 (start_date) — DATE — NOT NULL
- 종료일자 (end_date) — DATE — NOT NULL
- 상태 (status) — VARCHAR(15) — NOT NULL — 상태 (BEFORE | IN_PROGRESS | DONE)
- 공개여부' (is_public) — BOOLEAN — NOT NULL
- 초대코드 (invite_code) — VARCHAR(5) — UNIQUE
- 배경사진 (background_image_url) — VARCHAR(255)
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- Field
travel_member
- 여행멤버ID (id) — BIGSERIAL — Primary key — NOT NULL
- 여행ID (travel_id) — BIGINT — Foreign key → travel.여행ID — NOT NULL
- 사용자ID (user_id) — BIGINT — Foreign key → members.사용자ID — NOT NULL
- 역할 (role) — VARCHAR(10) — NOT NULL — 권한 (LEADER | MEMBER)
- 참여일자 (joined_at) — TIMESTAMP — NOT NULL
travel_tag
- 여행ID (travel_id) — BIGINT — Foreign key → travel.여행ID — NOT NULL
- 태그ID (tag_id) — BIGINT — Foreign key → tag.태그ID — NOT NULL
user_tag
- 사용자ID (user_id) — BIGINT — Foreign key → members.사용자ID — NOT NULL
- 태그ID (tag_id) — BIGINT — Foreign key → tag.태그ID — NOT NULL