create table t_object ( object_id integer auto_increment primary key not null, class_id integer not null references t_class(class_id), index (object_id), unique (object_id), index (class_id) );