NIGHTLETTER

Tables (10)

Chat (대화)

  • ChatId (대화ID) — Long — Primary key
  • MemberId (멤버ID) — Integer — Foreign key → Member.MemberId
  • ChatroomId (대화방ID) — Long — Foreign key → Chatroom.ChatroomId
  • SendTime (발송 시각) — LocalDateTime
  • Message (메세지 내용) — String

Chatroom (대화방)

  • ChatroomId (대화방ID) — Long — Primary key
  • CreatedAt (생성 시각) — LocalDateTime
  • DeletedAt (삭제 시각) — LocalDateTime

DairyTarot (일기_타로카드)

  • DiaryId (다이어리ID) — Long — Foreign key → Diary.DiaryId
  • TarotId (타로ID) — Integer — Foreign key → Tarot.TarotId
  • DiaryTarotType (타로 타입) — Enum(PAST, NOW, FUTURE)

Diary (다이어리)

  • DiaryId (다이어리ID) — Long — Primary key
  • MemberId (멤버ID) — Long
  • Content (본문) — String
  • Date (작성날짜) — LocalDate
  • Type (공개 여부) — Enum(PUBLIC, PRIVATE)
  • GptComment (GPT 답글) — String
  • DeletedAt (삭제 시각) — LocalDateTime
  • Vector (임베딩 벡터) — String — NOT NULL

Member (멤버)

  • MemberId (멤버ID) — Integer — Primary key
  • OAuth2Id (소셜ID) — String
  • email (이메일) — String
  • Nickname (닉네임) — String
  • ProfileImgUrl (프로필 이미지) — String
  • Provider (소셜 제공자) — Enum(Kakao, Apple)
  • DeletedAt (삭제 시각) — LocalDateTime — NOT NULL

Notification (알림)

  • NotificationId (알림ID) — Long — Primary key
  • MemberId (멤버ID) — Integer — Foreign key → Member.MemberId
  • NotificationType (알림 타입) — Enum
  • IsRead (확인 여부) — boolean
  • CreatedAt (생성 시각) — LocalDateTime
  • ReadAt (확인 시각) — LocalDateTime
  • DeletedAt (삭제 시각) — LocalDateTime

Participants (대화 참여자)

  • RoomParticipantId (대화참여ID) — Long — Primary key
  • MemberId (멤버ID) — Integer — Foreign key → Member.MemberId
  • ChatroomId (대화방ID) — Long — Foreign key → Chatroom.ChatroomId
  • ParticipatedTime (참여 시각) — LocalDateTime

RecommendedDiary (추천 사연(다이어리))

  • RecommendId (추천ID) — Long — Primary key — NOT NULL
  • DiaryId (다이어리ID) — Long — Foreign key → Diary.DiaryId
  • MemberId (멤버ID) — Integer — Foreign key → Member.MemberId
  • RecommendedDate (추천 일자) — LocalDate

Scrap (스크랩)

  • ScrapId (스크랩ID) — Long — Primary key
  • DiaryId (다이어리ID) — Long — Foreign key → Diary.DiaryId
  • MemberId (멤버ID) — Integer — Foreign key → Member.MemberId
  • ScrappedAt (스크랩 일자) — LocalDate

Tarot (타로카드)

  • TarotId (타로ID) — Integer — Primary key
  • Name (타로 이름) — String
  • ImgUrl (타로 이미지) — String
  • Keyword (키워드) — String
  • Description (설명) — String
  • Direction (방향) — Enum(FORWARD, REVERSE)
  • DeletedAt (삭제 시각) — LocalDateTime
  • Vector (임베딩 벡터) — List<EmberVector> — NOT NULL