POSCo

테이블 (16)

Sum_day_monitoring_door (일배치_방화문정보 Summary)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • door_id — VARCHAR(100)
  • door_closed_Cnt (d_closed_cnt) — int(100000)
  • connect_error_Cnt (con_err_Cnt) — int(100000)
  • rssi_abnormal_Cnt — int(100000)
  • in_temp_abnormal_Cnt — int(100000)
  • out_temp_abnormal_Cnt — int(100000)
  • in_abnormal_Cnt — int(100000)
  • inB_abnormal_Cnt — int(100000)
  • reg_datetime — DATETIME
  • Field

Sum_day_monitoring_p_type_his (일배치_P형 복합수신기정보 Summary)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • p_id — VARCHAR(100)
  • wdet1_sensing_Cnt — int(100000)
  • wdet2_abnormal_Cnt (wdet2_sensing_Cnt) — int(100000)
  • sprin_open_Cnt — int(100000)
  • pump_run_Cnt — int(100000)
  • connect_error_Cnt — int(100000)
  • rssi_abnormal_Cnt — int(100000)
  • in_abnormal_Cnt — int(100000)
  • inB_abnormal_Cnt — int(100000)
  • reg_datetime — DATETIME

Sum_hour_monitoring_door (1시간 배치_방화문정보 Summary)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • door_id — VARCHAR(100)
  • door_closed_Cnt (d_closed_cnt) — int(100000)
  • connect_error_Cnt (con_err_Cnt) — int(100000)
  • rssi_abnormal_Cnt — int(100000)
  • in_temp_abnormal_Cnt — int(100000)
  • out_temp_abnormal_Cnt — int(100000)
  • in_abnormal_Cnt — int(100000)
  • inB_abnormal_Cnt — int(100000)
  • reg_datetime — DATETIME
  • Field

monitoring_door_his (CopyOfwise_방화문정보)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • door_id — VARCHAR(100)
  • opcode — VARCHAR2(3)
  • rssi — VARCHAR2(4)
  • in24v — VARCHAR2(2)
  • inB24v — VARCHAR2(2)
  • s1 — VARCHAR2(2)
  • out1 — VARCHAR2(2)
  • in_temp — VARCHAR2(6)
  • ex_temp — VARCHAR2(6)
  • fire drill — VARCHAR2(1)
  • reg_datetime — DATETIME

monitoring_door_trd (wise_방화문정보)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • door_id — VARCHAR(100)
  • opcode — VARCHAR2(3)
  • rssi — VARCHAR2(4)
  • in24v — VARCHAR2(2)
  • inB24v — VARCHAR2(2)
  • s1 — VARCHAR2(2)
  • out1 — VARCHAR2(2)
  • in_temp — VARCHAR2(6)
  • ex_temp — VARCHAR2(6)
  • fire drill — VARCHAR2(1)
  • reg_datetime — DATETIME

monitoring_p_type_his (CopyOfwise_P형 복합수신기정보)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • p_id — VARCHAR(100)
  • opcode — VARCHAR2(3)
  • rssi — VARCHAR2(4)
  • in24v — VARCHAR2(2)
  • inB24v — VARCHAR2(2)
  • dist1 — int(10000)
  • dist2 — int(10000)
  • dist3 — int(10000)
  • dist4 — int(10000)
  • dist5 — int(10000)
  • dist6 — int(10000)
  • dist7 — int(10000)
  • dist8 — int(10000)
  • dist9 — int(10000)
  • dist10 — int(10000)
  • temp1 — VARCHAR2(4)
  • temp2 — VARCHAR2(4)
  • temp3 — VARCHAR2(4)
  • temp4 — VARCHAR2(4)
  • temp5 — VARCHAR2(4)
  • temp6 — VARCHAR2(4)
  • temp7 — VARCHAR2(4)
  • temp8 — VARCHAR2(4)
  • Field2 (temp9) — VARCHAR2(4)
  • Field3 (temp10) — VARCHAR2(4)
  • wdet1 — VARCHAR2(10)
  • wdet2 — VARCHAR2(10)
  • sprin — VARCHAR2(5)
  • pump (pmup) — VARCHAR2(5)
  • lowlevel — VARCHAR2(1)
  • fire_drill — VARCHAR2(1)
  • reg_datetime — DATETIME

