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