Chat

Tables (4)

ChatMessage (메세지)

  • message_id (메시지ID) — PK — Primary key — NOT NULL
  • room_id (채팅방 ID) — FK — Foreign key → ChatRoom.room_id — NOT NULL
  • user_id (회원ID) — FK — Foreign key → User.user_id — NOT NULL
  • message (메시지) — Not Null
  • send_date (보내는 시간) — Not Null

ChatRoom (채팅방)

  • room_id (채팅방 ID) — PK — Primary key — NOT NULL
  • user_id (회원ID) — FK — Foreign key → User.user_id — NOT NULL
  • chat_name (채팅방 이름) — Not Null
  • created_date (생성일) — Not Null

ChatUser (채팅방 참여 유저)

  • id (채탕방 참여 유저id) — PK — Primary key — NOT NULL
  • user_id (회원ID) — FK — Foreign key → User.user_id — NOT NULL
  • room_id (채팅방 ID) — FK — Foreign key → ChatRoom.room_id — NOT NULL

User (회원)

  • user_id (회원ID) — PK — Primary key — NOT NULL
  • user_name (이름) — Not Null
  • email (이메일) — Not Null
  • password (비밀번호) — Not Null
  • authority (권한) — Not Null