Schema: acq
Acquisitions — purchase orders, invoicing, funding, and provider management.
Tables |
66 |
Views |
21 |
Functions |
25 |
Triggers |
14 |
Enum Types |
0 |
|
This schema has 14 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 |
||
cancel_reason ⚡ 1 |
1 |
1 |
|
0 |
2 |
||
0 |
3 |
||
0 |
1 |
||
0 |
1 |
||
0 |
2 |
||
0 |
1 |
||
0 |
0 |
||
0 |
2 |
||
0 |
1 |
||
0 |
3 |
||
0 |
5 |
||
0 |
2 |
||
0 |
0 |
||
0 |
0 |
||
0 |
2 |
||
0 |
2 |
||
0 |
2 |
||
0 |
0 |
||
0 |
1 |
||
0 |
2 |
||
0 |
3 |
||
2 |
3 |
||
fund_debit ⚡ 1 |
1 |
4 |
|
0 |
1 |
||
0 |
2 |
||
0 |
4 |
||
0 |
2 |
||
0 |
1 |
||
invoice ⚡ 1 |
1 |
6 |
|
invoice_entry ⚡ 1 |
1 |
3 |
|
invoice_item ⚡ 1 |
1 |
6 |
|
0 |
0 |
||
0 |
0 |
||
0 |
0 |
||
lineitem ⚡ 3 |
3 |
10 |
|
0 |
1 |
||
0 |
1 |
||
0 |
0 |
||
lineitem_detail ⚡ 1 |
1 |
8 |
|
0 |
0 |
||
0 |
0 |
||
0 |
0 |
||
0 |
4 |
||
0 |
1 |
||
0 |
1 |
||
0 |
4 |
||
0 |
4 |
||
0 |
3 |
||
0 |
5 |
||
0 |
1 |
||
0 |
1 |
||
0 |
1 |
||
0 |
1 |
||
0 |
3 |
||
purchase_order ⚡ 3 |
3 |
6 |
|
0 |
2 |
||
0 |
3 |
||
0 |
5 |
||
0 |
2 |
||
0 |
6 |
||
0 |
0 |
||
0 |
0 |
Functions
See acq Functions (25).