Subject | Re: [firebird-support] Is correct to have a unique key restriction for names? |
---|---|
Author | W O |
Post date | 2011-08-15T03:08:08Z |
Hello Alexandre
Of course that no with people's names, just with control tables like
Countries or States which never have duplicates.
Greetings.
Walter.
On Sun, Aug 14, 2011 at 11:03 PM, Alexandre Benson Smith <
iblist@...> wrote:
Of course that no with people's names, just with control tables like
Countries or States which never have duplicates.
Greetings.
Walter.
On Sun, Aug 14, 2011 at 11:03 PM, Alexandre Benson Smith <
iblist@...> wrote:
> **[Non-text portions of this message have been removed]
>
>
> 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 !
>
>
>