The equipment_schedule Data Model

The equipment_schedule data model creates a relationship between unit ID of a site and the start time of a production event. The start time is associated with end time and event reason.

The equipment_schedule data model uses the following primary key: ((tenant_id, enterprise_id, site_id, unit_id), start_time)

The equipment_schedule data model contains the following columns:
  • tenant_id
  • enterprise_id
  • site_id
  • unit_id
  • start_time
  • end_time
  • event_reason_name
  • event_reason_name_std
  • ins_ts
  • npdet_id
  • upd_ts