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