chat
Tables
access_tokens
id, user_id, device_id, token, valid_until_ms, puppets_user_id, last_validated, refresh_token_id, used
3 rows
application_services_state
as_id, state, read_receipt_stream_id, presence_stream_id, to_device_stream_id, device_list_stream_id
6 rows
current_state_delta_stream
stream_id, room_id, type, state_key, event_id, prev_event_id, instance_name
5,890 rows
current_state_events
event_id, room_id, type, state_key, membership, event_stream_ordering
4,586 rows
delayed_events
delay_id, user_localpart, device_id, delay, send_ts, room_id, event_type, state_key, origin_server_ts, content, is_processed, sticky_duration_ms
0 rows
destinations
destination, retry_last_ts, retry_interval, failure_ts, last_successful_stream_ordering
1 row
device_lists_changes_in_room
user_id, device_id, room_id, stream_id, converted_to_destinations, opentracing_context, instance_name, inserted_ts
2,279 rows
device_lists_outbound_pokes
destination, stream_id, user_id, device_id, sent, ts, opentracing_context, instance_name
0 rows
e2e_cross_signing_keys
user_id, keytype, keydata, stream_id, updatable_without_uia_before_ms, instance_name
6 rows
e2e_room_keys
user_id, room_id, session_id, version, first_message_index, forwarded_count, is_verified, session_data
0 rows
event_auth_chain_links
origin_chain_id, origin_sequence_number, target_chain_id, target_sequence_number
4,468 rows
event_push_actions
room_id, event_id, user_id, profile_tag, actions, topological_ordering, stream_ordering, notif, highlight, unread, thread_id
276 rows
event_push_actions_staging
event_id, user_id, actions, notif, highlight, unread, thread_id, inserted_ts
0 rows
event_push_summary
user_id, room_id, notif_count, stream_ordering, unread_count, last_receipt_stream_ordering, thread_id
1,214 rows
events
stream_ordering, topological_ordering, event_id, type, room_id, content, unrecognized_keys, processed, outlier, depth, origin_server_ts, received_ts, sender, contains_url, instance_name, state_key, rejection_reason
19,759 rows
federation_inbound_events_staging
origin, room_id, event_id, received_ts, event_json, internal_metadata
0 rows
local_media_repository
media_id, media_type, media_length, created_ts, upload_name, user_id, quarantined_by, url_cache, last_access_ts, safe_from_quarantine, authenticated, sha256
3,936 rows
local_media_repository_thumbnails
media_id, thumbnail_width, thumbnail_height, thumbnail_type, thumbnail_method, thumbnail_length
17,354 rows
local_media_repository_url_cache
url, response_code, etag, expires_ts, og, media_id, download_ts
0 rows
presence_stream
stream_id, user_id, state, last_active_ts, last_federation_update_ts, last_user_sync_ts, status_msg, currently_active, instance_name
154 rows
push_rules_stream
stream_id, event_stream_ordering, user_id, rule_id, op, priority_class, priority, conditions, actions, instance_name
0 rows
pushers
id, user_name, access_token, profile_tag, kind, app_id, app_display_name, device_display_name, pushkey, ts, lang, data, last_stream_ordering, last_success, failing_since, enabled, device_id, instance_name
0 rows
receipts_linearized
stream_id, room_id, receipt_type, user_id, event_id, thread_id, event_stream_ordering, data, instance_name
162 rows
received_transactions
transaction_id, origin, ts, response_code, response_json, has_been_referenced
0 rows
refresh_tokens
id, user_id, device_id, token, next_token_id, expiry_ts, ultimate_session_expiry_ts
0 rows
remote_media_cache
media_origin, media_id, media_type, created_ts, upload_name, media_length, filesystem_id, last_access_ts, quarantined_by, authenticated, sha256
0 rows
remote_media_cache_thumbnails
media_origin, media_id, thumbnail_width, thumbnail_height, thumbnail_method, thumbnail_type, thumbnail_length, filesystem_id
0 rows
room_memberships
event_id, user_id, sender, room_id, membership, forgotten, display_name, avatar_url, event_stream_ordering, participant
2,513 rows
room_stats_current
room_id, current_state_events, joined_members, invited_members, left_members, banned_members, local_users_in_room, completed_delta_stream_id, knocked_members
292 rows
room_stats_state
room_id, name, canonical_alias, join_rules, history_visibility, encryption, avatar, guest_access, is_federatable, topic, room_type
292 rows
server_signature_keys
server_name, key_id, from_server, ts_added_ms, verify_key, ts_valid_until_ms
0 rows
sliding_sync_connection_lazy_members
connection_key, connection_position, room_id, user_id, last_seen_ts
0 rows
sliding_sync_connection_room_configs
connection_position, room_id, timeline_limit, required_state_id
0 rows
sliding_sync_connection_streams
connection_position, stream, room_id, room_status, last_token
0 rows
sliding_sync_connections
connection_key, user_id, effective_device_id, conn_id, created_ts, last_used_ts
0 rows
sliding_sync_joined_rooms
room_id, event_stream_ordering, bump_stamp, room_type, room_name, is_encrypted, tombstone_successor_room_id
289 rows
sliding_sync_membership_snapshots
room_id, user_id, sender, membership_event_id, membership, forgotten, event_stream_ordering, event_instance_name, has_known_state, room_type, room_name, is_encrypted, tombstone_successor_room_id
1,392 rows
sticky_events
stream_id, instance_name, event_id, room_id, event_stream_ordering, sender, expires_at
0 rows
thread_subscriptions
stream_id, instance_name, room_id, event_id, user_id, subscribed, automatic, unsubscribed_at_stream_ordering, unsubscribed_at_topological_ordering
0 rows
threepid_validation_session
session_id, medium, address, client_secret, last_send_attempt, validated_at
0 rows
users
name, password_hash, creation_ts, admin, upgrade_ts, is_guest, appservice_id, consent_version, consent_server_notice_sent, user_type, deactivated, shadow_banned, consent_ts, approved, locked, suspended
634 rows
worker_read_write_locks
lock_name, lock_key, instance_name, write_lock, token, last_renewed_ts
0 rows
... and 18 hidden tables
Views
Download SQLite DB: chat.db 104.8 MB