TABLES
10
VIEWS
0
COLUMNS
34
Constraints
8
Anomalies
1
Routines
0
Database Properties
Database Type: PostgreSQL - 16.4 (Debian 16.4-1.pgdg120+2)
Catalog public
PostgreSQL Database
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| config | 0 | 1 | 6 | -1 | Table | General JSON Configuration and Data Values. Defined Data Formats: Currently None |
| json_schema_type | 1 | 0 | 4 | -1 | Table | Library of defined json schemas used to validate JSONB field contents. |
| category | 1 | 2 | 4 | -1 | Table | Defintion of a Category. |
| proposal_template | 2 | 0 | 3 | -1 | Table | Defintion of a Proposal Template. |
| proposal | 1 | 1 | 2 | -1 | Table | An individual Proposal. |
| campaign | 1 | 1 | 3 | -1 | Table | Defintion of a Campaign. |
| refinery_schema_history | 0 | 0 | 4 | -1 | Table | History of Schema Updates to the Database. Managed by the |
| event | 1 | 1 | 3 | -1 | Table | Defintion of an Event. |
| brand | 1 | 0 | 2 | -1 | Table | Defintion of a Brand. |
| category_proposals | 0 | 2 | 3 | -1 | Table | Proposals that are submitted into the linked category. |