test

Tables (4)

chatting_message (채팅내용)

  • 내요ID (id) — Long — Primary key — NOT NULL
  • 메시지 (message) — Varchar(255)
  • 보낸시간 (send_time) — DateTime
  • 읽은시간 (read_time) — DateTime
  • 읽은여부 (isRead) — Boolean
  • 보낸사용자 (sender) — Long — Foreign key → user.유저ID — NOT NULL
  • 받은사용자 (receiver) — Long — Foreign key → user.유저ID — NOT NULL
  • 방ID (roomId) — Long — Foreign key → chatting_room.방ID — NOT NULL

chatting_room (채팅방)

  • 방ID (id) — Long — Primary key — NOT NULL
  • 방이름 (roomName) — Varchar(255)
  • 처음보낸사용자 (fiirstSender) — Long — Foreign key → user.유저ID — NOT NULL
  • 메시지받은사용자 (recevier) — Long — Foreign key → user.유저ID — NOT NULL
  • 방만들어진시간 (created_at) — DATETIME

manage_out (퇴장여부 관리)

  • id — Long — Primary key — NOT NULL
  • 나간시간 (outTime) — DateTime
  • 나간사용자 (outUser) — Long — Foreign key → user.유저ID — NOT NULL
  • 방ID (roomId) — Long — Foreign key → chatting_room.방ID — NOT NULL

user (회원)

  • 유저ID (id) — Long — Primary key — NOT NULL
  • Field