[CAY-2554] Redesign dbRelationship's and join's structure

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.2.M1
• Fix Version/s: 4.3.M1
• Component/s: Core Library
• Assignee: Arseni Bulatski
• Reporter: Arseni Bulatski
• Created: 20/Mar/19 13:42
• Updated: 24/Feb/21 09:51

Description

Need to redesign DbRelationship and DbJoin in order to represent relation between entities.

DbJoin will hold relationship's condition(usual join with pairs of attributes or expression join)  and two dbRelationships, one at a time for each entities.

This change will better represent relation from database view and will help to implement some new features.

Structure:

DbJoin

• DbJoinCondition
• DbRelationship[]

Condition for pairs of attributes:

ColumnPairsCondition

• List<ColumnPair>

or ExpressionCondition(in future)

• Expression