WithYou

Tables (15)

CLOUD (클라우드)

  • id (Key) — bigint — Primary key — NOT NULL
  • travel_id (여행id) — bigint — Foreign key → TRAVEL.id — NOT NULL
  • travelDate (여행날짜) — Date
  • createdAt (생성일시) — DateTime
  • updatedAt (수정일시) — DateTime
  • deactivatedAt (비활성화일시) — DateTime

CLOUD_PHOTO (클라우드 사진)

  • id (Key) — bigint — Primary key — NOT NULL
  • cloud_id (클라우드id) — bigint — Foreign key → CLOUD.id — NOT NULL
  • uploader_id (업로더id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • ImgUrl (이미지URL) — varchar
  • uploadedAt (업로드일시) — DateTIme

MEMBER (유저)

  • id (Key) — bigint — Primary key — NOT NULL
  • nickname (닉네임) — varchar
  • profileImgUrl (프로필이미지URL) — varchar
  • createdAt (생성일시) — DateTIme
  • updatedAt (수정일시) — DateTime
  • deactivatedAt (비활성화일시) — DateTime

MESSAGE (쪽지)

  • id (Key) — bigint — Primary key — NOT NULL
  • sender_id (송신인id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • addressee_id (수신인id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • message_id (메세지id) — bigint — Foreign key → MESSAGE.id — NOT NULL

POST (게시글)

  • id (Key) — bigint — Primary key — NOT NULL
  • travel_id (여행id) — bigint — Foreign key → TRAVEL.id — NOT NULL
  • writer_id (작성자id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • content (내용) — varchar
  • createdAt (생성일시) — DateTime
  • updatedAt (수정일시)

POST_COMMENT (게시글 댓글)

  • id (Key) — bigint — Primary key — NOT NULL
  • post_id (게시글id) — bigint — Foreign key → POST.id — NOT NULL
  • commenter_id (작성자id) — bigint — Foreign key → MEMBER.id — NOT NULL

POST_LIKE (게시글 좋아요)

  • id (Key) — bigint — Primary key — NOT NULL
  • post_id (게시글id) — bigint — Foreign key → POST.id — NOT NULL
  • liker_id (유저id) — bigint — Foreign key → MEMBER.id — NOT NULL

POST_PHOTO (게시글 사진)

  • id (Key) — bigint — Primary key — NOT NULL
  • post_id (게시글id) — bigint — Foreign key → POST.id — NOT NULL
  • ImgUrl (이미지URL) — varchar
  • Field

REWIND (회고)

  • id (Key) — bigint — Primary key — NOT NULL
  • travel_id (여행id) — bigint — Foreign key → TRAVEL.id — NOT NULL
  • travelDate (여행날짜) — Date
  • createdAt (생성일시) — DateTime
  • updatedAt (수정일시) — DateTime

REWIND_DLETTER (회고 오늘의 한마디)

  • id (Key) — bigint — Primary key — NOT NULL
  • rewind_id (회고id) — bigint — Foreign key → REWIND.id — NOT NULL
  • writer_id (작성자id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • target_id (수신자id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • content (한마디) — varchar

REWIND_MOOD (회고기분)

  • id (Key) — bigint — Primary key — NOT NULL
  • rewind_id (회고id) — bigint — Foreign key → REWIND.id — NOT NULL
  • writer_id (작성자id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • mood (기분) — varchar(ENUM)

REWIND_QNA (회고 Q&A)

  • id (Key) — bigint — Primary key — NOT NULL
  • rewind_id (회고id) — bigint — Foreign key → REWIND.id — NOT NULL
  • writer_id (작성자id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • question (질문 내용) — varchar(ENUM)
  • answer (질문 답변) — varchar

SNS (소셜로그인)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (유저id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • sns_id (소셜계정id) — varchar
  • sns_name (소셜계정이름) — varchar
  • sns_type (소셜로그인타입) — varchar(ENUM)
  • connectedAt (연동일시) — DateTime

TRAVEL (여행)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (여행제목) — varchar
  • status (여행 상태) — varchar(ENUM)
  • startDate (시작일) — Date
  • endDate (종료일) — Date
  • bannerImgUrl (배너이미지URL) — varchar
  • inviteCode (초대코드) — varchar(random&unique)

TRAVELER (여행자(들))

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (멤버id) — bigint — Foreign key → MEMBER.id — NOT NULL
  • travel_id (여행id) — bigint — Foreign key → TRAVEL.id — NOT NULL
  • master_member_id (관리자멤버id) — bigint — Foreign key → MEMBER.id — NOT NULL