Entities

Entity properties:

• The field “Schema name” contains the name of the schema to which the entity will belong.

• The field “Table name” contains the name of the entity in the database.

• The field “Title” contains the title of the entity that is displayed to the user.

• The field “Primary key” contains the names of the fields that are part of the primary key.

• The field “Entity type” contains the type of the entity being created. It is filled in automatically. It matters:

  • “Table” - table;
  • “View” - view;
  • “Partitioned table” - partitioned (partitioned) table;
  • “Foreign table” - external table.

• The field “Defining a view” contains an SQL query for retrieving data (for views).

Entity relationships:

• The container “Projections” contains the projections defined for this entity.

• The container “Relations” contains links to this entity from other entities.

• The container “Properties” contains the columns of this entity.

• The container “Triggers” contains triggers defined for this entity.