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