LISTING 3: Code to Create and Populate the Statuses Auxiliary Table

CREATE TABLE Statuses
(
  status     int         NOT NULL PRIMARY KEY,
  seq        int         NOT NULL UNIQUE
)

INSERT INTO Statuses VALUES(21, 1) -- Item is transferred to workshop.
INSERT INTO Statuses VALUES(20, 2) -- Work is in progress.
INSERT INTO Statuses VALUES(0,  3) - Item is handed in.
INSERT INTO Statuses VALUES(30, 4) -- Item is ready.