Telegram

Tables (23)

Untitled (session_queue)

  • Key (session_id) — bigint — Primary key — NOT NULL
  • Key (message_id) — bigint — Primary key — NOT NULL
  • Field (ack_received) — boolean
  • Field (tl_object) — blob

Untitled (file_parts)

  • Key (file_id) — bigint — Primary key — NOT NULL
  • Key (part_num) — int — Primary key — NOT NULL
  • Field (bytes) — blob
  • Field (size) — int

Untitled (contacts)

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (contact_id) — bigint — Primary key — NOT NULL
  • Field (phone) — text
  • Field (first_name) — text
  • Field (last_name) — text
  • Field (is_registered) — boolean

Untitled (dialogs)

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (dialog_id) — bigint — Primary key — NOT NULL
  • Field (peer_type) — bigint
  • Field (peer_id) — int
  • Field (top_message) — int
  • Field (unread_count) — int
  • Field (mute_until) — int
  • Field (sound) — text
  • Field (show_previews) — boolean
  • Field (events_mask) — int

Untitled (chat_users)

  • Key (chat_id) — int — Primary key — NOT NULL
  • Field (user_id) — int

Untitled (profile_photos)

  • Key (user_Id) — int — Primary key — NOT NULL
  • Field (file_id) — int
  • Field (caption) — text
  • Field (lat) — double
  • Field (lon) — double
  • Field (crop_left) — double
  • Field (crop_top) — double
  • Field (crop_width) — double
  • Field (date) — int

Untitled (outgoing_messages_by_chat[view])

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (to_chat_id) — int — Primary key — NOT NULL
  • Key (to_user_id) — int — Primary key — NOT NULL
  • Key (message_id) — int — Primary key — NOT NULL

Untitled (users_by_phone[view])

  • Key (phone) — text — Primary key — NOT NULL
  • Key (user_id) — int — Primary key — NOT NULL

Untitled (sessions_by_user[view])

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (session_id) — bigint — Primary key — NOT NULL

Untitled (files)

  • Key (file_id) — bigint — Primary key — NOT NULL
  • Field (type) — int
  • Field (mtime) — int
  • Field (part_size) — int
  • Field (name) — text
  • Field (md5_checksum) — text

Untitled (server_salts)

  • Key (auth_key_Id) — bigint — Primary key — NOT NULL
  • Key (valid_since) — timestamp — Primary key — NOT NULL
  • Field (server_salt) — bigint
  • Field

Untitled (users)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (first_name) — text
  • Field (last_name) — text
  • Field (username) — text
  • Field (access_hash) — bigint
  • Field (phone) — text
  • Field (pts) — int
  • Field (qts) — int
  • Field (sent_messages) — int
  • Field (received_messages) — int

Untitled (users_by_username[view])

  • Key (username) — text — Primary key — NOT NULL
  • Key (user_id) — int — Primary key — NOT NULL

Untitled (user_chats[view])

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (chat_id) — int — Primary key — NOT NULL

Untitled (secret_chats)

  • Key (chat_id) — int — Primary key — NOT NULL
  • Field (admin_id) — int
  • Field (participant_id) — int

Untitled (outgoing_messages)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (to_user_id) — int
  • Field (message_id) — int
  • Field (to_chat_id) — int
  • Field (peer_message_id) — int
  • Field (message) — text
  • Field (media) — blob
  • Field (flags) — int
  • Field (date) — int
  • Field (fwd_from_id) — int
  • Field (fwd_date) — int
  • Field (reply_to_msg_id) — int
  • Field (entities) — blob

Untitled (chat_messages)

  • Key (to_chat_id) — int — Primary key — NOT NULL
  • Field (user_id) — int
  • Field (message) — text
  • Field (media) — blob
  • Field (date) — int
  • Field (fwd_from_id) — int
  • Field (fwd_date) — int
  • Field (reply_to_msg_id) — int
  • Field (entities) — blob

Untitled (incoming_messages)

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (from_user_id) — int — Primary key — NOT NULL
  • Key (message_id) — int — Primary key — NOT NULL
  • Field (to_chat_id) — int
  • Field (peer_message_id) — int
  • Field (message) — text
  • Field (media) — blob
  • Field (flasg) — int
  • Field (date) — int
  • Field (fwd_from_id) — int
  • Field (fwd_date) — int
  • Field (reply_to_mesg_id) — int
  • Field (entities) — blob

Untitled (chats)

  • Key (chat_id) — int — Primary key — NOT NULL
  • Field (admin_id) — int
  • Field (title) — text
  • Field (photo) — bigint
  • Field (date) — int
  • Field (version) — int

Untitled (blocked_contacts)

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (phone) — text — Primary key — NOT NULL

Untitled (sessions)

  • Key (session_id) — bigint — Primary key — NOT NULL
  • Field (user_id) — int
  • Field (phone) — text
  • Field (auth_key_id) — bigint
  • Field (layer) — int

Untitled (auth_keys)

  • Key (auth_key_id) — bigint — Primary key — NOT NULL
  • Field (auth_key) — blob
  • Field (phone) — text
  • Field (user_id) — int
  • Field (api_layer) — int

Untitled (incoming_messages_by_chat[view])

  • Key (user_id) — int — Primary key — NOT NULL
  • Key (to_chat_id) — int — Primary key — NOT NULL
  • Key (from_user_id) — int — Primary key — NOT NULL
  • Key (message_id) — int — Primary key — NOT NULL