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