Database Properties
Database Type: PostgreSQL - 13.1 (Debian 13.1-1.pgdg100+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| variable_section_default_values | 0 | 11 | 10 | 0 | Table | Section values that are set by default on newly-created documents. |
| variable_link_values | 0 | 6 | 5 | 0 | Table | Type-specific details of the values of link variables. |
| variable_injection_display_styles | 2 | 0 | 2 | 2 | Table | (Enum) For injected variables, whether to render them as text fragments that are suitable for including in paragraphs or as separate items on the page. Analogous to the inline/block display styles in CSS. Not applicable to all variable types. |
| dependency_conditions | 1 | 0 | 2 | 6 | Table | (Enum) Types of conditions that can control whether or not a variable is presented to the user. |
| documents | 1 | 7 | 12 | 0 | Table | Top-level information about documents. |
| variable_workflow_history | 0 | 5 | 9 | 0 | Table | History of changes to the workflow details for a variable in a project. This table is append-only; edits to the values are represented as new rows, and the row with the highest ID for a given project and variable ID holds the current workflow details for that variable. |
| variable_section_recommendations | 0 | 4 | 4 | 0 | Table | Which sections recommend using which other variables. Can vary between manifests. |
| variable_image_values | 0 | 7 | 5 | 0 | Table | Linking table that defines which image files are values of which variables. |
| variable_values | 19 | 6 | 12 | 0 | Table | Insert-only table with all historical and current values of all inputs. |
| variable_owners | 0 | 3 | 3 | 0 | Table | Which internal users are responsible for reviewing the values of which variables for which projects. |
| variable_usage_types | 2 | 0 | 2 | 2 | Table | (Enum) When a variable is used in a section, whether to inject the value of the variable or the location where the value is injected elsewhere in the doc. |
| document_saved_versions | 0 | 3 | 9 | 0 | Table | Saved versions of document variable values. A saved version is conceptually just a reference to a particular point in the edit history of the document; to restore that version, we ignore any later edits. |
| variable_text_types | 1 | 0 | 2 | 2 | Table | (Enum) Types of text stored in a text variable field. |
| variable_section_values | 0 | 12 | 8 | 0 | Table | Fragments of the contents of document sections. Each fragment is either a block of text or a usage of a variable; they are assembled in order to render the contents of the section. |
| variable_manifests | 5 | 2 | 4 | 0 | Table | A collection of the definitions of the variables for a document template. This is how we do versioning of variable definitions. Each revision of the variable definitions is represented as a new manifest. |
| variable_select_option_values | 0 | 9 | 4 | 0 | Table | The options of a select variable that are selected in a document. Options that are not selected do not appear in this table. |
| variable_manifest_entries | 0 | 2 | 3 | 0 | Table | Linking table that defines which variables appear in which manifests and in what order. |
| variable_table_styles | 1 | 0 | 2 | 2 | Table | (Enum) How a table should be rendered visually in the document. |
| variable_table_columns | 0 | 5 | 5 | 0 | Table | The order of the columns in a table. Each column must be a variable whose parent is the table. |
| variable_selects | 3 | 3 | 3 | 0 | Table | Information about select variables that is not relevant for other variable types. This table only has information about the variable as a whole; the options are in |
| variable_select_options | 3 | 4 | 7 | 0 | Table | Available options for select variables. |
| variable_value_table_rows | 0 | 2 | 3 | 0 | Table | Linking table that defines which variable values are in which rows of a table. |
| document_templates | 2 | 0 | 2 | 0 | Table | Templates for the different types of documents this system can produce. |
| variable_tables | 2 | 4 | 3 | 0 | Table | Information about tables that is not relevant for other variable types. |
| variable_numbers | 0 | 4 | 5 | 0 | Table | Information about number variables that is not relevant for other variable types. |
| variable_types | 18 | 0 | 2 | 8 | Table | (Enum) Data types that can be assigned to variables. |
| document_statuses | 1 | 0 | 2 | 5 | Table | (Enum) Current stage of a document’s lifecycle. |
| variable_texts | 0 | 4 | 3 | 0 | Table | Information about text variables that is not relevant for other variable types. |
| variables | 38 | 3 | 13 | 0 | Table | variables that can be supplied by the user. This table stores the variables themselves, not the values of the variables in a particular document. Type-specific information is in child tables such as |
| variable_workflow_statuses | 1 | 0 | 2 | 8 | Table | (Enum) Workflow statuses of variables in projects. The list of valid statuses depends on the variable type. |
| variable_sections | 0 | 6 | 5 | 0 | Table | Hierarchy of sections that define the structure of the rendered document. |