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.