| Line 1... |
Line 1... |
| 1 |
<?xml version="1.0" standalone="yes" ?>
|
1 |
<?xml version="1.0" standalone="yes" ?>
|
| 2 |
<DBMODEL Version="4.0">
|
2 |
<DBMODEL Version="4.0">
|
| 3 |
<SETTINGS>
|
3 |
<SETTINGS>
|
| 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="24" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" 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" />
|
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="24" 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" />
|
| 5 |
<DATATYPEGROUPS>
|
5 |
<DATATYPEGROUPS>
|
| 6 |
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
|
6 |
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
|
| 7 |
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
|
7 |
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
|
| 8 |
<DATATYPEGROUP Name="String Types" Icon="3" />
|
8 |
<DATATYPEGROUP Name="String Types" Icon="3" />
|
| 9 |
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
|
9 |
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
|
| Line 260... |
Line 260... |
| 260 |
<REGIONS>
|
260 |
<REGIONS>
|
| 261 |
</REGIONS>
|
261 |
</REGIONS>
|
| 262 |
<TABLES>
|
262 |
<TABLES>
|
| 263 |
<TABLE ID="1394" Tablename="gestion_absence" PrevTableName="" XPos="693" YPos="727" 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" >
|
263 |
<TABLE ID="1394" Tablename="gestion_absence" PrevTableName="" XPos="693" YPos="727" 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" >
|
| 264 |
<COLUMNS>
|
264 |
<COLUMNS>
|
| 265 |
<COLUMN ID="1598" ColName="ga_id_abscence" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
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="">
|
| 266 |
<OPTIONSELECTED>
|
266 |
<OPTIONSELECTED>
|
| 267 |
<OPTIONSELECT Value="1" />
|
267 |
<OPTIONSELECT Value="1" />
|
| 268 |
<OPTIONSELECT Value="0" />
|
268 |
<OPTIONSELECT Value="0" />
|
| 269 |
</OPTIONSELECTED>
|
269 |
</OPTIONSELECTED>
|
| 270 |
</COLUMN>
|
270 |
</COLUMN>
|
| 271 |
<COLUMN ID="1731" ColName="ga_ce_absence_motif" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
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="">
|
| 272 |
<OPTIONSELECTED>
|
272 |
<OPTIONSELECTED>
|
| 273 |
<OPTIONSELECT Value="1" />
|
273 |
<OPTIONSELECT Value="1" />
|
| 274 |
<OPTIONSELECT Value="0" />
|
274 |
<OPTIONSELECT Value="0" />
|
| 275 |
</OPTIONSELECTED>
|
275 |
</OPTIONSELECTED>
|
| 276 |
</COLUMN>
|
276 |
</COLUMN>
|
| 277 |
<COLUMN ID="1588" ColName="ga_ce_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
- |
|
| 278 |
<OPTIONSELECTED>
|
- |
|
| 279 |
<OPTIONSELECT Value="1" />
|
- |
|
| 280 |
<OPTIONSELECT Value="0" />
|
- |
|
| 281 |
</OPTIONSELECTED>
|
- |
|
| 282 |
</COLUMN>
|
- |
|
| 283 |
<COLUMN ID="1411" ColName="ga_date_debut" PrevColName="" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
|
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="">
|
| 284 |
<OPTIONSELECTED>
|
278 |
<OPTIONSELECTED>
|
| 285 |
</OPTIONSELECTED>
|
279 |
</OPTIONSELECTED>
|
| 286 |
</COLUMN>
|
280 |
</COLUMN>
|
| 287 |
<COLUMN ID="1412" ColName="ga_date_fin" PrevColName="" Pos="4" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
|
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="">
|
| 288 |
<OPTIONSELECTED>
|
- |
|
| 289 |
</OPTIONSELECTED>
|
- |
|
| 290 |
</COLUMN>
|
- |
|
| 291 |
<COLUMN ID="1413" ColName="ga_date_envoi_lettre" PrevColName="" Pos="5" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
|
- |
|
| 292 |
<OPTIONSELECTED>
|
282 |
<OPTIONSELECTED>
|
| - |
|
283 |
<OPTIONSELECT Value="0" />
|
| 293 |
</OPTIONSELECTED>
|
284 |
</OPTIONSELECTED>
|
| 294 |
</COLUMN>
|
285 |
</COLUMN>
|
| 295 |
</COLUMNS>
|
286 |
</COLUMNS>
|
| 296 |
<RELATIONS_END>
|
287 |
<RELATIONS_END>
|
| 297 |
<RELATION_END ID="1583" />
|
288 |
<RELATION_END ID="1583" />
|
| 298 |
<RELATION_END ID="1585" />
|
289 |
<RELATION_END ID="1585" />
|
| 299 |
</RELATIONS_END>
|
290 |
</RELATIONS_END>
|
| 300 |
<INDICES>
|
291 |
<INDICES>
|
| 301 |
<INDEX ID="1414" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
292 |
<INDEX ID="1414" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
| 302 |
<INDEXCOLUMNS>
|
293 |
<INDEXCOLUMNS>
|
| - |
|
294 |
<INDEXCOLUMN idColumn="1761" LengthParam="0" />
|
| - |
|
295 |
<INDEXCOLUMN idColumn="1762" LengthParam="0" />
|
| 303 |
<INDEXCOLUMN idColumn="1598" LengthParam="0" />
|
296 |
<INDEXCOLUMN idColumn="1411" LengthParam="0" />
|
| 304 |
</INDEXCOLUMNS>
|
297 |
</INDEXCOLUMNS>
|
| 305 |
</INDEX>
|
298 |
</INDEX>
|
| 306 |
</INDICES>
|
299 |
</INDICES>
|
| 307 |
</TABLE>
|
300 |
</TABLE>
|
| 308 |
<TABLE ID="1395" Tablename="gestion_projet_categorie" PrevTableName="gestion_categorie" XPos="57" 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" >
|
301 |
<TABLE ID="1395" Tablename="gestion_projet_categorie" PrevTableName="gestion_categorie" XPos="57" 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" >
|
| 309 |
<COLUMNS>
|
302 |
<COLUMNS>
|
| 310 |
<COLUMN ID="1415" ColName="gpc_id_categorie" PrevColName="gc_id_categorie" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
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="">
|
| 311 |
<OPTIONSELECTED>
|
304 |
<OPTIONSELECTED>
|
| 312 |
<OPTIONSELECT Value="1" />
|
305 |
<OPTIONSELECT Value="1" />
|
| 313 |
<OPTIONSELECT Value="0" />
|
306 |
<OPTIONSELECT Value="0" />
|
| 314 |
</OPTIONSELECTED>
|
307 |
</OPTIONSELECTED>
|
| 315 |
</COLUMN>
|
308 |
</COLUMN>
|
| 316 |
<COLUMN ID="1416" ColName="gpc_libelle" PrevColName="gc_libelle_categorie" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
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="">
|
| 317 |
<OPTIONSELECTED>
|
310 |
<OPTIONSELECTED>
|
| 318 |
<OPTIONSELECT Value="0" />
|
311 |
<OPTIONSELECT Value="0" />
|
| 319 |
</OPTIONSELECTED>
|
312 |
</OPTIONSELECTED>
|
| 320 |
</COLUMN>
|
313 |
</COLUMN>
|
| 321 |
</COLUMNS>
|
314 |
</COLUMNS>
|
| Line 432... |
Line 425... |
| 432 |
</INDEX>
|
425 |
</INDEX>
|
| 433 |
</INDICES>
|
426 |
</INDICES>
|
| 434 |
</TABLE>
|
427 |
</TABLE>
|
| 435 |
<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" >
|
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" >
|
| 436 |
<COLUMNS>
|
429 |
<COLUMNS>
|
| 437 |
<COLUMN ID="1432" ColName="gfkt_id_frais_km_taux" PrevColName="gfk_id_frais_kilometrique" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
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="">
|
| 438 |
<OPTIONSELECTED>
|
431 |
<OPTIONSELECTED>
|
| 439 |
<OPTIONSELECT Value="1" />
|
432 |
<OPTIONSELECT Value="1" />
|
| 440 |
<OPTIONSELECT Value="0" />
|
433 |
<OPTIONSELECT Value="0" />
|
| 441 |
</OPTIONSELECTED>
|
434 |
</OPTIONSELECTED>
|
| 442 |
</COLUMN>
|
435 |
</COLUMN>
|
| 443 |
<COLUMN ID="1433" ColName="gfkt_taux" PrevColName="gfk_taux_kilometre" Pos="2" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
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="">
|
| 444 |
<OPTIONSELECTED>
|
437 |
<OPTIONSELECTED>
|
| 445 |
<OPTIONSELECT Value="0" />
|
438 |
<OPTIONSELECT Value="0" />
|
| 446 |
</OPTIONSELECTED>
|
439 |
</OPTIONSELECTED>
|
| 447 |
</COLUMN>
|
440 |
</COLUMN>
|
| 448 |
</COLUMNS>
|
441 |
</COLUMNS>
|
| Line 457... |
Line 450... |
| 457 |
</INDEX>
|
450 |
</INDEX>
|
| 458 |
</INDICES>
|
451 |
</INDICES>
|
| 459 |
</TABLE>
|
452 |
</TABLE>
|
| 460 |
<TABLE ID="1399" Tablename="gestion_absence_motif" PrevTableName="gestion_motif_absence" XPos="703" YPos="900" 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" >
|
453 |
<TABLE ID="1399" Tablename="gestion_absence_motif" PrevTableName="gestion_motif_absence" XPos="703" YPos="900" 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" >
|
| 461 |
<COLUMNS>
|
454 |
<COLUMNS>
|
| 462 |
<COLUMN ID="1435" ColName="gam_id_absence_motif" PrevColName="gma_id_motif" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
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="">
|
| 463 |
<OPTIONSELECTED>
|
456 |
<OPTIONSELECTED>
|
| 464 |
<OPTIONSELECT Value="1" />
|
457 |
<OPTIONSELECT Value="1" />
|
| 465 |
<OPTIONSELECT Value="0" />
|
458 |
<OPTIONSELECT Value="0" />
|
| 466 |
</OPTIONSELECTED>
|
459 |
</OPTIONSELECTED>
|
| 467 |
</COLUMN>
|
460 |
</COLUMN>
|
| 468 |
<COLUMN ID="1436" ColName="gam_libelle" PrevColName="gma_libelle_motif" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
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="">
|
| 469 |
<OPTIONSELECTED>
|
462 |
<OPTIONSELECTED>
|
| 470 |
<OPTIONSELECT Value="0" />
|
463 |
<OPTIONSELECT Value="0" />
|
| 471 |
</OPTIONSELECTED>
|
464 |
</OPTIONSELECTED>
|
| 472 |
</COLUMN>
|
465 |
</COLUMN>
|
| 473 |
<COLUMN ID="1437" ColName="gam_mark_rtt" PrevColName="gma_type_rtt" Pos="3" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
- |
|
| 474 |
<OPTIONSELECTED>
|
- |
|
| 475 |
</OPTIONSELECTED>
|
- |
|
| 476 |
</COLUMN>
|
- |
|
| 477 |
<COLUMN ID="1725" ColName="gam_nbre_heure" PrevColName="" Pos="3" idDatatype="4" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
- |
|
| 478 |
<OPTIONSELECTED>
|
- |
|
| 479 |
<OPTIONSELECT Value="0" />
|
- |
|
| 480 |
<OPTIONSELECT Value="0" />
|
- |
|
| 481 |
</OPTIONSELECTED>
|
- |
|
| 482 |
</COLUMN>
|
- |
|
| 483 |
</COLUMNS>
|
466 |
</COLUMNS>
|
| 484 |
<RELATIONS_START>
|
467 |
<RELATIONS_START>
|
| 485 |
<RELATION_START ID="1583" />
|
468 |
<RELATION_START ID="1583" />
|
| 486 |
</RELATIONS_START>
|
469 |
</RELATIONS_START>
|
| 487 |
<INDICES>
|
470 |
<INDICES>
|
| Line 575... |
Line 558... |
| 575 |
</INDEX>
|
558 |
</INDEX>
|
| 576 |
</INDICES>
|
559 |
</INDICES>
|
| 577 |
</TABLE>
|
560 |
</TABLE>
|
| 578 |
<TABLE ID="1405" Tablename="gestion_utilisateur_statut" PrevTableName="gestion_statut" XPos="700" YPos="238" 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" >
|
561 |
<TABLE ID="1405" Tablename="gestion_utilisateur_statut" PrevTableName="gestion_statut" XPos="700" YPos="238" 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" >
|
| 579 |
<COLUMNS>
|
562 |
<COLUMNS>
|
| 580 |
<COLUMN ID="1461" ColName="gus_id_utilisateur_statut" PrevColName="gs_id_statut" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
563 |
<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="">
|
| 581 |
<OPTIONSELECTED>
|
564 |
<OPTIONSELECTED>
|
| 582 |
<OPTIONSELECT Value="1" />
|
565 |
<OPTIONSELECT Value="1" />
|
| 583 |
<OPTIONSELECT Value="0" />
|
566 |
<OPTIONSELECT Value="0" />
|
| 584 |
</OPTIONSELECTED>
|
567 |
</OPTIONSELECTED>
|
| 585 |
</COLUMN>
|
568 |
</COLUMN>
|
| 586 |
<COLUMN ID="1462" ColName="gus_libelle" PrevColName="gs_libelle_statut" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
569 |
<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="">
|
| 587 |
<OPTIONSELECTED>
|
570 |
<OPTIONSELECTED>
|
| 588 |
<OPTIONSELECT Value="0" />
|
571 |
<OPTIONSELECT Value="0" />
|
| 589 |
</OPTIONSELECTED>
|
572 |
</OPTIONSELECTED>
|
| 590 |
</COLUMN>
|
573 |
</COLUMN>
|
| 591 |
</COLUMNS>
|
574 |
</COLUMNS>
|
| Line 600... |
Line 583... |
| 600 |
</INDEX>
|
583 |
</INDEX>
|
| 601 |
</INDICES>
|
584 |
</INDICES>
|
| 602 |
</TABLE>
|
585 |
</TABLE>
|
| 603 |
<TABLE ID="1406" Tablename="gestion_projet_tache" PrevTableName="gestion_taches" XPos="17" YPos="546" 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="14" >
|
586 |
<TABLE ID="1406" Tablename="gestion_projet_tache" PrevTableName="gestion_taches" XPos="17" YPos="546" 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="14" >
|
| 604 |
<COLUMNS>
|
587 |
<COLUMNS>
|
| 605 |
<COLUMN ID="1464" ColName="gpt_id_tache" PrevColName="gt_id_tache" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
588 |
<COLUMN ID="1464" ColName="gpt_id_tache" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
| 606 |
<OPTIONSELECTED>
|
589 |
<OPTIONSELECTED>
|
| 607 |
<OPTIONSELECT Value="1" />
|
590 |
<OPTIONSELECT Value="1" />
|
| 608 |
<OPTIONSELECT Value="0" />
|
591 |
<OPTIONSELECT Value="0" />
|
| 609 |
</OPTIONSELECTED>
|
592 |
</OPTIONSELECTED>
|
| 610 |
</COLUMN>
|
593 |
</COLUMN>
|
| Line 618... |
Line 601... |
| 618 |
<OPTIONSELECTED>
|
601 |
<OPTIONSELECTED>
|
| 619 |
<OPTIONSELECT Value="1" />
|
602 |
<OPTIONSELECT Value="1" />
|
| 620 |
<OPTIONSELECT Value="0" />
|
603 |
<OPTIONSELECT Value="0" />
|
| 621 |
</OPTIONSELECTED>
|
604 |
</OPTIONSELECTED>
|
| 622 |
</COLUMN>
|
605 |
</COLUMN>
|
| 623 |
<COLUMN ID="1466" ColName="gpt_libelle" PrevColName="gt_nom_tache" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
606 |
<COLUMN ID="1466" ColName="gpt_libelle" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
| 624 |
<OPTIONSELECTED>
|
607 |
<OPTIONSELECTED>
|
| 625 |
<OPTIONSELECT Value="0" />
|
608 |
<OPTIONSELECT Value="0" />
|
| 626 |
</OPTIONSELECTED>
|
609 |
</OPTIONSELECTED>
|
| 627 |
</COLUMN>
|
610 |
</COLUMN>
|
| 628 |
<COLUMN ID="1467" ColName="gpt_description" PrevColName="gt_description_tache" Pos="4" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
611 |
<COLUMN ID="1467" ColName="gpt_description" PrevColName="" Pos="4" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
| 629 |
<OPTIONSELECTED>
|
612 |
<OPTIONSELECTED>
|
| 630 |
</OPTIONSELECTED>
|
613 |
</OPTIONSELECTED>
|
| 631 |
</COLUMN>
|
614 |
</COLUMN>
|
| 632 |
<COLUMN ID="1468" ColName="gpt_date_debut" PrevColName="gt_date_debut_tache" Pos="5" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
615 |
<COLUMN ID="1468" ColName="gpt_date_debut" PrevColName="" Pos="5" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
| 633 |
<OPTIONSELECTED>
|
616 |
<OPTIONSELECTED>
|
| 634 |
</OPTIONSELECTED>
|
617 |
</OPTIONSELECTED>
|
| 635 |
</COLUMN>
|
618 |
</COLUMN>
|
| 636 |
<COLUMN ID="1469" ColName="gpt_duree_prevue" PrevColName="gt_duree_prevue" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
619 |
<COLUMN ID="1469" ColName="gpt_duree_prevue" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
| 637 |
<OPTIONSELECTED>
|
620 |
<OPTIONSELECTED>
|
| 638 |
<OPTIONSELECT Value="1" />
|
621 |
<OPTIONSELECT Value="1" />
|
| 639 |
<OPTIONSELECT Value="0" />
|
622 |
<OPTIONSELECT Value="0" />
|
| 640 |
</OPTIONSELECTED>
|
623 |
</OPTIONSELECTED>
|
| 641 |
</COLUMN>
|
624 |
</COLUMN>
|
| 642 |
<COLUMN ID="1470" ColName="gpt_avancement" PrevColName="gt_avancement" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
625 |
<COLUMN ID="1470" ColName="gpt_avancement" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
| 643 |
<OPTIONSELECTED>
|
626 |
<OPTIONSELECTED>
|
| 644 |
<OPTIONSELECT Value="0" />
|
627 |
<OPTIONSELECT Value="0" />
|
| 645 |
<OPTIONSELECT Value="0" />
|
628 |
<OPTIONSELECT Value="0" />
|
| 646 |
</OPTIONSELECTED>
|
629 |
</OPTIONSELECTED>
|
| 647 |
</COLUMN>
|
630 |
</COLUMN>
|
| Line 674... |
Line 657... |
| 674 |
<OPTIONSELECTED>
|
657 |
<OPTIONSELECTED>
|
| 675 |
<OPTIONSELECT Value="1" />
|
658 |
<OPTIONSELECT Value="1" />
|
| 676 |
<OPTIONSELECT Value="0" />
|
659 |
<OPTIONSELECT Value="0" />
|
| 677 |
</OPTIONSELECTED>
|
660 |
</OPTIONSELECTED>
|
| 678 |
</COLUMN>
|
661 |
</COLUMN>
|
| 679 |
<COLUMN ID="1474" ColName="gtp_id_date_travail" PrevColName="gt_date_travail" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
|
662 |
<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="">
|
| 680 |
<OPTIONSELECTED>
|
663 |
<OPTIONSELECTED>
|
| 681 |
</OPTIONSELECTED>
|
664 |
</OPTIONSELECTED>
|
| 682 |
</COLUMN>
|
665 |
</COLUMN>
|
| 683 |
<COLUMN ID="1475" ColName="gtp_duree" PrevColName="gt_duree_travail" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
|
666 |
<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="">
|
| 684 |
<OPTIONSELECTED>
|
667 |
<OPTIONSELECTED>
|
| 685 |
<OPTIONSELECT Value="0" />
|
668 |
<OPTIONSELECT Value="0" />
|
| 686 |
</OPTIONSELECTED>
|
669 |
</OPTIONSELECTED>
|
| 687 |
</COLUMN>
|
670 |
</COLUMN>
|
| 688 |
</COLUMNS>
|
671 |
</COLUMNS>
|
| Line 769... |
Line 752... |
| 769 |
<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="">
|
752 |
<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="">
|
| 770 |
<OPTIONSELECTED>
|
753 |
<OPTIONSELECTED>
|
| 771 |
<OPTIONSELECT Value="0" />
|
754 |
<OPTIONSELECT Value="0" />
|
| 772 |
</OPTIONSELECTED>
|
755 |
</OPTIONSELECTED>
|
| 773 |
</COLUMN>
|
756 |
</COLUMN>
|
| 774 |
<COLUMN ID="1490" ColName="gu_mark_admin" PrevColName="gu_admin" Pos="14" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
757 |
<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="">
|
| 775 |
<OPTIONSELECTED>
|
758 |
<OPTIONSELECTED>
|
| 776 |
</OPTIONSELECTED>
|
759 |
</OPTIONSELECTED>
|
| 777 |
</COLUMN>
|
760 |
</COLUMN>
|
| 778 |
<COLUMN ID="1491" ColName="gu_mark_recapitulatif" PrevColName="gu_admin2" Pos="15" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
761 |
<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="">
|
| 779 |
<OPTIONSELECTED>
|
762 |
<OPTIONSELECTED>
|
| 780 |
</OPTIONSELECTED>
|
763 |
</OPTIONSELECTED>
|
| 781 |
</COLUMN>
|
764 |
</COLUMN>
|
| 782 |
<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="">
|
765 |
<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="">
|
| 783 |
<OPTIONSELECTED>
|
766 |
<OPTIONSELECTED>
|
| Line 803... |
Line 786... |
| 803 |
</INDEX>
|
786 |
</INDEX>
|
| 804 |
</INDICES>
|
787 |
</INDICES>
|
| 805 |
</TABLE>
|
788 |
</TABLE>
|
| 806 |
<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" >
|
789 |
<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" >
|
| 807 |
<COLUMNS>
|
790 |
<COLUMNS>
|
| 808 |
<COLUMN ID="1439" ColName="gnf_id_note_frais" PrevColName="gnf_id_frais" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
791 |
<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="">
|
| 809 |
<OPTIONSELECTED>
|
792 |
<OPTIONSELECTED>
|
| 810 |
<OPTIONSELECT Value="1" />
|
793 |
<OPTIONSELECT Value="1" />
|
| 811 |
<OPTIONSELECT Value="0" />
|
794 |
<OPTIONSELECT Value="0" />
|
| 812 |
</OPTIONSELECTED>
|
795 |
</OPTIONSELECTED>
|
| 813 |
</COLUMN>
|
796 |
</COLUMN>
|
| Line 815... |
Line 798... |
| 815 |
<OPTIONSELECTED>
|
798 |
<OPTIONSELECTED>
|
| 816 |
<OPTIONSELECT Value="1" />
|
799 |
<OPTIONSELECT Value="1" />
|
| 817 |
<OPTIONSELECT Value="0" />
|
800 |
<OPTIONSELECT Value="0" />
|
| 818 |
</OPTIONSELECTED>
|
801 |
</OPTIONSELECTED>
|
| 819 |
</COLUMN>
|
802 |
</COLUMN>
|
| 820 |
<COLUMN ID="1440" ColName="gnf_libelle" PrevColName="gnf_libelle_frais" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
803 |
<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="">
|
| 821 |
<OPTIONSELECTED>
|
804 |
<OPTIONSELECTED>
|
| 822 |
<OPTIONSELECT Value="0" />
|
805 |
<OPTIONSELECT Value="0" />
|
| 823 |
</OPTIONSELECTED>
|
806 |
</OPTIONSELECTED>
|
| 824 |
</COLUMN>
|
807 |
</COLUMN>
|
| 825 |
</COLUMNS>
|
808 |
</COLUMNS>
|
| Line 883... |
Line 866... |
| 883 |
<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" />
|
866 |
<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" />
|
| 884 |
<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" />
|
867 |
<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" />
|
| 885 |
<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" />
|
868 |
<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" />
|
| 886 |
<RELATION ID="1514" RelationName="fk_gp_gpt" Kind="5" SrcTable="1404" DestTable="1406" FKFields="gp_id_projet=gpt_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="47" 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="30" />
|
869 |
<RELATION ID="1514" RelationName="fk_gp_gpt" Kind="5" SrcTable="1404" DestTable="1406" FKFields="gp_id_projet=gpt_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="47" 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="30" />
|
| 887 |
<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" />
|
870 |
<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" />
|
| 888 |
<RELATION ID="1583" RelationName="fk_gam_ga" Kind="2" SrcTable="1399" DestTable="1394" FKFields="gam_id_absence_motif=ga_ce_absence_motif\n" FKFieldsComments="\n" relDirection="1" 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" />
|
871 |
<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="1" 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" />
|
| 889 |
<RELATION ID="1585" RelationName="fk_gu_ga" Kind="5" SrcTable="1408" DestTable="1394" FKFields="gu_id_utilisateur=ga_ce_utilisateur\n" FKFieldsComments="\n" relDirection="3" 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" />
|
872 |
<RELATION ID="1585" RelationName="fk_gu_ga" Kind="1" SrcTable="1408" DestTable="1394" FKFields="gu_id_utilisateur=ga_id_utilisateur\n" FKFieldsComments="\n" relDirection="3" 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" />
|
| 890 |
<RELATION ID="1592" RelationName="fk_gs_gu" Kind="2" SrcTable="1405" DestTable="1408" FKFields="gus_id_utilisateur_statut=gus_id_utilisateur_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" />
|
873 |
<RELATION ID="1592" RelationName="fk_gs_gu" Kind="2" SrcTable="1405" DestTable="1408" FKFields="gus_id_utilisateur_statut=gus_id_utilisateur_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" />
|
| 891 |
<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" />
|
874 |
<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" />
|
| 892 |
<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" />
|
875 |
<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" />
|
| 893 |
<RELATION ID="1690" RelationName="fk_gpt_gpt_predecesseur" Kind="2" SrcTable="1406" DestTable="1406" FKFields="gpt_id_tache=gpt_ce_tache_precedente\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-84" 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="29" />
|
876 |
<RELATION ID="1690" RelationName="fk_gpt_gpt_predecesseur" Kind="2" SrcTable="1406" DestTable="1406" FKFields="gpt_id_tache=gpt_ce_tache_precedente\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-84" 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="29" />
|
| 894 |
<RELATION ID="1754" RelationName="fk_gpt_gtt" Kind="1" SrcTable="1406" DestTable="1745" FKFields="gpt_id_tache=gtt_id_tache\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="30" />
|
877 |
<RELATION ID="1754" RelationName="fk_gpt_gtt" Kind="1" SrcTable="1406" DestTable="1745" FKFields="gpt_id_tache=gtt_id_tache\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="30" />
|