RealTime

📊 Overview: 11 Fields

7 Indexes

2 Many-to-One Relations

2 One-to-Many Relations

📝 Description

🗨️ Stores real-time machine sensor data and production cycle information from manufacturing equipment. Captures timestamped sensor readings, cycle times, stoppages, and work order linkage for production monitoring and analysis.

ℹ️ Table Information

• Table ID: 57
• UUID: B037623CFAEA3D4EB94D9916905B77FC
• Primary Key: 🔑 ID
• Generated: 🕐 2025-12-04T14:34:19Z

---

📑 Table of Contents

• 📋 Fields (11)
• 🔍 Indexes (7)
• 🔗 Many-to-One Relations (2)
• 🔗 One-to-Many Relations (2)
• 🔗 Related Items
  • Classes (3)
  • Forms (6)

---

📋 Fields

Field	Type	Constraints	Description
🔑 ID	Long Integer	🔑 PK, ✨ Unique, ⚡ Auto	-
SensorData	Object	-	-
EndDate	Date	🚫 Not Null	-
EndTime	Time	🚫 Not Null	-
CycleTime	Real	🚫 Not Null	-
Stoppage	Boolean	🚫 Not Null	-
Impressions	Integer	🚫 Not Null	-
WorksOrder	Long Integer	🚫 Not Null	-
MouldClosedTime	Real	🚫 Not Null	-
DownReason	Long Integer	-	-
Robot	Boolean	🚫 Not Null	-

🔍 Indexes

Field	Type	Kind	Unique
Stoppage	Cluster	regular	-
ID	B-Tree	regular	✨ Yes
Robot	Cluster	regular	-
WorksOrder	Cluster	regular	-
EndDate	Cluster	regular	-
WorksOrder	B-Tree	regular	-
DownReason	Keywords	regular	-

🔗 Many-to-One Relations

Relation Name	Destination Table	Source → Destination	State	Description
WorksOrderEntity	WorksOrder	WorksOrder → Works_Order_No	Active	Many-to-one relationship linking real-time data records to their parent work order. Allows querying all sensor data for a specific production job.
DownReasonsEntity	DownReasons	DownReason → ID	Active	Many-to-one relationship linking real-time records to the reason code for machine downtime. Optional relationship (only set when stoppage occurred).

🔗 One-to-Many Relations

Relation Name	Source Table	Source → Destination	State	Description
FirstRealTimeSensorExceptionsSelection	RealTimeSensorExceptions	FirstRealTimeID → ID	Active	One-to-many relationship where this RealTime record is the first occurrence in a sensor exception range. Links to RealTimeSensorExceptions tracking anomalies.
LastRealTimeSensorExceptionsSelection	RealTimeSensorExceptions	LastRealTimeID → ID	Active	One-to-many relationship where this RealTime record is the last occurrence in a sensor exception range. Links to RealTimeSensorExceptions tracking anomalies.

🔗 Related Items

📦 Classes

• RealTime - ORDA DataClass class for RealTime table
• RealTimeEntity - ORDA Entity class for RealTime table
• RealTimeSelection - ORDA EntitySelection class for RealTime table

📄 Forms

• ChangeRealTimeImpressions - Data source for ChangeRealTimeImpressions form
• CycleHistory - Data source for CycleHistory form
• DownTime - Data source for DownTime form
• RTSUM - Data source for RTSUM form
• StockTakeInput - Data source for StockTakeInput form
• ToolTemps - Data source for ToolTemps form

---

Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:19Z