RTSUM

πŸ“Š Overview: 10 Fields 4 Indexes 1 Many-to-One Relations

πŸ“ Description

πŸ—¨οΈ Summary table aggregating real-time production data by period. Provides pre-calculated totals for reporting and dashboard displays.

ℹ️ Table Information

  • Table ID: 67
  • UUID: B4BCF8D18A05AB4AB5784486D50CD234
  • Primary Key: πŸ”‘ ID
  • Generated: πŸ• 2025-12-04T14:34:29Z

πŸ“‘ Table of Contents


πŸ“‹ Fields

Field Type Constraints Description
πŸ”‘ ID Long Integer πŸ”‘ PK, ✨ Unique, ⚑ Auto -
dDate Date 🚫 Not Null -
WorksOrder Long Integer 🚫 Not Null -
Stoppage Boolean 🚫 Not Null -
DownCode Long Integer 🚫 Not Null -
Impressions Long Integer 🚫 Not Null -
Seconds Real 🚫 Not Null -
Instances Integer 🚫 Not Null -
Target Real 🚫 Not Null -
TC Boolean 🚫 Not Null -

πŸ” Indexes

Field Type Kind Unique
dDate Cluster regular -
Stoppage Cluster regular -
ID Keywords regular ✨ Yes
WorksOrder Keywords regular -

πŸ”— Many-to-One Relations

Relation Name Destination Table Source β†’ Destination State Description
WorksOrderEntity WorksOrder WorksOrder β†’ Works_Order_No Active -

πŸ“¦ Classes

  • RTSUM - ORDA DataClass class for RTSUM table
  • RTSUMSelection - ORDA EntitySelection class for RTSUM table

πŸ“„ Forms


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