Tables
Tables define the different types of things the system keeps track of.
Each table represents one category of records, such as people, rooms, bookings, or equipment.
Within a table, each row represents one specific item.
For example, a Person table may contain one row for each person, while a Room table contains one row for each room.
Tables provide the basic structure for organizing information in the system.
What a table represents
A table represents a type of item in the organization.
All rows in the table share the same structure.
This means every row stores the same kinds of information.
For example, a Person table might store information such as:
- name
- phone number
- email address
Each row then represents one specific person.
Rows
Rows represent individual records.
If the table represents people, each row represents one person.
If the table represents rooms, each row represents one room.
Rows are the actual data stored in the system.
System-managed fields
In addition to the information defined by administrators, Minyu automatically stores some internal metadata for each row.
These fields help the system manage identity, history, and synchronization.
Examples include:
- a unique internal identifier
- timestamps for when a record was created or updated
- references used internally by the system
These fields are managed automatically to ensure consistent behavior across the system.
Table metadata and behavior
Tables also include system metadata that influences how the table behaves in the user interface.
This metadata helps determine how records are presented in forms, lists, and other views.
Because Minyu derives much of its interface directly from the data model, the structure and metadata of a table affect how users interact with the data throughout the system.
Related resources
Reference
Related concepts