Community

Entity Attribute Properties

Last updated
Save as PDF

Collaborate with us

Edit this page on GitHub

The next table presents the properties of the entity attribute element.

Property	Description	Optionality	Default value	Obs.
Name	Name of the attribute.	Mandatory	`Attribute <n>`	You should change the name of the attribute to a suitable value. See rules for naming elements.
Original Name	Name of the column in the source database. Can contain any kind of characters supported by the DBMS.	Optional		Automatically filled when introspecting a database. If this property is empty, the "Name" property value will be used. If you change this property value in an imported entity attribute, you might have runtime errors.
Original Type	Type of the attribute in the source database. Can be any value supported by the database.	Optional		Automatically filled when introspecting a database.
Mandatory	Indicates whether the attribute is mandatory or optional.	Mandatory	`Mandatory`	To define an attribute as optional, simply un-check this property.
Auto Generated	Indicates whether the attribute value is generated by the database. The platform sets the generated value in this attribute after the record has been inserted in the database.	Optional
Data Type	Indicates the type of the attribute. Only basic data types such as `Text` or `Integer` are available.	Mandatory		The possible values are presented in a drop-down list. For more information, see available data types. Since OutSystems has its own data types, you should check how Database data types are translated into OutSystems' data types. Check the mapping for Oracle or SQL Server. If you override an attribute data type (which value was initially defined when importing an entity from a database) by manually selecting a different value, this override value will be kept when you refresh the entity.
Default value	Default value that is used if no value for this attribute is provided in the module that is using this action.	Optional
Length	Size of the attribute.	Optional		This property is only available for `Text` and `Decimal` types. In the `Decimal` type, this property corresponds to the number of digits, including the decimal part. If the values for these data types are not specified, default values are used. The rest of the data types have a fixed length.
Decimals	Number of decimal places.	Optional		This property is only available when the data type is `Decimal` and corresponds to the number of digits of the decimal part.
Ignore	Indicates if the attribute should be ignored in runtime. Attributes set as ignored will not be present in the entity when you use it in your applications and will not be considered during verification and compilation phases.	Mandatory	`False` (see "Obs.")	When a table has a column with a type that cannot be used by OutSystems (ex: `Geometry`), the entity attribute is automatically set as ignored (Ignore = `True`) after importing the table.
Description	Description of the parameter.	Optional		By default the description is empty, but you should provide a small description of the semantic of this parameter. The maximum allowed size for descriptions is 255 characters.