EMS DB

Tables (12)

DELI (출고)

  • DELINO (출고번호) — NUMBER — Primary key — NOT NULL
  • INVNO (재고번호) — NUMBER — Foreign key → INV.INVNO — NOT NULL
  • DELIQTY (출고수량) — NUMBER
  • LOC (출고지역) — VARCHAR(N)

DEPT (부서)

  • DEPTNO (부서번호) — NUMBER — Primary key — NOT NULL
  • DEPTNAME (부서이름) — VARCHAR(N)

EMP (사원)

  • EMPNO (사원번호) — NUMBER — Primary key — NOT NULL
  • DEPTNO (부서번호) — NUMBER — Foreign key → DEPT.DEPTNO — NOT NULL
  • ENAME (사원이름) — VARCHAR(N)
  • JOB (직책) — VARCHAR(N)
  • HIREDATE (입사일) — DATE
  • MGR (상사) — VARCHAR(N)

FDCFAULT (설비이상감지)

  • FAULTNO (이상감지이력번호) — NUMBER — Primary key — NOT NULL
  • LOGNO (로그번호) — NUMBER — Foreign key → FDCLOG.LOGNO — NOT NULL
  • SEQNO (시퀸스번호) — NUMBER — Foreign key → FDCLOG.SEQNO — NOT NULL
  • FAULTCODE (이력감지코드) — VARCHAR(N)
  • FAULTMSG (이상감지이력) — VARCHAR(N)
  • FAULTTIME (이상감지시간) — DATE

FDCLOG (설비데이터로그)

  • LOGNO (로그번호) — NUMBER — Primary key — NOT NULL
  • PARAMNO (설비데이터번호) — VARCHAR(N) — Foreign key → FDCPARAM.PARAMNO — NOT NULL
  • SEQNO (시퀸스번호) — NUMBER — Foreign key → FDCPARAM.SEQNO — NOT NULL
  • PARAMVALUE (설비테이터 벨류) — NUMBER
  • LOGTIME (로그시간) — DATE

FDCPARAM (설비데이터수집)

  • PARAMNO (설비데이터번호) — VARCHAR(N) — Primary key — NOT NULL
  • SEQNO (시퀸스번호) — NUMBER — Foreign key → SEQ.SEQNO — NOT NULL
  • PARAMNAME (설비데이터이름) — VARCHAR(N)
  • UPPERLIMIT (상한값) — NUMBER
  • LOWERLIMIT (하한값) — NUMBER
  • UNIT (규격) — VARCHAR(N)

INV (재고관리)

  • INVNO (재고번호) — NUMBER — Primary key — NOT NULL
  • PRODNO (제품번호) — NUMBER — Foreign key → PROD.PRODNO — NOT NULL
  • QTY (수량) — NUMBER
  • LOCATION (위치) — VARCHAR(N)
  • UPDATE_DATE (갱신날짜) — DATE

PERF (작업실적)

  • PERFNO (작업실적번호) — NUMBER — Primary key — NOT NULL
  • PROCNO (공정번호) — NUMBER — Foreign key → PROC.PROCNO — NOT NULL
  • EMPNO (사원번호) — NUMBER — Foreign key → EMP.EMPNO — NOT NULL
  • WONO (작업지시번호) — NUMBER — Foreign key → WO.WONO — NOT NULL
  • ORDERQTY (지시수량) — NUMBER
  • QTY_GOOD (완제품수량) — NUMBER
  • QTY_DEFECT (불량품수량) — NUMBER
  • PERF_DATE (완료일) — DATE
  • NOTE (비고) — VARCHAR(N)

PROC (공정)

  • PROCNO (공정번호) — NUMBER — Primary key — NOT NULL
  • SEQNO (시퀸스번호) — NUMBER — Foreign key → SEQ.SEQNO — NOT NULL
  • PROCNAME (공정이름) — VARCHAR(N)

PROD (제품)

  • PRODNO (제품번호) — NUMBER — Primary key — NOT NULL
  • PRODNAME (제품이름) — VARCHAR(N)
  • SPCE (규격) — VARCHAR(N)
  • UNIT (단위) — VARCHAR(N)

SEQ (설비)

  • SEQNO (시퀸스번호) — NUMBER — Primary key — NOT NULL
  • SEQNAME (시퀸스이름) — VARCHAR(N)
  • SEQOR (시퀸스순서) — VARCHAR(N)

WO (작업지시)

  • WONO (작업지시번호) — NUMBER — Primary key — NOT NULL
  • PRODNO (제품번호) — NUMBER — Foreign key → PROD.PRODNO — NOT NULL
  • PROCNO (공정번호) — NUMBER — Foreign key → PROC.PROCNO — NOT NULL
  • ORDERDATE (작업시작시간) — DATE
  • DUEDATE (작업종료시간) — DATE
  • QTY (생산수량) — NUMBER