Equipment Class

Overview

The EquipmentClass entity represents categories or types of equipment within the manufacturing environment, organized in a hierarchical structure. Equipment classes can be nested to form multi-level groupings, enabling classification from high-level categories (e.g., 'Rotating Equipment') down to specific subtypes (e.g., 'CentrifugalPumps').

Table Structure

The following table outlines the SQL columns for the equipment_classes table, providing a brief description of each.

Column	Type	Description	Example
id	String (ULID)	Unique identifier for the entity.	01JAP8RJBN-8ZTPXSGY-J9GSDPE1
enabled	Boolean	If the entity is enabled or not.	true
created_date	DateTime	Date the entity was created.	2024-12-31T19:48:44Z
created_by	String	Person who created the entity.	TamakiMES
modified_date	DateTime	Date the entity was modified. Value is null upon creation, and gets initially populated upon the first edit.	2024-12-31T19:48:44Z
modified_by	String	Last person to modify the entity. Value is null upon creation, and gets initially populated upon the first edit.	TamakiMES
notes	String	Notes about the entity.	This entity has these extra notes
spare1	String	The first spare column that can be used for additional context on the entity.	some extra context 1
spare2	String	The second spare column that can be used for additional context on the entity.	some extra context 2
spare3	String	The third spare column that can be used for additional context on the entity.	some extra context 3
name	String	Name of the equipment class. Required and unique within the parent equipment class.	CentrifugalPumps
description	String	Optional description of the equipment class.	High-speed centrifugal pumps
parent_id	String (ULID)	References the parent equipment class, creating a hierarchical structure. See equipment_classes.	01JAP8R5RT-3FPXQABY-7KQZT6VF
path	String (unique)	Unique path for the equipment class, generated based on the hierarchy.	Pumps/CentrifugalPumps

Field Details

name

The name of the equipment class must be unique within its parent class. Top-level equipment classes have unique names across all top-level classes.

parent_id

References the parent EquipmentClass, enabling a hierarchical structure. A null parent_id indicates a top-level equipment class. See equipment_classes for details.

path

The path is a unique identifier for the equipment class, automatically generated by concatenating parent class names separated by forward slashes.