-- llx_scrap_ws_category.sql
-- Maps workstation (fk_ws) to a scrap reason category (F/T/L)
-- Workstations without an entry show only M + G reasons

CREATE TABLE IF NOT EXISTS llx_scrap_ws_category (
  rowid       INT    NOT NULL AUTO_INCREMENT,
  fk_ws       INT    NOT NULL,
  ws_category CHAR(1) NOT NULL,
  PRIMARY KEY (rowid),
  UNIQUE KEY uk_scrap_ws_category (fk_ws)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
