| 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="50" 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 : tb_coel" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="92.00" XPos="0" YPos="1080" 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: 601 $" 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: 631 $" 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: 601 $" 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: 631 $" 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: 601 $" 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: 631 $" 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: 601 $" 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: 631 $" 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: 601 $" 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: 631 $" 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: 601 $" 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: 631 $" 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: 601 $" 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: 631 $" 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 1446... |
Line 1446... |
| 1446 |
</INDEX>
|
1446 |
</INDEX>
|
| 1447 |
</INDICES>
|
1447 |
</INDICES>
|
| 1448 |
</TABLE>
|
1448 |
</TABLE>
|
| 1449 |
<TABLE ID="21148" Tablename="coel_collection_botanique" PrevTableName="Table_14" XPos="443" YPos="1329" 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="Toutes les informations sp\195\169cialis\195\169es sur une collection de type : botanique" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
|
1449 |
<TABLE ID="21148" Tablename="coel_collection_botanique" PrevTableName="Table_14" XPos="443" YPos="1329" 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="Toutes les informations sp\195\169cialis\195\169es sur une collection de type : botanique" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
|
| 1450 |
<COLUMNS>
|
1450 |
<COLUMNS>
|
| 1451 |
<COLUMN ID="21150" ColName="ccb_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection botanique.">
|
1451 |
<COLUMN ID="21150" ColName="ccb_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="1" DefaultValue="" Comments="Type(s) unit\195\169 de rangement de la collection botanique. \\\nPour chaque type : indication du nombre d\aunit\195\169, de la pr\195\169cision du nom (exact, approximatif), des formats.">
|
| - |
|
1452 |
<OPTIONSELECTED>
|
| - |
|
1453 |
<OPTIONSELECT Value="1" />
|
| - |
|
1454 |
<OPTIONSELECT Value="0" />
|
| - |
|
1455 |
</OPTIONSELECTED>
|
| - |
|
1456 |
</COLUMN>
|
| - |
|
1457 |
<COLUMN ID="27946" ColName="ccb_nbre_echantillon" PrevColName="" Pos="43" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nombre de cartons ou liasses \195\169chantillonn\195\169es.">
|
| 1452 |
<OPTIONSELECTED>
|
1458 |
<OPTIONSELECTED>
|
| 1453 |
<OPTIONSELECT Value="1" />
|
1459 |
<OPTIONSELECT Value="1" />
|
| 1454 |
<OPTIONSELECT Value="0" />
|
1460 |
<OPTIONSELECT Value="0" />
|
| 1455 |
</OPTIONSELECTED>
|
1461 |
</OPTIONSELECTED>
|
| 1456 |
</COLUMN>
|
1462 |
</COLUMN>
|
| Line 1638... |
Line 1644... |
| 1638 |
<OPTIONSELECTED>
|
1644 |
<OPTIONSELECTED>
|
| 1639 |
<OPTIONSELECT Value="1" />
|
1645 |
<OPTIONSELECT Value="1" />
|
| 1640 |
<OPTIONSELECT Value="0" />
|
1646 |
<OPTIONSELECT Value="0" />
|
| 1641 |
</OPTIONSELECTED>
|
1647 |
</OPTIONSELECTED>
|
| 1642 |
</COLUMN>
|
1648 |
</COLUMN>
|
| 1643 |
<COLUMN ID="21517" ColName="ccb_ce_inventaire_forme" PrevColName="" Pos="35" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Forme de l\ainventaire (mnauscrit, informatique...).">
|
1649 |
<COLUMN ID="21517" ColName="ccb_ce_inventaire_forme" PrevColName="" Pos="35" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Forme de l\ainventaire (manuscrit, informatique...).">
|
| 1644 |
<OPTIONSELECTED>
|
1650 |
<OPTIONSELECTED>
|
| 1645 |
<OPTIONSELECT Value="1" />
|
1651 |
<OPTIONSELECT Value="1" />
|
| 1646 |
<OPTIONSELECT Value="0" />
|
1652 |
<OPTIONSELECT Value="0" />
|
| 1647 |
</OPTIONSELECTED>
|
1653 |
</OPTIONSELECTED>
|
| 1648 |
</COLUMN>
|
1654 |
</COLUMN>
|
| 1649 |
<COLUMN ID="21516" ColName="ccb_inventaire_info" PrevColName="" Pos="34" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quelles informations retrouve-t-on?">
|
1655 |
<COLUMN ID="21516" ColName="ccb_inventaire_info" PrevColName="" Pos="34" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quelles informations retrouve-t-on?">
|
| 1650 |
<OPTIONSELECTED>
|
1656 |
<OPTIONSELECTED>
|
| 1651 |
</OPTIONSELECTED>
|
1657 |
</OPTIONSELECTED>
|
| 1652 |
</COLUMN>
|
1658 |
</COLUMN>
|
| 1653 |
<COLUMN ID="21518" ColName="ccb_ce_truk_inventaire_digital" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Si inventaire digial, quel logiciel utilisez vous?">
|
1659 |
<COLUMN ID="21518" ColName="ccb_ce_truk_inventaire_digital" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Si inventaire digital, quel logiciel utilisez vous?">
|
| 1654 |
<OPTIONSELECTED>
|
1660 |
<OPTIONSELECTED>
|
| 1655 |
<OPTIONSELECT Value="0" />
|
1661 |
<OPTIONSELECT Value="0" />
|
| 1656 |
</OPTIONSELECTED>
|
1662 |
</OPTIONSELECTED>
|
| 1657 |
</COLUMN>
|
1663 |
</COLUMN>
|
| 1658 |
<COLUMN ID="21519" ColName="ccb_inventaire_digital_pourcent" PrevColName="" Pos="37" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage de la documentation en base de donn\195\169es.">
|
1664 |
<COLUMN ID="21519" ColName="ccb_inventaire_digital_pourcent" PrevColName="" Pos="37" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage de la documentation en base de donn\195\169es.">
|
| Line 2174... |
Line 2180... |
| 2174 |
<OPTIONSELECTED>
|
2180 |
<OPTIONSELECTED>
|
| 2175 |
<OPTIONSELECT Value="1" />
|
2181 |
<OPTIONSELECT Value="1" />
|
| 2176 |
<OPTIONSELECT Value="0" />
|
2182 |
<OPTIONSELECT Value="0" />
|
| 2177 |
</OPTIONSELECTED>
|
2183 |
</OPTIONSELECTED>
|
| 2178 |
</COLUMN>
|
2184 |
</COLUMN>
|
| 2179 |
<COLUMN ID="21770" ColName="cmhl_ip" PrevColName="cmhl_ip_mac" Pos="7" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse IP (et MAC \195\169ventuellement) depuis laquelle la modification a eu lieu.">
|
2185 |
<COLUMN ID="21770" ColName="cmhl_ip" PrevColName="cmhl_ip_mac" Pos="7" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse IP depuis laquelle la modification a eu lieu.">
|
| 2180 |
<OPTIONSELECTED>
|
2186 |
<OPTIONSELECTED>
|
| 2181 |
<OPTIONSELECT Value="0" />
|
2187 |
<OPTIONSELECT Value="0" />
|
| 2182 |
</OPTIONSELECTED>
|
2188 |
</OPTIONSELECTED>
|
| 2183 |
</COLUMN>
|
2189 |
</COLUMN>
|
| 2184 |
<COLUMN ID="27929" ColName="cmhl_session_id" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(40)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de session del \autilisateur.">
|
2190 |
<COLUMN ID="27929" ColName="cmhl_session_id" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(40)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de session del \autilisateur.">
|