Chat
Tables (4)
Chat (chat)
- uuid — bitint — Foreign key → User.uuid — NOT NULL
- Roomid (roomid) — bigint — Foreign key → Chatroom.Roomid — NOT NULL
Chatroom (chatroom)
- Roomid (roomid) — bigint — Primary key — NOT NULL
- RoomName (roomname) — varchar2
- Status (status) — varchar2
- Creationtime (creationtime) — datetimefield
Message (message)
- Messageid (messageid) — bigint — Primary key — NOT NULL
- uuid — bitint — Foreign key → Chat.uuid — NOT NULL
- Roomid (roomid) — bigint — Foreign key → Chat.Roomid — NOT NULL
- Content (content) — varchar2
- Senttime (senttime) — timestamp
- Viewedcnt — int
User (user)
- uuid — bitint — Primary key — NOT NULL
- Username (username) — varchar2
- Email (email) — varchar2
- Password (password) — varchar2