Subject Re: [firebird-support] Is correct to have a unique key restriction for names?
Author Alexandre Benson Smith
Em 14/8/2011 23:43, W O escreveu:
> Hello everybody
>
> I had unique key restrictions on the column "Name" of tables like:
> Countries, States, Banks, etc.
>
> So, I can avoid duplicates.
>
> What do you think, is it correct to use unique keys for that job?
>
> Greetings.
>
> Walter.
>

It depends on the business rules...

I don't think that a unique constraint on the Field Name of a table of
people is ok.

We al lknow that there is more than one John Smith in the world.


see you !