MES-ERROR-BOARD
테이블 (6)
게시판테이블 (BOARD)
- NO (Key) — NUMBER — 기본 키 — NOT NULL
- REFNO (Field) — NUMBER(5)
- EQNUM (Field2) — NUMBER(5)
- SUBJECT (Field3) — VARCHAR2(100)
- CONTENT (Field4) — VARCHAR2(100)
- WRITER (Field5) — VARCHAR2(50)
- READCNT (Field6) — VARCHAR2(100)
- REGDTE (Field7) — DATE
- UPTDTE (Field8) — DATE
발주 스케줄 (Calendar_Schedule)
- ID (Key) — NUMBER()4 — 기본 키 — NOT NULL
- TITLE (Field) — VARCHAR2(100)
- WRITER (Field2) — VARCHAR2(50)
- START1 (Field3) — DATE
- END1 (Field4) — DATE
- CONTENT (Field5) — VARCHAR2(1000)
- BACKGROUNDCOLOR (Field6) — VARCHAR2(50)
- TEXTCOLOR (Field7) — VARCHAR2(50)
- ALLDAY (Field8) — NUMBER(1)
부자재 발주서 (PURORDER)
- INVNO (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
- EMPNO (Key2) — NUMBER(4) — 외래 키 → 사원정보.EMPNO — NOT NULL
- INVEMAIL (Field) — VARCHAR2(50)
- INV_STARTDATE (Field2) — DATE
- INV_ENDDATE (Field3) — DATE
- PRODUCTID (Field4) — NUMBER(10)
- INVCNT (Field5) — NUMBER(10)
- INVPRICE (Field6) — NUMBER(10,2)
- EMPNO (Field7) — NUMBER(4) — NOT NULL
사원정보 (MESEMP)
- EMPNO (Key) — NUMBER(4) — 기본 키 — NOT NULL
- MGR (Field) — NUMBER(4)
- AUTH (Field2) — VARCHAR2(50)
- JOB (Field3) — VARCHAR2(50)
- ENAME (Field4) — VARCHAR2(50)
- PNUMBER (Field5) — VARCHAR2(100)
- PWD (Field6) — NUMBER(4)
- DEPT (Field7) — VARCHAR2(50)
- DEPTNO (Field8) — NUMBER(10)
완제품 발주서 (INVOICE)
- INVNO (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
- EMPNO (Key2) — NUMBER(4) — 외래 키 → 사원정보.EMPNO — NOT NULL
- INVEMAIL (Field) — VARCHAR2(50)
- INV_STARTDATE (Field2) — DATE
- INV_ENDDATE (Field3) — DATE
- PRODUCTID (Field4) — NUMBER(10)
- INVCNT (Field5) — NUMBER(10)
- INVPRICE (Field6) — NUMBER(10,2)
- EMPNO (Field7) — NUMBER(4) — NOT NULL
파일리스트 (BOARDFILE)
- Key — 기본 키 — NOT NULL
- FNAME (Field2) — VARCHAR2(100)
- ETC (Field3) — VARCHAR2(100)
- REGDTE (Field4) — DATE
- UPTDTE (Field) — DATE