Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Re: Class::DBI and DB design

by v_thunder (Scribe)
on Jun 06, 2003 at 17:32 UTC ( #263788=note: print w/replies, xml ) Need Help??

in reply to Re: Class::DBI and DB design
in thread Class::DBI and DB design

I was under the impression that a primary key was equivalent to "unique not null", and indexed. In the user_login case the uid would not be unique, since there would be multiple rows with the same uid, one for each login from the same user.

Am I wrong here? Can I really use uid as the primary key in that example?

Replies are listed 'Best First'.
Re: Re: Re: Class::DBI and DB design
by edoc (Chaplain) on Jun 06, 2003 at 17:46 UTC

    ahhh.. doh.. thought I must've be missin something.. maybe I didn't need that extra beer..



Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://263788]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (9)
As of 2017-06-26 10:02 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (577 votes). Check out past polls.