current_collection
Tables
bib
bib_record_num, bib_record_id, control_numbers, isbn_values, best_author, best_title, publisher, publish_year, bib_level_callnumber, indexed_subjects, genres, item_types, cataloging_date
2,143,526 rows
bib_record
id, record_id, language_code, bcode1, bcode2, bcode3, country_code, index_change_count, is_on_course_reserve, is_right_result_exact, allocation_rule_code, skip_num, cataloging_date_gmt, marc_type_code, is_suppressed
2,143,526 rows
bib_record_item_record_link
id, bib_record_id, bib_record_num, item_record_id, item_record_num, items_display_order, bibs_display_order
5,593,542 rows
branch
id, address, email_source, email_reply_to, address_latitude, address_longitude, code_num
52 rows
branch_locations
rowid, chpl_branch_location_name, code_num, address, latitude, longitude, global_plus_code
44 rows
circ_agg
transaction_day, stat_group_code_num, op_code, itype_code_num, item_location_code, loanrule_code_num, count_op_code, count_distinct_patrons, stat_group_name, branch_code_num, branch_name
1,707,271 rows
circ_leased_items
id, transaction_day, stat_group_code_num, stat_group_name, stat_group_location_code, stat_group_branch_name, op_code, application_name, due_date, item_record_id, item_record_num, barcode, bib_record_id, bib_record_num, volume_record_id, volume_record_num, itype_code_num, item_location_code, ptype_code, patron_home_library_code, patron_agency_code_num, loanrule_code_num
41,959 rows
hold
hold_id, bib_record_num, campus_code, record_type_on_hold, item_record_num, volume_record_num, placed_julianday, is_frozen, delay_days, location_code, expires_julianday, hold_status, is_ir, is_ill, pickup_location_code, ir_pickup_location_code, ir_print_name, ir_delivery_stop_name, is_ir_converted_request, patron_is_active, patron_ptype_code, patron_home_library_code, patron_mblock_code, patron_has_over_10usd_owed
135,979 rows
in_transit_data
item_record_num, location_code, itype_code_num, itype_name, item_message_code, item_call_number, barcode, best_title, best_author, publish_year, material_code, in_transit_timestamp, from_field, from_field_branch, to_field, to_branch_name, is_for_hold, too_long_date, in_transit_days
26,561 rows
item
item_record_num, item_record_id, bib_record_num, creation_date, record_last_updated, barcode, agency_code_num, location_code, checkout_statistic_group_code_num, checkin_statistics_group_code_num, checkout_date, due_date, patron_branch_code, last_checkout_date, last_checkin_date, checkout_total, renewal_total, item_format, item_status_code, price_cents, item_callnumber, volume_record_num, volume_record_statement
4,974,669 rows
item_message
item_barcode, campus_code, call_number, item_record_id, varfield_id, has_in_transit, in_transit_julianday, in_transit_days, transit_from, transit_to, has_in_transit_too_long, occ_num, field_content, publish_year, best_title, best_author, item_status_code, item_status_name, agency_code_num, location_code, itype_code_num, item_format, due_julianday, loanrule_code_num, checkout_julianday, renewal_count, overdue_count, overdue_julianday
37,834 rows
record_metadata
record_id, record_num, record_type_code, creation_julianday, record_last_updated_julianday, deletion_julianday
15,128,324 rows
volume_record
volume_record_id, volume_record_num, bib_record_id, bib_record_num, creation_julianday, volume_statement
341,845 rows
volume_record_item_record_link
id, volume_record_id, volume_record_num, item_record_id, item_record_num, items_display_order, volume_statement
535,912 rows
... and 1 hidden table
Views
- isbn_view
- duplicate_items_in_location_view
- location_view
- item_view
- branch_30_day_circ_view
- branch_location_view
- collection_value_branch_view
- hold_view
- hold_title_view
- leased_item_view
- ld_compare_view
- location_percent_checkout_view
- book_connections_view
- two_months_leased_item_view
- new_downloadable_book_view
- new_titles_view
- last_copy_view
- dup_at_location_view
- active_holds_view
- active_items_view
- item_in_transit_view
- circ_agg_branch_view
- duplicate_items_2ra_2rabi
- duplicate_items_3ra_2rabi
- collection_detail_view
- genre_view
- mat_item_agg_view
- pct_checked_out_location_view
- hold_ratio_view
- location_weeding_view
- location_weeding_main_view
Download SQLite DB: current_collection.db 5.5 GB