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

Re: Migrating database field values rules from Perl code to DB

by perrin (Chancellor)
on Feb 12, 2007 at 15:18 UTC ( #599542=note: print w/replies, xml ) Need Help??


in reply to Migrating database field values rules from Perl code to DB

The right place to store allowable values for a field is in a separate lookup table, with a foreign key constraint that forces the value to be one of the keys from the lookup table. MySQL supports this just fine as long as you use InnoDB tables.
  • Comment on Re: Migrating database field values rules from Perl code to DB

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://599542]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (6)
As of 2022-01-27 13:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (70 votes). Check out past polls.

    Notices?