Tables, columns and relationships

📄️What is a table?

A table is the implementation of a type of object that is relevant to the business, such as "Customer" or "Rental Contract", in the form of stored data that characterises instances of the type of object.

📄️How to define a table and its columns

You can define a table and its columns by using a wizard or by filling out a form.

📄️Generating tables

The USoft capability to (re)generate database tables and database indexes is variously labeled as Create Tables (in USoft Binder), Create Physical Tables (in the USoft Definer menu), creapp.exe (on the command line), pc:creapp (in USoft Blend).

📄️What is an index?

An index is an alternative representation in the RDBMS of the values stored in a column, or in a combination of columns within a single table.

📄️What is a column?

A column is the implementation of an attribute that is relevant for distinguishing or describing instances of an entity.

📄️Virtual columns (joined columns)

Virtual column is another word for joined column.

📄️What is a relationship?

A relationship in USoft is the implementation of a connection between 2 instances of entities.

📄️Cardinality in relationships

Exactly how you map an association to USoft Tables, Columns and Relationships is a design choice that mainly depends on the association's cardinality. This help section starts with an overview of typical options, and then goes into each option in more detail.