Subversion Repositories eFlore/Applications.coel

Rev

Rev 41 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 41 Rev 42
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="coel" 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="" 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="0" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="nimbus sans l" CanvasWidth="4096" CanvasHeight="2842" />
4
<GLOBALSETTINGS ModelName="coel" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="BDD_NOM : tela_coel" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="0" 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="0" 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 256... Line 256...
256
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
256
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
257
</POSITIONMARKERS>
257
</POSITIONMARKERS>
258
</SETTINGS>
258
</SETTINGS>
259
<METADATA>
259
<METADATA>
260
<REGIONS>
260
<REGIONS>
261
<REGION ID="1443" RegionName="Collection" XPos="28" YPos="924" Width="744" Height="1251" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Collections.\nAbreviation : CC\nAide : OK\nEtat: OK\nRevision : $Revision: 41 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
261
<REGION ID="21340" RegionName="Projet" XPos="28" YPos="504" Width="744" Height="410" RegionColor="5" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Projets.\nAbreviation : CPR\nAide : OK\nEtat: OK\nRevision : $Revision: 42 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="74" />
262
<REGION ID="18416" RegionName="Structure" XPos="785" YPos="1386" Width="701" Height="959" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Structures.\nAbreviation : CS\nAide : OK\nEtat: OK\nRevision : $Revision: 41 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
262
<REGION ID="21218" RegionName="Publication" XPos="24" YPos="2357" Width="747" Height="286" RegionColor="4" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Publications.\nAbreviation : CPU\nAide : OK\nEtat: OK\nRevision : $Revision: 42 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="63" />
263
<REGION ID="18417" RegionName="Personne" XPos="784" YPos="505" Width="700" Height="872" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Personnes.\nAbreviation : CP\nAide : OK\nEtat: OK\nRevision : $Revision: 41 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
263
<REGION ID="18447" RegionName="M\195\169tadonn\195\169e" XPos="20" YPos="16" Width="1464" Height="480" RegionColor="3" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des M\195\169tadonn\195\169es.\nAbreviation : CM\nAide : OK\nEtat: OK\nRevision : $Revision: 42 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
264
<REGION ID="18447" RegionName="M\195\169tadonn\195\169e" XPos="20" YPos="16" Width="1464" Height="480" RegionColor="3" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des M\195\169tadonn\195\169es.\nAbreviation : CM\nAide : OK\nEtat: OK\nRevision : $Revision: 41 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
264
<REGION ID="18417" RegionName="Personne" XPos="784" YPos="505" Width="700" Height="872" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Personnes.\nAbreviation : CP\nAide : OK\nEtat: OK\nRevision : $Revision: 42 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
265
<REGION ID="21218" RegionName="Publication" XPos="24" YPos="2188" Width="746" Height="270" RegionColor="4" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Publications.\nAbreviation : CPU\nAide : OK\nEtat: OK\nRevision : $Revision: 41 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="63" />
265
<REGION ID="18416" RegionName="Structure" XPos="785" YPos="1386" Width="701" Height="959" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Structures.\nAbreviation : CS\nAide : OK\nEtat: OK\nRevision : $Revision: 42 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
266
<REGION ID="21340" RegionName="Projet" XPos="28" YPos="504" Width="744" Height="410" RegionColor="5" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Projets.\nAbreviation : CPR\nAide : OK\nEtat: OK\nRevision : $Revision: 41 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="74" />
266
<REGION ID="1443" RegionName="Collection" XPos="28" YPos="924" Width="741" Height="1421" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Collections.\nAbreviation : CC\nAide : OK\nEtat: OK\nRevision : $Revision: 42 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
267
</REGIONS>
267
</REGIONS>
268
<TABLES>
268
<TABLES>
269
<TABLE ID="1444" Tablename="coel_collection" PrevTableName="Table_01" XPos="36" YPos="1152" 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="Contient les informations sur les collections." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" >
269
<TABLE ID="1444" Tablename="coel_collection" PrevTableName="Table_01" XPos="36" YPos="1151" 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="Contient les informations sur les collections.INFO : cc_nom\n" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" >
270
<COLUMNS>
270
<COLUMNS>
271
<COLUMN ID="1449" ColName="cc_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la collection.">
271
<COLUMN ID="1449" ColName="cc_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la collection.">
272
<OPTIONSELECTED>
272
<OPTIONSELECTED>
273
<OPTIONSELECT Value="1" />
273
<OPTIONSELECT Value="1" />
274
<OPTIONSELECT Value="0" />
274
<OPTIONSELECT Value="0" />
Line 496... Line 496...
496
<INDEXCOLUMN idColumn="1449" LengthParam="0" />
496
<INDEXCOLUMN idColumn="1449" LengthParam="0" />
497
</INDEXCOLUMNS>
497
</INDEXCOLUMNS>
498
</INDEX>
498
</INDEX>
499
</INDICES>
499
</INDICES>
500
</TABLE>
500
</TABLE>
501
<TABLE ID="1445" Tablename="coel_structure" PrevTableName="Table_02" XPos="805" YPos="1410" 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="Contient les informations sur les structures." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="40" >
501
<TABLE ID="1445" Tablename="coel_structure" PrevTableName="Table_02" XPos="805" YPos="1410" 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="Contient les informations sur les structures.\nINFO : cs_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="40" >
502
<COLUMNS>
502
<COLUMNS>
503
<COLUMN ID="18411" ColName="cs_id_structure" PrevColName="idcoel_structure" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la structure.">
503
<COLUMN ID="18411" ColName="cs_id_structure" PrevColName="idcoel_structure" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la structure.">
504
<OPTIONSELECTED>
504
<OPTIONSELECTED>
505
<OPTIONSELECT Value="1" />
505
<OPTIONSELECT Value="1" />
506
<OPTIONSELECT Value="0" />
506
<OPTIONSELECT Value="0" />
Line 653... Line 653...
653
<INDEXCOLUMN idColumn="18411" LengthParam="0" />
653
<INDEXCOLUMN idColumn="18411" LengthParam="0" />
654
</INDEXCOLUMNS>
654
</INDEXCOLUMNS>
655
</INDEX>
655
</INDEX>
656
</INDICES>
656
</INDICES>
657
</TABLE>
657
</TABLE>
658
<TABLE ID="1446" Tablename="coel_personne" PrevTableName="Table_03" XPos="864" 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="Contient les informations sur les personnes.\nPar personne nous entendons \195\160 la fois les utilisateurs de l\aapplication mais aussi les personnes contacts, les botanistes collecteurs, auteurs..." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="67" >
658
<TABLE ID="1446" Tablename="coel_personne" PrevTableName="Table_03" XPos="865" YPos="726" 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="Contient les informations sur les personnes.\nPar personne nous entendons \195\160 la fois les utilisateurs de l\aapplication mais aussi les personnes contacts, les botanistes collecteurs, auteurs...\nINFO : cp_fmt_nom_complet" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="67" >
659
<COLUMNS>
659
<COLUMNS>
660
<COLUMN ID="1456" ColName="cp_id_personne" PrevColName="cco_id_contact" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun contact.">
660
<COLUMN ID="1456" ColName="cp_id_personne" PrevColName="cco_id_contact" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun contact.">
661
<OPTIONSELECTED>
661
<OPTIONSELECTED>
662
<OPTIONSELECT Value="1" />
662
<OPTIONSELECT Value="1" />
663
<OPTIONSELECT Value="0" />
663
<OPTIONSELECT Value="0" />
Line 952... Line 952...
952
<INDEXCOLUMN idColumn="18454" LengthParam="0" />
952
<INDEXCOLUMN idColumn="18454" LengthParam="0" />
953
</INDEXCOLUMNS>
953
</INDEXCOLUMNS>
954
</INDEX>
954
</INDEX>
955
</INDICES>
955
</INDICES>
956
</TABLE>
956
</TABLE>
957
<TABLE ID="18456" Tablename="coel_meta_colonne" PrevTableName="Table_07" XPos="572" YPos="93" 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="Contient l\aensemble des champs des tables de la base de donn\195\169es." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="25" >
957
<TABLE ID="18456" Tablename="coel_meta_colonne" PrevTableName="Table_07" XPos="572" YPos="93" 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="Contient l\aensemble des champs des tables de la base de donn\195\169es.\nINFO : cmc_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="25" >
958
<COLUMNS>
958
<COLUMNS>
959
<COLUMN ID="18458" ColName="cmc_id_champ" PrevColName="cmc_id_caracteristique" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom du champ dans la table.">
959
<COLUMN ID="18458" ColName="cmc_id_champ" PrevColName="cmc_id_caracteristique" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom du champ dans la table.">
960
<OPTIONSELECTED>
960
<OPTIONSELECTED>
961
<OPTIONSELECT Value="1" />
961
<OPTIONSELECT Value="1" />
962
<OPTIONSELECT Value="0" />
962
<OPTIONSELECT Value="0" />
Line 1028... Line 1028...
1028
<INDEXCOLUMN idColumn="18458" LengthParam="0" />
1028
<INDEXCOLUMN idColumn="18458" LengthParam="0" />
1029
</INDEXCOLUMNS>
1029
</INDEXCOLUMNS>
1030
</INDEX>
1030
</INDEX>
1031
</INDICES>
1031
</INDICES>
1032
</TABLE>
1032
</TABLE>
1033
<TABLE ID="18466" Tablename="coel_meta_liste_valeur" PrevTableName="Table_09" XPos="127" YPos="26" 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="Liste l\aensemble des valeurs des tables de type liste.\nUn champ contient des valeurs dans cette table quand il est de type \ALISTE\A." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="24" >
1033
<TABLE ID="18466" Tablename="coel_meta_liste_valeur" PrevTableName="Table_09" XPos="127" YPos="26" 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="Liste l\aensemble des valeurs des tables de type liste.\nUn champ contient des valeurs dans cette table quand il est de type \ALISTE\A.\nINFO : cmlv_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="24" >
1034
<COLUMNS>
1034
<COLUMNS>
1035
<COLUMN ID="18468" ColName="cmlv_id_valeur" PrevColName="cmv_id_valeur" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune valeur de liste. Notez que les listes sont des valeurs de la liste des listes.">
1035
<COLUMN ID="18468" ColName="cmlv_id_valeur" PrevColName="cmv_id_valeur" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune valeur de liste. Notez que les listes sont des valeurs de la liste des listes.">
1036
<OPTIONSELECTED>
1036
<OPTIONSELECTED>
1037
<OPTIONSELECT Value="1" />
1037
<OPTIONSELECT Value="1" />
1038
<OPTIONSELECT Value="0" />
1038
<OPTIONSELECT Value="0" />
Line 1048... Line 1048...
1048
<OPTIONSELECTED>
1048
<OPTIONSELECTED>
1049
<OPTIONSELECT Value="1" />
1049
<OPTIONSELECT Value="1" />
1050
<OPTIONSELECT Value="0" />
1050
<OPTIONSELECT Value="0" />
1051
</OPTIONSELECTED>
1051
</OPTIONSELECTED>
1052
</COLUMN>
1052
</COLUMN>
1053
<COLUMN ID="21723" ColName="cml_nom" PrevColName="cmv_nom" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la valeur.">
1053
<COLUMN ID="21723" ColName="cmlv_nom" PrevColName="cmv_nom" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la valeur.">
1054
<OPTIONSELECTED>
1054
<OPTIONSELECTED>
1055
<OPTIONSELECT Value="0" />
1055
<OPTIONSELECT Value="0" />
1056
</OPTIONSELECTED>
1056
</OPTIONSELECTED>
1057
</COLUMN>
1057
</COLUMN>
1058
<COLUMN ID="21724" ColName="cmlv_abreviation" PrevColName="cmv_abreviation" Pos="3" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation, code ou identifiant de la valeur.">
1058
<COLUMN ID="21724" ColName="cmlv_abreviation" PrevColName="cmv_abreviation" Pos="3" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation, code ou identifiant de la valeur.">
Line 1595... Line 1595...
1595
<INDEXCOLUMN idColumn="21150" LengthParam="0" />
1595
<INDEXCOLUMN idColumn="21150" LengthParam="0" />
1596
</INDEXCOLUMNS>
1596
</INDEXCOLUMNS>
1597
</INDEX>
1597
</INDEX>
1598
</INDICES>
1598
</INDICES>
1599
</TABLE>
1599
</TABLE>
1600
<TABLE ID="21188" Tablename="coel_publication" PrevTableName="Table_15" XPos="99" YPos="2197" 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="Publication de type articles scientifiques, ouvrages ou sites web." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" >
1600
<TABLE ID="21188" Tablename="coel_publication" PrevTableName="Table_15" XPos="99" YPos="2366" 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="Publication de type articles scientifiques, ouvrages ou sites web.\nINFO : cpu_fmt_nom_complet" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" >
1601
<COLUMNS>
1601
<COLUMNS>
1602
<COLUMN ID="21190" ColName="cpu_id_publication" PrevColName="cp_id_publication" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la publication.">
1602
<COLUMN ID="21190" ColName="cpu_id_publication" PrevColName="cp_id_publication" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la publication.">
1603
<OPTIONSELECTED>
1603
<OPTIONSELECTED>
1604
<OPTIONSELECT Value="1" />
1604
<OPTIONSELECT Value="1" />
1605
<OPTIONSELECT Value="0" />
1605
<OPTIONSELECT Value="0" />
Line 1609... Line 1609...
1609
<OPTIONSELECTED>
1609
<OPTIONSELECTED>
1610
<OPTIONSELECT Value="1" />
1610
<OPTIONSELECT Value="1" />
1611
<OPTIONSELECT Value="0" />
1611
<OPTIONSELECT Value="0" />
1612
</OPTIONSELECTED>
1612
</OPTIONSELECTED>
1613
</COLUMN>
1613
</COLUMN>
-
 
1614
<COLUMN ID="21955" ColName="cpu_fmt_nom_complet" PrevColName="cpu_fmt_nom" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la publication complet">
-
 
1615
<OPTIONSELECTED>
-
 
1616
<OPTIONSELECT Value="0" />
-
 
1617
</OPTIONSELECTED>
-
 
1618
</COLUMN>
1614
<COLUMN ID="21305" ColName="cpu_uri" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URI de la publication qui peut \195\170tre un site web...">
1619
<COLUMN ID="21305" ColName="cpu_uri" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URI de la publication qui peut \195\170tre un site web...">
1615
<OPTIONSELECTED>
1620
<OPTIONSELECTED>
1616
<OPTIONSELECT Value="0" />
1621
<OPTIONSELECT Value="0" />
1617
</OPTIONSELECTED>
1622
</OPTIONSELECTED>
1618
</COLUMN>
1623
</COLUMN>
Line 1720... Line 1725...
1720
<INDEXCOLUMN idColumn="21244" LengthParam="0" />
1725
<INDEXCOLUMN idColumn="21244" LengthParam="0" />
1721
</INDEXCOLUMNS>
1726
</INDEXCOLUMNS>
1722
</INDEX>
1727
</INDEX>
1723
</INDICES>
1728
</INDICES>
1724
</TABLE>
1729
</TABLE>
1725
<TABLE ID="21235" Tablename="coel_publication_a_personne" PrevTableName="Table_17" XPos="506" YPos="2235" 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="Permet de lister les publications d\aune personne." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="76" >
1730
<TABLE ID="21235" Tablename="coel_publication_a_personne" PrevTableName="Table_17" XPos="506" YPos="2404" 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="Permet de lister les publications d\aune personne." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="76" >
1726
<COLUMNS>
1731
<COLUMNS>
1727
<COLUMN ID="21571" ColName="cpuap_id_publication" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune publication.">
1732
<COLUMN ID="21571" ColName="cpuap_id_publication" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune publication.">
1728
<OPTIONSELECTED>
1733
<OPTIONSELECTED>
1729
<OPTIONSELECT Value="1" />
1734
<OPTIONSELECT Value="1" />
1730
<OPTIONSELECT Value="0" />
1735
<OPTIONSELECT Value="0" />
Line 1807... Line 1812...
1807
<INDEXCOLUMN idColumn="21491" LengthParam="0" />
1812
<INDEXCOLUMN idColumn="21491" LengthParam="0" />
1808
</INDEXCOLUMNS>
1813
</INDEXCOLUMNS>
1809
</INDEX>
1814
</INDEX>
1810
</INDICES>
1815
</INDICES>
1811
</TABLE>
1816
</TABLE>
1812
<TABLE ID="21522" Tablename="coel_projet" PrevTableName="EFLORE_PROJET" XPos="36" YPos="532" 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="Contient les informations sur un projet de donn\195\169es." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >
1817
<TABLE ID="21522" Tablename="coel_projet" PrevTableName="EFLORE_PROJET" XPos="36" YPos="532" 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="Contient les informations sur un projet de donn\195\169es.\nINFO : cpr_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >
1813
<COLUMNS>
1818
<COLUMNS>
1814
<COLUMN ID="21523" ColName="cpr_id_projet" PrevColName="EPR_ID_PROJET" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun projet.">
1819
<COLUMN ID="21523" ColName="cpr_id_projet" PrevColName="EPR_ID_PROJET" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun projet.">
1815
<OPTIONSELECTED>
1820
<OPTIONSELECTED>
1816
<OPTIONSELECT Value="0" />
1821
<OPTIONSELECT Value="0" />
1817
<OPTIONSELECT Value="0" />
1822
<OPTIONSELECT Value="0" />
Line 1913... Line 1918...
1913
<INDEXCOLUMN idColumn="21549" LengthParam="0" />
1918
<INDEXCOLUMN idColumn="21549" LengthParam="0" />
1914
</INDEXCOLUMNS>
1919
</INDEXCOLUMNS>
1915
</INDEX>
1920
</INDEX>
1916
</INDICES>
1921
</INDICES>
1917
</TABLE>
1922
</TABLE>
1918
<TABLE ID="21634" Tablename="coel_projet_version" PrevTableName="eflore_projet_version" XPos="364" YPos="672" 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="Table contenant les informations sur la version d\aun projet." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="11447" OrderPos="4" >
1923
<TABLE ID="21634" Tablename="coel_projet_version" PrevTableName="eflore_projet_version" XPos="364" YPos="672" 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="Table contenant les informations sur la version d\aun projet.\nINFO : cprv_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="11447" OrderPos="4" >
1919
<COLUMNS>
1924
<COLUMNS>
1920
<COLUMN ID="21635" ColName="cprv_id_version" PrevColName="eprv_id_version" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune version de projet.">
1925
<COLUMN ID="21635" ColName="cprv_id_version" PrevColName="eprv_id_version" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune version de projet.">
1921
<OPTIONSELECTED>
1926
<OPTIONSELECTED>
1922
<OPTIONSELECT Value="0" />
1927
<OPTIONSELECT Value="0" />
1923
<OPTIONSELECT Value="0" />
1928
<OPTIONSELECT Value="0" />
Line 1969... Line 1974...
1969
<INDEXCOLUMN idColumn="21635" LengthParam="0" />
1974
<INDEXCOLUMN idColumn="21635" LengthParam="0" />
1970
</INDEXCOLUMNS>
1975
</INDEXCOLUMNS>
1971
</INDEX>
1976
</INDEX>
1972
</INDICES>
1977
</INDICES>
1973
</TABLE>
1978
</TABLE>
1974
<TABLE ID="21757" Tablename="coel_meta_historique_ligne" PrevTableName="Table_22" XPos="1192" YPos="142" 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="Contient les m\195\169tadonn\195\169es sur l\ahistorique des enregistrements des tables de la base de donn\195\169es." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="37" >
1979
<TABLE ID="21757" Tablename="coel_meta_historique_ligne" PrevTableName="Table_22" XPos="1192" YPos="142" 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="Contient les m\195\169tadonn\195\169es sur l\ahistorique des enregistrements des tables de la base de donn\195\169es.\nINFO : cmhl_date_modification" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="37" >
1975
<COLUMNS>
1980
<COLUMNS>
1976
<COLUMN ID="21759" ColName="cmhl_id_historique_ligne" PrevColName="cmhl_id_historisque_ligne" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de l\ahistorique des lignes.">
1981
<COLUMN ID="21759" ColName="cmhl_id_historique_ligne" PrevColName="cmhl_id_historisque_ligne" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de l\ahistorique des lignes.">
1977
<OPTIONSELECTED>
1982
<OPTIONSELECTED>
1978
<OPTIONSELECT Value="1" />
1983
<OPTIONSELECT Value="1" />
1979
<OPTIONSELECT Value="0" />
1984
<OPTIONSELECT Value="0" />