Rocket.Chat DB schema

_raix_push_notifications
avatars.chunks
avatars.files
instances
meteor_accounts_loginServiceConfiguration
meteor_oauth_pendingCredentials
meteor_oauth_pendingRequestTokens
migrations
rocketchat__trash
rocketchat_cron_history
rocketchat_custom_emoji
rocketchat_custom_sounds
rocketchat_import
rocketchat_integration_history
rocketchat_integrations
rocketchat_livechat_custom_field
rocketchat_livechat_department
rocketchat_livechat_department_agents
rocketchat_livechat_external_message
rocketchat_livechat_inquiry
rocketchat_livechat_office_hour
rocketchat_livechat_page_visited
rocketchat_livechat_trigger
rocketchat_message
rocketchat_oauth_apps
rocketchat_oembed_cache
rocketchat_permissions
rocketchat_raw_imports
rocketchat_reports
rocketchat_roles
rocketchat_room
rocketchat_settings
rocketchat_smarsh_history
rocketchat_statistics
rocketchat_subscription
rocketchat_uploads
system.indexes
users
usersSessions

https://rocket.chat/docs/developer-guides/schema-definition

Rooms

{
  "_id": "22nytdn4QqKvSk2Av",              // Random.id()
  "t": "p",                                // String           Room Type: c = chanel, d = direct, p (change to g) = group, v = visitor
  "ts": new Date(1432937851208),           // Date             Room Creation Timestamp
  "name": "general",                       // String           Room Name (t:d -> empty)
  "lm": new Date(1432937851208),           // Date             Last Message Timestamp
  "msgs": 2345,                            // Integer          Messages Counter
  "cl": true,                              // Boolean          If users can leave room
  "ro": false,                             // Boolean          Read Only
  "usernames": [                           // Array(String)    Room Users
      "username1",                         // String           User Username
      "username2",
      "username3"
  ],
  "u": {                                   // Object           Owner User
    "_id": "CABrXSHpDqbZXGkYR",            // Random.id()      User Id
    "username": "john"                     // String           User Username
  }
}

Fields Type Description
_id Random.id() Room Id
t String Room Type
ts Date Room Creation Timestamp
name String Room Name (t:d -> empty)
lm Date Last Message Timestamp
msgs Integer Messages Counter
cl Boolean If users can leave room
ro     Boolean Read Only
usernames Array[String] Room Users
usernames.0 String User Username
u Object Owner User
u._id Random.id() User Id
u.username String User Username

Rocketchat_message

{
 "_id" : "sjiKhSfcxLDr6wQBZ",
"t" : "uj",
"rid" : "GENERAL",
 "ts" : ISODate("2017-05-09T06:10:49.050Z"),
"msg" : "woody_island",
"u" : { "_id" : "HgB3DB25uwbL4BS2D", "username" : "woody_island" },
"groupable" : false,
"_updatedAt" : ISODate("2017-05-09T06:10:49.050Z")
}

Fields:                       Type                 Description
_id
t
rid
ts
msg
u
groupable
_updatedAt

Users

{
    "_id" : "HgB3DB25uwbL4BS2D",
    "createdAt" : ISODate("2017-05-09T05:48:42.400Z"),
    "services" : {
         "password" : {
               "bcrypt" : "$2a$10$tcIus/rFIp0I3opQgSshfeIjq0H9jT59Gr.vg/nnRGoNZHZcdpIAi"  
          },
     "email" : {
          "verificationTokens" : [ {
               "token" : "mgBoYoXriJuTKsfjylQld5PonmVADqb8LFxXA9Hx9FL",
               "address" : "woody@island.spratly",
               "when" : ISODate("2017-05-09T05:48:42.743Z")
          } ] },
     "resume" : {
          "loginTokens" : [ {
                "when" : ISODate("2017-05-09T05:48:43.341Z"),
                "hashedToken" : "fMzgS8mGkkTqaz5pKUfOvY5L+4jS+2jHkiMpNaHhXUM="
               },
               { "when" : ISODate("2017-05-09T06:10:30.114Z"),
                 "hashedToken" : "OrzsPddJRu04h0NTCzqDlv8UXCmtYMjZZwQ4VPw2Fxc="
               }
          ] }
     },
     "emails" : [ { "address" : "woody@island.spratly", "verified" : true } ],
     "type" : "user",
     "status" : "away",
     "active" : true,
     "name" : "woody",
     "_updatedAt" : ISODate("2017-05-09T06:24:09.172Z"),
     "roles" : [ "admin" ],
     "lastLogin" : ISODate("2017-05-09T06:10:30.082Z"),
     "statusConnection" : "away",
     "utcOffset" : -5,
     "username" : "woody_island"
}


Fields Type Description