Real-time messaging

Tables (4)

ChatRoom (chat_room)

  • Chat_Room_Id (roomId) — int — Primary key — NOT NULL — RoomId
  • Created_By (createdBy) — text — find
  • Created_at (createdAt) — time — CreatedTime
  • Chat_Room_name (roomName) — text — NOT NULL — RoomName

Message (message)

  • Message_ID (messageId) — int — Primary key — NOT NULL — id
  • sender_id (senderId) — int — NOT NULL
  • Receiver (receiver) — int — NOT NULL
  • Content (content) — text — NOT NULL
  • Created_at (created_at) — time — NOT NULL
  • User_id (userId) — varchar — Foreign key → User.User_id — NOT NULL — Id
  • Chat_Room_Id (roomId) — int — Foreign key → ChatRoom.Chat_Room_Id — NOT NULL — RoomId

User (user)

  • User_id (userId) — varchar — Primary key — NOT NULL — Id
  • User_Name (userName) — varchar(10) — NOT NULL — Name
  • Email (email) — varchar(20) — NOT NULL — Email
  • PassWord (Pw) — varchar(20) — NOT NULL — PW

User_ChatRoom (user chat room)

  • User_id (userId) — varchar — Foreign key → User.User_id — NOT NULL — Id
  • Chat_Room_Id (roomId) — int — Foreign key → ChatRoom.Chat_Room_Id — NOT NULL — RoomId
  • JoinedAT (join) — time — NOT NULL — join 시간
  • Message_ID (messageId) — int — Foreign key → Message.Message_ID — NOT NULL — id