--- WORKSTATIONOUTCLBATCH table ---

CREATE TABLE WORKSTATIONOUTCLBATCH
(
  WORKSTATION_ID             NUMBER NOT NULL,
  TIMETOPROCESSITEMS         NUMBER DEFAULT 0 NULL,
  NOOFITEMSTOPROCESSTOGETHER NUMBER DEFAULT 1 NULL,
  SYSTEMUSER_ID              NUMBER NOT NULL,
  TIMESTAMP                  DATE NOT NULL
);

COMMENT ON COLUMN WORKSTATIONOUTCLBATCH.TIMETOPROCESSITEMS
  IS 'Time in milliseconds to process outscan items in cleanroom batches.';
COMMENT ON COLUMN WORKSTATIONOUTCLBATCH.NOOFITEMSTOPROCESSTOGETHER
  IS 'Number of items in buffer used on outscan in cleanroom batches. ';

ALTER TABLE WORKSTATIONOUTCLBATCH
  ADD CONSTRAINT XPKWORKSTATIONOUTCLBATCH PRIMARY KEY (WORKSTATION_ID);

ALTER TABLE WORKSTATIONOUTCLBATCH
  ADD CONSTRAINT WORKSTATIONOUTCLBATCH_WS FOREIGN KEY (WORKSTATION_ID)
  REFERENCES WORKSTATION (WORKSTATION_ID) ON DELETE CASCADE;