| /branches/v2.0-betulales/doc/bdd/referentiel.sql |
|---|
| New file |
| 0,0 → 1,33 |
| CREATE TABLE IF NOT EXISTS `ref_triple` ( |
| `id_triple` int(10) unsigned NOT NULL auto_increment, |
| `ressource` varchar(255) default NULL, |
| `propriete` varchar(255) default NULL, |
| `valeur` text, |
| PRIMARY KEY (`id_triple`), |
| KEY `ressource` (`ressource`), |
| KEY `propriete` (`propriete`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| CREATE TABLE IF NOT EXISTS `ref_traitement` ( |
| `id_traitement` int(10) unsigned NOT NULL auto_increment, |
| `referentiel_code` varchar(50) default NULL, |
| `script` varchar(50) default NULL COMMENT 'Nom du script à lancer.', |
| `nom` varchar(100) default NULL, |
| `date_debut` datetime default NULL, |
| `date_fin` datetime default NULL, |
| `duree` time default NULL, |
| `meta_date_creation` datetime default NULL, |
| PRIMARY KEY (`id_traitement`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| CREATE TABLE IF NOT EXISTS `ref_resultat` ( |
| `id_resultat` int(10) unsigned NOT NULL auto_increment, |
| `ce_traitement` int(10) unsigned default NULL, |
| `nom` varchar(100) default NULL, |
| `description` text, |
| `resultat` tinyint(1) default NULL, |
| `message` mediumtext, |
| `meta_date_creation` datetime default NULL, |
| PRIMARY KEY (`id_resultat`), |
| KEY `ce_traitement` (`ce_traitement`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| /branches/v2.0-betulales/doc/bdd/referentiel.xml |
|---|
| New file |
| 0,0 → 1,589 |
| <?xml version="1.0" standalone="yes" ?> |
| <DBMODEL Version="4.0"> |
| <SETTINGS> |
| <GLOBALSETTINGS ModelName="referentiel" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="0" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="0" DefaultTableType="0" ActivateRefDefForNewRelations="0" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Nimbus Sans L" CanvasWidth="4096" CanvasHeight="2842" /> |
| <DATATYPEGROUPS> |
| <DATATYPEGROUP Name="Numeric Types" Icon="1" /> |
| <DATATYPEGROUP Name="Date and Time Types" Icon="2" /> |
| <DATATYPEGROUP Name="String Types" Icon="3" /> |
| <DATATYPEGROUP Name="Blob and Text Types" Icon="4" /> |
| <DATATYPEGROUP Name="User defined Types" Icon="5" /> |
| <DATATYPEGROUP Name="Geographic Types" Icon="6" /> |
| </DATATYPEGROUPS> |
| <DATATYPES> |
| <DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="UNSIGNED" Default="1" /> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="UNSIGNED" Default="1" /> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="UNSIGNED" Default="1" /> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="UNSIGNED" Default="0" /> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="3" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="UNSIGNED" Default="1" /> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| <OPTION Name="INFO" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="UNSIGNED" Default="0" /> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="precision" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| <PARAM Name="decimals" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| <PARAM Name="decimals" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| <PARAM Name="decimals" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| <PARAM Name="decimals" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| <PARAM Name="decimals" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| <PARAM Name="decimals" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="ZEROFILL" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| </DATATYPE> |
| <DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| </DATATYPE> |
| <DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="BINARY" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="2" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="length" /> |
| </PARAMS> |
| <OPTIONS> |
| <OPTION Name="BINARY" Default="0" /> |
| <OPTION Name="INFO" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="values" /> |
| </PARAMS> |
| </DATATYPE> |
| <DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <PARAMS> |
| <PARAM Name="values" /> |
| </PARAMS> |
| </DATATYPE> |
| <DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <OPTIONS> |
| <OPTION Name="BINARY" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <OPTIONS> |
| <OPTION Name="BINARY" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| <OPTIONS> |
| <OPTION Name="BINARY" Default="0" /> |
| </OPTIONS> |
| </DATATYPE> |
| <DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| <DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > |
| </DATATYPE> |
| </DATATYPES> |
| <COMMON_DATATYPES> |
| <COMMON_DATATYPE ID="5" /> |
| <COMMON_DATATYPE ID="8" /> |
| <COMMON_DATATYPE ID="20" /> |
| <COMMON_DATATYPE ID="15" /> |
| <COMMON_DATATYPE ID="22" /> |
| <COMMON_DATATYPE ID="28" /> |
| <COMMON_DATATYPE ID="26" /> |
| <COMMON_DATATYPE ID="33" /> |
| <COMMON_DATATYPE ID="34" /> |
| <COMMON_DATATYPE ID="35" /> |
| </COMMON_DATATYPES> |
| <TABLEPREFIXES> |
| <TABLEPREFIX Name="Defaut (pas de prefixe)" /> |
| </TABLEPREFIXES> |
| <REGIONCOLORS> |
| <REGIONCOLOR Color="Red=#FFEEEC" /> |
| <REGIONCOLOR Color="Yellow=#FEFDED" /> |
| <REGIONCOLOR Color="Green=#EAFFE5" /> |
| <REGIONCOLOR Color="Cyan=#ECFDFF" /> |
| <REGIONCOLOR Color="Blue=#F0F1FE" /> |
| <REGIONCOLOR Color="Magenta=#FFEBFA" /> |
| </REGIONCOLORS> |
| <POSITIONMARKERS> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> |
| </POSITIONMARKERS> |
| </SETTINGS> |
| <METADATA> |
| <REGIONS> |
| <REGION ID="28021" RegionName="Exemple BDNT" XPos="743" YPos="25" Width="668" Height="529" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="7" /> |
| <REGION ID="27985" RegionName="Traitements" XPos="28" YPos="24" Width="691" Height="530" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Tables permettant de r\195\169aliser des traitments sur les donn\195\169es des r\195\169f\195\169rentiels." IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" /> |
| </REGIONS> |
| <TABLES> |
| <TABLE ID="27977" Tablename="ref_traitement" PrevTableName="Table_01" XPos="87" YPos="74" 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="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" > |
| <COLUMNS> |
| <COLUMN ID="27979" ColName="id_traitement" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Id auto incr\195\169ment\195\169 de la demande de traitement"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28015" ColName="referentiel_code" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Code du r\195\169f\195\169rentiel \195\160 traiter (ex. BDNFF)."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28049" ColName="script" PrevColName="type_2" Pos="7" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du script \195\160 lancer."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28051" ColName="script_parametres" PrevColName="" Pos="8" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Ensemble de param\195\170tres n\195\169cessaire au script dans le format choisis par le d\195\169veloppeur du script (XML, Json, variables serialis\195\169es...)."> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="27984" ColName="nom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du traitement"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="27982" ColName="date_debut" PrevColName="" Pos="2" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date et heure de d\195\169but du lancement du traitement"> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="27983" ColName="date_fin" PrevColName="" Pos="3" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date et heure de fin de traitement"> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28020" ColName="duree" PrevColName="" Pos="6" idDatatype="17" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Dur\195\169e du traitement"> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="27981" ColName="meta_date_creation" PrevColName="date_creation" Pos="1" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date et heure de cr\195\169ation de la demande de traitement."> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| </COLUMNS> |
| <RELATIONS_START> |
| <RELATION_START ID="27995" /> |
| </RELATIONS_START> |
| <INDICES> |
| <INDEX ID="27980" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> |
| <INDEXCOLUMNS> |
| <INDEXCOLUMN idColumn="27979" LengthParam="0" /> |
| </INDEXCOLUMNS> |
| </INDEX> |
| </INDICES> |
| </TABLE> |
| <TABLE ID="27986" Tablename="ref_resultat" PrevTableName="Table_02" XPos="86" YPos="289" 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="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4" > |
| <COLUMNS> |
| <COLUMN ID="27988" ColName="id_resultat" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="27990" ColName="ce_traitement" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28000" ColName="nom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28018" ColName="description" PrevColName="" Pos="6" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28017" ColName="resultat" PrevColName="" Pos="5" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="27992" ColName="message" PrevColName="" Pos="3" idDatatype="29" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="27991" ColName="meta_date_creation" PrevColName="date_creation" Pos="2" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| </COLUMNS> |
| <RELATIONS_END> |
| <RELATION_END ID="27995" /> |
| </RELATIONS_END> |
| <INDICES> |
| <INDEX ID="27989" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> |
| <INDEXCOLUMNS> |
| <INDEXCOLUMN idColumn="27988" LengthParam="0" /> |
| </INDEXCOLUMNS> |
| </INDEX> |
| <INDEX ID="28013" IndexName="ce_traitement" IndexKind="1" FKRefDef_Obj_id="-1"> |
| <INDEXCOLUMNS> |
| <INDEXCOLUMN idColumn="27990" LengthParam="0" /> |
| </INDEXCOLUMNS> |
| </INDEX> |
| </INDICES> |
| </TABLE> |
| <TABLE ID="28002" Tablename="ref_triple" PrevTableName="Table_03" XPos="506" YPos="103" 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="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="6" > |
| <COLUMNS> |
| <COLUMN ID="28004" ColName="id_triple" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28006" ColName="ressource" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28007" ColName="propriete" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28008" ColName="valeur" PrevColName="" Pos="3" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| </COLUMNS> |
| <INDICES> |
| <INDEX ID="28005" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> |
| <INDEXCOLUMNS> |
| <INDEXCOLUMN idColumn="28004" LengthParam="0" /> |
| </INDEXCOLUMNS> |
| </INDEX> |
| <INDEX ID="28010" IndexName="ressource" IndexKind="1" FKRefDef_Obj_id="-1"> |
| <INDEXCOLUMNS> |
| <INDEXCOLUMN idColumn="28006" LengthParam="0" /> |
| </INDEXCOLUMNS> |
| </INDEX> |
| <INDEX ID="28011" IndexName="propriete" IndexKind="1" FKRefDef_Obj_id="-1"> |
| <INDEXCOLUMNS> |
| <INDEXCOLUMN idColumn="28007" LengthParam="0" /> |
| </INDEXCOLUMNS> |
| </INDEX> |
| </INDICES> |
| </TABLE> |
| <TABLE ID="28022" Tablename="bdnt_meta" PrevTableName="Table_04" XPos="768" YPos="61" 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="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" > |
| <COLUMNS> |
| <COLUMN ID="28024" ColName="id_meta" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28026" ColName="titre" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(128)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=" Le nom complet."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28027" ColName="code" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(16)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le code correspondant \195\160 l\aabr\195\169viation ou \195\160 l\aacronyme du titre."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28028" ColName="domaine_taxo" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom du groupe taxonomique dans lequel le r\195\169f\195\169rentiel s\ainscrit."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28029" ColName="domaine_geo" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom de la zone g\195\169ographique la plus large prise en compte par le r\195\169f\195\169rentiel."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28030" ColName="domaine_nom" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(8)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation d\aun ou plusieurs codes de nomenclature utilis\195\169 dans ce r\195\169f\195\169rentiel. Liste des codes : CINB, CINPC."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28031" ColName="classification" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(128)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom de la classification retenue Cl."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28032" ColName="version" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(8)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro de version du r\195\169f\195\169rentiel sous la forme : version majeure.version mineure."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28033" ColName="coordinateur" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Informations sur le coordinateur du r\195\169f\195\169rentiel sous la forme : Pr\195\169nom1 NOM1 (Organisation1) \kcourriel1\g"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28034" ColName="auteur" PrevColName="" Pos="9" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste des auteurs du r\195\169f\195\169rentiel sous la forme : Pr\195\169nom1 NOM1 (Organisation1) \kcourriel1\g, Pr\195\169nom2 NOM2 (Organisation2) \kcourriel2\g"> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28035" ColName="contributeur" PrevColName="" Pos="10" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste des contributeurs au r\195\169f\195\169rentiel sous la forme : Pr\195\169nom1 NOM1 (Organisation1) \kcourriel1\g, Pr\195\169nom2 NOM2 (Organisation2) \kcourriel2\g"> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28036" ColName="date_production" PrevColName="" Pos="11" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date correspondant \195\160 la derni\195\168re modification effectu\195\169e par le groupe de travail sur la version courante. Format : AAAA-MM-JJ"> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28037" ColName="date_validation" PrevColName="" Pos="12" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date correspondant \195\160 la validation par le SINP de la version courante. Format : AAAA-MM-JJ"> |
| <OPTIONSELECTED> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28038" ColName="source" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Un permalien indiquant la page o\195\185 l\aon peut t\195\169l\195\169charger la pr\195\169sente version"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28039" ColName="contact" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Une adresse de courriel o\195\185 il est possible de poser des questions, faire des remarques..."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28040" ColName="editeur" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom de l\aorganisation dans le cadre de laquelle le r\195\169f\195\169rentiel a \195\169t\195\169 produit"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28041" ColName="droit" PrevColName="" Pos="16" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Mention l\195\169gale (copyright)"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28042" ColName="licence" PrevColName="" Pos="17" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL de la licence du document"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28043" ColName="referencement" PrevColName="" Pos="18" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indique comment d\195\169signer le r\195\169f\195\169rentiel dans une bibliographie par exemple"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28044" ColName="stat_combinaison" PrevColName="" Pos="19" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nombre de combinaisons nomenclaturales"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28045" ColName="stat_taxon" PrevColName="" Pos="20" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nombre de noms retenus (taxons)"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28046" ColName="stat_modification" PrevColName="" Pos="21" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nombre de lignes modifi\195\169es par rapport \195\160 la version pr\195\169c\195\169dente."> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="1" /> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| <COLUMN ID="28047" ColName="signature" PrevColName="" Pos="22" idDatatype="20" DatatypeParams="(32)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Signature md5 du fichier du r\195\169f\195\169rentiel"> |
| <OPTIONSELECTED> |
| <OPTIONSELECT Value="0" /> |
| <OPTIONSELECT Value="0" /> |
| </OPTIONSELECTED> |
| </COLUMN> |
| </COLUMNS> |
| <INDICES> |
| <INDEX ID="28025" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> |
| <INDEXCOLUMNS> |
| <INDEXCOLUMN idColumn="28024" LengthParam="0" /> |
| </INDEXCOLUMNS> |
| </INDEX> |
| </INDICES> |
| </TABLE> |
| </TABLES> |
| <RELATIONS> |
| <RELATION ID="27995" RelationName="fk_rt_rr" Kind="2" SrcTable="27977" DestTable="27986" FKFields="id_traitement=ce_traitement\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-36" CaptionOffsetY="-25" 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="5" /> |
| </RELATIONS> |
| <NOTES> |
| </NOTES> |
| <IMAGES> |
| </IMAGES> |
| </METADATA> |
| <PLUGINDATA> |
| <PLUGINDATARECORDS> |
| </PLUGINDATARECORDS> |
| </PLUGINDATA> |
| <QUERYDATA> |
| <QUERYRECORDS> |
| </QUERYRECORDS> |
| </QUERYDATA> |
| <LINKEDMODELS> |
| </LINKEDMODELS> |
| </DBMODEL> |
| /branches/v2.0-betulales/doc/bdd/bdnt.sql |
|---|
| New file |
| 0,0 → 1,51 |
| CREATE TABLE bdnt_meta ( |
| id_meta INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
| titre VARCHAR(128) NULL , |
| code VARCHAR(16) NULL , |
| domaine_taxo VARCHAR(64) NULL , |
| domaine_geo VARCHAR(64) NULL , |
| domaine_nom VARCHAR(8) NULL , |
| classification VARCHAR(128) NULL , |
| version VARCHAR(8) NULL , |
| coordinateur VARCHAR(256) NULL , |
| auteur TEXT NULL , |
| contributeur TEXT NULL , |
| date_production DATE NULL , |
| date_validation DATE NULL , |
| source VARCHAR(256) NULL , |
| contact VARCHAR(64) NULL , |
| editeur VARCHAR(64) NULL , |
| droit VARCHAR(64) NULL , |
| licence VARCHAR(256) NULL , |
| referencement VARCHAR(256) NULL , |
| stat_combinaison INTEGER UNSIGNED NULL , |
| stat_taxon INTEGER UNSIGNED NULL , |
| stat_modification INTEGER UNSIGNED NULL , |
| signature VARCHAR(32) NULL , |
| PRIMARY KEY(id_meta)); |
| /branches/v2.0-betulales/doc/bdd/creation_bdnt_test.sql |
|---|
| New file |
| 0,0 → 1,140 |
| --1,71574,19287,71567,71576,51777,7579,74979,77216,10,11,17,128,127,129,162,189,74932,376,374,365,85795,100897,1150,1153,85823,101130,3073,3167,84866,100931,100964,101139,9520,82082,9519,9513,85993,100947,23605,23603,23604,74929,83587,83705,85791,85945,86363,100916,100946,100980,101004,101012,101029,101040,101050,101053,101061,101132,101135,101140,102735,102741,102745,102750,102751,102752,102760,102761,102762,102768,102770,102771,102778,102791 |
| SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| -- |
| -- Base de données: `referentiels` |
| -- |
| -- -------------------------------------------------------- |
| -- |
| -- Structure de la table `bdnt` |
| -- |
| CREATE TABLE IF NOT EXISTS `bdnt` ( |
| `num_nom` int(9) NOT NULL DEFAULT '0', |
| `num_nom_retenu` varchar(9) DEFAULT NULL, |
| `num_tax_sup` varchar(9) DEFAULT NULL, |
| `rang` int(4) NOT NULL, |
| `nom_sci` varchar(500) NOT NULL, |
| `nom_supra_generique` varchar(100) DEFAULT NULL, |
| `genre` varchar(100) DEFAULT NULL, |
| `epithete_infra_generique` varchar(100) DEFAULT NULL, |
| `epithete_sp` varchar(100) DEFAULT NULL, |
| `type_epithete` varchar(100) DEFAULT NULL, |
| `epithete_infra_sp` varchar(100) DEFAULT NULL, |
| `cultivar_groupe` varchar(100) DEFAULT NULL, |
| `cultivar` varchar(100) DEFAULT NULL, |
| `nom_commercial` varchar(100) DEFAULT NULL, |
| `auteur` varchar(100) DEFAULT NULL, |
| `annee` varchar(4) DEFAULT NULL, |
| `biblio_origine` varchar(500) DEFAULT NULL, |
| `notes` text, |
| `nom_addendum` varchar(500) DEFAULT NULL, |
| `homonyme` varchar(1) DEFAULT NULL, |
| `basionyme` varchar(9) DEFAULT NULL, |
| `synonyme_proparte` varchar(100) DEFAULT NULL, |
| `synonyme_douteux` varchar(1) DEFAULT NULL, |
| `synonyme_mal_applique` varchar(1) DEFAULT NULL, |
| `synonyme_orthographique` varchar(9) DEFAULT NULL, |
| `hybride_parent_01` varchar(9) DEFAULT NULL, |
| `hybride_parent_01_notes` text, |
| `hybride_parent_02` varchar(9) DEFAULT NULL, |
| `hybride_parent_02_notes` text, |
| `nom_francais` varchar(500) DEFAULT NULL, |
| `presence` varchar(100) DEFAULT NULL, |
| `statut_origine` varchar(100) DEFAULT NULL, |
| `statut_introduction` varchar(100) DEFAULT NULL, |
| `statut_culture` varchar(100) DEFAULT NULL, |
| `presence_Ga` varchar(10) DEFAULT NULL, |
| `presence_Co` varchar(10) DEFAULT NULL, |
| `exclure_taxref` int(1) DEFAULT NULL, |
| `num_taxonomique` int(9) DEFAULT NULL, |
| PRIMARY KEY (`num_nom`), |
| KEY `nom_complet` (`nom_sci`(333)), |
| KEY `nom_francais` (`nom_francais`(333)) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| -- |
| -- Contenu de la table `bdnt` |
| -- |
| INSERT INTO `bdnt` (`num_nom`, `num_nom_retenu`, `num_tax_sup`, `rang`, `nom_sci`, `nom_supra_generique`, `genre`, `epithete_infra_generique`, `epithete_sp`, `type_epithete`, `epithete_infra_sp`, `cultivar_groupe`, `cultivar`, `nom_commercial`, `auteur`, `annee`, `biblio_origine`, `notes`, `nom_addendum`, `homonyme`, `basionyme`, `synonyme_proparte`, `synonyme_douteux`, `synonyme_mal_applique`, `synonyme_orthographique`, `hybride_parent_01`, `hybride_parent_01_notes`, `hybride_parent_02`, `hybride_parent_02_notes`, `nom_francais`, `presence`, `statut_origine`, `statut_introduction`, `statut_culture`, `presence_Ga`, `presence_Co`, `exclure_taxref`, `num_taxonomique`) VALUES |
| (1, '71574', '', 290, 'Abacosa dumetorum', '', 'Abacosa', '', 'dumetorum', '', '', '', '', '', '(L.) Alef.', '1861', 'Bonplandia, 9 : 104', '', '', NULL, '71574', '', '', '', '', '74979', '', '77216', '', '', '', '', '', '', '', '', NULL, NULL), |
| (10, '10', '74929', 320, 'Abies alba subsp. alba', '', 'Abies', '', 'alba', 'subsp.', 'alba', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL), |
| (11, '17', '', 320, 'Abies alba subsp. cephalonica', '', 'Abies', '', 'alba', 'subsp.', 'cephalonica', '', '', '', '(J.W.Loudon) K.Richt.', '1890', 'Pl. Eur., 1 : 5', '', '', NULL, '17', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (17, '17', '85791', 290, 'Abies cephalonica', '', 'Abies', '', 'cephalonica', '', '', '', '', '', 'J.W.Loudon', '1838', 'Arboret. Frutic. Brit., 4 : 2325', '', '', NULL, '17', '', '', '', '', '', '', '', '', 'Sapin de Céphalonie', 'P', '', '', '', 'P', '', NULL, NULL), |
| (127, '127', '83587', 290, 'Acer davidii', '', 'Acer', '', 'davidii', '', '', '', '', '', 'Franch.', '1885', 'Nouv. Arch. Mus. Hist. Nat., sér. 3, 8 : 212', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', 9, NULL), |
| (128, '128', '127', 340, 'Acer davidii var. grosseri', '', 'Acer', '', 'davidii', 'var.', 'grosseri', '', '', '', '(Pax) P.C.DeJong & Oterdoom', '1994', 'in van Gelderen ; Maples of the World, 151', '', '', NULL, '129', '', '', '', '', '', '', '', '', 'Érable de Hers', 'P', '', '', '', 'P', '', 9, NULL), |
| (129, '128', '', 290, 'Acer grosseri', '', 'Acer', '', 'grosseri', '', '', '', '', '', 'Pax', '1902', 'in Engl. ; Pflanzenreich, IV-163, Aceraceae : 80', '', '', NULL, '129', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (162, '189', '', 290, 'Acer fauriei', '', 'Acer', '', 'fauriei', '', '', '', '', '', 'H.Lév. & Vaniot', '1906', 'Bull. Soc. Bot. France, 53 : 590', '', '', NULL, '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (189, '189', '74932', 320, 'Acer negundo subsp. negundo', '', 'Acer', '', 'negundo', 'subsp.', 'negundo', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', 'I', '', 'P', 'P', NULL, NULL), |
| (365, '365', '85795', 290, 'Achillea millefolium', '', 'Achillea', '', 'millefolium', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 899', '', '', NULL, '365', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (374, '374', '365', 320, 'Achillea millefolium subsp. millefolium', '', 'Achillea', '', 'millefolium', 'subsp.', 'millefolium', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Sourcils-de-Vénus', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (376, '374', '', 320, 'Achillea millefolium subsp. setacea', '', 'Achillea', '', 'millefolium', 'subsp.', 'setacea', '', '', '', 'sensu P.Fourn.', '1939', 'Quatre Fl. Fr., 968', '', '', NULL, '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (1150, '1153', '', 290, 'Agrimonia odorata', '', 'Agrimonia', '', 'odorata', '', '', '', '', '', 'sensu auct.', '', '', '', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (1153, '1153', '85823', 290, 'Agrimonia procera', '', 'Agrimonia', '', 'procera', '', '', '', '', '', 'Wallr.', '1840', 'Linnaea, 14 : 573', '', '', NULL, '1153', '', '', '', '', '', '', '', '', 'Aigremoine élevée', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (3073, '3167', '', 290, 'Allium maritimum', '', 'Allium', '', 'maritimum', '', '', '', '', '', 'sensu H.J.Coste', '1905', 'Fl. Fr., 3 : 337, fig. 3447', '', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (3167, '3167', '84866', 290, 'Allium roseum', '', 'Allium', '', 'roseum', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 296', '', '', NULL, '3167', '', '', '', '', '', '', '', '', 'Ail rose', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL), |
| (7579, '7579', '74979', 320, 'Asplenium fontanum subsp. fontanum', '', 'Asplenium', '', 'fontanum', 'subsp.', 'fontanum', '', '', '', '', '', '', '', '', NULL, '51777', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', 1, NULL), |
| (9513, '9513', '85993', 290, 'Beta vulgaris', '', 'Beta', '', 'vulgaris', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 222', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL), |
| (9519, '9519', '9513', 320, 'Beta vulgaris subsp. vulgaris', '', 'Beta', '', 'vulgaris', 'subsp.', 'vulgaris', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Bette-épinard', 'P', '', '', '', 'P', 'P', NULL, NULL), |
| (9520, '82082', '', 340, 'Beta vulgaris (Altissima Gp)', '', 'Beta', '', 'vulgaris', '', '', 'Altissima', '', '', '', '', '', 'Betterave sucrière', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (19287, '71574', '', 290, 'Cracca dumetorum', '', 'Cracca', '', 'dumetorum', '', '', '', '', '', '(L.) Opiz', '1852', 'Seznam, 34', '', '', NULL, '71574', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (23603, '23603', '86363', 290, 'Elaeagnus macrophylla', '', 'Elaeagnus', '', 'macrophylla', '', '', '', '', '', 'Thunb.', '1784', 'Fl. Jap., 67', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', 1, NULL), |
| (23604, '23604', '86363', 290, 'Elaeagnus pungens', '', 'Elaeagnus', '', 'pungens', '', '', '', '', '', 'Thunb.', '1784', 'Fl. Jap., 68', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Oléastre épineux', 'P', '', '', '', 'P', '', 1, NULL), |
| (23605, '23605', '', 290, 'Elaeagnus x submacrophylla ''Ebbingei''', '', 'Elaeagnus', '', 'x submacrophylla', '', '', '', 'Ebbingei', '', '', '', '', '', '', NULL, '', '', '', '', '', '23603', '', '23604', '', '', 'P', '', '', '', 'P', 'P', NULL, NULL), |
| (51777, '7579', '', 290, 'Polypodium fontanum', '', 'Polypodium', '', 'fontanum', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 1089', '', '', NULL, '51777', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, NULL), |
| (71567, '71574', '', 290, 'Vicia desertorum', '', 'Vicia', '', 'desertorum', '', '', '', '', '', 'Link', '1822', 'Enum. Hort. Berol. Alt., 2 : 238', '(err. orthographe ?)', '', NULL, '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (71574, '71574', '83705', 290, 'Vicia dumetorum', '', 'Vicia', '', 'dumetorum', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 734', '', '', NULL, '71574', '', '', '', '', '', '', '', '', 'Tremblarète', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (71576, '71574', '', 290, 'Vicia dumicola', '', 'Vicia', '', 'dumicola', '', '', '', '', '', 'Dulac', '1867', 'Fl. Hautes-Pyr., 288', '', 'nom. illeg. ', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (74929, '74929', '85791', 290, 'Abies alba', '', 'Abies', '', 'alba', '', '', '', '', '', 'Mill.', '1768', 'Gard. Dict., éd. 8 : n°1', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Sapin à feuilles d''If', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (74932, '74932', '83587', 290, 'Acer negundo', '', 'Acer', '', 'negundo', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 1056', '', '', NULL, '74932', '', '', '', '', '', '', '', '', 'Érable Négondo', 'P', '', 'I', '', 'P', '', NULL, NULL), |
| (74979, '74979', '85945', 290, 'Asplenium fontanum', '', 'Asplenium', '', 'fontanum', '', '', '', '', '', '(L.) Bernh.', '1799', 'J. Bot. (Schrader), 1799 (1) : 314', '', '', NULL, '51777', '', '', '', '', '', '', '', '', 'Asplénium de Haller', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (77216, '77216', '85945', 290, 'Asplenium majoricum', '', 'Asplenium', '', 'majoricum', '', '', '', '', '', 'Litard.', '1911', 'Bull. Acad. Int. Géogr. Bot., 20 : 28', '', '', NULL, '77216', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL), |
| (82082, '82082', '9519', 340, 'Beta vulgaris var. altissima', '', 'Beta', '', 'vulgaris', 'var.', 'altissima', '', '', '', 'Döll', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', NULL, NULL), |
| (83587, '83587', '101012', 220, 'Acer', '', 'Acer', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL), |
| (83705, '83705', '100916', 220, 'Vicia', '', 'Vicia', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (84866, '84866', '100931', 220, 'Allium', '', 'Allium', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', 'P', NULL, NULL), |
| (85791, '85791', '100946', 220, 'Abies', '', 'Abies', '', '', '', '', '', '', '', 'Hill', '1753', 'in Scott', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (85795, '85795', '100897', 220, 'Achillea', '', 'Achillea', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL), |
| (85823, '85823', '101130', 220, 'Agrimonia', '', 'Agrimonia', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (85945, '85945', '100980', 220, 'Asplenium', '', 'Asplenium', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL), |
| (85993, '85993', '100947', 220, 'Beta', '', 'Beta', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL), |
| (86363, '86363', '101050', 220, 'Elaeagnus', '', 'Elaeagnus', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', 'I', '', 'P', 'P', NULL, NULL), |
| (100897, '100897', '102760', 180, 'Asteraceae', 'Asteraceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (100916, '100916', '102745', 180, 'Fabaceae', 'Fabaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (100931, '100931', '100964', 180, 'Amaryllidaceae', 'Amaryllidaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (100946, '100946', '102778', 180, 'Pinaceae', 'Pinaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (100947, '100947', '101040', 180, 'Amaranthaceae', 'Amaranthaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (100964, '100964', '101139', 140, 'Asparagales', 'Asparagales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (100980, '100980', '102791', 180, 'Aspleniaceae', 'Aspleniaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (101004, '101004', '101135', 70, 'Dicotyledones Vraies', 'Dicotyledones Vraies', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (101012, '101012', '102750', 180, 'Sapindaceae', 'Sapindaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (101029, '101029', '101004', 70, 'Dicotyledones Vraies Superieures', 'Dicotyledones Vraies Superieures', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (101040, '101040', '101029', 140, 'Caryophyllales', 'Caryophyllales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (101050, '101050', '102741', 180, 'Elaeagnaceae', 'Elaeagnaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (101053, '101053', '101029', 70, 'Rosidees', 'Rosidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (101061, '101061', '101053', 70, 'Fabidees', 'Fabidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (101135, '101135', '102768', 70, 'Angiospermes', 'Angiospermes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (101132, '101132', '102768', 70, 'Gymnospermes', 'Gymnospermes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (101139, '101139', '101135', 70, 'Monocotyledones', 'Monocotyledones', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (101140, '101140', '0', 0, 'Chlorobiontes', 'Chlorobiontes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (101130, '101130', '102741', 180, 'Rosaceae', 'Rosaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (102735, '102735', '101140', 70, 'Plasmodesmophytes', 'Plasmodesmophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (102741, '102741', '101061', 140, 'Rosales', 'Rosales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (102745, '102745', '101061', 140, 'Fabales', 'Fabales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (102750, '102750', '102751', 140, 'Sapindales', 'Sapindales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (102751, '102751', '101053', 70, 'Malvidees', 'Malvidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL), |
| (102752, '102752', '101029', 70, 'Asteridees', 'Asteridees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL), |
| (102760, '102760', '102761', 140, 'Asterales', 'Asterales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'A', NULL, NULL), |
| (102761, '102761', '102752', 70, 'Campanulidees', 'Campanulidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', 'C', 'P', 'A', 9, NULL), |
| (102762, '102762', '102735', 70, 'Embryophytes', 'Embryophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL), |
| (102768, '102768', '102762', 70, 'Stromatophytes', 'Stromatophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL), |
| (102770, '102770', '101132', 70, 'Pinophytes', 'Pinophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (102771, '102771', '101140', 70, 'Polypodiidae', 'Polypodiidae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (102778, '102778', '102770', 140, 'Pinales', 'Pinales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL), |
| (102791, '102791', '102771', 140, 'Polypodiales', 'Polypodiales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL); |