Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 29 Rev 32
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="1779" 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="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="384" 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="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: 29 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="73" />
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: 32 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="73" />
262
<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: 29 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="62" />
262
<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: 32 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="62" />
263
<REGION ID="18447" RegionName="M\195\169tadonn\195\169es" XPos="20" YPos="16" Width="1464" Height="475" 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: 29 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
263
<REGION ID="18447" RegionName="M\195\169tadonn\195\169es" XPos="20" YPos="16" Width="1464" Height="475" 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: 32 $" 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: 29 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
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: 32 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
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: 29 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
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: 32 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
266
<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: 29 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
266
<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: 32 $" 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="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" >
270
<COLUMNS>
270
<COLUMNS>
271
<COLUMN ID="1449" ColName="cc_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" 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="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la collection.">
Line 666... Line 666...
666
<OPTIONSELECTED>
666
<OPTIONSELECTED>
667
<OPTIONSELECT Value="1" />
667
<OPTIONSELECT Value="1" />
668
<OPTIONSELECT Value="0" />
668
<OPTIONSELECT Value="0" />
669
</OPTIONSELECTED>
669
</OPTIONSELECTED>
670
</COLUMN>
670
</COLUMN>
671
<COLUMN ID="1458" ColName="cp_fmt_nom_complet" PrevColName="cco_nom_complet" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom complet du contact format\195\169 pour l\aaffichage avec : pr\195\169fixe+\A \A+Pr\195\169nom+\A \A+NOM+\A \A+suffixe">
671
<COLUMN ID="1458" ColName="cp_fmt_nom_complet" PrevColName="cco_nom_complet" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom complet du contact format\195\169 pour l\aaffichage (le format peut \195\170tre diff\195\169rent en fonction du projet).">
672
<OPTIONSELECTED>
672
<OPTIONSELECTED>
673
<OPTIONSELECT Value="0" />
673
<OPTIONSELECT Value="0" />
674
</OPTIONSELECTED>
674
</OPTIONSELECTED>
675
</COLUMN>
675
</COLUMN>
676
<COLUMN ID="1462" ColName="cp_ce_truk_prefix" PrevColName="cco_prefix" Pos="5" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169fixe du nom principal. Exemple : Dr, Mr.">
676
<COLUMN ID="1462" ColName="cp_ce_truk_prefix" PrevColName="cco_prefix" Pos="5" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169fixe du nom principal. Exemple : Dr., Prof., Mr., Lord, von...">
677
<OPTIONSELECTED>
677
<OPTIONSELECTED>
678
<OPTIONSELECT Value="0" />
678
<OPTIONSELECT Value="0" />
679
</OPTIONSELECTED>
679
</OPTIONSELECTED>
680
</COLUMN>
680
</COLUMN>
681
<COLUMN ID="1460" ColName="cp_prenom" PrevColName="cco_prenom" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169nom principal (le plus connu, r\195\169pandu) de la personne. Un point virgul peut s\195\169parer le pr\195\169nom principal de pr\195\169noms secondaires \195\160 ne pas afficher dans le nom complet.">
681
<COLUMN ID="1460" ColName="cp_prenom" PrevColName="cco_prenom" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169nom principal (le plus connu, r\195\169pandu) de la personne. Un point virgule peut s\195\169parer le pr\195\169nom principal de pr\195\169noms secondaires \195\160 ne pas afficher dans le nom complet.">
682
<OPTIONSELECTED>
682
<OPTIONSELECTED>
683
<OPTIONSELECT Value="0" />
683
<OPTIONSELECT Value="0" />
684
</OPTIONSELECTED>
684
</OPTIONSELECTED>
685
</COLUMN>
685
</COLUMN>
686
<COLUMN ID="1459" ColName="cp_nom" PrevColName="cco_nom" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de famille principal (le plus connu, r\195\169pandu). Un point virgule peut s\195\169parer le nom principal de noms secondaires \195\160 ne pas afficher dans le nom complet.">
686
<COLUMN ID="1459" ColName="cp_nom" PrevColName="cco_nom" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer les lieux de r\195\169colte (code ISO des pays) s\195\169par\195\169s par des points virgules. Apr\195\168s chaque code ISO indiqu\195\169 les ann\195\169es de r\195\169colte s\195\169par\195\169es par des vigules ou des tirets pour les p\195\169riodes continues). Si le pays de r\195\169colte est inconnu utilis\195\169 un point d\ainterogration. Exemple : FR#1905-1908,1910;PS#1912.">
687
<OPTIONSELECTED>
687
<OPTIONSELECTED>
688
<OPTIONSELECT Value="0" />
688
<OPTIONSELECT Value="0" />
689
</OPTIONSELECTED>
689
</OPTIONSELECTED>
690
</COLUMN>
690
</COLUMN>
691
<COLUMN ID="1463" ColName="cp_ce_truk_suffix" PrevColName="cco_suffix" Pos="6" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Suffixe du nom principal. Exemple : Jr, III.">
691
<COLUMN ID="1463" ColName="cp_ce_truk_suffix" PrevColName="cco_suffix" Pos="6" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Suffixe du nom principal. Exemple : Jr, III.">
692
<OPTIONSELECTED>
692
<OPTIONSELECTED>
693
<OPTIONSELECT Value="0" />
693
<OPTIONSELECT Value="0" />
694
</OPTIONSELECTED>
694
</OPTIONSELECTED>
695
</COLUMN>
695
</COLUMN>
696
<COLUMN ID="1461" ColName="cp_truk_nom_autre" PrevColName="cco_nom_complement" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom(s) complet alternatif. Pour les valeurs, s\195\169parez l\aidentifiant de l\aabreviation par un symbole pipe \A|\A. Exemple: HUH#105714|Sharp, Aaron John;APN#9544-1|Sharp, Aaron John (\aJack\a)">
696
<COLUMN ID="1461" ColName="cp_truk_nom_autre" PrevColName="cco_nom_complement" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom(s) complet alternatif et surnoms. Pour les valeurs, s\195\169parez l\aidentifiant de l\aabreviation par un symbole pipe \A|\A. Exemple: HUH#105714|Sharp, Aaron John;APN#9544-1|Sharp, Aaron John (\aJack\a)">
697
<OPTIONSELECTED>
697
<OPTIONSELECTED>
698
<OPTIONSELECT Value="0" />
698
<OPTIONSELECT Value="0" />
699
</OPTIONSELECTED>
699
</OPTIONSELECTED>
700
</COLUMN>
700
</COLUMN>
701
<COLUMN ID="21132" ColName="cp_abreviation" PrevColName="" Pos="35" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abreviation retenu du nom.">
701
<COLUMN ID="21132" ColName="cp_abreviation" PrevColName="" Pos="35" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abreviation retenu du nom.">
702
<OPTIONSELECTED>
702
<OPTIONSELECTED>
703
<OPTIONSELECT Value="0" />
703
<OPTIONSELECT Value="0" />
704
</OPTIONSELECTED>
704
</OPTIONSELECTED>
705
</COLUMN>
705
</COLUMN>
706
<COLUMN ID="21133" ColName="cp_truk_abreviation_autre" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres abr\195\169viations du nom. Pour les valeurs, s\195\169parez l\aidentifiant de l\aabreviation par un symbole pipe \A|\A. Exemple: HUH#105714|A. J. Sharp;APN#9544-1|Sharp">
706
<COLUMN ID="21133" ColName="cp_truk_abreviation_autre" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres abr\195\169viations du nom.">
707
<OPTIONSELECTED>
707
<OPTIONSELECTED>
708
<OPTIONSELECT Value="0" />
708
<OPTIONSELECT Value="0" />
709
</OPTIONSELECTED>
709
</OPTIONSELECTED>
710
</COLUMN>
710
</COLUMN>
711
<COLUMN ID="21123" ColName="cp_naissance_date" PrevColName="cp_date_naissance" Pos="30" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de naissance de la personne.">
711
<COLUMN ID="21123" ColName="cp_naissance_date" PrevColName="cp_date_naissance" Pos="30" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de naissance de la personne.">
712
<OPTIONSELECTED>
712
<OPTIONSELECTED>
713
</OPTIONSELECTED>
713
</OPTIONSELECTED>
714
</COLUMN>
714
</COLUMN>
715
<COLUMN ID="21126" ColName="cp_naissance_lieu" PrevColName="" Pos="32" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres abr\195\169viations du nom. Pour les valeurs, s\195\169parez l\aidentifiant de l\aabreviation par un symbole pipe \A|\A. Exemple: HUH#105714|A. J. Sharp;APN#9544-1|Sharp;BP#?|Sharp">
715
<COLUMN ID="21126" ColName="cp_naissance_lieu" PrevColName="" Pos="32" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Lieu de naissance de la personne.">
716
<OPTIONSELECTED>
716
<OPTIONSELECTED>
717
<OPTIONSELECT Value="0" />
717
<OPTIONSELECT Value="0" />
718
</OPTIONSELECTED>
718
</OPTIONSELECTED>
719
</COLUMN>
719
</COLUMN>
720
<COLUMN ID="21124" ColName="cp_deces_date" PrevColName="cp_date_deces" Pos="31" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de d\195\169c\195\169s de la personne. Par d\195\169faut, si la personne n\aest pas d\195\169c\195\169d\195\169 le champ reste null. Si la personne est d\195\169c\195\169d\195\169e mais que l\aon ne connait pas la date mettre : 0000-00-00">
720
<COLUMN ID="21124" ColName="cp_deces_date" PrevColName="cp_date_deces" Pos="31" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de d\195\169c\195\169s de la personne. Par d\195\169faut, si la personne n\aest pas d\195\169c\195\169d\195\169 le champ reste null. Si la personne est d\195\169c\195\169d\195\169e mais que l\aon ne connait pas la date mettre : 0000-00-00">
Line 793... Line 793...
793
<COLUMN ID="18436" ColName="cp_ce_truk_specialite" PrevColName="cp_bota_specialite" Pos="29" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer s\195\169parer par des points virgules \A;\A les sp\195\169cialit\195\169s naturalistes de la personne.">
793
<COLUMN ID="18436" ColName="cp_ce_truk_specialite" PrevColName="cp_bota_specialite" Pos="29" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer s\195\169parer par des points virgules \A;\A les sp\195\169cialit\195\169s naturalistes de la personne.">
794
<OPTIONSELECTED>
794
<OPTIONSELECTED>
795
<OPTIONSELECT Value="0" />
795
<OPTIONSELECT Value="0" />
796
</OPTIONSELECTED>
796
</OPTIONSELECTED>
797
</COLUMN>
797
</COLUMN>
798
<COLUMN ID="21129" ColName="cp_truk_recolte" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer les lieux de r\195\169colte (code ISO des pays) s\195\169par\195\169s par des points virgules. Apr\195\168s chaque code ISO indiqu\195\169 les ann\195\169es de r\195\169colte s\195\169par\195\169es par des vigules ou des tirets pour les p\195\169riodes continues). Si le pays de r\195\169colte est inconnu utilis\195\169 un point d\ainterogration. Exemple : FR#1905-1908,1910;PS#1912.">
798
<COLUMN ID="21129" ColName="cp_truk_recolte" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer les lieux de r\195\169colte s\195\169par\195\169s par des points virgules. Indiquer le r\195\169f\195\169rentiel g\195\169ographique utilis\195\169 puis apr\195\168s un # mettre le code ou identitifiant de la zone g\195\169ographique. Apr\195\168s chaque code ISO un peut signe pipe | peut \195\170tre suivi des ann\195\169es de r\195\169colte s\195\169par\195\169es par des vigules ou des tirets pour les p\195\169riodes continues). Si le pays de r\195\169colte est inconnu utilis\195\169 un point d\ainterogration. Exemple : ISO-3166-1#FR|1905-1908,1910;ISO-3166-1#PS|1912;ISO-3166-2#FR-34|1917.">
799
<OPTIONSELECTED>
799
<OPTIONSELECTED>
800
<OPTIONSELECT Value="0" />
800
<OPTIONSELECT Value="0" />
801
</OPTIONSELECTED>
801
</OPTIONSELECTED>
802
</COLUMN>
802
</COLUMN>
803
<COLUMN ID="21554" ColName="cp_ce_truk_role" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le g\195\169n\195\169rale de la personne vis \195\160 vis de l\aensemble des projets : superadmin, admin...">
803
<COLUMN ID="21554" ColName="cp_ce_truk_role" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le g\195\169n\195\169rale de la personne vis \195\160 vis de l\aensemble des projets : superadmin, admin...">