On-premise Database Tables Schema

Estimated reading time: 3 minutes

mesibo on-premise gives you complete access to your data and total control over it. All the database tables created by mesibo on-premise and the data written in them are accessible to you.

While you can view all the data in the mesibo on-premise database, you can only use data from the below-listed tables and the columns. All other tables and columns are for mesibo on-premise use only and can be modified or deleted without notice. Hence, you MUST not access or use them.

You MUST NOT write to any tables under any circumstance. Also ensure that you do not overload the mesibo on-premise database. If you need to access the on-premise database frequently, set up the database in master-slave replication configuration and access the required data from the slave.

Messages Table

mesibo on-premise stores all the messages between your users in the messages table when you enable message retention. Following are the columns you can read.

Column Description
id Message ID
refid Message Reference ID
uid UID of the user to whom the message was sent
src UID of the sender
gid Group ID if the message was sent to the group
flags message flags used when sending
ts Message Time
rich 1 = Rich message with image, location, title, etc., 0 = Normal text message
title Title of the rich message (valid only if rich=1)
subtitle Message part of the rich message (valid only if rich=1)
image Image URL of the rich message (valid only if rich=1)
latitude Latitude - (valid only if rich=1 and the value is in range -90 and +90 )
longitude Longitude - (valid only if rich=1 and the value is in range -180 and +180 )
message Normal Text or Binary message (valid only if rich=0)

Calls Table

mesibo on-premise stores all the call logs in the calls table. Following are the columns you can read.

Column Description
id ID
uid UID of the user who initiated the call
duid UID of the user to whom the call was made
huid UID of the user who hanged up the call
ts Time when the call was made
rts Time when ringing on the destination started
ats Time when destination answered
ets Time when the call was ended
type Type of the call, 0 = voice, 1 = video
status Real-time Call Status

Users Table

mesibo on-premise stores all users in the users table. You can join this table with messages and calls table to find the address from the UID. Following are the columns you can read.

Column Description
uid UID of the user
address Address of the user
online Online status of the user, 1 = online, 0 = offline
active Active status of the user, 1 = active, 0 = not active
open, source, on-premise, messaging, chat, voice, video, database, on-premise