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