terraware.docprod

TABLES 31

COLUMNS 153

Constraints 91

Anomalies 0

Routines 5

Database Properties

Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)

Tables

All Tables Views Comments

Search:

Table / View	Children	Parents	Columns	Rows	Type	Comments
dependency_conditions	1	0	2	-1	Table	(Enum) Types of conditions that can control whether or not a variable is presented to the user.
document_saved_versions	0	3	9	-1	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.
document_statuses	1	0	2	-1	Table	(Enum) Current stage of a document’s lifecycle.
document_templates	2	0	2	-1	Table	Templates for the different types of documents this system can produce.
documents	1	7	12	-1	Table	Top-level information about documents.
variable_image_values	0	7	5	-1	Table	Linking table that defines which image files are values of which variables.
variable_injection_display_styles	2	0	2	-1	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.
variable_link_values	0	6	5	-1	Table	Type-specific details of the values of link variables.
variable_manifest_entries	0	2	3	-1	Table	Linking table that defines which variables appear in which manifests and in what order.
variable_manifests	5	2	4	-1	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_numbers	0	4	5	-1	Table	Information about number variables that is not relevant for other variable types.
variable_owners	0	3	3	-1	Table	Which internal users are responsible for reviewing the values of which variables for which projects.
variable_section_default_values	0	11	10	-1	Table	Section values that are set by default on newly-created documents.
variable_section_recommendations	0	4	4	-1	Table	Which sections recommend using which other variables. Can vary between manifests.
variable_section_values	0	12	8	-1	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_sections	0	6	5	-1	Table	Hierarchy of sections that define the structure of the rendered document.
variable_select_option_values	0	9	4	-1	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_select_options	3	4	7	-1	Table	Available options for select variables.
variable_selects	3	3	3	-1	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`.
variable_table_columns	0	5	5	-1	Table	The order of the columns in a table. Each column must be a variable whose parent is the table.
variable_table_styles	1	0	2	-1	Table	(Enum) How a table should be rendered visually in the document.
variable_tables	2	4	3	-1	Table	Information about tables that is not relevant for other variable types.
variable_text_types	1	0	2	-1	Table	(Enum) Types of text stored in a text variable field.
variable_texts	0	4	3	-1	Table	Information about text variables that is not relevant for other variable types.
variable_types	18	0	2	-1	Table	(Enum) Data types that can be assigned to variables.
variable_usage_types	2	0	2	-1	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.
variable_value_table_rows	0	2	3	-1	Table	Linking table that defines which variable values are in which rows of a table.
variable_values	19	6	12	-1	Table	Insert-only table with all historical and current values of all inputs.
variable_workflow_history	0	5	9	-1	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_workflow_statuses	1	0	2	-1	Table	(Enum) Workflow statuses of variables in projects. The list of valid statuses depends on the variable type.
variables	38	3	13	-1	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_numbers`.

Showing 1 to 31 of 31 entries