new-Drink

Tables (4)

defect

  • defect_code — VARCHAR(20) — Primary key
  • defect_name — VARCHAR(100) — NOT NULL
  • cause — VARCHAR(200)

production_order

  • po_id — INT — Primary key
  • created_by — INT — Foreign key → users.user_id
  • product_id — NUMBER — Foreign key
  • eq_id — NUMBER — Foreign key
  • product_name — VARCHAR(100) — NOT NULL
  • target_qty — INT — NOT NULL
  • due_date — DATE
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATE

production_result

  • pr_id — INT — Primary key
  • eq_id — NUMBER — Foreign key
  • po_id — INT — Foreign key → production_order.po_id
  • defect_code — VARCHAR(20) — Foreign key → defect.defect_code
  • worker_name — VARCHAR(50)
  • good_qty — INT
  • defect_qty — INT
  • result_time — DATE

users

  • user_id — INT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(200) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATE