Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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..

    cheers,

    J

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2017-04-26 16:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (484 votes). Check out past polls.