new

Tables (30)

TB_ACPMD_AGG_10M

  • ACPMD_AGG_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • LOAD_INST_PWR — NUMBER(18,6)
  • LOAD_ACTV_PWR — NUMBER(18,6)
  • LOAD_REACT_PWR — NUMBER(18,6)
  • LOAD_PWR_FACTOR — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_BMS_AGG_10M

  • BMS_AGG_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • SOC — NUMBER(18,6)
  • SOC_MIN — NUMBER(18,6)
  • SOC_MAX — NUMBER(18,6)
  • PWR_LIMIT — NUMBER(18,6)
  • CELL_DEV_P — NUMBER(18,6)
  • SOC_ZERO_YN — NUMBER(1)
  • SOC_LOW_YN — NUMBER(1)
  • SOC_HIGH_YN — NUMBER(1)
  • SOC_BLOCK_YN — NUMBER(1)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_BMS_SITE_AGG_10M

  • BMS_SITE_AGG_ID — VARCHAR2(36) — Primary key — NOT NULL
  • CMPLX_ID — VARCHAR2(36) — Foreign key → TB_EMS_CMPLX.CMPLX_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • BMS_SOC_MIN — NUMBER(18,6)
  • BMS_SOC_MAX — NUMBER(18,6)
  • BMS_ZERO_YN — NUMBER(1)
  • BMS_LOW_YN — NUMBER(1)
  • BMS_HIGH_YN — NUMBER(1)
  • BMS_BLOCK_YN — NUMBER(1)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_CMMN_CD

  • CMMN_CD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • CMMN_CD_GRP_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD_GRP.CMMN_CD_GRP_ID — NOT NULL
  • CD — VARCHAR2(64) — NOT NULL
  • CD_NM — VARCHAR2(100) — NOT NULL
  • SORT_ORD — NUMBER(10) — NOT NULL
  • USE_YN — NUMBER(1) — NOT NULL

TB_CMMN_CD_GRP

  • CMMN_CD_GRP_ID — VARCHAR2(36) — Primary key — NOT NULL
  • GRP_CD — VARCHAR2(64) — NOT NULL
  • GRP_NM — VARCHAR2(100) — NOT NULL
  • USE_YN — NUMBER(1) — NOT NULL

TB_EMS_BAT_DCDC_RCRD

  • BAT_DCDC_RCRD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_RAW_RCRD.DEV_ID — NOT NULL
  • OBS_DT — TIMESTAMP WITH TIME ZONE — Foreign key → TB_EMS_RAW_RCRD.OBS_DT — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_RAW_RCRD.DEV_TYPE_CD — NOT NULL
  • DEV_MOD_V — NUMBER(18,6)
  • DEV_MOD_A — NUMBER(18,6)
  • DEV_MOD_P — NUMBER(18,6)
  • DCLINK_DEV_V — NUMBER(18,6)
  • DCLINK_DEV_A — NUMBER(18,6)
  • DCLINK_DEV_P — NUMBER(18,6)
  • CHRG — NUMBER(18,6)
  • DISCHRG — NUMBER(18,6)
  • ALARM — VARCHAR2(255)
  • TRIP_A — VARCHAR2(255)
  • TRIP_B — VARCHAR2(255)
  • STATE_VAL — VARCHAR2(255)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_CLCT_TGT

  • CLCT_TGT_ID — VARCHAR2(36) — Primary key — NOT NULL
  • TGT_KEY — VARCHAR2(160) — NOT NULL
  • JOB_KIND_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID
  • REQ_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • REQ_STRT_DT — DATE — NOT NULL
  • REQ_END_DT — DATE — NOT NULL
  • CLAIM_REQ_DT — TIMESTAMP WITH TIME ZONE
  • CMPL_REQ_DT — TIMESTAMP WITH TIME ZONE
  • LEASE_OWNER — VARCHAR2(128)
  • LEASE_TOKEN — VARCHAR2(36)
  • LEASE_EXPR_DT — TIMESTAMP WITH TIME ZONE
  • STRT_DT — TIMESTAMP WITH TIME ZONE
  • CMPL_DT — TIMESTAMP WITH TIME ZONE
  • LAST_OUTCOME_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • LAST_ERR_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • LAST_ROW_CNT — NUMBER(10)
  • LAST_OBS_DT — TIMESTAMP WITH TIME ZONE
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_CMPLX

  • CMPLX_ID — VARCHAR2(36) — Primary key — NOT NULL
  • BIG_MG_IDX — VARCHAR2(64) — NOT NULL
  • DISP_NM — VARCHAR2(255)
  • ACTV_YN — NUMBER(1) — NOT NULL
  • LAST_SEEN_DT — TIMESTAMP WITH TIME ZONE
  • SITE_NM — VARCHAR2(255)
  • LAT — NUMBER(10,7)
  • LON — NUMBER(10,7)
  • KMA_NX — NUMBER(10)
  • KMA_NY — NUMBER(10)
  • TZ — VARCHAR2(64) — NOT NULL
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_DEV

  • DEV_ID — VARCHAR2(36) — Primary key — NOT NULL
  • FCTRY_ID — VARCHAR2(36) — Foreign key → TB_EMS_FCTRY.FCTRY_ID — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_DEV_TYPE.DEV_TYPE_CD — NOT NULL
  • DEV_IDX — VARCHAR2(64) — NOT NULL
  • DISP_NM — VARCHAR2(255)
  • ACTV_YN — NUMBER(1) — NOT NULL
  • CLCT_YN — NUMBER(1) — NOT NULL
  • LAST_SEEN_DT — TIMESTAMP WITH TIME ZONE
  • RATED_PWR_KW — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_DEV_TYPE

  • DEV_TYPE_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — NOT NULL
  • DISP_NM — VARCHAR2(255)
  • ACTV_YN — NUMBER(1) — NOT NULL
  • LAST_SEEN_DT — TIMESTAMP WITH TIME ZONE
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_FCTRY

  • FCTRY_ID — VARCHAR2(36) — Primary key — NOT NULL
  • CMPLX_ID — VARCHAR2(36) — Foreign key → TB_EMS_CMPLX.CMPLX_ID — NOT NULL
  • FAC_IDX — VARCHAR2(64) — NOT NULL
  • DISP_NM — VARCHAR2(255)
  • ACTV_YN — NUMBER(1) — NOT NULL
  • LAST_SEEN_DT — TIMESTAMP WITH TIME ZONE
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_INBMS_RCRD

  • INBMS_RCRD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_RAW_RCRD.DEV_ID — NOT NULL
  • OBS_DT — TIMESTAMP WITH TIME ZONE — Foreign key → TB_EMS_RAW_RCRD.OBS_DT — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_RAW_RCRD.DEV_TYPE_CD — NOT NULL
  • HEARTBEAT — NUMBER(18,6)
  • RELAY_STTS — NUMBER(18,6)
  • SOC — NUMBER(18,6)
  • SOH — NUMBER(18,6)
  • CELL_DEV_V — NUMBER(18,6)
  • CELL_DEV_A — NUMBER(18,6)
  • CELL_DEV_P — NUMBER(18,6)
  • PWR_LIMIT — NUMBER(18,6)
  • CELL_MAX_V — NUMBER(18,6)
  • CELL_MIN_V — NUMBER(18,6)
  • CELL_MAX_TEMP — NUMBER(18,6)
  • CELL_MIN_TEMP — NUMBER(18,6)
  • ALARM — VARCHAR2(255)
  • TRIP_A — VARCHAR2(255)
  • STATE_VAL — VARCHAR2(255)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_PCS_RCRD

  • PCS_RCRD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_RAW_RCRD.DEV_ID — NOT NULL
  • OBS_DT — TIMESTAMP WITH TIME ZONE — Foreign key → TB_EMS_RAW_RCRD.OBS_DT — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_RAW_RCRD.DEV_TYPE_CD — NOT NULL
  • LOAD_R_V — NUMBER(18,6)
  • LOAD_S_V — NUMBER(18,6)
  • LOAD_T_V — NUMBER(18,6)
  • LOAD_R_A — NUMBER(18,6)
  • LOAD_S_A — NUMBER(18,6)
  • LOAD_T_A — NUMBER(18,6)
  • LOAD_FREQ — NUMBER(18,6)
  • LOAD_INST_PWR — NUMBER(18,6)
  • LOAD_ACTV_PWR — NUMBER(18,6)
  • LOAD_REACT_PWR — NUMBER(18,6)
  • LOAD_PWR_FACTOR — NUMBER(18,6)
  • DCLINK_DEV_V — NUMBER(18,6)
  • DCLINK_DEV_A — NUMBER(18,6)
  • DCLINK_DEV_P — NUMBER(18,6)
  • ALARM — VARCHAR2(255)
  • TRIP_A — VARCHAR2(255)
  • TRIP_B — VARCHAR2(255)
  • STATE_VAL — VARCHAR2(255)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_PMD_AC_RCRD

  • PMD_AC_RCRD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_RAW_RCRD.DEV_ID — NOT NULL
  • OBS_DT — TIMESTAMP WITH TIME ZONE — Foreign key → TB_EMS_RAW_RCRD.OBS_DT — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_RAW_RCRD.DEV_TYPE_CD — NOT NULL
  • LOAD_R_V — NUMBER(18,6)
  • LOAD_S_V — NUMBER(18,6)
  • LOAD_T_V — NUMBER(18,6)
  • LOAD_R_A — NUMBER(18,6)
  • LOAD_S_A — NUMBER(18,6)
  • LOAD_T_A — NUMBER(18,6)
  • LOAD_R_V_ANGLE — NUMBER(18,6)
  • LOAD_S_V_ANGLE — NUMBER(18,6)
  • LOAD_T_V_ANGLE — NUMBER(18,6)
  • LOAD_R_A_ANGLE — NUMBER(18,6)
  • LOAD_S_A_ANGLE — NUMBER(18,6)
  • LOAD_T_A_ANGLE — NUMBER(18,6)
  • LOAD_FREQ — NUMBER(18,6)
  • LOAD_ACTV_PWR — NUMBER(18,6)
  • LOAD_REACT_PWR — NUMBER(18,6)
  • LOAD_PWR_FACTOR — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_PMD_DC_RCRD

  • PMD_DC_RCRD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_RAW_RCRD.DEV_ID — NOT NULL
  • OBS_DT — TIMESTAMP WITH TIME ZONE — Foreign key → TB_EMS_RAW_RCRD.OBS_DT — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_RAW_RCRD.DEV_TYPE_CD — NOT NULL
  • DCGRID_DCLINK_V — NUMBER(18,6)
  • DCGRID_DCLINK_A — NUMBER(18,6)
  • DCGRID_DCLINK_P — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_PVCON_RCRD

  • PVCON_RCRD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_RAW_RCRD.DEV_ID — NOT NULL
  • OBS_DT — TIMESTAMP WITH TIME ZONE — Foreign key → TB_EMS_RAW_RCRD.OBS_DT — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_RAW_RCRD.DEV_TYPE_CD — NOT NULL
  • CELL_DEV_V — NUMBER(18,6)
  • CELL_DEV_A — NUMBER(18,6)
  • CELL_DEV_P — NUMBER(18,6)
  • DEV_DCLINK_V — NUMBER(18,6)
  • DEV_DCLINK_A — NUMBER(18,6)
  • DEV_DCLINK_P — NUMBER(18,6)
  • DCGRID_V — NUMBER(18,6)
  • ALARM — VARCHAR2(255)
  • TRIP_A — VARCHAR2(255)
  • TRIP_B — VARCHAR2(255)
  • STATE_VAL — VARCHAR2(255)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_RAW_RCRD

  • RAW_RCRD_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • DEV_TYPE_CD — VARCHAR2(64) — Foreign key → TB_EMS_DEV.DEV_TYPE_CD — NOT NULL
  • OBS_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • RAW_DATA — CLOB — NOT NULL
  • INGEST_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_EMS_WTHR_FCST

  • WTHR_FCST_ID — VARCHAR2(36) — Primary key — NOT NULL
  • FCST_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • PCP — VARCHAR2(64)
  • POP — NUMBER(18,6)
  • PTY_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • REH — NUMBER(18,6)
  • SKY_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • SNO — VARCHAR2(64)
  • TMP — NUMBER(18,6)
  • UUU — NUMBER(18,6)
  • VEC — NUMBER(18,6)
  • VVV — NUMBER(18,6)
  • WAV — NUMBER(18,6)
  • WSD — NUMBER(18,6)
  • RAW_DATA — CLOB
  • INGEST_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_KMA_SHORT_FCST

  • KMA_FCST_ID — VARCHAR2(36) — Primary key — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • FCST_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • NX — NUMBER(10) — NOT NULL
  • NY — NUMBER(10) — NOT NULL
  • PCP — VARCHAR2(64)
  • POP — NUMBER(18,6)
  • PTY_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • REH — NUMBER(18,6)
  • SKY_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • SNO — VARCHAR2(64)
  • TMN — NUMBER(18,6)
  • TMP — NUMBER(18,6)
  • TMX — NUMBER(18,6)
  • UUU — NUMBER(18,6)
  • VEC — NUMBER(18,6)
  • VVV — NUMBER(18,6)
  • WAV — NUMBER(18,6)
  • WSD — NUMBER(18,6)
  • RAW_DATA — CLOB
  • INGEST_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_MENU

  • MENU_ID — VARCHAR2(36) — Primary key — NOT NULL
  • MENU_NM — VARCHAR2(100) — NOT NULL
  • PATH — VARCHAR2(255) — NOT NULL
  • SORT_ORD — NUMBER(10) — NOT NULL
  • USE_YN — NUMBER(1) — NOT NULL

TB_PCS_AGG_10M

  • PCS_AGG_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • LOAD_INST_PWR — NUMBER(18,6)
  • LOAD_ACTV_PWR — NUMBER(18,6)
  • LOAD_REACT_PWR — NUMBER(18,6)
  • LOAD_PWR_FACTOR — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_PV_ACCR_DEV_10M

  • ACCR_DEV_ID — VARCHAR2(36) — Primary key — NOT NULL
  • FCST_RUN_ID — VARCHAR2(36) — Foreign key → TB_PV_FCST_RUN.FCST_RUN_ID — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • TRUE_KW — NUMBER(18,6)
  • PRED_KW — NUMBER(18,6)
  • EVAL_PRED_KW — NUMBER(18,6)
  • ERR_KW — NUMBER(18,6)
  • ABS_ERR_KW — NUMBER(18,6)
  • RAW_ERR_KW — NUMBER(18,6)
  • EVAL_INCL_YN — NUMBER(1) — NOT NULL
  • EVAL_EXCL_YN — NUMBER(1) — NOT NULL
  • EVAL_EXCL_RSN_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • SOC_EXCL_YN — NUMBER(1) — NOT NULL
  • SOC_MAX — NUMBER(18,6)
  • NORM_ZERO_ADJ_YN — NUMBER(1) — NOT NULL
  • ABN_ZERO_EXCL_YN — NUMBER(1) — NOT NULL
  • WTHR_REGIME_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID
  • WTHR_LOW_OUT_OK_YN — NUMBER(1) — NOT NULL
  • POP — NUMBER(18,6)
  • PTY — NUMBER(18,6)
  • SKY — NUMBER(18,6)
  • REH — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_PV_ACCR_DEV_DAY

  • ACCR_DAY_ID — VARCHAR2(36) — Primary key — NOT NULL
  • FCST_RUN_ID — VARCHAR2(36) — Foreign key → TB_PV_FCST_RUN.FCST_RUN_ID — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • TGT_DT — DATE — NOT NULL
  • RATED_CAP_KW — NUMBER(18,6)
  • KPI_DAY_YN — NUMBER(1) — NOT NULL
  • ACTL_POINT_CNT — NUMBER(10) — NOT NULL
  • MATCH_POINT_CNT — NUMBER(10) — NOT NULL
  • EXCL_POINT_CNT — NUMBER(10) — NOT NULL
  • SOC_EXCL_POINT_CNT — NUMBER(10) — NOT NULL
  • ZERO_ADJ_POINT_CNT — NUMBER(10) — NOT NULL
  • ABN_ZERO_POINT_CNT — NUMBER(10) — NOT NULL
  • ACTL_TOT_KWH — NUMBER(18,6)
  • PRED_TOT_KWH — NUMBER(18,6)
  • ENERGY_BIAS_KWH — NUMBER(18,6)
  • NMAE — NUMBER(18,6)
  • ACCR_PCT — NUMBER(18,6)
  • NRMSE_PCT — NUMBER(18,6)
  • FULL_ACTL_KWH — NUMBER(18,6)
  • FULL_PRED_KWH — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_PV_AGG_10M

  • PV_AGG_ID — VARCHAR2(36) — Primary key — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • DEV_DCLINK_P — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_PV_FCST_DEV_10M

  • FCST_DEV_ID — VARCHAR2(36) — Primary key — NOT NULL
  • FCST_RUN_ID — VARCHAR2(36) — Foreign key → TB_PV_FCST_RUN.FCST_RUN_ID — NOT NULL
  • DEV_ID — VARCHAR2(36) — Foreign key → TB_EMS_DEV.DEV_ID — NOT NULL
  • HORIZON_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • BMS_SOC_MIN — NUMBER(18,6)
  • BMS_SOC_MAX — NUMBER(18,6)
  • BMS_ZERO_YN — NUMBER(1)
  • BMS_LOW_YN — NUMBER(1)
  • BMS_HIGH_YN — NUMBER(1)
  • BMS_BLOCK_YN — NUMBER(1)
  • PRED_KW — NUMBER(18,6)
  • BASE_PRED_KW — NUMBER(18,6)
  • R1_PRED_KW — NUMBER(18,6)
  • R2_PRED_KW — NUMBER(18,6)
  • NIGHT_ZERO_YN — NUMBER(1)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_PV_FCST_RUN

  • FCST_RUN_ID — VARCHAR2(36) — Primary key — NOT NULL
  • CMPLX_ID — VARCHAR2(36) — Foreign key → TB_EMS_CMPLX.CMPLX_ID — NOT NULL
  • ISSUE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • TGT_DT — DATE — NOT NULL
  • MODEL_VARIANT_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • PRED_INTRVL_MIN — NUMBER(10) — NOT NULL
  • POINT_CNT_PER_DEV — NUMBER(10) — NOT NULL
  • DEV_CNT — NUMBER(10) — NOT NULL
  • KMA_SRC_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • KMA_NX — NUMBER(10)
  • KMA_NY — NUMBER(10)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_PV_FCST_SITE_10M

  • FCST_SITE_ID — VARCHAR2(36) — Primary key — NOT NULL
  • FCST_RUN_ID — VARCHAR2(36) — Foreign key → TB_PV_FCST_RUN.FCST_RUN_ID — NOT NULL
  • HORIZON_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • PRED_KW — NUMBER(18,6)
  • BASE_PRED_KW — NUMBER(18,6)
  • R1_PRED_KW — NUMBER(18,6)
  • R2_PRED_KW — NUMBER(18,6)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_SMS_RCPT

  • SMS_RCPT_ID — VARCHAR2(36) — Primary key — NOT NULL
  • RCPT_NM — VARCHAR2(100) — NOT NULL
  • TEL_NO — VARCHAR2(32) — NOT NULL
  • NOTI_TYPE_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • USE_YN — NUMBER(1) — NOT NULL
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_USER

  • USER_ID — VARCHAR2(36) — Primary key — NOT NULL
  • LOGIN_ID — VARCHAR2(255) — NOT NULL
  • PWD_HASH — VARCHAR2(512) — NOT NULL
  • USER_NM — VARCHAR2(255) — NOT NULL
  • ORG_NM — VARCHAR2(255)
  • TEL_NO — VARCHAR2(32)
  • EMAIL — VARCHAR2(255)
  • ROLE_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • STTS_CD_ID — VARCHAR2(36) — Foreign key → TB_CMMN_CD.CMMN_CD_ID — NOT NULL
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL

TB_WTHR_AGG_10M

  • WTHR_AGG_ID — VARCHAR2(36) — Primary key — NOT NULL
  • CMPLX_ID — VARCHAR2(36) — Foreign key → TB_EMS_CMPLX.CMPLX_ID — NOT NULL
  • BASE_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • POP — NUMBER(18,6)
  • PTY — NUMBER(18,6)
  • REH — NUMBER(18,6)
  • SKY — NUMBER(18,6)
  • TMP — NUMBER(18,6)
  • UUU — NUMBER(18,6)
  • VVV — NUMBER(18,6)
  • WAV — NUMBER(18,6)
  • VEC — NUMBER(18,6)
  • WSD — NUMBER(18,6)
  • HOUR_VAL — NUMBER(2)
  • MONTH_VAL — NUMBER(2)
  • DAY_OF_YEAR — NUMBER(3)
  • DOW — NUMBER(1)
  • SIN_HOUR — NUMBER(18,10)
  • COS_HOUR — NUMBER(18,10)
  • SIN_DOY — NUMBER(18,10)
  • COS_DOY — NUMBER(18,10)
  • HOLIDAY_YN — NUMBER(1)
  • CRT_DT — TIMESTAMP WITH TIME ZONE — NOT NULL
  • UPD_DT — TIMESTAMP WITH TIME ZONE — NOT NULL