Page MenuHomeSealhub

Sealious PostgreSQL integration - refrences tables with information needed joins query
Open, NormalPublic3 Points

Description

This task is about investigating what columns we need to use for future joins. This needs to be done for all 3 "Refrence" fields. We need to determine if we need a column or not and in which tables. If column is needed it will probably be INT REFERENCES but this is also part of the investigation that needs to be done. Implementic the locig is also part of this task

Make POC in code

SingleReference				References another item from given collection										
ReverseSingleReference			A list of all items from a given collection that point to this item in a given field					
DeepReverseSingleReference		Stores an array of ids connected to a given item through n-to-n relationship

Details

Coded by
FilipI
Reviewed by
kuba-orlik
Action required from
FilipI

Revisions and Commits

Event Timeline

jenkins-user updated Coded by, added: FilipI.
jenkins-user updated Action required from, added: FilipI.
FilipI added a revision: Restricted Differential Revision.Thu, May 22, 19:41
jenkins-user moved this task from Doing to Review on the Kanban board.
jenkins-user moved this task from Review to Doing on the Kanban board.
jenkins-user updated Reviewed by, added: kuba-orlik.