---
title: "Guide of Decisions Entities Locations in SQL Tables"
slug: "guide-of-decisions-entities-locations-in-sql-tables"
description: "This document acts as a guide to a few Decisions entities and which SQL table they are related to.  This information is displayed in  this document by way of a helpful reference table. "
updated: 2024-08-08T15:38:37Z
published: 2024-08-08T15:38:37Z
---

> ## 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.

# Guide of Decisions Entities Locations in SQL Tables

## Overview

The following document takes a look at a few different Decisions Entities and which SQL tables relate to each one.

---

## Decisions Entities Locations in SQL Tables

| SQL Table | Description |
| --- | --- |
| **Account_group_join** | Contains a list of **Accounts** created in Decisions and which **Group** those accounts belong to. |
| **Active_directory_settings** | This table stores information about **Active Directory Settings** such as who **Modified** the settings last and the **Modified Date**. |
| **Assigned_to_group** | Information that links **Assignments** with the **Group** that was assigned the task. |
| **Assigned_to_id** | Contains information that links **Assignments** to the **User** that is assigned****the task. |
| **Database_query_definition** | Stores information about **Queries** made in Decisions such as the **Query** itself, the **Database** that is being queried, and the **Query Name**. |
| **Document** | Stores details about **Documents** in Decisions such as the **Document ID**, the **Document Size**, and the **Folder** that the **Document** resides in. |
| **Element_registration** | Contains information about various **Entities** in Decisions (**Flows, Rules,** ect) such as the **Entity Name**, **Folder ID**, and the **Modified Date**. |
| **Entity_account** | Stores information about accounts created in Decisions such as the **Account ID**, **Authentication Type**, and the **Last Login Date**. |
| **Entity_assignment** | This table contains information about **Assignments** such as the **Assignment ID**, **Assignment Name**, **Notes**, and the **State**. |
| **Entity_folder** | Stores details about **Folders**in Decisions such as the **Folder****ID**, **Behavior**, the **Path**, and **Folder****Name**. |
| **Entity_group** | Contains a list of **Groups** created in Decisions and related information such as the **Group ID**, **Group Name**, and the **Type of Group** (remote, local). |
| **Job_schedule** | Stores information about scheduled jobs such as whether the job is **Active**, the **Last Run Date**, and the **Last Run Duration**. |
| **Module_installation** | Details about the **Modules** installed in Decisions like the **Module Name**, **Size**, and **Version**. |

---

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