---
title: "Schema Explorer"
slug: "schema-explorer"
updated: 2024-01-24T21:30:47Z
published: 2024-01-24T21:30:47Z
canonical: "wiki.cobblestonesoftware.com/schema-explorer"
---

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

# Schema Explorer

### **Schema Explorer**

**Field Manager: Schema Explorer**

Contract Insight supports the ability to view the Schema of the system. A user must be a system administrator to view the **Schema Explorer** screen.

**Schema Explorer**

A schema is a road map of how everything is connected in the system.

Navigate to **Manage/Setup** > **Field Manager** > **Schema Explorer**

![Navigation to Schema Explorer](https://cdn.document360.io/e3626857-1fb5-4e27-b278-2d3fc5508be4/Images/Documentation/1(269).png)

**Table Selection**

Once a table is selected from the **Select Area/Table** drop down, the information for the table will appear in the box below such as the **Table Database (DB) Name**, **Table Display Name**, and the **Primary Key of the table**.

![Information about the table such as Name and Primary Key](https://cdn.document360.io/e3626857-1fb5-4e27-b278-2d3fc5508be4/Images/Documentation/2(202).png)

**Select Area/Table:** This drop-down field includes all the Tables from the system. When a table is selected from the drop-down, all the information for that table appears below (Ex: Contract Details).

**Table DB Name:** This shows what the table name is on the back end (Database) of the system (Ex. tblContracts).

**Table Display Name:** This shows what the **Display Name** is for this table in the system (Ex: Contract Details).

**Primary Key Field:** A **primary key** is a unique identifier for a table. The primary key for each table within the system is the **ID** field. For example, the primary key for the Contract Details table will be the **Contract ID**; for the Request table the primary key will be the **RequestID** field.

**Columns/Fields**

The Columns/Fields sub-table on the **Schema Explorer** shows all the fields associated with the selected table (Contract Details). The employee/user will see the **Display Names**, **Column Names**, **Data Type**, **Field Type**, **Default Value**, **Is Required**, **Is Locked**, **Is System**, **Is Identity**.

![Columns of the Columns/Fields sub table](https://cdn.document360.io/e3626857-1fb5-4e27-b278-2d3fc5508be4/Images/Documentation/7(5).png)

**Display Name:** This column shows the **Display Name** for each field in the table selected in **Select Area/Table**.

**Column Name:** This column shows the **Name** of the field on the DB side.

**Data Type:** This column shows the **Data Types** from the DB side of the system.

**Field Type:** This column shows the **Field Types** of the fields. (Checkbox, Currency, Date, DateTime, Decimal, Decimal 4, Drop Down Box, Integer, Multi-Line Text Box, Multi-Line List Box, Password, Slider, Text Box, and Rich Text Editor).

**Default Value:** This column will show the default value that was added to the **Default Value** text box on the **Manage/Edit Field** screen for a field.

**Is Required:** This column will show you if the field is a required field.

**Is Locked:** This column lets employee/user if the field is locked

**Is System:** This column shows if the field is system (Yes) or user (No) defined field.

**Is Identity:** This column shows you what field in the table has the **Primary Key**. For example, the **Contract ID** field has Yes in that column.

![Showing you what field has the Primary Key](https://cdn.document360.io/e3626857-1fb5-4e27-b278-2d3fc5508be4/Images/Documentation/3(15).png)

**Foreign Keys (Lookup Fields):**

A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.

![Foreign Key column](https://cdn.document360.io/e3626857-1fb5-4e27-b278-2d3fc5508be4/Images/Documentation/4(10).png)

**Foreign Key/Lookup Field:** This column shows the foreign keys that are associated with this table (Ex. Contract Details).

**Linked to Table:** This column shows the table that this fields are primary keys for and what links them to this table.

**Linked to Field Name:** This column shows the field names of those foreign keys.

**Linked to Field Display:** This column shows the linked field name displays for these foreign keys.

**Sub Tables/Areas:**

This sub-table on the Schema Explorer page will show all the sub-tables that are associated with this table (Ex. Contract Details).

![Sub-Table shows all Sub-Tables associated with the table](https://cdn.document360.io/e3626857-1fb5-4e27-b278-2d3fc5508be4/Images/Documentation/5(5).png)

**Primary Table Name:** This column shows the primary table name for this sub-table.

**Primary Table Key Field:** This column shows the primary key that’s associated with table (Contract Details).

**Sub Table Name:** This column shows the sub table name that’s on the DB side of the system.

**Sub Table Key Field:** This column shows the primary key that’s associated with that sub-table.

**Parent Tables/Areas:**

This sub-table on the Schema Explorer page shows the Parent Tables, Parent Table Key Field, Child Table Name, and Child Table Key Field.

![Sub-Table showing Parent Tables, Parent Table Key Field, and Child Table Name](https://cdn.document360.io/e3626857-1fb5-4e27-b278-2d3fc5508be4/Images/Documentation/6(4).png)

**Parent Table Name:** This column shows the parent tables that are associated with this table.

**Parent Table Key Field:** This column shows the primary key for each field.

**Child Table Name:** This column shows the child table of the primary table.

**Child Table Key Field:** This column shows the primary key to the child table.