DB3B_0828

Tables (8)

TB_ALARM_STATUS (Untitled6)

  • IDX (번호) — INT
  • CDATE (작업장) — VARCHAR(10)
  • VDATA (알람코드) — VARCHAR(10)
  • PLC_GB (PLC구분) — VARCHAR(10)
  • Field

TB_EQUIP_TROUBLE_HIST (Untitled4)

  • TRANSACTIONID (TROUBLE_HIST_ID) — INT — Primary key — NOT NULL
  • CDATE (기준일자) — VARCHAR(10)
  • WKCTR (라인코드) — VARCHAR(10)
  • OPSEQ (공정순서) — VARCHAR(10)
  • TICKER_ID (작업지시번호) — VARCHAR(10)
  • EQUIP_ID (설비번호) — VARCHAR(10)
  • TROUBLE_DESC (고장설명) — VARCHAR(100)

TB_QC (Untitled)

  • WKCTR (작업장) — VARCHAR(10) — Primary key — NOT NULL
  • OPSEQ (순서) — VARCHAR(10) — Primary key — NOT NULL
  • HOGI (라인구분) — VARCHAR(10) — Primary key — NOT NULL
  • PNAME (공정명) — VARCHAR(150) — Primary key — NOT NULL
  • COL_SEQ (공정순서) — INT — Primary key — NOT NULL
  • DATA_GB (데이터구분) — VARCHAR(10) — Primary key — NOT NULL
  • QC_NAME (측정항목명) — VARCHAR(50)
  • QC_YAK_NAME (측정항목약어) — VARCHAR(150)
  • DISPLAY (화면표시) — BIT
  • QC_FALG (품질분석구분) — BIT
  • QC_MANA (관리항목) — BIT

TB_QC_DB3B (Untitled3)

  • CDATE (일자) — VARCHAR(8)
  • SEQ_NO (순번) — INT
  • DATA_CNT (품질데이터수) — INT
  • PNAME (제품명) — VARCHAR(50)
  • DAT1 (품질데이터1) — VARCHAR(20)
  • ~ (Field)
  • DAT390 (품질데이터390) — VARCHAR(20)
  • MES_NG_FLAG (MES NG 판정) — VARCHAR(10)
  • MES_NG_OPSEQ (MES NG 공정) — VARCHAR(10)
  • OKNG_FLAG (OK,NG 구분) — VARCHAR(2)

TB_QC_SPEC (CopyOfUntitled2)

  • WKCTR (작업장) — VARCHAR(10) — Primary key — NOT NULL
  • OPSEQ (공정) — VARCHAR(10) — Primary key — NOT NULL
  • WKCTR (작업장2) — VARCHAR(10) — Foreign key → TB_QC_SPEC_SET.WKCTR — NOT NULL
  • OPSEQ (공정2) — VARCHAR(10) — Foreign key → TB_QC_SPEC_SET.OPSEQ — NOT NULL
  • QCSPEC_MAX (스펙최대값) — VARCHAR(100)
  • QCSPEC_MIN (스펙최소값) — VARCHAR(10)
  • QCSPEC_SET (스펙설정값) — VARCHAR(10)

TB_QC_SPEC_EXCLUDE_OPSEQ (CopyOfUntitled22)

  • WKCTR (작업장) — VARCHAR(10) — Primary key — NOT NULL
  • TYPE (공정) — VARCHAR(10) — Primary key — NOT NULL
  • WKCTR (작업장2) — VARCHAR(10) — Foreign key → TB_QC_SPEC.WKCTR — NOT NULL
  • OPSEQ (공정2) — VARCHAR(10) — Foreign key → TB_QC_SPEC.OPSEQ — NOT NULL
  • WKCTR (작업장22) — VARCHAR(10) — Foreign key → TB_QC_SPEC.WKCTR — NOT NULL
  • OPSEQ (공정22) — VARCHAR(10) — Foreign key → TB_QC_SPEC.OPSEQ — NOT NULL
  • OPSEQ (품질이름) — VARCHAR(100)
  • USE_YN (스펙구분) — VARCHAR(2)

TB_QC_SPEC_EXCLUDE_OPSEQ_LOG (Untitled5)

  • ROWSTAMP (순번) — INT — Primary key — NOT NULL
  • WKCTR (작업장2) — VARCHAR(10) — Foreign key → TB_QC_SPEC_EXCLUDE_OPSEQ.WKCTR — NOT NULL
  • TYPE (공정2) — VARCHAR(10) — Foreign key → TB_QC_SPEC_EXCLUDE_OPSEQ.TYPE — NOT NULL
  • WKCTR (작업장22) — VARCHAR(10) — Foreign key → TB_QC_SPEC_EXCLUDE_OPSEQ.WKCTR — NOT NULL
  • OPSEQ (공정22) — VARCHAR(10) — Foreign key → TB_QC_SPEC_EXCLUDE_OPSEQ.OPSEQ — NOT NULL
  • WKCTR (작업장222) — VARCHAR(10) — Foreign key → TB_QC_SPEC_EXCLUDE_OPSEQ.WKCTR — NOT NULL
  • OPSEQ (공정222) — VARCHAR(10) — Foreign key → TB_QC_SPEC_EXCLUDE_OPSEQ.OPSEQ — NOT NULL
  • WKCTR (작업장) — VARCHAR(10)
  • TYPE (사양구분) — VARCHAR(10)
  • OPSEQ_PRE_SET (공정이전값) — VARCHAR(10)
  • OPSEQ_CUR_SET (공정변경값) — VARCHAR(10)
  • REMARK (변경사유) — VARCHAR(100)

TB_QC_SPEC_SET (Untitled2)

  • WKCTR (작업장) — VARCHAR(10) — Primary key — NOT NULL
  • OPSEQ (공정) — VARCHAR(10) — Primary key — NOT NULL
  • SPEC_NAME (품질이름) — VARCHAR(100)
  • SPEC_GB (스펙구분) — VARCHAR(10)
  • DATA_TYPE (데이터타입) — VARCHAR(10)
  • DATA_LEN (데이터길이) — FLOAT
  • DOT_LEN (소수점길이) — FLOAT
  • MAXMIN_GB (최대최소) — VARCHAR(10)
  • QC_COL_SEQ (품질컬럼값) — INT