create table codes (
        id integer,
        subid integer,
        data text,
        unique (id, subid, data),
        foreign key (id, subid) references items(id, subid)
);