catalog_foreign_keys

16 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link database_name table_name id seq table from to on_update on_delete match
declaration250,app_access,0,0 declaration250 app_access 0 0 apps app_id id NO ACTION NO ACTION NONE
declaration250,app_csp_origins,0,0 declaration250 app_csp_origins 0 0 apps app_id id NO ACTION NO ACTION NONE
declaration250,app_revisions,0,0 declaration250 app_revisions 0 0 apps app_id id NO ACTION NO ACTION NONE
declaration250,app_sql_databases,0,0 declaration250 app_sql_databases 0 0 apps app_id id NO ACTION NO ACTION NONE
declaration250,app_user_state,0,0 declaration250 app_user_state 0 0 apps app_id id NO ACTION NO ACTION NONE
declaration250,catalog_columns,0,0 declaration250 catalog_columns 0 0 catalog_tables database_name database_name NO ACTION NO ACTION NONE
declaration250,catalog_columns,0,1 declaration250 catalog_columns 0 1 catalog_tables table_name table_name NO ACTION NO ACTION NONE
declaration250,catalog_columns,1,0 declaration250 catalog_columns 1 0 catalog_databases database_name database_name NO ACTION NO ACTION NONE
declaration250,catalog_foreign_keys,0,0 declaration250 catalog_foreign_keys 0 0 catalog_tables database_name database_name NO ACTION NO ACTION NONE
declaration250,catalog_foreign_keys,0,1 declaration250 catalog_foreign_keys 0 1 catalog_tables table_name table_name NO ACTION NO ACTION NONE
declaration250,catalog_foreign_keys,1,0 declaration250 catalog_foreign_keys 1 0 catalog_databases database_name database_name NO ACTION NO ACTION NONE
declaration250,catalog_indexes,0,0 declaration250 catalog_indexes 0 0 catalog_tables database_name database_name NO ACTION NO ACTION NONE
declaration250,catalog_indexes,0,1 declaration250 catalog_indexes 0 1 catalog_tables table_name table_name NO ACTION NO ACTION NONE
declaration250,catalog_indexes,1,0 declaration250 catalog_indexes 1 0 catalog_databases database_name database_name NO ACTION NO ACTION NONE
declaration250,catalog_tables,0,0 declaration250 catalog_tables 0 0 catalog_databases database_name database_name NO ACTION NO ACTION NONE
declaration250,catalog_views,0,0 declaration250 catalog_views 0 0 catalog_databases database_name database_name NO ACTION NO ACTION NONE

Advanced export

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

CSV options: 

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)
);