_memory

Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/

Custom SQL query returning 11 rows (hide)

typenametbl_namerootpagesql
table item item 2 CREATE TABLE item ( item_record_num BIGINT, bib_record_num BIGINT, creation_date TEXT, record_last_updated TEXT, barcode TEXT, agency_code_num BIGINT, location_code TEXT, checkout_statistic_group_code_num BIGINT, checkin_statistics_group_code_num BIGINT, checkout_date TEXT, due_date TEXT, patron_branch_code TEXT, last_checkout_date TEXT, last_checkin_date TEXT, checkout_total BIGINT, renewal_total BIGINT, isbn TEXT, item_format TEXT, item_status_code TEXT, price_cents BIGINT, item_callnumber TEXT )
table bib bib 186956 CREATE TABLE bib ( bib_record_num BIGINT, creation_date TEXT, record_last_updated TEXT, isbn TEXT, best_author TEXT, best_title TEXT, publisher TEXT, publish_year FLOAT, bib_level_callnumber TEXT, indexed_subjects TEXT )
table record_metadata record_metadata 577312 CREATE TABLE record_metadata ( id BIGINT, record_type_code TEXT, record_num BIGINT, creation_date_gmt DATETIME, campus_code TEXT, agency_code_num BIGINT, record_last_updated_gmt DATETIME )
table bib_record_item_record_link bib_record_item_record_link 1043250 CREATE TABLE bib_record_item_record_link ( id INTEGER, bib_record_id BIGINT, item_record_id INTEGER, items_display_order INTEGER, bibs_display_order INTEGER )
table phrase_entry phrase_entry 1082034 CREATE TABLE phrase_entry ( id INTEGER, record_id INTEGER, index_tag TEXT, varfield_type_code TEXT, occurrence INTEGER, is_permuted BOOLEAN, type2 INTEGER, type3 TEXT, index_entry TEXT, insert_title TEXT, phrase_rule_rule_num INTEGER, phrase_rule_operation TEXT, phrase_rule_subfield_list TEXT, original_content TEXT, parent_record_id INTEGER, insert_title_tag TEXT, insert_title_occ INTEGER, CHECK (is_permuted IN (0, 1)) )
table branch_name branch_name 1627150 CREATE TABLE branch_name ( branch_id INTEGER, name TEXT, iii_language_id INTEGER )
table branch branch 1627154 CREATE TABLE branch ( id INTEGER, address TEXT, email_source TEXT, email_reply_to TEXT, address_latitude TEXT, address_longitude TEXT, code_num INTEGER )
table country_property_myuser country_property_myuser 1627159 CREATE TABLE country_property_myuser ( code TEXT, display_order INTEGER, name TEXT )
table itype_property_myuser itype_property_myuser 1627162 CREATE TABLE itype_property_myuser ( code INTEGER, display_order INTEGER, itype_property_category_id TEXT, physical_format_id INTEGER, target_audience_id TEXT, name TEXT )
table location location 1627106 CREATE TABLE location ( id INTEGER, code INTEGER, branch_code_num INTEGER, parent_location_code INTEGER, is_public BOOLEAN, is_requestable BOOLEAN, CHECK (is_public IN (0, 1)), CHECK (is_requestable IN (0, 1)) )
table location_name location_name 1627163 CREATE TABLE location_name ( location_id INTEGER, name TEXT, iii_language_id INTEGER )