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.

Schemas

Schema Purpose Tables Views Functions

acq

Acquisitions — purchase orders, invoicing, funding, and provider management.

66

21

25

action

Circulation — checkouts, holds, transits, and patron actions.

39

12

48

action_trigger

Automation/Events — event definitions, hooks, and reactor/validator configurations.

13

0

2

actor

Users/Organizations — patrons, staff, org units, and user settings.

41

2

49

asset

Items/Copies — copy management, call numbers, copy locations, and status.

31

2

48

auditor

Audit Trails — historical snapshots of key tables (no foreign keys by design).

11

11

22

authority

Authority Records — MARC authority control and heading management.

16

7

56

biblio

Bibliographic Records — bib records, record entries, and TCN management.

5

0

15

booking

Reservations — resource booking and reservation management.

7

0

0

config

Configuration — system-wide configuration tables (largest schema).

91

9

9

container

Buckets/Collections — patron and staff bucket groupings.

24

0

2

evergreen

Core System — system-level functions (no tables).

0

0

90

extend_reporter

Extended Reporting — supplemental reporter data.

1

3

0

metabib

Search/Indexing — metabib field entries, search vectors, and facets.

23

11

27

money

Financial — billings, payments, and transaction summaries.

19

25

12

oai

OAI-PMH Protocol — Open Archives Initiative protocol support.

0

2

4

offline

Offline Mode — offline circulation session staging.

2

0

0

openapi

REST API — OpenAPI endpoint and parameter definitions.

22

0

5

permission

Permissions — permission definitions, groups, and grant management.

10

0

18

public

Public Schema — utility functions accessible without schema prefix.

0

0

297

query

Query Builder — stored query/filter builder components.

13

16

0

rating

Ratings — bibliographic record popularity rating.

3

1

26

reporter

Reporting — reporter template and schedule management.

8

13

9

search

Search Config — search filter configurations.

3

1

25

serial

Serials — serial publication and issuance management.

17

1

2

sip

SIP Protocol — SIP2 protocol configuration.

6

0

0

staging

Import Staging — intermediate staging tables for bulk import.

6

0

1

stats

Statistics — statistical tracking (no tables).

0

0

0

unapi

Output Formats — UNAPI output format functions.

1

0

32

url_verify

URL Verification — URL integrity checking.

5

0

3

vandelay

Import/Export — batch import/export queue and processing.

23

0

54