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
newdevs:db:schemas [2023/01/18 17:58] tmccannanewdevs:db:schemas [2023/12/28 14:52] (current) – [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]]   * [[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.1674082714.txt.gz · Last modified: 2023/01/18 17:58 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.