emm

Tables (14)

ei_analysis_config

  • Key (analysis_config_id) — integer — Primary key — NOT NULL
  • Field (best_period) — varchar
  • Field (ei_calc) — varchar
  • Field (enerygy_use_calc) — varchar
  • Field (energy_price_calc) — varchar
  • Field (parent_type) — varchar
  • plant_id — integer — Foreign key → plant.plant_id — NOT NULL
  • equip_id — integer — Foreign key → equip.equip_id — NOT NULL

ei_analysis_value (ei_ananlysis_value)

  • Key (ei_analysys_value_id) — integer — Primary key — NOT NULL
  • Field (date) — timestamp
  • Field2 (ei_value) — double
  • Field (energy_use_value) — double
  • Field (energy_price_value) — double
  • Key (analysis_config_id) — integer — Foreign key → ei_analysis_config.Key — NOT NULL

ei_config

  • Key (ei_config_id) — integer — Primary key — NOT NULL
  • Field (parent_type) — varchar
  • Field (config_name) — varchar
  • Field (config_tag) — varchar
  • Field (config_unit) — varchar
  • Field (use_yn) — boolean
  • plant_id — integer — Foreign key → plant.plant_id — NOT NULL
  • equip_id — integer — Foreign key → equip.equip_id — NOT NULL

ei_key_indicator_config_id (ei_key_indicator_config)

  • Key (ei_key_indicator_config_id) — integer — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (description) — varchar
  • Field (key_indicator_tag) — varchar
  • plant_id — integer — Foreign key → plant.plant_id — NOT NULL
  • equip_id — integer — Foreign key → equip.equip_id — NOT NULL
  • Field (parent_type) — varchar

ei_key_indicator_value

  • Key (ei_key_indicator_value_id) — integer — Primary key — NOT NULL
  • Field (date) — timestamp
  • Field (key_indicator_value) — double
  • Key (ei_key_indicator_config_id) — integer — Foreign key → ei_key_indicator_config_id.Key — NOT NULL

ei_same_condition (ei_same_condition_config)

  • Key (ei_same_condition_config_id) — integer — Primary key — NOT NULL
  • Field (parent_type) — varchar
  • Field (name) — varchar
  • Field (same_condition_tag) — varchar
  • Field (use_yn) — boolean
  • Field (err_rate) — integer
  • plant_id — integer — Foreign key → plant.plant_id — NOT NULL
  • equip_id — integer — Foreign key → equip.equip_id — NOT NULL

ei_same_condtion_value (ei_same_condition_value)

  • Key (ei_same_condition_value_id) — integer — Primary key — NOT NULL
  • Field (same_condtion_value) — double
  • Field (date) — timestamp
  • Key (ei_same_condition_config_id) — integer — Foreign key → ei_same_condition.Key — NOT NULL

ei_use_tag_config

  • Key (ei_use_tag_config_id) — integer — Primary key — NOT NULL
  • Field (parent_type) — varchar
  • Field (use_tag) — varchar
  • Field (description) — varchar
  • Field (use_compare) — boolean
  • Field (compare_unit) — varchar
  • plant_id — integer — Foreign key → plant.plant_id — NOT NULL
  • equip_id — integer — Foreign key → equip.equip_id — NOT NULL

ei_value

  • Key (ei_value_id) — integer — Primary key — NOT NULL
  • Field (ei_value) — double
  • Field (date) — timestamp
  • Key (ei_config_id) — integer — Foreign key → ei_config.Key — NOT NULL

equip

  • equip_id — integer — Primary key — NOT NULL
  • equip_name — varchar
  • Field2 (description) — varchar
  • plant_id — integer — Foreign key → plant.plant_id — NOT NULL
  • Key (equip_type) — varchar — Foreign key → equip_type_class.Key — NOT NULL

equip_type_class

  • Key (equip_type) — varchar — Primary key — NOT NULL
  • Field (equip_class) — varchar

issue

  • Key (issue_id) — integer — Primary key — NOT NULL
  • Field (parent_type) — varchar
  • Field (cause) — varchar
  • Field (action) — varchar
  • Field (date) — timestamp
  • Field (target_procedure_id) — varchar
  • Field (target_model_id) — varchar
  • plant_id — integer — Foreign key → plant.plant_id — NOT NULL
  • equip_id — integer — Foreign key → equip.equip_id — NOT NULL

plant

  • plant_id — integer — Primary key — NOT NULL
  • plant_name — varchar
  • description — varchar

tag_value

  • Key (use_tag) — varchar — Primary key — NOT NULL
  • Field (date) — timestamp
  • Field (value) — varchar