T
테이블 (7)
Copy Of RDT/FDT/CT (CopyOfrdt_fdt_ct)
- Key (seq_no) — 기본 키 — NOT NULL
- Key (coil_no) — 외래 키 → 코일.Key — NOT NULL
- 위치(EX.FMTOP1,FMTOP2 (location) — VARCHAR
- 타점 (point) — long
- 온도 (temp) — long
- P/F (p/f) — Boolean — NOT NULL
- CREATION_TIMESTAMP (creation_timestamp) — DATETIME
Copy Of 두께/폭편차 (CopyOfthick_width_deviation)
- Key (seq_no) — 기본 키 — NOT NULL
- Key (coil_no) — 외래 키 → 코일.Key — NOT NULL
- 위치(EX.FMTOP1,FMTOP2 (location) — VARCHAR
- 타점 (point) — long
- 온도 (temp) — long
- P/F (p/f) — Boolean — NOT NULL
- CREATION_TIMESTAMP (creation_timestamp) — DATETIME
FM/DC (fmt_dct2)
- Key (seq_no) — 기본 키 — NOT NULL
- Key (coil_no) — 외래 키 → 코일.Key — NOT NULL
- 위치(EX.FMTOP1,FMTOP2 (location) — VARCHAR
- 타점 (point) — long
- 온도 (temp) — long
- CREATION_TIMESTAMP (creation_timestamp) — DATETIME
기준(지시) (rule)
- Key (rule_no) — 기본 키 — NOT NULL
- 폭MIN (width_min) — long
- 폭MAX (width_max) — long
- 두께MIN (thick_min) — long
- 두께MAX (thick_max) — long
- RMT (rmt) — long
- FMT (fmt) — long
- CT (ct) — long
- MANAGER (manager) — VARCHAR — NOT NULL
- DATE (created_date) — DATETIME — NOT NULL
대표실적 (spec)
- Key — 기본 키 — NOT NULL
- Key (coil_no) — 외래 키 → 코일.Key — NOT NULL
- RDT_AVERAGE (rdt_average) — long
- RDT_DEVIATION (rdt_deviation) — long
- RDT_MAX (rdt_maxl) — long
- RDT_MIN (rdt_min) — long
- FDT_AVERAGE (fdt_average) — long
- FDT_DEVIATION (fdt_deviation) — long
- FDT_MAX (fdt_max) — long
- FDT_MIN (fdt_min) — long
- CT_AVERAGE (ct_average) — long
- CT_DEVIATION (cd_deviation) — long
- CT_MAX (ct_max) — long
- CT_MIN (ct_min) — long
- THICK_AVERAGE (thick_average) — long
- THICK_DEVIATION (thick_deviation) — long
- THICK_MAX (thick_max) — long
- THICK_MIN (thick_min) — long
- WIDTH_AVERAGE (width_average) — long
- WIDTH_DEVIATION (width_deviation) — long
- WIDTH_MAX (width_max) — long
- WIDTH_MIN (width_min) — long
이상부위모음집 (error_point)
- Key — 기본 키 — NOT NULL
- Key (coil_no) — 외래 키 → 코일.Key — NOT NULL
- THICK_HEAD (thick_head) — long
- THICK_TAIL (thick_tail) — long
- WIDTH_HEAD (width_head) — long
- WIDTH_TAIL (width_tail) — long
- FDT_HEAD (fdt_head) — long
- FDT_TAIL (fdt_tail) — long
- CT_HEAD (ct_head) — long
- CT_TAIL (ct_tail) — long
- 최종절사해드위치 (cut_head) — long
- 최종절사테일위치 (cut_tail) — long
코일 (coil)
- Key (coil_no) — 기본 키 — NOT NULL
- Key (rule_no) — 외래 키 → 기준(지시).Key — NOT NULL
- 메시지 (content) — VARCHAR
- CREATION_TIMESTAMP (creation_timestamp) — DATETIME
- DATA_END_TIMESTAMP (data_end_timestamp) — DATETIME