talkie
Tables (4)
Message (Untitled3)
- messageId (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- roomId (Key3) — Long — Foreign key → Room.roomId — NOT NULL
- createdAt (Field2) — LocalDateTime
- deletedAt (Field3) — LocalDateTime
Room (Untitled2)
- roomId (Key) — Long — Primary key — NOT NULL
- name (Field4) — String
- roomType (Field3) — String
- createdAt (Field) — LocalDateTime
- deletedAt (Field2) — LocalDateTime
RoomMember (Untitled4)
- roomMemberId (Key) — Long — Primary key — NOT NULL
- joinedAt (Field) — LocalDateTime
- last_read_message_id (Field2) — Long
- role (Field3) — String
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- roomId (Key3) — Long — Foreign key → Room.roomId — NOT NULL
User (Untitled)
- userId (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- password (Field2) — String
- email (Field3) — String
- nickname (Field4) — String
- profileImageUrl (Field5) — String
- lastActiveAt (Field6) — LocalDateTime
- createdAt (Field7) — LocalDateTime