Table structure for multiple names
Posted by: J. Holmberg
Date: April 09, 2013 07:40AM

I'm creating a database that will contain information about artists. like this:

artists
   • id
   • year_born
   • month_born
   • day_born
   • city_born
   • country_born
   • year_died
   • month_died
   • day_died
   • city_died
   • country_died
   • contemporary
   • unknown
   • views
   • publish
   • time_created
   • time_modified

Who can have multiple first names, surnames and aliases. The question is whether I should create separate tables for first name, last name and alias. like this:

artist_surname
   • id
   • artist_id
   • name
   • sorting
   • publish
   • time_created
   • time_modified

artist_forename
   • id
   • artist_id
   • name
   • sorting
   • publish
   • time_created
   • time_modified

artist_alias
   • id
   • artist_id
   • name
   • sorting
   • publish
   • time_created
   • time_modified

Or if I should have it all in one table and there determine what type it is. like this:

artist_name
   • id
   • artist_id
   • name
   • name_type (surname, forename, alias)
   • sorting
   • publish
   • time_created
   • time_modified

Would really appreciate if the experts could give their opinion!

Options: ReplyQuote


Subject
Written By
Posted
Table structure for multiple names
April 09, 2013 07:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.