create table comp (
comp_id INTEGER NOT NULL,
comp_owner_id INTEGER NOT NULL,
comp_name VARCHAR NOT NULL,
CONSTRAINT comp_unq UNIQUE (comp_owner_id, comp_name),
CONSTRAINT comp_pk PRIMARY KEY (comp_id),
CONSTRAINT comp_owner_fk FOREIGN KEY (comp_owner_id) REFERENCES owner (owner_id) NOT DEFERRABLE
);
那应该做你想要的。