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