User Tools

Site Tools


newdevs:db:schemas

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
newdevs:db:schemas [2023/01/18 16:46] – created tmccannanewdevs:db:schemas [2023/12/28 14:52] (current) – [Additional Resources] aneiman
Line 1: Line 1:
 **New Developers Working Group** **New Developers Working Group**
 ====== Database Schemas ====== ====== 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 =====
 +
 +  * [[https://olddocs.evergreen-ils.org/3.2_schema/|Evergreen Database Schema (3.2)]]
 +  * [[newdevs:db:schemas:3.10_schma|Evergreen Database Schema (3.10)]]
 +  * [[http://evergreen-ils.org/~denials/workshop.html#_evergreen_data_models_and_access|Evergreen Data Models and Access]]
 +
 +==== Evergreen Conference Sessions ====
 +  * [[https://htmlpreview.github.io/?https://github.com/Dyrcona/evergreen2019-preconference/blob/master/presentation.html|Cronscript.pm, Or How I Learned to Stop Worrying and Program the Evergreen Back End, by Jason Stephenson]]
 +
 +
newdevs/db/schemas.1674078362.txt.gz · Last modified: 2023/01/18 16:46 by tmccanna

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.