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)