국민학교
테이블 (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