--- title: "other_tables" slug: "other-tables-syntax" updated: 2022-12-13T01:44:18Z published: 2022-12-13T01:44:18Z canonical: "code.tag.bio/other-tables-syntax" --- > ## Documentation Index > Fetch the complete documentation index at: https://code.tag.bio/llms.txt > Use this file to discover all available pages before exploring further. # other_tables The `other_tables` array contains table objects to join in a *"one-to-many"* relationship from the one `entity_table` and additional source data. Source data to be joined in a *"one-to-one"* relationship should be attached to the `entity_table` within a `joins` array. All available attributes of the parent `table` object apply. ``` [ { "table": "~/dir_with_source_data/ooo1.csv", "table_alias": "ooo1", "id_columns": { "ooo1": "uuuu" }, "parsers": "config/parsers/ooo1_parsers.json" }, { "table": "~/dir_with_source_data/ooo2.csv", "table_alias": "ooo2", "id_columns": { "ooo2": "uuuu" }, "parsers": "config/parsers/ooo2_parsers.json" } ] ``` ## id_columns **usage: *required*** The `id_columns` object is a key, value pair of strings which defines the columns used to connect two data sources. The **key** of this object is a column within the joined table and the **value** is a column within the parent table.