Entity (Module) relationship enhancement, column strategy supports o2o, o2m, m2m, m2o.

[cabbage89]

I am familiar with hibernate orm in java world, it supports complete entity relationship configuration, such as one to one, one to many, many to many, many to one.

I noticed that in the one-to-many relationship scenario, the field cannot use EncodingStrategyPlain, which is only supported in the JSON type. this commit.

Hibernate uses database foreign keys to define the relationship between o2o and o2m, and m2m uses an intermediate table.

The advantage of this is that in the page builder, there is no need to set Prefilter, such as LeadId = ${recordID}. Automatically deduced from foreign key relationships. We call the entity's navigation field.

We can even customize a field that refers to an object in the grid view, such as referencing the title field of leads module in task module by using leader.title

[cabbage89]

The following is my pseudo code, such as defining a task list view through XML

  <grid title="Task List" module="Task">
         <field name="Subject"/>
         <field name="Leads.Title"/> <!--This field is the title of the reference lead object-->
        <field name="Leads.Owner.NickName"/> <!--This field is the nickname of the lead owner（second-level reference）-->
</grid>