Hello, how are you?
Is it possible to create a Foreign Key (FK) between collections from two different Data Sources?
In my case, I use a PostgreSQL Data Source and I need to create a FK in the “orders” collection, which is in the “purchases” Data Source, pointing to the “suppliers” collection, which is in the “registrations” Data Source. However, when I try to do this, only collections from the same Data Source are available.
PostgreSQL structure:
Schemas: “registrations” and “purchases”
Tables: “registrations.suppliers” and “purchases.orders”
Does anyone know how I can solve this?
PS: I created a View of the “registrations.suppliers” table in the “purchases” schema, and it appeared in the same Data Source in NocoBase. However, it’s impossible to create a relationship because collections without a Primary Key cannot be related (Views do not store PKs). Materialized Views, on the other hand, do not appear as collections in NocoBase.