---
title: "Database Structure CRUD Actions"
slug: "database-structure-crud-actions"
tags: ["CRUD Actions", "Database Structure"]
updated: 2025-06-25T13:10:57Z
published: 2025-06-25T13:10:57Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Structure CRUD Actions

## Overview

Database Structures are Data Structures that are typically used to create a table in the database to store information (e.g. customer information such as phone numbers or names). The following article will demonstrate how to use the Create, Read, Update, and Delete (CRUD) actions via Flow steps for Database Structures.

CRUD Action Steps: Database Structures

In the Flow Designer's Toolbox, **Create, Update**, and **Delete**steps cannot be searched for. Users will have to navigate to USER DEFINED TYPES > DATABASE STRUCTURE to add CRUD actions to the workspace.

## 

---

## [Prerequisite](/v9/docs/creating-a-database-structure)

This tutorial uses a Database Structure named "DatabaseStructurePerson" with the following attributes:

| DatabaseStructurePerson |
| --- |
| Data Field Name | Data Field Type |
| Firstname | String |
| Lastname | String |
| DOB | Date time |

### 

---

## Create

1. In a Designer Folder, create a Flow. Name it "Database Structure Create". It will automatically open in the Flow Designer.
2. In the Flow Designer, add a **Create DatabasePerson**from the **Toolbox**under **USER DEFINED TYPES > DATABASE STRUCTURES > DATABASEPERSON.**Connect it to the Start and End steps.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_08h54_27.png)
3. With the **Create DatabasePerson**step selected, navigate to the **Properties panel** **> INPUTS > Item to Create** field and change its input mapping to **Build Data**.
4. Notice the new list of INPUTS. Change the inputting mapping for the **FirstName**, **LastName**, and **DOB** inputs from **Ignore**to **Constant**. Provide example information.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_08h56_22.png)

### Debug

Select **Debug**from the Top Action Bar. This will save and run the Flow, creating a record (row of relational data) on the DatabasePerson Data Structure.

Auto ID Generation

Despite being initially set to Ignore, note how the system auto-generates the record's ID upon creation by the Debug (Flow run) action.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_08h57_10.png)

This new record can be seen when sourcing the Database Structure in a Report.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_08h58_22(1).png)

---

## Update

Users may update their data with either the **Edit [DatabaseStructureName]** step or the **Selective Update [DatabaseStructureName]**step found alongside the Create [DatabaseStructureName] step in the Toolbox.

The two steps offer two different methods of editing Database Structure data records:

- **Edit:**Changes **every**data field even those not intended to change. Any fields left without a value will become Null, so enter data to prevent this.
- **Selective Edit**: Changes only the data field(s) that were **given new value(s).**Leaving fields blank instead maintains their original values and thus will not become Null.

For most uses cases, Selective Edit is recommended over the Edit step.

Update Flows rely on the **Fetch Entities**step to****grab the correct data record(s) to change in a Data Structure by passing the data record's ID into the Edit or Selective Update steps.

### Edit Person Step

1. In the Designer Folder, create a new Flow and name it "Database Structure Update". It will automatically open in the Flow Designer.
2. From the Toolbox's Favorites section, add a **Fetch Entities**step after the **Start**step.
3. In the **Fetch Entities'** Properties****tab, change its **Type Name**search for the Database Structure: "DatabaseStructurePerson".

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_08h59_42.png)
4. After the **Results**outcome of the Fetch Entities step, add a **Edit DatabaseStructure Person**step found under **Toolbox** **> USER DEFINED TYPES > DATABASE STRUCTURES > DATABASESTRUCTUREPERSON.** Connect the **No Results**path to the **End**step.
5. View the Edit DatabaseStructurePerson's Properties. For **Extension Data,**change its mapping type to **Build Data.** For **Entity ID,**change its mapping type to **Select From Flow**and select the ID of the entity to change that was grabbed from the Fetch Entities step. In this example, this is EntityResults.First.ID For the **"FirstName", "LastName",**and **"DOB"** inputs, change their mapping type to **Constant** and enter new information to change. Unless wishing to create null values, enter values for all fields even if they are the same as the original.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h01_12.png)

#### Debug

Select the **Debug** action from the top action bar. This will automatically save the Flow. Open the Inputs/Outputs of the Edit step to view the new data.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h02_52.png)

This edit can be seen in the Database Structure's Report.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h03_26.png)

### Selective Update Person Step

1. Repeat steps 1-3 in the prior Edit step example.
2. After the **Results**outcome of the Fetch Entities step, add a **Selective** **Update DatabaseStructure Person**step found under **Toolbox > USER DEFINED TYPES > DATABASE STRUCTURES > DATABASESTRUCTUREPERSON.** Connect the **No Results**path to the **End**step.
3. View the Selective Update DatabaseStructurePerson's Properties. For **Data,**change the DOB field mapping type to **Constant**and enter a new DateTime. The other fields will not be changed, so they can remain blank. Under **Inputs,**change the **ID**input to **Select From Flow**and select the ID of the entity to change that was grabbed from the Fetch Entities step. In this example, this is EntityResults.First.ID

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h06_00.png)

#### Debug

Select the **Debug** action from the top action bar. This will automatically save the Flow. Open the Inputs/Outputs of the Selective Update step. Notice only the record's ID and the change values show i.e. the ID and the DOB field.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h07_03.png)

This change is reflected in a Report sourcing the Database Structure Notice that while the DOB field changed, the other fields ignored in the Selective Update step maintain their values.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h07_40.png)

---

## Delete

1. In the Designer Folder, create a new Flow. Name it "Database Structure Delete". It will automatically open in the Flow Designer.
2. In the Flow Designer, add a **Fetch Entities**step from the **Toolbox's Favorites**section. Connect it to the Start step.
3. View the Fetch Entities's Properies. For the **Type Name,**search for the Database Structure: "DatabaseStructurePerson".

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h08_35.png)
4. After the **Results** outcome of the Fetch Entities step, add a **Delete DatabaseStructurePerson**step found via **Toolbox > USER DEFINED TYPES > DATABASE STRUCTURES > DATABASEPERSON.**
5. View the Delete DatabaseStructurePerson's Properties. For the **ID**input, change the input mapping to **Select From Flow**and select the ID of the record to delete. For this example, this is EntityResults.First.ID.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-25_09h09_52.png)
6. After debugging/running the Flow, the specified record is deleted from the Database Structure.

---

For further information on Data Structures, visit the [Decisions Forum](https://community.decisions.com/categories/Datastructures).