Capture table relationships #2
Description
When working with collections of tables that are essentially a database export (e.g. https://github.com/microsoft/AIforEarthDataSets/blob/main/data/forest-inventory-and-analysis.md) tables will often be linked by one or more primary / foreign keys.
We might be able to expose that metadata through a [ relations ] object on Column object. Each Relation would be something like
| Field | Type | Description |
|---|---|---|
| table | string | Name of the other table. Should be present in table:columns. |
| columns | [ string ] | Colum names from the other table to join on |
We could maybe have a type to that's one-to-one, one-to-many, many-to-one, or many-to-many. Dunno if that would be useful.