The next table presents the properties of the Entity attribute.

Property

Description

Optionality

Default value

Obs.

Name

Internal name that identifies the attribute.

Mandatory

 

See rules for naming elements.

Description

Free text that describes the attribute. You can edit the text by directly typing it in the property or in the description editor which opens by clicking

Optional

 

Useful for documentation purpose.

The maximum size of this property is 2000 characters.

Data Type

List of all the types supported by OutSystems, except Object, Record, and List. It also contains the Identifiers for all the entities created in the eSpace.

Mandatory

Text

Learn more about types of entity attributes.

Length

Size of the attribute.

Optional

 

Mandatory for Text and Decimal types. In the Decimal types, this property includes the decimal part.

If the values for these types are not specified, default values are used.

The other types have a fixed length.

Decimals

Number of decimal places.

Optional

 

Mandatory when the type is Decimal.

Is Auto Number

Boolean value that indicates whether the Platform Server generates at run time the value of this attribute.

Optional

 

Mandatory when the type is Integer or Long Integer.

 

Is Mandatory

Boolean value that indicates whether the attribute is mandatory.

 

Mandatory

No

The 'Is Mandatory' property does not create a constraint on the database. Database constraints are only created for primary keys and reference attributes.

 

If true, Platform Server validates, at run-time, if this attribute is filled-in. If false, when the attribute is not filled-in, the default empty values (spaces, 0, … ) are accepted.

Delete Rule

Referential mechanism used when the entity is deleted.

Optional

 

Mandatory when the type is <Entity> Identifier. In this case, the default value is Protected.

Learn more about Delete Rules

Default value

Default value of the attribute displayed if the attribute does not have a value introduced by the end-user.

 

Optional

 

The default value can be a literal or one of the following built-in functions:

NullDate(), NullIdentifier(), NullObject(), NullTextIdentifier(), CurrDate(), CurrTime(), CurrDateTime() or NewLine().

If this entity is a Foreign Entity with null value behavior the default value you enter here is propagated to every gathering data widget's Null Value property where this attribute is bounded to.

Label

Text used when the attribute is displayed in a Record Widget.

Optional

<Attribute Name>

This property is also used as the column header when exporting entity data to Excel.

See Also

Attributes Description