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