3j5KwYcP

1CREATE TABLE IF NOT EXISTS cars (
2  id    SERIAL PRIMARY KEY,
3  mark  VARCHAR(25) UNIQUE NOT NULL
4);
5
6CREATE TABLE IF NOT EXISTS engines (
7  id       SERIAL PRIMARY KEY,
8  name    VARCHAR(25) NOT NULL,
9  power    INTEGER     NOT NULL,
10  car_mark VARCHAR(25) NOT NULL,
11  FOREIGN KEY (car_mark) REFERENCES cars (mark)
12);
13	
14<class name="ru.javavision.model.Engine" table="engines">
15    <id name = "id" type = "int" column = "id">
16        <generator class="identity"/>
17    </id>
18    <property name="name" column="name"/>
19    <property name="power" column="power"/>
20
21    <!--Прикрепляем машины к к двигателю.-->
22    <set name="cars" table="cars" cascade="all" fetch="join">
23        <key column="mark" foreign-key="car_mark"/>
24        <one-to-many class="ru.javavision.model.Car" />
25    </set>
26</class>
27
28
29<class name="ru.javavision.model.Car" table="cars">
30    <id name="id" column="id">
31        <generator class="identity"/>
32    </id>
33    <property name="mark" column="mark"/>
34</class>