Subversion Repositories Applications.gtt

Rev

Rev 81 | Rev 95 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
81 jpm 1 
<?xml version="1.0" standalone="yes" ?>
2 
<DBMODEL Version="4.0">
3 
<SETTINGS>
84 jpm 4 
<GLOBALSETTINGS ModelName="model_reverse_engineered" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="0" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="Gestion v4" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="0" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Nimbus Sans L" CanvasWidth="4096" CanvasHeight="2842" />
81 jpm 5 
<DATATYPEGROUPS>
6 
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
7 
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
8 
<DATATYPEGROUP Name="String Types" Icon="3" />
9 
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
10 
<DATATYPEGROUP Name="User defined Types" Icon="5" />
11 
<DATATYPEGROUP Name="Geographic Types" Icon="6" />
12 
</DATATYPEGROUPS>
13 
<DATATYPES>
14 
<DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
15 
<PARAMS>
16 
<PARAM Name="length" />
17 
</PARAMS>
18 
<OPTIONS>
19 
<OPTION Name="UNSIGNED" Default="1" />
20 
<OPTION Name="ZEROFILL" Default="0" />
21 
</OPTIONS>
22 
</DATATYPE>
23 
<DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
24 
<PARAMS>
25 
<PARAM Name="length" />
26 
</PARAMS>
27 
<OPTIONS>
28 
<OPTION Name="UNSIGNED" Default="1" />
29 
<OPTION Name="ZEROFILL" Default="0" />
30 
</OPTIONS>
31 
</DATATYPE>
32 
<DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
33 
<PARAMS>
34 
<PARAM Name="length" />
35 
</PARAMS>
36 
<OPTIONS>
37 
<OPTION Name="UNSIGNED" Default="1" />
38 
<OPTION Name="ZEROFILL" Default="0" />
39 
</OPTIONS>
40 
</DATATYPE>
41 
<DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
42 
<PARAMS>
43 
<PARAM Name="length" />
44 
</PARAMS>
45 
<OPTIONS>
46 
<OPTION Name="UNSIGNED" Default="0" />
47 
<OPTION Name="ZEROFILL" Default="0" />
48 
</OPTIONS>
49 
</DATATYPE>
50 
<DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
51 
<PARAMS>
52 
<PARAM Name="length" />
53 
</PARAMS>
54 
<OPTIONS>
55 
<OPTION Name="UNSIGNED" Default="1" />
56 
<OPTION Name="ZEROFILL" Default="0" />
57 
</OPTIONS>
58 
</DATATYPE>
59 
<DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
60 
<PARAMS>
61 
<PARAM Name="length" />
62 
</PARAMS>
63 
<OPTIONS>
64 
<OPTION Name="UNSIGNED" Default="0" />
65 
<OPTION Name="ZEROFILL" Default="0" />
66 
</OPTIONS>
67 
</DATATYPE>
68 
<DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
69 
<PARAMS>
70 
<PARAM Name="precision" />
71 
</PARAMS>
72 
<OPTIONS>
73 
<OPTION Name="ZEROFILL" Default="0" />
74 
</OPTIONS>
75 
</DATATYPE>
76 
<DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
77 
<PARAMS>
78 
<PARAM Name="length" />
79 
<PARAM Name="decimals" />
80 
</PARAMS>
81 
<OPTIONS>
82 
<OPTION Name="ZEROFILL" Default="0" />
83 
</OPTIONS>
84 
</DATATYPE>
85 
<DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
86 
<PARAMS>
87 
<PARAM Name="length" />
88 
<PARAM Name="decimals" />
89 
</PARAMS>
90 
<OPTIONS>
91 
<OPTION Name="ZEROFILL" Default="0" />
92 
</OPTIONS>
93 
</DATATYPE>
94 
<DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
95 
<PARAMS>
96 
<PARAM Name="length" />
97 
<PARAM Name="decimals" />
98 
</PARAMS>
99 
<OPTIONS>
100 
<OPTION Name="ZEROFILL" Default="0" />
101 
</OPTIONS>
102 
</DATATYPE>
103 
<DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
104 
<PARAMS>
105 
<PARAM Name="length" />
106 
<PARAM Name="decimals" />
107 
</PARAMS>
108 
<OPTIONS>
109 
<OPTION Name="ZEROFILL" Default="0" />
110 
</OPTIONS>
111 
</DATATYPE>
112 
<DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
113 
<PARAMS>
114 
<PARAM Name="length" />
115 
<PARAM Name="decimals" />
116 
</PARAMS>
117 
<OPTIONS>
118 
<OPTION Name="ZEROFILL" Default="0" />
119 
</OPTIONS>
120 
</DATATYPE>
121 
<DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
122 
<PARAMS>
123 
<PARAM Name="length" />
124 
<PARAM Name="decimals" />
125 
</PARAMS>
126 
<OPTIONS>
127 
<OPTION Name="ZEROFILL" Default="0" />
128 
</OPTIONS>
129 
</DATATYPE>
130 
<DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
131 
</DATATYPE>
132 
<DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
133 
</DATATYPE>
134 
<DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
135 
<PARAMS>
136 
<PARAM Name="length" />
137 
</PARAMS>
138 
</DATATYPE>
139 
<DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
140 
</DATATYPE>
141 
<DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
142 
<PARAMS>
143 
<PARAM Name="length" />
144 
</PARAMS>
145 
</DATATYPE>
146 
<DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
147 
<PARAMS>
148 
<PARAM Name="length" />
149 
</PARAMS>
150 
<OPTIONS>
151 
<OPTION Name="BINARY" Default="0" />
152 
</OPTIONS>
153 
</DATATYPE>
154 
<DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
155 
<PARAMS>
156 
<PARAM Name="length" />
157 
</PARAMS>
158 
<OPTIONS>
159 
<OPTION Name="BINARY" Default="0" />
160 
</OPTIONS>
161 
</DATATYPE>
162 
<DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
163 
</DATATYPE>
164 
<DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
165 
</DATATYPE>
166 
<DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
167 
</DATATYPE>
168 
<DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
169 
</DATATYPE>
170 
<DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
171 
</DATATYPE>
172 
<DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
173 
</DATATYPE>
174 
<DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
175 
</DATATYPE>
176 
<DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
177 
</DATATYPE>
178 
<DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
179 
</DATATYPE>
180 
<DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
181 
</DATATYPE>
182 
<DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
183 
<PARAMS>
184 
<PARAM Name="values" />
185 
</PARAMS>
186 
</DATATYPE>
187 
<DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
188 
<PARAMS>
189 
<PARAM Name="values" />
190 
</PARAMS>
191 
</DATATYPE>
192 
<DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
193 
<OPTIONS>
194 
<OPTION Name="BINARY" Default="0" />
195 
</OPTIONS>
196 
</DATATYPE>
197 
<DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
198 
<OPTIONS>
199 
<OPTION Name="BINARY" Default="0" />
200 
</OPTIONS>
201 
</DATATYPE>
202 
<DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
203 
<OPTIONS>
204 
<OPTION Name="BINARY" Default="0" />
205 
</OPTIONS>
206 
</DATATYPE>
207 
<DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
208 
</DATATYPE>
209 
<DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
210 
</DATATYPE>
211 
<DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
212 
</DATATYPE>
213 
<DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
214 
</DATATYPE>
215 
<DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
216 
</DATATYPE>
217 
<DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
218 
</DATATYPE>
219 
<DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
220 
</DATATYPE>
221 
</DATATYPES>
222 
<COMMON_DATATYPES>
223 
<COMMON_DATATYPE ID="5" />
224 
<COMMON_DATATYPE ID="8" />
225 
<COMMON_DATATYPE ID="20" />
226 
<COMMON_DATATYPE ID="15" />
227 
<COMMON_DATATYPE ID="22" />
228 
<COMMON_DATATYPE ID="28" />
229 
<COMMON_DATATYPE ID="26" />
230 
<COMMON_DATATYPE ID="33" />
231 
<COMMON_DATATYPE ID="34" />
232 
<COMMON_DATATYPE ID="35" />
233 
</COMMON_DATATYPES>
234 
<TABLEPREFIXES>
235 
<TABLEPREFIX Name="Default (no prefix)" />
236 
</TABLEPREFIXES>
237 
<REGIONCOLORS>
238 
<REGIONCOLOR Color="Red=#FFEEEC" />
239 
<REGIONCOLOR Color="Yellow=#FEFDED" />
240 
<REGIONCOLOR Color="Green=#EAFFE5" />
241 
<REGIONCOLOR Color="Cyan=#ECFDFF" />
242 
<REGIONCOLOR Color="Blue=#F0F1FE" />
243 
<REGIONCOLOR Color="Magenta=#FFEBFA" />
244 
</REGIONCOLORS>
245 
<POSITIONMARKERS>
246 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
247 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
248 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
249 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
250 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
251 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
252 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
253 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
254 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
255 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
256 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
257 
</POSITIONMARKERS>
258 
</SETTINGS>
259 
<METADATA>
260 
<REGIONS>
261 
</REGIONS>
262 
<TABLES>
84 jpm 263 
<TABLE ID="1394" Tablename="gestion_absence" PrevTableName="" XPos="386" YPos="643" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
10 jpm 264 
<COLUMNS>
31 jpm 265 
<COLUMN ID="1761" ColName="ga_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
10 jpm 266 
<OPTIONSELECTED>
267 
<OPTIONSELECT Value="1" />
268 
<OPTIONSELECT Value="0" />
269 
</OPTIONSELECTED>
270 
</COLUMN>
31 jpm 271 
<COLUMN ID="1762" ColName="ga_id_absence_motif" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
10 jpm 272 
<OPTIONSELECTED>
273 
<OPTIONSELECT Value="1" />
274 
<OPTIONSELECT Value="0" />
275 
</OPTIONSELECTED>
276 
</COLUMN>
31 jpm 277 
<COLUMN ID="1411" ColName="ga_id_date_absence" PrevColName="" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
10 jpm 278 
<OPTIONSELECTED>
279 
</OPTIONSELECTED>
280 
</COLUMN>
31 jpm 281 
<COLUMN ID="1413" ColName="ga_duree" PrevColName="" Pos="5" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
10 jpm 282 
<OPTIONSELECTED>
31 jpm 283 
<OPTIONSELECT Value="0" />
10 jpm 284 
</OPTIONSELECTED>
285 
</COLUMN>
286 
</COLUMNS>
287 
<RELATIONS_END>
288 
<RELATION_END ID="1583" />
289 
<RELATION_END ID="1585" />
290 
</RELATIONS_END>
291 
<INDICES>
292 
<INDEX ID="1414" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
293 
<INDEXCOLUMNS>
31 jpm 294 
<INDEXCOLUMN idColumn="1761" LengthParam="0" />
295 
<INDEXCOLUMN idColumn="1762" LengthParam="0" />
296 
<INDEXCOLUMN idColumn="1411" LengthParam="0" />
10 jpm 297 
</INDEXCOLUMNS>
298 
</INDEX>
299 
</INDICES>
300 
</TABLE>
84 jpm 301 
<TABLE ID="1395" Tablename="gestion_projet_categorie" PrevTableName="gestion_categorie" XPos="43" YPos="71" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >
10 jpm 302 
<COLUMNS>
31 jpm 303 
<COLUMN ID="1415" ColName="gpc_id_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 304 
<OPTIONSELECTED>
305 
<OPTIONSELECT Value="1" />
306 
<OPTIONSELECT Value="0" />
307 
</OPTIONSELECTED>
308 
</COLUMN>
31 jpm 309 
<COLUMN ID="1416" ColName="gpc_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 310 
<OPTIONSELECTED>
311 
<OPTIONSELECT Value="0" />
312 
</OPTIONSELECTED>
313 
</COLUMN>
314 
</COLUMNS>
315 
<RELATIONS_START>
316 
<RELATION_START ID="1564" />
317 
</RELATIONS_START>
318 
<INDICES>
319 
<INDEX ID="1417" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
320 
<INDEXCOLUMNS>
321 
<INDEXCOLUMN idColumn="1415" LengthParam="0" />
322 
</INDEXCOLUMNS>
323 
</INDEX>
324 
</INDICES>
325 
</TABLE>
326 
<TABLE ID="1396" Tablename="gestion_frais_km" PrevTableName="gestion_composer_utilisateur_frais_kilometrique" XPos="1027" YPos="349" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4" >
327 
<COLUMNS>
328 
<COLUMN ID="1605" ColName="gfk_id_frais_km" PrevColName="gcufk_id_frais_km" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
329 
<OPTIONSELECTED>
330 
<OPTIONSELECT Value="1" />
331 
<OPTIONSELECT Value="0" />
332 
</OPTIONSELECTED>
333 
</COLUMN>
334 
<COLUMN ID="1737" ColName="gfkt_id_frais_km_taux" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
335 
<OPTIONSELECTED>
336 
<OPTIONSELECT Value="1" />
337 
<OPTIONSELECT Value="0" />
338 
</OPTIONSELECTED>
339 
</COLUMN>
340 
<COLUMN ID="1639" ColName="gfk_ce_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
341 
<OPTIONSELECTED>
342 
<OPTIONSELECT Value="1" />
343 
<OPTIONSELECT Value="0" />
344 
</OPTIONSELECTED>
345 
</COLUMN>
346 
<COLUMN ID="1420" ColName="gfk_date" PrevColName="gcufk_date_frais" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
347 
<OPTIONSELECTED>
348 
</OPTIONSELECTED>
349 
</COLUMN>
350 
<COLUMN ID="1421" ColName="gfk_nbre_km" PrevColName="gcufk_nb_kilometre" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
351 
<OPTIONSELECTED>
352 
<OPTIONSELECT Value="0" />
353 
</OPTIONSELECTED>
354 
</COLUMN>
355 
<COLUMN ID="1422" ColName="gfk_objet" PrevColName="gcufk_objet" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
356 
<OPTIONSELECTED>
357 
<OPTIONSELECT Value="0" />
358 
</OPTIONSELECTED>
359 
</COLUMN>
360 
<COLUMN ID="1423" ColName="gfk_trajet" PrevColName="gcufk_trajet" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
361 
<OPTIONSELECTED>
362 
<OPTIONSELECT Value="0" />
363 
</OPTIONSELECTED>
364 
</COLUMN>
365 
<COLUMN ID="1424" ColName="gfk_montant_total" PrevColName="gcufk_montant_total" Pos="7" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
366 
<OPTIONSELECTED>
367 
<OPTIONSELECT Value="0" />
368 
</OPTIONSELECTED>
369 
</COLUMN>
370 
</COLUMNS>
371 
<RELATIONS_END>
372 
<RELATION_END ID="1503" />
373 
<RELATION_END ID="1505" />
374 
</RELATIONS_END>
375 
<INDICES>
376 
<INDEX ID="1425" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
377 
<INDEXCOLUMNS>
378 
<INDEXCOLUMN idColumn="1605" LengthParam="0" />
379 
</INDEXCOLUMNS>
380 
</INDEX>
381 
</INDICES>
382 
</TABLE>
383 
<TABLE ID="1397" Tablename="gestion_note_frais_ligne" PrevTableName="gestion_depense" XPos="1025" YPos="651" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" >
384 
<COLUMNS>
385 
<COLUMN ID="1617" ColName="gnfl_id_note_frais_ligne" PrevColName="gld_id_ligne_depense" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
386 
<OPTIONSELECTED>
387 
<OPTIONSELECT Value="1" />
388 
<OPTIONSELECT Value="0" />
389 
</OPTIONSELECTED>
390 
</COLUMN>
391 
<COLUMN ID="1634" ColName="gnfl_ce_note_frais" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
392 
<OPTIONSELECTED>
393 
<OPTIONSELECT Value="1" />
394 
<OPTIONSELECT Value="0" />
395 
</OPTIONSELECTED>
396 
</COLUMN>
397 
<COLUMN ID="1428" ColName="gnfl_date" PrevColName="gd_date_depense" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
398 
<OPTIONSELECTED>
399 
</OPTIONSELECTED>
400 
</COLUMN>
401 
<COLUMN ID="1429" ColName="gnfl_montant_ht" PrevColName="gd_montant_ht" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
402 
<OPTIONSELECTED>
403 
<OPTIONSELECT Value="0" />
404 
</OPTIONSELECTED>
405 
</COLUMN>
406 
<COLUMN ID="1620" ColName="gnfl_taux_tva" PrevColName="gld_taux_tva" Pos="5" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
407 
<OPTIONSELECTED>
408 
<OPTIONSELECT Value="0" />
409 
</OPTIONSELECTED>
410 
</COLUMN>
411 
<COLUMN ID="1430" ColName="gnfl_montant_ttc" PrevColName="gd_montant_ttc" Pos="5" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
412 
<OPTIONSELECTED>
413 
<OPTIONSELECT Value="0" />
414 
</OPTIONSELECTED>
415 
</COLUMN>
416 
</COLUMNS>
417 
<RELATIONS_END>
418 
<RELATION_END ID="1500" />
419 
</RELATIONS_END>
420 
<INDICES>
421 
<INDEX ID="1431" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
422 
<INDEXCOLUMNS>
423 
<INDEXCOLUMN idColumn="1617" LengthParam="0" />
424 
</INDEXCOLUMNS>
425 
</INDEX>
426 
</INDICES>
427 
</TABLE>
428 
<TABLE ID="1398" Tablename="gestion_frais_km_taux" PrevTableName="gestion_frais_kilometrique" XPos="1027" YPos="245" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="6" >
429 
<COLUMNS>
31 jpm 430 
<COLUMN ID="1432" ColName="gfkt_id_frais_km_taux" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 431 
<OPTIONSELECTED>
432 
<OPTIONSELECT Value="1" />
433 
<OPTIONSELECT Value="0" />
434 
</OPTIONSELECTED>
435 
</COLUMN>
31 jpm 436 
<COLUMN ID="1433" ColName="gfkt_taux" PrevColName="" Pos="2" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 437 
<OPTIONSELECTED>
438 
<OPTIONSELECT Value="0" />
439 
</OPTIONSELECTED>
440 
</COLUMN>
441 
</COLUMNS>
442 
<RELATIONS_START>
443 
<RELATION_START ID="1505" />
444 
</RELATIONS_START>
445 
<INDICES>
446 
<INDEX ID="1434" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
447 
<INDEXCOLUMNS>
448 
<INDEXCOLUMN idColumn="1432" LengthParam="0" />
449 
</INDEXCOLUMNS>
450 
</INDEX>
451 
</INDICES>
452 
</TABLE>
84 jpm 453 
<TABLE ID="1399" Tablename="gestion_absence_motif" PrevTableName="gestion_motif_absence" XPos="44" YPos="521" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="7" >
10 jpm 454 
<COLUMNS>
31 jpm 455 
<COLUMN ID="1435" ColName="gam_id_absence_motif" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 456 
<OPTIONSELECTED>
457 
<OPTIONSELECT Value="1" />
458 
<OPTIONSELECT Value="0" />
459 
</OPTIONSELECTED>
460 
</COLUMN>
84 jpm 461 
<COLUMN ID="1436" ColName="gam_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Libell\195\169 du motif d\aabscence.">
10 jpm 462 
<OPTIONSELECTED>
463 
<OPTIONSELECT Value="0" />
464 
</OPTIONSELECTED>
465 
</COLUMN>
84 jpm 466 
<COLUMN ID="1770" ColName="gam_cp_diminuer" PrevColName="" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif diminue le nombre d\aheur de cong\195\169s pay\195\169s.">
467 
<OPTIONSELECTED>
468 
</OPTIONSELECTED>
469 
</COLUMN>
470 
<COLUMN ID="1771" ColName="gam_hs_augmenter" PrevColName="" Pos="3" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif augmente quand m\195\170me le nombre d\aheures supl\195\169mentaires.">
471 
<OPTIONSELECTED>
472 
</OPTIONSELECTED>
473 
</COLUMN>
474 
<COLUMN ID="1772" ColName="gam_hs_diminuer" PrevColName="" Pos="4" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif diminue le nombre d\aheures supl\195\169mentaires.">
475 
<OPTIONSELECTED>
476 
</OPTIONSELECTED>
477 
</COLUMN>
10 jpm 478 
</COLUMNS>
479 
<RELATIONS_START>
480 
<RELATION_START ID="1583" />
481 
</RELATIONS_START>
482 
<INDICES>
483 
<INDEX ID="1438" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
484 
<INDEXCOLUMNS>
485 
<INDEXCOLUMN idColumn="1435" LengthParam="0" />
486 
</INDEXCOLUMNS>
487 
</INDEX>
488 
</INDICES>
489 
</TABLE>
84 jpm 490 
<TABLE ID="1402" Tablename="gestion_utilisateur_a_projet" PrevTableName="gestion_preferences" XPos="384" YPos="357" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="10" >
10 jpm 491 
<COLUMNS>
492 
<COLUMN ID="1631" ColName="guap_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
493 
<OPTIONSELECTED>
494 
<OPTIONSELECT Value="1" />
495 
<OPTIONSELECT Value="0" />
496 
</OPTIONSELECTED>
497 
</COLUMN>
498 
<COLUMN ID="1632" ColName="guap_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
499 
<OPTIONSELECTED>
500 
<OPTIONSELECT Value="1" />
501 
<OPTIONSELECT Value="0" />
502 
</OPTIONSELECTED>
503 
</COLUMN>
504 
</COLUMNS>
505 
<RELATIONS_END>
506 
<RELATION_END ID="1494" />
507 
<RELATION_END ID="1498" />
508 
</RELATIONS_END>
509 
<INDICES>
510 
<INDEX ID="1447" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
511 
<INDEXCOLUMNS>
512 
<INDEXCOLUMN idColumn="1631" LengthParam="0" />
513 
<INDEXCOLUMN idColumn="1632" LengthParam="0" />
514 
</INDEXCOLUMNS>
515 
</INDEX>
516 
</INDICES>
517 
</TABLE>
518 
<TABLE ID="1404" Tablename="gestion_projet" PrevTableName="" XPos="44" YPos="195" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="12" >
519 
<COLUMNS>
81 jpm 520 
<COLUMN ID="1522" ColName="gp_id_projet" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du projet.">
10 jpm 521 
<OPTIONSELECTED>
522 
<OPTIONSELECT Value="1" />
523 
<OPTIONSELECT Value="0" />
524 
</OPTIONSELECTED>
525 
</COLUMN>
84 jpm 526 
<COLUMN ID="1766" ColName="gp_ce_projet_parent" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
527 
<OPTIONSELECTED>
528 
<OPTIONSELECT Value="1" />
529 
<OPTIONSELECT Value="0" />
530 
</OPTIONSELECTED>
531 
</COLUMN>
81 jpm 532 
<COLUMN ID="1629" ColName="gp_ce_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la cat\195\169gorie du projet.">
10 jpm 533 
<OPTIONSELECTED>
534 
<OPTIONSELECT Value="1" />
535 
<OPTIONSELECT Value="0" />
536 
</OPTIONSELECTED>
537 
</COLUMN>
84 jpm 538 
<COLUMN ID="1455" ColName="gp_nom" PrevColName="gp_nom_projet" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du projet.">
10 jpm 539 
<OPTIONSELECTED>
540 
<OPTIONSELECT Value="0" />
541 
</OPTIONSELECTED>
542 
</COLUMN>
81 jpm 543 
<COLUMN ID="1456" ColName="gp_description" PrevColName="" Pos="4" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description d\195\169taill\195\169e du projet.">
10 jpm 544 
<OPTIONSELECTED>
545 
</OPTIONSELECTED>
546 
</COLUMN>
84 jpm 547 
<COLUMN ID="1457" ColName="gp_date_debut" PrevColName="" Pos="5" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de d\195\169but du projet">
10 jpm 548 
<OPTIONSELECTED>
549 
</OPTIONSELECTED>
550 
</COLUMN>
84 jpm 551 
<COLUMN ID="1768" ColName="gp_date_fin" PrevColName="" Pos="8" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de fin du projet estim\195\169e.">
10 jpm 552 
<OPTIONSELECTED>
84 jpm 553 
</OPTIONSELECTED>
554 
</COLUMN>
555 
<COLUMN ID="1458" ColName="gp_duree_prevue" PrevColName="" Pos="6" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Dur\195\169e pr\195\169vue du projet en jour.">
556 
<OPTIONSELECTED>
10 jpm 557 
<OPTIONSELECT Value="0" />
558 
</OPTIONSELECTED>
559 
</COLUMN>
84 jpm 560 
<COLUMN ID="1459" ColName="gp_avancement" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Pourcentage d\aavancement du projet.">
10 jpm 561 
<OPTIONSELECTED>
562 
<OPTIONSELECT Value="0" />
563 
<OPTIONSELECT Value="0" />
564 
</OPTIONSELECTED>
565 
</COLUMN>
566 
</COLUMNS>
567 
<RELATIONS_START>
568 
<RELATION_START ID="1498" />
569 
<RELATION_START ID="1511" />
84 jpm 570 
<RELATION_START ID="1764" />
10 jpm 571 
</RELATIONS_START>
572 
<RELATIONS_END>
573 
<RELATION_END ID="1564" />
84 jpm 574 
<RELATION_END ID="1764" />
10 jpm 575 
</RELATIONS_END>
576 
<INDICES>
577 
<INDEX ID="1625" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
578 
<INDEXCOLUMNS>
579 
<INDEXCOLUMN idColumn="1522" LengthParam="0" />
580 
</INDEXCOLUMNS>
581 
</INDEX>
582 
</INDICES>
583 
</TABLE>
84 jpm 584 
<TABLE ID="1405" Tablename="gestion_utilisateur_statut" PrevTableName="gestion_statut" XPos="673" YPos="234" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="13" >
10 jpm 585 
<COLUMNS>
31 jpm 586 
<COLUMN ID="1461" ColName="gus_id_utilisateur_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 587 
<OPTIONSELECTED>
588 
<OPTIONSELECT Value="1" />
589 
<OPTIONSELECT Value="0" />
590 
</OPTIONSELECTED>
591 
</COLUMN>
31 jpm 592 
<COLUMN ID="1462" ColName="gus_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 593 
<OPTIONSELECTED>
594 
<OPTIONSELECT Value="0" />
595 
</OPTIONSELECTED>
596 
</COLUMN>
84 jpm 597 
<COLUMN ID="1776" ColName="gus_mark_recapitulatif" PrevColName="" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="Indique si ce type d\autilisateur doit appara\195\174tre dans le r\195\169capitulatif ou pas.">
598 
<OPTIONSELECTED>
599 
</OPTIONSELECTED>
600 
</COLUMN>
10 jpm 601 
</COLUMNS>
602 
<RELATIONS_START>
603 
<RELATION_START ID="1592" />
604 
</RELATIONS_START>
605 
<INDICES>
606 
<INDEX ID="1463" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
607 
<INDEXCOLUMNS>
608 
<INDEXCOLUMN idColumn="1461" LengthParam="0" />
609 
</INDEXCOLUMNS>
610 
</INDEX>
611 
</INDICES>
612 
</TABLE>
84 jpm 613 
<TABLE ID="1407" Tablename="gestion_travail_projet" PrevTableName="gestion_travail" XPos="394" YPos="473" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" >
10 jpm 614 
<COLUMNS>
615 
<COLUMN ID="1742" ColName="gtp_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
616 
<OPTIONSELECTED>
617 
<OPTIONSELECT Value="1" />
618 
<OPTIONSELECT Value="0" />
619 
</OPTIONSELECTED>
620 
</COLUMN>
621 
<COLUMN ID="1743" ColName="gtp_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
622 
<OPTIONSELECTED>
623 
<OPTIONSELECT Value="1" />
624 
<OPTIONSELECT Value="0" />
625 
</OPTIONSELECTED>
626 
</COLUMN>
31 jpm 627 
<COLUMN ID="1474" ColName="gtp_id_date_travail" PrevColName="" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
10 jpm 628 
<OPTIONSELECTED>
629 
</OPTIONSELECTED>
630 
</COLUMN>
31 jpm 631 
<COLUMN ID="1475" ColName="gtp_duree" PrevColName="" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
10 jpm 632 
<OPTIONSELECTED>
633 
<OPTIONSELECT Value="0" />
634 
</OPTIONSELECTED>
635 
</COLUMN>
636 
</COLUMNS>
637 
<RELATIONS_END>
638 
<RELATION_END ID="1510" />
639 
<RELATION_END ID="1511" />
640 
</RELATIONS_END>
641 
<INDICES>
642 
<INDEX ID="1476" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
643 
<INDEXCOLUMNS>
644 
<INDEXCOLUMN idColumn="1742" LengthParam="0" />
645 
<INDEXCOLUMN idColumn="1743" LengthParam="0" />
646 
<INDEXCOLUMN idColumn="1474" LengthParam="0" />
647 
</INDEXCOLUMNS>
648 
</INDEX>
649 
</INDICES>
650 
</TABLE>
651 
<TABLE ID="1408" Tablename="gestion_utilisateur" PrevTableName="" XPos="686" YPos="365" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" >
652 
<COLUMNS>
653 
<COLUMN ID="1477" ColName="gu_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
654 
<OPTIONSELECTED>
655 
<OPTIONSELECT Value="1" />
656 
<OPTIONSELECT Value="0" />
657 
</OPTIONSELECTED>
658 
</COLUMN>
41 jpm 659 
<COLUMN ID="1763" ColName="gu_ce_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
10 jpm 660 
<OPTIONSELECTED>
661 
<OPTIONSELECT Value="1" />
662 
<OPTIONSELECT Value="0" />
663 
</OPTIONSELECTED>
664 
</COLUMN>
665 
<COLUMN ID="1479" ColName="gu_nom" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
666 
<OPTIONSELECTED>
667 
<OPTIONSELECT Value="0" />
668 
</OPTIONSELECTED>
669 
</COLUMN>
670 
<COLUMN ID="1480" ColName="gu_prenom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
671 
<OPTIONSELECTED>
672 
<OPTIONSELECT Value="0" />
673 
</OPTIONSELECTED>
674 
</COLUMN>
675 
<COLUMN ID="1481" ColName="gu_password" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
676 
<OPTIONSELECTED>
677 
<OPTIONSELECT Value="0" />
678 
</OPTIONSELECTED>
679 
</COLUMN>
680 
<COLUMN ID="1482" ColName="gu_email" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
681 
<OPTIONSELECTED>
682 
<OPTIONSELECT Value="0" />
683 
</OPTIONSELECTED>
684 
</COLUMN>
685 
<COLUMN ID="1483" ColName="gu_telephone" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
686 
<OPTIONSELECTED>
687 
<OPTIONSELECT Value="1" />
688 
<OPTIONSELECT Value="0" />
689 
</OPTIONSELECTED>
690 
</COLUMN>
691 
<COLUMN ID="1484" ColName="gu_adresse" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
692 
<OPTIONSELECTED>
693 
<OPTIONSELECT Value="0" />
694 
</OPTIONSELECTED>
695 
</COLUMN>
696 
<COLUMN ID="1485" ColName="gu_code_postal" PrevColName="" Pos="9" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
697 
<OPTIONSELECTED>
698 
<OPTIONSELECT Value="1" />
699 
<OPTIONSELECT Value="0" />
700 
</OPTIONSELECTED>
701 
</COLUMN>
702 
<COLUMN ID="1486" ColName="gu_ville" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(50)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
703 
<OPTIONSELECTED>
704 
<OPTIONSELECT Value="0" />
705 
</OPTIONSELECTED>
706 
</COLUMN>
707 
<COLUMN ID="1487" ColName="gu_quota_heures_supp" PrevColName="" Pos="11" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
708 
<OPTIONSELECTED>
709 
<OPTIONSELECT Value="0" />
710 
</OPTIONSELECTED>
711 
</COLUMN>
712 
<COLUMN ID="1488" ColName="gu_conges_payes" PrevColName="" Pos="12" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
713 
<OPTIONSELECTED>
714 
<OPTIONSELECT Value="0" />
715 
</OPTIONSELECTED>
716 
</COLUMN>
717 
<COLUMN ID="1489" ColName="gu_temps_de_travail" PrevColName="" Pos="13" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
718 
<OPTIONSELECTED>
719 
<OPTIONSELECT Value="0" />
720 
</OPTIONSELECTED>
721 
</COLUMN>
31 jpm 722 
<COLUMN ID="1490" ColName="gu_mark_admin" PrevColName="" Pos="14" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 723 
<OPTIONSELECTED>
724 
</OPTIONSELECTED>
725 
</COLUMN>
31 jpm 726 
<COLUMN ID="1491" ColName="gu_mark_recapitulatif" PrevColName="" Pos="15" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 727 
<OPTIONSELECTED>
728 
</OPTIONSELECTED>
729 
</COLUMN>
730 
<COLUMN ID="1492" ColName="gu_notes" PrevColName="" Pos="16" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
731 
<OPTIONSELECTED>
732 
</OPTIONSELECTED>
733 
</COLUMN>
734 
</COLUMNS>
735 
<RELATIONS_START>
736 
<RELATION_START ID="1494" />
737 
<RELATION_START ID="1503" />
738 
<RELATION_START ID="1510" />
739 
<RELATION_START ID="1585" />
740 
<RELATION_START ID="1612" />
741 
</RELATIONS_START>
742 
<RELATIONS_END>
743 
<RELATION_END ID="1592" />
744 
</RELATIONS_END>
745 
<INDICES>
746 
<INDEX ID="1493" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
747 
<INDEXCOLUMNS>
748 
<INDEXCOLUMN idColumn="1477" LengthParam="0" />
749 
</INDEXCOLUMNS>
750 
</INDEX>
751 
</INDICES>
752 
</TABLE>
753 
<TABLE ID="1400" Tablename="gestion_note_frais" PrevTableName="" XPos="1030" YPos="525" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
754 
<COLUMNS>
31 jpm 755 
<COLUMN ID="1439" ColName="gnf_id_note_frais" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 756 
<OPTIONSELECTED>
757 
<OPTIONSELECT Value="1" />
758 
<OPTIONSELECT Value="0" />
759 
</OPTIONSELECTED>
760 
</COLUMN>
761 
<COLUMN ID="1614" ColName="gnf_ce_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
762 
<OPTIONSELECTED>
763 
<OPTIONSELECT Value="1" />
764 
<OPTIONSELECT Value="0" />
765 
</OPTIONSELECTED>
766 
</COLUMN>
31 jpm 767 
<COLUMN ID="1440" ColName="gnf_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
10 jpm 768 
<OPTIONSELECTED>
769 
<OPTIONSELECT Value="0" />
770 
</OPTIONSELECTED>
771 
</COLUMN>
772 
</COLUMNS>
773 
<RELATIONS_START>
774 
<RELATION_START ID="1500" />
775 
</RELATIONS_START>
776 
<RELATIONS_END>
777 
<RELATION_END ID="1612" />
778 
</RELATIONS_END>
779 
<INDICES>
780 
<INDEX ID="1441" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
781 
<INDEXCOLUMNS>
782 
<INDEXCOLUMN idColumn="1439" LengthParam="0" />
783 
</INDEXCOLUMNS>
784 
</INDEX>
785 
</INDICES>
786 
</TABLE>
81 jpm 787 
</TABLES>
788 
<RELATIONS>
10 jpm 789 
<RELATION ID="1494" RelationName="fk_gu_guap" Kind="1" SrcTable="1408" DestTable="1402" FKFields="gu_id_utilisateur=guap_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="-13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="48" CaptionOffsetY="-33" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="17" />
790 
<RELATION ID="1498" RelationName="fk_gp_guap" Kind="1" SrcTable="1404" DestTable="1402" FKFields="gp_id_projet=guap_id_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="19" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-53" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="18" />
791 
<RELATION ID="1503" RelationName="fk_gu_gfk" Kind="2" SrcTable="1408" DestTable="1396" FKFields="gu_id_utilisateur=gfk_ce_utilisateur\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" />
792 
<RELATION ID="1505" RelationName="fk_gfkt_gfk" Kind="2" SrcTable="1398" DestTable="1396" FKFields="gfkt_id_frais_km_taux=gfkt_id_frais_km_taux\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-59" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="23" />
793 
<RELATION ID="1510" RelationName="fk_gu_gtp" Kind="1" SrcTable="1408" DestTable="1407" FKFields="gu_id_utilisateur=gtp_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-1" CaptionOffsetY="-46" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" />
794 
<RELATION ID="1511" RelationName="fk_gp_gtp" Kind="1" SrcTable="1404" DestTable="1407" FKFields="gp_id_projet=gtp_id_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="-12" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="48" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="27" />
795 
<RELATION ID="1564" RelationName="fk_gpc_gp" Kind="5" SrcTable="1395" DestTable="1404" FKFields="gpc_id_categorie=gp_ce_categorie\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
84 jpm 796 
<RELATION ID="1583" RelationName="fk_gam_ga" Kind="1" SrcTable="1399" DestTable="1394" FKFields="gam_id_absence_motif=ga_id_absence_motif\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />
797 
<RELATION ID="1585" RelationName="fk_gu_ga" Kind="1" SrcTable="1408" DestTable="1394" FKFields="gu_id_utilisateur=ga_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-45" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
41 jpm 798 
<RELATION ID="1592" RelationName="fk_gs_gu" Kind="2" SrcTable="1405" DestTable="1408" FKFields="gus_id_utilisateur_statut=gu_ce_statut\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-41" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
10 jpm 799 
<RELATION ID="1500" RelationName="fk_gnf_gnfl" Kind="5" SrcTable="1400" DestTable="1397" FKFields="gnf_id_note_frais=gnfl_ce_note_frais\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-48" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" />
800 
<RELATION ID="1612" RelationName="fk_gu_gnf" Kind="2" SrcTable="1408" DestTable="1400" FKFields="gu_id_utilisateur=gnf_ce_utilisateur\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
84 jpm 801 
<RELATION ID="1764" RelationName="fk_gp_gp_parent" Kind="2" SrcTable="1404" DestTable="1404" FKFields="gp_id_projet=gp_ce_projet_parent\n" FKFieldsComments="\n" relDirection="2" MidOffset="23" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-71" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" />
81 jpm 802 
</RELATIONS>
803 
<NOTES>
804 
</NOTES>
805 
<IMAGES>
806 
</IMAGES>
807 
</METADATA>
808 
<PLUGINDATA>
809 
<PLUGINDATARECORDS>
810 
</PLUGINDATARECORDS>
811 
</PLUGINDATA>
812 
<QUERYDATA>
813 
<QUERYRECORDS>
814 
</QUERYRECORDS>
815 
</QUERYDATA>
816 
<LINKEDMODELS>
817 
</LINKEDMODELS>
818 
</DBMODEL>