Re: DataModel Design question
Posted by: Frank Jonas
Date: September 22, 2006 05:30AM

I think, you are on the right way. If you give all your entities a unique identifier (id) and you insert in your rent-table a column article_id referencing on article.id, you'll find out what article is connected with the rent.

SELECT rent.number, article.name, atricle.type FROM article a JOIN rent r ON (r.article_id = a.id)

Hope that helps

Regards Frank

Options: ReplyQuote


Subject
Written By
Posted
September 17, 2006 12:07PM
Re: DataModel Design question
September 22, 2006 05:30AM


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.