Comment #⁨22⁩

If we are supporting this kind of relationships, i think one important option to validate is whether the relationship is

  1. one to one (person - id)
  2. one to many (team members - project)
  3. many to many (classes - students)
  1. In reply to bharat bharat

    If we are supporting this kind of relationships, i think one important option to validate is whether the relationship is
    one to one (person - id)
    one to many (team members - project)
    many to many (classes - students)

    I don’t know if SQL-style relationships are necessary, although when modeling certain domains, being able to restrict how many instances of a type of something can be related to another type of something could be essential to ensure correctness of data.

    What you’re after is the ability to constrain a relationship’s cardinality.

    I believe I stumbled upon some unpolished area of Tana where it’s possible to set cardinality of any given field. I think it might have been an abandoned feature?