User Tools

Site Tools


newdevs:db:schemas

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
newdevs:db:schemas [2023/01/18 17:40] tmccannanewdevs:db:schemas [2023/12/28 14:52] – [Additional Resources] aneiman
Line 2: Line 2:
 ====== Database Schemas ====== ====== Database Schemas ======
  
-  * [[https://docs.evergreen-ils.org/3.2_schema/|Evergreen Database Schema (3.2)]]+===== 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.txt · Last modified: 2024/06/13 10:27 by sleary

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.