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