Overview

Updated on 28 Jun 2024
1 Minute to read

Article summary

Did you find this summary helpful?

Thank you for your feedback

Table Designer - Time, Cost and Result Oriented

A Table Designer is an effective interface that enables you to create tables with data values organized in accordance with your needs. This table arrangement is extremely simple to complete without any coding or technical expertise.

Figure: Table Designer - Capabilities

User Persona: Application Designer

A table is a grid structure of rows and columns to organize the information. A table stores and displays the information in a structured format for quick access later. It’s the foundation on which all components such as Forms, Applications, Notifications and Workflows execute and perform actions. An existing table is the mandatory prerequisite to design any workflow, notifications, forms, or applications.

Tables are the core element of Symphony Apex Platform. You can define validation rules, Default values, additional Metadataat Table Designer level.

Database Elements in Apex Platform

The following are key Database elements used in Apex platform"

Concept	Definition
Table	A table is a collection of data represented in rows and columns. Each table has a name in database.
Record	Each row of a table is known as a record.
Field or Column Name or Attribute	Each vertical set of values is a column, and the header is considered the attribute name or field.
Schema	Database schema defines the variable declarations in tables that belong to a particular database.
Instance	The data stored in database at a particular moment of time is called instance of database. The value of variables at a moment of time is called the instance of that database.
Key	Keys are used for identifying unique rows from table. Two important types are: Primary Key – A primary is a column or set of columns in a table that uniquely identifies tuples (rows) in that table. Foreign Key – Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.

The infographic depicts the usage of Table Designer.

Figure: Table Designer Usage

Table Designer in Action

Let us start configuring Table Designer!


Overview	Define Table Designer

Was this article helpful?

What's Next

Define Table Characteristics

Table of contents