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