Support compound references (relationships)

XMLWordPrintableJSON

    • Type: Story
    • Resolution: Unresolved
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • None
    • Developer Tools

      Compound references - one document references another document using multiple fields. 

      Example:

      We have two tables, articles and comments. The articles are indexed by (author_id, article_id). So the comments reference the articles by (author_id, article_id).

      In the storage, we do support this type of relationships. Fields is an array.

      type RelationshipSide = {
        ns: Namespace;
        cardinality: number;
        fields: FieldPath[];
      };
      

       

      This task is to make sure these types of relationships can be managed via the Data Modeling side panel, as well as represented in the diagrams.

       

      For reference, see the attached screenshots showing a Composite Foreign Key in the Relational Migrator (sidepanel and diagram).

            Assignee:
            Unassigned
            Reporter:
            Paula Stachova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: