MESsystem

Tables (14)

DEFECT

  • DEFECTID — VARCHAR2(50) — Primary key — NOT NULL
  • DEFECTNAME — VARCHAR2(50)NOT — NOT NULL

DEFECTLOT

  • DEFECT_LOTID — VARCHAR2(50) — Foreign key → LOT.LOTID — NOT NULL
  • DEFECT_QTY — NUMBER
  • DEFECT_DTTM — TIMESTAMP
  • DEFECTID — VARCHAR2(50) — Foreign key → DEFECT.DEFECTID — NOT NULL

EMPLOYEE

  • EMPLOYEEID — VARCHAR2(50) — Primary key — NOT NULL
  • EMPLOYEEPASSWORD — VARCHAR2(50) — NOT NULL
  • EMPLOYEENAME — VARCHAR2(50) — NOT NULL

EMPLOYEE_LOG

  • LOGDTTM — TIMESTAMP
  • Key (EMPLOYEEID) — VARCHAR2(50) — Foreign key → EMPLOYEE.EMPLOYEEID — NOT NULL

EMP_AUTHORITY

  • ADMIN_YN — VARCHAR2(50)
  • EMPLOYEEID — VARCHAR2(50) — Foreign key → EMPLOYEE.EMPLOYEEID — NOT NULL
  • PROCID — VARCHAR2(50) — Foreign key → PROCESS.PROCID — NOT NULL

EQPTDATACOLLECT

  • EQPTITEMVALUE — VARCHAR2(50)
  • EQPTITEMDTTM — TIMESTAMP
  • EQPTID — VARCHAR2(50)NOT — Foreign key → EQUIPMENT.EQPTID — NOT NULL
  • EQPTITEMID — VARCHAR2(50) — Foreign key → EQPTDATAITEM.EQPTITEMID — NOT NULL

EQPTDATAITEM

  • EQPTITEMID — VARCHAR2(50) — Primary key — NOT NULL
  • EQPTITEMNAME — VARCHAR2(50)
  • EQPTITEMUNIT — VARCHAR2(50)

EQUIPMENT

  • EQPTID — VARCHAR2(50)NOT — Primary key — NOT NULL
  • EQPTNAME — VARCHAR2(50) — NOT NULL
  • PROCID — VARCHAR2(50)
  • EQPTSTATS — VARCHAR2(50)

LOT

  • LOTID — VARCHAR2(50) — Primary key — NOT NULL
  • INSUSER — VARCHAR2(50) — Foreign key → EMPLOYEE.EMPLOYEEID — NOT NULL
  • LOTSTAT — VARCHAR2(50)
  • LOTCRDTTM — TIMESTAMP
  • LOTSTDTTM — TIMESTAMP
  • LOTEDDTTM — TIMESTAMP
  • LOTCRQTY — NUMBER
  • LOTQTY — NUMBER
  • INSDTTM — TIMESTAMP
  • WOID — VARCHAR(50) — Foreign key → WORKORDER.WOID — NOT NULL
  • PROCID — VARCHAR2(50) — Foreign key → PROCESS.PROCID — NOT NULL
  • EQPTID — VARCHAR2(50)NOT — Foreign key → EQUIPMENT.EQPTID — NOT NULL
  • EMPLOYEEID — VARCHAR2(50) — Foreign key → WORKORDER.INSUSER — NOT NULL

MATERIAL

  • MTRLID — VARCHAR2(50) — Primary key — NOT NULL
  • MTRLNAME — VARCHAR2(50) — NOT NULL
  • MTRLUNIT — VARCHAR2(50)
  • MTRLCOST — NUMBER
  • MTRLTYPE — VARCHAR2(50)
  • MTRLQTY — NUMBER
  • STORID — VARCHAR2(50) — Foreign key → STORE_STORAGE.STORID — NOT NULL

PROCESS

  • PROCID — VARCHAR2(50) — Primary key — NOT NULL
  • PROCNAME — VARCHAR2(50)NOT — NOT NULL

PRODUCT

  • PRODID — VARCHAR2(50) — Primary key — NOT NULL
  • PRODNAME — VARCHAR2(50)NOT — NOT NULL
  • PRODUNIT — VARCHAR2(50)
  • PRODCOST — NUMBER
  • PRODTYPE — VARCHAR2(50)
  • PRODWEIGHT — NUMBER

STORE_STORAGE

  • STORID — VARCHAR2(50) — Primary key — NOT NULL
  • STORNAME — VARCHAR2(50) — NOT NULL
  • MAXLEVEL — NUMBER
  • MINLEVEL — NUMBER
  • CURRQTY — NUMBER

WORKORDER

  • WOID — VARCHAR(50) — Primary key — NOT NULL
  • INSUSER — VARCHAR2(50) — Foreign key → EMPLOYEE.EMPLOYEEID — NOT NULL
  • WOSTAT — VARCHAR(5) — NOT NULL
  • PLANDTTM — TIMESTAMP
  • WOSTDTTM — TIMESTAMP
  • WOEDDTTM — TIMESTAMP
  • PLANQTY — NUMBER
  • PRODQTY — NUMBER
  • INSDTTM — TIMESTAMP
  • ETC — VARCHAR2(50)
  • PROCID — VARCHAR2(50) — Foreign key → PROCESS.PROCID — NOT NULL
  • PRODID — VARCHAR2(50) — Foreign key → PRODUCT.PRODID — NOT NULL