What is a table?
Think of a table as a single spreadsheet that stores one kind of information.
- One table for Staff.
- One table for Leave Applications.
- One table for Office Equipment.
Every row in the table is one record — one staff member, one leave application, one item of equipment.
Every column in the table is one field — Full Name, Start Date, Serial Number.
You design the columns; the platform handles the rest
When you add a table in Builder, you're really designing the shape of that data — what columns it has, what kind of value goes in each.
You don't write any code. Luna creates the database table, the data-entry form, the list page, and the detail page from your column definitions.
Glossary
- Table — one collection of similar records (e.g. all leave applications).
- Field — one column on the table (e.g. Start Date).
- Record — one row in the table (e.g. Ahmad's leave request from 3 May to 5 May).
- Type — what kind of value a field holds (text, date, number, yes/no, …). Pick the right type and the form gets the right input automatically.
- Required — the field must be filled in before saving.
- Unique — no two records can have the same value (e.g. staff IC number).
Where to next
- Add your first field — step-by-step.
- Field types — pick the right one — quick reference.
- Required, unique, indexed — when each constraint matters.