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="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" />
|
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" />
|
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 258... |
Line 258... |
258 |
</SETTINGS>
|
258 |
</SETTINGS>
|
259 |
<METADATA>
|
259 |
<METADATA>
|
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="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" >
|
264 |
<COLUMNS>
|
264 |
<COLUMNS>
|
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="">
|
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" />
|
Line 296... |
Line 296... |
296 |
<INDEXCOLUMN idColumn="1411" LengthParam="0" />
|
296 |
<INDEXCOLUMN idColumn="1411" LengthParam="0" />
|
297 |
</INDEXCOLUMNS>
|
297 |
</INDEXCOLUMNS>
|
298 |
</INDEX>
|
298 |
</INDEX>
|
299 |
</INDICES>
|
299 |
</INDICES>
|
300 |
</TABLE>
|
300 |
</TABLE>
|
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" >
|
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" >
|
302 |
<COLUMNS>
|
302 |
<COLUMNS>
|
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="">
|
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="">
|
304 |
<OPTIONSELECTED>
|
304 |
<OPTIONSELECTED>
|
305 |
<OPTIONSELECT Value="1" />
|
305 |
<OPTIONSELECT Value="1" />
|
306 |
<OPTIONSELECT Value="0" />
|
306 |
<OPTIONSELECT Value="0" />
|
Line 448... |
Line 448... |
448 |
<INDEXCOLUMN idColumn="1432" LengthParam="0" />
|
448 |
<INDEXCOLUMN idColumn="1432" LengthParam="0" />
|
449 |
</INDEXCOLUMNS>
|
449 |
</INDEXCOLUMNS>
|
450 |
</INDEX>
|
450 |
</INDEX>
|
451 |
</INDICES>
|
451 |
</INDICES>
|
452 |
</TABLE>
|
452 |
</TABLE>
|
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" >
|
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" >
|
454 |
<COLUMNS>
|
454 |
<COLUMNS>
|
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="">
|
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="">
|
456 |
<OPTIONSELECTED>
|
456 |
<OPTIONSELECTED>
|
457 |
<OPTIONSELECT Value="1" />
|
457 |
<OPTIONSELECT Value="1" />
|
458 |
<OPTIONSELECT Value="0" />
|
458 |
<OPTIONSELECT Value="0" />
|
459 |
</OPTIONSELECTED>
|
459 |
</OPTIONSELECTED>
|
460 |
</COLUMN>
|
460 |
</COLUMN>
|
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="">
|
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.">
|
462 |
<OPTIONSELECTED>
|
462 |
<OPTIONSELECTED>
|
463 |
<OPTIONSELECT Value="0" />
|
463 |
<OPTIONSELECT Value="0" />
|
464 |
</OPTIONSELECTED>
|
464 |
</OPTIONSELECTED>
|
465 |
</COLUMN>
|
465 |
</COLUMN>
|
- |
|
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>
|
466 |
</COLUMNS>
|
478 |
</COLUMNS>
|
467 |
<RELATIONS_START>
|
479 |
<RELATIONS_START>
|
468 |
<RELATION_START ID="1583" />
|
480 |
<RELATION_START ID="1583" />
|
469 |
</RELATIONS_START>
|
481 |
</RELATIONS_START>
|
470 |
<INDICES>
|
482 |
<INDICES>
|
Line 473... |
Line 485... |
473 |
<INDEXCOLUMN idColumn="1435" LengthParam="0" />
|
485 |
<INDEXCOLUMN idColumn="1435" LengthParam="0" />
|
474 |
</INDEXCOLUMNS>
|
486 |
</INDEXCOLUMNS>
|
475 |
</INDEX>
|
487 |
</INDEX>
|
476 |
</INDICES>
|
488 |
</INDICES>
|
477 |
</TABLE>
|
489 |
</TABLE>
|
478 |
<TABLE ID="1402" Tablename="gestion_utilisateur_a_projet" PrevTableName="gestion_preferences" XPos="378" YPos="326" 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" >
|
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" >
|
479 |
<COLUMNS>
|
491 |
<COLUMNS>
|
480 |
<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="">
|
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="">
|
481 |
<OPTIONSELECTED>
|
493 |
<OPTIONSELECTED>
|
482 |
<OPTIONSELECT Value="1" />
|
494 |
<OPTIONSELECT Value="1" />
|
483 |
<OPTIONSELECT Value="0" />
|
495 |
<OPTIONSELECT Value="0" />
|
Line 509... |
Line 521... |
509 |
<OPTIONSELECTED>
|
521 |
<OPTIONSELECTED>
|
510 |
<OPTIONSELECT Value="1" />
|
522 |
<OPTIONSELECT Value="1" />
|
511 |
<OPTIONSELECT Value="0" />
|
523 |
<OPTIONSELECT Value="0" />
|
512 |
</OPTIONSELECTED>
|
524 |
</OPTIONSELECTED>
|
513 |
</COLUMN>
|
525 |
</COLUMN>
|
- |
|
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>
|
514 |
<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.">
|
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.">
|
515 |
<OPTIONSELECTED>
|
533 |
<OPTIONSELECTED>
|
516 |
<OPTIONSELECT Value="1" />
|
534 |
<OPTIONSELECT Value="1" />
|
517 |
<OPTIONSELECT Value="0" />
|
535 |
<OPTIONSELECT Value="0" />
|
518 |
</OPTIONSELECTED>
|
536 |
</OPTIONSELECTED>
|
519 |
</COLUMN>
|
537 |
</COLUMN>
|
520 |
<COLUMN ID="1455" ColName="gp_nom_projet" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du projet.">
|
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.">
|
521 |
<OPTIONSELECTED>
|
539 |
<OPTIONSELECTED>
|
522 |
<OPTIONSELECT Value="0" />
|
540 |
<OPTIONSELECT Value="0" />
|
523 |
</OPTIONSELECTED>
|
541 |
</OPTIONSELECTED>
|
524 |
</COLUMN>
|
542 |
</COLUMN>
|
525 |
<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.">
|
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.">
|
526 |
<OPTIONSELECTED>
|
544 |
<OPTIONSELECTED>
|
527 |
</OPTIONSELECTED>
|
545 |
</OPTIONSELECTED>
|
528 |
</COLUMN>
|
546 |
</COLUMN>
|
529 |
<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="" Comments="Date de d\195\169but du projet">
|
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">
|
- |
|
548 |
<OPTIONSELECTED>
|
- |
|
549 |
</OPTIONSELECTED>
|
- |
|
550 |
</COLUMN>
|
- |
|
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.">
|
530 |
<OPTIONSELECTED>
|
552 |
<OPTIONSELECTED>
|
531 |
</OPTIONSELECTED>
|
553 |
</OPTIONSELECTED>
|
532 |
</COLUMN>
|
554 |
</COLUMN>
|
533 |
<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="" Comments="Dur\195\169e pr\195\169vue du projet en jour.">
|
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.">
|
534 |
<OPTIONSELECTED>
|
556 |
<OPTIONSELECTED>
|
535 |
<OPTIONSELECT Value="0" />
|
557 |
<OPTIONSELECT Value="0" />
|
536 |
</OPTIONSELECTED>
|
558 |
</OPTIONSELECTED>
|
537 |
</COLUMN>
|
559 |
</COLUMN>
|
538 |
<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="" Comments="Pourcentage d\aavancement du projet.">
|
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.">
|
539 |
<OPTIONSELECTED>
|
561 |
<OPTIONSELECTED>
|
540 |
<OPTIONSELECT Value="0" />
|
562 |
<OPTIONSELECT Value="0" />
|
541 |
<OPTIONSELECT Value="0" />
|
563 |
<OPTIONSELECT Value="0" />
|
542 |
</OPTIONSELECTED>
|
564 |
</OPTIONSELECTED>
|
543 |
</COLUMN>
|
565 |
</COLUMN>
|
544 |
</COLUMNS>
|
566 |
</COLUMNS>
|
545 |
<RELATIONS_START>
|
567 |
<RELATIONS_START>
|
546 |
<RELATION_START ID="1498" />
|
568 |
<RELATION_START ID="1498" />
|
547 |
<RELATION_START ID="1511" />
|
569 |
<RELATION_START ID="1511" />
|
548 |
<RELATION_START ID="1514" />
|
570 |
<RELATION_START ID="1764" />
|
549 |
</RELATIONS_START>
|
571 |
</RELATIONS_START>
|
550 |
<RELATIONS_END>
|
572 |
<RELATIONS_END>
|
551 |
<RELATION_END ID="1564" />
|
573 |
<RELATION_END ID="1564" />
|
- |
|
574 |
<RELATION_END ID="1764" />
|
552 |
</RELATIONS_END>
|
575 |
</RELATIONS_END>
|
553 |
<INDICES>
|
576 |
<INDICES>
|
554 |
<INDEX ID="1625" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
577 |
<INDEX ID="1625" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
555 |
<INDEXCOLUMNS>
|
578 |
<INDEXCOLUMNS>
|
556 |
<INDEXCOLUMN idColumn="1522" LengthParam="0" />
|
579 |
<INDEXCOLUMN idColumn="1522" LengthParam="0" />
|
557 |
</INDEXCOLUMNS>
|
580 |
</INDEXCOLUMNS>
|
558 |
</INDEX>
|
581 |
</INDEX>
|
559 |
</INDICES>
|
582 |
</INDICES>
|
560 |
</TABLE>
|
583 |
</TABLE>
|
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" >
|
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" >
|
562 |
<COLUMNS>
|
585 |
<COLUMNS>
|
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="">
|
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="">
|
564 |
<OPTIONSELECTED>
|
587 |
<OPTIONSELECTED>
|
565 |
<OPTIONSELECT Value="1" />
|
588 |
<OPTIONSELECT Value="1" />
|
566 |
<OPTIONSELECT Value="0" />
|
589 |
<OPTIONSELECT Value="0" />
|
Line 569... |
Line 592... |
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="">
|
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="">
|
570 |
<OPTIONSELECTED>
|
593 |
<OPTIONSELECTED>
|
571 |
<OPTIONSELECT Value="0" />
|
594 |
<OPTIONSELECT Value="0" />
|
572 |
</OPTIONSELECTED>
|
595 |
</OPTIONSELECTED>
|
573 |
</COLUMN>
|
596 |
</COLUMN>
|
574 |
</COLUMNS>
|
- |
|
575 |
<RELATIONS_START>
|
- |
|
576 |
<RELATION_START ID="1592" />
|
- |
|
577 |
</RELATIONS_START>
|
- |
|
578 |
<INDICES>
|
- |
|
579 |
<INDEX ID="1463" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
- |
|
580 |
<INDEXCOLUMNS>
|
- |
|
581 |
<INDEXCOLUMN idColumn="1461" LengthParam="0" />
|
- |
|
582 |
</INDEXCOLUMNS>
|
- |
|
583 |
</INDEX>
|
- |
|
584 |
</INDICES>
|
- |
|
585 |
</TABLE>
|
- |
|
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" >
|
- |
|
587 |
<COLUMNS>
|
- |
|
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="">
|
- |
|
589 |
<OPTIONSELECTED>
|
- |
|
590 |
<OPTIONSELECT Value="1" />
|
- |
|
591 |
<OPTIONSELECT Value="0" />
|
- |
|
592 |
</OPTIONSELECTED>
|
- |
|
593 |
</COLUMN>
|
- |
|
594 |
<COLUMN ID="1732" ColName="gpt_ce_tache_precedente" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
- |
|
595 |
<OPTIONSELECTED>
|
- |
|
596 |
<OPTIONSELECT Value="1" />
|
- |
|
597 |
<OPTIONSELECT Value="0" />
|
- |
|
598 |
</OPTIONSELECTED>
|
- |
|
599 |
</COLUMN>
|
- |
|
600 |
<COLUMN ID="1695" ColName="gpt_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
- |
|
601 |
<OPTIONSELECTED>
|
- |
|
602 |
<OPTIONSELECT Value="1" />
|
- |
|
603 |
<OPTIONSELECT Value="0" />
|
- |
|
604 |
</OPTIONSELECTED>
|
- |
|
605 |
</COLUMN>
|
- |
|
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="">
|
- |
|
607 |
<OPTIONSELECTED>
|
- |
|
608 |
<OPTIONSELECT Value="0" />
|
- |
|
609 |
</OPTIONSELECTED>
|
- |
|
610 |
</COLUMN>
|
- |
|
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="">
|
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.">
|
612 |
<OPTIONSELECTED>
|
- |
|
613 |
</OPTIONSELECTED>
|
- |
|
614 |
</COLUMN>
|
- |
|
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="">
|
- |
|
616 |
<OPTIONSELECTED>
|
- |
|
617 |
</OPTIONSELECTED>
|
- |
|
618 |
</COLUMN>
|
- |
|
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="">
|
- |
|
620 |
<OPTIONSELECTED>
|
- |
|
621 |
<OPTIONSELECT Value="1" />
|
- |
|
622 |
<OPTIONSELECT Value="0" />
|
- |
|
623 |
</OPTIONSELECTED>
|
- |
|
624 |
</COLUMN>
|
- |
|
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="">
|
- |
|
626 |
<OPTIONSELECTED>
|
598 |
<OPTIONSELECTED>
|
627 |
<OPTIONSELECT Value="0" />
|
- |
|
628 |
<OPTIONSELECT Value="0" />
|
- |
|
629 |
</OPTIONSELECTED>
|
599 |
</OPTIONSELECTED>
|
630 |
</COLUMN>
|
600 |
</COLUMN>
|
631 |
</COLUMNS>
|
601 |
</COLUMNS>
|
632 |
<RELATIONS_START>
|
602 |
<RELATIONS_START>
|
633 |
<RELATION_START ID="1690" />
|
603 |
<RELATION_START ID="1592" />
|
634 |
<RELATION_START ID="1754" />
|
- |
|
635 |
</RELATIONS_START>
|
604 |
</RELATIONS_START>
|
636 |
<RELATIONS_END>
|
- |
|
637 |
<RELATION_END ID="1514" />
|
- |
|
638 |
<RELATION_END ID="1690" />
|
- |
|
639 |
</RELATIONS_END>
|
- |
|
640 |
<INDICES>
|
605 |
<INDICES>
|
641 |
<INDEX ID="1655" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
606 |
<INDEX ID="1463" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
642 |
<INDEXCOLUMNS>
|
607 |
<INDEXCOLUMNS>
|
643 |
<INDEXCOLUMN idColumn="1464" LengthParam="0" />
|
608 |
<INDEXCOLUMN idColumn="1461" LengthParam="0" />
|
644 |
</INDEXCOLUMNS>
|
609 |
</INDEXCOLUMNS>
|
645 |
</INDEX>
|
610 |
</INDEX>
|
646 |
</INDICES>
|
611 |
</INDICES>
|
647 |
</TABLE>
|
612 |
</TABLE>
|
648 |
<TABLE ID="1407" Tablename="gestion_travail_projet" PrevTableName="gestion_travail" XPos="373" YPos="462" 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" >
|
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" >
|
649 |
<COLUMNS>
|
614 |
<COLUMNS>
|
650 |
<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="">
|
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="">
|
651 |
<OPTIONSELECTED>
|
616 |
<OPTIONSELECTED>
|
652 |
<OPTIONSELECT Value="1" />
|
617 |
<OPTIONSELECT Value="1" />
|
653 |
<OPTIONSELECT Value="0" />
|
618 |
<OPTIONSELECT Value="0" />
|
Line 771... |
Line 736... |
771 |
<RELATION_START ID="1494" />
|
736 |
<RELATION_START ID="1494" />
|
772 |
<RELATION_START ID="1503" />
|
737 |
<RELATION_START ID="1503" />
|
773 |
<RELATION_START ID="1510" />
|
738 |
<RELATION_START ID="1510" />
|
774 |
<RELATION_START ID="1585" />
|
739 |
<RELATION_START ID="1585" />
|
775 |
<RELATION_START ID="1612" />
|
740 |
<RELATION_START ID="1612" />
|
776 |
<RELATION_START ID="1757" />
|
- |
|
777 |
</RELATIONS_START>
|
741 |
</RELATIONS_START>
|
778 |
<RELATIONS_END>
|
742 |
<RELATIONS_END>
|
779 |
<RELATION_END ID="1592" />
|
743 |
<RELATION_END ID="1592" />
|
780 |
</RELATIONS_END>
|
744 |
</RELATIONS_END>
|
781 |
<INDICES>
|
745 |
<INDICES>
|
Line 818... |
Line 782... |
818 |
<INDEXCOLUMN idColumn="1439" LengthParam="0" />
|
782 |
<INDEXCOLUMN idColumn="1439" LengthParam="0" />
|
819 |
</INDEXCOLUMNS>
|
783 |
</INDEXCOLUMNS>
|
820 |
</INDEX>
|
784 |
</INDEX>
|
821 |
</INDICES>
|
785 |
</INDICES>
|
822 |
</TABLE>
|
786 |
</TABLE>
|
823 |
<TABLE ID="1745" Tablename="gestion_travail_tache" PrevTableName="Table_14" XPos="374" YPos="622" 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="29" >
|
- |
|
824 |
<COLUMNS>
|
- |
|
825 |
<COLUMN ID="1759" ColName="gtt_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
- |
|
826 |
<OPTIONSELECTED>
|
- |
|
827 |
<OPTIONSELECT Value="1" />
|
- |
|
828 |
<OPTIONSELECT Value="0" />
|
- |
|
829 |
</OPTIONSELECTED>
|
- |
|
830 |
</COLUMN>
|
- |
|
831 |
<COLUMN ID="1756" ColName="gtt_id_tache" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
- |
|
832 |
<OPTIONSELECTED>
|
- |
|
833 |
<OPTIONSELECT Value="1" />
|
- |
|
834 |
<OPTIONSELECT Value="0" />
|
- |
|
835 |
</OPTIONSELECTED>
|
- |
|
836 |
</COLUMN>
|
- |
|
837 |
<COLUMN ID="1747" ColName="gtt_id_date_travail" PrevColName="" Pos="0" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
- |
|
838 |
<OPTIONSELECTED>
|
- |
|
839 |
</OPTIONSELECTED>
|
- |
|
840 |
</COLUMN>
|
- |
|
841 |
<COLUMN ID="1750" ColName="gtt_duree" PrevColName="" Pos="1" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
|
- |
|
842 |
<OPTIONSELECTED>
|
- |
|
843 |
<OPTIONSELECT Value="0" />
|
- |
|
844 |
</OPTIONSELECTED>
|
- |
|
845 |
</COLUMN>
|
- |
|
846 |
</COLUMNS>
|
- |
|
847 |
<RELATIONS_END>
|
- |
|
848 |
<RELATION_END ID="1754" />
|
- |
|
849 |
<RELATION_END ID="1757" />
|
- |
|
850 |
</RELATIONS_END>
|
- |
|
851 |
<INDICES>
|
- |
|
852 |
<INDEX ID="1748" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
- |
|
853 |
<INDEXCOLUMNS>
|
- |
|
854 |
<INDEXCOLUMN idColumn="1759" LengthParam="0" />
|
- |
|
855 |
<INDEXCOLUMN idColumn="1756" LengthParam="0" />
|
- |
|
856 |
<INDEXCOLUMN idColumn="1747" LengthParam="0" />
|
- |
|
857 |
</INDEXCOLUMNS>
|
- |
|
858 |
</INDEX>
|
- |
|
859 |
</INDICES>
|
- |
|
860 |
</TABLE>
|
- |
|
861 |
</TABLES>
|
787 |
</TABLES>
|
862 |
<RELATIONS>
|
788 |
<RELATIONS>
|
863 |
<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" />
|
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" />
|
864 |
<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" />
|
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" />
|
865 |
<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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
- |
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
873 |
<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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
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" />
|
- |
|
878 |
<RELATION ID="1757" RelationName="fk_gu_gtt" Kind="1" SrcTable="1408" DestTable="1745" FKFields="gu_id_utilisateur=gtt_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" 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="31" />
|
- |
|
879 |
</RELATIONS>
|
802 |
</RELATIONS>
|
880 |
<NOTES>
|
803 |
<NOTES>
|
881 |
</NOTES>
|
804 |
</NOTES>
|
882 |
<IMAGES>
|
805 |
<IMAGES>
|
883 |
</IMAGES>
|
806 |
</IMAGES>
|