Hibernate Community • View topic - Mapping many-to-one with foreign primary key

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

Mapping many-to-one with foreign primary key

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

kakoni

Post subject: Mapping many-to-one with foreign primary key

Posted: Tue Nov 27, 2007 5:36 am

Newbie

Joined: Tue Nov 27, 2007 5:29 am
Posts: 9

Hi! I've been wondering what would be the best way to map this legacy db structure. I've got two tables;

TABLE first (
event_id DECIMAL(22, 0) NOT NULL,
file_id VARCHAR(20) NULL,
PRIMARY KEY (`event_id`)
)

TABLE second (
event_id DECIMAL(22, 0) NOT NULL,
xml_schema VARCHAR(200) NULL,
CONSTRAINT `fk` FOREIGN KEY `fk` (`event_id`)
REFERENCES `first` (`event_id`)
)

So first 1-m second.

How would you represent using annotations? Table second doesn't have any primary key specified.

Top

kakoni

Post subject:

Posted: Tue Nov 27, 2007 7:04 am