bib_record

2,156,246 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cataloging_date_gmt (date)

Next page

CREATE TABLE [bib_record] (
   [id] INTEGER PRIMARY KEY,
   [record_id] INTEGER,
   [language_code] TEXT,
   [bcode1] TEXT,
   [bcode2] TEXT,
   [bcode3] TEXT,
   [country_code] TEXT,
   [index_change_count] INTEGER,
   [is_on_course_reserve] INTEGER,
   [is_right_result_exact] INTEGER,
   [allocation_rule_code] TEXT,
   [skip_num] INTEGER,
   [cataloging_date_gmt] TEXT,
   [marc_type_code] TEXT,
   [is_suppressed] INTEGER
);
CREATE INDEX [idx_bib_record_bcode1]
    ON [bib_record] ([bcode1]);
CREATE INDEX [idx_bib_record_bcode2]
    ON [bib_record] ([bcode2]);
CREATE INDEX [idx_bib_record_bcode3]
    ON [bib_record] ([bcode3]);
CREATE INDEX [idx_bib_record_country_code]
    ON [bib_record] ([country_code]);
CREATE INDEX [idx_bib_record_language_code]
    ON [bib_record] ([language_code]);
CREATE INDEX [idx_bib_record_record_id]
    ON [bib_record] ([record_id]);
CREATE INDEX [idx_bib_record_cataloging_date_gmt]
    ON [bib_record] ([cataloging_date_gmt]);