Table structure for multiple names
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!
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.