When you have an integer, you're able to link it to another table as a table reference.
Technically speaking, it's just an integer, and if I want to, I can link it to multiple tables if I need to? Example below, with the following Tables:
- Posts
- Birthdays
- Comments
Both Posts and Birthdays can have comments, so under Table 3, Comments, I can have a 'Parent' field, which could link to both Posts and Birthdays.
Within Xano, I just have it as an ordinary integer field, and not link it to any table, but in my queries and function stack, I can still use that integer as an ID to query both the Posts and Birthdays table should I need to.
What do you guys think? Or should I not structure my data in such a way?