Schema: asset
Items/Copies — copy management, call numbers, copy locations, and status.
Tables |
31 |
Views |
2 |
Functions |
49 |
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 |
|---|---|---|---|
call_number ⚡ 4 |
4 |
7 |
|
0 |
0 |
||
0 |
2 |
||
1 |
1 |
||
1 |
1 |
||
copy ⚡ 7 |
7 |
8 |
|
copy_alert ⚡ 1 |
1 |
3 |
|
copy_inventory ⚡ 2 |
2 |
1 |
|
copy_location ⚡ 1 |
1 |
1 |
|
0 |
1 |
||
0 |
2 |
||
0 |
2 |
||
copy_note ⚡ 1 |
1 |
1 |
|
0 |
1 |
||
copy_tag ⚡ 2 |
2 |
2 |
|
1 |
1 |
||
0 |
7 |
||
0 |
0 |
||
0 |
1 |
||
0 |
8 |
||
0 |
3 |
||
0 |
0 |
||
0 |
1 |
||
0 |
2 |
||
stat_cat ⚡ 1 |
1 |
2 |
|
0 |
2 |
||
0 |
2 |
||
0 |
0 |
||
0 |
0 |
||
0 |
0 |
||
0 |
2 |
Functions
See asset Functions (49).