Differences

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

--- newdevs:db:schemas [2023/01/18 17:40] – tmccanna
+++ newdevs:db:schemas [2024/12/20 12:48] (current) – [Additional Resources] Added link to full list of schema docs. stompro
@@ Line 2: / Line 2: @@
 ====== 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://roganhamby.github.io/emeraldelephant/whatiswhere.html|What is Where in the Database? (Emerald Elephant)]]
+  * [[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]]
+  * [[dev:database_schemas|List of all existing Evergreen schema documentation.]]
+==== 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]]