Columns
Columns define the information stored about each record in a table.
If a table represents a type of thing—such as a person, room, or booking—columns describe the details recorded for each item.
For example, a Person table might include columns such as:
- first name
- last name
- phone number
- email address
Each row in the table stores a value for each column.
What a column represents
A column represents one attribute of the records stored in a table.
All rows in the table follow the same structure, meaning they store values for the same set of columns.
For example, if a table includes a Phone Number column, each row may store a phone number for that record.
Columns define the structure of the data stored in the table.
Column types
Each column has a defined type that determines what kind of value it can store.
Examples of common column types include:
- text
- numbers
- yes / no values
- dates or times
The column type determines how values are validated and how they are interpreted by the system.
Columns and the user interface
Minyu uses column definitions to automatically generate input fields in forms and display values in lists.
Because the interface is derived from the data model, the columns defined on a table influence how users enter and view information throughout the system.
Changes to columns therefore affect how data appears and behaves across the application.
Related resources
Reference
Related concepts