1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="com.XXX.mapping">
<class
name="Incidents"
table="Incidents"
>
<meta attribute="sync-DAO">false</meta>
<id
name="Id"
type="integer"
column="incident_id"
>
<generator class="increment"/>
</id>
<!-- foreign key : IncidentType -->
<many-to-one
name="IncidentTypeId"
class="IncidentsType"
column="incident_type_id"
/>
<!-- foreign key from User : assigned User -->
<many-to-one
name="AssignedUser"
class="User"
column="assigned_user"
/>
<!-- foreign key from User : creater User -->
<many-to-one
name="CreaterUser"
class="User"
column="creater_user"
/>
<property
name="Title"
column="title"
type="string"
not-null="true"
length="45"
/>
<!-- foreign key from IncidentLevel -->
<many-to-one
name="IncidentLevelId"
class="IncidentLevel"
column="incident_level_id"
/>
<property
name="StartDate"
column="start_date"
type="date"
not-null="true"
length="10"
/>
<property
name="EndDate"
column="end_date"
type="date"
not-null="false"
length="10"
/>
<!-- foreign key from IncidentState -->
<many-to-one
name="IncidentStateId"
column="incident_state_id"
class="IncidentState"
/>
<property
name="Description"
column="description"
type="string"
not-null="true"
/>
<property
name="Solution"
column="solution"
type="string"
not-null="false"
/>
</class>
</hibernate-mapping> |
