Designing a database for your Mendix app

In addition to attributes and associations, there are also other entity properties to consider when designing the data layer of your Mendix application. These properties include event handlers, access rules, validation rules, and indexes. In this section, we will briefly go over these properties and how to set them in a Mendix entity. For more information on how these constructs work, it is recommended for you to read more about data architecture and database design. For now, we will cover a simple use case of each.

Using validation rules at the entity level

Validation rules are rules used to ensure that data being entered into the data field conforms to a desired standard. Rules can be about ensuring that a value stays unique, such as on object ID or an email address. Rules can also be about validating the length or format of the data as well as forcing the data to equal a specific value. Entity-level validation rules will be executed...