catalog_tables

38 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link database_name table_name rootpage sql
declaration250,app_access declaration250 app_access 75 CREATE TABLE app_access ( id INTEGER PRIMARY KEY, app_id TEXT REFERENCES apps(id), action TEXT NOT NULL, subject_type TEXT NOT NULL, subject_id TEXT, allow INTEGER NOT NULL DEFAULT 1, created_at TEXT NOT NULL, updated_at TEXT NOT NULL, CHECK (subject_type IN ('authenticated')), CHECK (allow IN (0, 1)) )
declaration250,app_csp_origins declaration250 app_csp_origins 80 CREATE TABLE app_csp_origins ( id INTEGER PRIMARY KEY, app_id TEXT NOT NULL REFERENCES apps(id), directive TEXT NOT NULL DEFAULT 'connect-src', origin TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL, CHECK (directive IN ('connect-src')), UNIQUE (app_id, directive, origin) )
declaration250,app_revisions declaration250 app_revisions 65 CREATE TABLE app_revisions ( app_id TEXT NOT NULL REFERENCES apps(id), version INTEGER NOT NULL, actor_id TEXT, name TEXT, description TEXT, html TEXT, is_private INTEGER, sql_databases TEXT, stored_queries TEXT, csp_origins TEXT, changed_fields TEXT NOT NULL DEFAULT '[]', created_at TEXT NOT NULL, PRIMARY KEY (app_id, version), CHECK (is_private IN (0, 1) OR is_private IS NULL) )
declaration250,app_sql_databases declaration250 app_sql_databases 77 CREATE TABLE app_sql_databases ( app_id TEXT NOT NULL REFERENCES apps(id), database_name TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL, PRIMARY KEY (app_id, database_name) )
declaration250,app_user_state declaration250 app_user_state 83 CREATE TABLE app_user_state ( actor_id TEXT NOT NULL, app_id TEXT NOT NULL REFERENCES apps(id), last_accessed_at TEXT, pinned_at TEXT, access_count INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (actor_id, app_id) )
declaration250,apps declaration250 apps 63 CREATE TABLE apps ( id TEXT PRIMARY KEY, external INTEGER NOT NULL DEFAULT 0, name TEXT NOT NULL, description TEXT NOT NULL DEFAULT '', path TEXT NOT NULL, source TEXT NOT NULL DEFAULT '', metadata TEXT NOT NULL DEFAULT '{}', actor_id TEXT, is_private INTEGER NOT NULL DEFAULT 1, stored_queries TEXT NOT NULL DEFAULT '[]', current_version INTEGER, deleted_at TEXT, deleted_actor_id TEXT, created_at TEXT NOT NULL, updated_at TEXT NOT NULL, CHECK (external IN (0, 1)), CHECK (is_private IN (0, 1)) )
declaration250,apps_fts declaration250 apps_fts 0 CREATE VIRTUAL TABLE apps_fts USING fts5(name, description, source, content='apps', content_rowid='rowid')
declaration250,apps_fts_config declaration250 apps_fts_config 74 CREATE TABLE 'apps_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID
declaration250,apps_fts_data declaration250 apps_fts_data 71 CREATE TABLE 'apps_fts_data'(id INTEGER PRIMARY KEY, block BLOB)
declaration250,apps_fts_docsize declaration250 apps_fts_docsize 73 CREATE TABLE 'apps_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)
declaration250,apps_fts_idx declaration250 apps_fts_idx 72 CREATE TABLE 'apps_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID
declaration250,catalog_columns declaration250 catalog_columns 36 CREATE TABLE catalog_columns ( database_name TEXT, table_name TEXT, cid INTEGER, name TEXT, type TEXT, "notnull" INTEGER, default_value TEXT, -- renamed from dflt_value is_pk INTEGER, -- renamed from pk hidden INTEGER, PRIMARY KEY (database_name, table_name, name), FOREIGN KEY (database_name) REFERENCES catalog_databases(database_name), FOREIGN KEY (database_name, table_name) REFERENCES catalog_tables(database_name, table_name) )
declaration250,catalog_databases declaration250 catalog_databases 30 CREATE TABLE catalog_databases ( database_name TEXT PRIMARY KEY, path TEXT, is_memory INTEGER, schema_version INTEGER )
declaration250,catalog_foreign_keys declaration250 catalog_foreign_keys 42 CREATE TABLE catalog_foreign_keys ( database_name TEXT, table_name TEXT, id INTEGER, seq INTEGER, "table" TEXT, "from" TEXT, "to" TEXT, on_update TEXT, on_delete TEXT, match TEXT, PRIMARY KEY (database_name, table_name, id, seq), FOREIGN KEY (database_name) REFERENCES catalog_databases(database_name), FOREIGN KEY (database_name, table_name) REFERENCES catalog_tables(database_name, table_name) )
declaration250,catalog_indexes declaration250 catalog_indexes 38 CREATE TABLE catalog_indexes ( database_name TEXT, table_name TEXT, seq INTEGER, name TEXT, "unique" INTEGER, origin TEXT, partial INTEGER, PRIMARY KEY (database_name, table_name, name), FOREIGN KEY (database_name) REFERENCES catalog_databases(database_name), FOREIGN KEY (database_name, table_name) REFERENCES catalog_tables(database_name, table_name) )
declaration250,catalog_tables declaration250 catalog_tables 32 CREATE TABLE catalog_tables ( database_name TEXT, table_name TEXT, rootpage INTEGER, sql TEXT, PRIMARY KEY (database_name, table_name), FOREIGN KEY (database_name) REFERENCES catalog_databases(database_name) )
declaration250,catalog_views declaration250 catalog_views 34 CREATE TABLE catalog_views ( database_name TEXT, view_name TEXT, rootpage INTEGER, sql TEXT, PRIMARY KEY (database_name, view_name), FOREIGN KEY (database_name) REFERENCES catalog_databases(database_name) )
declaration250,column_types declaration250 column_types 52 CREATE TABLE column_types ( database_name TEXT NOT NULL, resource_name TEXT NOT NULL, column_name TEXT NOT NULL, column_type TEXT NOT NULL, config TEXT, PRIMARY KEY (database_name, resource_name, column_name) )
declaration250,grievances declaration250 grievances 3 CREATE TABLE grievances( num integer primary key, short_title text, theme text, text text, plain_english text)
declaration250,grievances_fts declaration250 grievances_fts 0 CREATE VIRTUAL TABLE grievances_fts using fts5(num, short_title, theme, text, plain_english)
declaration250,grievances_fts_config declaration250 grievances_fts_config 10 CREATE TABLE 'grievances_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID
declaration250,grievances_fts_content declaration250 grievances_fts_content 8 CREATE TABLE 'grievances_fts_content'(id INTEGER PRIMARY KEY, c0, c1, c2, c3, c4)
declaration250,grievances_fts_data declaration250 grievances_fts_data 6 CREATE TABLE 'grievances_fts_data'(id INTEGER PRIMARY KEY, block BLOB)
declaration250,grievances_fts_docsize declaration250 grievances_fts_docsize 9 CREATE TABLE 'grievances_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)
declaration250,grievances_fts_idx declaration250 grievances_fts_idx 7 CREATE TABLE 'grievances_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID
declaration250,metadata_columns declaration250 metadata_columns 50 CREATE TABLE metadata_columns ( database_name text, resource_name text, column_name text, key text, value text, unique(database_name, resource_name, column_name, key) )
declaration250,metadata_databases declaration250 metadata_databases 46 CREATE TABLE metadata_databases ( database_name text, key text, value text, unique(database_name, key) )
declaration250,metadata_instance declaration250 metadata_instance 44 CREATE TABLE metadata_instance ( key text, value text, unique(key) )
declaration250,metadata_resources declaration250 metadata_resources 48 CREATE TABLE metadata_resources ( database_name text, resource_name text, key text, value text, unique(database_name, resource_name, key) )
declaration250,queries declaration250 queries 54 CREATE TABLE queries ( database_name TEXT NOT NULL, name TEXT NOT NULL, sql TEXT NOT NULL, title TEXT, description TEXT, description_html TEXT, options TEXT NOT NULL DEFAULT '{}', parameters TEXT NOT NULL DEFAULT '[]', is_write INTEGER NOT NULL DEFAULT 0 CHECK (is_write IN (0, 1)), is_private INTEGER NOT NULL DEFAULT 0 CHECK (is_private IN (0, 1)), is_trusted INTEGER NOT NULL DEFAULT 0 CHECK (is_trusted IN (0, 1)), source TEXT NOT NULL DEFAULT 'user', owner_id TEXT, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (database_name, name) )
declaration250,sections declaration250 sections 2 CREATE TABLE sections( id integer primary key, section_order integer, section_key text, heading text, body text)
declaration250,signers declaration250 signers 17 CREATE TABLE signers( seq integer primary key, name text, state text, birth_year integer, age_at_signing integer, birthplace text, education text, occupation text)
declaration250,signers_fts declaration250 signers_fts 0 CREATE VIRTUAL TABLE signers_fts using fts5(seq, name, state, birthplace, education, occupation)
declaration250,signers_fts_config declaration250 signers_fts_config 24 CREATE TABLE 'signers_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID
declaration250,signers_fts_content declaration250 signers_fts_content 22 CREATE TABLE 'signers_fts_content'(id INTEGER PRIMARY KEY, c0, c1, c2, c3, c4, c5)
declaration250,signers_fts_data declaration250 signers_fts_data 20 CREATE TABLE 'signers_fts_data'(id INTEGER PRIMARY KEY, block BLOB)
declaration250,signers_fts_docsize declaration250 signers_fts_docsize 23 CREATE TABLE 'signers_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)
declaration250,signers_fts_idx declaration250 signers_fts_idx 21 CREATE TABLE 'signers_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE catalog_tables (
    database_name TEXT,
    table_name TEXT,
    rootpage INTEGER,
    sql TEXT,
    PRIMARY KEY (database_name, table_name),
    FOREIGN KEY (database_name) REFERENCES catalog_databases(database_name)
);