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