---
title: "Defining Data Relationships (see Column Setting)"
slug: "column-reference-v1"
updated: 2024-09-10T11:26:28Z
published: 2024-09-10T11:26:28Z
canonical: "documents.trocco.io/column-reference-v1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Defining Data Relationships (see Column Setting)

## summary

TROCCO's Data Catalog provides a list of column references. It is displayed by clicking on the **column reference** tab.

              What is a column reference?

              

**A column reference** refers to the correspondence between columns. Tables with Column Setting can be [JOINed to each other in the ER Diagram](/docs/erd-and-join-v1). For information on how to define a column reference, see [Manual Column Setting](/docs/table-information-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E5%8F%82%E7%85%A7%E3%81%AE%E6%89%8B%E5%8B%95%E5%AE%9A%E7%BE%A9).

              Automatic Column Setting

              

Tables transferred to the data store using a specific Data Source Connector in TROCCO will automatically have Column Settings defined. For more information, see [Connectors Subject to Automatic Column Setting](/docs/automatic-metadata-fetched-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E5%8F%82%E7%85%A7%E3%81%AE%E8%87%AA%E5%8B%95%E5%AE%9A%E7%BE%A9%E3%81%AE%E5%AF%BE%E8%B1%A1%E3%81%A8%E3%81%AA%E3%82%8B%E3%82%B3%E3%83%8D%E3%82%AF%E3%82%BF).

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/column-reference-v1-2024-08-29-16-32-0.png)

### Filtering column references

Column references to be displayed in the list can be narrowed down as follows

- Filter by creation method
  - If you wish to narrow down the column references to be displayed, uncheck the boxes as appropriate.
  - By selecting the **creator**, you can also choose to view only the Column Setting references defined by that user.
- Filtering the search range
  - By default, all column references under the data store are visible.
  - To narrow your search, select a **project** (or database).
  - When a **project** (or database) is selected, its lower-level selections are displayed one after the other, allowing you to refine your selections more finely.

### Display ER Diagram

You can check the ER diagram for the table of selected column references. With the checkbox selected, click **Open ER Diagram**.

### Deleting column references

Manually defined Column Setting references can be deleted. Click the icon in the red box and click **Remove this column reference**.

              About auto-generated column references

              

The name of the creator of a Column **Setting** reference is **automatically defined**. Automatic Column Setting references cannot be deleted.