예시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)