Kopens Data

Tables (9)

mm_alarm

  • tag_id — text
  • alarm_config_desc — text
  • alarm_config_id — text
  • alarm_config_name — text
  • alarm_config_priority — text
  • alarm_type — text
  • condition — text
  • duplicate_check — boolean
  • duplicate_check_time — int
  • epl — text
  • insert_date — timestamp
  • message — text
  • recieve_me — boolean
  • recieve_others — text
  • send_email — boolean
  • send_sms — boolean
  • update_date — timestamp

mm_asset

  • asset_id — text
  • asset_name — text
  • asset_order — int
  • asset_svg_img — text
  • asset_type — text
  • description — text
  • insert_date — timestamp
  • parent_asset_id — text
  • site_id — text
  • table_type — text
  • update_date — timestamp

mm_json_model

  • path — text
  • payload — text

mm_opc

  • opc_id — text
  • description — text
  • insert_date — timestamp
  • opc_name — text
  • opc_server_ip — text
  • opc_type — text
  • site_id — text
  • update_date — timestamp

mm_security

  • security_id — text
  • insert_date — timestamp
  • object_permission_array — text
  • security_desc — text
  • update_date — timestamp

mm_site

  • site_id — text
  • description — text
  • insert_date — timestamp
  • lat — text
  • lng — text
  • site_name — text
  • update_date — timestamp

mm_tag

  • tag_id — text
  • alias_name — text
  • description — text
  • display_format — text
  • hi — text
  • hi_hi — text
  • importance — int
  • insert_date — timestamp
  • interval — text
  • java_type — text
  • lat — text
  • linked_asset_id — text
  • lng — text
  • lo — text
  • lo_lo — text
  • max_value — text
  • min_value — text
  • opc_id — text
  • site_id — text
  • tag_name — text
  • tag_source — text
  • trip_hi — text
  • trip_lo — text
  • unit — text
  • update_date — timestamp

mm_user

  • user_id — text
  • email — text
  • insert_date — timestamp
  • name — text
  • password — text
  • phone — text
  • role — text
  • security_id — text
  • update_date — timestamp

pd_result_00

  • id — text
  • pd_sta_tm — timestamp
  • pd_end_tm — timestamp
  • jijong — text
  • avg_py — text
  • pd_type — text
  • bad_r1 — text
  • bad_r2 — text
  • pd_end_tm — ASC
  • jijong — ASC
  • avg_py — ASC
  • pd_type — ASC