Linked Records CRUD

[shogunpurple]

Users need to be able to link records from different tables together.

For example, a student may attend many classes.

This would include the ability to:

• Create a linked record column in the student table for classes
• Select which classes you want to link
• Have the linked records displayed for a particular record in the backend UI when you click on it. Ie. "Show me all the classes that this student is part of."

Technical notes:
Decide how to link records together. This requires a research spike. We need to know whether to:

• Keep and improve the current implementation where we link one record to another using their IDs in an array
• Create a view that keys linked records by the parents ID. You then query this view by ID to get all the linked records for it.

With the view implementation, we could possibly create a view that contains bidirectional links for a specific record using a composite key and query it out using the Id of either the parent or the child. For example:

emit(["childLinkedField", "parentId"], ["childId", "otherChildId"])

emit(["parentLinkedField", "childId"], ["parentId", "otherParentId"])