Manual Tables & Fields

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 fieldFull 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.