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