logo
ExamplesEditorPricingDocs
37.1kSign in

Public library catalog and circulation database schema

How a public library models its data: works, editions and barcoded copies, branches and holdings, members, loans with renewals, a positioned hold queue, fines and payments, and inter-branch transfers.

Library Catalog ER diagram

Public library catalog and circulation database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 works idBIGINT uniform_titleVARCHAR original_languageCHAR first_published_y…SMALLINT work_typeVARCHAR subject_headingsTEXT summaryTEXT editions idBIGINT work_idBIGINT isbn13CHAR titleVARCHAR publisherVARCHAR published_yearSMALLINT edition_statementVARCHAR language_codeCHAR formatVARCHAR page_countINTEGER cover_image_urlVARCHAR contributors idBIGINT authority_nameVARCHAR display_nameVARCHAR birth_yearSMALLINT death_yearSMALLINT external_authorit…VARCHAR work_contributors work_idBIGINT contributor_idBIGINT roleVARCHAR ordinalSMALLINT branches idBIGINT codeVARCHAR nameVARCHAR address_lineVARCHAR postcodeVARCHAR phoneVARCHAR opens_atTIME closes_atTIME is_openBOOLEAN copies idBIGINT edition_idBIGINT barcodeVARCHAR home_branch_idBIGINT current_branch_idBIGINT shelf_locationVARCHAR statusVARCHAR acquired_onDATE cost_minorINTEGER currency_codeCHAR condition_noteVARCHAR is_reference_onlyBOOLEAN members idBIGINT library_card_numb…VARCHAR full_nameVARCHAR emailVARCHAR phoneVARCHAR date_of_birthDATE home_branch_idBIGINT membership_typeVARCHAR joined_onDATE expires_onDATE borrowing_blockedBOOLEAN loans idBIGINT copy_idBIGINT member_idBIGINT checkout_branch_idBIGINT return_branch_idBIGINT checked_out_atDATETIME due_onDATE returned_atDATETIME renewal_countSMALLINT renewal_limitSMALLINT stateVARCHAR loan_renewals idBIGINT loan_idBIGINT renewal_numberSMALLINT renewed_atDATETIME previous_due_onDATE new_due_onDATE channelVARCHAR granted_byVARCHAR holds idBIGINT member_idBIGINT work_idBIGINT edition_idBIGINT pickup_branch_idBIGINT placed_atDATETIME queue_positionINTEGER stateVARCHAR fulfilled_copy_idBIGINT ready_atDATETIME expires_onDATE suspended_untilDATE transfers idBIGINT copy_idBIGINT from_branch_idBIGINT to_branch_idBIGINT hold_idBIGINT reasonVARCHAR sent_atDATETIME received_atDATETIME courier_runVARCHAR fines idBIGINT member_idBIGINT loan_idBIGINT charge_typeVARCHAR amount_minorINTEGER currency_codeCHAR assessed_onDATE days_overdueINTEGER stateVARCHAR waived_reasonVARCHAR fine_payments idBIGINT fine_idBIGINT amount_minorINTEGER currency_codeCHAR methodVARCHAR paid_atDATETIME received_branch_idBIGINT external_referenceVARCHAR

Related database schemas

PostgreSQL
Education

Coursera-style online course platform database schema

How a MOOC platform models its data: versioned course content, dated session runs, an outline tree of modules and lectures, quizzes drawn from question banks, peer-graded assignments with rubric criteria, entitlements and certificates.

PostgreSQL
Education

Duolingo-style language learning database schema

How a gamified language app models its data: directional courses, a skill tree with unlock rules, lessons and exercise items, crown levels, a per-word spaced-repetition schedule, streaks with freezes, hearts and weekly leagues.

PostgreSQL
Commerce

E-commerce store database schema

A production-shaped e-commerce schema: products with variants, inventory per location, carts, orders with snapshotted line items, payments and shipments. Open it in the editor or export SQL for six dialects.

MySQL
Education

Quiz and assessment engine database schema

A quiz engine that handles four question types at once: reusable question banks, draw rules and randomised papers, typed answer keys, per-question responses, partial credit, negative marking and time limits.