monitoring_p_type_trd (wise_P형 복합수신기정보)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • p_id — VARCHAR(100)
  • opcode — VARCHAR2(3)
  • rssi — VARCHAR2(4)
  • in24v — VARCHAR2(2)
  • inB24v — VARCHAR2(2)
  • dist1 — int(10000)
  • dist2 — int(10000)
  • dist3 — int(10000)
  • dist4 — int(10000)
  • dist5 — int(10000)
  • dist6 — int(10000)
  • dist7 — int(10000)
  • dist8 — int(10000)
  • dist9 — int(10000)
  • dist10 — int(10000)
  • temp1 — VARCHAR2(4)
  • temp2 — VARCHAR2(4)
  • temp3 — VARCHAR2(4)
  • temp4 — VARCHAR2(4)
  • temp5 — VARCHAR2(4)
  • temp6 — VARCHAR2(4)
  • temp7 — VARCHAR2(4)
  • temp8 — VARCHAR2(4)
  • Field2 (temp9) — VARCHAR2(4)
  • Field3 (temp10) — VARCHAR2(4)
  • wdet1 — VARCHAR2(10)
  • wdet2 — VARCHAR2(10)
  • sprin — VARCHAR2(5)
  • pump (pmup) — VARCHAR2(5)
  • lowlevel — VARCHAR2(1)
  • fire_drill — VARCHAR2(1)
  • reg_datetime — DATETIME

one min_monitoring_door (1분 배치_방화문정보 Summary)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • door_id — VARCHAR(100)
  • door_closed_Cnt (d_closed_cnt) — int(100000)
  • connect_error_Cnt (con_err_Cnt) — int(100000)
  • rssi_abnormal_Cnt — int(100000)
  • in_temp_abnormal_Cnt — int(100000)
  • out_temp_abnormal_Cnt — int(100000)
  • in_abnormal_Cnt — int(100000)
  • inB_abnormal_Cnt — int(100000)
  • reg_datetime — DATETIME
  • Field

postok (Untitled)

  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • postok_id — VARCHAR2(30)

wdet1_mapping (정온식_방화문 매핑)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • wdet1_no — VARCHAR(10)
  • wdet1_dist_s (wdet1_dist_start) — int(100000)
  • wdet1_dist_e (wdet1_dest_end) — int(100000)
  • door_id — VARCHAR(100)
  • d_wise id — VARCHAR(12)

wdet2_mapping (수신반화재_방화문 매핑)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id
  • wdet2_no — VARCHAR(10)
  • door_id — VARCHAR(100)
  • d_wise id — VARCHAR(12)

공장/공정 (Factory)

  • f_code — VARCHAR2(10) — 기본 키 — NOT NULL
  • sf_code — VARCHAR2(10) — 기본 키
  • f_name — VARCHAR2(50)

공장별 WISE1A (Untitled3)

  • w_dev_id (w_ded_id) — VARCHAR2(12) — 기본 키
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • w_type — VARHCAR2(1)
  • w_id — VARCHAR2(100)
  • w_dev_ip — vARCHAR2(15)
  • Field

사용자 (User)

  • seq — INT(1000) — 기본 키 — NOT NULL
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • id — VARCHAR2(30) — NOT NULL
  • pwd — VARCHAR2(30)
  • level — VARCHAR2(10)
  • name — VARCHAR2(20)
  • phone_no — VARCHAR2(11)
  • etc — VARCHAR2(50)
  • reg_datetime (Field) — DATETIME
  • Field2

소방훈련 여부 (FIRE_TRAINING)

  • seq — int(100000) — 기본 키 — NOT NULL
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • fire_train_yn — BOOLEAN(1)
  • w_dev_id (Field2) — VARCHAR2(12)
  • wdet1_no (Field3) — VARCHAR(10)

소방훈련 이력 (Untitled2)

  • seq — int(100000) — 기본 키 — NOT NULL
  • f_code — VARCHAR2(10) — 외래 키 → 공장/공정.f_code — NOT NULL
  • sf_code — VARCHAR2(10) — 외래 키 → 공장/공정.sf_code
  • user_id — VARCHAR2(5)
  • reg_date — DATE
  • ff_stime — TIME
  • ff_etime — TIME
  • wdet1_no — VARCHAR(10)
  • order_door_id — VARCHAR2(500)
  • closed_door_id — VARCHAR2(500)
  • ff_result — VARCHAR2(1000)
  • reg_datetime — DATETIME
  • Field
  • Field2
  • w_dev_id (w_ded_id) — VARCHAR2(12) — 외래 키 → 공장별 WISE1A.w_dev_id