TABLES
13
VIEWS
16
COLUMNS
179
Constraints
32
Anomalies
6
Routines
0
Database Properties
Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)
Schema query
Contains tables designed to represent user-defined queries for reports and the like.
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| case_branch | 0 | 3 | 5 | -1 | Table | |
| function_param_def | 0 | 2 | 4 | -1 | Table | |
| stored_query | 7 | 5 | 9 | -1 | Table | |
| query_sequence | 0 | 2 | 4 | -1 | Table | |
| bind_variable | 9 | 0 | 5 | -1 | Table | |
| datatype | 6 | 1 | 4 | -1 | Table | |
| from_relation | 3 | 6 | 11 | -1 | Table | |
| subfield | 0 | 2 | 4 | -1 | Table | |
| function_sig | 2 | 2 | 4 | -1 | Table | |
| order_by_item | 0 | 2 | 4 | -1 | Table | |
| expression | 14 | 8 | 16 | -1 | Table | |
| select_item | 0 | 2 | 6 | -1 | Table | |
| record_column | 0 | 3 | 5 | -1 | Table | |
| expr_xisnull | 0 | 0 | 6 | 0 | View | |
| expr_xnum | 0 | 0 | 5 | 0 | View | |
| expr_xop | 0 | 0 | 8 | 0 | View | |
| expr_xex | 0 | 0 | 6 | 0 | View | |
| expr_xbind | 0 | 0 | 5 | 0 | View | |
| expr_xcol | 0 | 1 | 7 | 0 | View | |
| expr_xcast | 0 | 0 | 7 | 0 | View | |
| expr_xser | 0 | 0 | 6 | 0 | View | |
| expr_xnull | 0 | 0 | 5 | 0 | View | |
| expr_xsubq | 0 | 0 | 6 | 0 | View | |
| expr_xfunc | 0 | 1 | 7 | 0 | View | |
| expr_xbool | 0 | 0 | 6 | 0 | View | |
| expr_xin | 0 | 0 | 7 | 0 | View | |
| expr_xcase | 0 | 0 | 6 | 0 | View | |
| expr_xstr | 0 | 0 | 5 | 0 | View | |
| expr_xbet | 0 | 0 | 6 | 0 | View |