Evergreen Database Reference
Complete reference for the Evergreen ILS PostgreSQL database: 506 tables, 137 views, and 881 functions across 31 schemas.
Generated 2026-04-16. Do not edit — regenerate with make generate.
-
Write Safety Reference — all tables with data-modifying triggers
Schemas
| Schema | Purpose | Tables | Views | Functions |
|---|---|---|---|---|
Acquisitions — purchase orders, invoicing, funding, and provider management. |
66 |
21 |
25 |
|
Circulation — checkouts, holds, transits, and patron actions. |
39 |
12 |
48 |
|
Automation/Events — event definitions, hooks, and reactor/validator configurations. |
13 |
0 |
2 |
|
Users/Organizations — patrons, staff, org units, and user settings. |
41 |
2 |
49 |
|
Items/Copies — copy management, call numbers, copy locations, and status. |
31 |
2 |
48 |
|
Audit Trails — historical snapshots of key tables (no foreign keys by design). |
11 |
11 |
22 |
|
Authority Records — MARC authority control and heading management. |
16 |
7 |
56 |
|
Bibliographic Records — bib records, record entries, and TCN management. |
5 |
0 |
15 |
|
Reservations — resource booking and reservation management. |
7 |
0 |
0 |
|
Configuration — system-wide configuration tables (largest schema). |
91 |
9 |
9 |
|
Buckets/Collections — patron and staff bucket groupings. |
24 |
0 |
2 |
|
Core System — system-level functions (no tables). |
0 |
0 |
90 |
|
Extended Reporting — supplemental reporter data. |
1 |
3 |
0 |
|
Search/Indexing — metabib field entries, search vectors, and facets. |
23 |
11 |
27 |
|
Financial — billings, payments, and transaction summaries. |
19 |
25 |
12 |
|
OAI-PMH Protocol — Open Archives Initiative protocol support. |
0 |
2 |
4 |
|
Offline Mode — offline circulation session staging. |
2 |
0 |
0 |
|
REST API — OpenAPI endpoint and parameter definitions. |
22 |
0 |
5 |
|
Permissions — permission definitions, groups, and grant management. |
10 |
0 |
18 |
|
Public Schema — utility functions accessible without schema prefix. |
0 |
0 |
297 |
|
Query Builder — stored query/filter builder components. |
13 |
16 |
0 |
|
Ratings — bibliographic record popularity rating. |
3 |
1 |
26 |
|
Reporting — reporter template and schedule management. |
8 |
13 |
9 |
|
Search Config — search filter configurations. |
3 |
1 |
25 |
|
Serials — serial publication and issuance management. |
17 |
1 |
2 |
|
SIP Protocol — SIP2 protocol configuration. |
6 |
0 |
0 |
|
Import Staging — intermediate staging tables for bulk import. |
6 |
0 |
1 |
|
Statistics — statistical tracking (no tables). |
0 |
0 |
0 |
|
Output Formats — UNAPI output format functions. |
1 |
0 |
32 |
|
URL Verification — URL integrity checking. |
5 |
0 |
3 |
|
Import/Export — batch import/export queue and processing. |
23 |
0 |
54 |