Hibernate Community • View topic - How to implement mapping tables with additional fields

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to implement mapping tables with additional fields

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

cagan327

Post subject: How to implement mapping tables with additional fields

Posted: Thu Jul 29, 2004 2:33 pm

Newbie

Joined: Mon Jun 14, 2004 5:16 pm
Posts: 16
Location: New York

I'm trying to write a program that deals with movies, theaters and what
movies play at what theaters.

Here are the 3 tables I have:

tbl_movie

Code:

movie_id
name
...

tbl_venue

Code:

venue_id
name
...

tbl_movie_venue_map

Code:

movie_id
venue_id
start_date
end_date
time_info
price_info
....

My initial approach is to have 3 classes:
Movie
Venue
MovieVenueMap

MovieVenueMap will obviously hold Movie and Venue entities and the
additional field values (start_date, end_date, etc)...

Is this the correct approach? Or is there a better, more efficient way of representing the tbl_movie_venue_map?

Thanks in advance,
Cagan

Top

gstamp

Post subject:

Posted: Thu Jul 29, 2004 9:17 pm

Regular

Joined: Thu Nov 20, 2003 10:04 pm
Posts: 64
Location: Melbourne, Australia

I'm no hibernate expert but it sounds okay to me.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum