Change Details

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 ```

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 ```

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 ```