Composite Unique Constraint SQL
Yes. This would be a composite unique key:
alter table t add constraint unq_t_parent_name unique (parent, name);If you don't care if the constraint has a name, then you can just create a unique index:
create unique index unq_t_parent_name on t(parent, name);