Help:Data Dictionary:Entities Attributes
From Opadeez WikiJump 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.
|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.|
|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)|