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 (불량수량)