DB3K

Tables (4)

TB_LINE_WORK_HIST (WCT실적)

  • CDATE (날짜)
  • WKCTR (작업장)
  • TIME_ID (시간)
  • PROD_QTY (생산수량)
  • OK_QTY (양품수량)
  • NG_QTY (불량수량)
  • MATNR (품명)

TB_QC (통신기준정보)

  • WKCTR (Key) — Primary key — NOT NULL
  • OPSEQ (Key2) — Primary key — NOT NULL
  • STATION (Key3) — Primary key — NOT NULL
  • COL_SEQ (Key4) — Primary key — NOT NULL
  • DATA_GB (Field)

TB_QC_DB3K (공정측정데이터)

  • CDATE (날짜) — varchar(8)
  • SEQ_NO (공정) — INT
  • DATA_CNT (Field2) — INT
  • PNAME (품명) — VARCHAR(50)
  • DAT1 (데이터1) — VARCHAR(25)
  • DAT2 (데이터2) — VARCHAR(20)
  • DAT3 (Field) — VARCHAR(20)
  • DAT4 (Field3) — VARCHAR(20)
  • DAT4 (Field4) — VARCHAR(20)
  • Field5

TB_TICKET_RES (실적)

  • TICKET_RES_ID (Key) — Primary key — NOT NULL
  • CDATE (날짜)
  • WKCTR (작업장)
  • TIME_ID (시간)
  • PROD_QTY (생산수량)
  • GOOD_QTY (양품수량)
  • NG_QTY (불량수량)