DB Table Initialize

Overview

DB Table Initialize defines a table schema and prepares the table for subsequent row read and write tools.

At runtime, this node can create a new table, update an existing table structure, or enforce strict new-table creation depending on the selected create mode.

Input

Table Name

string required

Logical table name to create or open.

Choose a stable name because child tools reference this setup node and operate on its configured table.

Table Create Mode

string

Controls what happens if the table already exists:

• APPEND: keeps existing table and adds missing columns when possible.
• OVERWRITE: drops and recreates table from current schema definition.
• NEW_ONLY: fails initialization if table already exists.

Default: APPEND

Primary Key Type

string

Primary key strategy for row identity and ordering.

Available options include auto-increment integer and datetime-string key formats at different precision levels.

Default: INT_INCREMENT

Column Definitions

array required

List of table columns to create/manage.

Each item:

• Column Name: unique column name.
• Column Data Type: one of string, number, integer, boolean, string_base64image, string_date-time.
• Is Nullable: allows null values in this column.
• Is Unique: enforces uniqueness across all rows.

For image and datetime column types, additional conditional options may appear in the UI based on schema helpers.

Auto Delete Max Rows

integer required

Maximum number of rows to keep.

When greater than 0, oldest rows are deleted automatically after the limit is exceeded.

Set to 0 to disable auto deletion.

Output

This node does not expose custom data fields directly. It provides the configured table context used by child database tools.