Skip to content

Instantly share code, notes, and snippets.

@rubo77

rubo77/synapse.html

Created March 25, 2019 21:52
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rubo77/c47cd669ad46f9cb16784277069be0ba to your computer and use it in GitHub Desktop.
Save rubo77/c47cd669ad46f9cb16784277069be0ba to your computer and use it in GitHub Desktop.
Download ZIP
Raw
synapse.html
<!-- $Header: /cvsroot/autodoc/autodoc/html.tmpl,v 1.4 2006/05/16 19:01:27 rbt Exp $ -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Index for synapse</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">
BODY {
color: #000000;
background-color: #FFFFFF;
font-family: Helvetica, sans-serif;
}
P {
margin-top: 5px;
margin-bottom: 5px;
}
P.w3ref {
font-size: 8pt;
font-style: italic;
text-align: right;
}
P.detail {
font-size: 10pt;
}
.error {
color: #FFFFFF;
background-color: #FF0000;
}
H1, H2, H3, H4, H5, H6 {
}
OL {
list-style-type: upper-alpha;
}
UL.topic {
list-style-type: upper-alpha;
}
LI.topic {
font-weight : bold;
}
HR {
color: #00FF00;
background-color: #808080;
}
TABLE {
border-width: medium;
padding: 3px;
background-color: #000000;
width: 90%;
}
CAPTION {
text-transform: capitalize;
font-weight : bold;
font-size: 14pt;
}
TH {
color: #FFFFFF;
background-color: #000000;
text-align: left;
}
TR {
color: #000000;
background-color: #000000;
vertical-align: top;
}
TR.tr0 {
background-color: #F0F0F0;
}
TR.tr1 {
background-color: #D8D8D8;
}
TD {
font-size: 12pt;
}
TD.col0 {
font-weight : bold;
width: 20%;
}
TD.col1 {
font-style: italic;
width: 15%;
}
TD.col2 {
font-size: 12px;
}
</style>
<link rel="stylesheet" type="text/css" media="all" href="all.css">
<link rel="stylesheet" type="text/css" media="screen" href="screen.css">
<link rel="stylesheet" type="text/css" media="print" href="print.css">
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
</head>
<body>
<!-- Primary Index -->
<p><br><br>Dumped on 2018-11-09</p>
<h1><a name="index">Index of database - synapse</a></h1>
<ul>
<li><a name="public.schema">public</a></li><ul>
<li><a href="#public.table.access-tokens">access_tokens</a></li><li><a href="#public.table.account-data">account_data</a></li><li><a href="#public.table.account-data-max-stream-id">account_data_max_stream_id</a></li><li><a href="#public.table.application-services">application_services</a></li><li><a href="#public.table.application-services-regex">application_services_regex</a></li><li><a href="#public.table.application-services-state">application_services_state</a></li><li><a href="#public.table.application-services-txns">application_services_txns</a></li><li><a href="#public.table.applied-module-schemas">applied_module_schemas</a></li><li><a href="#public.table.applied-schema-deltas">applied_schema_deltas</a></li><li><a href="#public.table.appservice-room-list">appservice_room_list</a></li><li><a href="#public.table.appservice-stream-position">appservice_stream_position</a></li><li><a href="#public.table.background-updates">background_updates</a></li><li><a href="#public.table.blocked-rooms">blocked_rooms</a></li><li><a href="#public.table.cache-invalidation-stream">cache_invalidation_stream</a></li><li><a href="#public.table.current-state-delta-stream">current_state_delta_stream</a></li><li><a href="#public.table.current-state-events">current_state_events</a></li><li><a href="#public.table.current-state-resets">current_state_resets</a></li><li><a href="#public.table.deleted-pushers">deleted_pushers</a></li><li><a href="#public.table.destinations">destinations</a></li><li><a href="#public.table.device-federation-inbox">device_federation_inbox</a></li><li><a href="#public.table.device-federation-outbox">device_federation_outbox</a></li><li><a href="#public.table.device-inbox">device_inbox</a></li><li><a href="#public.table.device-lists-outbound-last-success">device_lists_outbound_last_success</a></li><li><a href="#public.table.device-lists-outbound-pokes">device_lists_outbound_pokes</a></li><li><a href="#public.table.device-lists-remote-cache">device_lists_remote_cache</a></li><li><a href="#public.table.device-lists-remote-extremeties">device_lists_remote_extremeties</a></li><li><a href="#public.table.device-lists-stream">device_lists_stream</a></li><li><a href="#public.table.device-max-stream-id">device_max_stream_id</a></li><li><a href="#public.table.devices">devices</a></li><li><a href="#public.table.e2e-device-keys-json">e2e_device_keys_json</a></li><li><a href="#public.table.e2e-one-time-keys-json">e2e_one_time_keys_json</a></li><li><a href="#public.table.e2e-room-keys">e2e_room_keys</a></li><li><a href="#public.table.e2e-room-keys-versions">e2e_room_keys_versions</a></li><li><a href="#public.table.erased-users">erased_users</a></li><li><a href="#public.table.event-auth">event_auth</a></li><li><a href="#public.table.event-backward-extremities">event_backward_extremities</a></li><li><a href="#public.table.event-content-hashes">event_content_hashes</a></li><li><a href="#public.table.event-destinations">event_destinations</a></li><li><a href="#public.table.event-edge-hashes">event_edge_hashes</a></li><li><a href="#public.table.event-edges">event_edges</a></li><li><a href="#public.table.event-forward-extremities">event_forward_extremities</a></li><li><a href="#public.table.event-forward-extremities-bak">event_forward_extremities_bak</a></li><li><a href="#public.table.event-json">event_json</a></li><li><a href="#public.table.event-push-actions">event_push_actions</a></li><li><a href="#public.table.event-push-actions-staging">event_push_actions_staging</a></li><li><a href="#public.table.event-push-summary">event_push_summary</a></li><li><a href="#public.table.event-push-summary-stream-ordering">event_push_summary_stream_ordering</a></li><li><a href="#public.table.event-reference-hashes">event_reference_hashes</a></li><li><a href="#public.table.event-reports">event_reports</a></li><li><a href="#public.table.event-search">event_search</a></li><li><a href="#public.table.event-signatures">event_signatures</a></li><li><a href="#public.table.event-to-state-groups">event_to_state_groups</a></li><li><a href="#public.table.event-to-state-groups-to-delete">event_to_state_groups_to_delete</a></li><li><a href="#public.table.events">events</a></li><li><a href="#public.table.ex-outlier-stream">ex_outlier_stream</a></li><li><a href="#public.table.federation-stream-position">federation_stream_position</a></li><li><a href="#public.table.feedback">feedback</a></li><li><a href="#public.table.group-attestations-remote">group_attestations_remote</a></li><li><a href="#public.table.group-attestations-renewals">group_attestations_renewals</a></li><li><a href="#public.table.group-invites">group_invites</a></li><li><a href="#public.table.group-roles">group_roles</a></li><li><a href="#public.table.group-room-categories">group_room_categories</a></li><li><a href="#public.table.group-rooms">group_rooms</a></li><li><a href="#public.table.group-summary-roles">group_summary_roles</a></li><li><a href="#public.table.group-summary-room-categories">group_summary_room_categories</a></li><li><a href="#public.table.group-summary-rooms">group_summary_rooms</a></li><li><a href="#public.table.group-summary-users">group_summary_users</a></li><li><a href="#public.table.group-users">group_users</a></li><li><a href="#public.table.groups">groups</a></li><li><a href="#public.table.guest-access">guest_access</a></li><li><a href="#public.table.history-visibility">history_visibility</a></li><li><a href="#public.table.local-group-membership">local_group_membership</a></li><li><a href="#public.table.local-group-updates">local_group_updates</a></li><li><a href="#public.table.local-invites">local_invites</a></li><li><a href="#public.table.local-media-repository">local_media_repository</a></li><li><a href="#public.table.local-media-repository-thumbnails">local_media_repository_thumbnails</a></li><li><a href="#public.table.local-media-repository-url-cache">local_media_repository_url_cache</a></li><li><a href="#public.table.monthly-active-users">monthly_active_users</a></li><li><a href="#public.table.open-id-tokens">open_id_tokens</a></li><li><a href="#public.table.port-from-sqlite3">port_from_sqlite3</a></li><li><a href="#public.table.presence">presence</a></li><li><a href="#public.table.presence-allow-inbound">presence_allow_inbound</a></li><li><a href="#public.table.presence-list">presence_list</a></li><li><a href="#public.table.presence-stream">presence_stream</a></li><li><a href="#public.table.profiles">profiles</a></li><li><a href="#public.table.public-room-list-stream">public_room_list_stream</a></li><li><a href="#public.table.push-rules">push_rules</a></li><li><a href="#public.table.push-rules-enable">push_rules_enable</a></li><li><a href="#public.table.push-rules-stream">push_rules_stream</a></li><li><a href="#public.table.pusher-throttle">pusher_throttle</a></li><li><a href="#public.table.pushers">pushers</a></li><li><a href="#public.table.ratelimit-override">ratelimit_override</a></li><li><a href="#public.table.receipts-graph">receipts_graph</a></li><li><a href="#public.table.receipts-linearized">receipts_linearized</a></li><li><a href="#public.table.received-transactions">received_transactions</a></li><li><a href="#public.table.redactions">redactions</a></li><li><a href="#public.table.rejections">rejections</a></li><li><a href="#public.table.remote-media-cache">remote_media_cache</a></li><li><a href="#public.table.remote-media-cache-thumbnails">remote_media_cache_thumbnails</a></li><li><a href="#public.table.remote-profile-cache">remote_profile_cache</a></li><li><a href="#public.table.room-account-data">room_account_data</a></li><li><a href="#public.table.room-alias-servers">room_alias_servers</a></li><li><a href="#public.table.room-aliases">room_aliases</a></li><li><a href="#public.table.room-depth">room_depth</a></li><li><a href="#public.table.room-hosts">room_hosts</a></li><li><a href="#public.table.room-memberships">room_memberships</a></li><li><a href="#public.table.room-names">room_names</a></li><li><a href="#public.table.room-tags">room_tags</a></li><li><a href="#public.table.room-tags-revisions">room_tags_revisions</a></li><li><a href="#public.table.rooms">rooms</a></li><li><a href="#public.table.schema-version">schema_version</a></li><li><a href="#public.table.sent-transactions">sent_transactions</a></li><li><a href="#public.table.server-keys-json">server_keys_json</a></li><li><a href="#public.table.server-signature-keys">server_signature_keys</a></li><li><a href="#public.table.server-tls-certificates">server_tls_certificates</a></li><li><a href="#public.table.state-events">state_events</a></li><li><a href="#public.table.state-forward-extremities">state_forward_extremities</a></li><li><a href="#public.table.state-group-edges">state_group_edges</a></li><li><a href="#public.table.state-groups">state_groups</a></li><li><a href="#public.table.state-groups-state">state_groups_state</a></li><li><a href="#public.table.stats-reporting">stats_reporting</a></li><li><a href="#public.table.stream-ordering-to-exterm">stream_ordering_to_exterm</a></li><li><a href="#public.table.threepid-guest-access-tokens">threepid_guest_access_tokens</a></li><li><a href="#public.table.topics">topics</a></li><li><a href="#public.table.transaction-id-to-pdu">transaction_id_to_pdu</a></li><li><a href="#public.table.user-daily-visits">user_daily_visits</a></li><li><a href="#public.table.user-directory">user_directory</a></li><li><a href="#public.table.user-directory-search">user_directory_search</a></li><li><a href="#public.table.user-directory-stream-pos">user_directory_stream_pos</a></li><li><a href="#public.table.user-filters">user_filters</a></li><li><a href="#public.table.user-ips">user_ips</a></li><li><a href="#public.table.user-threepids">user_threepids</a></li><li><a href="#public.table.users">users</a></li><li><a href="#public.table.users-in-public-rooms">users_in_public_rooms</a></li><li><a href="#public.table.users-pending-deactivation">users_pending_deactivation</a></li><li><a href="#public.table.users-who-share-rooms">users_who_share_rooms</a></li>
</ul>
</ul>
<!-- Schema Creation -->
<!-- publicpublic -->
<hr>
<h2>Table:
<a name="public.table.access-tokens">access_tokens</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>access_tokens Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>token</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_used</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.account-data">account_data</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>account_data Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>account_data_type</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>account_data_stream_id <i>user_id, stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.account-data-max-stream-id">account_data_max_stream_id</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>account_data_max_stream_id Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>lock</td>
<td>character(1)</td>
<td><i>
UNIQUE
NOT NULL
DEFAULT &#39;X&#39;::bpchar
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>account_data_max_stream_id Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>private_user_data_max_stream_id_lock_check</td>
<td>CHECK ((lock = &#39;X&#39;::bpchar))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.application-services">application_services</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>application_services Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>token</td>
<td>text</td>
<td><i>
UNIQUE
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>hs_token</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sender</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<div class="fk_schemas">
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.application-services-regex">application_services_regex</a></li>
</ul>
</div>
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.application-services-regex">application_services_regex</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>application_services_regex Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.application-services">application_services.id</a>
</td>
<td>as_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>namespace</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>regex</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.application-services-state">application_services_state</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>application_services_state Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>as_id</td>
<td>text</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state</td>
<td>character varying(5)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_txn</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.application-services-txns">application_services_txns</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>application_services_txns Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>as_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>txn_id</td>
<td>integer</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_ids</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>application_services_txns_id <i>as_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.applied-module-schemas">applied_module_schemas</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>applied_module_schemas Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>module_name</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>file</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.applied-schema-deltas">applied_schema_deltas</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>applied_schema_deltas Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>version</td>
<td>integer</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>file</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.appservice-room-list">appservice_room_list</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>appservice_room_list Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>appservice_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>network_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.appservice-stream-position">appservice_stream_position</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>appservice_stream_position Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>lock</td>
<td>character(1)</td>
<td><i>
UNIQUE
NOT NULL
DEFAULT &#39;X&#39;::bpchar
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_ordering</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>appservice_stream_position Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>appservice_stream_position_lock_check</td>
<td>CHECK ((lock = &#39;X&#39;::bpchar))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.background-updates">background_updates</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>background_updates Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>update_name</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>progress_json</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>depends_on</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.blocked-rooms">blocked_rooms</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>blocked_rooms Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.cache-invalidation-stream">cache_invalidation_stream</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>cache_invalidation_stream Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>cache_func</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>keys</td>
<td>text[]</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>invalidation_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>cache_invalidation_stream_id <i>stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.current-state-delta-stream">current_state_delta_stream</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>current_state_delta_stream Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state_key</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>prev_event_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>current_state_delta_stream_idx <i>stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.current-state-events">current_state_events</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>current_state_events Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state_key</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>current_state_events_member_index <i>state_key) WHERE (type = 'm.room.member'::text</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.current-state-resets">current_state_resets</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>current_state_resets Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_stream_ordering</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.deleted-pushers">deleted_pushers</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>deleted_pushers Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>app_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>pushkey</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>deleted_pushers_stream_id <i>stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.destinations">destinations</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>destinations Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>destination</td>
<td>text</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>retry_last_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>retry_interval</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-federation-inbox">device_federation_inbox</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_federation_inbox Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>origin</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>message_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>received_ts</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_federation_inbox_sender_id <i>origin, message_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-federation-outbox">device_federation_outbox</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_federation_outbox Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>destination</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>queued_ts</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>messages_json</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_federation_outbox_destination_id <i>destination, stream_id</i></li>
<li>device_federation_outbox_id <i>stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-inbox">device_inbox</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_inbox Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>message_json</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_inbox_stream_id_user_id <i>stream_id, user_id</i></li>
<li>device_inbox_user_stream_id <i>user_id, device_id, stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-lists-outbound-last-success">device_lists_outbound_last_success</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_lists_outbound_last_success Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>destination</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_lists_outbound_last_success_idx <i>destination, user_id, stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-lists-outbound-pokes">device_lists_outbound_pokes</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_lists_outbound_pokes Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>destination</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sent</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ts</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_lists_outbound_pokes_id <i>destination, stream_id</i></li>
<li>device_lists_outbound_pokes_stream <i>stream_id</i></li>
<li>device_lists_outbound_pokes_user <i>destination, user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-lists-remote-cache">device_lists_remote_cache</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_lists_remote_cache Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_lists_remote_cache_id <i>user_id, device_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-lists-remote-extremeties">device_lists_remote_extremeties</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_lists_remote_extremeties Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_lists_remote_extremeties_id <i>user_id, stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-lists-stream">device_lists_stream</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_lists_stream Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>device_lists_stream_id <i>stream_id, user_id</i></li>
<li>device_lists_stream_user_id <i>user_id, device_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.device-max-stream-id">device_max_stream_id</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>device_max_stream_id Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.devices">devices</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>devices Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>display_name</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.e2e-device-keys-json">e2e_device_keys_json</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>e2e_device_keys_json Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>ts_added_ms</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_json</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.e2e-one-time-keys-json">e2e_one_time_keys_json</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>e2e_one_time_keys_json Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>algorithm</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>ts_added_ms</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_json</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.e2e-room-keys">e2e_room_keys</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>e2e_room_keys Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>session_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>version</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>first_message_index</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>forwarded_count</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_verified</td>
<td>boolean</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>session_data</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.e2e-room-keys-versions">e2e_room_keys_versions</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>e2e_room_keys_versions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>version</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>algorithm</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>auth_data</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.erased-users">erased_users</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>erased_users Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-auth">event_auth</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_auth Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>auth_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>evauth_edges_id <i>event_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-backward-extremities">event_backward_extremities</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_backward_extremities Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>ev_b_extrem_id <i>event_id</i></li>
<li>ev_b_extrem_room <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-content-hashes">event_content_hashes</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_content_hashes Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>algorithm</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>hash</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-destinations">event_destinations</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_destinations Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>destination</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>delivered_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-edge-hashes">event_edge_hashes</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_edge_hashes Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>prev_event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>algorithm</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>hash</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-edges">event_edges</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_edges Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>prev_event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_state</td>
<td>boolean</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>ev_edges_id <i>event_id</i></li>
<li>ev_edges_prev_id <i>prev_event_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-forward-extremities">event_forward_extremities</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_forward_extremities Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>ev_extrem_id <i>event_id</i></li>
<li>ev_extrem_room <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-forward-extremities-bak">event_forward_extremities_bak</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_forward_extremities_bak Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-json">event_json</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_json Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>internal_metadata</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>json</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>event_json_room_id <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-push-actions">event_push_actions</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_push_actions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>profile_tag</td>
<td>character varying(32)</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>actions</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>topological_ordering</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_ordering</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>notif</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>highlight</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>event_push_actions_highlights_index <i>user_id, room_id, topological_ordering, stream_ordering) WHERE (highlight = 1</i></li>
<li>event_push_actions_rm_tokens <i>user_id, room_id, topological_ordering, stream_ordering</i></li>
<li>event_push_actions_room_id_user_id <i>room_id, user_id</i></li>
<li>event_push_actions_stream_ordering <i>stream_ordering, user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-push-actions-staging">event_push_actions_staging</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_push_actions_staging Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>actions</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>notif</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>highlight</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>event_push_actions_staging_id <i>event_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-push-summary">event_push_summary</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_push_summary Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>notif_count</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_ordering</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>event_push_summary_user_rm <i>user_id, room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-push-summary-stream-ordering">event_push_summary_stream_ordering</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_push_summary_stream_ordering Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>lock</td>
<td>character(1)</td>
<td><i>
UNIQUE
NOT NULL
DEFAULT &#39;X&#39;::bpchar
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_ordering</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>event_push_summary_stream_ordering Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>event_push_summary_stream_ordering_lock_check</td>
<td>CHECK ((lock = &#39;X&#39;::bpchar))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-reference-hashes">event_reference_hashes</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_reference_hashes Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>algorithm</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>hash</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>event_reference_hashes_id <i>event_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-reports">event_reports</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_reports Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>received_ts</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>reason</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-search">event_search</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_search Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sender</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>vector</td>
<td>tsvector</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>origin_server_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_ordering</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>event_search_ev_ridx <i>room_id</i></li>
<li>event_search_fts_idx <i>vector</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-signatures">event_signatures</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_signatures Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>signature_name</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>signature</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-to-state-groups">event_to_state_groups</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_to_state_groups Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state_group</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.event-to-state-groups-to-delete">event_to_state_groups_to_delete</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>event_to_state_groups_to_delete Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.events">events</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>events Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_ordering</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>topological_ordering</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>unrecognized_keys</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>processed</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>outlier</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>depth</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>origin_server_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>received_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sender</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>contains_url</td>
<td>boolean</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>events_order_room <i>room_id, topological_ordering, stream_ordering</i></li>
<li>events_room_stream <i>room_id, stream_ordering</i></li>
<li>events_ts <i>origin_server_ts, stream_ordering</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.ex-outlier-stream">ex_outlier_stream</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>ex_outlier_stream Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_stream_ordering</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>state_group</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.federation-stream-position">federation_stream_position</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>federation_stream_position Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.feedback">feedback</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>feedback Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>feedback_type</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>target_event_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>sender</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-attestations-remote">group_attestations_remote</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_attestations_remote Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>valid_until_ms</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>attestation_json</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>group_attestations_remote_g_idx <i>group_id, user_id</i></li>
<li>group_attestations_remote_u_idx <i>user_id</i></li>
<li>group_attestations_remote_v_idx <i>valid_until_ms</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-attestations-renewals">group_attestations_renewals</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_attestations_renewals Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>valid_until_ms</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>group_attestations_renewals_g_idx <i>group_id, user_id</i></li>
<li>group_attestations_renewals_u_idx <i>user_id</i></li>
<li>group_attestations_renewals_v_idx <i>valid_until_ms</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-invites">group_invites</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_invites Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>group_invites_u_idx <i>user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-roles">group_roles</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_roles Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>role_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>profile</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-room-categories">group_room_categories</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_room_categories Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>category_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>profile</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-rooms">group_rooms</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_rooms Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>group_rooms_r_idx <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-summary-roles">group_summary_roles</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_summary_roles Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>role_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>role_order</td>
<td>bigint</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>group_summary_roles Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>group_summary_roles_role_order_check</td>
<td>CHECK ((role_order &gt; 0))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-summary-room-categories">group_summary_room_categories</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_summary_room_categories Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>category_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>cat_order</td>
<td>bigint</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>group_summary_room_categories Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>group_summary_room_categories_cat_order_check</td>
<td>CHECK ((cat_order &gt; 0))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-summary-rooms">group_summary_rooms</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_summary_rooms Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>category_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_order</td>
<td>bigint</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>group_summary_rooms Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>group_summary_rooms_room_order_check</td>
<td>CHECK ((room_order &gt; 0))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-summary-users">group_summary_users</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_summary_users Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>role_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_order</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>group_summary_users_g_idx <i>group_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.group-users">group_users</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>group_users Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_admin</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>group_users_u_idx <i>user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.groups">groups</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>groups Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>name</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>avatar_url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>short_description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>long_description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>join_policy</td>
<td>text</td>
<td><i>
NOT NULL
DEFAULT &#39;invite&#39;::text
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.guest-access">guest_access</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>guest_access Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>guest_access</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.history-visibility">history_visibility</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>history_visibility Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>history_visibility</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.local-group-membership">local_group_membership</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>local_group_membership Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_admin</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>membership</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_publicised</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>local_group_membership_g_idx <i>group_id</i></li>
<li>local_group_membership_u_idx <i>user_id, group_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.local-group-updates">local_group_updates</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>local_group_updates Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>group_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.local-invites">local_invites</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>local_invites Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>inviter</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>invitee</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>locally_rejected</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>replaced_by</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>local_invites_for_user_idx <i>invitee, locally_rejected, replaced_by, room_id</i></li>
<li>local_invites_id <i>stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.local-media-repository">local_media_repository</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>local_media_repository Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>media_id</td>
<td>text</td>
<td><i>
UNIQUE
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>media_type</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>media_length</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>created_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>upload_name</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>quarantined_by</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>url_cache</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_access_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>local_media_repository_url_idx <i>created_ts) WHERE (url_cache IS NOT NULL</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.local-media-repository-thumbnails">local_media_repository_thumbnails</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>local_media_repository_thumbnails Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>media_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>thumbnail_width</td>
<td>integer</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>thumbnail_height</td>
<td>integer</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>thumbnail_type</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>thumbnail_method</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>thumbnail_length</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>local_media_repository_thumbnails_media_id <i>media_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.local-media-repository-url-cache">local_media_repository_url_cache</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>local_media_repository_url_cache Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>response_code</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>etag</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>expires_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>og</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>media_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>download_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>local_media_repository_url_cache_by_url_download_ts <i>url, download_ts</i></li>
<li>local_media_repository_url_cache_expires_idx <i>expires_ts</i></li>
<li>local_media_repository_url_cache_media_idx <i>media_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.monthly-active-users">monthly_active_users</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>monthly_active_users Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>timestamp</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>monthly_active_users_time_stamp <i>"timestamp"</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.open-id-tokens">open_id_tokens</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>open_id_tokens Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>token</td>
<td>text</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ts_valid_until_ms</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>open_id_tokens_ts_valid_until_ms <i>ts_valid_until_ms</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.port-from-sqlite3">port_from_sqlite3</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>port_from_sqlite3 Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>table_name</td>
<td>character varying(100)</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>forward_rowid</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>backward_rowid</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.presence">presence</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>presence Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state</td>
<td>character varying(20)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>status_msg</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>mtime</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.presence-allow-inbound">presence_allow_inbound</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>presence_allow_inbound Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>observed_user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>observer_user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.presence-list">presence_list</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>presence_list Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>observed_user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>accepted</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>presence_list_user_id <i>user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.presence-stream">presence_stream</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>presence_stream Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>state</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_active_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_federation_update_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_user_sync_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>status_msg</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>currently_active</td>
<td>boolean</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>presence_stream_id <i>stream_id, user_id</i></li>
<li>presence_stream_user_id <i>user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.profiles">profiles</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>profiles Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>displayname</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>avatar_url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.public-room-list-stream">public_room_list_stream</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>public_room_list_stream Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>visibility</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>appservice_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>network_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>public_room_list_stream_idx <i>stream_id</i></li>
<li>public_room_list_stream_rm_idx <i>room_id, stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.push-rules">push_rules</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>push_rules Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_name</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>rule_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>priority_class</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>priority</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>conditions</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>actions</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>push_rules_user_name <i>user_name</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.push-rules-enable">push_rules_enable</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>push_rules_enable Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_name</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>rule_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>enabled</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>push_rules_enable_user_name <i>user_name</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.push-rules-stream">push_rules_stream</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>push_rules_stream Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>event_stream_ordering</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>rule_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>op</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>priority_class</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>priority</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>conditions</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>actions</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>push_rules_stream_id <i>stream_id</i></li>
<li>push_rules_stream_user_stream_id <i>user_id, stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.pusher-throttle">pusher_throttle</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>pusher_throttle Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>pusher</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_sent_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>throttle_ms</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.pushers">pushers</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>pushers Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_name</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>access_token</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>profile_tag</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>kind</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>app_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>app_display_name</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_display_name</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>pushkey</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ts</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>lang</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>data</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_stream_ordering</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_success</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>failing_since</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.ratelimit-override">ratelimit_override</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>ratelimit_override Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>messages_per_second</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>burst_count</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.receipts-graph">receipts_graph</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>receipts_graph Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>receipt_type</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>event_ids</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>data</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.receipts-linearized">receipts_linearized</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>receipts_linearized Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>receipt_type</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>data</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>receipts_linearized_id <i>stream_id</i></li>
<li>receipts_linearized_room_stream <i>room_id, stream_id</i></li>
<li>receipts_linearized_user <i>user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.received-transactions">received_transactions</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>received_transactions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>transaction_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>origin</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>response_code</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>response_json</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>has_been_referenced</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>received_transactions_ts <i>ts</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.redactions">redactions</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>redactions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>redacts</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>redactions_redacts <i>redacts</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.rejections">rejections</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>rejections Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>reason</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_check</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.remote-media-cache">remote_media_cache</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>remote_media_cache Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>media_origin</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>media_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>media_type</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>created_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>upload_name</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>media_length</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>filesystem_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_access_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>quarantined_by</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.remote-media-cache-thumbnails">remote_media_cache_thumbnails</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>remote_media_cache_thumbnails Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>media_origin</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>media_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>thumbnail_width</td>
<td>integer</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>thumbnail_height</td>
<td>integer</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>thumbnail_method</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>thumbnail_type</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>thumbnail_length</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>filesystem_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.remote-profile-cache">remote_profile_cache</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>remote_profile_cache Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>displayname</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>avatar_url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_check</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>remote_profile_cache_time <i>last_check</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-account-data">room_account_data</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_account_data Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>account_data_type</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>room_account_data_stream_id <i>user_id, stream_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-alias-servers">room_alias_servers</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_alias_servers Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_alias</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>server</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>room_alias_servers_alias <i>room_alias</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-aliases">room_aliases</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_aliases Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_alias</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>creator</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>room_aliases_id <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-depth">room_depth</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_depth Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>min_depth</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>room_depth_room <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-hosts">room_hosts</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_hosts Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>host</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-memberships">room_memberships</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_memberships Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sender</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>membership</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>forgotten</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>display_name</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>avatar_url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>room_memberships_room_id <i>room_id</i></li>
<li>room_memberships_user_id <i>user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-names">room_names</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_names Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>name</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>room_names_room_id <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-tags">room_tags</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_tags Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>tag</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.room-tags-revisions">room_tags_revisions</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>room_tags_revisions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.rooms">rooms</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>rooms Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_public</td>
<td>boolean</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>creator</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>public_room_index <i>is_public</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.schema-version">schema_version</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>schema_version Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>lock</td>
<td>character(1)</td>
<td><i>
UNIQUE
NOT NULL
DEFAULT &#39;X&#39;::bpchar
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>version</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>upgraded</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>schema_version Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>schema_version_lock_check</td>
<td>CHECK ((lock = &#39;X&#39;::bpchar))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.sent-transactions">sent_transactions</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>sent_transactions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>transaction_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>destination</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>response_code</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>response_json</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>sent_transaction_txn_id <i>transaction_id</i></li>
<li>sent_transactions_ts <i>ts</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.server-keys-json">server_keys_json</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>server_keys_json Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>server_name</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>from_server</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ts_added_ms</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>ts_valid_until_ms</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_json</td>
<td>bytea</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.server-signature-keys">server_signature_keys</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>server_signature_keys Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>server_name</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>from_server</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ts_added_ms</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>verify_key</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.server-tls-certificates">server_tls_certificates</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>server_tls_certificates Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>server_name</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>fingerprint</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>from_server</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ts_added_ms</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>tls_certificate</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.state-events">state_events</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>state_events Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state_key</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>prev_state</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.state-forward-extremities">state_forward_extremities</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>state_forward_extremities Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state_key</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>st_extrem_keys <i>room_id, type, state_key</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.state-group-edges">state_group_edges</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>state_group_edges Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>state_group</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>prev_state_group</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>state_group_edges_idx <i>state_group</i></li>
<li>state_group_edges_prev_idx <i>prev_state_group</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.state-groups">state_groups</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>state_groups Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>bigint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.state-groups-state">state_groups_state</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>state_groups_state Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>state_group</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state_key</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>state_groups_state_id <i>state_group</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.stats-reporting">stats_reporting</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>stats_reporting Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>reported_stream_token</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>reported_time</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.stream-ordering-to-exterm">stream_ordering_to_exterm</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>stream_ordering_to_exterm Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>stream_ordering</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>stream_ordering_to_exterm_idx <i>stream_ordering</i></li>
<li>stream_ordering_to_exterm_rm_idx <i>room_id, stream_ordering</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.threepid-guest-access-tokens">threepid_guest_access_tokens</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>threepid_guest_access_tokens Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>medium</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>address</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>guest_access_token</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>first_inviter</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.topics">topics</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>topics Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>event_id</td>
<td>text</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>topic</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>topics_room_id <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.transaction-id-to-pdu">transaction_id_to_pdu</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>transaction_id_to_pdu Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>transaction_id</td>
<td>integer</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>destination</td>
<td>text</td>
<td><i>
UNIQUE#1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>pdu_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>pdu_origin</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>transaction_id_to_pdu_dest <i>destination</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-daily-visits">user_daily_visits</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>user_daily_visits Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>timestamp</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>user_daily_visits_ts_idx <i>"timestamp"</i></li>
<li>user_daily_visits_uts_idx <i>user_id, "timestamp"</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-directory">user_directory</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>user_directory Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>display_name</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>avatar_url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>user_directory_room_idx <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-directory-search">user_directory_search</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>user_directory_search Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>vector</td>
<td>tsvector</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>user_directory_search_fts_idx <i>vector</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-directory-stream-pos">user_directory_stream_pos</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>user_directory_stream_pos Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>lock</td>
<td>character(1)</td>
<td><i>
UNIQUE
NOT NULL
DEFAULT &#39;X&#39;::bpchar
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>stream_id</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<p>&nbsp;</p>
<table class="constraints" width="100%" cellspacing="0" cellpadding="3">
<caption>user_directory_stream_pos Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<tr class="tr0">
<td>user_directory_stream_pos_lock_check</td>
<td>CHECK ((lock = &#39;X&#39;::bpchar))</td>
</tr>
</table>
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-filters">user_filters</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>user_filters Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>filter_id</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>filter_json</td>
<td>bytea</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>user_filters_by_user_id_filter_id <i>user_id, filter_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-ips">user_ips</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>user_ips Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>access_token</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>device_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ip</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_agent</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_seen</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>user_ips_last_seen <i>user_id, last_seen</i></li>
<li>user_ips_last_seen_only <i>last_seen</i></li>
<li>user_ips_user_ip <i>user_id, access_token, ip</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-threepids">user_threepids</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>user_threepids Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>medium</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>address</td>
<td>text</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>validated_at</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_at</td>
<td>bigint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>user_threepids_medium_address <i>medium, address</i></li>
<li>user_threepids_user_id <i>user_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users">users</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>users Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>name</td>
<td>text</td>
<td><i>
UNIQUE
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>password_hash</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>creation_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>admin</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>upgrade_ts</td>
<td>bigint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_guest</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>appservice_id</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>consent_version</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>consent_server_notice_sent</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>users_creation_ts <i>creation_ts</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-in-public-rooms">users_in_public_rooms</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>users_in_public_rooms Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>users_in_public_rooms_room_idx <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-pending-deactivation">users_pending_deactivation</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>users_pending_deactivation Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-who-share-rooms">users_who_share_rooms</a>
</h2>
<table class="schema" width="100%" cellspacing="0" cellpadding="3">
<caption>users_who_share_rooms Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>other_user_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_id</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>share_private</td>
<td>boolean</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<ul class="indexes">
<!-- Indexes -->
<li>users_who_share_rooms_o_idx <i>other_user_id</i></li>
<li>users_who_share_rooms_r_idx <i>room_id</i></li>
</ul>
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<!-- We've gone through the table structure, now lets take a look at user functions -->
<p class="w3ref">Generated by <a href="http://github.com/cbbrowne/autodoc/">PostgreSQL Autodoc</a></p>
<p class="w3ref"><a href="http://validator.w3.org/check/referer">W3C HTML 4.01 Strict</a></p>
</body></html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment