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