예시DB

테이블 (3)

production_data ()

  • id (Key) — 기본 키 — NOT NULL
  • worker_id (Key2) — 외래 키 → workers.worker_id — NOT NULL
  • product__id (Key3) — 외래 키 → products.product__id — NOT NULL
  • production_date (Field)
  • shift (Field2)
  • quantity (Field4)
  • created_at (Field6)

products (CopyOfUntitled2)

  • product__id (Key) — 기본 키 — NOT NULL
  • product_name (Field)
  • category (Field2)

workers (CopyOfUntitled)

  • worker_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • department (Field2)
  • role (Field3)