/trunk/doc/bdd/coel_table_coel_projet_a_structure.html |
---|
158,7 → 158,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_collection_a_publication.html |
---|
158,7 → 158,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_personne.html |
---|
694,7 → 694,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_structure_valorisation.html |
---|
282,7 → 282,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_collection.html |
---|
603,22 → 603,6 |
<tr class="pair" > |
<td> 6 </td> |
<td> fk_cc_ccar_01 </td> |
<td> cc_id_collection </td> |
<td> ccar_id_collection_01 </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 7 </td> |
<td> fk_cc_ccar_02 </td> |
<td> cc_id_collection </td> |
<td> ccar_id_collection_02 </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 8 </td> |
<td> fk_cpr_cc </td> |
<td> cc_ce_projet </td> |
<td> cpr_id_projet </td> |
626,7 → 610,7 |
</tr> |
<tr class="pair" > |
<td> 9 </td> |
<td> 7 </td> |
<td> fk_cc_ccac </td> |
<td> cc_id_collection </td> |
<td> ccac_id_collection </td> |
634,7 → 618,7 |
</tr> |
<tr class="pair" > |
<td> 10 </td> |
<td> 8 </td> |
<td> fk_cmhl_cc_meta </td> |
<td> cc_ce_meta </td> |
<td> cmhl_id_historique_ligne </td> |
642,7 → 626,7 |
</tr> |
<tr class="pair" > |
<td> 11 </td> |
<td> 9 </td> |
<td> fk_cmlv_cc_type </td> |
<td> cc_ce_type </td> |
<td> cmlv_id_valeur </td> |
650,7 → 634,7 |
</tr> |
<tr class="pair" > |
<td> 12 </td> |
<td> 10 </td> |
<td> fk_cmlv_cc_developpement </td> |
<td> cc_ce_developpement </td> |
<td> cmlv_id_valeur </td> |
658,7 → 642,7 |
</tr> |
<tr class="pair" > |
<td> 13 </td> |
<td> 11 </td> |
<td> fk_cmlv_cc_specimen_type </td> |
<td> cc_ce_specimen_type </td> |
<td> cmlv_id_valeur </td> |
666,7 → 650,7 |
</tr> |
<tr class="pair" > |
<td> 14 </td> |
<td> 12 </td> |
<td> fk_cmlv_cc_specimen_type_classement </td> |
<td> cc_ce_specimen_type_classement </td> |
<td> cmlv_id_valeur </td> |
674,7 → 658,7 |
</tr> |
<tr class="pair" > |
<td> 15 </td> |
<td> 13 </td> |
<td> fk_cmlv_cc_type_depot </td> |
<td> cc_ce_type_depot </td> |
<td> cmlv_id_valeur </td> |
682,7 → 666,7 |
</tr> |
<tr class="pair" > |
<td> 16 </td> |
<td> 14 </td> |
<td> fk_cmlv_cc_type_nbre_precision </td> |
<td> cc_ce_specimen_type_nbre_precision </td> |
<td> cmlv_id_valeur </td> |
706,7 → 690,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_module_Structure.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Structures.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
77,7 → 77,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/index.html |
---|
57,8 → 57,8 |
<td> CC </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Collections.<br /> </td> |
</tr> |
68,8 → 68,8 |
<td> CCM </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module contenant les tables permettant de gérer les commentaires.<br /> </td> |
</tr> |
79,8 → 79,8 |
<td> CM </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Métadonnées.<br /> </td> |
</tr> |
90,8 → 90,8 |
<td> CP </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Personnes.<br /> </td> |
</tr> |
101,8 → 101,8 |
<td> CPR </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Projets.<br /> </td> |
</tr> |
112,8 → 112,8 |
<td> CPU </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Publications.<br /> </td> |
</tr> |
123,14 → 123,14 |
<td> CS </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Structures.<br /> </td> |
</tr> |
</tbody> |
</table> |
<p>Nombre total de tables : 154</p> |
<p>Nombre total de tables : 147</p> |
<h2> Commentaires </h2> |
<p>N'hésitez pas à laisser sur le wiki vos suggestions, réactions... concernant les modules : |
141,7 → 141,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_module_Commentaire.html |
---|
45,7 → 45,7 |
<p> |
Module contenant les tables permettant de gérer les commentaires.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
71,7 → 71,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_projet.html |
---|
390,7 → 390,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel.xml |
---|
1,7 → 1,7 |
<?xml version="1.0" standalone="yes" ?> |
<DBMODEL Version="4.0"> |
<SETTINGS> |
<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="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" /> |
<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="744" 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" /> |
<DATATYPEGROUPS> |
<DATATYPEGROUP Name="Numeric Types" Icon="1" /> |
<DATATYPEGROUP Name="Date and Time Types" Icon="2" /> |
260,13 → 260,13 |
</SETTINGS> |
<METADATA> |
<REGIONS> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" /> |
</REGIONS> |
<TABLES> |
<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" > |
486,8 → 486,6 |
<RELATION_START ID="21108" /> |
<RELATION_START ID="21152" /> |
<RELATION_START ID="21223" /> |
<RELATION_START ID="21496" /> |
<RELATION_START ID="21498" /> |
<RELATION_START ID="22037" /> |
</RELATIONS_START> |
<RELATIONS_END> |
604,12 → 602,12 |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<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."> |
<COLUMN ID="27881" ColName="cs_latitude" PrevColName="" Pos="27" idDatatype="20" DatatypeParams="(15)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Latitude du local de la structure."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<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."> |
<COLUMN ID="27882" ColName="cs_longitude" PrevColName="" Pos="28" idDatatype="20" DatatypeParams="(15)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Longitude du local de la structure."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
643,10 → 641,6 |
<OPTIONSELECTED> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="27935" ColName="cs_mark_public" PrevColName="" Pos="28" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si oui (=1) ou non (=0) les donn\195\169es de cette structure sont publiques."> |
<OPTIONSELECTED> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="20825" ColName="cs_ce_meta" PrevColName="cs_date_derniere_modif" Pos="21" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
1163,7 → 1157,6 |
<RELATION_START ID="22146" /> |
<RELATION_START ID="22148" /> |
<RELATION_START ID="22150" /> |
<RELATION_START ID="22152" /> |
<RELATION_START ID="22154" /> |
<RELATION_START ID="22158" /> |
<RELATION_START ID="22160" /> |
1893,49 → 1886,6 |
</INDEX> |
</INDICES> |
</TABLE> |
<TABLE ID="21486" Tablename="coel_collection_a_relation" PrevTableName="Table_18" XPos="76" YPos="955" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Permet de lister les relations entre collection autre que hi\195\169rarchique." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" > |
<COLUMNS> |
<COLUMN ID="21660" ColName="ccar_id_collection_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1761."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21661" ColName="ccar_id_collection_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1762."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21491" ColName="ccar_id_relation" PrevColName="ccr_ce_relation" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Indentifiant du type de la relation."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21493" ColName="ccar_ce_meta" PrevColName="ccr_date_derniere_modif" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
</COLUMNS> |
<RELATIONS_END> |
<RELATION_END ID="21496" /> |
<RELATION_END ID="21498" /> |
<RELATION_END ID="22075" /> |
<RELATION_END ID="22152" /> |
</RELATIONS_END> |
<INDICES> |
<INDEX ID="21489" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> |
<INDEXCOLUMNS> |
<INDEXCOLUMN idColumn="21660" LengthParam="0" /> |
<INDEXCOLUMN idColumn="21661" LengthParam="0" /> |
<INDEXCOLUMN idColumn="21491" LengthParam="0" /> |
</INDEXCOLUMNS> |
</INDEX> |
</INDICES> |
</TABLE> |
<TABLE ID="21522" Tablename="coel_projet" PrevTableName="EFLORE_PROJET" XPos="57" YPos="541" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur un projet de donn\195\169es.\nINFO : cpr_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" > |
<COLUMNS> |
<COLUMN ID="21523" ColName="cpr_id_projet" PrevColName="EPR_ID_PROJET" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun projet."> |
2218,7 → 2168,6 |
<RELATION_START ID="22066" /> |
<RELATION_START ID="22068" /> |
<RELATION_START ID="22073" /> |
<RELATION_START ID="22075" /> |
<RELATION_START ID="22077" /> |
<RELATION_START ID="22079" /> |
<RELATION_START ID="22081" /> |
2417,8 → 2366,6 |
<RELATION ID="21226" RelationName="fk_cpu_ccapu" Kind="1" SrcTable="21188" DestTable="21219" FKFields="cpu_id_publication=ccapu_id_publication\n" FKFieldsComments="Identifiant de la publication traitant d\aune collection.\n" relDirection="1" MidOffset="31" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="25" CaptionOffsetY="-3" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="67" /> |
<RELATION ID="21239" RelationName="fk_cp_cpuap" Kind="1" SrcTable="1446" DestTable="21235" FKFields="cp_id_personne=cpuap_id_personne\n" FKFieldsComments="Identifiant de la personne ayant un rapport avec une publication.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="53" CaptionOffsetY="-20" StartIntervalOffsetX="99" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="71" /> |
<RELATION ID="21241" RelationName="fk_cpu_cpuap" Kind="1" SrcTable="21188" DestTable="21235" FKFields="cpu_id_publication=cpuap_id_publication\n" FKFieldsComments="Identifiant de la publication li\195\169e \195\160 une personne.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-2" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="72" /> |
<RELATION ID="21496" RelationName="fk_cc_ccar_01" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_01\n" FKFieldsComments="Identifiant de la collection n\194\1761.\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="39" CaptionOffsetY="-2" StartIntervalOffsetX="7" StartIntervalOffsetY="-2" EndIntervalOffsetX="6" EndIntervalOffsetY="3" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="65" /> |
<RELATION ID="21498" RelationName="fk_cc_ccar_02" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_02\n" FKFieldsComments="Identifiant de la collection n\194\1762.\n" relDirection="1" MidOffset="22" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-44" CaptionOffsetY="-2" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="4" EndIntervalOffsetY="6" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="66" /> |
<RELATION ID="21560" RelationName="fk_cpr_cpar" Kind="1" SrcTable="21522" DestTable="21544" FKFields="cpr_id_projet=cpar_id_projet\n" FKFieldsComments="Identifiant du projet dans lequel la relation entre les deux personnes s\a\195\169tablie.\n" relDirection="2" MidOffset="215" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="1" CaptionOffsetY="-44" StartIntervalOffsetX="5" StartIntervalOffsetY="-27" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="70" /> |
<RELATION ID="21563" RelationName="fk_cp_cpar_01" Kind="1" SrcTable="1446" DestTable="21544" FKFields="cp_id_personne=cpar_id_personne_01\n" FKFieldsComments="Identifiant de la personne n\194\1761.\n" relDirection="4" MidOffset="13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="71" /> |
<RELATION ID="21616" RelationName="fk_cs_cpu_editeur" Kind="2" SrcTable="1445" DestTable="21188" FKFields="cs_id_structure=cpu_ce_truk_editeur\n" FKFieldsComments="Identifiant de la structure \195\169ditrice de la publication. S\ail n\aest pas renseignn\195\169 dans la table Structure, contient AUTRE# suivit du nom complet de la structure \195\169ditrice.\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="-6" StartIntervalOffsetY="-29" EndIntervalOffsetX="8" EndIntervalOffsetY="11" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="72" /> |
2451,7 → 2398,6 |
<RELATION ID="22068" RelationName="fk_cmhl_cprv_meta" Kind="2" SrcTable="21757" DestTable="21634" FKFields="cmhl_id_historique_ligne=cprv_ce_meta\n" FKFieldsComments="\n" relDirection="4" 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="81" /> |
<RELATION ID="22071" RelationName="fk_cmlv_cmhl_val" Kind="2" SrcTable="18466" DestTable="21757" FKFields="cmlv_id_valeur=cmhl_ce_etat\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="82" /> |
<RELATION ID="22073" RelationName="fk_cmhl_csap_meta" Kind="2" SrcTable="21757" DestTable="1447" FKFields="cmhl_id_historique_ligne=csap_ce_meta\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="82" /> |
<RELATION ID="22075" RelationName="fk_cmhl_ccar_meta" Kind="2" SrcTable="21757" DestTable="21486" FKFields="cmhl_id_historique_ligne=ccar_ce_meta\n" FKFieldsComments="\n" relDirection="4" 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="83" /> |
<RELATION ID="22077" RelationName="fk_cmhl_ccap_meta" Kind="2" SrcTable="21757" DestTable="21104" FKFields="cmhl_id_historique_ligne=ccap_ce_meta\n" FKFieldsComments="\n" relDirection="4" 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="84" /> |
<RELATION ID="22079" RelationName="fk_cmhl_cc_meta" Kind="2" SrcTable="21757" DestTable="1444" FKFields="cmhl_id_historique_ligne=cc_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="5" CaptionOffsetY="-5" 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="85" /> |
<RELATION ID="22081" RelationName="fk_cmhl_ccapu_meta" Kind="2" SrcTable="21757" DestTable="21219" FKFields="cmhl_id_historique_ligne=ccapu_ce_meta\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="86" /> |
2472,7 → 2418,6 |
<RELATION ID="22146" RelationName="fk_cmlv_csc_materiel_conservation" Kind="2" SrcTable="18466" DestTable="20850" FKFields="cmlv_id_valeur=csc_ce_materiel_conservation\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="101" /> |
<RELATION ID="22148" RelationName="fk_cmlv_cpuap_type" Kind="2" SrcTable="18466" DestTable="21235" FKFields="cmlv_id_valeur=cpuap_ce_truk_type\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="102" /> |
<RELATION ID="22150" RelationName="fk_cmlv_cpuap_role" Kind="1" SrcTable="18466" DestTable="21235" FKFields="cmlv_id_valeur=cpuap_id_role\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="103" /> |
<RELATION ID="22152" RelationName="fk_cmlv_ccar_relation" Kind="1" SrcTable="18466" DestTable="21486" FKFields="cmlv_id_valeur=ccar_id_relation\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="104" /> |
<RELATION ID="22154" RelationName="fk_cmlv_ccap_role" Kind="1" SrcTable="18466" DestTable="21104" FKFields="cmlv_id_valeur=ccap_id_role\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="105" /> |
<RELATION ID="22158" RelationName="fk_cmlv_cc_type" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_type\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="106" /> |
<RELATION ID="22160" RelationName="fk_cmlv_cc_developpement" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_developpement\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="107" /> |
/trunk/doc/bdd/coel_table_coel_meta_liste_valeur.html |
---|
339,14 → 339,6 |
<tr class="pair" > |
<td> 24 </td> |
<td> fk_cmlv_ccar_relation </td> |
<td> cmlv_id_valeur </td> |
<td> ccar_id_relation </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 25 </td> |
<td> fk_cmlv_ccap_role </td> |
<td> cmlv_id_valeur </td> |
<td> ccap_id_role </td> |
354,7 → 346,7 |
</tr> |
<tr class="pair" > |
<td> 26 </td> |
<td> 25 </td> |
<td> fk_cmlv_cc_type </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_type </td> |
362,7 → 354,7 |
</tr> |
<tr class="pair" > |
<td> 27 </td> |
<td> 26 </td> |
<td> fk_cmlv_cc_developpement </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_developpement </td> |
370,7 → 362,7 |
</tr> |
<tr class="pair" > |
<td> 28 </td> |
<td> 27 </td> |
<td> fk_cmlv_cc_specimen_type </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_specimen_type </td> |
378,7 → 370,7 |
</tr> |
<tr class="pair" > |
<td> 29 </td> |
<td> 28 </td> |
<td> fk_cmlv_cc_specimen_type_classement </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_specimen_type_classement </td> |
386,7 → 378,7 |
</tr> |
<tr class="pair" > |
<td> 30 </td> |
<td> 29 </td> |
<td> fk_cmlv_ccb_unitte_rangement_etat </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_unite_rangement_etat </td> |
394,7 → 386,7 |
</tr> |
<tr class="pair" > |
<td> 31 </td> |
<td> 30 </td> |
<td> fk_cmlv_ccb_traitement </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_traitement </td> |
402,7 → 394,7 |
</tr> |
<tr class="pair" > |
<td> 32 </td> |
<td> 31 </td> |
<td> fk_cmlv_ccb_etat_general </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_etat_general </td> |
410,7 → 402,7 |
</tr> |
<tr class="pair" > |
<td> 33 </td> |
<td> 32 </td> |
<td> fk_cmlv_ccb_determination </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_determination </td> |
418,7 → 410,7 |
</tr> |
<tr class="pair" > |
<td> 34 </td> |
<td> 33 </td> |
<td> fk_cmlv_ccb_recolte_date_debut_type </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_recolte_date_debut_type </td> |
426,7 → 418,7 |
</tr> |
<tr class="pair" > |
<td> 35 </td> |
<td> 34 </td> |
<td> fk_cmlv_ccb_recolte_date_fin_type </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_recolte_date_fin_type </td> |
434,7 → 426,7 |
</tr> |
<tr class="pair" > |
<td> 36 </td> |
<td> 35 </td> |
<td> fk_cmlv_ccb_classement_etat </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_classement_etat </td> |
442,7 → 434,7 |
</tr> |
<tr class="pair" > |
<td> 37 </td> |
<td> 36 </td> |
<td> fk_cmlv_ccb_precision_localite </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_precision_localite </td> |
450,7 → 442,7 |
</tr> |
<tr class="pair" > |
<td> 38 </td> |
<td> 37 </td> |
<td> fk_cmlv_ccb_precision_date </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_precision_date </td> |
458,7 → 450,7 |
</tr> |
<tr class="pair" > |
<td> 39 </td> |
<td> 38 </td> |
<td> fk_cmlv_ccb_collection_integre </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_collection_integre </td> |
466,7 → 458,7 |
</tr> |
<tr class="pair" > |
<td> 40 </td> |
<td> 39 </td> |
<td> fk_cmlv_ccb_collection_integre_info </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_collection_integre_info </td> |
474,7 → 466,7 |
</tr> |
<tr class="pair" > |
<td> 41 </td> |
<td> 40 </td> |
<td> fk_cmlv_ccb_inventaire </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire </td> |
482,7 → 474,7 |
</tr> |
<tr class="pair" > |
<td> 42 </td> |
<td> 41 </td> |
<td> fk_cmlv_ccb_inventaire_auteur </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire_auteur </td> |
490,7 → 482,7 |
</tr> |
<tr class="pair" > |
<td> 43 </td> |
<td> 42 </td> |
<td> fk_cmlv_ccb_inventaire_forme </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire_forme </td> |
498,7 → 490,7 |
</tr> |
<tr class="pair" > |
<td> 44 </td> |
<td> 43 </td> |
<td> fk_cmlv_ccb_inventaire_digital </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_truk_inventaire_digital </td> |
506,7 → 498,7 |
</tr> |
<tr class="pair" > |
<td> 45 </td> |
<td> 44 </td> |
<td> fk_cmlv_ccb_inventaire_etat </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire_etat </td> |
514,7 → 506,7 |
</tr> |
<tr class="pair" > |
<td> 46 </td> |
<td> 45 </td> |
<td> fk_cmlv_cc_type_depot </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_type_depot </td> |
522,7 → 514,7 |
</tr> |
<tr class="pair" > |
<td> 47 </td> |
<td> 46 </td> |
<td> fk_cmlv_cpr_langue </td> |
<td> cmlv_id_valeur </td> |
<td> cpr_ce_langue </td> |
530,7 → 522,7 |
</tr> |
<tr class="pair" > |
<td> 48 </td> |
<td> 47 </td> |
<td> fk_cmlv_cpr_idx_duree </td> |
<td> cmlv_id_valeur </td> |
<td> cpr_ce_indexation_duree </td> |
538,7 → 530,7 |
</tr> |
<tr class="pair" > |
<td> 49 </td> |
<td> 48 </td> |
<td> fk_cmlv_cpr_idx_freq </td> |
<td> cmlv_id_valeur </td> |
<td> cpr_ce_indexation_freq </td> |
546,7 → 538,7 |
</tr> |
<tr class="pair" > |
<td> 50 </td> |
<td> 49 </td> |
<td> fk_cmlv_csap_role </td> |
<td> cmlv_id_valeur </td> |
<td> csap_id_role </td> |
554,7 → 546,7 |
</tr> |
<tr class="pair" > |
<td> 51 </td> |
<td> 50 </td> |
<td> fk_cmlv_cp_deces </td> |
<td> cmlv_id_valeur </td> |
<td> cp_ce_deces </td> |
562,7 → 554,7 |
</tr> |
<tr class="pair" > |
<td> 52 </td> |
<td> 51 </td> |
<td> fk_cmlv_cp_pays </td> |
<td> cmlv_id_valeur </td> |
<td> cp_ce_truk_pays </td> |
570,7 → 562,7 |
</tr> |
<tr class="pair" > |
<td> 53 </td> |
<td> 52 </td> |
<td> fk_cmlv_cp_region </td> |
<td> cmlv_id_valeur </td> |
<td> cp_ce_truk_region </td> |
578,7 → 570,7 |
</tr> |
<tr class="pair" > |
<td> 54 </td> |
<td> 53 </td> |
<td> fk_cmlv_cc_type_nbre_precision </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_specimen_type_nbre_precision </td> |
602,7 → 594,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_module_Publication.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Publications.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
73,7 → 73,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_projet_version.html |
---|
186,7 → 186,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_meta_historique_ligne.html |
---|
299,14 → 299,6 |
<tr class="pair" > |
<td> 13 </td> |
<td> fk_cmhl_ccar_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccar_ce_meta </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 14 </td> |
<td> fk_cmhl_ccap_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccap_ce_meta </td> |
314,7 → 306,7 |
</tr> |
<tr class="pair" > |
<td> 15 </td> |
<td> 14 </td> |
<td> fk_cmhl_cc_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cc_ce_meta </td> |
322,7 → 314,7 |
</tr> |
<tr class="pair" > |
<td> 16 </td> |
<td> 15 </td> |
<td> fk_cmhl_ccapu_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccapu_ce_meta </td> |
330,7 → 322,7 |
</tr> |
<tr class="pair" > |
<td> 17 </td> |
<td> 16 </td> |
<td> fk_cmhl_cpu_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cpu_ce_meta </td> |
338,7 → 330,7 |
</tr> |
<tr class="pair" > |
<td> 18 </td> |
<td> 17 </td> |
<td> fk_cmhl_cpuap_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cpuap_ce_meta </td> |
346,7 → 338,7 |
</tr> |
<tr class="pair" > |
<td> 19 </td> |
<td> 18 </td> |
<td> fk_cmlv_cmhl_table </td> |
<td> cmhl_ce_table </td> |
<td> cmlv_id_valeur </td> |
354,7 → 346,7 |
</tr> |
<tr class="pair" > |
<td> 20 </td> |
<td> 19 </td> |
<td> fk_cmhl_cpras_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cpras_ce_meta </td> |
362,7 → 354,7 |
</tr> |
<tr class="pair" > |
<td> 21 </td> |
<td> 20 </td> |
<td> fk_cmhl_csc_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> csc_ce_meta </td> |
370,7 → 362,7 |
</tr> |
<tr class="pair" > |
<td> 22 </td> |
<td> 21 </td> |
<td> fk_cmhl_csv_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> csv_ce_meta </td> |
378,7 → 370,7 |
</tr> |
<tr class="pair" > |
<td> 23 </td> |
<td> 22 </td> |
<td> fk_cmhl_ccb_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccb_ce_meta </td> |
402,7 → 394,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_publication_a_personne.html |
---|
186,7 → 186,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_module_Personne.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Personnes.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
73,7 → 73,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_personne_a_relation.html |
---|
186,7 → 186,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_module_Collection.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Collections.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
58,8 → 58,6 |
<li><a href="coel_table_coel_collection_a_publication.html">coel_collection_a_publication</a> : Permet de lister les publication liées à une collection.</li> |
<li><a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> : Permet de lister les relations entre collection autre que hiérarchique.</li> |
<li><a href="coel_table_coel_collection_botanique.html">coel_collection_botanique</a> : Toutes les informations spécialisées sur une collection de type : botanique</li> |
</ol> |
81,7 → 79,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_structure_conservation.html |
---|
374,7 → 374,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_module_Projet.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Projets.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
75,7 → 75,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_structure.html |
---|
275,7 → 275,7 |
<td> 19 </td> |
<td> cs_latitude </td> |
<td> cs_l </td> |
<td> FLOAT </td> |
<td> VARCHAR(15) </td> |
<td> non </td> |
<td> </td> |
<td> standard </td> |
287,7 → 287,7 |
<td> 20 </td> |
<td> cs_longitude </td> |
<td> cs_l </td> |
<td> FLOAT </td> |
<td> VARCHAR(15) </td> |
<td> non </td> |
<td> </td> |
<td> standard </td> |
367,20 → 367,8 |
<td> Conditions d'usage générales des collections de la structure. </td> |
</tr> |
<tr id="cs_mark_public" class="pair" > |
<tr id="cs_ce_meta" class="pair" > |
<td> 27 </td> |
<td> cs_mark_public </td> |
<td> cs_mp </td> |
<td> BOOL </td> |
<td> non </td> |
<td> 0 </td> |
<td> standard </td> |
<td> non </td> |
<td> Indique si oui (=1) ou non (=0) les données de cette structure sont publiques. </td> |
</tr> |
<tr id="cs_ce_meta" class="pair" > |
<td> 28 </td> |
<td> cs_ce_meta </td> |
<td> cs_ce_m </td> |
<td> INTEGER </td> |
518,7 → 506,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_collection_botanique.html |
---|
746,7 → 746,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_meta_colonne.html |
---|
254,7 → 254,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_commentaire.html |
---|
214,7 → 214,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_collection_a_personne.html |
---|
166,7 → 166,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_publication.html |
---|
282,7 → 282,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_structure_a_personne.html |
---|
242,7 → 242,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_module_Metadonnee.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Métadonnées.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
77,7 → 77,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_meta_donnee.html |
---|
162,7 → 162,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/trunk/doc/bdd/coel_table_coel_collection_a_commentaire.html |
---|
158,7 → 158,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:27</p> |
<p>Documentation générée le 29 janvier 2010 12:20:19</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_module_Projet.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Projets.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
75,7 → 75,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_structure.html |
---|
275,7 → 275,7 |
<td> 19 </td> |
<td> cs_latitude </td> |
<td> cs_l </td> |
<td> FLOAT </td> |
<td> VARCHAR(15) </td> |
<td> non </td> |
<td> </td> |
<td> standard </td> |
287,7 → 287,7 |
<td> 20 </td> |
<td> cs_longitude </td> |
<td> cs_l </td> |
<td> FLOAT </td> |
<td> VARCHAR(15) </td> |
<td> non </td> |
<td> </td> |
<td> standard </td> |
367,20 → 367,8 |
<td> Conditions d'usage générales des collections de la structure. </td> |
</tr> |
<tr id="cs_mark_public" class="pair" > |
<tr id="cs_ce_meta" class="pair" > |
<td> 27 </td> |
<td> cs_mark_public </td> |
<td> cs_mp </td> |
<td> BOOL </td> |
<td> non </td> |
<td> 0 </td> |
<td> standard </td> |
<td> non </td> |
<td> Indique si oui (=1) ou non (=0) les données de cette structure sont publiques. </td> |
</tr> |
<tr id="cs_ce_meta" class="pair" > |
<td> 28 </td> |
<td> cs_ce_meta </td> |
<td> cs_ce_m </td> |
<td> INTEGER </td> |
518,7 → 506,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_collection_botanique.html |
---|
746,7 → 746,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_meta_colonne.html |
---|
254,7 → 254,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_commentaire.html |
---|
214,7 → 214,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:09</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_collection_a_personne.html |
---|
166,7 → 166,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_structure_a_personne.html |
---|
242,7 → 242,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_publication.html |
---|
282,7 → 282,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_module_Metadonnee.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Métadonnées.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
77,7 → 77,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_collection_a_commentaire.html |
---|
158,7 → 158,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:09</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_meta_donnee.html |
---|
162,7 → 162,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_projet_a_structure.html |
---|
158,7 → 158,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:09</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_collection_a_publication.html |
---|
158,7 → 158,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_personne.html |
---|
694,7 → 694,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_structure_valorisation.html |
---|
282,7 → 282,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_collection.html |
---|
603,22 → 603,6 |
<tr class="pair" > |
<td> 6 </td> |
<td> fk_cc_ccar_01 </td> |
<td> cc_id_collection </td> |
<td> ccar_id_collection_01 </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 7 </td> |
<td> fk_cc_ccar_02 </td> |
<td> cc_id_collection </td> |
<td> ccar_id_collection_02 </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 8 </td> |
<td> fk_cpr_cc </td> |
<td> cc_ce_projet </td> |
<td> cpr_id_projet </td> |
626,7 → 610,7 |
</tr> |
<tr class="pair" > |
<td> 9 </td> |
<td> 7 </td> |
<td> fk_cc_ccac </td> |
<td> cc_id_collection </td> |
<td> ccac_id_collection </td> |
634,7 → 618,7 |
</tr> |
<tr class="pair" > |
<td> 10 </td> |
<td> 8 </td> |
<td> fk_cmhl_cc_meta </td> |
<td> cc_ce_meta </td> |
<td> cmhl_id_historique_ligne </td> |
642,7 → 626,7 |
</tr> |
<tr class="pair" > |
<td> 11 </td> |
<td> 9 </td> |
<td> fk_cmlv_cc_type </td> |
<td> cc_ce_type </td> |
<td> cmlv_id_valeur </td> |
650,7 → 634,7 |
</tr> |
<tr class="pair" > |
<td> 12 </td> |
<td> 10 </td> |
<td> fk_cmlv_cc_developpement </td> |
<td> cc_ce_developpement </td> |
<td> cmlv_id_valeur </td> |
658,7 → 642,7 |
</tr> |
<tr class="pair" > |
<td> 13 </td> |
<td> 11 </td> |
<td> fk_cmlv_cc_specimen_type </td> |
<td> cc_ce_specimen_type </td> |
<td> cmlv_id_valeur </td> |
666,7 → 650,7 |
</tr> |
<tr class="pair" > |
<td> 14 </td> |
<td> 12 </td> |
<td> fk_cmlv_cc_specimen_type_classement </td> |
<td> cc_ce_specimen_type_classement </td> |
<td> cmlv_id_valeur </td> |
674,7 → 658,7 |
</tr> |
<tr class="pair" > |
<td> 15 </td> |
<td> 13 </td> |
<td> fk_cmlv_cc_type_depot </td> |
<td> cc_ce_type_depot </td> |
<td> cmlv_id_valeur </td> |
682,7 → 666,7 |
</tr> |
<tr class="pair" > |
<td> 16 </td> |
<td> 14 </td> |
<td> fk_cmlv_cc_type_nbre_precision </td> |
<td> cc_ce_specimen_type_nbre_precision </td> |
<td> cmlv_id_valeur </td> |
706,7 → 690,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/index.html |
---|
57,8 → 57,8 |
<td> CC </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Collections.<br /> </td> |
</tr> |
68,8 → 68,8 |
<td> CCM </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module contenant les tables permettant de gérer les commentaires.<br /> </td> |
</tr> |
79,8 → 79,8 |
<td> CM </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Métadonnées.<br /> </td> |
</tr> |
90,8 → 90,8 |
<td> CP </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Personnes.<br /> </td> |
</tr> |
101,8 → 101,8 |
<td> CPR </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Projets.<br /> </td> |
</tr> |
112,8 → 112,8 |
<td> CPU </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Publications.<br /> </td> |
</tr> |
123,14 → 123,14 |
<td> CS </td> |
<td> OK </td> |
<td> OK </td> |
<td> 22 </td> |
<td> 1157 </td> |
<td> 21 </td> |
<td> 1159 </td> |
<td> Module de gestion des Structures.<br /> </td> |
</tr> |
</tbody> |
</table> |
<p>Nombre total de tables : 154</p> |
<p>Nombre total de tables : 147</p> |
<h2> Commentaires </h2> |
<p>N'hésitez pas à laisser sur le wiki vos suggestions, réactions... concernant les modules : |
141,7 → 141,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:09</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_module_Structure.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Structures.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
77,7 → 77,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_module_Commentaire.html |
---|
45,7 → 45,7 |
<p> |
Module contenant les tables permettant de gérer les commentaires.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
71,7 → 71,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/maj_v1.0.2_a_v1.0.3.sql |
---|
1,4 → 1,24 |
# Suppression du champ ccb_inventaire_donnee_type qui fait doublon avec le champ ccb_inventaire_info. |
ALTER TABLE `coel_collection_botanique` DROP `ccb_inventaire_donnee_type`; |
DELETE FROM `coel_meta_colonne` WHERE `coel_meta_colonne`.`cmc_id_champ` = 224 LIMIT 1; |
# Changement de nom d''un champ |
ALTER TABLE `coel_personne` CHANGE `cp_ce_annuaire_tela` `cp_ce_annuaire` INT( 11 ) NULL DEFAULT NULL COMMENT 'Identifiant de la personne dans un annuaire (par défaut celui de Tela Botanica).'; |
UPDATE `tb_coel`.`coel_meta_colonne` SET `cmc_abreviation` = 'cp_ce_a', |
`cmc_nom` = 'cp_ce_annuaire', `cmc_description` = 'Identifiant de la personne dans un annuaire (par défaut celui de Tela Botanica).' WHERE `coel_meta_colonne`.`cmc_id_champ` = 107 LIMIT 1 ; |
# Changement du type des champs latitude et longitudes |
ALTER TABLE `coel_structure` CHANGE `cs_latitude` `cs_latitude` VARCHAR( 15 ) NULL DEFAULT NULL COMMENT 'Latitude du local de la structure.'; |
ALTER TABLE `coel_structure` CHANGE `cs_longitude` `cs_longitude` VARCHAR( 15 ) NULL DEFAULT NULL COMMENT 'Longitude du local de la structure.'; |
UPDATE `tb_coel`.`coel_meta_colonne` SET `cmc_ce_format_sql` = '29', |
`cmc_taille` = '15' WHERE `coel_meta_colonne`.`cmc_id_champ` =60 LIMIT 1 ; |
UPDATE `tb_coel`.`coel_meta_colonne` SET `cmc_ce_format_sql` = '29', |
`cmc_taille` = '15' WHERE `coel_meta_colonne`.`cmc_id_champ` =61 LIMIT 1 ; |
# Suppression du champ cs_mark_public finalement inutile vis à vis de la licence de l''application |
ALTER TABLE `coel_structure` DROP `cs_mark_public`; |
DELETE FROM `coel_meta_colonne` WHERE `coel_meta_colonne`.`cmc_id_champ` = 68 LIMIT 1; |
# Suppression de la table établissant des relations complexes entre collection car inutile |
DROP TABLE `coel_collection_a_relation`; |
DELETE FROM `coel_meta_liste_valeur` WHERE `coel_meta_liste_valeur`.`cmlv_id_valeur` = 105 LIMIT 1; |
DELETE FROM `coel_meta_colonne` WHERE `coel_meta_colonne`.`cmc_id_champ` = 248 LIMIT 1; |
DELETE FROM `coel_meta_colonne` WHERE `coel_meta_colonne`.`cmc_id_champ` = 249 LIMIT 1; |
DELETE FROM `coel_meta_colonne` WHERE `coel_meta_colonne`.`cmc_id_champ` = 250 LIMIT 1; |
DELETE FROM `coel_meta_colonne` WHERE `coel_meta_colonne`.`cmc_id_champ` = 251 LIMIT 1; |
/branches/v1.0-syrah/doc/bdd/coel.xml |
---|
1,7 → 1,7 |
<?xml version="1.0" standalone="yes" ?> |
<DBMODEL Version="4.0"> |
<SETTINGS> |
<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="408" 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" /> |
<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="744" 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" /> |
<DATATYPEGROUPS> |
<DATATYPEGROUP Name="Numeric Types" Icon="1" /> |
<DATATYPEGROUP Name="Date and Time Types" Icon="2" /> |
260,13 → 260,13 |
</SETTINGS> |
<METADATA> |
<REGIONS> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" /> |
<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$" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" /> |
</REGIONS> |
<TABLES> |
<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" > |
486,8 → 486,6 |
<RELATION_START ID="21108" /> |
<RELATION_START ID="21152" /> |
<RELATION_START ID="21223" /> |
<RELATION_START ID="21496" /> |
<RELATION_START ID="21498" /> |
<RELATION_START ID="22037" /> |
</RELATIONS_START> |
<RELATIONS_END> |
604,12 → 602,12 |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<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."> |
<COLUMN ID="27881" ColName="cs_latitude" PrevColName="" Pos="27" idDatatype="20" DatatypeParams="(15)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Latitude du local de la structure."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<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."> |
<COLUMN ID="27882" ColName="cs_longitude" PrevColName="" Pos="28" idDatatype="20" DatatypeParams="(15)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Longitude du local de la structure."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
643,10 → 641,6 |
<OPTIONSELECTED> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="27935" ColName="cs_mark_public" PrevColName="" Pos="28" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si oui (=1) ou non (=0) les donn\195\169es de cette structure sont publiques."> |
<OPTIONSELECTED> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="20825" ColName="cs_ce_meta" PrevColName="cs_date_derniere_modif" Pos="21" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
1163,7 → 1157,6 |
<RELATION_START ID="22146" /> |
<RELATION_START ID="22148" /> |
<RELATION_START ID="22150" /> |
<RELATION_START ID="22152" /> |
<RELATION_START ID="22154" /> |
<RELATION_START ID="22158" /> |
<RELATION_START ID="22160" /> |
1893,49 → 1886,6 |
</INDEX> |
</INDICES> |
</TABLE> |
<TABLE ID="21486" Tablename="coel_collection_a_relation" PrevTableName="Table_18" XPos="76" YPos="955" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Permet de lister les relations entre collection autre que hi\195\169rarchique." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" > |
<COLUMNS> |
<COLUMN ID="21660" ColName="ccar_id_collection_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1761."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21661" ColName="ccar_id_collection_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1762."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21491" ColName="ccar_id_relation" PrevColName="ccr_ce_relation" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Indentifiant du type de la relation."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21493" ColName="ccar_ce_meta" PrevColName="ccr_date_derniere_modif" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
</COLUMNS> |
<RELATIONS_END> |
<RELATION_END ID="21496" /> |
<RELATION_END ID="21498" /> |
<RELATION_END ID="22075" /> |
<RELATION_END ID="22152" /> |
</RELATIONS_END> |
<INDICES> |
<INDEX ID="21489" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> |
<INDEXCOLUMNS> |
<INDEXCOLUMN idColumn="21660" LengthParam="0" /> |
<INDEXCOLUMN idColumn="21661" LengthParam="0" /> |
<INDEXCOLUMN idColumn="21491" LengthParam="0" /> |
</INDEXCOLUMNS> |
</INDEX> |
</INDICES> |
</TABLE> |
<TABLE ID="21522" Tablename="coel_projet" PrevTableName="EFLORE_PROJET" XPos="57" YPos="541" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur un projet de donn\195\169es.\nINFO : cpr_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" > |
<COLUMNS> |
<COLUMN ID="21523" ColName="cpr_id_projet" PrevColName="EPR_ID_PROJET" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun projet."> |
2218,7 → 2168,6 |
<RELATION_START ID="22066" /> |
<RELATION_START ID="22068" /> |
<RELATION_START ID="22073" /> |
<RELATION_START ID="22075" /> |
<RELATION_START ID="22077" /> |
<RELATION_START ID="22079" /> |
<RELATION_START ID="22081" /> |
2417,8 → 2366,6 |
<RELATION ID="21226" RelationName="fk_cpu_ccapu" Kind="1" SrcTable="21188" DestTable="21219" FKFields="cpu_id_publication=ccapu_id_publication\n" FKFieldsComments="Identifiant de la publication traitant d\aune collection.\n" relDirection="1" MidOffset="31" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="25" CaptionOffsetY="-3" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="67" /> |
<RELATION ID="21239" RelationName="fk_cp_cpuap" Kind="1" SrcTable="1446" DestTable="21235" FKFields="cp_id_personne=cpuap_id_personne\n" FKFieldsComments="Identifiant de la personne ayant un rapport avec une publication.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="53" CaptionOffsetY="-20" StartIntervalOffsetX="99" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="71" /> |
<RELATION ID="21241" RelationName="fk_cpu_cpuap" Kind="1" SrcTable="21188" DestTable="21235" FKFields="cpu_id_publication=cpuap_id_publication\n" FKFieldsComments="Identifiant de la publication li\195\169e \195\160 une personne.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-2" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="72" /> |
<RELATION ID="21496" RelationName="fk_cc_ccar_01" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_01\n" FKFieldsComments="Identifiant de la collection n\194\1761.\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="39" CaptionOffsetY="-2" StartIntervalOffsetX="7" StartIntervalOffsetY="-2" EndIntervalOffsetX="6" EndIntervalOffsetY="3" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="65" /> |
<RELATION ID="21498" RelationName="fk_cc_ccar_02" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_02\n" FKFieldsComments="Identifiant de la collection n\194\1762.\n" relDirection="1" MidOffset="22" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-44" CaptionOffsetY="-2" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="4" EndIntervalOffsetY="6" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="66" /> |
<RELATION ID="21560" RelationName="fk_cpr_cpar" Kind="1" SrcTable="21522" DestTable="21544" FKFields="cpr_id_projet=cpar_id_projet\n" FKFieldsComments="Identifiant du projet dans lequel la relation entre les deux personnes s\a\195\169tablie.\n" relDirection="2" MidOffset="215" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="1" CaptionOffsetY="-44" StartIntervalOffsetX="5" StartIntervalOffsetY="-27" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="70" /> |
<RELATION ID="21563" RelationName="fk_cp_cpar_01" Kind="1" SrcTable="1446" DestTable="21544" FKFields="cp_id_personne=cpar_id_personne_01\n" FKFieldsComments="Identifiant de la personne n\194\1761.\n" relDirection="4" MidOffset="13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="71" /> |
<RELATION ID="21616" RelationName="fk_cs_cpu_editeur" Kind="2" SrcTable="1445" DestTable="21188" FKFields="cs_id_structure=cpu_ce_truk_editeur\n" FKFieldsComments="Identifiant de la structure \195\169ditrice de la publication. S\ail n\aest pas renseignn\195\169 dans la table Structure, contient AUTRE# suivit du nom complet de la structure \195\169ditrice.\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="-6" StartIntervalOffsetY="-29" EndIntervalOffsetX="8" EndIntervalOffsetY="11" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="72" /> |
2451,7 → 2398,6 |
<RELATION ID="22068" RelationName="fk_cmhl_cprv_meta" Kind="2" SrcTable="21757" DestTable="21634" FKFields="cmhl_id_historique_ligne=cprv_ce_meta\n" FKFieldsComments="\n" relDirection="4" 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="81" /> |
<RELATION ID="22071" RelationName="fk_cmlv_cmhl_val" Kind="2" SrcTable="18466" DestTable="21757" FKFields="cmlv_id_valeur=cmhl_ce_etat\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="82" /> |
<RELATION ID="22073" RelationName="fk_cmhl_csap_meta" Kind="2" SrcTable="21757" DestTable="1447" FKFields="cmhl_id_historique_ligne=csap_ce_meta\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="82" /> |
<RELATION ID="22075" RelationName="fk_cmhl_ccar_meta" Kind="2" SrcTable="21757" DestTable="21486" FKFields="cmhl_id_historique_ligne=ccar_ce_meta\n" FKFieldsComments="\n" relDirection="4" 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="83" /> |
<RELATION ID="22077" RelationName="fk_cmhl_ccap_meta" Kind="2" SrcTable="21757" DestTable="21104" FKFields="cmhl_id_historique_ligne=ccap_ce_meta\n" FKFieldsComments="\n" relDirection="4" 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="84" /> |
<RELATION ID="22079" RelationName="fk_cmhl_cc_meta" Kind="2" SrcTable="21757" DestTable="1444" FKFields="cmhl_id_historique_ligne=cc_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="5" CaptionOffsetY="-5" 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="85" /> |
<RELATION ID="22081" RelationName="fk_cmhl_ccapu_meta" Kind="2" SrcTable="21757" DestTable="21219" FKFields="cmhl_id_historique_ligne=ccapu_ce_meta\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="86" /> |
2472,7 → 2418,6 |
<RELATION ID="22146" RelationName="fk_cmlv_csc_materiel_conservation" Kind="2" SrcTable="18466" DestTable="20850" FKFields="cmlv_id_valeur=csc_ce_materiel_conservation\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="101" /> |
<RELATION ID="22148" RelationName="fk_cmlv_cpuap_type" Kind="2" SrcTable="18466" DestTable="21235" FKFields="cmlv_id_valeur=cpuap_ce_truk_type\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="102" /> |
<RELATION ID="22150" RelationName="fk_cmlv_cpuap_role" Kind="1" SrcTable="18466" DestTable="21235" FKFields="cmlv_id_valeur=cpuap_id_role\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="103" /> |
<RELATION ID="22152" RelationName="fk_cmlv_ccar_relation" Kind="1" SrcTable="18466" DestTable="21486" FKFields="cmlv_id_valeur=ccar_id_relation\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="104" /> |
<RELATION ID="22154" RelationName="fk_cmlv_ccap_role" Kind="1" SrcTable="18466" DestTable="21104" FKFields="cmlv_id_valeur=ccap_id_role\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="105" /> |
<RELATION ID="22158" RelationName="fk_cmlv_cc_type" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_type\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="106" /> |
<RELATION ID="22160" RelationName="fk_cmlv_cc_developpement" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_developpement\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="107" /> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_projet.html |
---|
390,7 → 390,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_meta_liste_valeur.html |
---|
339,14 → 339,6 |
<tr class="pair" > |
<td> 24 </td> |
<td> fk_cmlv_ccar_relation </td> |
<td> cmlv_id_valeur </td> |
<td> ccar_id_relation </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 25 </td> |
<td> fk_cmlv_ccap_role </td> |
<td> cmlv_id_valeur </td> |
<td> ccap_id_role </td> |
354,7 → 346,7 |
</tr> |
<tr class="pair" > |
<td> 26 </td> |
<td> 25 </td> |
<td> fk_cmlv_cc_type </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_type </td> |
362,7 → 354,7 |
</tr> |
<tr class="pair" > |
<td> 27 </td> |
<td> 26 </td> |
<td> fk_cmlv_cc_developpement </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_developpement </td> |
370,7 → 362,7 |
</tr> |
<tr class="pair" > |
<td> 28 </td> |
<td> 27 </td> |
<td> fk_cmlv_cc_specimen_type </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_specimen_type </td> |
378,7 → 370,7 |
</tr> |
<tr class="pair" > |
<td> 29 </td> |
<td> 28 </td> |
<td> fk_cmlv_cc_specimen_type_classement </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_specimen_type_classement </td> |
386,7 → 378,7 |
</tr> |
<tr class="pair" > |
<td> 30 </td> |
<td> 29 </td> |
<td> fk_cmlv_ccb_unitte_rangement_etat </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_unite_rangement_etat </td> |
394,7 → 386,7 |
</tr> |
<tr class="pair" > |
<td> 31 </td> |
<td> 30 </td> |
<td> fk_cmlv_ccb_traitement </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_traitement </td> |
402,7 → 394,7 |
</tr> |
<tr class="pair" > |
<td> 32 </td> |
<td> 31 </td> |
<td> fk_cmlv_ccb_etat_general </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_etat_general </td> |
410,7 → 402,7 |
</tr> |
<tr class="pair" > |
<td> 33 </td> |
<td> 32 </td> |
<td> fk_cmlv_ccb_determination </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_determination </td> |
418,7 → 410,7 |
</tr> |
<tr class="pair" > |
<td> 34 </td> |
<td> 33 </td> |
<td> fk_cmlv_ccb_recolte_date_debut_type </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_recolte_date_debut_type </td> |
426,7 → 418,7 |
</tr> |
<tr class="pair" > |
<td> 35 </td> |
<td> 34 </td> |
<td> fk_cmlv_ccb_recolte_date_fin_type </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_recolte_date_fin_type </td> |
434,7 → 426,7 |
</tr> |
<tr class="pair" > |
<td> 36 </td> |
<td> 35 </td> |
<td> fk_cmlv_ccb_classement_etat </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_classement_etat </td> |
442,7 → 434,7 |
</tr> |
<tr class="pair" > |
<td> 37 </td> |
<td> 36 </td> |
<td> fk_cmlv_ccb_precision_localite </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_precision_localite </td> |
450,7 → 442,7 |
</tr> |
<tr class="pair" > |
<td> 38 </td> |
<td> 37 </td> |
<td> fk_cmlv_ccb_precision_date </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_precision_date </td> |
458,7 → 450,7 |
</tr> |
<tr class="pair" > |
<td> 39 </td> |
<td> 38 </td> |
<td> fk_cmlv_ccb_collection_integre </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_collection_integre </td> |
466,7 → 458,7 |
</tr> |
<tr class="pair" > |
<td> 40 </td> |
<td> 39 </td> |
<td> fk_cmlv_ccb_collection_integre_info </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_collection_integre_info </td> |
474,7 → 466,7 |
</tr> |
<tr class="pair" > |
<td> 41 </td> |
<td> 40 </td> |
<td> fk_cmlv_ccb_inventaire </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire </td> |
482,7 → 474,7 |
</tr> |
<tr class="pair" > |
<td> 42 </td> |
<td> 41 </td> |
<td> fk_cmlv_ccb_inventaire_auteur </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire_auteur </td> |
490,7 → 482,7 |
</tr> |
<tr class="pair" > |
<td> 43 </td> |
<td> 42 </td> |
<td> fk_cmlv_ccb_inventaire_forme </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire_forme </td> |
498,7 → 490,7 |
</tr> |
<tr class="pair" > |
<td> 44 </td> |
<td> 43 </td> |
<td> fk_cmlv_ccb_inventaire_digital </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_truk_inventaire_digital </td> |
506,7 → 498,7 |
</tr> |
<tr class="pair" > |
<td> 45 </td> |
<td> 44 </td> |
<td> fk_cmlv_ccb_inventaire_etat </td> |
<td> cmlv_id_valeur </td> |
<td> ccb_ce_inventaire_etat </td> |
514,7 → 506,7 |
</tr> |
<tr class="pair" > |
<td> 46 </td> |
<td> 45 </td> |
<td> fk_cmlv_cc_type_depot </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_type_depot </td> |
522,7 → 514,7 |
</tr> |
<tr class="pair" > |
<td> 47 </td> |
<td> 46 </td> |
<td> fk_cmlv_cpr_langue </td> |
<td> cmlv_id_valeur </td> |
<td> cpr_ce_langue </td> |
530,7 → 522,7 |
</tr> |
<tr class="pair" > |
<td> 48 </td> |
<td> 47 </td> |
<td> fk_cmlv_cpr_idx_duree </td> |
<td> cmlv_id_valeur </td> |
<td> cpr_ce_indexation_duree </td> |
538,7 → 530,7 |
</tr> |
<tr class="pair" > |
<td> 49 </td> |
<td> 48 </td> |
<td> fk_cmlv_cpr_idx_freq </td> |
<td> cmlv_id_valeur </td> |
<td> cpr_ce_indexation_freq </td> |
546,7 → 538,7 |
</tr> |
<tr class="pair" > |
<td> 50 </td> |
<td> 49 </td> |
<td> fk_cmlv_csap_role </td> |
<td> cmlv_id_valeur </td> |
<td> csap_id_role </td> |
554,7 → 546,7 |
</tr> |
<tr class="pair" > |
<td> 51 </td> |
<td> 50 </td> |
<td> fk_cmlv_cp_deces </td> |
<td> cmlv_id_valeur </td> |
<td> cp_ce_deces </td> |
562,7 → 554,7 |
</tr> |
<tr class="pair" > |
<td> 52 </td> |
<td> 51 </td> |
<td> fk_cmlv_cp_pays </td> |
<td> cmlv_id_valeur </td> |
<td> cp_ce_truk_pays </td> |
570,7 → 562,7 |
</tr> |
<tr class="pair" > |
<td> 53 </td> |
<td> 52 </td> |
<td> fk_cmlv_cp_region </td> |
<td> cmlv_id_valeur </td> |
<td> cp_ce_truk_region </td> |
578,7 → 570,7 |
</tr> |
<tr class="pair" > |
<td> 54 </td> |
<td> 53 </td> |
<td> fk_cmlv_cc_type_nbre_precision </td> |
<td> cmlv_id_valeur </td> |
<td> cc_ce_specimen_type_nbre_precision </td> |
602,7 → 594,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_module_Publication.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Publications.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
73,7 → 73,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_projet_version.html |
---|
186,7 → 186,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_meta_historique_ligne.html |
---|
299,14 → 299,6 |
<tr class="pair" > |
<td> 13 </td> |
<td> fk_cmhl_ccar_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccar_ce_meta </td> |
<td> <a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> </td> |
</tr> |
<tr class="pair" > |
<td> 14 </td> |
<td> fk_cmhl_ccap_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccap_ce_meta </td> |
314,7 → 306,7 |
</tr> |
<tr class="pair" > |
<td> 15 </td> |
<td> 14 </td> |
<td> fk_cmhl_cc_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cc_ce_meta </td> |
322,7 → 314,7 |
</tr> |
<tr class="pair" > |
<td> 16 </td> |
<td> 15 </td> |
<td> fk_cmhl_ccapu_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccapu_ce_meta </td> |
330,7 → 322,7 |
</tr> |
<tr class="pair" > |
<td> 17 </td> |
<td> 16 </td> |
<td> fk_cmhl_cpu_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cpu_ce_meta </td> |
338,7 → 330,7 |
</tr> |
<tr class="pair" > |
<td> 18 </td> |
<td> 17 </td> |
<td> fk_cmhl_cpuap_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cpuap_ce_meta </td> |
346,7 → 338,7 |
</tr> |
<tr class="pair" > |
<td> 19 </td> |
<td> 18 </td> |
<td> fk_cmlv_cmhl_table </td> |
<td> cmhl_ce_table </td> |
<td> cmlv_id_valeur </td> |
354,7 → 346,7 |
</tr> |
<tr class="pair" > |
<td> 20 </td> |
<td> 19 </td> |
<td> fk_cmhl_cpras_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> cpras_ce_meta </td> |
362,7 → 354,7 |
</tr> |
<tr class="pair" > |
<td> 21 </td> |
<td> 20 </td> |
<td> fk_cmhl_csc_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> csc_ce_meta </td> |
370,7 → 362,7 |
</tr> |
<tr class="pair" > |
<td> 22 </td> |
<td> 21 </td> |
<td> fk_cmhl_csv_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> csv_ce_meta </td> |
378,7 → 370,7 |
</tr> |
<tr class="pair" > |
<td> 23 </td> |
<td> 22 </td> |
<td> fk_cmhl_ccb_meta </td> |
<td> cmhl_id_historique_ligne </td> |
<td> ccb_ce_meta </td> |
402,7 → 394,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_publication_a_personne.html |
---|
186,7 → 186,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_module_Personne.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Personnes.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
73,7 → 73,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_personne_a_relation.html |
---|
186,7 → 186,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_module_Collection.html |
---|
45,7 → 45,7 |
<p> |
Module de gestion des Collections.<br /> |
<br /> |
<b>Révision : </b>1157 |
<b>Révision : </b>1159 |
</p> |
<h2> Liste des tables </h2> |
58,8 → 58,6 |
<li><a href="coel_table_coel_collection_a_publication.html">coel_collection_a_publication</a> : Permet de lister les publication liées à une collection.</li> |
<li><a href="coel_table_coel_collection_a_relation.html">coel_collection_a_relation</a> : Permet de lister les relations entre collection autre que hiérarchique.</li> |
<li><a href="coel_table_coel_collection_botanique.html">coel_collection_botanique</a> : Toutes les informations spécialisées sur une collection de type : botanique</li> |
</ol> |
81,7 → 79,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |
/branches/v1.0-syrah/doc/bdd/coel_table_coel_structure_conservation.html |
---|
374,7 → 374,7 |
</div> |
<div id="zone_contenu_pied"> |
<p>Documentation générée le 26 janvier 2010 11:43:08</p> |
<p>Documentation générée le 29 janvier 2010 12:20:36</p> |
<!-- CONTENU_PIED --> |
</div> |