It feels to me like you're mixing the terms schema and relations/joins. You can have a schema on a table without any foreign keys or relations. But in the abov

It feels to me like you're mixing the terms schema and relations/joins. You can have a schema on a table without any foreign keys or relations. But in the above you seems to use those concepts interchangeably. Taking OPs comments directly about schemas, it seems true to me.