국민학교

테이블 (9)

ChatMessage (Untitled7)

  • message_id (Key) — Long — 기본 키 — NOT NULL
  • senderId (Field) — Long
  • message (Field2) — String
  • timeStamp (Field3) — String
  • chatRoom_id (Key2) — Long — 외래 키 → ChatRoom.chatRoom_id — NOT NULL

ChatRoom (Untitled6)

  • chatRoom_id (Key) — Long — 기본 키 — NOT NULL
  • roomId (Field) — String
  • otherMemberName (Field2) — String
  • registerMember (Field3) — String
  • id (Key2) — Long — 외래 키 → Member.id — NOT NULL

CommentPhoto (Untitled5)

  • comment_photo_id (Key) — Long — 기본 키 — NOT NULL
  • photoUrl (Field) — String
  • comment_id (Key2) — Long — 외래 키 → comment.comment_id — NOT NULL

Member (Untitled)

  • id (Key) — Long — 기본 키 — NOT NULL
  • name (Field) — String
  • email (Field2) — String
  • role (Field3) — String
  • lastLogin (Field4) — LocalDateTime
  • provider (Field5) — AuthProvider
  • refreshToken (Field6) — String

MemberChatRoom (Untitled8)

  • memberChatRoom_id (Key) — Long — 기본 키 — NOT NULL
  • chatRoom_id (Key2) — Long — 외래 키 → ChatRoom.chatRoom_id — NOT NULL
  • id (Key3) — Long — 외래 키 → Member.id — NOT NULL

PostLiked (Untitled4)

  • like_id (Key) — Long — 기본 키 — NOT NULL
  • isDeleted (Field) — Boolean
  • updatedAt (Field2) — LocalDateTime
  • createdAt (Field3) — LocalDateTime
  • id (Key2) — Long — 외래 키 → Member.id — NOT NULL
  • post_id (Key3) — Long — 외래 키 → post.post_id — NOT NULL

PostPhoto (CopyOfUntitled5)

  • Post_photo_id (Key) — Long — 기본 키 — NOT NULL
  • photoUrl (Field) — String
  • post_id (Key2) — Long — 외래 키 → post.post_id — NOT NULL

comment (Untitled3)

  • comment_id (Key) — Long — 기본 키 — NOT NULL
  • content (Field) — String
  • updatedAt (Field2) — LocalDateTime
  • createdAt (Field3) — LocalDateTime
  • isDeleted (Field4) — boolean
  • id (Key2) — Long — 외래 키 → Member.id — NOT NULL
  • post_id (Key3) — Long — 외래 키 → post.post_id — NOT NULL

post (Untitled2)

  • post_id (Key) — Long — 기본 키 — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • category (Field3) — PostCategory
  • likeCount (Field4) — int
  • viewCount (Field5) — int
  • isDeleted (Field6) — boolean
  • updatedAt (Field7) — LocalDateTime
  • createdAt (Field8) — LocalDateTime
  • id (Key2) — Long — 외래 키 → Member.id — NOT NULL