travelBox
Tables (11)
Cloth (옷api)
- clothId (Key) — not null — Primary key — NOT NULL
- threadId (Key2) — not null — Foreign key → TravelThread.threadId — NOT NULL
- clothInfoId (----) — not null
Comment (댓글)
- commentId (Key) — not null — Primary key — NOT NULL
- userId (댓글 작성자) — not null — Foreign key → User.userId — NOT NULL
- threadId (댓글 달린 게시물) — not null — Foreign key → TravelThread.threadId — NOT NULL
- commentContent (------) — not null
- commentVisible (enum = { public , private }) — not null
- commmentDate (2025-01-13) — not null
Follow (팔로워)
- followId (Key) — not null — Primary key — NOT NULL
- userId — not null — Foreign key → User.userId — NOT NULL
- follwingUserId (---------) — not null
- follwerUserId (-----) — not null
HashTag (해시테그)
- hashtagId (Key) — not null — Primary key — NOT NULL
- threadId (Key2) — not null — Foreign key → TravelThread.threadId — NOT NULL
- hashtagContent (------) — not null
- hashtagNumber (---) — not null
Image (사진)
- imageId (Key) — not null — Primary key — NOT NULL
- threadId (Key2) — not null — Foreign key → TravelThread.threadId — NOT NULL
- image (이미지 파일) — not null
Like (좋아요)
- likeId (Key) — not null — Primary key — NOT NULL
- threadId (좋아요 받은 게시물) — not null — Foreign key → TravelThread.threadId — NOT NULL
- userId (좋아요 누른 유저) — not null — Foreign key → User.userId — NOT NULL
PostScrap (게시물 스크랩 정보)
- ScrapId (Key) — not null — Primary key — NOT NULL
- userId (스크랩한 유저) — not null — Foreign key → User.userId — NOT NULL
- threadId (스크랩당한 게시물) — not null — Foreign key → TravelThread.threadId — NOT NULL
SIng (노래api)
- singId (Key) — not null — Primary key — NOT NULL
- threadId (Key2) — not null — Foreign key → TravelThread.threadId — NOT NULL
- singInfoId (---) — not null
TravelCalender (여행 캘린더 일정)
- travelId (Key) — not null — Primary key — NOT NULL
- userId — not null — Foreign key → User.userId — NOT NULL
- TravelTitle (----) — not null
- TravelContent (---) — not null
- TravelStartDate (------) — not null
- TravelEndDate (-------) — not null
TravelThread (게시물 정보)
- threadId (Key) — not null — Primary key — NOT NULL
- userId — not null — Foreign key → User.userId — NOT NULL
- postCategory (enum = {여행기록, 기념품, 여행지, 여행 코디}) — not null
- postTitle (---) — not null
- postContent (-----) — not null
- postDate (------) — not null
- postRegionCode (지역 고유 번호) — null
- postclothesAPIInfo (api 구조 확인 후 수정) — null
- postmusicAPIInfo (api 구조 확인 후 수정 필요) — null
User (유저 정보)
- userId (key) — not null — Primary key — NOT NULL
- userPassword (암호화) — not null — NOT NULL
- userNickname (고유값 x) — not null
- userTag (고유값 o, loginId) — not null