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