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