wp
Tables (11)
kma_stn_info (기상청 관측지점정보)
- stn_id (지점아이디) — INT
- stn_nm (지점명) — VARCHAR
- stn_addr (주소) — VARCHAR
- stn_offi (관리관서) — VARCHAR
- lat (위도) — DECIMAL
- lon — DECIMAL
rep_data_ms_meas_met_shko60_h (기상관측자료)
- STN_ID — VARCHAR — Primary key — NOT NULL
- TM (일자) — BIGINT — Primary key — NOT NULL
- POWER_PLANT_ID (발전소 ID) — INT — Foreign key → rep_data_pv_fcst_gen_gent_h.POWER_PLANT_ID — NOT NULL
- CRTN_TM (발표시간) — BIGINT — Foreign key → rep_data_pv_fcst_gen_gent_h.CRTN_TM — NOT NULL
- FCST_TM (예측시간) — VARCHAR — Foreign key → rep_data_pv_fcst_gen_gent_h.FCST_TM — NOT NULL
- PT (기압변화경향) — DECIMAL
- WD_DEG (풍향) — DECIMAL
- WD (평균풍향) — DECIMAL
- WS (풍속) — DECIMAL
- WS_UNT (단위풍속) — DECIMAL
- WD_GST (GUST풍향) — DECIMAL
- WS_GST (GUST풍속) — DECIMAL
- WS_GST_TM (GUST 시각) — DECIMAL
- PA (평균현지기압) — DECIMAL
- PS (평균해면기압) — DECIMAL
- PR (기압변화량) — DECIMAL
- TD (이슬점) — DECIMAL
- TA (평균기온) — DECIMAL
- HM (평균습도) — DECIMAL
- PV (증기압) — DECIMAL
- RN (시간강수량) — DECIMAL
- RN_ACC (강수량 정확도) — DECIMAL
- SD_HR1 (1시간 신적설) — DECIMAL
- SD_HR3 (3시간신적설) — DECIMAL
- SD_DAY (일누적신적설) — DECIMAL
- SD_TOT (적설) — DECIMAL
- WC (현재일기) — DECIMAL
- WP (과거일기) — DECIMAL
- WW (현상번호) — DECIMAL
- CA_TOT (전운량) — DECIMAL
- CA_MID (중하층운량) — DECIMAL
- CH_MIN (최저운고) — DECIMAL
- CT (운형) — DECIMAL
- CT_TOP (상층운형) — DECIMAL
- CT_MIN (중층운형) — DECIMAL
- CT_LOW (하층운형) — DECIMAL
- VS (시정) — DECIMAL
- SS_HR1 (일조) — DECIMAL
- SI_HR1 (일사) — DECIMAL
- TG (초상기온) — DECIMAL
- ST_GD (지면상태) — DECIMAL
- TS (지면온도) — DECIMAL
- TE_005 (0.05m지중온도) — DECIMAL
- TE_01 (0.1m지중온도) — DECIMAL
- TE_02 (0.2m지중운도) — DECIMAL
- TE_03 (0.3m지중운도) — DECIMAL
- TE_05 (0.5m지중온도) — DECIMAL
- TE_10 (1.0m지중온도) — DECIMAL
- TE_15 (1.5m지중온도) — DECIMAL
- TE_30 (3.0m지중온도) — DECIMAL
- TE_50 (5.0m지중온도) — DECIMAL
- WH (파고) — DECIMAL
- RN_INT (최대강수강도) — DECIMAL
- RN_DAY (일누적강수량) — DECIMAL
- ST_SEA (해면상태) — DECIMAL
- BF (Beaufart최대풍력) — DECIMAL
- RN_JUN (일강수량) — DECIMAL
- IR (강수자료포함여부) — DECIMAL
- IX (일기자료포함여부) — DECIMAL
- REG_DATE (등록일시) — TIMESTAMP
- … +1
rep_data_pv_fcst_gen_gent_h (발전량 예측자료)
- POWER_PLANT_ID (발전단지 아이디) — INT — Primary key — NOT NULL
- CRTN_TM (발표시간) — BIGINT — Primary key — NOT NULL
- FCST_TM (예측시간) — VARCHAR — Primary key — NOT NULL
- LEAD_TM (선행시간) — VARCHAR
- FCST_SR01 (일사량-모델) — DECIMAL
- FCST_SR02 (일사량-MOS) — DECIMAL
- FCST_SRAD (최종일사량) — DECIMAL
- FCST_WSPD (풍속) — DECIMAL
- FCST_TEMP (기온) — DECIMAL
- FCST_HUMI (습도) — DECIMAL
- FCST_PSFC (현지기압) — DECIMAL
- FCST_QG01 (예측발전량1) — DECIMAL
- FCST_QG02 (예측발전량2) — DECIMAL
- FCST_QC11 (예측발전량(ESS충전전)) — DECIMAL
- FCST_QGEN (최종발전량) — DECIMAL
- FCST_CAPA (설비용량) — DECIMAL
- FCST_SRAD_ACCU_DAY (일사량 일누적) — DECIMAL
- FCST_QGEN_ACCU_DAY (발전량 일누적) — DECIMAL
- ESS_DISC (ESS 방전량) — DECIMAL
- ESS_CHRG (ESS 충전량) — DECIMAL
- ESS_BSOC (ESS 배터리잔량) — DECIMAL
- ESS_CAPA (ESS PCS 용량) — DECIMAL
- ETC_VARI (기타변수) — VARCHAR
- REG_DATE (입력일시) — TIMESTAMP
- UPD_DATE (수정일시) — TIMESTAMP
rep_data_pv_fcst_nwp_um_h (수치예보자료)
- NWP_TP_CD (수치모델 타입 코드) — VERCHAR — Primary key — NOT NULL
- POWER_PLANT_ID (발전소 아이디) — INT — Primary key — NOT NULL
- CRTN_TM (발표시간) — BIGINT — Primary key — NOT NULL
- FCST_TM (예측시간) — VARCHAR — Primary key — NOT NULL
- POWER_PLANT_ID (발전소아이디) — INT — Foreign key → rep_data_pv_fcst_gen_gent_h.POWER_PLANT_ID — NOT NULL
- CRTN_TM (발표 시간) — BIGINT — Foreign key → rep_data_pv_fcst_gen_gent_h.CRTN_TM — NOT NULL
- FCST_TM (예측 시간) — VARCHAR — Foreign key → rep_data_pv_fcst_gen_gent_h.FCST_TM — NOT NULL
- LEAD_TM (선행시간) — VARCHAR
- HGT (고도) — DECIMAL
- TEM (온도) — DECIMAL
- REH (습도) — DECIMAL
- WS10 (10m풍속) — DECIMAL
- WD10 (10m풍량) — DECIMAL
- WSL2 (레벨2풍속) — DECIMAL
- WDL2 (레벨2풍향) — DECIMAL
- LEV2 (레벨2높이) — DECIMAL
- PSFC (현지기압) — DECIMAL
- SLPR (해면기압) — DECIMAL
- SWDOWN (하향단바복사량) — DECIMAL
- TCDC (전운량) — DECIMAL
- REG_DATE (등록일시) — TIMESTAMP
- UPD_DATE (수정일시) — TIMESTAMP
rep_info_elec_rec (전력거래소 REC 자료)
- TRADE_DAY (거래일) — CHAR — Primary key — NOT NULL
- LVOL (거래량) — INT
- LAVG (평균가) — DECIMAL
- LMAX (최고가) — DECIMAL
- LMIN (최저가) — DECIMAL
- LCLO (종가) — DECIMAL
- REG_DATE (입력시간) — TIMESTAMP
- UPD_DATE (수정시간) — TIMESTAMP
rep_info_elec_smp (전력거래소 SMP자료)
- LAND_DIV_CD (육지/제주 구분) — VARCHAR — Primary key — NOT NULL
- TRADE_DAY (거래일) — CHAR — Primary key — NOT NULL
- HH01 (시간별 01) — DECIMAL
- HH02 (시간별 02) — DECIMAL
- HH03 (시간별03) — DECIMAL
- HH04 (시간별 04) — DECIMAL
- HH05 (시간별 05) — DECIMAL
- HH06 (시간별 06) — DECIMAL
- HH07 (시간별 07) — DECIMAL
- HH08 (시간별 08) — DECIMAL
- HH09 (시간별 09) — DECIMAL
- HH10 (시간별 10) — DECIMAL
- HH11 (시간별11) — DECIMAL
- HH12 (시간별 12) — DECIMAL
- HH13 (시간별 13) — DECIMAL
- HH14 (시간별 14) — DECIMAL
- HH15 (시간별 15) — DECIMAL
- HH16 (시간별 16) — DECIMAL
- HH17 (시간별 17) — DECIMAL
- HH18 (시간별 18) — DECIMAL
- HH19 (시간별 19) — DECIMAL
- HH20 (시간별 20) — DECIMAL
- HH21 (시간별 21) — DECIMAL
- HH22 (시간별 22) — DECIMAL
- HH23 (시간별 23) — DECIMAL
- HH24 (시간별 24) — DECIMAL
- LMAX (최대) — DECIMAL
- LMIN (최소) — DECIMAL
- LAVG (평균) — DECIMAL
- REG_DATE (입력시간) — TIMESTAMP
- UPD_DATE (수정시간) — TIMESTAMP
rep_info_pv_gent (Untitled6)
- FIXED_YN (고장 유무) — CHAR — Primary key — NOT NULL
- GEN_ID (발전소 아이디) — VARCHAR — Primary key — NOT NULL
- EFF_START_DAY (발전시작일) — CHAR — Primary key — NOT NULL
- EFF_END_DAY (발전종료일) — CHAR
- REG_DATE (등록일) — TIMESTAMP
- REG_USER_ID (등록자아이디) — VARCHAR
- UPD_DATE (수정일) — TIMESTAMP
- UPD_USER_ID (수정자아이디) — VARCHAR
- GEN_NM (발전소명) — VARCHAR
- LATITD (위도) — DECIMAL
- LONGTD (경도) — DECIMAL
- B_SG_AREA_CD (발전소지역코드) — VARCHAR
- API_ADDR (API 주소) — VARCHAR
- SRC_ADDR (SCR 주소) — VARCHAR
- RTD_CAPA (발전소 용량) — DECIMAL
- MEAS_GEN_ID (관측발전소아이디) — VARCHAR
- MEAS_EMS_ID (관측EMS아이디) — VARCHAR
- MODEL_ID (모듈모델 아이디) — VARCHAR
- TRC_MODE_CD (트래킹모드) — VARCHAR
- CL_EQP_YN (냉각장치유무) — CHAR
- LOSS_FACTOR (손실계수) — DECIMAL
- INST_ZENITHANGLE (설치고도각) — DECIMAL
- INST_AZIMUTE (설치방위각) — DECIMAL
- MON_ZENITHANGLE (월별고도각) — VARCHAR
- USE_YN (사용유무) — CHAR
- UPD_REASON (수정이유) — VARCHAR
- FIXED_REASON (고장사유) — VARCHAR
- UPD_HISTORY_JSON (수정이력) — LONGTEXT
tb_hourly_data_info (발전량 관측자료)
- SEQUENCE_ID (시퀀스 아이디) — INT — Primary key — NOT NULL
- POWER_PLANT_ID (발전소아이디) — INT
- MEASUREMENT_TIME (측정시간) — DATETIME
- ACCUMULATED_POWER (금일누적 전력량) — DECIMAL
- INSOLATION (일사량) — DECIMAL
- TEMPERATURE (온도) — DECIMAL
tb_power_plant_inof (발전소 정보)
- POWER_PLANT_ID (발전소아이디) — INT — Primary key — NOT NULL
- POWER_PLANT_NAME (발전소명) — VARCHAR
- AREA_CODE (발전소지역코드) — VARCHAR
- POWER_PLANT_TYPE (발전소구분코드) — VARCHAR
- POWER_PLANT_ADDR (발전소주소) — VARCHAR
- POWER_PLANT_CAPACITY (발전용량) — DECIMAL
- POWER_PLANT_RADIATION (일사량) — DECIMAL
- POWER_PLANT_TEMPERATURE (온도) — DECIMAL
- POWER_PLANT_LATITUDE (위도) — DECIMAL
- POWER_PLANT_LONGITUDE (경도) — DECIMAL
- OFFICE_TYPE (사업소구분코드) — VARCHAR
- TILT_ANGLE (경사각) — VARCHAR
- MODEL_ID (모듈모델명) — VARCHAR
- TRC_MODE_CD (트래킹모드) — VARCHAR
- CL_EQP_YN (냉각장치유무) — CHAR
- LOSS_FACTOR (손실계수) — DECIMAL
- INST_ZENITHANGLE (설치고도각) — DECIMAL
- INST_AZIMUTH (설치방위각) — DECIMAL
- MON_ZENITHANGLE (월별고도각) — DECIMAL
- ESS_ID (ESS 아이디) — INT
- ESS_SVCAP (ESS 저장용량) — DECIMAL
- ESS_UP_YN (ESS 상위유무) — CHAR
- USE_YN (사용유무) — CHAR
- TODAY_ACCUMULATED_POWER (금일누적전력량) — DECIMAL
- NOW_OUPUT (현재출력) — DECIMAL
- PREV_DAY_ACCUMULATED_POWER (전일누적전력량) — DECIMAL
- PREV_MONTH_ACCUMULATED_POWER (전월누적전력량) — DECIMAL
- TODAY_CHARGE_AMOUNT (금일충전량) — DECIMAL
- TODAY_DISCHARGE_AMOUNT (금일방전량) — DECIMAL
- MONTH_CHARGE_AMOUNT (금월충전량) — DECIMAL
- MONTH_DISCHARGE_AMOUNT (금월방전량) — DECIMAL
- TOTAL_ACCUMULATED_CHARGE_AMOUNT (총 누적 충전량) — DECIMAL
- TOTAL_ACCUMULATED_DISCHARGE_AMOUNT (총 누적 방전량) — DECIMAL
- BATTERY_LEVEL (베터리 잔량) — DECIMAL
- PCS_STATUS (PCS 현재상태) — DECIMAL
- PCS_OUTPUT (PCS 현재출력) — DECIMAL
- IDX_ACCUMULATED_POWER (금일누적 전력량 인덱스) — VARCHAR
- IDX_INSOLATION (수평일사량 인덱스) — VARCHAR
- IDX_TEMPERATURE (온도 인덱스) — VARCHAR
- stn_id (기상청 관측지점 아이디) — INT
tb_rps_plant_info (RPS 계약 발전소 정보)
- PLANT_ID (발전소아이디) — INT — Primary key — NOT NULL
- PLANT_NAME (발전소명) — VARCHAR
- CORPORATE_NAME (사업자명) — VARCHAR
- BUSINESS_NUMBER (사업자등록번호) — VARCHAR
- PLANT_ADDRESS (발전소주소) — VARCHAR
- PLANT_LON (발전소 경도) — DECIMAL
- PLANT_LAT (발전소 위도) — DECIMAL
- PLNAT_VOLUME (발전소 용량) — DECIMAL
tb_rps_plant_rec (RPS 계약발전소 REC정보)
- PLANT_ID (발전소아이디) — INT — Primary key — NOT NULL
- YEAR (년) — INT
- MONTH (월) — INT
- REC (Field3) — INT