| 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="BDD_NOM : tb_coel" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="92.00" XPos="0" YPos="552" 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 : tb_coel" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="92.00" XPos="733" YPos="864" 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 258... |
Line 258... |
| 258 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
258 |
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
|
| 259 |
</POSITIONMARKERS>
|
259 |
</POSITIONMARKERS>
|
| 260 |
</SETTINGS>
|
260 |
</SETTINGS>
|
| 261 |
<METADATA>
|
261 |
<METADATA>
|
| 262 |
<REGIONS>
|
262 |
<REGIONS>
|
| 263 |
<REGION ID="21985" RegionName="Commentaire" XPos="790" YPos="2355" Width="694" Height="287" RegionColor="6" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module contenant les tables permettant de g\195\169rer les commentaires.\nAbreviation : CCM\nAide : OK\nEtat: OK\nRevision : $Revision: 274 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" />
|
263 |
<REGION ID="21985" RegionName="Commentaire" XPos="790" YPos="2355" Width="694" Height="287" RegionColor="6" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module contenant les tables permettant de g\195\169rer les commentaires.\nAbreviation : CCM\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" />
|
| 264 |
<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: 274 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
|
264 |
<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: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
|
| 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: 274 $" 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: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
|
| 266 |
<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: 274 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
|
266 |
<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: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
|
| 267 |
<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: 274 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
|
267 |
<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: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
|
| 268 |
<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: 274 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" />
|
268 |
<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: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" />
|
| 269 |
<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: 274 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" />
|
269 |
<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: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" />
|
| 270 |
</REGIONS>
|
270 |
</REGIONS>
|
| 271 |
<TABLES>
|
271 |
<TABLES>
|
| 272 |
<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" >
|
272 |
<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" >
|
| 273 |
<COLUMNS>
|
273 |
<COLUMNS>
|
| 274 |
<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.">
|
274 |
<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.">
|
| Line 329... |
Line 329... |
| 329 |
</COLUMN>
|
329 |
</COLUMN>
|
| 330 |
<COLUMN ID="21187" ColName="cc_historique" PrevColName="" Pos="20" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Historique de la collection (acquisition, diff\195\169rentes interventions de restauration, de traitement ...).">
|
330 |
<COLUMN ID="21187" ColName="cc_historique" PrevColName="" Pos="20" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Historique de la collection (acquisition, diff\195\169rentes interventions de restauration, de traitement ...).">
|
| 331 |
<OPTIONSELECTED>
|
331 |
<OPTIONSELECTED>
|
| 332 |
</OPTIONSELECTED>
|
332 |
</OPTIONSELECTED>
|
| 333 |
</COLUMN>
|
333 |
</COLUMN>
|
| 334 |
<COLUMN ID="21182" ColName="cc_truk_url" PrevColName="cc_url" Pos="18" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) du site web ou de la page concernant la collection.">
|
334 |
<COLUMN ID="21182" ColName="cc_truk_url" PrevColName="cc_url" Pos="18" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) du site web ou de la page concernant la collection (WEB), d\aun web service (WS) ou d\aune page permettant d\aacc\195\168der \195\160 des informations sur les objets de la collection (OBJ).">
|
| 335 |
<OPTIONSELECTED>
|
335 |
<OPTIONSELECTED>
|
| 336 |
<OPTIONSELECT Value="0" />
|
- |
|
| 337 |
</OPTIONSELECTED>
|
- |
|
| 338 |
</COLUMN>
|
- |
|
| 339 |
<COLUMN ID="21333" ColName="cc_truk_url_objet" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) indiquant un web service ou une page permettant d\aacc\195\168der \195\160 des informations sur les objets de la collection.">
|
- |
|
| 340 |
<OPTIONSELECTED>
|
- |
|
| 341 |
<OPTIONSELECT Value="0" />
|
- |
|
| 342 |
</OPTIONSELECTED>
|
336 |
</OPTIONSELECTED>
|
| 343 |
</COLUMN>
|
337 |
</COLUMN>
|
| 344 |
<COLUMN ID="21262" ColName="cc_truk_groupement_principe" PrevColName="cc_ce_truk_principe_groupe" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Principal but de groupement de la collection au niveau int\195\169lectuel plut\195\180t que physique.">
|
338 |
<COLUMN ID="21262" ColName="cc_truk_groupement_principe" PrevColName="cc_ce_truk_principe_groupe" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Principal but de groupement de la collection au niveau int\195\169lectuel plut\195\180t que physique.">
|
| 345 |
<OPTIONSELECTED>
|
339 |
<OPTIONSELECTED>
|
| 346 |
<OPTIONSELECT Value="0" />
|
340 |
<OPTIONSELECT Value="0" />
|
| Line 595... |
Line 589... |
| 595 |
<COLUMN ID="20782" ColName="cs_ville" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Ville.">
|
589 |
<COLUMN ID="20782" ColName="cs_ville" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Ville.">
|
| 596 |
<OPTIONSELECTED>
|
590 |
<OPTIONSELECTED>
|
| 597 |
<OPTIONSELECT Value="0" />
|
591 |
<OPTIONSELECT Value="0" />
|
| 598 |
</OPTIONSELECTED>
|
592 |
</OPTIONSELECTED>
|
| 599 |
</COLUMN>
|
593 |
</COLUMN>
|
| 600 |
<COLUMN ID="20783" ColName="cs_region" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la r\195\169gion (\195\169tat, province) o\195\185 est situ\195\169 la structure. Utiliser les noms du standard ISO-3166-2.">
|
594 |
<COLUMN ID="20783" ColName="cs_ce_truk_region" PrevColName="cs_region" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom de la r\195\169gion (\195\169tat, province) o\195\185 est situ\195\169 la structure. Utiliser les noms du standard ISO-3166-2. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-2. ">
|
| 601 |
<OPTIONSELECTED>
|
595 |
<OPTIONSELECTED>
|
| 602 |
<OPTIONSELECT Value="0" />
|
596 |
<OPTIONSELECT Value="0" />
|
| 603 |
</OPTIONSELECTED>
|
597 |
</OPTIONSELECTED>
|
| 604 |
</COLUMN>
|
598 |
</COLUMN>
|
| 605 |
<COLUMN ID="20784" ColName="cs_pays" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pays de la structure. Utiliser les codes sur deux lettres si le nom est dans le standard ISO-3166-1 sinon mettre le nom du pays.">
|
599 |
<COLUMN ID="20784" ColName="cs_ce_truk_pays" PrevColName="cs_pays" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom du pays de la structure. Utiliser les noms du standard ISO-3166-1. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-1.">
|
| 606 |
<OPTIONSELECTED>
|
600 |
<OPTIONSELECTED>
|
| 607 |
<OPTIONSELECT Value="0" />
|
601 |
<OPTIONSELECT Value="0" />
|
| 608 |
</OPTIONSELECTED>
|
602 |
</OPTIONSELECTED>
|
| 609 |
</COLUMN>
|
603 |
</COLUMN>
|
| 610 |
<COLUMN ID="27881" ColName="cs_latitude" PrevColName="" Pos="27" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Latitude du local de la structure.">
|
604 |
<COLUMN ID="27881" ColName="cs_latitude" PrevColName="" Pos="27" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Latitude du local de la structure.">
|
| Line 615... |
Line 609... |
| 615 |
<COLUMN ID="27882" ColName="cs_longitude" PrevColName="" Pos="28" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Longitude du local de la structure.">
|
609 |
<COLUMN ID="27882" ColName="cs_longitude" PrevColName="" Pos="28" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Longitude du local de la structure.">
|
| 616 |
<OPTIONSELECTED>
|
610 |
<OPTIONSELECTED>
|
| 617 |
<OPTIONSELECT Value="0" />
|
611 |
<OPTIONSELECT Value="0" />
|
| 618 |
</OPTIONSELECTED>
|
612 |
</OPTIONSELECTED>
|
| 619 |
</COLUMN>
|
613 |
</COLUMN>
|
| 620 |
<COLUMN ID="20785" ColName="cs_telephone" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="T\195\169l\195\169phone principale de la structure.">
|
614 |
<COLUMN ID="20785" ColName="cs_truk_telephone" PrevColName="cs_telephone" Pos="14" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="T\195\169l\195\169phone(s) principaux de la structure (fixe, fax, portable...).">
|
| 621 |
<OPTIONSELECTED>
|
- |
|
| 622 |
<OPTIONSELECT Value="0" />
|
- |
|
| 623 |
</OPTIONSELECTED>
|
- |
|
| 624 |
</COLUMN>
|
- |
|
| 625 |
<COLUMN ID="20786" ColName="cs_fax" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Fax de la structure.">
|
- |
|
| 626 |
<OPTIONSELECTED>
|
615 |
<OPTIONSELECTED>
|
| 627 |
<OPTIONSELECT Value="0" />
|
616 |
<OPTIONSELECT Value="0" />
|
| 628 |
</OPTIONSELECTED>
|
617 |
</OPTIONSELECTED>
|
| 629 |
</COLUMN>
|
618 |
</COLUMN>
|
| 630 |
<COLUMN ID="20787" ColName="cs_courriel" PrevColName="" Pos="16" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Courriel principal de contact de l\aorganisation ex : accueil@organisation.org, pas de mail individuel.">
|
619 |
<COLUMN ID="20787" ColName="cs_courriel" PrevColName="" Pos="16" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Courriel principal de contact de l\aorganisation ex : accueil@organisation.org, pas de mail individuel.">
|
| Line 748... |
Line 737... |
| 748 |
<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.">
|
737 |
<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.">
|
| 749 |
<OPTIONSELECTED>
|
738 |
<OPTIONSELECTED>
|
| 750 |
<OPTIONSELECT Value="0" />
|
739 |
<OPTIONSELECT Value="0" />
|
| 751 |
</OPTIONSELECTED>
|
740 |
</OPTIONSELECTED>
|
| 752 |
</COLUMN>
|
741 |
</COLUMN>
|
| - |
|
742 |
<COLUMN ID="27943" ColName="cp_ce_deces" PrevColName="" Pos="40" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Permet de savoir si la personne est d\195\169c\195\169d\195\169e ou pas, ou que l\ainformation est ind\195\169termin\195\169e.">
|
| - |
|
743 |
<OPTIONSELECTED>
|
| - |
|
744 |
<OPTIONSELECT Value="1" />
|
| - |
|
745 |
<OPTIONSELECT Value="0" />
|
| - |
|
746 |
</OPTIONSELECTED>
|
| - |
|
747 |
</COLUMN>
|
| 753 |
<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">
|
748 |
<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">
|
| 754 |
<OPTIONSELECTED>
|
749 |
<OPTIONSELECTED>
|
| 755 |
</OPTIONSELECTED>
|
750 |
</OPTIONSELECTED>
|
| 756 |
</COLUMN>
|
751 |
</COLUMN>
|
| 757 |
<COLUMN ID="21127" ColName="cp_deces_lieu" PrevColName="" Pos="33" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Lieu de d\195\169c\195\169s de la personne.">
|
752 |
<COLUMN ID="21127" ColName="cp_deces_lieu" PrevColName="" Pos="33" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Lieu de d\195\169c\195\169s de la personne.">
|
| Line 781... |
Line 776... |
| 781 |
<COLUMN ID="18391" ColName="cp_adresse_02" PrevColName="cco_perso_adresse_complement" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Compl\195\169ment d\aadresse personnelle.">
|
776 |
<COLUMN ID="18391" ColName="cp_adresse_02" PrevColName="cco_perso_adresse_complement" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Compl\195\169ment d\aadresse personnelle.">
|
| 782 |
<OPTIONSELECTED>
|
777 |
<OPTIONSELECTED>
|
| 783 |
<OPTIONSELECT Value="0" />
|
778 |
<OPTIONSELECT Value="0" />
|
| 784 |
</OPTIONSELECTED>
|
779 |
</OPTIONSELECTED>
|
| 785 |
</COLUMN>
|
780 |
</COLUMN>
|
| 786 |
<COLUMN ID="18394" ColName="cp_region" PrevColName="cco_perso_region" Pos="15" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la r\195\169gion (\195\169tat, province) o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-2.">
|
781 |
<COLUMN ID="18394" ColName="cp_ce_truk_region" PrevColName="cco_perso_region" Pos="15" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom de la r\195\169gion (\195\169tat, province) o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-2. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-2.">
|
| 787 |
<OPTIONSELECTED>
|
782 |
<OPTIONSELECTED>
|
| 788 |
<OPTIONSELECT Value="0" />
|
783 |
<OPTIONSELECT Value="0" />
|
| 789 |
</OPTIONSELECTED>
|
784 |
</OPTIONSELECTED>
|
| 790 |
</COLUMN>
|
785 |
</COLUMN>
|
| 791 |
<COLUMN ID="18390" ColName="cp_bp" PrevColName="cco_perso_bp" Pos="11" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Boite postale de l\aadresse de la personne.">
|
786 |
<COLUMN ID="18390" ColName="cp_bp" PrevColName="cco_perso_bp" Pos="11" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Boite postale de l\aadresse de la personne.">
|
| Line 801... |
Line 796... |
| 801 |
<COLUMN ID="18393" ColName="cp_ville" PrevColName="cco_perso_ville" Pos="14" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la localit\195\169 (ville) o\195\185 vit la personne.">
|
796 |
<COLUMN ID="18393" ColName="cp_ville" PrevColName="cco_perso_ville" Pos="14" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la localit\195\169 (ville) o\195\185 vit la personne.">
|
| 802 |
<OPTIONSELECTED>
|
797 |
<OPTIONSELECTED>
|
| 803 |
<OPTIONSELECT Value="0" />
|
798 |
<OPTIONSELECT Value="0" />
|
| 804 |
</OPTIONSELECTED>
|
799 |
</OPTIONSELECTED>
|
| 805 |
</COLUMN>
|
800 |
</COLUMN>
|
| 806 |
<COLUMN ID="18396" ColName="cp_pays" PrevColName="cco_perso_pays" Pos="17" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du pays o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-1.">
|
801 |
<COLUMN ID="18396" ColName="cp_ce_truk_pays" PrevColName="cco_perso_pays" Pos="17" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du pays o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-1. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-1.">
|
| 807 |
<OPTIONSELECTED>
|
- |
|
| 808 |
<OPTIONSELECT Value="0" />
|
- |
|
| 809 |
</OPTIONSELECTED>
|
- |
|
| 810 |
</COLUMN>
|
- |
|
| 811 |
<COLUMN ID="18400" ColName="cp_truk_telephone" PrevColName="cco_perso_tel_complement" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro(s) de t\195\169l\195\169phone, pager... personnels compl\195\169mentaires.">
|
- |
|
| 812 |
<OPTIONSELECTED>
|
802 |
<OPTIONSELECTED>
|
| 813 |
<OPTIONSELECT Value="0" />
|
803 |
<OPTIONSELECT Value="0" />
|
| 814 |
</OPTIONSELECTED>
|
804 |
</OPTIONSELECTED>
|
| 815 |
</COLUMN>
|
805 |
</COLUMN>
|
| 816 |
<COLUMN ID="21173" ColName="cp_truk_fax" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro(s) de fax.">
|
806 |
<COLUMN ID="18400" ColName="cp_truk_telephone" PrevColName="cco_perso_tel_complement" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro(s) de t\195\169l\195\169phone fixe (FIX), portable (GSM), Fax (FAX), pager (PAG)... personnels.">
|
| 817 |
<OPTIONSELECTED>
|
807 |
<OPTIONSELECTED>
|
| 818 |
<OPTIONSELECT Value="0" />
|
808 |
<OPTIONSELECT Value="0" />
|
| 819 |
</OPTIONSELECTED>
|
809 |
</OPTIONSELECTED>
|
| 820 |
</COLUMN>
|
810 |
</COLUMN>
|
| 821 |
<COLUMN ID="18401" ColName="cp_truk_courriel" PrevColName="cco_perso_courriel" Pos="22" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse(s) de courriel personnel. Ajouter les adresses dans leur ordre d\aimportance.">
|
811 |
<COLUMN ID="18401" ColName="cp_truk_courriel" PrevColName="cco_perso_courriel" Pos="22" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse(s) de courriel personnel. Ajouter les adresses dans leur ordre d\aimportance.">
|
| Line 826... |
Line 816... |
| 826 |
<COLUMN ID="18402" ColName="cp_truk_url" PrevColName="cco_perso_url" Pos="23" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) de site web personnel. Ajouter les adresses dans leur ordre d\aimportance.">
|
816 |
<COLUMN ID="18402" ColName="cp_truk_url" PrevColName="cco_perso_url" Pos="23" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) de site web personnel. Ajouter les adresses dans leur ordre d\aimportance.">
|
| 827 |
<OPTIONSELECTED>
|
817 |
<OPTIONSELECTED>
|
| 828 |
<OPTIONSELECT Value="0" />
|
818 |
<OPTIONSELECT Value="0" />
|
| 829 |
</OPTIONSELECTED>
|
819 |
</OPTIONSELECTED>
|
| 830 |
</COLUMN>
|
820 |
</COLUMN>
|
| 831 |
<COLUMN ID="18403" ColName="cp_truk_logo" PrevColName="cco_perso_logo" Pos="24" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) de logo personnel. Ajouter les adresses dans leur ordre d\aimportance.">
|
821 |
<COLUMN ID="18403" ColName="cp_truk_logo" PrevColName="cco_perso_logo" Pos="24" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) des logo, avatar, portrait ou photo de la personne. Ajouter les URL(s) dans leur ordre d\aimportance.">
|
| 832 |
<OPTIONSELECTED>
|
822 |
<OPTIONSELECTED>
|
| 833 |
<OPTIONSELECT Value="0" />
|
823 |
<OPTIONSELECT Value="0" />
|
| 834 |
</OPTIONSELECTED>
|
824 |
</OPTIONSELECTED>
|
| 835 |
</COLUMN>
|
825 |
</COLUMN>
|
| 836 |
<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="1" DefaultValue="" Comments="Indiquer s\195\169parer par des points virgules \A;\A les sp\195\169cialit\195\169s naturalistes de la personne.">
|
826 |
<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="1" DefaultValue="" Comments="Indiquer s\195\169parer par des points virgules \A;\A les sp\195\169cialit\195\169s naturalistes de la personne.">
|