Question

Why in all mendix modeling there is no definition of primary keys and foreign keys in database modeling ?

0

all the examples I've seen of modeling in mendix videos, associations or relationships do not take into account the creation of primary (numeric) keys often used in traditional modeling, to maintain data integrity, performance in updates and searches and avoid duplication of records in tables, in addition to allowing relationships between tables.

asked 2021-09-10

AILTON FELICIANO

3 answers

Hardy Chen · Answer 1 · 2021-09-10

Under the hood, each entity actually does have it's own id in order to maintain uniqueness. The same applies to associations, which are actually tracked in relationship tables within the actual database, so functionally, associations will cover the bases of foreign keys.

The domain model is more of an abstracted view as it's more visual for the developer. So in the modeler, the dev doesn't need to worry about primary/foreign keys while developing since the Mendix runtime handles the mapping of the objects in the modeler to the database schema.

AILTON FELICIANO · Answer 2 · 2021-09-10

thank you very much for you answer, have good times, friend

Henri Schellingerhout · Answer 3 · 2021-09-11

In addition to Hardy’s useful answer.

Domain model is a business domain model, so the business and citizen developers need to understand it easily. It is not a database model. But you are able to set validation constraints and indexes for data integrity and performance.