Help:Data Dictionary:Entities Attributes

From Opadeez Wiki
Jump to navigationJump to search

The Entity / Attributes page is used to create the base definition of the solution data model.

  • Entities are logical structures that can be used multiple times with different meanings; for example you may create a '"Person"' entity, which can be used to represent a client, an employee etc... The '"meaning"' of an entity is defined by the DataSet where it is used (refer to "Data set" for further details).
  • Attributes are the properties of an entity. For example a '"Person"' entity may have a '"First Name"' and '"Lastname"' attributes.

You can see Entities & attributes as the tables and attributes in a database.

Entities

Entity name Name of the entity. This name will be used as the database table name.
Has Lock Set if this entity can handle locks. Locks should be created at top-level entities, to avoid multiple users accessing the same record.
Is Temporary Temporary tables can be used for calculation or temporary storage in the scope of a workflow, but are not stored in database.
Connection (optional) Opadeez supports storing different tables in different databases. To do this, create additional Connections (refer to "Connections" for further details) and select a connection entry for each entity.

Attributes

Attribute name Name of the attribute.
Label Label to be used when the attribute is shown on a Page. If not provided, the "Attribute name" is used as a label.
Type Attribute data type. Depending on the "Type" additional settings are available: Length, Signed, Precision etc...
DB Field name (optional) Name of the database field used to store this attribute. If not provided, the attribute name is used as the table field name.
Value List References a "Value list" definition (refer to "Value lists" for further details). An attribute with a "Value list" is displayed as a drop-down list or an auto-complete search input text.
Value List Dependency If needed, select the field that holds the dependency value, that will be used to filter the Value List. If you select a dependency field, your Value List must have "Dependency Value" defined for its entries.
Is Temporary Temporary fields can be used for temporary calculations and are not stored in the database.
Audit trail Set if the value of this attribute is saved in the audit trail records.
Formula A formula is used to create computed fields. Computed fields cannot be keyed in by user (read-only), but can be displayed and used in the system. When such a field is displayed on a screen, its value is updated "real time" based on the dependent fields values. For example this formula gives the age of a person based on his/her date of birth: datediff(now(), DateOfBirth, "y") (refer to "Scripting Language" for further details on the syntax to use)

See also