444

Tables (7)

ew_management_kpi_approval_history

  • mgmt_kpi_approval_id — serial4 — Primary key — NOT NULL
  • mgmt_kpi_id — int4 — NOT NULL
  • reference_year — varchar(4)
  • approval_cl_cd — varchar(2)
  • approval_content — varchar(500)
  • audit_id — varchar(15)
  • audit_name — varchar(20)
  • audit_datetime — timestamp

ew_management_kpi_base

  • mgmt_kpi_id — serial4 — Primary key — NOT NULL
  • company_cd — varchar(100)
  • tenant_id — varchar(50)
  • bplc_cd — varchar(100)
  • bld_id — varchar(50)
  • energy_waste_cl_cd — varchar(2)
  • reference_year — varchar(4)
  • regit_datetime — timestamp
  • audit_datetime — timestamp

ew_management_kpi_detail

  • mgmt_kpi_detail_id — serial4 — Primary key — NOT NULL
  • mgmt_kpi_id — int4 — NOT NULL
  • reference_month — varchar(2)
  • energy_type_cd — varchar(2)
  • constitute_cl_cd — varchar(4)
  • constitute_val — varchar(300)
  • symbol_unit_cd — varchar(2)
  • audit_datetime — timestamp

ew_management_reason

  • mgmt_reason_id — serial4 — Primary key — NOT NULL
  • mgmt_id — int4 — NOT NULL
  • reference_month — varchar(2)
  • energy_type_cd — varchar(2)
  • reason_content — varchar(500)
  • audit_datetime — timestamp

ew_service_connection_api_detail

  • service_connection_detail_id — int4 — Primary key — NOT NULL
  • service_connection_id — int4 — NOT NULL
  • param_name — varchar(50)
  • param_val — varchar(200)
  • param_desc — varchar(200)
  • sort_seq — int4
  • audit_datetime — timestamp

iv_alarm_rule

  • alarm_rule_id — int4 — Primary key — NOT NULL
  • alarm_rule_detail_id — int4 — NOT NULL
  • rule_type — int4 — NOT NULL
  • expression — varchar
  • spark_include_sql_text — text
  • spark_exclude_sql_text — text
  • alarm_rule_group_id — int4 — NOT NULL
  • alarm_rule_super_id — int4
  • use_yn — bpchar(1) — NOT NULL
  • distribution_status_code — varchar
  • distribution_datetime — timestamptz

sp_response_team

  • company_cd — varchar(100) — Primary key — NOT NULL
  • bplc_cd — varchar(100) — Primary key — NOT NULL
  • bld_id — varchar(50) — Primary key — NOT NULL
  • response_team_id — varchar(4) — Primary key — NOT NULL
  • response_team_name — varchar(30)
  • default_yn — varchar(1)
  • main_task — varchar(100)
  • organization — varchar(100)
  • step1_task — varchar(100)
  • step2_task — varchar(100)
  • step3_task — varchar(100)
  • step4_task — varchar(100)
  • assign — varchar(1000)
  • regist_datetime — timestamp
  • register_id — varchar(15)
  • register_name — varchar(20)
  • audit_datetime — timestamp
  • audit_id — varchar(15)
  • audit_name — varchar(20)
  • use_yn — varchar(1)