Skip to main content

Introduction

Last updated 19/03/2024

tip
Five's Table Wizard is a quick way to add your tables into Five and is our recommended table-building experience. You can add extra features and functionality into your table by going to the Tables view and selecting the record.

Five gives you several ways to create your tables. You can use the Table form, Five's Table Wizard, or Five's Database Modeler.

info
Whichever way you add your tables, all table records will be listed in the Tables view.

Tables are a data source that contain your data. In tables, data is logically organized in columns and rows. Each row represents a record that is uniquely identified by a primary key, and each column represents a field in the record.

Columns define the data in a table, and each column holds a single type of data value to further describe the information it contains along with the constraints for the type of data that may be inserted in the column.

Each field in a row is implicitly correlated with each of the other fields in that same row. For example, a table containing customer information data might contain a row for each customer and columns representing customer information such as Customer Number, Name, Phone, Email.


Example of a Customer table
Figure 1 - Example of a Customer table

In Five, you can assign properties to a table, and each field in the table to control the data that is allowed. For example, you can create constraints on a field to disallow null values, or provide a default value, or assign a key constraint on a field that enforces uniqueness or defines a relationship between tables.

Who Can Add, Edit, and Delete Tables?

Please refer to the chapter Five's Users and Roles.

How Five Will Use Your Tables

The forms connected to your tables, are only capable of instructing the browser on the method of presenting the information. Five handles the transactions needed to store the information in your database. The input values in your application will be accepted by Five and stored in an organized structure in your tables.

The fields in your tables can become your form fields on your forms and column headings for your lists. The input values must match the definitions set for the values to be stored in your tables. 1. Select Data in the menu.

2. Select Tables in the sub-menu.


Tables menu item
Figure 2 - Tables menu item

The Table Form

The Table form has five tabs across the top of the form, each of these tabs will navigate you to their respective page to build out your table.

PageDescription
GeneralSelect your database and give your table an ID and a name.
EventsAttach functions to your table.
FieldsAdd fields and their definitions.
IndicesAdd the keys for your table.
ReferencesA report of where your table is being referenced.

Table form
Figure 3 - Table form

General Page

The General page is to name your table, if you are working in the cloud, you will need to select the database you want to add the table to if you are working with multiple databases. The table below will give you an overview of the fields on the General page.

FieldDescription
DatabaseThis field is only available in the cloud, as the desktop version does not support multiple databases. Use the field to select the database for the table to be created in. If you only have one database for your application, Five will automatically populate the field.
Data Source IDAdd a data source ID for your table. This will uniquely identify your table across multiple databases and across all data sources in Five. Please see the note below for further information.
Table NameAdd fields and their definitions.
NotesAdd the keys for your table.

note

When you are using multiple databases we provide the fields Data Source ID and Table Name. The data source ID must be unique for all data sources in your application.

Five's Data Sources
  • Tables
  • Connections
  • Queries

Because of this we also provide the Table Name field, this enables you to have the same table name across multiple databases as long as they have a unique data source ID.

Example

FieldDatabase OneDatabase Two
Data Source IDCustomerACustomerB
Table NameCustomerCustomer

The next logical step when creating a table via the form is to add fields to the table followed by any keys required for the table inclusive of the primary key.