Schema Editor

The schema editor lets you add, remove, reorder, and configure columns. Each column has a name, type, optional role, and required flag.

Column EditorLive Preview

Inventory Columns

Column 1
Column 2
Column 3
Column 4
Column 5

Column Types

Choose the right type for each column. The type determines the input control and how values are displayed.

Text

Free-form text input for names, descriptions, SKUs, and other string values.

Number

Numeric input for quantities, counts, and other whole or decimal numbers.

Currency

Monetary values formatted with a dollar sign and two decimal places.

Date

Date picker for purchase dates, expiration dates, and other calendar values.

Select

Dropdown with predefined options such as condition, status, or location.

Column Roles

Roles give columns semantic meaning. They control how Legitski displays and calculates data across the interface.

name

Primary Name

The main display name for each item. Shown in table rows, card headers, and search results. Must be a Text column.

quantity

Stock Quantity

Current stock count. Displayed with color-coded badges (green = OK, red = low). Must be a Number column.

minQuantity

Minimum Quantity

Low stock threshold. When quantity drops to or below this value, the item is flagged. Must be a Number column.

price

Selling Price

The retail or selling price per unit. Used in total value calculations. Must be a Currency column.

cost

Unit Cost

Your cost or wholesale price per unit. Useful for profit margin analysis. Must be a Currency column.

barcode

Barcode / SKU

A unique identifier like a UPC, EAN, or internal SKU. Used for barcode scanning. Must be a Text column.

One role per column

Each role can only be assigned to one column at a time. For example, you cannot have two columns both assigned the "quantity" role. If a role is already taken, it will appear disabled in the role dropdown.