[Tagging] Architectural Discovery: Data models for taxonomies

[ChrisChV]

Description

Research the best possible implementation for the taxonomy data model. Explore different possibilities (JSON vs database relations) for the use cases defined in the reference links below. The supported field types are:

• Free form field that accepts any text (with autocomplete suggestions).
• Single select: a selection from a list of options.
• Multi select: one or more selections from a list of options.

Explore what is the best approach for storing taxonomies in the platform and come up with the database modeling for a taxonomy system that supports those characteristics.

• These taxonomies will be used to validate and render tag fields on the frontend.
• The models should also allow conditional nesting for the single select fields, allowing up to 3 levels of linked child items.
• The data models should also consider that taxonomies can be instance wide or per-organization (check the Users section of the MVP specs for details on the expected permissions).
• Taxonomies can be turned “on” or “off” per context: instance, organization and course.

Reference documents:

• Taxonomy Field Types: list of fields that should be supported in the MVP.
• Taxonomy Analysis: lists a few taxonomies and their structures.
• Features and requirements: requirements for taxonomy system (look at “Taxonomy Management System” on the table).

[ChrisChV]

Discovery document