SQLite Forum

closure table, prevent identical childrens names per parent
Login
The former being always the better option.

The latter will be hard for them Smuel and Sami twins.

Also, to add to Simon's suggestion, never make a hard rule in a Database structure if it is not a hard rule (or at least an enforceable one) in real life.