Web System Composite Types

Web System Composite Type is a structure of a record or a row and is a list of fields and their types. Younicycle uses composite types just like any other conventional type of data.  For example, a table column can be declared to be a composite type.

Composite Types interface

Type name - The name of the type under which it will be saved in the database.
Description - Information field to add notes decribing the type.
Columns - The list of type fields.
Name - The name of the field, same restrictions as on the names of table fields apply (see {ref: 38}).
Type - The type of the field. Similar to the types of table fields (see (ref: 38)). It can also be composite.
Length - The length of the field. (see. Web System Manage fields).
Description - Description.
Del - Deletes a field from the list.

Save - Saves composite type in the database.
Reset - Cancels all changes.
Add new - Adds a new field to the list.

Composite Type can't be edited after saving. PostgreSQL dictates this restriction.

Younicycle uses composite types just like any other conventional type of data.  For example, a table column can be declared to be a composite type.

When you add or change field values of a composite type, the value must be enclosed in brackets, and the elements of a value, must be separated by commas:
('Ivan','Petrov',45)