Electronics Manufacturing Execution Suite (EMES)
Tables (10)
BOM
- bom_id — NUMBER(10)
- product_id — NUMBER(10)
BOM_DETAIL
- bom_detail_id — NUMBER(10)
- bom_id — NUMBER(10) — NOT NULL
- part_id — NUMBER(10) — NOT NULL
- quantity — NUMBER(5) — NOT NULL
EMPLOYEE
- employee_id — NUMBER(10)
- employee_name — VARCHAR2(255) — NOT NULL
INVENTORY
- inventory_id — NUMBER(10)
- product_id — NUMBER(10)
- current_stock — NUMBER(10) — NOT NULL
- last_updated — TIMESTAMP — NOT NULL
PART
- part_id — NUMBER(10)
- part_name — VARCHAR2(255) — NOT NULL
- part_number — VARCHAR2(100) — NOT NULL
PERFORMANCE
- performance_id — NUMBER(10)
- process_id — NUMBER(10) — NOT NULL
- good_quantity — NUMBER(10) — NOT NULL
- defect_quantity — NUMBER(10) — NOT NULL
- inspection_status — VARCHAR2(50) — NOT NULL
- inspection_date — TIMESTAMP — NOT NULL
PROCESS
- process_id — NUMBER(10)
- work_order_id — NUMBER(10) — NOT NULL
- process_type — VARCHAR2(100) — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP
- employee_id — NUMBER(10)
PRODUCT
- product_id — NUMBER(10)
- product_name — VARCHAR2(255) — NOT NULL
- model_number — VARCHAR2(100) — NOT NULL
SHIPMENT
- shipment_id — NUMBER(10)
- product_id — NUMBER(10) — NOT NULL
- quantity — NUMBER(10) — NOT NULL
- shipment_date — DATE — NOT NULL
WORK_ORDER
- work_order_id — NUMBER(10)
- product_id — NUMBER(10) — NOT NULL
- quantity — NUMBER(10) — NOT NULL
- start_date — DATE — NOT NULL
- status — VARCHAR2(50) — NOT NULL