chat_proj`

Tables (4)

ChatMessage (채팅 메세지)

  • message_id (메세지 ID) — Long — Primary key — NOT NULL
  • message_content (메세지 내용) — VARCHAR(50)
  • message_type (전송 시각) — DATETIME
  • file_path (파일 경로) — STRING
  • sent_at (전송 시간) — DATETIME
  • chat_room_id (채팅방 ID) — Long — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • sender_id (사용자 ID) — Long — Foreign key → User.user_id — NOT NULL

ChatRoom (채팅방)

  • chat_room_id (채팅방 ID) — Long — Primary key — NOT NULL
  • room_name (Field)
  • room_type (Field2)
  • datetime (생성일) — DATETIME

ChatRoom_Participant (채팅방 참가자)

  • room_id (채팅방 ID2) — Long — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • created_at (참여일)
  • user_id (사용자 ID) — Long — Foreign key → User.user_id — NOT NULL

User (사용자)

  • user_id (사용자 ID) — Long — Primary key — NOT NULL
  • email (이메일) — VARCHAR(50)
  • Field (이름) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(20)
  • created_at (가입일) — DATETIME
  • updated_at (수정일) — DATETIME
  • deleted_at (탈퇴일) — DATETIME