Exploring database Entities

As said before, database Entities are representations of tables that support our applications.

Note

A table is a structure for organizing and displaying information, with data arranged in columns and rows. Information is displayed as text, using words and numbers, and grid lines may or may not be present.

To this purpose, they have the following characteristics:

• Attributes: Attributes are the fields where we store data. They can be of several simple types. We can define some properties, varying according to the configured type, and one of the common properties is the mandatory configuration. The possible attribute types are as follows:
  • Text
  • Integer
  • Long Integer
  • Decimal
  • Boolean
  • Date Time
  • Date
  • Time
  • Phone Number
  • Email
  • Binary Data
  • Currency
  • Identifier
• Primary keys: The primary key in OutSystems is called the Entity Identifier. This is created automatically at Entity creation time and cannot be a composite key. The Entity Identifier can only be of the...