Reference

Last updated on 2025-06-26 | Edit this page

Glossary


Attribute
A property or characteristic of an entity, represented as a column in a table.

Base
A collection of tables in NocoDB, similar to a database.

Column
A vertical set of data values in a table, representing a single attribute.

Data Type
The kind of data a field can hold, such as text, number, date, etc.

Entity
A real-world object or concept represented in a database (e.g., Artist, Artwork).

Field
A single piece of data in a table, represented by a column.

Foreign Key
A field in one table that links to the primary key of another table, creating a relationship.

Link Field
A special field type in NocoDB used to create relationships between tables.

Normalization
The process of organizing data to reduce redundancy and improve integrity.

One to Many (Has Many)
A relationship where one record in a table can relate to multiple records in another table.

One to One
A relationship where one record in a table relates to only one record in another table.

Many to Many
A relationship where multiple records in one table can relate to multiple records in another.

Primary Key
A unique identifier for each record in a table.

Record
A single row in a table, representing one instance of an entity.

Relation
A connection between tables, usually established through keys.

Table (Relation)
A set of data organized in rows and columns.

Transitive Dependency
A type of dependency in which a non-key attribute depends on another non-key attribute.

View
A way to display or filter data in NocoDB without changing the underlying table.