Subject | Re: [firebird-support] Is correct to have a unique key restriction for names? |
---|---|
Author | Alexandre Benson Smith |
Post date | 2011-08-15T03:03:28Z |
Em 14/8/2011 23:43, W O escreveu:
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 !
> Hello everybodyIt depends on the business rules...
>
> 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.
>
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 !