Schema: action
Circulation — checkouts, holds, transits, and patron actions.
Tables |
39 |
Views |
12 |
Functions |
48 |
Triggers |
22 |
Enum Types |
0 |
|
This schema has 22 triggers. Many triggers modify data before write (BEFORE ROW triggers) or maintain denormalized summary tables (AFTER triggers). Review trigger bodies carefully before writing to these tables directly. |
Tables
| Table | Triggers | FKs | Description |
|---|---|---|---|
0 |
0 |
||
0 |
0 |
||
0 |
0 |
||
0 |
0 |
||
0 |
2 |
||
0 |
2 |
||
circulation ⚡ 11 |
11 |
6 |
|
0 |
2 |
||
0 |
4 |
||
0 |
1 |
||
0 |
2 |
||
0 |
2 |
||
0 |
2 |
||
0 |
1 |
||
0 |
2 |
||
0 |
4 |
||
0 |
1 |
||
0 |
3 |
||
hold_copy_map ⚡ 1 |
1 |
1 |
|
0 |
2 |
||
hold_request ⚡ 3 |
3 |
14 |
|
0 |
0 |
||
0 |
1 |
||
0 |
0 |
||
1 |
4 |
||
1 |
1 |
||
0 |
3 |
||
0 |
1 |
||
1 |
2 |
||
0 |
4 |
||
0 |
4 |
||
1 |
2 |
||
0 |
1 |
||
0 |
1 |
||
0 |
1 |
||
survey_response ⚡ 1 |
1 |
3 |
|
transit_copy ⚡ 1 |
1 |
5 |
|
0 |
0 |
||
usr_circ_history ⚡ 1 |
1 |
2 |