lastproject

테이블 (8)

BOM (product_materials)

  • bom_id — NUMBER
  • product_code — VARCHAR2(20) — NOT NULL
  • material_code — VARCHAR2(20) — NOT NULL
  • quantity — NUMBER(10,2) — NOT NULL
  • created_date — DATE
  • updated_date — DATE
  • created_by — VARCHAR2(50)
  • updated_by — VARCHAR2(50)

inventory

  • inventory_id — NUMBER
  • item_code — VARCHAR2(20) — NOT NULL
  • current_qty — NUMBER(10)
  • min_qty — NUMBER(10)
  • max_qty — NUMBER(10)
  • unit — VARCHAR2(20)
  • location — VARCHAR2(100)
  • last_updated — DATE
  • updated_by — VARCHAR2(50)
  • created_date — DATE
  • created_by — VARCHAR2(50)

inventory_transactions

  • transaction_id — NUMBER
  • inventory_id — NUMBER — NOT NULL
  • item_code — VARCHAR2(20) — NOT NULL
  • transaction_type — VARCHAR2(20) — NOT NULL
  • quantity — NUMBER(10) — NOT NULL
  • before_qty — NUMBER(10) — NOT NULL
  • after_qty — NUMBER(10) — NOT NULL
  • reason — VARCHAR2(200)
  • lot_number — VARCHAR2(20)
  • supplier_id — VARCHAR2(20)
  • transaction_date — DATE
  • created_by — VARCHAR2(50)

lot_tracking

  • tracking_id — NUMBER
  • lot_number — VARCHAR2(20) — NOT NULL
  • stage — VARCHAR2(20) — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • responsible_id — VARCHAR2(50)
  • responsible_name — VARCHAR2(100)
  • remarks — VARCHAR2(500)
  • created_date — DATE

quality_inspections

  • inspection_no — VARCHAR2(20)
  • work_order_no — VARCHAR2(20) — NOT NULL
  • status — VARCHAR2(20)
  • inspector_id — VARCHAR2(50)
  • inspector_name — VARCHAR2(100)
  • good_qty — NUMBER(10)
  • defect_qty — NUMBER(10)
  • defect_reason — VARCHAR2(500)
  • inspection_date — DATE
  • created_date — DATE
  • updated_date — DATE
  • created_by — VARCHAR2(50)
  • updated_by — VARCHAR2(50)

기준관리 (items)

  • item_code — VARCHAR2(20)
  • item_name — VARCHAR2(100) — NOT NULL
  • item_type — VARCHAR2(20) — NOT NULL
  • unit — VARCHAR2(20) — NOT NULL
  • created_date — DATE
  • updated_date — DATE
  • created_by — VARCHAR2(50)
  • updated_by — VARCHAR2(50)

생산관리 (production_lots)

  • lot_number — VARCHAR2(20)
  • product_code — VARCHAR2(20) — NOT NULL
  • planned_qty — NUMBER(10) — NOT NULL
  • actual_qty — NUMBER(10)
  • status — VARCHAR2(20)
  • planned_start_date — DATE
  • planned_end_date — DATE
  • actual_start_date — DATE
  • actual_end_date — DATE
  • created_date — DATE
  • updated_date — DATE
  • created_by — VARCHAR2(50)
  • updated_by — VARCHAR2(50)

작업지시서 (work_orders)

  • work_order_no — VARCHAR2(20)
  • lot_number — VARCHAR2(20) — NOT NULL
  • product_code — VARCHAR2(20) — NOT NULL
  • planned_qty — NUMBER(10) — NOT NULL
  • actual_qty — NUMBER(10)
  • status — VARCHAR2(20)
  • worker_id — VARCHAR2(50)
  • worker_name — VARCHAR2(100)
  • start_date — DATE
  • end_date — DATE
  • created_date — DATE
  • updated_date — DATE
  • created_by — VARCHAR2(50)
  • updated_by — VARCHAR2(50)