Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

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]
NodeReaper snacks on some Soylent Green

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (8)
As of 2017-03-25 18:38 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (313 votes). Check out past polls.