declaration250

Custom SQL query

Tables schema

app_access

id, app_id, action, subject_type, subject_id, allow, created_at, updated_at

0 rows

app_csp_origins

id, app_id, directive, origin, created_at, updated_at

0 rows

app_revisions

app_id, version, actor_id, name, description, html, is_private, sql_databases, stored_queries, csp_origins, changed_fields, created_at

1 row

app_sql_databases

app_id, database_name, created_at, updated_at

1 row

app_user_state

actor_id, app_id, last_accessed_at, pinned_at, access_count

1 row

apps

id, external, name, description, path, source, metadata, actor_id, is_private, stored_queries, current_version, deleted_at, deleted_actor_id, created_at, updated_at

1 row

catalog_columns

database_name, table_name, cid, name, type, notnull, default_value, is_pk, hidden

200 rows

catalog_databases

database_name, path, is_memory, schema_version

1 row

catalog_foreign_keys

database_name, table_name, id, seq, table, from, to, on_update, on_delete, match

16 rows

catalog_indexes

database_name, table_name, seq, name, unique, origin, partial

32 rows

catalog_tables

database_name, table_name, rootpage, sql

38 rows

catalog_views

database_name, view_name, rootpage, sql

0 rows

column_types

database_name, resource_name, column_name, column_type, config

0 rows

grievances

num, short_title, theme, text, plain_english

27 rows

grievances_fts

num, short_title, theme, text, plain_english, grievances_fts, rank

27 rows

metadata_columns

database_name, resource_name, column_name, key, value

0 rows

metadata_databases

database_name, key, value

0 rows

metadata_instance

key, value

0 rows

metadata_resources

database_name, resource_name, key, value

0 rows

queries

database_name, name, sql, title, description, description_html, options, parameters, is_write, is_private, is_trusted, source, owner_id, created_at, updated_at

0 rows

sections

id, section_order, section_key, heading, body

5 rows

signers

seq, name, state, birth_year, age_at_signing, birthplace, education, occupation

56 rows

signers_fts

seq, name, state, birthplace, education, occupation, signers_fts, rank

56 rows

... and 15 hidden tables