/trunk/doc/bdd/coel.sql |
---|
1,6 → 1,6 |
# Encodage : UTF-8 |
# Nom : Coel v1.0 |
# Date de création : 2009-02-18 19:12:47 |
# Date de création : 2009-03-05 12:55:18 |
#---------------------------------------------------------------------------------------------------------------------# |
# Création des tables |
CREATE TABLE IF NOT EXISTS `tb_coel`.`coel_collection` ( |
53,7 → 53,7 |
CREATE TABLE IF NOT EXISTS `tb_coel`.`coel_structure` ( |
`cs_id_structure` INTEGER NOT NULL auto_increment COMMENT 'Identifiant de la structure.', |
`cs_ce_projet` INTEGER NOT NULL COMMENT 'Identifiant du projet dans lequel les informations de la structure sont saisies.', |
`cs_ce_mere` INTEGER NOT NULL COMMENT 'Identifiant de la structure mère.', |
`cs_ce_mere` INTEGER NOT NULL default 0 COMMENT 'Identifiant de la structure mère.', |
`cs_guid` VARCHAR(255) COMMENT 'URI (LSID ou URL) de la structure. Dans le format RDF, cela sera utilisé comme URI des données de l''institutions.', |
`cs_truk_identifiant_alternatif` VARCHAR(255) COMMENT 'Identifiant alternatif. Par exemple, l''acronyme de l''Index Herbariorum ou du MNHN. Séparer les différentes valeurs par un point virgule ";" et le type d''identifiant de sa valeur par un dièze "#". Exemple : IH#MPU;MNHN#163', |
`cs_nom` VARCHAR(255) COMMENT 'Nom officiel de la structure dans sa langue d''origine.', |
60,8 → 60,8 |
`cs_truk_nom_alternatif` VARCHAR(255) COMMENT 'Autres noms de la structures. Séparer les différentes valeurs par un point virgule ";".', |
`cs_description` TEXT COMMENT 'Description de la structure pour le public.', |
`cs_ce_type` INTEGER COMMENT 'Identifiant du type de la structure vis à vis du standard NCD.', |
`cs_ce_truk_type_prive` INTEGER default 0 COMMENT 'Type privé de structure.', |
`cs_ce_truk_type_public` INTEGER default 0 COMMENT 'Type public de structure.', |
`cs_ce_truk_type_prive` VARCHAR(255) default 0 COMMENT 'Type privé de structure.', |
`cs_ce_truk_type_public` VARCHAR(255) default 0 COMMENT 'Type public de structure.', |
`cs_adresse_01` VARCHAR(255) COMMENT 'Adresse principale.', |
`cs_adresse_02` VARCHAR(255) COMMENT 'Complément d''adresse.', |
`cs_date_fondation` DATE COMMENT 'Date de fondation de la structure.', |
251,7 → 251,7 |
# Insertion des méta-données |
CREATE TABLE IF NOT EXISTS `tb_coel`.`coel_collection_botanique` ( |
`ccb_id_collection` INTEGER NOT NULL auto_increment COMMENT 'Identifiant de la collection botanique.', |
`ccb_ce_truk_type` INTEGER COMMENT 'Type(s) précis de collection botanique.', |
`ccb_ce_truk_type` VARCHAR(255) COMMENT 'Type(s) de collection botanique.', |
`ccb_truk_unite_rangement` VARCHAR(510) COMMENT 'Type(s) unité de rangement de la collection botanique. \ |
Pour chaque type : indication du nombre d''unité, de la précision du nom (exact, approximatif), des formats.', |
`ccb_ce_unite_rangement_etat` INTEGER COMMENT 'État de la majorité des unités de rangements (état des rubans, des poignées, des sangles, des cartons...).', |
2660,11 → 2660,11 |
INSERT INTO `tb_coel`.`coel_meta_historique_ligne` (`cmhl_id_historique_ligne` ,`cmhl_ce_table` ,`cmhl_cle_ligne` ,`cmhl_enregistrement` ,`cmhl_date_modification` ,`cmhl_notes` ,`cmhl_ce_modifier_par` ,`cmhl_ce_etat` ,`cmhl_ip`) VALUES |
('556', '116', '50', NULL , NOW( ) , 'Ajout des informations sur une colonne.', '1', '1', '162.38.234.1'); |
INSERT INTO `tb_coel`.`coel_meta_colonne` (`cmc_id_champ` ,`cmc_ce_projet` ,`cmc_ce_liste` ,`cmc_ce_table` ,`cmc_nom` ,`cmc_abreviation` ,`cmc_description` ,`cmc_ce_format_sql` ,`cmc_taille` ,`cmc_ce_meta`) VALUES |
('51', '1', '1015', '119', 'cs_ce_truk_type_prive', 'cs_ce_ttp', 'Type privé de structure.', '15', '', '557'); |
('51', '1', '1015', '119', 'cs_ce_truk_type_prive', 'cs_ce_ttp', 'Type privé de structure.', '29', '255', '557'); |
INSERT INTO `tb_coel`.`coel_meta_historique_ligne` (`cmhl_id_historique_ligne` ,`cmhl_ce_table` ,`cmhl_cle_ligne` ,`cmhl_enregistrement` ,`cmhl_date_modification` ,`cmhl_notes` ,`cmhl_ce_modifier_par` ,`cmhl_ce_etat` ,`cmhl_ip`) VALUES |
('557', '116', '51', NULL , NOW( ) , 'Ajout des informations sur une colonne.', '1', '1', '162.38.234.1'); |
INSERT INTO `tb_coel`.`coel_meta_colonne` (`cmc_id_champ` ,`cmc_ce_projet` ,`cmc_ce_liste` ,`cmc_ce_table` ,`cmc_nom` ,`cmc_abreviation` ,`cmc_description` ,`cmc_ce_format_sql` ,`cmc_taille` ,`cmc_ce_meta`) VALUES |
('52', '1', '1016', '119', 'cs_ce_truk_type_public', 'cs_ce_ttp', 'Type public de structure.', '15', '', '558'); |
('52', '1', '1016', '119', 'cs_ce_truk_type_public', 'cs_ce_ttp', 'Type public de structure.', '29', '255', '558'); |
INSERT INTO `tb_coel`.`coel_meta_historique_ligne` (`cmhl_id_historique_ligne` ,`cmhl_ce_table` ,`cmhl_cle_ligne` ,`cmhl_enregistrement` ,`cmhl_date_modification` ,`cmhl_notes` ,`cmhl_ce_modifier_par` ,`cmhl_ce_etat` ,`cmhl_ip`) VALUES |
('558', '116', '52', NULL , NOW( ) , 'Ajout des informations sur une colonne.', '1', '1', '162.38.234.1'); |
INSERT INTO `tb_coel`.`coel_meta_colonne` (`cmc_id_champ` ,`cmc_ce_projet` ,`cmc_ce_liste` ,`cmc_ce_table` ,`cmc_nom` ,`cmc_abreviation` ,`cmc_description` ,`cmc_ce_format_sql` ,`cmc_taille` ,`cmc_ce_meta`) VALUES |
3184,7 → 3184,7 |
INSERT INTO `tb_coel`.`coel_meta_historique_ligne` (`cmhl_id_historique_ligne` ,`cmhl_ce_table` ,`cmhl_cle_ligne` ,`cmhl_enregistrement` ,`cmhl_date_modification` ,`cmhl_notes` ,`cmhl_ce_modifier_par` ,`cmhl_ce_etat` ,`cmhl_ip`) VALUES |
('687', '116', '181', NULL , NOW( ) , 'Ajout des informations sur une colonne.', '1', '1', '162.38.234.1'); |
INSERT INTO `tb_coel`.`coel_meta_colonne` (`cmc_id_champ` ,`cmc_ce_projet` ,`cmc_ce_liste` ,`cmc_ce_table` ,`cmc_nom` ,`cmc_abreviation` ,`cmc_description` ,`cmc_ce_format_sql` ,`cmc_taille` ,`cmc_ce_meta`) VALUES |
('182', '1', '0', '106', 'ccb_ce_truk_type', 'ccb_ce_tt', 'Type(s) précis de collection botanique.', '15', '', '688'); |
('182', '1', '0', '106', 'ccb_ce_truk_type', 'ccb_ce_tt', 'Type(s) de collection botanique.', '29', '255', '688'); |
INSERT INTO `tb_coel`.`coel_meta_historique_ligne` (`cmhl_id_historique_ligne` ,`cmhl_ce_table` ,`cmhl_cle_ligne` ,`cmhl_enregistrement` ,`cmhl_date_modification` ,`cmhl_notes` ,`cmhl_ce_modifier_par` ,`cmhl_ce_etat` ,`cmhl_ip`) VALUES |
('688', '116', '182', NULL , NOW( ) , 'Ajout des informations sur une colonne.', '1', '1', '162.38.234.1'); |
INSERT INTO `tb_coel`.`coel_meta_colonne` (`cmc_id_champ` ,`cmc_ce_projet` ,`cmc_ce_liste` ,`cmc_ce_table` ,`cmc_nom` ,`cmc_abreviation` ,`cmc_description` ,`cmc_ce_format_sql` ,`cmc_taille` ,`cmc_ce_meta`) VALUES |
3802,8 → 3802,6 |
INSERT INTO `phpmyadmin`.`pma_relation` (`master_db`, `master_table`, `master_field`, `foreign_db`, `foreign_table`, `foreign_field`) |
VALUES ('tb_coel', 'coel_collection', 'cc_ce_specimen_type_classement', 'tb_coel', 'coel_meta_liste_valeur', 'cmlv_id_valeur'); |
INSERT INTO `phpmyadmin`.`pma_relation` (`master_db`, `master_table`, `master_field`, `foreign_db`, `foreign_table`, `foreign_field`) |
VALUES ('tb_coel', 'coel_collection_botanique', 'ccb_ce_truk_type', 'tb_coel', 'coel_meta_liste_valeur', 'cmlv_id_valeur'); |
INSERT INTO `phpmyadmin`.`pma_relation` (`master_db`, `master_table`, `master_field`, `foreign_db`, `foreign_table`, `foreign_field`) |
VALUES ('tb_coel', 'coel_collection_botanique', 'ccb_ce_unite_rangement_etat', 'tb_coel', 'coel_meta_liste_valeur', 'cmlv_id_valeur'); |
INSERT INTO `phpmyadmin`.`pma_relation` (`master_db`, `master_table`, `master_field`, `foreign_db`, `foreign_table`, `foreign_field`) |
VALUES ('tb_coel', 'coel_collection_botanique', 'ccb_ce_traitement', 'tb_coel', 'coel_meta_liste_valeur', 'cmlv_id_valeur'); |
3861,7 → 3859,7 |
INSERT INTO `phpmyadmin`.`pma_designer_coords` (`db_name`, `table_name`, `x`, `y`, `v`, `h`) |
VALUES ('tb_coel', 'coel_collection_a_personne', 473, 1068, 1, 1); |
INSERT INTO `phpmyadmin`.`pma_designer_coords` (`db_name`, `table_name`, `x`, `y`, `v`, `h`) |
VALUES ('tb_coel', 'coel_collection_botanique', 455, 1332, 1, 1); |
VALUES ('tb_coel', 'coel_collection_botanique', 443, 1329, 1, 1); |
INSERT INTO `phpmyadmin`.`pma_designer_coords` (`db_name`, `table_name`, `x`, `y`, `v`, `h`) |
VALUES ('tb_coel', 'coel_publication', 100, 2366, 1, 1); |
INSERT INTO `phpmyadmin`.`pma_designer_coords` (`db_name`, `table_name`, `x`, `y`, `v`, `h`) |
/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="1521" 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="847" 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="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" /> |
<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" /> |
</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" > |
521,7 → 521,7 |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21165" ColName="cs_ce_mere" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure m\195\168re."> |
<COLUMN ID="21165" ColName="cs_ce_mere" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant de la structure m\195\168re."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
557,15 → 557,13 |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21169" ColName="cs_ce_truk_type_prive" PrevColName="" Pos="24" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Type priv\195\169 de structure."> |
<COLUMN ID="21169" ColName="cs_ce_truk_type_prive" PrevColName="" Pos="24" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Type priv\195\169 de structure."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21170" ColName="cs_ce_truk_type_public" PrevColName="" Pos="25" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Type public de structure."> |
<COLUMN ID="21170" ColName="cs_ce_truk_type_public" PrevColName="" Pos="25" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Type public de structure."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
1150,7 → 1148,6 |
<RELATION_START ID="22160" /> |
<RELATION_START ID="22162" /> |
<RELATION_START ID="22164" /> |
<RELATION_START ID="22166" /> |
<RELATION_START ID="22170" /> |
<RELATION_START ID="22172" /> |
<RELATION_START ID="22174" /> |
1454,7 → 1451,7 |
</INDEX> |
</INDICES> |
</TABLE> |
<TABLE ID="21148" Tablename="coel_collection_botanique" PrevTableName="Table_14" XPos="455" YPos="1332" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Toutes les informations sp\195\169cialis\195\169es sur une collection de type : botanique" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" > |
<TABLE ID="21148" Tablename="coel_collection_botanique" PrevTableName="Table_14" XPos="443" YPos="1329" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Toutes les informations sp\195\169cialis\195\169es sur une collection de type : botanique" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" > |
<COLUMNS> |
<COLUMN ID="21150" ColName="ccb_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection botanique."> |
<OPTIONSELECTED> |
1462,9 → 1459,8 |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="21156" ColName="ccb_ce_truk_type" PrevColName="ccb_ce_type" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type(s) pr\195\169cis de collection botanique."> |
<COLUMN ID="26508" ColName="ccb_ce_truk_type" PrevColName="" Pos="41" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de collection botanique."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="1" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
1683,7 → 1679,6 |
</COLUMNS> |
<RELATIONS_END> |
<RELATION_END ID="21152" /> |
<RELATION_END ID="22166" /> |
<RELATION_END ID="22170" /> |
<RELATION_END ID="22172" /> |
<RELATION_END ID="22174" /> |
2361,7 → 2356,6 |
<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" /> |
<RELATION ID="22162" RelationName="fk_cmlv_cc_specimen_type" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_specimen_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="108" /> |
<RELATION ID="22164" RelationName="fk_cmlv_cc_specimen_type_classement" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_specimen_type_classement\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="109" /> |
<RELATION ID="22166" RelationName="fk_cmlv_ccb_type" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_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="110" /> |
<RELATION ID="22170" RelationName="fk_cmlv_ccb_unitte_rangement_etat" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_unite_rangement_etat\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="111" /> |
<RELATION ID="22172" RelationName="fk_cmlv_ccb_traitement" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_traitement\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="112" /> |
<RELATION ID="22174" RelationName="fk_cmlv_ccb_etat_general" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_etat_general\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="113" /> |