temp
Tables (6)
tb_mart_bar_inout
- date — date — Primary key — NOT NULL
- bar_no — int2 — Primary key — NOT NULL — 봉강번호
- poc_no — varchar(7) — POC
- heat — varchar(7) — HEAT
- steel_nm — varchar(20) — 강종명
- item_size — int2 — 봉강구경
- length — int2 — 봉강
- timestamp_min — timestamp(3) — 최소시간
- value_min — int2 — Cycle
- timestamp_max — timestamp(3) — 최대시간
- value_max — int2 — Cycle
- timestamp_min_offset — timestamp — 최소시간
- dup_count — int4 — 중복
- timestamp_dup_min — timestamp — 중복
- working_time — float8 — 교정
- req_no_from — int4
- req_no_to — int4
- reg_id — varchar — 생성자
- reg_dt — timestamp — 생성일시
- mod_id — varchar — 수정자
- mod_dt — timestamp — 수정일시
tb_mart_bar_manual_summary
- date — date — Primary key — NOT NULL — 생산일
- bar_no — int4 — Primary key — NOT NULL — 봉강번호
- tag_id — varchar(22) — Primary key — NOT NULL — 태그
- poc_no — varchar(7) — poc
- heat — varchar(7) — HEAT
- steel_nm — varchar(20) — 강종명
- item_size — float8 — 봉강구경
- length — int4 — 봉강길이
- tag_nm — varchar(45) — 태그
- changed — int2 — 변동
- first — int2 — 첫
- last — int2 — 마지막
- num_changed — int4 — 변동
- reg_id — varchar — 생성자
- reg_dt — timestamp — 생성일시
- mod_id — varchar — 수정자
- mod_dt — timestamp — 수정일시
tb_mart_bar_stat
- date — date — Primary key — NOT NULL — 생산일
- bar_no — int4 — Primary key — NOT NULL — 봉강번호
- tag_id — varchar(22) — Primary key — NOT NULL — 태그
- poc_no — varchar(7) — poc
- heat — varchar(7) — HEAT
- steel_nm — varchar(20) — 강종명
- item_size — float8 — 봉강구경
- length — int4 — 봉강길이
- tag_nm — varchar(45) — 태그
- stat_count — float8 — 관측치
- stat_min — float8 — 최소값
- stat_p25 — float8 — 25%
- stat_mean — float8 — 평균
- stat_mode — float8 — 최빈값
- stat_median — float8 — 중앙값
- stat_p75 — float8 — 75%
- stat_max — float8 — 최대값
- stat_std — float8 — 표준편차
- stat_1sig_sp — float8 — 90%
- stat_1sig_ep — float8 — 90%
- stat_2sig_sp — float8 — 95%
- stat_2sig_ep — float8 — 95%
- stat_3sig_sp — float8 — 99%
- stat_3sig_ep — float8 — 99%
- stat_1_5iqr_sp — float8 — 중앙값
- stat_1_5iqr_ep — float8 — 중앙값
- stat_2_5iqr_sp — float8 — 중앙값
- stat_2_5iqr_ep — float8 — 중앙값
- stat_skew — float8 — 왜도
- stat_skew_flag — varchar(1) — 치우침
- stat_kurt — float8 — 첨도
- stat_kurt_flag — varchar(1) — 양쪽
- use_yn — varchar(16) — 사용
- reg_id — varchar — 생성자
- reg_dt — timestamp — 생성일시
- mod_id — varchar — 수정자
- mod_dt — timestamp — 수정일시
tb_mart_mic_judge
- date — date — Primary key — NOT NULL — 일자
- mic_no — int4 — Primary key — NOT NULL — MIC
- poc_no — varchar(40) — NOT NULL — POC
- heat — varchar(40) — NOT NULL — HEAT
- steel_nm — varchar(40) — NOT NULL — 강종명
- item_size — float8 — NOT NULL — 봉강규격
- length — float8 — NOT NULL — 봉강길이
- line_speed — int4 — NOT NULL — 라인속도
- judge_flag — int4 — NOT NULL — 판정값
- max_dist — int2 — NOT NULL — 판정
- max_count — int2 — NOT NULL — 판정
tb_mart_mic_judge_detail
- date — date — Primary key — NOT NULL — 일자
- mic_no — int4 — Primary key — NOT NULL — MIC
- seq — int4 — Primary key — NOT NULL — 시퀀스
- circle_x — float4 — NOT NULL — X
- circle_y — float4 — NOT NULL — Y
- circle_z — float4 — NOT NULL — Z
- dist — float4 — NOT NULL — 계산
- err_flag — int4 — 판정
tb_mart_mic_judge_sim
- date — date — Primary key — NOT NULL — 일자
- mic_no — int4 — Primary key — NOT NULL — MIC
- x1_dtw — float4 — X1
- x1_cosine_similarity — float4 — X1
- x1_sax_3sigma — float4 — X1
- x2_dtw — float4 — X2
- x2_cosine_similarity — float4 — X2
- x2_sax_3sigma — float4 — X2
- y_dtw — float4 — Y
- y_cosine_similarity — float4 — Y
- y_sax_3sigma — float4 — Y