Hi

I am trying to associate 2 tables by foreign key constraint. These 2 tables are job and jobtype.
There are only 2 jobtype. So the oid of the jobtype table will be used as the foreign key in job table, and the jobtype table should not be inserted any new row.
jobtype
0 lookingforjob
1 offerigjob

job
oid|description|jobtype

The mapping for jobtype in job.hbm.xml is the following
<many-to-one class="Jobtype" name="jobtype" cascade="all"/>

As a result, the hibernate create the job table, but without the foreign key constraint reference. And eveytime a job is inserted to the job table, a new jobtype is also inserted to the jobtype table.
CREATE TABLE `job` (
`oid` BIGINT(20) NOT NULL AUTO_INCREMENT,
`description` VARCHAR(255) DEFAULT NULL,
`jobtype` BIGINT(20) DEFAULT NULL,
PRIMARY KEY (`oid`),
KEY `FK11F9D5D27BCB9` (`jobtype`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1


How can I config the hibernate to create the job table with foreign key constraint references the oid of another table?