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