ERD_01

Tables (6)

ChatRoom (채팅방)

  • id (PK) — Long — Primary key — NOT NULL
  • roomName (Field) — String — NOT NULL
  • roomType (Field2) — String — NOT NULL
  • createTime (Field3) — LocalDateTime — NOT NULL

ChatRoomMemeber (채팅방 유저)

  • id (PK) — Long — Primary key — NOT NULL
  • roomId (FK) — Long — Foreign key → ChatRoom.id — NOT NULL
  • userId (FK2) — Long — Foreign key → User.id — NOT NULL
  • joinedAt (Field) — LocalDateTime — NOT NULL
  • leftAt (Field2) — LocalDateTime — NOT NULL

Memo (메모)

  • memoId (PK) — Long — Primary key — NOT NULL
  • ownerId (FK) — Long — Foreign key → User.id — NOT NULL
  • friendId (FK2) — Long
  • content (Field) — String
  • createAt (Field2) — LocalDate

Message (메시지)

  • msgId (PK) — Long — Primary key — NOT NULL
  • roomId (FK) — Long — Foreign key → ChatRoom.id — NOT NULL
  • senderId (FK2) — Long — Foreign key → User.id — NOT NULL
  • content (Field) — String
  • createAt (Field2) — LocalDate

User (유저)

  • id (PK) — Long — Primary key — NOT NULL
  • name (Field) — String — NOT NULL
  • username (Field2) — String — NOT NULL
  • password (Field3) — String — NOT NULL
  • status (Field4) — Boolean — NOT NULL
  • profileUrl (Field5) — String — NOT NULL
  • friends (Field6) — List<User> — NOT NULL
  • memos (Field7) — List<Memo> — NOT NULL
  • chatRoomEntries (Field8) — List<ChatRoomMemeber> — NOT NULL
  • messageSent (Field9) — List<Message> — NOT NULL

UserFriends (유저 친구)

  • userId (PK) — Long — Foreign key → User.id — NOT NULL
  • friendId (FK2) — Long — NOT NULL