I hope I’ve misunderstood this but, can we not have foreign keys such as UUID in the child tables? Are they strictly embedded in the NCB data tables?
How can I get my external logic apps to query related data if I cant see the key?
Hello, I did not understand your question. You need to provide examples and details.
In a postgres table if we need a foriegn key to another table it shows as a column/field in the table.
In NocoBase, even though there is the possibility of creating a one to one relationship, that key is not stored in the table where it is created.
Hello, the relational field is a virtual field in the NocoBase data table, representing the relationship between the two tables, and will not be reflected in the physical database table.
Foreign keys in a relation field will be physical fields in the data table.