Scroll To Top

Table Columns

Introduction

This page was extraced from the Table Properties page.

The Columns tab empowers you to design the column-level data definitions for your table.

Add Column

Clicking the Add Column button will open a dynamic Add Column dialog box with the power to define the data of your new column, based on the Type of the column you select.

Default Column Definition and Display Options

In the top 4 definitions, you can name and configure the display features of your new column

  • Name — This is the identifying label that you want to use to reference this column in this table.

  • Friendly Name — This is the end-user focused label that you want to display for this column.

  • Alignment — This select box allows you to tell how you want the orientation of the cell data for this column to be displayed.

  • Sequence — This select box gives you the power to set the order in which you want to display this column.

Type-Based Column Definitions

The Type options are Standard, Reference and Calculated. Each of these Types has its own set of definition options that dynamically displays depending on which Type you select.

Standard-Type Definition Options

  • Column Type — This drop-down allows you to set the type of data that you want to enforce in this column.

  • Column is nullable — This toggle gives you the power to tell whether or not this column can have, literally, nothing in it.

  • Column is unique — This toggle lets you tell whether or not to allow a value to exist more than once in this column.

Reference-Type Definition Options

  • Table — This select-box allows you to tell which table to use to get the data you want it to display in this column.

  • Column — This select box lets your tell which column has the data, from the selected reference table, that you want to use to fill this column.

  • Column is nullable — This toggle gives you the power to tell whether or not this column can have, literally, nothing in it.

Calculated-Type Definition Options

  • Expression — This code box lets you use MySQL Functions to create the calculation statement, that results in a single "scalar value", to return for display in this column.

Custom Column Types

Custom column types are those that are not a database constraint but one custom created for foreflow use.

  • URL — This column type creates a string column that accepts a valid URL. When displaying this column in a grid the URL is rendered so that it is clickable.