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