On-premise Database Tables Schema
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.
Caution
You must not write to tables in the on-premise mesibo database under any circumstances. Also ensure that you do not overload the mesibo on-premise database. If frequent reads are needed, consider setting up the database in a master-slave replication configuration. This allows read operations to be performed on the slave, reducing load on the master. The slave can then be accessed to retrieve required data as needed.
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 |
Group Calls Table
mesibo on-premise stores all the group call logs in the groupcalls table. Following are the columns you can read.
| Column | Description |
|---|---|
| id | Call ID |
| uid | UID of the user who joined the call |
| peer | UID of the publisher if the uid is the subscriber, 0 if the uid is the publisher |
| sid | Stream ID |
| sts | Time when the call was started, in epoch seconds |
| ets | Time when the call was ended, in epoch seconds |
| bw | Bandwidth consumed (in bytes) |
| video | 1 if the video frames were sent or received, 0 otherwise |
| audio | 1 if the audio frames were sent or received, 0 otherwise |
| active | 1 if the call is active, 0 otherwise |
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 |