Self Join possible

[Bernie1502]

Hi all,
i have three tables:
subject
module
topic

every module is part of one subject, every topic is part of one module.
And, a module is dependent on other modules.

So i need to have Self Joins within the modules table - see the example json:

[
  {
    "_id": "subject_informatik",
    "type": "subject",
    "name": "Informatik",
    "modules": ["module_grundlagen_programmierung", "module_datenstrukturen"]
  },
  {
    "_id": "module_grundlagen_programmierung",
    "type": "module",
    "name": "Grundlagen der Programmierung",
    "subject_id": "subject_informatik",
    "dependencies": [],
    "topics": ["topic_variablen", "topic_kontrollstrukturen"]
  },
  {
    "_id": "module_datenstrukturen",
    "type": "module",
    "name": "Datenstrukturen",
    "subject_id": "subject_informatik",
    "dependencies": ["module_grundlagen_programmierung"],
    "topics": ["topic_array", "topic_linked_list"]
  },
  {
    "_id": "topic_variablen",
    "type": "topic",
    "name": "Variablen und Datentypen",
    "module_id": "module_grundlagen_programmierung"
  },
  {
    "_id": "topic_kontrollstrukturen",
    "type": "topic",
    "name": "Kontrollstrukturen",
    "module_id": "module_grundlagen_programmierung"
  },
  {
    "_id": "topic_array",
    "type": "topic",
    "name": "Arrays",
    "module_id": "module_datenstrukturen"
  },
  {
    "_id": "topic_linked_list",
    "type": "topic",
    "name": "Verkettete Listen",
    "module_id": "module_datenstrukturen"
  }
]

a) Is this possible with Budibase DB?
b) Alternate: i can host the DB externally, but - if i understood correct - i have to build the relationships in Budibase, and can't pick the table itself as source and target!?

How can i manage these?
Thanks a lot for any hint!

[poirazis]

hey @Bernie1502
self referencing relationships are not currently supported, but there are open Feature Requests for their support.

[Bernie1502]

ok, thanks - i will look for an alternative solution!