User Tools

Site Tools


newdevs:db:schemas

This is an old revision of the document!


New Developers Working Group

Database Schemas

Schema Descriptions

  • Config - catch-all for configuration / setup
  • Actor - users, org units, and their attributes
  • Permission - permissions and permission groups
  • Biblio - bib data and functions
  • Authority - authority data and functions
  • Serial - serials related tables
  • Asset - item and call number, mostly
  • Metabib - search data, mostly
  • Action - circ and hold state machine tables
  • Booking - booking/reservation state machine tables
  • Money - billing and payment tables and views
  • Action_trigger - A/T definitions, events, and output
  • Vandelay - import/export tables and functions
  • Acq - acquisitions data
  • Search - functions and search support tables
  • Container - buckets, carousels
  • Oai - views and functions supporting oai-pmh
  • Unapi - functions generating xml from data in other schemas
  • Query - back qstore service, holds structured data that can become arbitrary SQL
  • Offline - offline transactions and processing state thereof
  • Reporter - report templates, definitions, and scheduling tables
  • Rating - stores popularity badge definitions and bib ratings
  • Auditor - tables recording old versions of rows from many core tables

Additional Resources

Evergreen Conference Sessions

newdevs/db/schemas.1703793145.txt.gz · Last modified: 2023/12/28 14:52 by aneiman

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.