---
title: "other_tables"
slug: "other-tables-syntax"
updated: 2022-12-13T01:44:18Z
published: 2022-12-13T01:44:18Z
---

> ## 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.