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