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