ddd

Tables (13)

ai_hub_data

  • ahd_seq — int(10) — Primary key — NOT NULL
  • ahd_time — datetime
  • ahd_label — varchar(20)
  • ahd_caoc — varchar(20)
  • ahd_temp — varchar(20)
  • ahd_pva — varchar(20)
  • ahd_lva — varchar(20)
  • ahd_vhm — varchar(20)
  • ahd_ca — varchar(20)
  • ahd_chm — varchar(20)
  • ahd_pfa — varchar(20)
  • ahd_rpa — varchar(20)
  • ahd_freq — varchar(20)
  • ahd_epa — varchar(20)
  • ahd_Rpv — varchar(20)
  • ahd_Rlv — varchar(20)
  • ahd_Rpc — varchar(20)
  • ahd_Rpep — varchar(20)
  • ahd_Rprp — varchar(20)
  • ahd_Rpf — varchar(20)
  • ahd_Rpvh — varchar(20)
  • ahd_Rpch — varchar(20)
  • ahd_Spv — varchar(20)
  • ahd_Slv — varchar(20)
  • ahd_Spc — varchar(20)
  • ahd_Spep — varchar(20)
  • ahd_Sprp — varchar(20)
  • ahd_Spf — varchar(20)
  • ahd_Spvh — varchar(20)
  • ahd_Spch — varchar(20)
  • ahd_Tpv — varchar(20)
  • ahd_Tlv — varchar(20)
  • ahd_Tpc — varchar(20)
  • ahd_Tpep — varchar(20)
  • ahd_Tprp — varchar(20)
  • ahd_Tpf — varchar(20)
  • ahd_Tpvh — varchar(20)
  • ahd_Tpch — varchar(20)

company

  • co_name — varchar(20) — NOT NULL
  • co_locate — varchar(100)
  • co_estb — date — 회사 설립연도
  • co_busi — varchar(20) — 업종\r\ncategory of business
  • co_busi_con — varchar(20) — business conditions
  • co_product — varchar(20) — 주생산품
  • co_cont_hist — int(10) — contract history
  • co_sel_paysys — varchar(20) — select payment system
  • co_kepco_info — varchar(100) — 한전 정보
  • user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
  • ahd_seq — int(10) — Foreign key → ai_hub_data.ahd_seq — NOT NULL
  • fac_name — varchar(20) — Foreign key → facilities.fac_name — NOT NULL

facilities

  • fac_name — varchar(20) — Primary key — NOT NULL
  • fac_type — varchar(20)
  • fac_mfg — varchar(20) — a facility manufacturer
  • fac_yr_prodn — date — the year of production
  • fac_rated_capa — int(10) — rated capacity
  • fac_rated_volt — int(10) — rated voltage
  • isrt_date — date — Foreign key → fems_log_2february.isrt_date — NOT NULL
  • isrt_dttm — time — Foreign key → fems_log_2february.isrt_dttm — NOT NULL
  • isrt_date (isrt_date2) — date — Foreign key → fems_log_3match.isrt_date — NOT NULL
  • isrt_dttm (isrt_dttm2) — time — Foreign key → fems_log_3match.isrt_dttm — NOT NULL
  • isrt_date (isrt_date3) — date — Foreign key → fems_log_4april.isrt_date — NOT NULL
  • isrt_dttm (isrt_dttm3) — time — Foreign key → fems_log_4april.isrt_dttm — NOT NULL
  • isrt_date (isrt_date4) — date — Foreign key → fems_log_5may.isrt_date — NOT NULL
  • isrt_dttm (isrt_dttm4) — time — Foreign key → fems_log_5may.isrt_dttm — NOT NULL
  • isrt_date (isrt_date5) — date — Foreign key → fems_log_6june.isrt_date — NOT NULL
  • isrt_dttm (isrt_dttm5) — time — Foreign key → fems_log_6june.isrt_dttm — NOT NULL
  • isrt_date (isrt_date6) — date — Foreign key → fems_log_7july.isrt_date — NOT NULL
  • isrt_dttm (isrt_dttm6) — time — Foreign key → fems_log_7july.isrt_dttm — NOT NULL
  • isrt_date (isrt_date7) — date — Foreign key → fems_log_8august.isrt_date — NOT NULL
  • isrt_dttm (isrt_dttm7) — time — Foreign key → fems_log_8august.isrt_dttm — NOT NULL
  • isrt_date (isrt_date8) — date — Foreign key → fems_log_9september.isrt_date — NOT NULL
  • isrt_dttm (isrt_dttm8) — time — Foreign key → fems_log_9september.isrt_dttm — NOT NULL

fems_log_2february

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fems_log_3match

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fems_log_4april

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fems_log_5may

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fems_log_6june

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fems_log_7july

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fems_log_8august

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fems_log_9september

  • isrt_date — date — Primary key — NOT NULL
  • isrt_dttm — time — Primary key — NOT NULL
  • fems_no — varchar(20)
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(11)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)

fire_station

  • fire_seq — int(11) — Primary key — NOT NULL
  • fire_regions — varchar(10)
  • fire_districts — varchar(10)
  • fire_name — varchar(100)
  • fire_locate — varchar(100)
  • fire_callnum — varchar(100)

user

  • user_id — varchar(20) — Primary key — NOT NULL
  • user_pw — varchar(20)
  • user_name — varchar(20)
  • fire_seq — int(11) — Foreign key → fire_station.fire_seq — NOT NULL