With linked fields, how to know which table originally established that link?

Question

In actual databases, I can explicitly define which table holds the linked column, e.g., Table A has a foreign key field to Table B. So, if I look directly at Table B by itself, I wouldn't know that it has a relationship with Table A. But that's okay, because Table B isn't supposed to hold that information itself.

But in Airtable, I noticed that when I put a linked field in Table A to Table B, instantly that field also appears in Table B. While that's very useful and helpful to understand the bigger picture of how things are interconnected, now I no longer know which table was the original one that established that relationship.

The purpose that I need to know this is to transform an Airtable base into an SQL database schema, so I need to know the "native" fields of each table. Any tips, or anything I missed?

Best answer by luqmaan

I don't think that's possible I'm afraid. Perhaps when you create the linked fields you could edit their names to include this information?

I have figured out a simple solution: by creating a dedicated grid view for each table that only shows the "native" fields, to be conventionally named as "Native". Thank you for your reply, it might have sparked this idea in my mind.

luqmaan · Accepted Answer

I don't think that's possible I'm afraid. Perhaps when you create the linked fields you could edit their names to include this information?

I have figured out a simple solution: by creating a dedicated grid view for each table that only shows the "native" fields, to be conventionally named as "Native". Thank you for your reply, it might have sparked this idea in my mind.

TheTimeSavingCo · Answer

I don't think that's possible I'm afraid.  Perhaps when you create the linked fields you could edit their names to include this information?

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded