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