Jump to content

Better MySQL table structure?


jodbowrs

Recommended Posts

Simply, a table for the members including contact information, a table for fields of work, and an associative table between the two.

 

If you don't know what types of contact information you'll be recording then there's two more tables: one for type of information ("Phone", "Email", etc.) and another associating contact with type of information ("Phone") with the actual information ("555-1212").

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.