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