Schema: actor
Users/Organizations — patrons, staff, org units, and user settings.
Tables |
42 |
Views |
2 |
Functions |
51 |
Triggers |
16 |
Enum Types |
1 |
|
This schema has 16 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 |
1 |
||
0 |
1 |
||
0 |
2 |
||
0 |
1 |
||
0 |
1 |
||
0 |
0 |
||
0 |
2 |
||
org_unit ⚡ 3 |
3 |
7 |
|
0 |
2 |
||
0 |
0 |
||
0 |
3 |
||
0 |
0 |
||
0 |
6 |
||
org_unit_setting ⚡ 2 |
2 |
2 |
|
0 |
1 |
||
0 |
2 |
||
0 |
0 |
||
0 |
1 |
||
0 |
1 |
||
0 |
2 |
||
0 |
0 |
||
stat_cat ⚡ 1 |
1 |
2 |
|
stat_cat_entry ⚡ 2 |
2 |
2 |
|
0 |
3 |
||
0 |
2 |
||
0 |
0 |
||
0 |
3 |
||
usr ⚡ 6 |
6 |
9 |
|
usr_activity ⚡ 1 |
1 |
2 |
|
usr_address ⚡ 1 |
1 |
2 |
|
0 |
3 |
||
0 |
3 |
||
0 |
1 |
||
0 |
2 |
||
0 |
4 |
||
0 |
1 |
||
0 |
1 |
||
0 |
1 |
||
0 |
2 |
||
0 |
5 |
||
0 |
1 |
||
0 |
2 |
Types
See actor Types for enum type definitions.
Functions
See actor Functions (51).