create table baseitems (
        id integer primary key,
        data text
);

##</code><code>##

create table items (
        id integer,
        subid integer,
        data text,
        primary key (id, subid),
        foreign key (id) references baseitems (id)
);

##</code><code>##

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