chat

Tables (4)

Chat (CopyOfCopyOfCopyOfUntitled)

  • Id (PK) — Long — Primary key — NOT NULL
  • message (권한) — String — NOT NULL
  • room_id (room_FK) — Long — Foreign key → Room.Id — NOT NULL
  • member_id (member_FK) — Long — Foreign key → Member.Id — NOT NULL

Member (Untitled)

  • Id (PK) — Long — Primary key — NOT NULL
  • username (아이디) — string — NOT NULL
  • nickname (닉네임) — string — NOT NULL

Room (CopyOfUntitled)

  • Id (PK) — Long — Primary key — NOT NULL
  • roomName (방 이름) — string — NOT NULL

RoomMember (CopyOfCopyOfUntitled)

  • Id (PK) — Long — Primary key — NOT NULL
  • role (권한) — enum(ADMIN, MEMBER) — NOT NULL
  • room_id (room_FK) — Long — Foreign key → Room.Id — NOT NULL
  • member_id (member_FK) — Long — Foreign key → Member.Id — NOT NULL