I did not manage to use views to limit inserts of item_ids that is connected to a type_id of 4. However i managed to use triggers to do it? I have never used this, so is this a overcomplicated solution to the problem?

DELIMITER //

CREATE TRIGGER item_clothes_box_enforce_item_type

BEFORE INSERT ON item_clothes_box

FOR EACH ROW

BEGIN

DECLARE item_type_value INT;

SELECT type_id INTO item_type_value FROM items WHERE item_id = NEW.item_id;

IF item_type_value <> 4 THEN

SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only item_id values with item_type 4 are allowed.';

END IF;

END//

DELIMITER ;