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