Entity Attribute
An Entity Attribute represents a column in a database table.
Properties
| Name | Description | Mandatory | Default value | Observations |
|---|---|---|---|---|
| Name | Identifies an element in the scope where it is defined, like a screen, action, or module. | Yes | ||
| Description | Text that documents the element. | Useful for documentation purpose. The maximum size of this property is 2000 characters. |
||
| Label | Text used when the attribute is displayed in widgets. | This property is also used as the column header when exporting entity data to Excel. | ||
| Data Type | The attribute data type. | Yes | The attribute data type must be a basic data type or an Entity Identifier. | |
| Length | Maximum size of the attribute in characters. | |||
| Decimals | Number of decimal places. | Only available when data type is Decimal (mandatory). | ||
| Is AutoNumber | Set to Yes to generate and set Number values automatically at runtime. | Yes | No | |
| Is Mandatory | Set to Yes to require for a value to be set. | Yes | No | |
| Delete Rule | Specifies the action to take when the record that the foreign key references is deleted. | Yes | Protect | |
| Default Value | Initial value of this element. If undefined, the default value of the data type is used. | |||
| Advanced | ||||
| Original Name | The attribute column name as defined in the external database. | This property is only available in external entities' attributes. | ||
| Original Type | The attribute column data type as defined in the external database. | This property is only available in external entities' attributes. | ||