some_types ( id serial primary key, name ); some_objects ( id serial primary key, name, some_type_id, CONSTRAINT fk1 FOREIGN KEY (some_type_id) REFERENCES some_types(id) );