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

# Grid

# What is a Grid ?

A Grid is the **visual representation** of a Sheet. It's represented as a table with rows and columns.

<img src="https://mintcdn.com/stratumn/4rAewZdM7szac3r3/studio/database/images/grid.jpg?fit=max&auto=format&n=4rAewZdM7szac3r3&q=85&s=6a8f29f56f3c3364ee7d357003da7f57" style={{ borderRadius: '1rem' }} width="1859" height="721" data-path="studio/database/images/grid.jpg" />

## Columns

Columns are defined by the client and configured by the Stratumn team. There are **two specific types** of columns that you must be aware of.

### Primary Key

This type of column is used to identify a row, it **cannot be empty** and is used as a **display value** in case the row is referenced elsewhere.

It can be easily identified by the **little blue key** displayed in the column header:

<img src="https://mintcdn.com/stratumn/4rAewZdM7szac3r3/studio/database/images/primaryKey.jpg?fit=max&auto=format&n=4rAewZdM7szac3r3&q=85&s=4c88b5bf53173d6944655efaa150fc8b" style={{ borderRadius: '1rem' }} width="1874" height="115" data-path="studio/database/images/primaryKey.jpg" />

### Reference

This type of column is used to symbolize a link with **another Sheet**.

It can be easily identified by the **blue chips** representing selected rows of the other Sheet inside any cell of the column.

<img src="https://mintcdn.com/stratumn/4rAewZdM7szac3r3/studio/database/images/chip.jpg?fit=max&auto=format&n=4rAewZdM7szac3r3&q=85&s=9b29af6f46bb78956af137407039f21c" style={{ borderRadius: '1rem' }} width="454" height="223" data-path="studio/database/images/chip.jpg" />

Other types of columns are:

* **Text**: A simple text column.
* **Number**: A number column.
* **Boolean**: A boolean column taking form of a checkbox.
* **Date**: A date column.

### Filters

Filters can be applied to a column by clicking on the **filter icon** in the column header.

<img src="https://mintcdn.com/stratumn/4rAewZdM7szac3r3/studio/database/images/filter.jpg?fit=max&auto=format&n=4rAewZdM7szac3r3&q=85&s=feed64c449ac3312b7b4050fc028b249" style={{ borderRadius: '1rem' }} width="686" height="293" data-path="studio/database/images/filter.jpg" />

**Alphabetical filters** sorting is also available by clicking anywhere inside the column header. A little arrow will show up to indicate the sorting direction.

<img src="https://mintcdn.com/stratumn/4rAewZdM7szac3r3/studio/database/images/alphabetical.jpg?fit=max&auto=format&n=4rAewZdM7szac3r3&q=85&s=efb5fa5336c193e8f1a55c71fa75250a" style={{ borderRadius: '1rem' }} width="453" height="71" data-path="studio/database/images/alphabetical.jpg" />
