inferencer: determine the relations for more than 1 foreign keys referring to the same target table
Hello, i have a table with 3 foreign keys inside a table referring to the same one table. How should i name the foreign key column to give insight to inferencer that the three columns refer to the same table
For example:
Tenant Table:
- tenant_id refers to id on user table
- landlord_id refers to id on user table
- agent_id refers to id on user table
how should i name the output on the API to make sure these columns refers to the same user table?
For example:
Tenant Table:
- tenant_id refers to id on user table
- landlord_id refers to id on user table
- agent_id refers to id on user table
how should i name the output on the API to make sure these columns refers to the same user table?
