| 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="1392" 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="0" YPos="888" 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="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: 833 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" />
|
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: 859 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" />
|
| 264 |
<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: 833 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" />
|
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: 859 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
|
| 265 |
<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: 833 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
|
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: 859 $" 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: 833 $" 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: 859 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
|
| 267 |
<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: 833 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
|
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: 859 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
|
| 268 |
<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: 833 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
|
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: 859 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" />
|
| 269 |
<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: 833 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" />
|
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: 859 $" 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 441... |
Line 441... |
| 441 |
<OPTIONSELECTED>
|
441 |
<OPTIONSELECTED>
|
| 442 |
<OPTIONSELECT Value="1" />
|
442 |
<OPTIONSELECT Value="1" />
|
| 443 |
<OPTIONSELECT Value="0" />
|
443 |
<OPTIONSELECT Value="0" />
|
| 444 |
</OPTIONSELECTED>
|
444 |
</OPTIONSELECTED>
|
| 445 |
</COLUMN>
|
445 |
</COLUMN>
|
| 446 |
<COLUMN ID="21507" ColName="cc_mark_speciment_type_nbre_precision" PrevColName="cc_ce_speciment_type_nbre_precision" Pos="41" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169cision sur le nombre de sp\195\169cimens types indiqu\195\169 (1 = exact, 0 = approximatif).">
|
446 |
<COLUMN ID="27961" ColName="cp_ce_specimen_type_nbre_precision" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Pr\195\169cision sur le nombre de sp\195\169cimens types indiqu\195\169 (exact, approximatif).">
|
| 447 |
<OPTIONSELECTED>
|
447 |
<OPTIONSELECTED>
|
| - |
|
448 |
<OPTIONSELECT Value="1" />
|
| - |
|
449 |
<OPTIONSELECT Value="0" />
|
| 448 |
</OPTIONSELECTED>
|
450 |
</OPTIONSELECTED>
|
| 449 |
</COLUMN>
|
451 |
</COLUMN>
|
| 450 |
<COLUMN ID="21508" ColName="cc_ce_specimen_type_classement" PrevColName="" Pos="42" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type de classement des specimens types.">
|
452 |
<COLUMN ID="21508" ColName="cc_ce_specimen_type_classement" PrevColName="" Pos="42" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type de classement des specimens types.">
|
| 451 |
<OPTIONSELECTED>
|
453 |
<OPTIONSELECTED>
|
| 452 |
<OPTIONSELECT Value="1" />
|
454 |
<OPTIONSELECT Value="1" />
|
| Line 496... |
Line 498... |
| 496 |
<RELATION_END ID="22158" />
|
498 |
<RELATION_END ID="22158" />
|
| 497 |
<RELATION_END ID="22160" />
|
499 |
<RELATION_END ID="22160" />
|
| 498 |
<RELATION_END ID="22162" />
|
500 |
<RELATION_END ID="22162" />
|
| 499 |
<RELATION_END ID="22164" />
|
501 |
<RELATION_END ID="22164" />
|
| 500 |
<RELATION_END ID="27872" />
|
502 |
<RELATION_END ID="27872" />
|
| - |
|
503 |
<RELATION_END ID="27959" />
|
| 501 |
</RELATIONS_END>
|
504 |
</RELATIONS_END>
|
| 502 |
<INDICES>
|
505 |
<INDICES>
|
| 503 |
<INDEX ID="1450" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
506 |
<INDEX ID="1450" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
| 504 |
<INDEXCOLUMNS>
|
507 |
<INDEXCOLUMNS>
|
| 505 |
<INDEXCOLUMN idColumn="1449" LengthParam="0" />
|
508 |
<INDEXCOLUMN idColumn="1449" LengthParam="0" />
|
| Line 737... |
Line 740... |
| 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.">
|
740 |
<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.">
|
| 738 |
<OPTIONSELECTED>
|
741 |
<OPTIONSELECTED>
|
| 739 |
<OPTIONSELECT Value="0" />
|
742 |
<OPTIONSELECT Value="0" />
|
| 740 |
</OPTIONSELECTED>
|
743 |
</OPTIONSELECTED>
|
| 741 |
</COLUMN>
|
744 |
</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.">
|
745 |
<COLUMN ID="27943" ColName="cp_ce_deces" PrevColName="" Pos="40" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" 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>
|
746 |
<OPTIONSELECTED>
|
| 744 |
<OPTIONSELECT Value="1" />
|
747 |
<OPTIONSELECT Value="1" />
|
| 745 |
<OPTIONSELECT Value="0" />
|
748 |
<OPTIONSELECT Value="0" />
|
| 746 |
</OPTIONSELECTED>
|
749 |
</OPTIONSELECTED>
|
| 747 |
</COLUMN>
|
750 |
</COLUMN>
|
| Line 776... |
Line 779... |
| 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.">
|
779 |
<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.">
|
| 777 |
<OPTIONSELECTED>
|
780 |
<OPTIONSELECTED>
|
| 778 |
<OPTIONSELECT Value="0" />
|
781 |
<OPTIONSELECT Value="0" />
|
| 779 |
</OPTIONSELECTED>
|
782 |
</OPTIONSELECTED>
|
| 780 |
</COLUMN>
|
783 |
</COLUMN>
|
| 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.">
|
784 |
<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="1" 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.">
|
| 782 |
<OPTIONSELECTED>
|
785 |
<OPTIONSELECTED>
|
| 783 |
<OPTIONSELECT Value="0" />
|
786 |
<OPTIONSELECT Value="0" />
|
| 784 |
</OPTIONSELECTED>
|
787 |
</OPTIONSELECTED>
|
| 785 |
</COLUMN>
|
788 |
</COLUMN>
|
| 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.">
|
789 |
<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 796... |
Line 799... |
| 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.">
|
799 |
<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.">
|
| 797 |
<OPTIONSELECTED>
|
800 |
<OPTIONSELECTED>
|
| 798 |
<OPTIONSELECT Value="0" />
|
801 |
<OPTIONSELECT Value="0" />
|
| 799 |
</OPTIONSELECTED>
|
802 |
</OPTIONSELECTED>
|
| 800 |
</COLUMN>
|
803 |
</COLUMN>
|
| 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.">
|
804 |
<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="1" 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.">
|
| 802 |
<OPTIONSELECTED>
|
805 |
<OPTIONSELECTED>
|
| 803 |
<OPTIONSELECT Value="0" />
|
806 |
<OPTIONSELECT Value="0" />
|
| 804 |
</OPTIONSELECTED>
|
807 |
</OPTIONSELECTED>
|
| 805 |
</COLUMN>
|
808 |
</COLUMN>
|
| 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.">
|
809 |
<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.">
|
| Line 892... |
Line 895... |
| 892 |
<RELATION_END ID="22099" />
|
895 |
<RELATION_END ID="22099" />
|
| 893 |
<RELATION_END ID="22101" />
|
896 |
<RELATION_END ID="22101" />
|
| 894 |
<RELATION_END ID="22133" />
|
897 |
<RELATION_END ID="22133" />
|
| 895 |
<RELATION_END ID="22135" />
|
898 |
<RELATION_END ID="22135" />
|
| 896 |
<RELATION_END ID="22137" />
|
899 |
<RELATION_END ID="22137" />
|
| - |
|
900 |
<RELATION_END ID="27948" />
|
| - |
|
901 |
<RELATION_END ID="27950" />
|
| - |
|
902 |
<RELATION_END ID="27952" />
|
| 897 |
</RELATIONS_END>
|
903 |
</RELATIONS_END>
|
| 898 |
<INDICES>
|
904 |
<INDICES>
|
| 899 |
<INDEX ID="1457" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
905 |
<INDEX ID="1457" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
| 900 |
<INDEXCOLUMNS>
|
906 |
<INDEXCOLUMNS>
|
| 901 |
<INDEXCOLUMN idColumn="1456" LengthParam="0" />
|
907 |
<INDEXCOLUMN idColumn="1456" LengthParam="0" />
|
| Line 1182... |
Line 1188... |
| 1182 |
<RELATION_START ID="27872" />
|
1188 |
<RELATION_START ID="27872" />
|
| 1183 |
<RELATION_START ID="27908" />
|
1189 |
<RELATION_START ID="27908" />
|
| 1184 |
<RELATION_START ID="27910" />
|
1190 |
<RELATION_START ID="27910" />
|
| 1185 |
<RELATION_START ID="27912" />
|
1191 |
<RELATION_START ID="27912" />
|
| 1186 |
<RELATION_START ID="27941" />
|
1192 |
<RELATION_START ID="27941" />
|
| - |
|
1193 |
<RELATION_START ID="27948" />
|
| - |
|
1194 |
<RELATION_START ID="27950" />
|
| - |
|
1195 |
<RELATION_START ID="27952" />
|
| - |
|
1196 |
<RELATION_START ID="27959" />
|
| 1187 |
</RELATIONS_START>
|
1197 |
</RELATIONS_START>
|
| 1188 |
<RELATIONS_END>
|
1198 |
<RELATIONS_END>
|
| 1189 |
<RELATION_END ID="21816" />
|
1199 |
<RELATION_END ID="21816" />
|
| 1190 |
<RELATION_END ID="21819" />
|
1200 |
<RELATION_END ID="21819" />
|
| 1191 |
<RELATION_END ID="21861" />
|
1201 |
<RELATION_END ID="21861" />
|
| Line 2168... |
Line 2178... |
| 2168 |
<COLUMN ID="21767" ColName="cmhl_notes" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur la modification effectu\195\169e sur la ligne.">
|
2178 |
<COLUMN ID="21767" ColName="cmhl_notes" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur la modification effectu\195\169e sur la ligne.">
|
| 2169 |
<OPTIONSELECTED>
|
2179 |
<OPTIONSELECTED>
|
| 2170 |
<OPTIONSELECT Value="0" />
|
2180 |
<OPTIONSELECT Value="0" />
|
| 2171 |
</OPTIONSELECTED>
|
2181 |
</OPTIONSELECTED>
|
| 2172 |
</COLUMN>
|
2182 |
</COLUMN>
|
| - |
|
2183 |
<COLUMN ID="27956" ColName="cmhl_source" PrevColName="" Pos="10" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Source des donn\195\169es de l\aenregistrement, si le cr\195\169ateur/modificateur de l\aenregistrement n\aen est pas l\aauteur.">
|
| - |
|
2184 |
<OPTIONSELECTED>
|
| - |
|
2185 |
</OPTIONSELECTED>
|
| - |
|
2186 |
</COLUMN>
|
| 2173 |
<COLUMN ID="21769" ColName="cmhl_ce_modifier_par" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 cette modification sur la ligne.">
|
2187 |
<COLUMN ID="21769" ColName="cmhl_ce_modifier_par" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 cette modification sur la ligne.">
|
| 2174 |
<OPTIONSELECTED>
|
2188 |
<OPTIONSELECTED>
|
| 2175 |
<OPTIONSELECT Value="1" />
|
2189 |
<OPTIONSELECT Value="1" />
|
| 2176 |
<OPTIONSELECT Value="0" />
|
2190 |
<OPTIONSELECT Value="0" />
|
| 2177 |
</OPTIONSELECTED>
|
2191 |
</OPTIONSELECTED>
|
| Line 2474... |
Line 2488... |
| 2474 |
<RELATION ID="27912" RelationName="fk_cmlv_cpr_idx_freq" Kind="2" SrcTable="18466" DestTable="21522" FKFields="cmlv_id_valeur=cpr_ce_indexation_freq\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="132" />
|
2488 |
<RELATION ID="27912" RelationName="fk_cmlv_cpr_idx_freq" Kind="2" SrcTable="18466" DestTable="21522" FKFields="cmlv_id_valeur=cpr_ce_indexation_freq\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="132" />
|
| 2475 |
<RELATION ID="27921" RelationName="fk_cmhl_csc_meta" Kind="2" SrcTable="21757" DestTable="20850" FKFields="cmhl_id_historique_ligne=csc_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="133" />
|
2489 |
<RELATION ID="27921" RelationName="fk_cmhl_csc_meta" Kind="2" SrcTable="21757" DestTable="20850" FKFields="cmhl_id_historique_ligne=csc_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="133" />
|
| 2476 |
<RELATION ID="27924" RelationName="fk_cmhl_csv_meta" Kind="2" SrcTable="21757" DestTable="20854" FKFields="cmhl_id_historique_ligne=csv_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="134" />
|
2490 |
<RELATION ID="27924" RelationName="fk_cmhl_csv_meta" Kind="2" SrcTable="21757" DestTable="20854" FKFields="cmhl_id_historique_ligne=csv_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="134" />
|
| 2477 |
<RELATION ID="27927" RelationName="fk_cmhl_ccb_meta" Kind="2" SrcTable="21757" DestTable="21148" FKFields="cmhl_id_historique_ligne=ccb_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="135" />
|
2491 |
<RELATION ID="27927" RelationName="fk_cmhl_ccb_meta" Kind="2" SrcTable="21757" DestTable="21148" FKFields="cmhl_id_historique_ligne=ccb_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="135" />
|
| 2478 |
<RELATION ID="27941" RelationName="fk_cmlv_csap_role" Kind="1" SrcTable="18466" DestTable="1447" FKFields="cmlv_id_valeur=csap_id_role\n" FKFieldsComments="Identifiant du r\195\180le de la personne vis \195\160 vis de la structure.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="136" />
|
2492 |
<RELATION ID="27941" RelationName="fk_cmlv_csap_role" Kind="1" SrcTable="18466" DestTable="1447" FKFields="cmlv_id_valeur=csap_id_role\n" FKFieldsComments="Identifiant du r\195\180le de la personne vis \195\160 vis de la structure.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="136" />
|
| - |
|
2493 |
<RELATION ID="27948" RelationName="fk_cmlv_cp_deces" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_deces\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="134" />
|
| - |
|
2494 |
<RELATION ID="27950" RelationName="fk_cmlv_cp_pays" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_truk_pays\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="135" />
|
| - |
|
2495 |
<RELATION ID="27952" RelationName="fk_cmlv_cp_region" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_truk_region\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="136" />
|
| - |
|
2496 |
<RELATION ID="27959" RelationName="fk_cmlv_cp_type_nbre_precision" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cp_ce_specimen_type_nbre_precision\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="137" />
|
| 2479 |
</RELATIONS>
|
2497 |
</RELATIONS>
|
| 2480 |
<NOTES>
|
2498 |
<NOTES>
|
| 2481 |
</NOTES>
|
2499 |
</NOTES>
|
| 2482 |
<IMAGES>
|
2500 |
<IMAGES>
|
| 2483 |
</IMAGES>
|
2501 |
</IMAGES>
|