ttt

Tables (3)

chatroom

  • id — bigint — Primary key — NOT NULL
  • master_id — bigint — Foreign key → user.id — NOT NULL
  • title — varchar(45)

message

  • id — bigint — Primary key — NOT NULL
  • chatroom_id — bigint — Foreign key → chatroom.id — NOT NULL
  • sender_id — bigint — Foreign key → user.id — NOT NULL
  • content — text

user

  • id — bigint — Primary key — NOT NULL
  • nickname — varchar(45)