Demo

Units of measure

UOM categories, units, and conversion factors. Prefer these over inventing product-specific unit tables when a shared UOM model is enough.

UnitCategoryEntity

Table: unit_category — groups related units (Weight, Volume, Time).

  • id: number — primary key
  • name: string — unique category name

UnitEntity

Table: unit — standard units of measurement.

  • id: number — primary key
  • name: string — e.g. Kilogram
  • symbol: string — e.g. kg
  • code: string — internal code
  • isBase: boolean — base unit for its category
  • categoryId: number — UnitCategoryEntity

Unit conversion

Table: unit_conversion — rules for converting between units.

  • fromUnitId: number
  • toUnitId: number
  • conversionFactor: number — multiplier