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

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