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