⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Do I have a good database design?



Jack Magdalene

Jack Magdalene
  • profile picture
  • Member

Posted 21 March 2013 - 21:56 PM

Hi Everyone,

 

I'm using multiple drop-down lists in my crud design (via set_relation), when view the primary table in MySQL, it shows the ID numbers of the items selected from each of the drop-down tables (see attached screenshot).

 

Does this look like a good database design? Where the main table is showing ID numbers instead of the full description.  

 

Thanks in advance for your comments.

Jack


victor

victor
  • profile picture
  • Member

Posted 22 March 2013 - 10:57 AM

I think that's a normal solution.