Attribute
Property that maps to data the entity can manipulate or a relationship the entity has with another entity.
Calculated Field
Property that returns a read-only calculated value.
Column
Attribute that represents data that has a mapped column in the entity's database table.
Constraint
Data validation that determines whether data can be processed.
Data Type
Determines the type of data a column can store, such as string, int, etc.
Delete Constraint
Constraint that prevents deleting a record if its condition is true.
Delete Order
Defines the order to delete child objects before deleting a record based on the entity.
Entity
XML file that moves data between the app and database.
Expression
Pairing of a condition that describes the state of some entity data and a message to display when the condition is true.
Field Constraint
Constraint that prevents saving a record if the defined attribute meets the defined constraint.
Foreign Key
Primary key of the table that the entity's parent entity is linked to.
Form
Interface that allows users to interact with the entity's data in the app via configured controls. Also called a screen.
Group
Collection of conditions that applies to the wizard step that calls it.
NonQuery
SQL statement that is not a query.
One to Many Relationship
Relationship one item has with one or multiple other items.
One to One Relationship
Relationship one item (possibly of multiple) has with one other item.
PickList
Data type that maps a column to a code group that defines the possible values for that column.
Primary Key
Unique, sequential identifier of each record in the entity's linked table.
Property
Attribute that represents data that does not have a mapped database column.
Query
SQL statement that retrieves data.
Query Builder
Drag-and-drop interface for creating a query, rather than directly keying it.
Rule
Logic that returns a value or makes a decision.
ScalarQuery
Query that returns a count.
SelectQuery
Query that returns table data.
Server Constraint
Constraint that prevents saving a record if its condition is true.
Soft Constraint
Constraint that prevents a record from being in Valid status if its condition is true.
SubSelectQuery
Query that executes as a where clause in another query.
System Column
Attribute that represents a default column that manages record metadata. System columns are: Created By, Created Data, Modified By, Modified Date, and Update Seq.
This post is part of the Entity topic. Click here to open the Entity Overview.
#Entity