EUNIS 2 - MySQL Database
| |
| |
| |
| |
| |
|EC CHM PROJECT |
|EUNIS 2 - MYSQL DATABASE |
[pic]
Modification history
|DATE |Version |Author |Reason for modification |
|13 Jun. 2001 |1.0 |L. Dell’Amico, C. Piermarocchi |First draft |
| | |(Finsiel) | |
|16 Nov. 2001 |1.1 |L. Dell’Amico, C. Piermarocchi |Added information from habitat classifications |
| | |(Finsiel) | |
|13 Feb. 2003 |1.2 |D.Chirca, A. Dascalu, A. Ignat |Added information from sites; Added information from habitat attributes |
| | |(Finsiel) | |
|21 Nov. 2005 |2.0 |D.Chirca (Finsiel) |Updated for EUNIS 2 |
|21 Oct. 2006 |2.0 |D.Chirca (Finsiel) |Updated with latest modifications for EUNIS 2 |
Table of Contents
0.1 Purpose of this document 4
0.2 Structure of this document 4
0.3 Field of application 4
0.4 Deviation from PMP 4
0.5 Reference and applicable documents 5
0.6 Terminology 5
0.6.1 Abbreviations, acronyms and definitions 5
0.6.2 Definitions 6
1 DATA MODEL 7
1.1 General 7
1.2 Conceptual Data Schema 7
1.4 Relations 26
1.5 Look-up tables 41
Introduction
1 Purpose of this document
This document reports the current content of the EUNIS Species, Habitats & Sites MySQL database that has been built adding information related to Habitats and Sites to the pre-existent Species Data Base. This version of the database includes also the information extracted from the Habitat classification available at
2 Structure of this document
See Table of Contents.
This document extends the content of similar documents released during the previous Specific Agreements of the EC CHM Framework Contract 1998 – 2003.
The document describes:
▪ the main data schema as an UML diagram;
▪ the logical structure of the database (entities, relations and look-up tables).
3 Field of application
|Contract |CWU Title |CWU Code |
|ENV.B.2/SER/2004/0102 |EUNIS web application |WU.3 |
This document is meant to support the analysis and design activities. The intended users are the task leader and the team entrusted with the development and maintenance of the new EUNIS 2 applications in the CHM project.
4 Deviation from PMP
The UML approach is here applied due to the availability of the already deployed EUNIS v1 application.
5 Reference and applicable documents
|Code |Title |DATE |
|CHM-EW1-PMP-001 |Project Management Plan |17 Feb 2005 |
|CHM-CW6-ADD-002 |EUNIS functions and data analysis |03 Jan 2001 |
|CHM-BW4-DNC-002 |EUNIS – Species Data Base |28 May 2001 |
|CHM-DW3-CNT-001 |EUNIS Data Base with Sites |03 Mar 2003 |
6 Terminology
1 Abbreviations, acronyms and definitions
|EC |European Commission |
|EUNIS |European Nature Information System |
|ETC/BD |European Topic Centre on Biological Diversity |
|CHM |Clearing-House Mechanism |
|CBD |Convention on Biological Diversity |
|CWU |Contractual Work Unit |
|DWH |Data Warehouse |
|EEA |European Environment Agency |
|EIONET |Environmental Information and Observation Network |
|UML |Unified Modelling Language |
|IG |Interest Group (in CIRCA) |
|NFP |National Focal Point |
|SA1 |1st Specific Agreement |
|SA2 |2nd Specific Agreement |
|PMP |Project Management Plan |
|N/a |Not applicable |
|Zope |An Open Source web application server which enables teams to collaborate in |
| |the creation and management of dynamic web-based applications such as |
| |intranets and portals |
2 Definitions
|CIRCA or CIRCLE |The extranet tool developed under the IDA Programme and which constitutes |
| |the kernel of the EIONET system; CIRCLE is the name given to the tool in |
| |EIONET whereas CIRCA is the name of the tool to be used across Europe. |
|Interest Group |CIRCLE (i.e. CIRCA) is organised around Interest Groups i.e. a private |
| |workspace for a group of people that need to collaborate to achieve common |
| |objectives and tasks. |
|Interest Group Leader |In the context of CIRCLE, the Interest Group Leader is granted extended |
| |privileges to administrate manage and customise the Interest Group. S/he |
| |defines users and grant access rights within the Interest Group. |
DATA MODEL
1 General
In the context of the WU.3 (EUNIS web application), Finsiel has been requested by EEA to make available the information gathered at the European Topic Centre on Biological Diversity (ETC/BD) to the whole community .
This shall be done developing a structured database called "EUNIS DWH” or data warehouse of the information available in the European Nature Information System (EUNIS); such database shall be queriable by Internet users, accessing in particular the EEA Data Service or the EC CHM Portal (also developed in this Contract).
The content of this document has been built extending the document CHM-BW2-DNC-002 “EUNIS – Species Data Base” to include the information about habitats published on Circle by D. Moss in December 2000 and in June 2001. This document relies also upon the version issued on January 2000 of the report "Draft EUNIS Status Manual", prepared by S. Condé, D. Moss and M. Roekaerts and on the other afterwards received contributions. Moreover, the document CHM-DW3-CNT-001 “EUNIS Data Base with Sites” has been included.
The data schema includes only the entities and relationships whose data are actually available, taking into account the Dublin Core definitions.
In this section is described the data schema of the EUNIS Database, with reference to the data related to Species, Habitat types and Sites.
For each entity of the schema is reported a brief description for the entity itself together with a list of the attributes.
Finally a description of the relationships among the entities is reported.
2 Conceptual Data Schema
For each table, are given:
• the code name of the table ;
• the definition of the relation or entity or look-up table, in plain text, explaining the meaning with reference to the "real world";
For the entities, look-up table and relations, with reference to each field of each record is reported the following:
▪ the name of the field;
▪ if the field is a key (PK for a primary key, FK for a foreign key);
▪ the data type;
▪ the acceptable values for the field;
▪ the status of the field (Mandatory, Unique, Optional, Automatic); "Mandatory if xywz is not null" means that the field is Optional but becomes Mandatory if another field "xywz" is not null;
▪ the description of the content of the field;
▪ the source table(s), i.e. the table(s) of the existing EUNIS databases from where the content of the current field of EUNIUS DWH is extracted;
▪ the source field(s); i.e. the field(s) of the table(s) of the existing EUNIS databases from where the content of the current field of EUNIS DWH is extracted.
▪ the term “external” indicates data extracted from sources external to the original EUNIS databases.
▪ Tables have the following prefixes:
o CHM62EDT_ : for table containing data on nature objects
o EUNIS_ : for auxiliary tables used in application
o DC_ : for tables which implement the DUBLIN CORE model
Sometimes in this document, the prefixes are not used for brevity.
[pic]
EUNIS 2 Database - Main Schema Model
The CHM62EDT_NATURE_OBJECT table is at the root of the database design. It holds common information on Species, Habitat types and Sites (these are the fundamental nature objects in EUNIS) – so every biodiversity object is also a generic nature object.
The main tables for Species, Sites and Habitat Types are:
CHM62EDT_SPECIES for Species
CHM62EDT_HABITATS for Habitat Types
CHM62EDT_SITES for Sites
[pic]
A nature object can have links with:
- Reference data. The Reference data is maintain in a Dublin Core compatible design (the corresponding tables are the tables with prefix “DC_”
- Another nature object
- A characteristic
- A (bio)geographical location/information
To hold the latest mentioned relation, the database uses the tables: CHM62EDT_REPORTS and CHM62EDT_NATURE_OBJECT_REPORT_TYPE.
From these tables the relation goes further to the lookup tables.
A nature object is linked to a (bio)geographical location through the REPORTS tables, going further to CHM62EDT_GEOSCOPE tables which links together information on Countries (CHM62EDT_COUNTRY) and Biogeoregions (CHM62EDT_BIOGEOREGION).
These are the main logical relations used in the database design. There are also other relations to related specific information in order to hold all the information: Designations for Sites, Taxonomy for Species, Class Codes for Habitat Types etc.
For detailed information, please read the next section which details all tables present in the EUNIS 2 MySQL Database.
1.3 Entities
|Table name |CHM62EDT_NATURE_OBJECT |
|Definition |Parent entity for an object of interest for nature conservation – species, habitat type or site |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_DC |FK (to |INTEGER |N/a |O |Identifier of the |SPECREF, HABREFS |REFCD |
| |DUBLIN | | | |Dublin Core Metadata | | |
| |CORE) | | | | | | |
|TYPE | |VARCHAR(32) |"Site"; |M, A |Type of nature object| | |
| | | |"Habitat"; | | | | |
| | | |"Species" | | | | |
|ORIGINAL_CODE | |VARCHAR(16) | |O |Original code of the |SPECIES, HABITATS, |GENSPECSCCD, |
| | | | | |record from the |BIOTOP |SITE_CODE, |
| | | | | |source databases | |HABSCCD, SITECODE|
| | | | | | | | |
|Table name |CHM62EDT_SPECIES |
|Definition |Main table for Species – a descendant of CHM62EDT_NATURE_OBJECT |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_NATURE_ |FK (same |INTEGER | |M |Identifier of the |N/a |N/a |
|OBJECT |as in | | | |nature object | | |
| |CHM62EDT_N| | | | | | |
| |ATURE_OBJE| | | | | | |
| |CT) | | | | | | |
|VALID_NAME | |INTEGER(1) | |M |The scientific name is|eunis-db / species /|NMVAL |
| | | | | |a valid name for EUNIS|Eunis-sp.mdb / | |
| | | | | |(1) or synonym (0) |SPECIES | |
|ID_SPECIES_LINK |FK (from |INTEGER |ID_SPECIES of |M |Identifier of the |eunis-db / species /|Syn_GENSPECSCCD |
| |the same | |the related | |related species (or |Eunis-sp.mdb / | |
| |table) | |species | |related term) with |SPECIES | |
| | | | | |valid name (can be the| | |
| | | | | |same value of | | |
| | | | | |ID_SPECIES) | | |
|TYPE_RELATED_SPECIES | |VARCHAR(16) |“Species” |M (if |Type of related term |eunis-db / species /|TAXRLCD |
| | | |“Genus” |ID_species| |Eunis-sp.mdb / | |
| | | |“Subspecies” |_link is | |SPECIES | |
| | | |“Syn” |not null) | | | |
| | | |“Var” | | | | |
| | | |“Hybrid” | | | | |
| | | |“Misspelling” | | | | |
| | | |“Misspelling/Syn| | | | |
| | | |” | | | | |
|TEMPORARY_SELECT | |INTEGER(1) | |O |Temporary selection of|eunis-db / species /|SELECT |
| | | | | |data by ETC/NC |Eunis-sp.mdb / | |
| | | | | | |SPECIES | |
|ID_TAXONOMY |FK (same |INTEGER(16) |N/a |M |Identifier of the |eunis-db / species /|TAX_CODE |
| |as in | | | |hierarchical taxonomic|Eunis-sp.mdb / | |
| |TAXCODE | | | |code to family level |SPECIES | |
| |table) | | | | | | |
|TAXONOMIC_SPECIES_CODE | |VARCHAR(32) | |M |Taxonomic species code|eunis-db / species /|GENSPECTXCD |
| | | | | |which includes |Eunis-sp.mdb / | |
| | | | | |hierarchical aspects |SPECIES | |
| | | | | |below family level | | |
|SPECIES_MAP | |VARCHAR(7) | |O |Reference code to the |eunis-db / species /|SPECMAP |
| | | | | |distribution map of |Eunis-sp.mdb / | |
| | | | | |the species |SPECIES | |
|ID_GROUP_SPECIES |FK (same |INTEGER |N/a |M |Identifier of the |eunis-db / species /|GROUPCD |
| |as in | | | |group of species |Eunis-sp.mdb / | |
| |GROUPSPECI| | | | |SPECIES | |
| |ES table) | | | | | | |
|SPECIES_MAP | |VARCHAR(255) |N/a |O |Logical address of |external |external |
| | | | | |the file containing | | |
| | | | | |the image of the | | |
| | | | | |species (currently not| | |
| | | | | |valued) | | |
|AUTHOR | |VARCHAR(255) | |M |Author of the species | |REFSPEC |
| | | | | |name | | |
|SCIENTIFIC_NAME | |VARCHAR (100) | |M |Scientific name of the|eunis-db / species /|GENSPECSCNM |
| | | | | |species (or related |Eunis-sp.mdb / | |
| | | | | |term) |SPECIES | |
|Table name |CHM62EDT_HABITAT |
|Definition |Main table for Habitat types – a descendant of CHM62EDT_NATURE_OBJECT |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_NATURE_ |FK (same |INTEGER | |M |Identifier of the |N/a |N/a |
|OBJECT |as in | | | |nature_object | | |
| |NATURE_OBJ| | | | | | |
| |ECT) | | | | | | |
|CODE_2000 | |VARCHAR(4) | |o |Unique habitat code, |eunis-db / species /|HABSCCD |
| | | | | |as developed for |Eunis-sp.mdb / | |
| | | | | |Natura 2000 software |HABITAT | |
|CODE_ANNEX1 | |VARCHAR(25) | |O |Code given in Annex I |eunis-db / species /|HBCDCOAX |
| | | | | |as published in the |Eunis-sp.mdb / | |
| | | | | |Official Journal |HABITAT | |
|PRIORITY | |INTEGER(1) |"1" for TRUE; |O |Priority |eunis-db / species /|P |
| | | |"0" (default) | | |Eunis-sp.mdb / | |
| | | |for FALSE | | |HABITAT | |
|EUNIS_HABITAT_CODE | |VARCHAR(16) | |O |EUNIS Habitat |Eunishab.mdb / |EUNIS HAB |
| | | | | |hierarchical code |HABITAT | |
|ORRIGINALLY_PUBLISHED_C| |VARCHAR(25) | |O |Original habitat code |Eunishab.mdb / |HABSCCD |
|ODE | | | | | |HABITAT | |
|CLASS_REF | |VARCHAR(16) | |O |Classification system,|Eunishab.mdb / |CLASS_REF |
| | | | | |including previous |HABITAT | |
| | | | | |versions. (Refers to | | |
| | | | | |table HABEQUIV) | | |
|CODE_PART_2 | |VARCHAR(64) | |O |Attached part of code |Eunishab.mdb / |CODE PART2 |
| | | | | |referred to another |HABITAT | |
| | | | | |classification | | |
|LEVEL | |INTEGER | |O |Hierarchical level |Eunishab.mdb / |Hab level |
| | | | | | |HABITAT | |
|SCIENTIFIC_NAME | |VARCHAR(255) | |O |Agreed name using |Eunishab.mdb / |Scientific name |
| | | | | |scientific |HABITAT | |
| | | | | |nomenclature, (not | | |
| | | | | |syntaxon) | | |
|DESCRIPTION | |TEXT | |O |Explicit English name |eunis-db / species /|HBTTAXEN ; |
| | | | | |of habitat type |Eunis-sp.mdb / |NAME |
| | | | | | |HABITAT ; | |
| | | | | | |eunishab.mdb / | |
| | | | | | |HABITAT | |
|Table name |CHM62EDT_SITES |
|Definition |Main table for Sites – a descendant of CHM62EDT_NATURE_OBJECT |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|RESPONDENT | |TEXT |N/a |O |Name of respondent |Biotopes, |RESPONDENT |
| | | | | |responsible for site |international_sites| |
| | | | | |record | | |
|NAME | |VARCHAR(255) | |M |Site name |Biotopes, |SITE_NAME/AREANAM|
| | | | | | |international_sites|E |
|MANAGER | |TEXT | |O |Manager |Natura 2000 |MANAGER |
|COMPLEX_NAME | |TEXT | |O |Name of the site |(CDDA data) |COMP_NAME |
| | | | | |Complex to which it | | |
| | | | | |beINTEGERs | | |
|DISTRICT_NAME | |TEXT | |O |Name of the site |(CDDA data) |DIST_NAME |
| | | | | |District to which it | | |
| | | | | |beINTEGERs | | |
|OWNERSHIP | |TEXT | |O |Text description of |Ownership text |TEXT |
| | | | | |ownership of site | | |
|NUTS | |VARCHAR(50) | |O | | |NUTS |
| | | | | | | | |
|QUALITY | |TEXT | |O |Text description of |Quality text |TEXT |
| | | | | |quality of site | | |
|VULNERABILITY | |TEXT | |O |Text description of |Vulnerability text |TEXT |
| | | | | |threats to site | | |
|HISTORY | |TEXT | |O |Text information |Record history |TEXT |
| | | | | |concerning history of| | |
| | | | | |changes to site | | |
| | | | | |record | | |
|CHARACTER | |TEXT | |O |Text description of |Character text |TEXT |
| | | | | |site | | |
|DOCUMENTATION | |TEXT | |O |Text information | |TEXT |
| | | | | |concerning published | | |
| | | | | |documentation | | |
|DESCRIPTION | |TEXT | |O |Text description of |Designation text |TEXT |
| | | | | |site | | |
|MANAGEMENT_PLAN | |TEXT | |O |Management plan of |Natura 2000 |MANAGPL |
| | | | | |site | | |
|IUCNAT | |TEXT | |O |Administrative region|(CDDA data) |IUCNAT |
| | | | | |code | | |
|SITE_YEAR | |INTEGER | |O |Site year |(CDDA data) |YEAR |
|PROPOSED_DATE | |VARCHAR(50) | |O |Date site proposed as|NATURA 2000 |DATE_PROP |
| | | | | |eligible as SCI | | |
|CON_DATE | |VARCHAR(50) | |O |Date confirmed as SCI|NATURA 2000 |DATE_CON |
|SPA_DATE | |VARCHAR(50) | |O |Date site classified |NATURA 2000 |SPA_DATE |
| | | | | |as SPA | | |
|SAC_DATE | |VARCHAR(50) | |O |Date site designated |NATURA 2000 |SAC_DATE |
| | | | | |as SAC | | |
|COMPILATION_DATE | |VARCHAR(50) | |O |Date site compilation|NATURA 2000 | |
|NATIONAL_CODE | |TEXT | |O |National site code |(CDDA data) |SITE_CODE_NAT |
|AREA | |INTEGER | |O |Area (ha) |Biotopes |AREA |
|LENGTH | |INTEGER | |O |Length (m) |Natura 2000 |LENGTH |
|INTEGER_EW | |INTEGER | |M |INTEGERitude: E/W |Biotopes |INTEGER_EW |
|INTEGER_DEG | |INTEGER | |M |INTEGERitude – |Biotopes |INTEGER_DEG |
| | | | | |Degrees | | |
|INTEGER_MIN | |INTEGER | |M |INTEGERitude – |Biotopes |INTEGER_MIN |
| | | | | |Minutes | | |
|INTEGER_SEC | |INTEGER | |M |INTEGERitude – |Biotopes |INTEGER_SEC |
| | | | | |Seconds | | |
|LAT_DEG | |INTEGER | |M |Latitude - Degrees |Biotopes |LAT_DEG |
|LAT_MIN | |INTEGER | |M |Latitude – Minutes |Biotopes |LAT_MIN |
|LAT_SEC | |INTEGER | |M |Latitude – Seconds |Biotopes |LAT_SEC |
|INTEGERITUDE | |DECIMAL | |O |INTEGERitude |Biotopes |INTEGER |
|LATITUDE | |DECIMAL | |O |Latitude |Biotopes |LAT |
|ALT_MEAN | |INTEGER | |O |Mean altitude height |Biotopes |ALT_MEAN |
| | | | | |- meters | | |
|ALT_MAX | |INTEGER | |O |Maximum altitude |Biotopes |ALT_MAX |
| | | | | |height – meters | | |
|ALT_MIN | |INTEGER | |O |Minimum altitude |Biotopes |ALT_MIN |
| | | | | |height - meters | | |
|UPDATE_DATE | |TEXT | |O |Date site information|Biotopes |UPDATE |
| | | | | |last updated | | |
|ID_GEOSCOPE |FK |INTEGER | |O |FK to Geoscope |Biotopes |ISO_3L |
| | | | | |corresponding to the | | |
| | | | | |Designation ID | | |
|ID_DESIGNATION |FK |VARCHAR(16) | |O |FK to Designation ID |Biotopes |DESIG_ABBR |
|SOURCE_DB | |VARCHAR(32) |NATURA2000, |M |Source of information| | |
| | | |CORINE, | |for the site – the | | |
| | | |EMERALD, | |Access database where| | |
| | | |CDDA_NATIONAL, | |the information come | | |
| | | |CDDA_INTERNATIO| |from | | |
| | | |NAL, DIPLOMA, | | | | |
| | | |BIOGENETIC | | | | |
|Table name |CHM62EDT_DESIGNATIONS |
|Definition |Object that holds designations information for Sites |
Each Site has one legal designation.
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_GEOSCOPE |FK |INTEGER | |M |Geoscope identifier |N/a |AREACD |
|ID_DC |FK (same|INTEGER | |M |Dublin Core index |N/a |REFCD |
| |as in | | | | | | |
| |DC_INDEX | | | | | | |
| |table) | | | | | | |
|DESCRIPTION | |TEXT | |M |Description in |Designation Codes |DESCRIPTION |
| | | | | |original language | | |
|DESCRIPTION_EN | |TEXT | |O |Description in |Designation Codes |ENGLISH |
| | | | | |English | | |
|DESCRIPTION_FR | |TEXT | |O |Description in French|(CDDA data) |FRENCH |
|ORIGINAL_DATASOURCE | |TEXT | |A, O |Original data source | | |
| | | | | |where the information| | |
| | | | | |come from | | |
|DATA_SOURCE | |VARCHAR(255) | |O |Date source | |DATA SOURCE |
|ABBREVIATION | |TEXT | |M |Designation | |DESIG_ABBR |
| | | | | |abbreviation | | |
|NATIONAL_LAW | |TEXT | |O |National law text | |LAW |
|NATIONAL_CATEGORY | |TEXT |A, B, C |O |National category | |CATEGORY |
|NATIONAL_LAW_REF | |TEXT | |O |National law | |LAW REFERENCE |
| | | | | |references text | | |
|NATIONAL_AGENCY | |TEXT | |O |National agency | |AGENCY |
|CDDA_SITES | |INTEGER |‘Y’,’N’ |M |Number of sites | |CDDA_SITES |
| | | | | |within the | | |
| | | | | |designation | | |
|TOTAL_NUMBER | |INTEGER | |O |Total number of sites| |NUMBER |
| | | | | |for the designation | | |
|REFERENCE_AREA | |INTEGER | |O |Reference area | |TOTAL AREA |
| | | | | | | |REFERENCE |
|REMARK | |TEXT | |O |Total number of sites| |REMARK |
| | | | | |for the designation | | |
|REMARK_SOURCE | |VARCHAR(255) | |O |Reference area | |REMARK SOURCE |
|Table name |DC_INDEX |
|Definition |Entry point for DUBLIN CORE METADATA |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|REFCD | |INTEGER |N/a |O |Identifier of the |REFSPEC |REFCD |
| | | | | |original information | | |
| | | | | |source id | | |
|REFERENCE |PK |INTEGER |N/a |O |Link to legal |REFSPEC |LEGAL_INST_CD |
| | | | | |reference | | |
|COMMENT | |VARCHAR(255) |Name of the |O |Comment |REFSPEC |REFERENCES |
| | | |table from | | | | |
| | | |where derive | | | | |
| | | |ID_DC | | | | |
|Table name |CHM62EDT_GEOSCOPE |
|Definition |Geographical area (in a broad meaning) related to a site, habitat type, designation or species |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_GEOSCOPE_PARENT |FK (from |INTEGER |ID_GEOSCOPE of |O |Parent area which |_SUBSTS |Subsite |
| |the same | |the parent area | |contains the area of | | |
| |table) | | | |interest | | |
|AREA_TYPE | |VARCHAR(2) |"CO"= country; |M |Type of area |N/a |N/a |
| | | |"’BA"= | | | | |
| | | |biogeoarea; | | | | |
| | | |"BR"= | | | | |
| | | |biogeoregion | | | | |
|ID_DC |FK (same |INTEGER | |O |ID of the Dublin Core |N/a |N/a |
| |as in | | | |Metadata | | |
| |DC_INDEX | | | | | | |
| |table) | | | | | | |
|Table name |CHM62EDT_COUNTRY |
|Definition |An area is a country or a group of countries of interest for EUNIS; it also includes general terms ("World","Europe"), |
| |contracting parties to conventions, Atlases, single cities ("Bucharest"). It is a descendatnt of the GEOSCOPE entity. |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_GEOSCOPE |FK (same |INTEGER | |M |Identifier of the |N/a |N/a |
| |as in | | | |Geoscope object | | |
| |GEOSCOPE) | | | | | | |
|AREA_NAME | |VARCHAR(255) | |O |Name of the area, in |eunis-db / species /|Country name |
| | | | | |original language |Eunis-sp.mdb / AREAS| |
|AREA_NAME_ENGHISH | |VARCHAR(255) | |O |Name of the area, in |eunis-db / species /|Country name |
| | | | | |English |Eunis-sp.mdb / AREAS|English |
|Area_name_French | |VARCHAR(255) | |O |Name of the area, in |eunis-db / species /|Country name |
| | | | | |French |Eunis-sp.mdb / AREAS|French |
|ISO_2L | |VARCHAR(2) |ISO 2-letter |O |ISO 3166 2-letter |eunis-db / species /|ISO 3166 - 2L |
| | | |code for | |code |Eunis-sp.mdb / AREAS| |
| | | |countries; for | | | | |
| | | |other area types| | | | |
| | | |is "null" | | | | |
|ISO_3L | |VARCHAR(3) |ISO 3-letter |O |ISO 3166 3-letter |eunis-db / species /|ISO 3166 - 3L |
| | | |code for | |code |Eunis-sp.mdb / AREAS| |
| | | |countries; for | | | | |
| | | |other area types| | | | |
| | | |is "null" | | | | |
|AREUCD | |VARCHAR(2) |ISO-2 country |O |For INTEGER use |eunis-db / species /|AREUCD |
| | | |codes | | |Eunis-sp.mdb / AREAS| |
|EUNIS_AREA_CODE | |CHAR(3) |N/a |M |Area code adopted in |eunis-db / species /|AREACD |
| | | | | |EUNIS; it is |Eunis-sp.mdb / AREAS| |
| | | | | |equivalent to ISO-2 | | |
| | | | | |with extension for Exx| | |
| | | | | |and Wxx codes | | |
|ISO_N | |CHAR (2) |ISO code for |M |ISO 3166 numeric code |eunis-db / species /|ISO 3166 – N |
| | | |countries; for | | |Eunis-sp.mdb / AREAS| |
| | | |other area types| | | | |
| | | |is "0" | | | | |
|ISO_2_WCMC | |CHAR(2) | |O |ISO 2 character code |eunis-db / species /|ISO2-WCMC |
| | | | | |used by WCMC |Eunis-sp.mdb / AREAS| |
|ISO_3_WCMC | |CHAR(3) | |O |ISO 3 character code |eunis-db / species /|ISO3-WCMC |
| | | | | |used by WCMC |Eunis-sp.mdb / AREAS| |
|Tel_code | |SMALLINT | |O |Telephone country code|eunis-db / species /|Tel code |
| | | | | | |Eunis-sp.mdb / AREAS| |
|Sort_number | |INTEGER(8) | |O |Sort number for |eunis-db / species /|Sortnumber |
| | | | | |reporting (changes |Eunis-sp.mdb / AREAS| |
| | | | | |from a report to | | |
| | | | | |other) | | |
|Country_type | |VARCHAR(1) | |O |Country type code in |eunis-db / species /|Countrytype |
| | | | | |European context |Eunis-sp.mdb / AREAS| |
|Surface | |INTEGER(8) | |O |Country surface area |eunis-db / species /|Area |
| | | | | |in sqKm |Eunis-sp.mdb / AREAS| |
|NGO | |INTEGER(1) |"1" or "0"; |O |"1" is the country has|eunis-db / species /|NGO |
| | | |default is | |a known designated |Eunis-sp.mdb / AREAS| |
| | | |"null" | |areas network managed | | |
| | | | | |by a NGO | | |
|Number_desigN_area | |INTEGER | |O |Estimated number of |eunis-db / species /|DPRN |
| | | | | |designated areas, |Eunis-sp.mdb / AREAS| |
| | | | | |according to source | | |
|Source | |VARCHAR(255) | |o |Information source |eunis-db / species /|SOURCE |
| | | | | |(can be a biblio |Eunis-sp.mdb / AREAS| |
| | | | | |source) of the | | |
| | | | | |estimated number of | | |
| | | | | |designated areas | | |
|Political_status | |VARCHAR(100) | |O |Political status of |eunis-db / species /|POLSTAT |
| | | | | |the country |Eunis-sp.mdb / AREAS| |
|Population | |INTEGER | |O |Population |eunis-db / species /|POPULATION |
| | | | | | |Eunis-sp.mdb / AREAS| |
|Pop_density | |DECIMAL | |O |Population density |eunis-db / species /|POPDENSITY |
| | | | | | |Eunis-sp.mdb / AREAS| |
|Capital | |VARCHAR(64) | |O |Capital city |eunis-db / species /|CAPITAL |
| | | | | | |Eunis-sp.mdb / AREAS| |
|Currency_NAME | |VARCHAR(64) | |O |Currency name |eunis-db / species /|CURRENCY |
| | | | | | |Eunis-sp.mdb / AREAS| |
|Currency_code | |VARCHAR(3) | |O |Currency code |eunis-db / species /|CURRENCYCODE |
| | | | | | |Eunis-sp.mdb / AREAS| |
|Selection | |INTEGER |Temporary |M |Temporary selection by|eunis-db / species /|SELECT |
| | | |selection is | |ETC-NC |Eunis-sp.mdb / AREAS| |
| | | |TRUE; otherwise | | | | |
| | | |is FALSE | | | | |
|LAT_MIN | |DECIMAL |N/a |O |Latitude minimum |Countries |LATITUDE min |
|LAT_MAX | |DECIMAL |N/a |O |Latitude maximum |Countries |LATITUDE max |
|LONG_MIN | |DECIMAL |N/a |O |Longitude minimum |Countries |LONGITUDE min |
|LONG _MAX | |DECIMAL |N/a |O |Longitude maximum |Countries |LONGITUDE max |
|ALT_MIN | |INTEGER |N/a |O |Altitude minimum |Countries |ALTITUDE min |
|ALT_MAX | |INTEGER |N/a |O |Altitude maximum |Countries |ALTITUDE max |
|NGO | |INTEGER | |O | | | |
|Table name |CHM62EDT_BIOGEOREGION |
|Definition |Biogeographic region |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_GEOSCOPE |FK (same |INTEGER | |M |Identifier of the |N/a |N/a |
| |as in - | | | |geoscope | | |
| |GEOSCOPE | | | | | | |
| |table) | | | | | | |
|code_EEA | |VARCHAR(5) |Five-letter code|O |Alphabetical code used|eunis-db / species /|BIOGEOREG-EEA |
| | | | | |by EEA |Eunis-sp.mdb / BGEU | |
|name | |VARCHAR(128) | |M |Name of the |eunis-db / species /|BIORNAME |
| | | | | |biogeographic region |Eunis-sp.mdb / BGEU | |
|Selection | |INTEGER |“1” for |M |Temporary selection of|eunis-db / species /|SELECT |
| | | |"TRUE",”0” for | |data |Eunis-sp.mdb / BGEU | |
| | | |“FALSE”; | | | | |
| | | |(default) is | | | | |
| | | |"FALSE" | | | | |
|code | |VARCHAR(2) |Two-letter code |M |Alphabetic code of the|eunis-db / species /|BIOGEOREG |
| | | | | |biogeographic region |Eunis-sp.mdb / BGEU | |
3 Relations
|Table name |CHM62EDT_REPORTS |
|Definition |Facts, data etc. are reported for a site, habitat or species beINTEGERing to a geoscope (geographical zone, in a broad|
| |meaning), as referenced by an information source |
|Entity name |Multiplicity |Mandatory |
|NATURE_OBJECT |N |Y |
|DUBLIN_CORE |M |Y |
|GEOSCOPE |P |Y |
|REPORT_TYPE |Q |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_DC |PK (same |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| |as in | | | |Dublin Core metadata | | |
| |DC_INDEX | | | | | | |
| |table) | | | | | | |
|ID_GEOSCOPE |PK (same |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| |as in | | |(O,U,A |geoscope | | |
| |GEOSCOPE | | |for | | | |
| |table) | | |HABITAT) | | | |
|ID_REPORT_TYPE |PK (same |INTEGER |N/a |M, U, A |Value of reported |N/a |N/a |
| |as in | | | |facts, data etc. | | |
| |REPORT_TYP| | | | | | |
| |E) | | | | | | |
|ID_GEOSCOPE_LINK |PK (same |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| |as in | | |(O,U,A |geoscope | | |
| |GEOSCOPE | | |for | | | |
| |table) | | |HABITAT) | | | |
|Table name |CHM62EDT_NATURE_OBJECT_REPORT_TYPE |
|Definition |A nature object (species for ex.) pertains to another nature object (habitat type for ex.) in a geoscope |
| |(biogeoregion), according to an DUBLIN_CORE reference |
|Entity name |Multiplicity |Mandatory |
|NATURE_OBJECT |N |Y |
|NATURE_OBJECT |M |Y |
|DUBLIN_CORE |P |Y |
|GEOSCOPE |Q |N |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_NATURE_OBJECT_LINK |PK (same |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| |as in | | | |habitat | | |
| |HABITAT | | | | | | |
| |table) | | | | | | |
|ID_DC |PK (same |INTEGER |N/a; “0” where |M, U, A |Identifier of the DC |N/a |N/a |
| |as in | |not existent | |(for | | |
| |DC_INDEX | | | |SPECIES:currently, | | |
| |table) | | | |only one value; for | | |
| | | | | |HABITAT: check) | | |
|ID_GEOSCOPE |PK (same |INTEGER |N/a; “0” where |M, U, A |Identifier of the |N/a |N/a |
| |as in | |not existent | |biogeographic region | | |
| |GEOSCOPE | | | |(for | | |
| |table) | | | |SPECIES:currently, | | |
| | | | | |only one value; for | | |
| | | | | |HABITAT: check) | | |
|ID_REPORT_TYPE |FK (Same |INTEGER | |O, A | | | |
| |as in | | | | | | |
| |REPORT_TYP| | | | | | |
| |E table) | | | | | | |
|ID_REPORT_ATTRIBUTES |FK (Same |INTEGER | |O, A | | | |
| |as in | | | | | | |
| |REPORT_ATT| | | | | | |
| |RIBUTEStab| | | | | | |
| |le) | | | | | | |
|Table name |CHM62EDT_COUNTRY_BIOREGION |
|Definition |A biogeographic region related to a country |
|Entity name |Multiplicity |Mandatory |
|COUNTRY |M |Y |
|BIOGEOREGION |N |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|CODE_COUNTRY |PK (same |VARCHAR(16) |N/a |M, U, A |Identifier of the |AREA_BGU |PERCENT |
| |sa in | | | |country or group of | | |
| |BIOGEOREGI| | | |countries | | |
| |ON table) | | | | | | |
|PERCENT | |INTEGER | |O |Coverage | | |
|Table name |CHM62EDT_HABITAT_HABITAT |
|Definition |A habitat is related to another habitat |
|Entity name |Multiplicity |Mandatory |
|HABITAT |N |Y |
|HABITAT |M |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_HABITAT_LINK |PK (same |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| |as in | | | |related habitat | | |
| |HABITAT | | | | | | |
| |table) | | | | | | |
|RelAtion_type | |CHAR(1) |“Ancestor”; |M |Type of relation (a |Eunishab.mdb / |N/a |
| | | |“Parent” | |habitat has a related |HABITAT PARENT ; | |
| | | | | |habitat as parent or |Eunishab.mdb / | |
| | | | | |ancestor |HABITAT ANCESTOR | |
|Table name |CHM62EDT_HABITAT_CLASS_CODE |
|Definition |An habitat, classified according to another classification system |
|Entity name |Multiplicity |Mandatory |
|HABITAT |N |Y |
|CLASS_CODE |M |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_CLASS_CODE |PK (same |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| |as in | | | |classification code | | |
| |CLASS_CODE| | | | | | |
| |table) | | | | | | |
|Title | |VARCHAR(255) | |O |Name of the habitat |Eunishab.mdb / |TITLE |
| | | | | |in another |HABEQUIV | |
| | | | | |classification system | | |
|Relation_type | |CHAR(1) |“ > “ wider, |O |Relationship of other |Eunishab.mdb / |RELATION |
| | | |” < “ narrower, | |codes to EUNIS habitat|HABEQUIV | |
| | | |” = “ same, | |code. | | |
| | | |” # “ overlap, | | | | |
| | | |” ? “ not | | | | |
| | | |determined | | | | |
|Code | |VARCHAR(30) | |O |Code in other |Eunishab.mdb / |CODE |
| | | | | |classification |HABEQUIV | |
|Table name |CHM62EDT_HABITAT_SYNTAXA |
|Definition |An habitat refers to a syntaxon |
|Entity name |Multiplicity |Mandatory |
|HABITAT |N |Y |
|SYNTAXA |M |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_SYNTAXA |PK (same |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| |as in | | | |syntaxa | | |
| |SYNTAXA | | | | | | |
| |table) | | | | | | |
|Relation_type | |CHAR(1) |“ > ” wider, |O |Relationship |Eunishab.mdb / |RELATION |
| | | |” < “ narrower, | | |HABSYN | |
| | | |” = “ same, | | | | |
| | | |” # “ overlap, | | | | |
| | | |” ? “ not | | | | |
| | | |determined | | | | |
|ID_SYNTAXA_SOURCE | |CHAR(1) |“E” = EVS |M |Status, according to a|Eunishab.mdb / |SOURCE |
| | | |validated, “P” =| |source |HABSYN | |
| | | |PHYSIS | | | | |
| | | |unvalidated, “U”| | | | |
| | | |= UVS validated | | | | |
|Table name |CHM62EDT_SITES_SITES |
|Definition |Relationship between sites |
|Entity name |Multiplicity |Mandatory |
|SITES |N |Y |
|SITES |M |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_SITE_LINK |PK (Same |VARCHAR(16) |N/a | |Identifier of the |Subsites |N/a |
| |as in | | | |nature object | | |
| |SITES | | | | | | |
| |table) | | | | | | |
|SEQUENCE | |INTEGER |N/a | |Site sequence |Subsites |SEQUENCE |
|WITHIN_PROJECT | |INTEGER |1=Yes, 0=No | |Site is related to | | |
| | | | | |another site but in | | |
| | | | | |the same source | | |
|RELATION_TYPE | |VARCHAR(32) |(see below) | | |Biotopes | |
|OVERLAP | |DECIMAL | | | |Subsites |OVERLAP |
|SOURCE_TABLE | |VARCHAR(16) | | |The name of the table| | |
| | | | | |where the information| | |
| | | | | |come from | | |
|RELATIONSHIP |DESCRIPTION |
|= |Types are coincident (different designations?) |
|+ |The described site includes another site completely |
|- |The other site includes the described site completely |
|* |The two sites partially overlap |
|/ |Neighbour sites |
|Table name |CHM62EDT_SITES_RELATED_DESIGNATIONS |
|Definition |Relationship between sites and related designations |
|Entity name |Multiplicity |Mandatory |
|SITES |N |Y |
|DESIGNATION |M |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_DESIGNATION |PK (Same |INTEGER | |M |Identifier of the |Designations |N/a |
| |as in | | | |designation | | |
| |DESIGNATI| | | | | | |
| |ON table)| | | | | | |
|ID_GEOSCOPE |PK (Same |INTEGER | |M |Identifier of the |Designations |N/a |
| |as in | | | |designation geoscope | | |
| |DESIGNATI| | | | | | |
| |ON table)| | | | | | |
|SEQUENCE |PK |SMALLINT | |O |Site sequence |Designations |SEQUENCE |
|OVERLAP_TYPE | |VARCHAR(16) | |O |Overlap type | | |
| | | | | | | | |
|OVERLAP | |VARCHAR(50) | |O |Percentage of site |Designations |OVERLAP/COVER |
| | | | | |within that | | |
| | | | | |designation | | |
|DESIGNATED_SITE | |VARCHAR(255) | |O |Site name |Designations | |
|DESIGNATION_DATE | |VARCHAR(16) | |O |Site designation date|Designations | |
|SOURCE_DB | |VARCHAR(32) | |M |The database where | | |
| | | | | |this information come| | |
| | | | | |from | | |
|SOURCE_TABLE | |VARCHAR(16) | |M |The table where this | | |
| | | | | |information come from| | |
|Table name |CHM62EDT_GROUP_SPECIES |
|Definition |A species beINTEGERs to a group of species |
|Entity name |Multiplicity |Mandatory |
| SPECIES |N |Y |
| GROUPSPECIES |1 |N |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|COMMON_NAME | |VARCHAR(50) | |M |Common name of the |GROUPSPECIES |N/a |
| | | | | |group | | |
|SCIENTIFIC_NAME | |VARCHAR(50) | |M |Scientific name of |GROUPSPECIES |N/a |
| | | | | |the group | | |
|SELECTION | |INTEGER | |O |Selection (inclusion |GROUPSPECIES | |
| | | | | |in EUNIS) | | |
|ID_DC |FK (to |INTEGER | |O |DUBLIN CORE Reference|GROUPSPECIES | |
| |DUBLIN | | | | | |REFCD |
| |CORE) | | | | | | |
|Table name |CHM62EDT_TAXONOMY |
|Definition |A species refers to a taxcode |
|Entity name |Multiplicity |Mandatory |
| SPECIES |N |Y |
|TAXCODE |1 |Y |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(45) | |M |Name of the taxonomy | |N/a |
|LEVEL | |VARCHAR(8) | |M |Level of the taxonomy| |N/a |
|GROUP | |VARCHAR(8) | |O |Group | | |
|ID_TAXONOMY_LINK | |VARCHAR(16) | |O |Link to other | | |
| | | | | |taxonomy | | |
|ID_TAXONOMY_PARENT | |VARCHAR(16) | |O |Link to parent in | | |
| | | | | |taxonomy tree | | |
|TAXONOMY_TREE | |TEXT | |M |Full taxonomy tree in| | |
| | | | | |form of ID*Name*Value| | |
|ID_DC |FK (to |INTEGER | |O |DUBLIN CORE Reference| | |
| |DUBLIN | | | | | |REFCD |
| |CORE) | | | | | | |
|Table name |CHM62EDT_CONSERVATION_STATUS |
|Definition |A species is related to a conservation status |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|CODE | |VARCHAR(10) | |M |Name | |N/a |
|NAME | |VARCHAR(128) | |M |Name of the taxonomy | |N/a |
|DESCRIPTION | |VARCHAR(8) | |M | | |N/a |
|RED_BOOK_DATE | |DATE | |O |Date as in Red Book –| | |
| | | | | |Endangered species | | |
|ID_CONSERVATION_STATUS_| |INTEGER | |O |Link to other | | |
|LINK | | | | |conservation status | | |
|ID_DC |FK (to |INTEGER | |O |DUBLIN CORE Reference| | |
| |DUBLIN | | | | | |REFCD |
| |CORE) | | | | | | |
|Table name |CHM62EDT_GRID |
|Definition |Geographical cell |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|LATITUDE | |DECIMAL |N/a |O |Latitude |DIST_REF_GRID |REF_GRID_LAT |
|INTEGERITUDE | |DECIMAL |N/a |O |INTEGERitude |DIST_REF_GRID |REF_GRID_INTEGER |
|PROSPECT | |INTEGER |N/a |O | |DIST_REF_GRID |REF_GRID_PROSPECT |
|ID_DC |FK (to |INTEGER | |O |DUBLIN CORE Reference| | |
| |DUBLIN | | | | | |REFCD |
| |CORE) | | | | | | |
|Table name |CHM62EDT_HABITAT_REFERENCES |
|Definition | |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_DC |PK to |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| |DUBLIN | | | |object reference | | |
| |CORE | | | | | | |
|HAVE_SOURCE | |INTEGER |N/a |O | |HABREFS | |
|HAVE_OTHER_REFERENCES | |INTEGER |N/a |O | |HABREFS | |
4 Look-up tables
|Table name |CHM62EDT_REPORT_TYPE |
|Definition |Look up table for type of reported values |
This is a special table, because it acts as an intermediate table between a report on a nature object and actual attributes of that nature object.
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_LOOKUP | |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |element from Lookup | | |
| | | | | |table | | |
|Lookup_type | |VARCHAR(200) |CONS_STATUS = |M |Report value |N/a |N/a |
| | | |conservation | |definition | | |
| | | |status; | | | | |
| | | |SPECIES_STATUS =| | | | |
| | | |status of | | | | |
| | | |species; | | | | |
| | | |LEGAL_STATUS= | | | | |
| | | |legal status of | | | | |
| | | |species; | | | | |
| | | |LANGUAGE = | | | | |
| | | |languages; | | | | |
| | | |TREND = trend of| | | | |
| | | |species; | | | | |
| | | |INFO_QUALITY = | | | | |
| | | |quality of | | | | |
| | | |information; | | | | |
| | | |MEASURE_UNIT = | | | | |
| | | |list of | | | | |
| | | |measurement | | | | |
| | | |unit; | | | | |
| | | |STRATA= list of | | | | |
| | | |stratas; | | | | |
| | | |SPEC_STAT_HAB = | | | | |
| | | |status of | | | | |
| | | |species in | | | | |
| | | |habitat; | | | | |
| | | |ABUNDANCE= | | | | |
| | | |abundance of | | | | |
| | | |species; | | | | |
| | | |FREQUENCES= | | | | |
| | | |frequence of | | | | |
| | | |species; | | | | |
| | | |FAITHFULLNESS= | | | | |
| | | |faithfulness of | | | | |
| | | |data; | | | | |
| | | |GEOMORPH= | | | | |
| | | |geomorphology; | | | | |
| | | |EXPOSURE = | | | | |
| | | |exposure; | | | | |
| | | |EXPOSOURCE = | | | | |
| | | |exposource; | | | | |
| | | |SLOPE= slope; | | | | |
| | | |ALTZONE = list | | | | |
| | | |of altitudines | | | | |
| | | |of zones; | | | | |
| | | |DEPTH = depth; | | | | |
| | | |SALINITY = | | | | |
| | | |salinity; | | | | |
| | | |TIDAL = tidal; | | | | |
| | | |MARINE = marine;| | | | |
| | | |LOCALISED_NAME =| | | | |
| | | |localised_name | | | | |
|Table name |CHM62EDT_CONSERVATION_STATUS |
|Definition |Look up table for conservation status |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|code | |VARCHAR(10) | |M |Conservation status |eunis-db / species /|STATUSTP |
| | | | | |code |Eunis-sp.mdb / | |
| | | | | | |CONSSTATUS | |
|NAME | |VARCHAR(128) | |O |Conservation status |eunis-db / species /|STATUSDF |
| | | | | |definition |Eunis-sp.mdb / | |
| | | | | | |CONSSTATUS | |
|DESCRIPTION | |VARCHAR(255) | |O |Abbreviation of the |eunis-db / species /|STATUSAB |
| | | | | |status |Eunis-sp.mdb / | |
| | | | | | |CONSSTATUS | |
|Red_Book_DATE | |DATE |(currently void)|O |DATE of classification|eunis-db / species /|STDATE |
| | | | | |or publication of the |Eunis-sp.mdb / | |
| | | | | |Red Book |CONSSTATUS | |
|ID_CONSERVATION_STATUS_|FK (from |INTEGER |ID_CONS_STATUS |M |Equivalent European |eunis-db / species /|STTEMP |
|LINK |the same | |of the related | |code (can be the same |Eunis-sp.mdb / | |
| |table) | |conservation | |value of |CONSSTATUS | |
| | | |status | |ID_CONS_STATUS) | | |
|ID_DC |FK (Same |INTEGER | |O |DUBLIN CORE reference | | |
| |as in | | | | | | |
| |ID_DC | | | | | | |
| |table) | | | | | | |
|Table name |CHM62EDT_SPECIES_STATUS |
|Definition |Look-up table for status of a species |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|Description | |VARCHAR(100) | |M |Description of the |eunis-db / species /|SPSTATUSLB |
| | | | | |status |Eunis-sp.mdb / | |
| | | | | | |STATUSSPEC | |
|Short_definition | |VARCHAR(255) |(currently void)|O |Short definition |eunis-db / species /|SPSTATUSDF |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |STATUSSPEC | |
|Status_code | |CHAR(3) | |O |Status code |eunis-db / species /|SPSTATUSAB |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |STATUSSPEC | |
|Table name |CHM62EDT_LEGAL_STATUS |
|Definition |Look up table for legal status of species, referenced by an information source |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|Annex | |VARCHAR(50) | |M |Number of Annex |Eunis-db / species /|ANNEX |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |SPECLEGAL | |
|Priority | |INTEGER |"1" for TRUE; |M |Priority Species |Eunis-db / species /|PRIORITY |
| | | |"0" (default) | | |Eunis-sp.mdb / | |
| | | |for FALSE | | |SPECLEGAL | |
|Comment | |TEXT | |O |Exception specified |Eunis-db / species /|COMMENTS |
| | | | | |within the text |Eunis-sp.mdb / | |
| | | | | | |SPECLEGAL | |
|code | |VARCHAR(8) |Currently void |O |Legal status according|Eunis-db / species /|SPECLEGAL |
| | | | | |to international |Eunis-sp.mdb / | |
| | | | | |conventions, European |SPECLEGAL | |
| | | | | |Directives or national| | |
| | | | | |legislation | | |
|Table name |CHM62EDT_LANGUAGE |
|Definition |Look-up table for languages |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|code | |CHAR(2) | |M |Alphanumeric code of |eunis-db / species /|LANGCD |
| | | | | |the language |Eunis-sp.mdb / | |
| | | | | | |LANGUAGE; | |
|name_EN | |VARCHAR(255) | |M |Description of the |eunis-db / species /|LANGNAME |
| | | | | |language |Eunis-sp.mdb / | |
| | | | | | |LANGUAGE | |
|SelectION | |INTEGER |"1" for TRUE; |M |Temporary selection of|eunis-db / species /|SELECT |
| | | |"0" for FALSE | |data |Eunis-sp.mdb / | |
| | | |(default) | | |LANGUAGE | |
|name_FR | |VARCHAR(255) | |M |Description of the |eunis-db / species /|LANGNAME_fr |
| | | | | |language in French |Eunis-sp.mdb / | |
| | | | | | |LANGUAGE | |
|name_DE | |VARCHAR(255) | |O |Description of the |eunis-db / species /|LANGNAME_de |
| | | | | |language in German |Eunis-sp.mdb / | |
| | | | | | |LANGUAGE | |
|family | |VARCHAR(255) | |M |Linguistic group |eunis-db / species /|LANGFAMILY |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |LANGUAGE | |
|COMMENT | |VARCHAR(255) | |O |Comments |eunis-db / species /|NOTE |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |LANGUAGE | |
|Table name |CHM62EDT_TREND |
|Definition |Trend of population size related to a given time interval |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|status | |VARCHAR(50) | |M |Code |eunis-db / species /|TRTP |
| | | | | | |Eunis-sp.mdb / TREND| |
|DESCRIPTION | |TEXT | |M |Description |eunis-db / species /|TRDF |
| | | | | | |Eunis-sp.mdb / TREND| |
|Table name |CHM62EDT_INFO_QUALITY |
|Definition |Look-up table for quality of information about species population |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|status | |VARCHAR(50) | |M |Quality status |eunis-db / species /|QUALTP |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |QUALITY | |
|Description | |VARCHAR(255) |(currently void)|M |Definition |eunis-db / species /|QUALDF |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |QUALITY | |
|Table name |CHM62EDT_POPULATION_UNIT |
|Definition |Lookup table for list of measurement units |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) | |M |Description of the |eunis-db / species /|UNIT |
| | | | | |unit |Eunis-sp.mdb / | |
| | | | | | |UNITCD | |
|Description | |VARCHAR(50) | |M |Description of the |eunis-db / species /|UNIT |
| | | | | |unit |Eunis-sp.mdb / UNIT | |
|Table name |CHM62EDT_ABUNDANCE |
|Definition |Lookup table for values of abundance of the species in habitat |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|CODE | |VARCHAR(2) |“A”=abundant |M |Link to BioMar species|Luhab-mdb/ ABUNDANCE|ABUNDCD |
| | | |”C”=common | |abundance | | |
| | | |“F”=frequent | | | | |
| | | |“O”=occasional | | | | |
| | | |“P”= present/not| | | | |
| | | |known | | | | |
| | | |“R”=rare | | | | |
| | | |“SA”=Super | | | | |
| | | |abundant | | | | |
|Description | |VARCHAR(255) | |M |Explanation of |Luhab-mdb/ ABUNDANCE|ABUNDTEXT |
| | | | | |abundance codes | | |
|Table name |CHM62EDT_FREQUENCIES |
|Definition |Lookup table for frequencies of the species in habitat |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) | |M |Name frequency codes |Luhab-mdb/ |FREQCD |
| | | | | | |FREQUENCIES | |
|Description | |VARCHAR(255) | |M |Explanation of |Luhab-mdb/ |FREQTEXT |
| | | | | |frequency codes |FREQUENCIES | |
|Table name |CHM62EDT_FAITHFULNESS |
|Definition |Lookup table for faithfulness |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) | |M |Faithfulness |Luhab-Mdb/ |FAITHDESC |
| | | | | |description |FAITHFULNESS | |
|Description | |VARCHAR(100) | |M |Explanation of |Luhab-Mdb/ |FAITHTEXT |
| | | | | |faithfulness codes |FAITHFULNESS | |
|Table name |CHM62EDT_GEOMORPH |
|Definition |Look-up table of the geomorphologic feature of the habitats |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|Name | |VARCHAR(64) | |M |Geomorphologic feature|Luhab.mdb / GEOMORPH|GEOMORPH CD |
| | | | | |name | | |
|Description | | TEXT | |M |Geomorphologic and |Luhab.mdb / GEOMORPH|GEOMORPHDESC |
| | | | | |topographic features | | |
|OLD_CODE | | VARCHAR(16) | |M |Previous code |Luhab.mdb / GEOMORPH|GEOMORPHCD |
|Table name |CHM62EDT_EXPOSURE |
|Definition |Look-up table of the exposure |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(128) | |M |Exposure name |Luhab.mdb / EXPOSURE|EXPOSTEXT |
|DESCRIPTION | |VARCHAR(255) | |M |Exposure description |Luhab.mdb / EXPOSURE|EXPOSDESC |
|Table name |CHM62EDT_ALTITUDE |
|Definition |Look-up table of the altitudes of the zones |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|Name | |VARCHAR(64) | |M |Altitudinal zone name |luhab.mdb / ALTZONE |ALTZONE |
|Description | | TEXT | |M |Altitudinal zone |luhab.mdb / ALTZONE |ALTDESC |
| | | | | |description | | |
|OLD_CODE | | CHAR(2) | |M |Altitudinal zone |luhab.mdb / ALTZONE |OLD_ALTCD |
| | | | | |previous code | | |
|Table name |CHM62EDT_DEPTH |
|Definition |Look-up table of the depth of the habitat type zone |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) | |M |Depth band name |luhab.mdb / DEPTH |DEPTHTEXT |
|DESCRIPTION | |VARCHAR(255) | |M |Depth band text |luhab.mdb / DEPTH |DEPTHTEXT |
|Table name |CHM62EDT_SALINITY |
|Definition |Look-up table of the salinity |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|Name | |VARCHAR(128) | |M |Salinity text |luhab.mdb / SALINITY|SALINETEXT |
|Description | |TEXT | |M |Description of |luhab.mdb / SALINITY|SALINEDESC |
| | | | | |salinity text | | |
|OLD_CODE | |VARCHAR(16) | |M |Salinity old code |luhab.mdb / SALINITY|OLD_SALINECD |
|USED | |INTEGER |Default 1=TRUE |M |Used or not | | |
|Table name |CHM62EDT_HABITAT_INTERNATIONAL_NAME |
|Definition |Look-up table of the name of habitat in different languages or convention |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_LANGUAGE |PK |INTEGER | |M |Language | | |
|INTERNATIONAL_name | |VARCHAR(255) | |M |International name of |luhab.mdb / EMERALD |NAME |
| | | | | |the habitat |ANNEXi | |
|Table name |CHM62EDT HABITAT_DESCRIPTION |
|Definition |Look-up table of the habitat description |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_LANGUAGE |PK |INTEGER |N/a |M, U, A |Identifier of the |N/a |N/a |
| | | | | |language | | |
|Description | |TEXT | |M |Description of habitat|Eunishab.mdb/HABTEXT|TEXTDESCR |
|OWNER_TEXT | |TEXT | |O |Owner of the |Eunishab.mdb/HABTEXT|OWNER |
| | | | | |description | | |
|ID_DC |FK (to |INTEGER | |O |Reference information |Eunishab.mdb/HABTEXT| |
| |DUBLIN | | | | | | |
| |CORE) | | | | | | |
|Table name |CHM62EDT_GROUP_SPECIES |
|Definition |Look-up table of the groups of species |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|Common_name | |VARCHAR(50) | |M |English common name of|eunis-db / species /|GROUPCOMNAM |
| | | | | |the species group |Eunis-sp.mdb / | |
| | | | | | |GROUPSPEC | |
|Scientific_name | |VARCHAR(50) | |M |Scientific name of the|eunis-db / species /|GROUPSCIENTNAM |
| | | | | |species group |Eunis-sp.mdb / | |
| | | | | | |GROUPSPEC | |
|Selection | |INTEGER | |M |Temporary selection of|eunis-db / species /|SELECT |
| | | | | |data |Eunis-sp.mdb / | |
| | | | | | |GROUPSPEC | |
|ID_DC | |FK (to DUBLIN | |O |DUBLIN CORE reference | | |
| | |CORE) | | |information | | |
|Table name |CHM62EDT_TAXONOMY |
|Definition |Look-up table of the (vegetal and animal) taxonomic classification to family level |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|level | |VARCHAR(8) | |M |Taxonomic level |eunis-db / species /|TAX_LEVEL |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |TAXCODES | |
|name | |VARCHAR(45) | |M |Name of the taxon |eunis-db / species /|TAX_NAME |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |TAXCODES | |
|group | |VARCHAR(8) | |O |Code of the taxonomic |eunis-db / species /|TAXGROUP |
| | | | | |group |Eunis-sp.mdb / | |
| | | | | | |TAXCODES | |
|ID_DC |FK (same |INTEGER | |M |Reference to the | | |
| |as in | | | |Dublin Core | | |
| |DC_INDEX | | | | | | |
| |table) | | | | | | |
|ID_TAXONOMY_LINK |FK (same |VARCHAR(16) | |M |Reference to the |eunis-db / species /|TAXCODE |
| |as in | | | |related taxonomic code|Eunis-sp.mdb / | |
| |TAXONOMY | | | | |TAXCODES | |
| |table) | | | | | | |
|ID_TAXONOMY_PARENT |FK (same |VARCHAR(16) | |M |Reference to the |eunis-db / species /|TAXCODE |
| |as in | | | |parent taxonomic code |Eunis-sp.mdb / | |
| |TAXONOMY | | | | |TAXCODES | |
| |table) | | | | | | |
|NoteS | |BLOB | |O |Additional information|eunis-db / species /|Notes |
| | | | | | |Eunis-sp.mdb / | |
| | | | | | |TAXCODES | |
|Table name |CHM62EDT_CLASS_CODE |
|Definition |Lookup table for list of classification codes for Habitat types |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|name | |VARCHAR(255) | |M |Name of the |eunis-db / species /|UNIT |
| | | | | |classification system |Eunis-sp.mdb / UNIT | |
| | | | | |(and DATE) | | |
|SORT_ORDER | |SMALLINT | |M |Order of |eunis-db / species /| |
| | | | | |classification |Eunis-sp.mdb / UNIT | |
|UNVALIDATED_CODE | |CHAR(1) | |M |Non validate code – |eunis-db / species /|CLASSREF |
| | | | | |single letter |Eunis-sp.mdb / UNIT | |
|CURRENT_DATA | |INTEGER | |M |Classification is |eunis-db / species /|CURRENT |
| | | | | |currently used or |Eunis-sp.mdb / UNIT | |
| | | | | |historical | | |
|LEGAL | |INTEGER | |M |Classification is a |eunis-db / species /| |
| | | | | |legal type |Eunis-sp.mdb / UNIT | |
|ID_DC |FK (to |INTEGER | | |Reference to DUBLIN |Eunishab.mdb / |REFSPECCD |
| |DUBLIN | | | |CORE reference |CLASSCODES | |
| |CORE) | | | |information | | |
|Table name |CHM62EDT_SYNTAXA |
|Definition |Look-up table of the syntaxa |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|Code | |VARCHAR(8) | |M |Source taxonomic code |Luhab.mdb / SYNTAXA |SYNTAXCD |
|Name | |VARCHAR(255) | |M |Name of the syntaxa |Luhab.mdb / SYNTAXA |SYNTAXNAME |
|Author | |VARCHAR(100) | |O |Name of the author of |Luhab.mdb / SYNTAXA |SYNTAXAUTH |
| | | | | |the syntaxa | | |
|SYNTAXON | |INTEGER | |O | |Luhab.mdb / SYNTAXA | |
|Table name |CHM62EDT_HUMAN_ACTIVITY |
|Definition |Human activity decoding |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(128) |N/a |M |English name |Activity codes |DESCRIPTION |
|DESCRIPTION | |TEXT |N/a |O |Description | |DESCRIPTION |
|Table name |CHM62EDT_REGION_CODES |
|Definition |Region codes decoding |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(255) |N/a |M | |NUTS_V5 |DESCRIPTION |
|DESCRIPTION | |TEXT |N/a |M | |NUTS_V5 |DESCRIPTION |
|Table name |CHM62EDT_MOTIVATION |
|Definition |Motivation decoding |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(128) |N/a |M | |Motivation |DESCRIPTION |
|DESCRIPTION | |TEXT |N/a |M | |Motivation |DESCRIPTION |
|Table name |CHM62EDT_DISTRIBUTION_STATUS |
|Definition |Geo reference distribution status |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |TEXT |N/a |M |Distribution status |DIST_STATUS |STATUS_GRID_LB |
|DESCRIPTION | |TEXT |N/a |M |Abbreviation of |DIST_STATUS |STATUS_GRID_SHORT|
| | | | | |distribution status | |_LB |
|ID_DC |FK (to |INTEGER |N/a |M |Dublin Core Index |N/a |N/a |
| |DUBLIN | | | | | | |
| |CORE) | | | | | | |
|Table name |CHM62EDT_CLIMATE |
|Definition |Clime zone description |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) |N/a |M |Name |CLIZONE |Climzone |
|DESCRIPTION | |TEXT |N/a |M |Description |CLIZONE |Climdesc |
|Table name |CHM62EDT_GLOBAL |
|Definition |Lookup table for global characterization of habitat types |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) |N/a |M | |GLOBAL | |
|DESCRIPTION | |TEXT |N/a |M | |GLOBAL | |
|Table name |CHM62EDT_SPATIAL |
|Definition |Lookup table for habitat types |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) |N/a |M | |SPATIAL |Spatialunit |
|DESCRIPTION | |TEXT |N/a |M | |SPATIAL |Spatialdesc |
|Table name |CHM62EDT_SUBSTRATE |
|Definition |Lookup table for habitat types |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) |N/a |M | |SUBSTRATES |substrate |
|DESCRIPTION | |TEXT |N/a |M | |SUBSTRATES |subdesc |
|Table name |CHM62EDT_TEMPORAL |
|Definition |Lookup table for habitat types |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|NAME | |VARCHAR(64) |N/a |M | |TEMPORAL |Temptext |
|DESCRIPTION | |TEXT |N/a |M | |TEMPORAL |Tempdesc |
|USED | |INTEGER |Default: 1=TRUE|M |Used or not | | |
Dublin Core tables
|Table name |CHM62EDT_DC_CONTRIBUTOR |
|Definition |List of the contributors |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_contributor |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |contributor | | |
|Contributor | |VARCHAR(255) |N/a |M |A person or | | |
| | | | | |organization not | | |
| | | | | |specified in a Creator| | |
| | | | | |element who has made | | |
| | | | | |significant | | |
| | | | | |intellectual | | |
| | | | | |contributions to the | | |
| | | | | |resource. | | |
|Table name |CHM62EDT_DC_COVERAGE |
|Definition |List of the coverages |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_coverage |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |coverage | | |
|Coverage | |VARCHAR(255) |N/a |M |The spatial and/or | | |
| | | | | |temporal | | |
| | | | | |characteristics of the| | |
| | | | | |intellectual content | | |
| | | | | |of the resource | | |
|Spatial | |VARCHAR(255) | |O |Spatial characteristic| | |
| | | | | |of the intellectual | | |
| | | | | |content of the resoure| | |
| | | | | | | | |
| | | | | | | | |
|Temporal | |VARCHAR(255) | |O |Temporal | | |
| | | | | |characteristic of the | | |
| | | | | |intellectual content | | |
| | | | | |of the resoure | | |
|Table name |CHM62EDT_DC_CREATOR |
|Definition |List of the creators |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_creator |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |creator | | |
|Creator | |VARCHAR(255) |N/a |M |The person or |eunis-db / species /|AUTHOR |
| | | | | |organization primarily|Eunis-sp.mdb / | |
| | | | | |responsible for |SPECIES | |
| | | | | |creating the | | |
| | | | | |intellectual content | | |
| | | | | |of the resource. | | |
|Table name |CHM62EDT_DC_DATE |
|Definition |List of the dates |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_date |PK |INTEGER |N/a |M |Identifier of the date|N/a |N/a |
|Created | |DATE |N/a |M |Date of creation of |eunis-db / species /|DATE ; DATE |
| | | | | |the resource |Eunis-sp.mdb / | |
| | | | | | |REFSPEC; | |
| | | | | | |luhab.mdb/REFERENCES| |
| | | | | | | | |
| | | | | | | | |
|Valid | |DATE | |O |Date (often a range) | | |
| | | | | |of validity of a | | |
| | | | | |resource | | |
|Available | |DATE | |O |Date (often a range) | | |
| | | | | |that the resource will| | |
| | | | | |become or did become | | |
| | | | | |available | | |
|Issued | |DATE | |O |Date of formal | | |
| | | | | |issuance (e.g., | | |
| | | | | |publication) of the | | |
| | | | | |resource. | | |
|Modified | |DATE | |O |Date on which the | | |
| | | | | |resource was changed | | |
|MDate | |DATE | |O |A date associated with|
| | | | | |the creation or |
| | | | | |availability of the |
| | | | | |resource |
|Table name |CHM62EDT_DC_DESCRIPTION |
|Definition |List of the descriptions |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_description |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |description | | |
|Descrption | |VARCHAR(255) |N/a |M |A textual description | | |
| | | | | |of the content of the | | |
| | | | | |resource, including | | |
| | | | | |abstracts in the case | | |
| | | | | |of document-like | | |
| | | | | |objects or content | | |
| | | | | |descriptions in the | | |
| | | | | |case of visual | | |
| | | | | |resources | | |
| | | | | | | | |
| | | | | | | | |
|TOC | |VARCHAR(255) | |O |A list of subunits of | | |
| | | | | |the content of the | | |
| | | | | |resource | | |
|Abstract | |VARCHAR(255) | |O |A summary of the | | |
| | | | | |content of the | | |
| | | | | |resource. | | |
|Table name |CHM62EDT_DC_FORMAT |
|Definition |List of the formats |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_format |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |format | | |
|Format | |VARCHAR(255) |N/a |M |The data format and, | | |
| | | | | |optionally, dimensions| | |
| | | | | |(e.g., size, duration)| | |
| | | | | |of the resource | | |
| | | | | | | | |
| | | | | | | | |
|Extent | |VARCHAR(255) | |O |The size or duration | | |
| | | | | |of the resource | | |
|Medium | |VARCHAR(255) | |O |The material or | | |
| | | | | |physical carrier of | | |
| | | | | |the resource. | | |
|Table name |CHM62EDT_DC_IDENTIFIER |
|Definition |List of the identifiers |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_identifier |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |identifier of the | | |
| | | | | |resource | | |
|Identifier | |VARCHAR(255) |N/a |M |A string or number | | |
| | | | | |used to uniquely | | |
| | | | | |identity the resource | | |
|Table name |CHM62EDT_DC_LANGUAGE |
|Definition |List of the languages |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_language |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |language | | |
|Language | |VARCHAR(255) |N/a |M |The language of the | | |
| | | | | |intellectual content | | |
| | | | | |of the resource | | |
|Table name |CHM62EDT_DC_PUBLISHER |
|Definition |List of the publishers |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_publisher |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |publisher | | |
|Publisher | |VARCHAR(255) |N/a |M |The entity responsible|eunis-db / species /|Publisher; |
| | | | | |for making the |Eunis-sp.mdb / |Publisher |
| | | | | |resource available in |REFSPEC; | |
| | | | | |its present form, such|luhab.mdb/REFERENCES| |
| | | | | |as a publishing house,| | |
| | | | | |a university | | |
| | | | | |department, or a | | |
| | | | | |corporate entity | | |
|Table name |CHM62EDT_DC_RELATION |
|Definition |List of the relations |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_reletion |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |identifier of the | | |
| | | | | |resource | | |
|Reletion | |VARCHAR(255) |N/a |M |An identifier of a | | |
| | | | | |second resource and | | |
| | | | | |its relationship to | | |
| | | | | |the present resource | | |
|Is_version_of | |VARCHAR(255) | |O |The described resource| | |
| | | | | |is a version, edition,| | |
| | | | | |or adaptation of the | | |
| | | | | |referenced resource | | |
|Has_version | |VARCHAR(255) | |O |The described resource| | |
| | | | | |has a version, | | |
| | | | | |edition, or | | |
| | | | | |adaptation, namely, | | |
| | | | | |the referenced | | |
| | | | | |resource | | |
|Is_replaced_by | |VARCHAR(255) | |O |The described resource| | |
| | | | | |is supplanted, | | |
| | | | | |displaced, or | | |
| | | | | |superceded by the | | |
| | | | | |referenced resource | | |
|Is_required_by | |VARCHAR(255) | |O |The described resource| | |
| | | | | |is required by the | | |
| | | | | |referenced resource, | | |
| | | | | |either physically or | | |
| | | | | |logically. | | |
|Requires | |VARCHAR(255) | |O |The described resource| | |
| | | | | |requires the | | |
| | | | | |referenced resource to| | |
| | | | | |support its function, | | |
| | | | | |delivery, or coherence| | |
| | | | | |of content | | |
|Is_part_of | |VARCHAR(255) | |O |The described resource| | |
| | | | | |is a physical or | | |
| | | | | |logical part of the | | |
| | | | | |referenced resource. | | |
|Has_part | |VARCHAR(255) | |O |The described resource| | |
| | | | | |includes the | | |
| | | | | |referenced resource | | |
| | | | | |either physically or | | |
| | | | | |logically. | | |
|Is_references_by | |VARCHAR(255) | |O |The described resource| | |
| | | | | |is referenced, cited, | | |
| | | | | |or otherwise pointed | | |
| | | | | |to by the referenced | | |
| | | | | |resource. | | |
|References | |VARCHAR(255) | |O |The described resource| | |
| | | | | |references, cites, or | | |
| | | | | |otherwise points to | | |
| | | | | |the referenced | | |
| | | | | |resource | | |
|Is_format_of | |VARCHAR(255) | |O |The described resource| | |
| | | | | |is the same | | |
| | | | | |intellectual content | | |
| | | | | |of the referenced | | |
| | | | | |resource, but | | |
| | | | | |presented in another | | |
| | | | | |format | | |
|Has_format | |VARCHAR(255) | |O |The described resource| | |
| | | | | |pre-existed the | | |
| | | | | |referenced resource, | | |
| | | | | |which is essentially | | |
| | | | | |the same intellectual | | |
| | | | | |content presented in | | |
| | | | | |another format. | | |
|REPLACES | |VARCHAR(255) | |O |The described resource| | |
| | | | | |supplants, displaces, | | |
| | | | | |or supersedes the | | |
| | | | | |referenced resource | | |
|Table name |CHM62EDT_DC_RIGHTS |
|Definition |List of the rights |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_rights |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |right | | |
|Right | |VARCHAR(255) |N/a |M |A rights management | | |
| | | | | |statement, an | | |
| | | | | |identifier that links | | |
| | | | | |to a rights management| | |
| | | | | |statement, or an | | |
| | | | | |identifier that links | | |
| | | | | |to a service providing| | |
| | | | | |information about | | |
| | | | | |rights management for | | |
| | | | | |the resource | | |
|Table name |CHM62EDT_DC_SOURCE |
|Definition |List of the sources |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_source |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |source | | |
|Source | |VARCHAR(255) |N/a |M |Information about a |Eunis-db/species/Eun|AUTHOR ; AUTHOR |
| | | | | |second resource from |is-sp.mdb/REFSPEC ; | |
| | | | | |which the present |luhab.mdb/ | |
| | | | | |resource is derived |REFERENCES | |
|Editor | |VARCHAR(255) | |O |Comment |Eunis-db/species/Eun|EDITOR ; EDITOR |
| | | | | | |is-sp.mdb/REFSPEC ; | |
| | | | | | |luhab.mdb/ | |
| | | | | | |REFERENCES | |
|Journal_title | |VARCHAR(255) | |O |Title of the journal |Eunis-db/species/Eun|Journtitle; |
| | | | | | |is-sp.mdb/REFSPEC ; |JOURNTITLE |
| | | | | | |luhab.mdb/ | |
| | | | | | |REFERENCES | |
|Book_title | |VARCHAR(255) | |O |Title of the book |Eunis-db/species/Eun|Booktitle; |
| | | | | | |is-sp.mdb/REFSPEC ; |BOOKTITLE |
| | | | | | |luhab.mdb/ | |
| | | | | | |REFERENCES | |
|Journal_issue | |VARCHAR(255) | |O |Identification data of|Eunis-db/species/Eun|Journissue; |
| | | | | |the journal issue |is-sp.mdb/REFSPEC ; |JOURNISSUE |
| | | | | | |luhab.mdb/ | |
| | | | | | |REFERENCES | |
|ISBN | |VARCHAR(255) | |O |ISBN code of the |Eunis-db/species/Eun|ISBN; ISBN |
| | | | | |publication |is-sp.mdb/REFSPEC ; | |
| | | | | | |luhab.mdb/ | |
| | | | | | |REFERENCES | |
|Geo_level | |VARCHAR(255) | |O |Geographical area |Luhab.mdb/ LEGDESIG |GEOLEVEL |
| | | | | |covered by legal | | |
| | | | | |instrument | | |
|URL | |VARCHAR(255) | |O |URL of info source | | |
|Table name |CHM62EDT_DC_SUBJECT |
|Definition |List of the subjects |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_subject |PK |INTEGER |N/a |M |Identifier of the |N/a |N/a |
| | | | | |subject | | |
|Subject | |VARCHAR(255) |N/a |M |The topic of the | | |
| | | | | |resource. Typically, | | |
| | | | | |subject will be | | |
| | | | | |expressed as keywords | | |
| | | | | |or phrases that | | |
| | | | | |describe the subject | | |
| | | | | |or content of the | | |
| | | | | |resource | | |
|Table name |CHM62EDT_DC_TITLE |
|Definition |List of the titles. |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_title |PK |INTEGER |N/a |M,U,A |Identifier of the |N/a |N/a |
| | | | | |title | | |
|Title | |VARCHAR(255) |N/a |M |The name given to the |Eunis-db/species/Eun|TITLE, TITLE |
| | | | | |resource, usually by |is-sp.mdb/REFSPEC ; | |
| | | | | |the Creator or |luhab.mdb/ | |
| | | | | |Publisher |REFERENCES | |
|Alternative | |VARCHAR(255) | |O |Any form of the title |Eunis-db/species/Eun|ABREV_TITLE ; |
| | | | | |used as a substitute |is-sp.mdb/REFSPEC | |
| | | | | |or alternative to the | | |
| | | | | |formal title of the | | |
| | | | | |resource | | |
|Table name |CHM62EDT_DC_TYPE |
|Definition |List of the types |
|Field name |Key |Data type |Values |Status |Description |Source Table |Source Field |
|ID_type |PK |INTEGER |N/a |M |Identifier of the type|N/a |N/a |
|Type | |VARCHAR(255) |N/a |M |The category of the | | |
| | | | | |resource, such as home| | |
| | | | | |page, novel, poem, | | |
| | | | | |working paper, | | |
| | | | | |technical report, | | |
| | | | | |essay, dictionary | | |
Auxiliary tables
|Table name |EUNIS_ADVANCED_SEARCH/ EUNIS_COMBINED_SEARCH |
|Definition |Used to store temporary data for Advanced/Combined Search functionality |
|Field name |Key |Data type |Description |
|ID_SESSION |PK |VARCHAR(64) |Session ID |
|NATURE_OBJECT |PK |VARCHAR(16) |Nature object type |
|ID_NODE |PK |VARCHAR(16) |Identifier of the criterion node |
|NODE_TYPE | |VARCHAR(16) |Node type |
|Table name |EUNIS_ADVANCED_SEARCH_TEMP/ EUNIS_COMBINED_SEARCH_TEMP |
|Definition |Used to store temporary data for Advanced/Combined Search functionality |
|Field name |Key |Data type |Description |
|ID_SESSION |PK |VARCHAR(64) |Session ID |
|NATURE_OBJECT |PK |VARCHAR(16) |Nature object type |
|ID_NODE |PK |VARCHAR(16) |Identifier of the criterion node |
|NODE_TYPE | |VARCHAR(16) |Node type |
|Table name |EUNIS_ADVANCED_SEARCH_RESULTS/ EUNIS_COMBINED_SEARCH_RESULTS |
|Definition |Used to store temporary data for Advanced/Combined Search functionality |
|Field name |Key |Data type |Description |
|ID_SESSION |PK |VARCHAR(64) |Session ID |
|ID_NATURE_OBJECT |PK |VARCHAR(16) |Identifier of the nature object |
|NATURE_OBJECT |PK |VARCHAR(16) |Nature object type |
|Table name |EUNIS_ADVANCED_SEARCH_CRITERIA/ EUNIS_COMBINED_SEARCH_CRITERIA |
|Definition |Used to store temporary data for Advanced/Combined Search functionality |
|Field name |Key |Data type |Description |
|ID_SESSION |PK |VARCHAR(64) |Session ID |
|NATURE_OBJECT |PK |VARCHAR(16) |Nature object type |
|ID_NODE |PK |VARCHAR(16) |Identifier of the criterion node |
|ATTRIBUTE | |VARCHAR(32) |Attribute corresponding to search criteria |
|OPERATOR | |VARCHAR(16) |Operator corresponding to search criteria |
|FIRST_VALUE | |VARCHAR(128) |First value corresponding to search criteria |
|LAST_VALUE | |VARCHAR(128) |Last value corresponding to search criteria (used with BETWEEN operator) |
|Table name |EUNIS_ADVANCED_SEARCH_CRITERIA_TEMP/ EUNIS_COMBINED_SEARCH_CRITERIA_TEMP |
|Definition |Used to store temporary data for Advanced/Combined Search functionality |
|Field name |Key |Data type |Description |
|ID_SESSION |PK |VARCHAR(64) |Session ID |
|NATURE_OBJECT |PK |VARCHAR(16) |Nature object type |
|ID_NODE |PK |VARCHAR(16) |Identifier of the criterion node |
|ATTRIBUTE | |VARCHAR(32) |Attribute corresponding to search criteria |
|OPERATOR | |VARCHAR(16) |Operator corresponding to search criteria |
|FIRST_VALUE | |VARCHAR(128) |First value corresponding to search criteria |
|LAST_VALUE | |VARCHAR(128) |Last value corresponding to search criteria (used with BETWEEN operator) |
|Table name |EUNIS_BOOKMARKS |
|Definition |Stores users saved page bookmarks |
|Field name |Key |Data type |Description |
|USERNAME |PK, FK (to|INTEGER |Identifier of the user |
| |EUNIS_USER| | |
| |S) | | |
|BOOKMARK |PK |TEXT |Name of the bookmark |
|DESCRIPTION |PK |VARCHAR(255) |Description of the bookmark |
|RECORD_DATE | |TIMESTAMP |Timestamp value |
|Table name |EUNIS_ISO_LANGUAGES |
|Definition |Stores languages available in EUNIS |
|Field name |Key |Data type |Description |
|NAME |PK |VARCHAR(32) |Language name |
|CODE | |VARCHAR(6) |Language code |
|Table name |EUNIS_FEEDBACK |
|Definition |Used to store users feedback |
|Field name |Key |Data type |Description |
|ID_FEEDBACK |PK |INTEGER |Identifier of the feedback |
|FEEDBACK_TYPE | |VARCHAR(32) |See for corresponding fields |
|MODULE | |VARCHAR(32) |See for corresponding fields |
|COMMENT | |VARCHAR(255) |See for corresponding fields |
|NAME | |VARCHAR(64) |See for corresponding fields |
|EMAIL | |VARCHAR(64) |See for corresponding fields |
|COMPANY | |VARCHAR(64) |See for corresponding fields |
|ADDRESS | |VARCHAR(255) |See for corresponding fields |
|PHONE | |VARCHAR(32) |See for corresponding fields |
|FAX | |VARCHAR(32) |See for corresponding fields |
|URL | |VARCHAR(128) |See for corresponding fields |
|RECORD_DATE | |TIMESTAMP |See for corresponding fields |
|Table name |EUNIS_GROUP_SEARCH |
|Definition |Used to save users search criteria |
|Field name |Key |Data type |Description |
|CRITERIA_NAME |PK |VARCHAR(128) |Identifier of the search criteria |
|DESCRIPTION | |TEXT | |
|USERNAME |FK |VARCHAR(100) | |
|FROM_WHERE | |VARCHAR(2550 |The URL of the page |
|Table name |EUNIS_GROUP_SEARCH_CRITERIA |
|Definition |Used to save users search criteria |
|Field name |Key |Data type |Description |
|CRITERIA_NAME |PK |VARCHAR(128) |Identifier of the search criteria |
|ID_EUNIS_GROUP_SEARCH_C| |VARCHAR(16) |Unique ID for criteria |
|RITERIA | | | |
|CRITERIA_ATTRIBUTE |FK |VARCHAR(128) |Attribute |
|CRITERIA_FORM_FIELD_ATT| |VARCHAR(1280 |Form field attribute |
|RIBUTE | | | |
|CRITERIA_OPERATOR | |VARCHAR(16) |Operator |
|CRITERIA_FORM_FIELD_OPE| |VARCHAR(128) |Form field operator |
|RATOR | | | |
|CRITERIA_FIRST_VALUE | |VARCHAR(128) |First value |
|CRITERIA_LAST_VALUE | |VARCHAR(128) |Last value (used with BETWEEN) |
|CRITERIA_BOOLEAN | |VARCHAR(50) |AND/OR corresponding to criteria combination |
|Table name |EUNIS_HEADLINES |
|Definition |Used to store headline on first page of EUNIS 2 |
|Field name |Key |Data type |Description |
|CONTENT | |VARCHAR(255) |Headline text |
|START_DATE | |DATE |Headline start date |
|END_DATE | |DATE |Headline expiring date |
|RECORD_DATE | |TIMESTAMP | |
|Table name |EUNIS_ISO_LANGUAGES |
|Definition |Utility table for HTML page encoding |
|Field name |Key |Data type |Description |
|NAME | |VARCHAR(32) |Name of language |
|CODE | |VARCHAR(6) |HTML encoding |
|Table name |EUNIS_RELATED_REPORTS |
|Definition |It is used to store information on uploaded documents |
|Field name |Key |Data type |Description |
|FILE_NAME | |VARCHAR(255) |Name of the file |
|REPORT_NAME | |VARCHAR(255) |Name of the report |
|APPROVED | |INTEGER |Status of approval |
|RECORD_DATE | |TIMESTAMP |Record timestamp |
|RECORD_AUTHOR | |VARCHAR(16) |Username who uploaded the file/report |
|Table name |EUNIS_SESSION_LOG |
|Definition |Stores session log of users |
|Field name |Key |Data type |Description |
|ID_SESSION | |VARCHAR(255) |Identifier of the web session |
|USERNAME | |VARCHAR(64) |Username |
|START | |DATETIME |Login time |
|END | |DATETIME |Logoff time |
|IP_ADDRESS | |VARCHAR(32) |IP Address |
|Table name |EUNIS_WEB_CONTENT |
|Definition |Table which holds dynamic text, including Multilanguage support |
|Field name |Key |Data type |Description |
|ID_PAGE |PK |INTEGER |Identifier of the text |
|CONTENT | |TEXT |Text |
|CONTENT_VALID | |INTEGER |English text was changed or not: 0 = NO, 1 = YES |
|DESCRIPTION | |VARCHAR(255) |Text description |
|LANG | |VARCHAR(64) |Identifier of the language |
|LANG_STATUS | |INTEGER |Language is available to public on web 1 = YES, 0 = NO |
|CONTENT_LENGTH | |INTEGER |Maximum length of text |
|RECORD_DATE | |TIMESTAMP |Record timestamp |
|RECORD_AUTHOR | |VARCHAR(16) |Username who changed the value |
|Table name |EUNIS_DIGIR |
|Definition |This table is exclusively used by the EUNIS Digir provider |
The structure of this table is derived from the GBIF toolkit.
The SQL script is listed in the Annexes of this document.
Authenticated users information tables
|Table name |EUNIS_RIGHTS |
|Definition |User rights |
|Field name |Key |Data type |Description |
|RIGHTNAME |PK |VARCHAR(250) |Identifier of the user right |
|DESCRIPTION | |VARCHAR(250) |Description |
|Table name |EUNIS_ROLES |
|Definition |Application roles – a role is a collection of rights |
|Field name |Key |Data type |Description |
|ROLENAME |PK |VARCHAR(250) |Identifier of the role |
|DESCRIPTION | |VARCHAR(250) |Description |
|Table name |EUNIS_ROLES_RIGHTS |
|Definition |Links between user rights and roles |
|Field name |Key |Data type |Description |
|RIGHTNAME |PK, FK to |VARCHAR(250) |Identifier of the user right |
| |RIGHTS | | |
|ROLENAME |PK, FK to |VARCHAR(250) |Identifier of the role |
| |ROLES | | |
|Table name |EUNIS_USERS |
|Definition |Authenticated users |
|Field name |Key |Data type |Description |
|USERNAME |PK |VARCHAR(100) |User name |
|PASSWORD | |VARCHAR(255) |Encrypted password |
|FIRST_NAME | |VARCHAR(255) |Additional data on user |
|LAST_NAME | |VARCHAR(255) |Additional data on user |
|EMAIL | |VARCHAR(64) |User email address |
|LANG | |VARCHAR(5) |Preferred language |
|THEME_INDEX | |INTEGER |Identifier of the preferred visual theme |
|LOGIN_DATE | |TIMESTAMP | |
|Table name |EUNIS_USERS_ROLES |
|Definition |Link between users and roles |
|Field name |Key |Data type |Description |
|USERNAME |PK, FK to |VARCHAR(100) |User name |
| |USERS | | |
|ROLENAME |PK, FK to |VARCHAR(100) |Role |
| |ROLES | | |
0. SQL Scripts
Here are the SQL script used to create the database:
USE `eunis`;
--
-- Table structure for table `chm62edt_abundance`
--
DROP TABLE IF EXISTS `chm62edt_abundance`;
CREATE TABLE `chm62edt_abundance` (
`ID_ABUNDANCE` int(11) NOT NULL default '0',
`CODE` varchar(2) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_ABUNDANCE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_activity_influence`
--
DROP TABLE IF EXISTS `chm62edt_activity_influence`;
CREATE TABLE `chm62edt_activity_influence` (
`ID_ACTIVITY_INFLUENCE` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_ACTIVITY_INFLUENCE`),
UNIQUE KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_activity_intensity`
--
DROP TABLE IF EXISTS `chm62edt_activity_intensity`;
CREATE TABLE `chm62edt_activity_intensity` (
`ID_ACTIVITY_INTENSITY` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_ACTIVITY_INTENSITY`),
UNIQUE KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_altitude`
--
DROP TABLE IF EXISTS `chm62edt_altitude`;
CREATE TABLE `chm62edt_altitude` (
`ID_ALTITUDE` int(11) NOT NULL default '0',
`NAME` varchar(64) NOT NULL default '',
`DESCRIPTION` text,
`OLD_CODE` varchar(2) default NULL,
PRIMARY KEY (`ID_ALTITUDE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_area_legal_text`
--
DROP TABLE IF EXISTS `chm62edt_area_legal_text`;
CREATE TABLE `chm62edt_area_legal_text` (
`ID_GEOSCOPE` int(11) NOT NULL default '-1',
`ID_DC` int(11) NOT NULL default '-1',
`LEGAL_DATE` date NOT NULL default '0000-00-00',
`ID_LEGAL_AREA_EVENT` int(11) NOT NULL default '0',
`DESCRIPTION` text,
`INPUT_DATE` date default NULL,
PRIMARY KEY (`ID_GEOSCOPE`,`ID_DC`,`ID_LEGAL_AREA_EVENT`,`LEGAL_DATE`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_ID_LEGAL_AREA_EVENT` (`ID_LEGAL_AREA_EVENT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_biogeoregion`
--
DROP TABLE IF EXISTS `chm62edt_biogeoregion`;
CREATE TABLE `chm62edt_biogeoregion` (
`ID_BIOGEOREGION` int(11) NOT NULL default '-1',
`ID_GEOSCOPE` int(11) NOT NULL default '-1',
`CODE` varchar(2) NOT NULL default '',
`CODE_EEA` varchar(5) default NULL,
`NAME` varchar(128) NOT NULL default '',
`SELECTION` int(11) default NULL,
PRIMARY KEY (`ID_BIOGEOREGION`,`ID_GEOSCOPE`),
KEY `IDX_CODE` (`CODE`),
KEY `IDX_NAME` (`NAME`),
KEY `IDX_ID_GEOSCOPE` (`ID_GEOSCOPE`),
KEY `IDX_ID_BIOGEOREGION` (`ID_BIOGEOREGION`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_chemistry`
--
DROP TABLE IF EXISTS `chm62edt_chemistry`;
CREATE TABLE `chm62edt_chemistry` (
`ID_CHEMISTRY` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_CHEMISTRY`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_class_code`
--
DROP TABLE IF EXISTS `chm62edt_class_code`;
CREATE TABLE `chm62edt_class_code` (
`ID_CLASS_CODE` int(11) NOT NULL default '0',
`NAME` varchar(255) NOT NULL default '',
`SORT_ORDER` smallint(6) default NULL,
`UNVALIDATED_CODE` char(1) default NULL,
`CURRENT_DATA` int(11) default NULL,
`LEGAL` int(11) default NULL,
`ID_DC` int(11) default NULL,
`CURRENT_CLASSIFICATION` tinyint(4) default NULL,
PRIMARY KEY (`ID_CLASS_CODE`),
KEY `IDX_SORT_ORDER` (`SORT_ORDER`),
KEY `IDX_LEGAL` (`LEGAL`),
KEY `IDX_NAME` (`NAME`),
KEY `IDX_CURRENT_CLASSIFICATION` (`CURRENT_CLASSIFICATION`),
KEY `IDX_ID_DC` (`ID_DC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_climate`
--
DROP TABLE IF EXISTS `chm62edt_climate`;
CREATE TABLE `chm62edt_climate` (
`ID_CLIMATE` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_CLIMATE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_conservation_status`
--
DROP TABLE IF EXISTS `chm62edt_conservation_status`;
CREATE TABLE `chm62edt_conservation_status` (
`ID_CONSERVATION_STATUS` int(11) NOT NULL default '0',
`CODE` varchar(10) default NULL,
`NAME` varchar(128) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`POPULATION_CONCERNED` varchar(128) default NULL,
`RED_BOOK_DATE` date default NULL,
`ID_CONSERVATION_STATUS_LINK` int(11) default NULL,
`ID_DC` int(11) NOT NULL default '-1',
PRIMARY KEY (`ID_CONSERVATION_STATUS`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_ID_CONSERVATION_STATUS_LINK` (`ID_CONSERVATION_STATUS_LINK`),
KEY `IDX_CODE` (`CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_country`
--
DROP TABLE IF EXISTS `chm62edt_country`;
CREATE TABLE `chm62edt_country` (
`ID_COUNTRY` int(11) NOT NULL default '-1',
`ID_GEOSCOPE` int(11) NOT NULL default '-1',
`EUNIS_AREA_CODE` varchar(3) NOT NULL default '',
`AREA_NAME` varchar(255) default NULL,
`AREA_NAME_EN` varchar(255) default NULL,
`AREA_NAME_FR` varchar(255) default NULL,
`ISO_2L` varchar(2) default NULL,
`ISO_3L` varchar(3) default NULL,
`ISO_N` smallint(6) default NULL,
`ISO_2_WCMC` varchar(2) default NULL,
`ISO_3_WCMC` varchar(3) default NULL,
`ISO_3_WCMC_PARENT` varchar(3) default NULL,
`TEL_CODE` smallint(6) default NULL,
`AREUCD` varchar(2) default NULL,
`SORT_NUMBER` int(11) default NULL,
`COUNTRY_TYPE` char(1) default NULL,
`SURFACE` int(11) default NULL,
`NGO` int(11) default NULL,
`NUMBER_DESIGN_AREA` int(11) default NULL,
`SOURCE` varchar(255) default NULL,
`POLITICAL_STATUS` varchar(100) default NULL,
`POPULATION` int(11) default NULL,
`POP_DENSITY` double default NULL,
`CAPITAL` varchar(64) default NULL,
`CURRENCY_CODE` varchar(3) default NULL,
`CURRENCY_NAME` varchar(64) default NULL,
`LAT_MIN` varchar(16) default NULL,
`LAT_MAX` varchar(16) default NULL,
`LONG_MIN` varchar(16) default NULL,
`LONG_MAX` varchar(16) default NULL,
`ALT_MIN` int(11) default NULL,
`ALT_MAX` int(11) default NULL,
`SELECTION` int(11) default NULL,
PRIMARY KEY (`ID_COUNTRY`,`ID_GEOSCOPE`),
KEY `IDX_ID_GEOSCOPE` (`ID_GEOSCOPE`),
KEY `IDX_AREA_NAME_EN` (`AREA_NAME_EN`),
KEY `IDX_EUNIS_AREA_CODE` (`EUNIS_AREA_CODE`),
KEY `IDX_ISO_2L` (`ISO_2L`,`ISO_3L`),
KEY `IDX_SELECTION` (`SELECTION`),
KEY `IDX_ISO_3L` (`ISO_3L`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_country_biogeoregion`
--
DROP TABLE IF EXISTS `chm62edt_country_biogeoregion`;
CREATE TABLE `chm62edt_country_biogeoregion` (
`CODE_BIOGEOREGION` varchar(16) NOT NULL default '',
`CODE_COUNTRY` varchar(16) NOT NULL default '',
`PERCENT` int(11) default NULL,
PRIMARY KEY (`CODE_BIOGEOREGION`,`CODE_COUNTRY`),
KEY `IDX_CODE_COUNTRY` (`CODE_COUNTRY`),
KEY `IDX_CODE_BIOGEOREGION` (`CODE_BIOGEOREGION`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_country_sites_factsheet`
--
DROP TABLE IF EXISTS `chm62edt_country_sites_factsheet`;
CREATE TABLE `chm62edt_country_sites_factsheet` (
`SOURCE_DB` varchar(50) NOT NULL default '',
`AREA_NAME_EN` varchar(254) NOT NULL default '',
`NUMBER_OF_SITES` varchar(255) default NULL,
`NUMBER_OF_SPECIES` varchar(255) default '0',
`NUMBER_OF_HABITATS` varchar(255) default '0',
`NO_SITES_PER_SQUARE_KM` varchar(255) default NULL,
`PROCENT_NO_SITES_WITH_SURFACE_AVAILABLE` varchar(255) default NULL,
`TOTAL_SIZE` varchar(255) default NULL,
`AVG_SIZE` varchar(255) default NULL,
`NO_OF_PRIORITY_SITES` varchar(255) default NULL,
`TOTAL_SIZE_FOR_PRIORITY_SITES` varchar(255) default NULL,
`STANDARD_DEVIATION` varchar(255) default NULL,
PRIMARY KEY (`SOURCE_DB`,`AREA_NAME_EN`),
KEY `IDX_SOURCE_DB` (`SOURCE_DB`),
KEY `IDX_AREA_NAME_EN` (`AREA_NAME_EN`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_cover`
--
DROP TABLE IF EXISTS `chm62edt_cover`;
CREATE TABLE `chm62edt_cover` (
`ID_COVER` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_COVER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_depth`
--
DROP TABLE IF EXISTS `chm62edt_depth`;
CREATE TABLE `chm62edt_depth` (
`ID_DEPTH` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_DEPTH`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_designations`
--
DROP TABLE IF EXISTS `chm62edt_designations`;
CREATE TABLE `chm62edt_designations` (
`ID_DESIGNATION` varchar(16) NOT NULL default '0',
`ID_GEOSCOPE` int(11) NOT NULL default '0',
`ID_DC` int(11) default NULL,
`DESCRIPTION` varchar(255) NOT NULL default '',
`DESCRIPTION_EN` varchar(255) default NULL,
`DESCRIPTION_FR` varchar(255) default NULL,
`ORIGINAL_DATASOURCE` varchar(255) default NULL,
`CDDA_SITES` char(1) default 'N',
`TOTAL_AREA` varchar(50) default NULL,
`REFERENCE_AREA` varchar(50) default NULL,
`NATIONAL_LAW` text,
`NATIONAL_CATEGORY` varchar(8) default NULL,
`NATIONAL_LAW_REFERENCE` text,
`NATIONAL_LAW_AGENCY` text,
`DATA_SOURCE` varchar(255) default NULL,
`TOTAL_NUMBER` int(11) default '0',
`REFERENCE_NUMBER` varchar(50) default NULL,
`REFERENCE_DATE` varchar(16) default NULL,
`REMARK` text,
`REMARK_SOURCE` varchar(255) default NULL,
PRIMARY KEY (`ID_DESIGNATION`,`ID_GEOSCOPE`),
KEY `IDX_ID_DESIGNATION` (`ID_DESIGNATION`),
KEY `IDX_ID_GEOSCOPE` (`ID_GEOSCOPE`),
KEY `IDX_NATIONAL_CATEGORY` (`NATIONAL_CATEGORY`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_DESCRIPTION` (`DESCRIPTION`),
KEY `IDX_DESCRIPTION_EN` (`DESCRIPTION_EN`),
KEY `IDX_DESCRIPTION_FR` (`DESCRIPTION_FR`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_distribution_status`
--
DROP TABLE IF EXISTS `chm62edt_distribution_status`;
CREATE TABLE `chm62edt_distribution_status` (
`ID_DISTRIBUTION_STATUS` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
`ID_DC` int(11) NOT NULL default '-1',
PRIMARY KEY (`ID_DISTRIBUTION_STATUS`),
KEY `IDX_ID_DC` (`ID_DC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_exposure`
--
DROP TABLE IF EXISTS `chm62edt_exposure`;
CREATE TABLE `chm62edt_exposure` (
`ID_EXPOSURE` int(11) NOT NULL default '0',
`NAME` varchar(128) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_EXPOSURE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_faithfulness`
--
DROP TABLE IF EXISTS `chm62edt_faithfulness`;
CREATE TABLE `chm62edt_faithfulness` (
`ID_FAITHFULNESS` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(100) default NULL,
PRIMARY KEY (`ID_FAITHFULNESS`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_frequencies`
--
DROP TABLE IF EXISTS `chm62edt_frequencies`;
CREATE TABLE `chm62edt_frequencies` (
`ID_FREQUENCIES` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_FREQUENCIES`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_geomorph`
--
DROP TABLE IF EXISTS `chm62edt_geomorph`;
CREATE TABLE `chm62edt_geomorph` (
`ID_GEOMORPH` int(11) NOT NULL default '0',
`NAME` varchar(64) NOT NULL default '',
`DESCRIPTION` text,
`OLD_CODE` varchar(16) default NULL,
PRIMARY KEY (`ID_GEOMORPH`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_geoscope`
--
DROP TABLE IF EXISTS `chm62edt_geoscope`;
CREATE TABLE `chm62edt_geoscope` (
`ID_GEOSCOPE` int(11) NOT NULL default '0',
`ID_GEOSCOPE_PARENT` int(11) NOT NULL default '-1',
`ID_DC` int(11) default '-1',
`AREA_TYPE` varchar(10) NOT NULL default '',
PRIMARY KEY (`ID_GEOSCOPE`,`ID_GEOSCOPE_PARENT`),
KEY `IDX_ID_GEOSCOPE` (`ID_GEOSCOPE`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_ID_GEOSCOPE_PARENT_GEOSCOPE` (`ID_GEOSCOPE_PARENT`,`ID_GEOSCOPE`),
KEY `IDX_ID_GEOSCOPE_PARENT` (`ID_GEOSCOPE_PARENT`),
KEY `IDX_AREA_TYPE` (`AREA_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_global`
--
DROP TABLE IF EXISTS `chm62edt_global`;
CREATE TABLE `chm62edt_global` (
`ID_GLOBAL` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_GLOBAL`),
UNIQUE KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_glossary`
--
DROP TABLE IF EXISTS `chm62edt_glossary`;
CREATE TABLE `chm62edt_glossary` (
`TERM` varchar(64) NOT NULL default '',
`ID_LANGUAGE` int(11) NOT NULL default '25',
`SOURCE` varchar(255) NOT NULL default '',
`DEFINITION` text NOT NULL,
`LINK_DESCRIPTION` varchar(255) default NULL,
`LINK_URL` varchar(255) default NULL,
`REFERENCE` varchar(255) default NULL,
`DATE_CHANGED` varchar(100) default NULL,
`CURRENT` tinyint(4) default NULL,
`ID_DC` int(11) default NULL,
`TERM_DOMAIN` varchar(255) default NULL,
`SEARCH_DOMAIN` varchar(255) default NULL,
PRIMARY KEY (`TERM`,`ID_LANGUAGE`,`SOURCE`),
KEY `IDX_TERM` (`TERM`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_DEFINITION` (`DEFINITION`(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_grid`
--
DROP TABLE IF EXISTS `chm62edt_grid`;
CREATE TABLE `chm62edt_grid` (
`NAME` char(16) NOT NULL default '',
`LATITUDE` char(32) NOT NULL default '',
`LONGITUDE` char(32) NOT NULL default '',
`ID_DC` int(11) NOT NULL default '-1',
`PROSPECT` int(11) default NULL,
PRIMARY KEY (`NAME`,`LATITUDE`,`LONGITUDE`,`ID_DC`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_group_species`
--
DROP TABLE IF EXISTS `chm62edt_group_species`;
CREATE TABLE `chm62edt_group_species` (
`ID_GROUP_SPECIES` int(11) NOT NULL default '0',
`COMMON_NAME` varchar(50) NOT NULL default '',
`SCIENTIFIC_NAME` varchar(50) NOT NULL default '',
`SELECTION` int(11) default NULL,
`ID_DC` int(11) default '-1',
PRIMARY KEY (`ID_GROUP_SPECIES`),
KEY `IDX_SCIENTIFIC_NAME` (`SCIENTIFIC_NAME`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_COMMON_NAME` (`COMMON_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat`
--
DROP TABLE IF EXISTS `chm62edt_habitat`;
CREATE TABLE `chm62edt_habitat` (
`ID_HABITAT` int(16) NOT NULL default '0',
`ID_NATURE_OBJECT` int(11) NOT NULL default '-1',
`SCIENTIFIC_NAME` varchar(255) default NULL,
`DESCRIPTION` text,
`CODE_2000` varchar(4) default NULL,
`CODE_ANNEX1` varchar(25) default NULL,
`PRIORITY` int(11) default NULL,
`EUNIS_HABITAT_CODE` varchar(16) default NULL,
`CLASS_REF` varchar(16) default NULL,
`CODE_PART_2` varchar(64) default NULL,
`LEVEL` int(11) default NULL,
`ORIGINALLY_PUBLISHED_CODE` varchar(25) default NULL,
PRIMARY KEY (`ID_HABITAT`,`ID_NATURE_OBJECT`),
KEY `IDX_SCIENTIFIC_NAME` (`SCIENTIFIC_NAME`),
KEY `IDX_CODE_ANNEX1` (`CODE_ANNEX1`),
KEY `IDX_EUNIS_HABITAT_CODE` (`EUNIS_HABITAT_CODE`),
KEY `IDX_LEVEL` (`LEVEL`),
KEY `IDX_ID_HABITAT` (`ID_HABITAT`),
KEY `IDX_ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
KEY `IDX_ID_NATURE_OBJECT_ID_HABITAT` (`ID_NATURE_OBJECT`,`ID_HABITAT`),
KEY `IDX_DESCRIPTION` (`DESCRIPTION`(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_change`
--
DROP TABLE IF EXISTS `chm62edt_habitat_change`;
CREATE TABLE `chm62edt_habitat_change` (
`ID_HABITAT_CHANGE` int(16) NOT NULL default '-1',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_HABITAT_CHANGE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_class_code`
--
DROP TABLE IF EXISTS `chm62edt_habitat_class_code`;
CREATE TABLE `chm62edt_habitat_class_code` (
`ID_HABITAT` int(16) NOT NULL default '-1',
`ID_CLASS_CODE` int(11) NOT NULL default '-1',
`TITLE` varchar(255) NOT NULL default '',
`RELATION_TYPE` char(1) NOT NULL default '',
`CODE` varchar(30) NOT NULL default '',
PRIMARY KEY (`ID_HABITAT`,`ID_CLASS_CODE`,`TITLE`,`RELATION_TYPE`,`CODE`),
KEY `IDX_ID_HABITAT` (`ID_HABITAT`),
KEY `IDX_ID_CLASS_CODE` (`ID_CLASS_CODE`),
KEY `IDX_CODE` (`CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_description`
--
DROP TABLE IF EXISTS `chm62edt_habitat_description`;
CREATE TABLE `chm62edt_habitat_description` (
`ID_HABITAT` int(16) NOT NULL default '-1',
`ID_LANGUAGE` int(11) NOT NULL default '0',
`DESCRIPTION` text NOT NULL,
`OWNER_TEXT` text,
`ID_DC` int(11) default NULL,
PRIMARY KEY (`ID_HABITAT`,`ID_LANGUAGE`,`DESCRIPTION`(255)),
KEY `IDX_ID_DC` (`ID_DC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_habitat`
--
DROP TABLE IF EXISTS `chm62edt_habitat_habitat`;
CREATE TABLE `chm62edt_habitat_habitat` (
`ID_HABITAT` int(16) NOT NULL default '-1',
`ID_HABITAT_LINK` int(16) NOT NULL default '-1',
`RELATION_TYPE` char(1) NOT NULL default '',
PRIMARY KEY (`ID_HABITAT`,`ID_HABITAT_LINK`,`RELATION_TYPE`),
KEY `IDX_ID_HABITAT_LINK` (`ID_HABITAT`,`ID_HABITAT_LINK`),
KEY `IDX_ID_HABITAT_LINK_ID_HABITAT` (`ID_HABITAT_LINK`,`ID_HABITAT`),
KEY `IDX_ID_HABITAT` (`ID_HABITAT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_international_name`
--
DROP TABLE IF EXISTS `chm62edt_habitat_international_name`;
CREATE TABLE `chm62edt_habitat_international_name` (
`ID_HABITAT` int(11) NOT NULL default '0',
`ID_LANGUAGE` int(11) NOT NULL default '0',
`INTERNATIONAL_NAME` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID_HABITAT`,`ID_LANGUAGE`),
KEY `IDX_ID_HABITAT` (`ID_HABITAT`),
KEY `IDX_ID_LANGUAGE` (`ID_LANGUAGE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_key_navigation`
--
DROP TABLE IF EXISTS `chm62edt_habitat_key_navigation`;
CREATE TABLE `chm62edt_habitat_key_navigation` (
`ID_PAGE` int(11) default NULL,
`PAGE_LEVEL` int(11) default NULL,
`PAGE_NAME` varchar(255) default NULL,
`PAGE_NOTES` text,
`ID_QUESTION` varchar(10) default NULL,
`QUESTION_CODE` varchar(10) default NULL,
`QUESTION_LABEL` varchar(255) default NULL,
`QUESTION_EXPLANATION` text,
`POSSIBLE_ANSWERS` int(11) default NULL,
`ID_ANSWER` int(11) default NULL,
`ANSWER_LABEL` varchar(100) default NULL,
`ID_QUESTION_LINK` varchar(50) default NULL,
`ID_HABITAT_LINK` int(16) default NULL,
`ADDITIONAL_INFO` varchar(100) default NULL,
`PAGE_CODE` varchar(10) default NULL,
KEY `IDX_HABITAT_KEY_NAVIGATION` (`ID_PAGE`,`PAGE_LEVEL`,`PAGE_NAME`,`ID_QUESTION`,`ID_ANSWER`,`ID_QUESTION_LINK`,`ID_HABITAT_LINK`),
KEY `IDX_PAGE_LEVEL` (`PAGE_LEVEL`),
KEY `IDX_PAGE_CODE` (`PAGE_CODE`),
KEY `IDX_QUESTION_CODE` (`QUESTION_CODE`),
KEY `IDX_ID_ANSWER` (`ID_ANSWER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_references`
--
DROP TABLE IF EXISTS `chm62edt_habitat_references`;
CREATE TABLE `chm62edt_habitat_references` (
`ID_HABITAT` int(16) NOT NULL default '-1',
`ID_DC` int(11) NOT NULL default '-1',
`HAVE_SOURCE` int(11) NOT NULL default '0',
`HAVE_OTHER_REFERENCES` int(11) NOT NULL default '0',
PRIMARY KEY (`ID_HABITAT`,`ID_DC`),
KEY `IDX_ID_HABITAT` (`ID_HABITAT`),
KEY `IDX_ID_DC` (`ID_DC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_habitat_syntaxa`
--
DROP TABLE IF EXISTS `chm62edt_habitat_syntaxa`;
CREATE TABLE `chm62edt_habitat_syntaxa` (
`ID_HABITAT` int(16) NOT NULL default '-1',
`ID_SYNTAXA` int(11) NOT NULL default '-1',
`RELATION_TYPE` char(1) default NULL,
`ID_SYNTAXA_SOURCE` char(1) default NULL,
PRIMARY KEY (`ID_HABITAT`,`ID_SYNTAXA`),
KEY `IDX_RELATION_TYPE` (`RELATION_TYPE`),
KEY `IDX_ID_SYNTAXA_SOURCE` (`ID_SYNTAXA_SOURCE`),
KEY `IDX_ID_HABITAT` (`ID_HABITAT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_human_activity`
--
DROP TABLE IF EXISTS `chm62edt_human_activity`;
CREATE TABLE `chm62edt_human_activity` (
`ID_HUMAN_ACTIVITY` int(11) NOT NULL default '0',
`NAME` varchar(128) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_HUMAN_ACTIVITY`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_humidity`
--
DROP TABLE IF EXISTS `chm62edt_humidity`;
CREATE TABLE `chm62edt_humidity` (
`ID_HUMIDITY` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_HUMIDITY`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_impact`
--
DROP TABLE IF EXISTS `chm62edt_impact`;
CREATE TABLE `chm62edt_impact` (
`ID_IMPACT` int(11) NOT NULL default '0',
`NAME` varchar(255) default NULL,
`DESCRIPTION` text,
`NATURA2000_CODE` varchar(16) default NULL,
`NATURA2000_NAME` varchar(255) default NULL,
PRIMARY KEY (`ID_IMPACT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_info_quality`
--
DROP TABLE IF EXISTS `chm62edt_info_quality`;
CREATE TABLE `chm62edt_info_quality` (
`ID_INFO_QUALITY` int(11) NOT NULL default '0',
`STATUS` varchar(50) NOT NULL default '',
`DESCRIPTION` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID_INFO_QUALITY`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_isolation`
--
DROP TABLE IF EXISTS `chm62edt_isolation`;
CREATE TABLE `chm62edt_isolation` (
`ID_ISOLATION` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_ISOLATION`),
UNIQUE KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_language`
--
DROP TABLE IF EXISTS `chm62edt_language`;
CREATE TABLE `chm62edt_language` (
`ID_LANGUAGE` int(11) NOT NULL default '0',
`CODE` varchar(2) NOT NULL default '',
`NAME_EN` varchar(255) NOT NULL default '',
`SELECTION` int(11) default NULL,
`NAME_FR` varchar(255) default NULL,
`NAME_DE` varchar(255) default NULL,
`FAMILY` varchar(255) default NULL,
`COMMENT` varchar(255) default NULL,
PRIMARY KEY (`ID_LANGUAGE`),
KEY `IDX_CODE` (`CODE`),
FULLTEXT KEY `IDX_NAME_EN` (`NAME_EN`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_legal_area_event`
--
DROP TABLE IF EXISTS `chm62edt_legal_area_event`;
CREATE TABLE `chm62edt_legal_area_event` (
`ID_LEGAL_AREA_EVENT` int(11) NOT NULL default '0',
`NAME` varchar(128) NOT NULL default '',
`DESCRIPTION` text,
PRIMARY KEY (`ID_LEGAL_AREA_EVENT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_legal_status`
--
DROP TABLE IF EXISTS `chm62edt_legal_status`;
CREATE TABLE `chm62edt_legal_status` (
`ID_LEGAL_STATUS` int(11) NOT NULL default '0',
`ANNEX` varchar(50) NOT NULL default '',
`PRIORITY` int(11) default NULL,
`COMMENT` text,
`CODE` varchar(8) default NULL,
PRIMARY KEY (`ID_LEGAL_STATUS`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_life_form`
--
DROP TABLE IF EXISTS `chm62edt_life_form`;
CREATE TABLE `chm62edt_life_form` (
`ID_LIFE_FORM` int(11) NOT NULL default '0',
`NAME` varchar(128) default NULL,
`DESCRIPTION` text,
`DATE_ADDED` date default NULL,
PRIMARY KEY (`ID_LIFE_FORM`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_light_intensity`
--
DROP TABLE IF EXISTS `chm62edt_light_intensity`;
CREATE TABLE `chm62edt_light_intensity` (
`ID_LIGHT_INTENSITY` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_LIGHT_INTENSITY`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_motivation`
--
DROP TABLE IF EXISTS `chm62edt_motivation`;
CREATE TABLE `chm62edt_motivation` (
`ID_MOTIVATION` int(11) NOT NULL default '0',
`NAME` varchar(128) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_MOTIVATION`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_natura2000_activity_code`
--
DROP TABLE IF EXISTS `chm62edt_natura2000_activity_code`;
CREATE TABLE `chm62edt_natura2000_activity_code` (
`ID_ACTIVITY_CODE` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_ACTIVITY_CODE`),
FULLTEXT KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_natura2000_conservation_code`
--
DROP TABLE IF EXISTS `chm62edt_natura2000_conservation_code`;
CREATE TABLE `chm62edt_natura2000_conservation_code` (
`ID_CONSERVATION_CODE` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_CONSERVATION_CODE`),
FULLTEXT KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_natura2000_motivation_code`
--
DROP TABLE IF EXISTS `chm62edt_natura2000_motivation_code`;
CREATE TABLE `chm62edt_natura2000_motivation_code` (
`ID_MOTIVATION_CODE` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_MOTIVATION_CODE`),
FULLTEXT KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_natura2000_site_type`
--
DROP TABLE IF EXISTS `chm62edt_natura2000_site_type`;
CREATE TABLE `chm62edt_natura2000_site_type` (
`ID_SITE_TYPE` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_SITE_TYPE`),
FULLTEXT KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_nature_object`
--
DROP TABLE IF EXISTS `chm62edt_nature_object`;
CREATE TABLE `chm62edt_nature_object` (
`ID_NATURE_OBJECT` int(11) NOT NULL default '0',
`ID_DC` int(11) NOT NULL default '-1',
`ORIGINAL_CODE` varchar(16) default NULL,
`TYPE` varchar(32) NOT NULL default '',
PRIMARY KEY (`ID_NATURE_OBJECT`),
UNIQUE KEY `ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
KEY `IDX_TYPE` (`TYPE`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_ORIGINAL_CODE` (`ORIGINAL_CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_nature_object_geoscope`
--
DROP TABLE IF EXISTS `chm62edt_nature_object_geoscope`;
CREATE TABLE `chm62edt_nature_object_geoscope` (
`ID_NATURE_OBJECT` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT_LINK` int(11) NOT NULL default '-1',
`ID_DC` int(11) NOT NULL default '-1',
`ID_GEOSCOPE` int(11) NOT NULL default '-1',
`ID_REPORT_ATTRIBUTES` int(11) NOT NULL default '-1',
PRIMARY KEY (`ID_NATURE_OBJECT`,`ID_NATURE_OBJECT_LINK`,`ID_DC`,`ID_GEOSCOPE`,`ID_REPORT_ATTRIBUTES`),
KEY `IDX_ID_NATURE_OBJECT_LINK` (`ID_NATURE_OBJECT_LINK`),
KEY `IDX_ID_GEOSCOPE` (`ID_GEOSCOPE`),
KEY `IDX_ID_REPORT_ATTRIBUTES` (`ID_REPORT_ATTRIBUTES`),
KEY `IDX_ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_ID_NATURE_OBJECT_LINK_NATUR` (`ID_NATURE_OBJECT_LINK`,`ID_NATURE_OBJECT`),
KEY `IDX_ID_NATURE_OBJECT_GEOSCOPE` (`ID_NATURE_OBJECT`,`ID_GEOSCOPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_nature_object_report_type`
--
DROP TABLE IF EXISTS `chm62edt_nature_object_report_type`;
CREATE TABLE `chm62edt_nature_object_report_type` (
`ID_NATURE_OBJECT` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT_LINK` int(11) NOT NULL default '-1',
`ID_GEOSCOPE` int(11) default NULL,
`ID_REPORT_TYPE` int(11) NOT NULL default '-1',
`ID_REPORT_ATTRIBUTES` int(11) NOT NULL default '-1',
`ID_DC` int(11) NOT NULL default '-1',
PRIMARY KEY (`ID_NATURE_OBJECT`,`ID_NATURE_OBJECT_LINK`,`ID_REPORT_TYPE`,`ID_REPORT_ATTRIBUTES`),
KEY `IDX_ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
KEY `IDX_ID_NATURE_OBJECT_LINK` (`ID_NATURE_OBJECT_LINK`),
KEY `IDX_ID_REPORT_ATTRIBUTES` (`ID_REPORT_ATTRIBUTES`),
KEY `IDX_ID_REPORT_TYPE` (`ID_REPORT_TYPE`),
KEY `IDX_ID_GEOSCOPE` (`ID_GEOSCOPE`),
KEY `IDX_ID_NATURE_OBJECT_LINK_NATUR` (`ID_NATURE_OBJECT_LINK`,`ID_NATURE_OBJECT`),
KEY `IDX_ID_NATURE_OBJECT_NATURE_LIN` (`ID_NATURE_OBJECT`,`ID_NATURE_OBJECT_LINK`),
KEY `IDX_ID_DC` (`ID_DC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_population`
--
DROP TABLE IF EXISTS `chm62edt_population`;
CREATE TABLE `chm62edt_population` (
`ID_POPULATION` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_POPULATION`),
UNIQUE KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_population_unit`
--
DROP TABLE IF EXISTS `chm62edt_population_unit`;
CREATE TABLE `chm62edt_population_unit` (
`ID_POPULATION_UNIT` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_POPULATION_UNIT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_region_codes`
--
DROP TABLE IF EXISTS `chm62edt_region_codes`;
CREATE TABLE `chm62edt_region_codes` (
`ID_REGION_CODE` varchar(16) NOT NULL default '0',
`NAME` varchar(255) NOT NULL default '',
`DESCRIPTION` text,
PRIMARY KEY (`ID_REGION_CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_relative_surface`
--
DROP TABLE IF EXISTS `chm62edt_relative_surface`;
CREATE TABLE `chm62edt_relative_surface` (
`ID_RELATIVE_SURFACE` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_RELATIVE_SURFACE`),
UNIQUE KEY `IDX_ID_RELATIVE_SURFACE` (`ID_RELATIVE_SURFACE`),
UNIQUE KEY `NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_report_attributes`
--
DROP TABLE IF EXISTS `chm62edt_report_attributes`;
CREATE TABLE `chm62edt_report_attributes` (
`ID_REPORT_ATTRIBUTES` int(11) NOT NULL default '0',
`NAME` varchar(64) NOT NULL default '',
`TYPE` varchar(16) default NULL,
`VALUE` text,
PRIMARY KEY (`ID_REPORT_ATTRIBUTES`,`NAME`),
KEY `IDX_ID_REPORT_ATTRIBUTES` (`ID_REPORT_ATTRIBUTES`),
KEY `IDX_NAME` (`NAME`),
KEY `IDX_ID_REPORT_ATTRIBUTES_NAME` (`ID_REPORT_ATTRIBUTES`,`NAME`),
KEY `IDX_NAME_ATTRIBUTES` (`NAME`,`ID_REPORT_ATTRIBUTES`),
KEY `IDX_VALUE` (`VALUE`(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_report_type`
--
DROP TABLE IF EXISTS `chm62edt_report_type`;
CREATE TABLE `chm62edt_report_type` (
`ID_REPORT_TYPE` int(11) NOT NULL default '0',
`ID_LOOKUP` varchar(50) NOT NULL default '-1',
`LOOKUP_TYPE` varchar(32) NOT NULL default '',
PRIMARY KEY (`ID_REPORT_TYPE`,`ID_LOOKUP`,`LOOKUP_TYPE`),
KEY `IDX_ID_REPORT_TYPE` (`ID_REPORT_TYPE`),
KEY `IDX_LOOKUP_TYPE` (`LOOKUP_TYPE`),
KEY `IDX_ID_LOOKUP` (`ID_LOOKUP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_reports`
--
DROP TABLE IF EXISTS `chm62edt_reports`;
CREATE TABLE `chm62edt_reports` (
`ID_NATURE_OBJECT` int(11) NOT NULL default '-1',
`ID_DC` int(11) NOT NULL default '-1',
`ID_GEOSCOPE` int(11) NOT NULL default '-1',
`ID_GEOSCOPE_LINK` int(11) NOT NULL default '-1',
`ID_REPORT_TYPE` int(11) NOT NULL default '-1',
`ID_REPORT_ATTRIBUTES` int(11) NOT NULL default '-1',
PRIMARY KEY (`ID_NATURE_OBJECT`,`ID_DC`,`ID_GEOSCOPE`,`ID_GEOSCOPE_LINK`,`ID_REPORT_TYPE`,`ID_REPORT_ATTRIBUTES`),
KEY `IDX_ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
KEY `IDX_ID_GEOSCOPE` (`ID_GEOSCOPE`),
KEY `IDX_ID_GEOSCOPE_LINK` (`ID_GEOSCOPE_LINK`),
KEY `IDX_ID_REPORT_ATTRIBUTES` (`ID_REPORT_ATTRIBUTES`),
KEY `IDX_ID_REPORT_TYPE` (`ID_REPORT_TYPE`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_ID_NATURE_OBJECT_TYPE` (`ID_NATURE_OBJECT`,`ID_REPORT_TYPE`),
KEY `IDX_ID_REPORT_TYPE_NATURE_OBJEC` (`ID_REPORT_TYPE`,`ID_NATURE_OBJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_representativity`
--
DROP TABLE IF EXISTS `chm62edt_representativity`;
CREATE TABLE `chm62edt_representativity` (
`ID_REPRESENTATIVITY` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_REPRESENTATIVITY`),
UNIQUE KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_representativity_code`
--
DROP TABLE IF EXISTS `chm62edt_representativity_code`;
CREATE TABLE `chm62edt_representativity_code` (
`ID_REPRESENTATIVITY` varchar(8) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`ID_REPRESENTATIVITY`),
UNIQUE KEY `IDX_NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_salinity`
--
DROP TABLE IF EXISTS `chm62edt_salinity`;
CREATE TABLE `chm62edt_salinity` (
`ID_SALINITY` int(11) NOT NULL default '0',
`NAME` varchar(128) NOT NULL default '',
`DESCRIPTION` text,
`OLD_CODE` varchar(16) default NULL,
`USED` int(11) default NULL,
PRIMARY KEY (`ID_SALINITY`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_site_attributes`
--
DROP TABLE IF EXISTS `chm62edt_site_attributes`;
CREATE TABLE `chm62edt_site_attributes` (
`ID_SITE` varchar(16) NOT NULL default '',
`NAME` varchar(128) NOT NULL default '',
`TYPE` varchar(16) NOT NULL default '',
`VALUE` longtext NOT NULL,
`SOURCE_TABLE` varchar(32) default NULL,
`SOURCE_DB` varchar(32) NOT NULL default '',
PRIMARY KEY (`ID_SITE`,`NAME`,`SOURCE_DB`),
KEY `IDX_ID_SITE` (`ID_SITE`),
KEY `IDX_TYPE` (`TYPE`),
KEY `IDX_NAME` (`NAME`),
KEY `IDX_ID_SITE_NAME` (`ID_SITE`,`NAME`),
KEY `IDX_SOURCE_TABLE` (`SOURCE_TABLE`),
KEY `IDX_SOURCE_DB` (`SOURCE_DB`),
KEY `IDX_VALUE` (`VALUE`(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_sites`
--
DROP TABLE IF EXISTS `chm62edt_sites`;
CREATE TABLE `chm62edt_sites` (
`ID_SITE` varchar(16) NOT NULL default '0',
`ID_NATURE_OBJECT` int(11) NOT NULL default '-1',
`ID_DESIGNATION` varchar(16) default NULL,
`ID_GEOSCOPE` int(11) default NULL,
`RESPONDENT` text,
`NAME` varchar(255) NOT NULL default '',
`MANAGER` text,
`COMPLEX_NAME` text,
`DISTRICT_NAME` text,
`OWNERSHIP` text,
`HISTORY` text,
`CHARACTER` text,
`DESCRIPTION` text,
`MANAGEMENT_PLAN` text,
`IUCNAT` text,
`DESIGNATION_DATE` varchar(50) default NULL,
`COMPILATION_DATE` varchar(50) default NULL,
`PROPOSED_DATE` varchar(50) default NULL,
`CONFIRMED_DATE` varchar(50) default NULL,
`UPDATE_DATE` varchar(50) default NULL,
`SPA_DATE` varchar(50) default NULL,
`SAC_DATE` varchar(50) default NULL,
`NATIONAL_CODE` text,
`NATURA_2000` text,
`NUTS` varchar(50) default NULL,
`AREA` decimal(18,9) default NULL,
`LENGTH` decimal(18,9) default NULL,
`LONG_EW` char(1) default NULL,
`LONG_DEG` int(11) default NULL,
`LONG_MIN` int(11) default NULL,
`LONG_SEC` int(11) default NULL,
`LAT_NS` char(1) default NULL,
`LAT_DEG` int(11) default NULL,
`LAT_MIN` int(11) default NULL,
`LAT_SEC` int(11) default NULL,
`ALT_MEAN` int(11) default NULL,
`ALT_MAX` int(11) default NULL,
`ALT_MIN` int(11) default NULL,
`LONGITUDE` decimal(18,9) default NULL,
`LATITUDE` decimal(18,9) default NULL,
`CATEGORY` varchar(8) default NULL,
`SOURCE_DB` varchar(32) NOT NULL default '',
PRIMARY KEY (`ID_SITE`,`ID_NATURE_OBJECT`),
UNIQUE KEY `IDX_ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
KEY `IDX_NAME` (`NAME`),
KEY `IDX_ALT_MIN` (`ALT_MIN`),
KEY `IDX_ALT_MAX` (`ALT_MAX`),
KEY `IDX_ALT_MEAN` (`ALT_MEAN`),
KEY `IDX_LATITUDE` (`LATITUDE`),
KEY `IDX_LONGITUDE` (`LONGITUDE`),
KEY `IDX_AREA` (`AREA`),
KEY `IDX_LENGTH` (`LENGTH`),
KEY `IDX_LONG_DEG` (`LONG_DEG`),
KEY `IDX_LONG_MIN` (`LONG_MIN`),
KEY `IDX_LONG_SEC` (`LONG_SEC`),
KEY `IDX_LAT_DEG` (`LAT_DEG`),
KEY `IDX_LAT_MIN` (`LAT_MIN`),
KEY `IDX_LAT_SEC` (`LAT_SEC`),
KEY `IDX_LAT_NS` (`LAT_NS`),
KEY `IDX_LONG_EW` (`LONG_EW`),
KEY `IDX_ID_SITE` (`ID_SITE`),
KEY `IDX_ID_NATURE_OBJECT_ID_SITE` (`ID_NATURE_OBJECT`,`ID_SITE`),
KEY `IDX_DESIGNATION_DATE` (`DESIGNATION_DATE`),
KEY `IDX_SOURCE_DB` (`SOURCE_DB`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_sites_related_designations`
--
DROP TABLE IF EXISTS `chm62edt_sites_related_designations`;
CREATE TABLE `chm62edt_sites_related_designations` (
`ID_SITE` varchar(16) NOT NULL default '',
`ID_DESIGNATION` varchar(16) NOT NULL default '',
`ID_GEOSCOPE` int(11) NOT NULL default '0',
`SEQUENCE` smallint(6) NOT NULL default '0',
`OVERLAP_TYPE` varchar(16) default NULL,
`OVERLAP` varchar(50) default NULL,
`DESIGNATED_SITE` varchar(255) default NULL,
`DESIGNATION_DATE` varchar(16) default NULL,
`SOURCE_DB` varchar(32) NOT NULL default '',
`SOURCE_TABLE` varchar(16) default NULL,
PRIMARY KEY (`ID_SITE`,`ID_DESIGNATION`,`SEQUENCE`,`ID_GEOSCOPE`,`SOURCE_DB`),
KEY `IDX_ID_DESIGNATION` (`ID_DESIGNATION`),
KEY `IDX_ID_SITE` (`ID_SITE`),
KEY `IDX_ISO_3L` (`ID_GEOSCOPE`),
KEY `IDX_SOURCE_DB` (`SOURCE_DB`),
KEY `IDX_SEQUENCE` (`SEQUENCE`),
KEY `IDX_ID_DESIGNATION_ID_SITE` (`ID_DESIGNATION`,`ID_SITE`),
KEY `IDX_SOURCE_TABLE` (`SOURCE_TABLE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_sites_sites`
--
DROP TABLE IF EXISTS `chm62edt_sites_sites`;
CREATE TABLE `chm62edt_sites_sites` (
`ID_SITE` varchar(16) NOT NULL default '',
`ID_SITE_LINK` varchar(16) NOT NULL default '',
`SEQUENCE` int(11) NOT NULL default '0',
`RELATION_TYPE` varchar(32) default NULL,
`OVERLAP` varchar(8) default '',
`WITHIN_PROJECT` int(11) default NULL,
`SOURCE_TABLE` varchar(16) default NULL,
PRIMARY KEY (`ID_SITE`,`ID_SITE_LINK`,`SEQUENCE`),
KEY `IDX_ID_SITE_ID_SITE_LINK` (`ID_SITE`,`ID_SITE_LINK`),
KEY `IDX_ID_SITE_LINK_ID_SITE` (`ID_SITE_LINK`,`ID_SITE`),
KEY `IDX_ID_SITE` (`ID_SITE`),
KEY `IDX_SOURCE_TABLE` (`SOURCE_TABLE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_soundex`
--
DROP TABLE IF EXISTS `chm62edt_soundex`;
CREATE TABLE `chm62edt_soundex` (
`NAME` varchar(32) NOT NULL default '',
`PHONETIC` varchar(16) NOT NULL default '',
`OBJECT_TYPE` varchar(16) NOT NULL default '',
PRIMARY KEY (`NAME`),
UNIQUE KEY `IDX_NAME` (`NAME`),
KEY `IDX_OBJECT_TYPE` (`OBJECT_TYPE`),
KEY `IDX_PHONETIC` (`PHONETIC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_spatial`
--
DROP TABLE IF EXISTS `chm62edt_spatial`;
CREATE TABLE `chm62edt_spatial` (
`ID_SPATIAL` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_SPATIAL`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_species`
--
DROP TABLE IF EXISTS `chm62edt_species`;
CREATE TABLE `chm62edt_species` (
`ID_SPECIES` int(11) NOT NULL default '0',
`ID_NATURE_OBJECT` int(11) NOT NULL default '-1',
`SCIENTIFIC_NAME` varchar(100) NOT NULL default '',
`VALID_NAME` int(11) default NULL,
`ID_SPECIES_LINK` int(11) default NULL,
`TYPE_RELATED_SPECIES` varchar(16) default NULL,
`TEMPORARY_SELECT` int(11) default NULL,
`TAXONOMIC_SPECIES_CODE` varchar(32) NOT NULL default '',
`GENUS` varchar(64) default NULL,
`SPECIES_MAP` varchar(7) default NULL,
`ID_GROUP_SPECIES` int(11) NOT NULL default '0',
`ID_TAXONOMY` varchar(16) default NULL,
`AUTHOR` varchar(255) default NULL,
PRIMARY KEY (`ID_SPECIES`,`ID_NATURE_OBJECT`),
UNIQUE KEY `IDX_ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
UNIQUE KEY `IDX_ID_SPECIES` (`ID_SPECIES`),
KEY `IDX_ID_GROUP_SPECIES` (`ID_GROUP_SPECIES`),
KEY `IDX_ID_SPECIES_LINK` (`ID_SPECIES_LINK`),
KEY `IDX_VALID_NAME` (`VALID_NAME`),
KEY `IDX_ID_TAXONOMY` (`ID_TAXONOMY`),
KEY `IDX_ID_NATURE_OBJECT_ID_SPECIES` (`ID_NATURE_OBJECT`,`ID_SPECIES`),
KEY `IDX_SCIENTIFIC_NAME` (`SCIENTIFIC_NAME`),
KEY `IDX_TYPE_RELATED_SPECIES` (`TYPE_RELATED_SPECIES`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_species_richness`
--
DROP TABLE IF EXISTS `chm62edt_species_richness`;
CREATE TABLE `chm62edt_species_richness` (
`ID_SPECIES_RICHNESS` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_SPECIES_RICHNESS`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_species_statistics_module`
--
DROP TABLE IF EXISTS `chm62edt_species_statistics_module`;
CREATE TABLE `chm62edt_species_statistics_module` (
`AREA_NAME_EN` varchar(255) NOT NULL default '',
`NUMBER_OF_DISTINCT_SPECIES` varchar(255) default NULL,
`NUMBER_OF_SPECIES_NAMES` varchar(255) default '0',
`NUMBER_OF_VERNACULAR_NAMES` varchar(255) default '0',
`NUMBER_OF_LANGUAGES` varchar(255) default NULL,
`NUMBER_OF_LEGAL_STATUS` varchar(255) default NULL,
`NUMBER_OF_LEGAL_INSTRUMENTS` varchar(255) default NULL,
`NUMBER_OF_INTERN_CONS_STATUS` varchar(255) default NULL,
`NUMBER_OF_NATIONAL_CONS_STATUS` varchar(255) default NULL,
`NUMBER_OF_COUNTRIES_FOR_CONS_STATUS` varchar(255) default NULL,
`NUMBER_OF_GEOGRAPHICAL_DIST` varchar(255) default NULL,
`NUMBER_OF_GRID_DISTR` varchar(255) default NULL,
PRIMARY KEY (`AREA_NAME_EN`),
KEY `IDX_AREA_NAME_EN` (`AREA_NAME_EN`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_species_status`
--
DROP TABLE IF EXISTS `chm62edt_species_status`;
CREATE TABLE `chm62edt_species_status` (
`ID_SPECIES_STATUS` int(11) NOT NULL default '0',
`DESCRIPTION` varchar(255) NOT NULL default '',
`SHORT_DEFINITION` varchar(255) default NULL,
`STATUS_CODE` varchar(3) default NULL,
PRIMARY KEY (`ID_SPECIES_STATUS`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_substrate`
--
DROP TABLE IF EXISTS `chm62edt_substrate`;
CREATE TABLE `chm62edt_substrate` (
`ID_SUBSTRATE` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_SUBSTRATE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_syntaxa`
--
DROP TABLE IF EXISTS `chm62edt_syntaxa`;
CREATE TABLE `chm62edt_syntaxa` (
`ID_SYNTAXA` int(11) NOT NULL default '0',
`CODE` varchar(8) NOT NULL default '',
`NAME` varchar(255) NOT NULL default '',
`AUTHOR` varchar(100) default NULL,
`SYNTAXON` int(11) default NULL,
PRIMARY KEY (`ID_SYNTAXA`),
KEY `IDX_CODE` (`CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_syntaxa_source`
--
DROP TABLE IF EXISTS `chm62edt_syntaxa_source`;
CREATE TABLE `chm62edt_syntaxa_source` (
`ID_SYNTAXA_SOURCE` char(1) NOT NULL default '',
`SOURCE` varchar(255) default NULL,
`SOURCE_ABBREV` varchar(50) default NULL,
`ID_DC` int(11) NOT NULL default '-1',
PRIMARY KEY (`ID_SYNTAXA_SOURCE`),
KEY `IDX_ID_DC` (`ID_DC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_tab_page_habitats`
--
DROP TABLE IF EXISTS `chm62edt_tab_page_habitats`;
CREATE TABLE `chm62edt_tab_page_habitats` (
`ID_NATURE_OBJECT` int(11) NOT NULL default '0',
`GENERAL_INFORMATION` char(1) NOT NULL default 'Y',
`GEOGRAPHICAL_DISTRIBUTION` char(1) NOT NULL default 'N',
`LEGAL_INSTRUMENTS` char(1) NOT NULL default 'N',
`SPECIES` char(1) NOT NULL default 'N',
`HABITATS` char(1) NOT NULL default 'N',
`SITES` char(1) NOT NULL default 'N',
`OTHER` char(1) NOT NULL default 'N',
PRIMARY KEY (`ID_NATURE_OBJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_tab_page_sites`
--
DROP TABLE IF EXISTS `chm62edt_tab_page_sites`;
CREATE TABLE `chm62edt_tab_page_sites` (
`ID_NATURE_OBJECT` int(11) NOT NULL default '0',
`GENERAL_INFORMATION` char(1) NOT NULL default 'Y',
`FAUNA_FLORA` char(1) NOT NULL default 'N',
`DESIGNATION` char(1) NOT NULL default 'N',
`HABITATS` char(1) NOT NULL default 'N',
`SITES` char(1) NOT NULL default 'N',
`OTHER` char(1) NOT NULL default 'N',
PRIMARY KEY (`ID_NATURE_OBJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_tab_page_species`
--
DROP TABLE IF EXISTS `chm62edt_tab_page_species`;
CREATE TABLE `chm62edt_tab_page_species` (
`ID_NATURE_OBJECT` int(11) NOT NULL default '0',
`GENERAL_INFORMATION` char(1) NOT NULL default 'Y',
`VERNACULAR_NAMES` char(1) NOT NULL default 'N',
`GEOGRAPHICAL_DISTRIBUTION` char(1) NOT NULL default 'N',
`POPULATION` char(1) NOT NULL default 'N',
`TRENDS` char(1) NOT NULL default 'N',
`REFERENCES` char(1) NOT NULL default 'Y',
`GRID_DISTRIBUTION` char(1) NOT NULL default 'N',
`THREAT_STATUS` char(1) NOT NULL default 'N',
`LEGAL_INSTRUMENTS` char(1) NOT NULL default 'N',
`HABITATS` char(1) NOT NULL default 'N',
`SITES` char(1) NOT NULL default 'N',
PRIMARY KEY (`ID_NATURE_OBJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_taxonomy`
--
DROP TABLE IF EXISTS `chm62edt_taxonomy`;
CREATE TABLE `chm62edt_taxonomy` (
`ID_TAXONOMY` varchar(16) NOT NULL default '',
`LEVEL` varchar(8) default NULL,
`NAME` varchar(45) default NULL,
`GROUP` varchar(8) default NULL,
`ID_TAXONOMY_LINK` varchar(16) default NULL,
`ID_TAXONOMY_PARENT` varchar(16) default NULL,
`ID_DC` int(11) default NULL,
`NOTES` varchar(255) default NULL,
`TAXONOMY_TREE` text,
PRIMARY KEY (`ID_TAXONOMY`),
KEY `IDX_GROUP` (`GROUP`),
KEY `IDX_NAME` (`NAME`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_ID_TAXONOMY_LINK` (`ID_TAXONOMY_LINK`),
KEY `IDX_LEVEL` (`LEVEL`),
KEY `ID_TAXONOMY_PARENT` (`ID_TAXONOMY_PARENT`),
KEY `TAXONOMY_TREE` (`TAXONOMY_TREE`(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_temperature`
--
DROP TABLE IF EXISTS `chm62edt_temperature`;
CREATE TABLE `chm62edt_temperature` (
`ID_TEMPERATURE` int(11) NOT NULL default '0',
`NAME` varchar(128) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_TEMPERATURE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_temporal`
--
DROP TABLE IF EXISTS `chm62edt_temporal`;
CREATE TABLE `chm62edt_temporal` (
`ID_TEMPORAL` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
`USED` int(11) default NULL,
PRIMARY KEY (`ID_TEMPORAL`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_trend`
--
DROP TABLE IF EXISTS `chm62edt_trend`;
CREATE TABLE `chm62edt_trend` (
`ID_TREND` int(11) NOT NULL default '0',
`STATUS` varchar(50) NOT NULL default '',
`DESCRIPTION` text,
PRIMARY KEY (`ID_TREND`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_usage`
--
DROP TABLE IF EXISTS `chm62edt_usage`;
CREATE TABLE `chm62edt_usage` (
`ID_USAGE` int(11) NOT NULL default '0',
`NAME` varchar(64) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_USAGE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `chm62edt_water`
--
DROP TABLE IF EXISTS `chm62edt_water`;
CREATE TABLE `chm62edt_water` (
`ID_WATER` int(11) NOT NULL default '0',
`NAME` varchar(128) default NULL,
`DESCRIPTION` text,
PRIMARY KEY (`ID_WATER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_contributor`
--
DROP TABLE IF EXISTS `dc_contributor`;
CREATE TABLE `dc_contributor` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_CONTRIBUTOR` int(11) NOT NULL default '0',
`CONTRIBUTOR` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_CONTRIBUTOR`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_coverage`
--
DROP TABLE IF EXISTS `dc_coverage`;
CREATE TABLE `dc_coverage` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_COVERAGE` int(11) NOT NULL default '0',
`COVERAGE` varchar(255) NOT NULL default '',
`SPATIAL` varchar(255) default NULL,
`TEMPORAL` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_COVERAGE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_creator`
--
DROP TABLE IF EXISTS `dc_creator`;
CREATE TABLE `dc_creator` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_CREATOR` int(11) NOT NULL default '0',
`CREATOR` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_CREATOR`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_CREATOR` (`CREATOR`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_date`
--
DROP TABLE IF EXISTS `dc_date`;
CREATE TABLE `dc_date` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_DATE` int(11) NOT NULL default '0',
`MDATE` date default NULL,
`CREATED` year(4) default NULL,
`VALID` date default NULL,
`AVAILABLE` date default NULL,
`ISSUED` date default NULL,
`MODIFIED` date default NULL,
PRIMARY KEY (`ID_DC`,`ID_DATE`),
KEY `IDX_CREATED` (`CREATED`),
KEY `IDX_ID_DC` (`ID_DC`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_description`
--
DROP TABLE IF EXISTS `dc_description`;
CREATE TABLE `dc_description` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_DESCRIPTION` int(11) NOT NULL default '0',
`DESCRIPTION` varchar(255) default NULL,
`TOC` varchar(255) default NULL,
`ABSTRACT` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_DESCRIPTION`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_format`
--
DROP TABLE IF EXISTS `dc_format`;
CREATE TABLE `dc_format` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_FORMAT` int(11) NOT NULL default '0',
`FORMAT` varchar(255) NOT NULL default '',
`EXTENT` varchar(255) default NULL,
`MEDIUM` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_FORMAT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_identifier`
--
DROP TABLE IF EXISTS `dc_identifier`;
CREATE TABLE `dc_identifier` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_IDENTIFIER` int(11) NOT NULL default '0',
`IDENTIFIER` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_IDENTIFIER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_index`
--
DROP TABLE IF EXISTS `dc_index`;
CREATE TABLE `dc_index` (
`ID_DC` int(11) NOT NULL default '0',
`COMMENT` varchar(255) default NULL,
`REFCD` int(11) default NULL,
`REFERENCE` int(11) default NULL,
PRIMARY KEY (`ID_DC`),
UNIQUE KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_REFCD` (`REFCD`),
KEY `IDX_REFERENCE` (`REFERENCE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_language`
--
DROP TABLE IF EXISTS `dc_language`;
CREATE TABLE `dc_language` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_LANGUAGE` int(11) NOT NULL default '0',
`LANGUAGE` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_LANGUAGE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_publisher`
--
DROP TABLE IF EXISTS `dc_publisher`;
CREATE TABLE `dc_publisher` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_PUBLISHER` int(11) NOT NULL default '0',
`PUBLISHER` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_PUBLISHER`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_PUBLISHER` (`PUBLISHER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_relation`
--
DROP TABLE IF EXISTS `dc_relation`;
CREATE TABLE `dc_relation` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_RELATION` int(11) NOT NULL default '0',
`RELATION` varchar(255) NOT NULL default '',
`IS_VERSION_OF` varchar(255) default NULL,
`HAS_VERSION` varchar(255) default NULL,
`IS_REPLACED_BY` varchar(255) default NULL,
`IS_REQUIRED_BY` varchar(255) default NULL,
`REQUIRES` varchar(255) default NULL,
`IS_PART_OF` varchar(255) default NULL,
`HAS_PART` varchar(255) default NULL,
`IS_REFERENCED_BY` varchar(255) default NULL,
`REFERENCES` varchar(255) default NULL,
`IS_FORMAT_OF` varchar(255) default NULL,
`HAS_FORMAT` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_RELATION`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_rights`
--
DROP TABLE IF EXISTS `dc_rights`;
CREATE TABLE `dc_rights` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_RIGHTS` int(11) NOT NULL default '0',
`RIGHTS` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_RIGHTS`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_source`
--
DROP TABLE IF EXISTS `dc_source`;
CREATE TABLE `dc_source` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_SOURCE` int(11) NOT NULL default '0',
`SOURCE` text,
`EDITOR` varchar(255) default NULL,
`JOURNAL_TITLE` varchar(255) default NULL,
`BOOK_TITLE` varchar(255) default NULL,
`JOURNAL_ISSUE` varchar(50) default NULL,
`ISBN` varchar(20) default NULL,
`GEO_LEVEL` varchar(50) default NULL,
`URL` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_SOURCE`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_EDITOR` (`EDITOR`),
KEY `IDX_JOURNAL_TITLE` (`JOURNAL_TITLE`),
KEY `IDX_BOOK_TITLE` (`BOOK_TITLE`),
KEY `IDX_ID_SOURCE` (`ID_SOURCE`),
KEY `IDX_SOURCE` (`SOURCE`(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_subject`
--
DROP TABLE IF EXISTS `dc_subject`;
CREATE TABLE `dc_subject` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_SUBJECT` int(11) NOT NULL default '0',
`SUBJECT` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_SUBJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_title`
--
DROP TABLE IF EXISTS `dc_title`;
CREATE TABLE `dc_title` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_TITLE` int(11) NOT NULL default '0',
`TITLE` varchar(255) default NULL,
`ALTERNATIVE` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_TITLE`),
KEY `IDX_ID_DC` (`ID_DC`),
KEY `IDX_TITLE` (`TITLE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `dc_type`
--
DROP TABLE IF EXISTS `dc_type`;
CREATE TABLE `dc_type` (
`ID_DC` int(11) NOT NULL default '-1',
`ID_TYPE` int(11) NOT NULL default '0',
`TYPE` varchar(255) default NULL,
PRIMARY KEY (`ID_DC`,`ID_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=0;
USE `eunis`;
--
-- Table structure for table `chm62edt_nature_object_picture`
--
DROP TABLE IF EXISTS `chm62edt_nature_object_picture`;
CREATE TABLE `chm62edt_nature_object_picture` (
`ID_OBJECT` varchar(16) NOT NULL default '-1',
`NATURE_OBJECT_TYPE` varchar(16) NOT NULL default '',
`NAME` varchar(128) NOT NULL default '',
`FILE_NAME` varchar(255) NOT NULL default '',
`DESCRIPTION` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_advanced_search`
--
DROP TABLE IF EXISTS `eunis_advanced_search`;
CREATE TABLE `eunis_advanced_search` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`NODE_TYPE` varchar(16) NOT NULL default '',
KEY `IDX_EUNIS_ADVANCED_SEARCH` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`,`NODE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_advanced_search_criteria`
--
DROP TABLE IF EXISTS `eunis_advanced_search_criteria`;
CREATE TABLE `eunis_advanced_search_criteria` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`ATTRIBUTE` varchar(32) NOT NULL default '',
`OPERATOR` varchar(16) NOT NULL default '',
`FIRST_VALUE` varchar(128) NOT NULL default '',
`LAST_VALUE` varchar(128) default NULL,
KEY `IDX_EUNIS_ADVANCED_SEARCH_CRIT` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_advanced_search_criteria_temp`
--
DROP TABLE IF EXISTS `eunis_advanced_search_criteria_temp`;
CREATE TABLE `eunis_advanced_search_criteria_temp` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`ATTRIBUTE` varchar(32) NOT NULL default '',
`OPERATOR` varchar(16) NOT NULL default '',
`FIRST_VALUE` varchar(128) NOT NULL default '',
`LAST_VALUE` varchar(128) default NULL,
KEY `IDX_EUNIS_ADV_SEARCH_CRIT_TEMP` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_advanced_search_results`
--
DROP TABLE IF EXISTS `eunis_advanced_search_results`;
CREATE TABLE `eunis_advanced_search_results` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(32) NOT NULL default '',
`ID_NATURE_OBJECT` int(16) NOT NULL default '0',
PRIMARY KEY (`ID_SESSION`,`NATURE_OBJECT`,`ID_NATURE_OBJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_advanced_search_temp`
--
DROP TABLE IF EXISTS `eunis_advanced_search_temp`;
CREATE TABLE `eunis_advanced_search_temp` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`NODE_TYPE` varchar(16) NOT NULL default '',
KEY `IDX_EUNIS_ADVANCED_SEARCH_TEMP` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`,`NODE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_bookmarks`
--
DROP TABLE IF EXISTS `eunis_bookmarks`;
CREATE TABLE `eunis_bookmarks` (
`USERNAME` varchar(64) NOT NULL default '',
`BOOKMARK` text NOT NULL,
`DESCRIPTION` varchar(255) NOT NULL default '',
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`DESCRIPTION`(128),`BOOKMARK`(128),`USERNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_combined_search`
--
DROP TABLE IF EXISTS `eunis_combined_search`;
CREATE TABLE `eunis_combined_search` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`NODE_TYPE` varchar(16) NOT NULL default '',
KEY `IDX_EUNIS_COMBINED_SEARCH` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`,`NODE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_combined_search_criteria`
--
DROP TABLE IF EXISTS `eunis_combined_search_criteria`;
CREATE TABLE `eunis_combined_search_criteria` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`ATTRIBUTE` varchar(32) NOT NULL default '',
`OPERATOR` varchar(16) NOT NULL default '',
`FIRST_VALUE` varchar(128) NOT NULL default '',
`LAST_VALUE` varchar(128) default NULL,
KEY `IDX_EUNIS_COMBINED_SEARCH_CRIT` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_combined_search_criteria_temp`
--
DROP TABLE IF EXISTS `eunis_combined_search_criteria_temp`;
CREATE TABLE `eunis_combined_search_criteria_temp` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`ATTRIBUTE` varchar(32) NOT NULL default '',
`OPERATOR` varchar(16) NOT NULL default '',
`FIRST_VALUE` varchar(128) NOT NULL default '',
`LAST_VALUE` varchar(128) default NULL,
KEY `IDX_EUNIS_COMB_SEARCH_CRIT_TEMP` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_combined_search_results`
--
DROP TABLE IF EXISTS `eunis_combined_search_results`;
CREATE TABLE `eunis_combined_search_results` (
`ID_SESSION` varchar(64) NOT NULL default '',
`ID_NATURE_OBJECT_SPECIES` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT_HABITATS` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT_SITES` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT_COMBINATION_1` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT_COMBINATION_2` int(11) NOT NULL default '-1',
`ID_NATURE_OBJECT_COMBINATION_3` int(11) NOT NULL default '-1',
KEY `ID_SESSION` (`ID_SESSION`),
KEY `ID_NATURE_OBJECT_SPECIES` (`ID_NATURE_OBJECT_SPECIES`),
KEY `ID_NATURE_OBJECT_HABITATS` (`ID_NATURE_OBJECT_HABITATS`),
KEY `ID_NATURE_OBJECT_SITES` (`ID_NATURE_OBJECT_SITES`),
KEY `ID_NATURE_OBJECT` (`ID_NATURE_OBJECT`),
KEY `ID_NATURE_OBJECT_COMBINATION_1` (`ID_NATURE_OBJECT_COMBINATION_1`),
KEY `ID_NATURE_OBJECT_COMBINATION_2` (`ID_NATURE_OBJECT_COMBINATION_2`),
KEY `ID_NATURE_OBJECT_COMBINATION_3` (`ID_NATURE_OBJECT_COMBINATION_3`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_combined_search_temp`
--
DROP TABLE IF EXISTS `eunis_combined_search_temp`;
CREATE TABLE `eunis_combined_search_temp` (
`ID_SESSION` varchar(64) NOT NULL default '',
`NATURE_OBJECT` varchar(16) NOT NULL default '',
`ID_NODE` varchar(16) NOT NULL default '',
`NODE_TYPE` varchar(16) NOT NULL default '',
KEY `IDX_EUNIS_COMBINED_SEARCH_TEMP` (`ID_SESSION`,`NATURE_OBJECT`,`ID_NODE`,`NODE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_digir`
--
DROP TABLE IF EXISTS `eunis_digir`;
CREATE TABLE `eunis_digir` (
`GlobalUniqueIdentifier` varchar(64) default NULL,
`DateLastModified` datetime default NULL,
`BasisOfRecord` varchar(50) default NULL,
`InstitutionCode` varchar(16) default NULL,
`CollectionCode` varchar(16) default NULL,
`CatalogNumber` varchar(64) default NULL,
`ScientificName` varchar(64) default NULL,
`Kingdom` varchar(32) default NULL,
`Phylum` varchar(32) default NULL,
`Class` varchar(32) default NULL,
`Order` varchar(32) default NULL,
`Family` varchar(32) default NULL,
`Genus` varchar(32) default NULL,
`ScientificNameAuthor` varchar(50) default NULL,
`Continent` varchar(16) default NULL,
`Country` varchar(32) default NULL,
`GeodeticDatum` varchar(64) default 'not recorded',
`DecimalLatitude` varchar(32) default NULL,
`DecimalLongitude` varchar(32) default NULL,
`CoordinateUncertaintyInMeters` int(6) default NULL,
`YearCollected` tinyint(4) default NULL,
`MonthCollected` tinyint(4) default NULL,
`DayCollected` tinyint(4) default NULL,
`Collector` tinyint(4) default NULL,
`RelatedInformation` varchar(255) default NULL,
KEY `GlobalUniqueIdentifier` (`GlobalUniqueIdentifier`),
FULLTEXT KEY `ScientificName` (`ScientificName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_feedback`
--
DROP TABLE IF EXISTS `eunis_feedback`;
CREATE TABLE `eunis_feedback` (
`ID_FEEDBACK` int(11) NOT NULL auto_increment,
`FEEDBACK_TYPE` varchar(32) default NULL,
`MODULE` varchar(32) default NULL,
`COMMENT` varchar(2000) default NULL,
`NAME` varchar(64) default NULL,
`EMAIL` varchar(64) default NULL,
`COMPANY` varchar(64) default NULL,
`ADDRESS` varchar(255) default NULL,
`PHONE` varchar(32) default NULL,
`FAX` varchar(32) default NULL,
`URL` varchar(128) default NULL,
PRIMARY KEY (`ID_FEEDBACK`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_group_search`
--
DROP TABLE IF EXISTS `eunis_group_search`;
CREATE TABLE `eunis_group_search` (
`CRITERIA_NAME` varchar(128) NOT NULL default '',
`DESCRIPTION` text,
`USERNAME` varchar(100) NOT NULL default '',
`FROM_WHERE` varchar(255) NOT NULL default '0',
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(16) NOT NULL default 'OPERATOR',
PRIMARY KEY (`CRITERIA_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_group_search_criteria`
--
DROP TABLE IF EXISTS `eunis_group_search_criteria`;
CREATE TABLE `eunis_group_search_criteria` (
`CRITERIA_NAME` varchar(128) NOT NULL default '',
`ID_EUNIS_GROUP_SEARCH_CRITERIA` varchar(16) NOT NULL default '0',
`CRITERIA_ATTRIBUTE` varchar(128) NOT NULL default '',
`CRITERIA_FORM_FIELD_ATTRIBUTE` varchar(128) NOT NULL default '',
`CRITERIA_OPERATOR` varchar(16) NOT NULL default '',
`CRITERIA_FORM_FIELD_OPERATOR` varchar(128) default NULL,
`CRITERIA_FIRST_VALUE` varchar(128) NOT NULL default '',
`CRITERIA_LAST_VALUE` varchar(128) default NULL,
`CRITERIA_BOOLEAN` varchar(50) default NULL,
PRIMARY KEY (`CRITERIA_NAME`,`ID_EUNIS_GROUP_SEARCH_CRITERIA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_headlines`
--
DROP TABLE IF EXISTS `eunis_headlines`;
CREATE TABLE `eunis_headlines` (
`CONTENT` varchar(255) NOT NULL default '',
`START_DATE` date default NULL,
`END_DATE` date default NULL,
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
KEY `IDX_START_DATE` (`START_DATE`),
KEY `IDX_END_DATE` (`END_DATE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_iso_languages`
--
DROP TABLE IF EXISTS `eunis_iso_languages`;
CREATE TABLE `eunis_iso_languages` (
`name` varchar(32) default NULL,
`code` varchar(6) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_related_reports`
--
DROP TABLE IF EXISTS `eunis_related_reports`;
CREATE TABLE `eunis_related_reports` (
`FILE_NAME` varchar(85) NOT NULL default '',
`REPORT_NAME` varchar(85) NOT NULL default '',
`APPROVED` int(11) default NULL,
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(5) NOT NULL default 'OPERATOR',
PRIMARY KEY (`FILE_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_rights`
--
DROP TABLE IF EXISTS `eunis_rights`;
CREATE TABLE `eunis_rights` (
`RIGHTNAME` varchar(250) NOT NULL default '',
`DESCRIPTION` varchar(255) default NULL,
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(16) NOT NULL default 'OPERATOR',
PRIMARY KEY (`RIGHTNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_roles`
--
DROP TABLE IF EXISTS `eunis_roles`;
CREATE TABLE `eunis_roles` (
`ROLENAME` varchar(64) NOT NULL default '',
`DESCRIPTION` varchar(255) default NULL,
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(16) NOT NULL default 'OPERATOR',
PRIMARY KEY (`ROLENAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_roles_rights`
--
DROP TABLE IF EXISTS `eunis_roles_rights`;
CREATE TABLE `eunis_roles_rights` (
`ROLENAME` varchar(64) NOT NULL default '',
`RIGHTNAME` varchar(250) NOT NULL default '',
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(16) NOT NULL default 'OPERATOR',
PRIMARY KEY (`ROLENAME`,`RIGHTNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_save_advanced_search`
--
DROP TABLE IF EXISTS `eunis_save_advanced_search`;
CREATE TABLE `eunis_save_advanced_search` (
`CRITERIA_NAME` varchar(100) default NULL,
`NATURE_OBJECT` varchar(100) default NULL,
`ID_NODE` int(16) NOT NULL default '0',
`NODE_TYPE` varchar(16) default NULL,
`DESCRIPTION` text,
`USERNAME` varchar(100) default NULL,
`RECORD_AUTHOR` varchar(16) NOT NULL default '',
`RECORD_DATE` datetime default NULL,
`FROM_WHERE` varchar(100) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_save_advanced_search_criteria`
--
DROP TABLE IF EXISTS `eunis_save_advanced_search_criteria`;
CREATE TABLE `eunis_save_advanced_search_criteria` (
`CRITERIA_NAME` varchar(100) default NULL,
`NATURE_OBJECT` varchar(100) default NULL,
`ID_NODE` int(16) NOT NULL default '0',
`ATTRIBUTE` varchar(32) default NULL,
`OPERATOR` varchar(16) default NULL,
`FIRST_VALUE` varchar(128) default NULL,
`LAST_VALUE` varchar(128) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_session_log`
--
DROP TABLE IF EXISTS `eunis_session_log`;
CREATE TABLE `eunis_session_log` (
`ID_SESSION` varchar(255) NOT NULL default '',
`USERNAME` varchar(64) NOT NULL default '',
`START` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`END` datetime NOT NULL,
`IP_ADDRESS` varchar(32) NOT NULL default '',
PRIMARY KEY (`ID_SESSION`,`START`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_users`
--
DROP TABLE IF EXISTS `eunis_users`;
CREATE TABLE `eunis_users` (
`USERNAME` varchar(100) NOT NULL default '',
`PASSWORD` varchar(255) NOT NULL default '',
`FIRST_NAME` varchar(255) default NULL,
`LAST_NAME` varchar(255) default NULL,
`EMAIL` varchar(64) default NULL,
`LANG` varchar(5) NOT NULL default 'en',
`THEME_INDEX` int(11) unsigned NOT NULL default '0',
`LOGIN_DATE` datetime NOT NULL default '1970-01-01 00:00:00',
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(16) NOT NULL default 'OPERATOR',
PRIMARY KEY (`USERNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_users_roles`
--
DROP TABLE IF EXISTS `eunis_users_roles`;
CREATE TABLE `eunis_users_roles` (
`USERNAME` varchar(100) NOT NULL default '',
`ROLENAME` varchar(64) NOT NULL default '',
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(16) NOT NULL default 'OPERATOR',
PRIMARY KEY (`USERNAME`,`ROLENAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table `eunis_web_content`
--
DROP TABLE IF EXISTS `eunis_web_content`;
CREATE TABLE `eunis_web_content` (
`ID_PAGE` varchar(64) NOT NULL default '',
`CONTENT` text,
`DESCRIPTION` varchar(255) default NULL,
`LANG` varchar(64) NOT NULL default 'EN',
`LANG_STATUS` tinyint(4) default '1',
`CONTENT_LENGTH` tinyint(4) default '0',
`RECORD_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`RECORD_AUTHOR` varchar(16) default 'OPERATOR',
`CONTENT_VALID` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ID_PAGE`,`LANG`,`RECORD_DATE`),
KEY `IDX_RECORD_DATE` (`RECORD_DATE`),
KEY `IDX_ALL_FIELDS` (`ID_PAGE`,`CONTENT`(128)),
KEY `IDX_ID_PAGE` (`ID_PAGE`),
KEY `IDX_LANG` (`LANG`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Data for the `eunis_rights` table
#
INSERT INTO `eunis_rights` (`RIGHTNAME`, `DESCRIPTION`, `RECORD_DATE`, `RECORD_AUTHOR`) VALUES
('Login','Login to EUNIS','2003-10-30 15:54:10','OPERATOR'),
('Upload_Reports','Upload related reports','2003-10-30 15:55:02','OPERATOR'),
('Services','Access services','2003-10-30 15:53:48','OPERATOR'),
('Save_Search_Criteria','Save search criteria','2003-10-30 15:54:40','OPERATOR'),
('Content_Management','Use contentent management tool','2003-10-30 15:54:57','OPERATOR'),
('User_Management','User management rights','2003-10-30 15:55:21','OPERATOR'),
('Upload_Pictures','Upload pictures of nature objects','2003-10-30 15:55:38','OPERATOR'),
('Show_Novalidated_Species','Show non-validated species from EUNIS','2003-10-30 15:56:00','OPERATOR'),
('Role_Management','Roles management rights','2003-10-30 15:56:18','OPERATOR'),
('edit_glossary','Edit the terms from glossary','2003-11-06 13:52:58','Administrator');
COMMIT;
#
# Data for the `eunis_roles` table
#
INSERT INTO `eunis_roles` (`ROLENAME`, `DESCRIPTION`, `RECORD_DATE`, `RECORD_AUTHOR`) VALUES
('Login','User who can do only login','2003-10-30 15:56:56','OPERATOR'),
('Administrator','Administrator of EUNIS','2003-11-07 14:56:34','root'),
('Operator','EUNIS operator','2003-11-07 11:05:31','root'),
('Guest','Guest user','2003-11-07 11:06:05','root'),
('Editor','Users who can edit content online','2003-10-30 15:57:57','OPERATOR'),
('Registered','','2003-11-07 11:10:46','root');
COMMIT;
#
# Data for the `eunis_roles_rights` table
#
INSERT INTO `eunis_roles_rights` (`ROLENAME`, `RIGHTNAME`, `RECORD_DATE`, `RECORD_AUTHOR`) VALUES
('Operator','Save_Search_Criteria','2003-11-07 14:56:04','root'),
('Administrator','Services','2003-11-07 14:56:35','root'),
('Administrator','Content_Management','2003-11-07 14:56:35','root'),
('Administrator','Upload_Pictures','2003-11-07 14:56:35','root'),
('Login','login','2003-10-16 13:27:53','Administrator'),
('Administrator','Role_Management','2003-11-07 14:56:35','root'),
('Registered','Show_Novalidated_Species','2003-11-07 11:10:47','root'),
('Operator','query_database','2003-11-07 14:56:04','root'),
('Operator','Content_Management','2003-11-07 14:56:04','root'),
('Operator','Upload_Pictures','2003-11-07 14:56:04','root'),
('Operator','Services','2003-11-07 14:56:04','root'),
('Operator','edit_glossary','2003-11-07 14:56:04','root'),
('Administrator','edit_glossary','2003-11-07 14:56:35','root'),
('Guest','Save_Search_Criteria','2003-11-07 11:06:05','root'),
('editor','login','2003-10-20 18:05:11','Administrator'),
('editor','content_management','2003-10-20 18:05:11','Administrator'),
('Guest','Login','2003-11-07 11:06:05','root'),
('Administrator','Upload_Reports','2003-11-07 14:56:35','root'),
('Administrator','Save_Search_Criteria','2003-11-07 14:56:35','root'),
('Administrator','Show_Novalidated_Species','2003-11-07 14:56:35','root'),
('Administrator','Login','2003-11-07 14:56:34','root'),
('Administrator','MySQLAdmin','2003-11-07 14:56:34','root'),
('Administrator','query_database','2003-11-07 14:56:34','root'),
('Administrator','User_Management','2003-11-07 14:56:34','root'),
('Operator','Upload_Reports','2003-11-07 14:56:04','root'),
('Operator','Show_Novalidated_Species','2003-11-07 14:56:04','root'),
('Registered','Save_Search_Criteria','2003-11-07 11:10:47','root'),
('Registered','Login','2003-11-07 11:10:47','root'),
('Operator','Login','2003-11-07 14:56:04','root');
COMMIT;
#
# Data for the `eunis_users` table
#
#…for security reason this part is not listed here
#
# Data for the `eunis_users_roles` table
#
INSERT INTO `eunis_users_roles` (`USERNAME`, `ROLENAME`, `RECORD_DATE`, `RECORD_AUTHOR`) VALUES
('administrator','Administrator','2005-01-31 15:43:41','root'),
('ullapinborg','Administrator','2003-11-07 14:56:34','root'),
('danielchirca','Administrator','2003-11-07 14:56:34','root'),
('lauriklein','Operator','2003-11-07 14:56:04','root'),
('markroekaerts','Operator','2003-11-07 14:56:04','root'),
('gregoirelois','Administrator','2003-11-07 14:56:34','root'),
('dorianmoss','Operator','2003-11-07 14:56:04','root'),
('phillipfox','Operator','2003-11-07 14:56:04','root'),
('sophieconde','Registered','2003-11-07 14:49:54','root'),
('corradoiannucci','Administrator','2003-11-07 14:56:34','root'),
('adriandascalu','Administrator','2003-11-07 14:56:34','root'),
('sorenroug','Operator','2003-11-07 14:56:04','root'),
('guest','Guest','2003-11-07 14:57:54','root'),
('cynthiadavies','Operator','2003-11-07 14:41:37','root'),
('root','Administrator','2005-04-07 11:14:13',''),
('sheilacryan','Operator','2003-11-07 13:54:53','root'),
('cristianromanescu','Administrator','2003-11-07 14:56:34','root');
COMMIT;
#
# Data for the `eunis_web_content` table
#
# This part is to long to be listed in this document – check the actual SQL script file – clear_auxiliary_tables.sql
#
# Data for the `eunis_iso_languages` table
#
INSERT INTO `eunis_iso_languages` (`NAME`, `CODE`) VALUES
('Afrikaans','af'),
('Arabic (U.A.E.)','ar-ae'),
('Arabic (U.A.E.)','ar-ae'),
('Arabic (Bahrain)','ar-bh'),
('Arabic (Algeria)','ar-dz'),
('Arabic (Egypt)','ar-eg'),
('Arabic (Iraq)','ar-iq'),
('Arabic (Jordan)','ar-jo'),
('Arabic (Kuwait)','ar-kw'),
('Arabic (Lebanon)','ar-lb'),
('Arabic (Libya)','ar-ly'),
('Arabic (Morocco)','ar-ma'),
('Arabic (Oman)','ar-om'),
('Arabic (Qatar)','ar-qa'),
('Arabic (Saudi Arabia)','ar-sa'),
('Arabic (Syria)','ar-sy'),
('Arabic (Tunisia)','ar-tn'),
('Arabic (Yemen)','ar-ye'),
('Belarusian','be'),
('Bulgarian','bg'),
('Catalan','ca'),
('Czech','cs'),
('Danish','da'),
('German (Standard)','de'),
('German (Austria)','de-at'),
('German (Switzerland)','de-ch'),
('German (Liechtenstein)','de-li'),
('German (Luxembourg)','de-lu'),
('Greek','el'),
('English','en'),
('English (Caribbean)','en'),
('English (Australia)','en-au'),
('English (Belize)','en-bz'),
('English (Canada)','en-ca'),
('English (United Kingdom)','en-gb'),
('English (Ireland)','en-ie'),
('English (Jamaica)','en-jm'),
('English (New Zealand)','en-nz'),
('English (Trinidad)','en-tt'),
('English (United States)','en-us'),
('English (South Africa)','en-za'),
('Spanish (Spain ? Modern)','es'),
('Spanish (Spain ? Traditional)','es'),
('Spanish (Argentina)','es-ar'),
('Spanish (Bolivia)','es-bo'),
('Spanish (Chile)','es-cl'),
('Spanish (Colombia)','es-co'),
('Spanish (Costa Rica)','es-cr'),
('Spanish (Dominican Republic)','es-do'),
('Spanish (Ecuador)','es-ec'),
('Spanish (Guatemala)','es-gt'),
('Spanish (Honduras)','es-hn'),
('Spanish (Mexico)','es-mx'),
('Spanish (Nicaragua)','es-ni'),
('Spanish (Panama)','es-pa'),
('Spanish (Peru)','es-pe'),
('Spanish (Puerto Rico)','es-pr'),
('Spanish (Paraguay)','es-py'),
('Spanish (El Salvador)','es-sv'),
('Spanish (Uruguay)','es-uy'),
('Spanish (Venezuela)','es-ve'),
('Estonian','et'),
('Basque','eu'),
('Farsi','fa'),
('Finnish','fi'),
('Faeroese','fo'),
('French (Standard)','fr'),
('French (Belgium)','fr-be'),
('French (Canada)','fr-ca'),
('French (Switzerland)','fr-ch'),
('French (Luxembourg)','fr-lu'),
('Gaelic (Scotland)','gd'),
('Gaelic (Ireland)','gd-ie'),
('Hebrew','he'),
('Hindi','hi'),
('Croatian','hr'),
('Hungarian','hu'),
('Indonesian','id'),
('Icelandic','is'),
('Italian (Standard)','it'),
('Italian (Switzerland)','it-ch'),
('Japanese','ja'),
('Yiddish','ji'),
('Korean','ko'),
('Korean (Johab)','ko'),
('Lithuanian','lt'),
('Latvian','lv'),
('(FYROM)','Macedo'),
('Malaysian','ms'),
('Maltese','mt'),
('Dutch (Standard)','nl'),
('Dutch (Belgium)','nl-be'),
('Norwegian (Bokmal)','no'),
('Norwegian (Nynorsk)','no'),
('Polish','pl'),
('Portuguese (Portugal)','pt'),
('Portuguese (Brazil)','pt-br'),
('Rhaeto-Romanic','rm'),
('Romanian','ro'),
('Romanian (Moldavia)','ro-mo'),
('Russian','ru'),
('Russian (Moldavia)','ru-mo'),
('Sorbian','sb'),
('Slovak','sk'),
('Slovenian','sl'),
('Albanian','sq'),
('Serbian (Cyrillic)','sr'),
('Serbian (Latin)','sr'),
('Swedish','sv'),
('Swedish (Finland)','sv-fi'),
('Sutu','sx'),
('Sami (Lappish)','sz'),
('Thai','th'),
('Tswana','tn'),
('Turkish','tr'),
('Tsonga','ts'),
('Ukrainian','uk'),
('Urdu','ur'),
('Venda','ve'),
('Vietnamese','vi'),
('Xhosa','xh'),
('Chinese (PRC)','zh-cn'),
('Chinese (Hong Kong SAR)','zh-hk'),
('Chinese (Singapore)','zh-sg'),
('Chinese (Taiwan)','zh-tw'),
('Zulu','zu');
COMMIT;
-----------------------
CHM62EDT_NATURE_OBJECT
CHM62EDT_SPECIES
CHM62EDT_HABITATS
CHM62EDT_SITES
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
Related searches
- azure database for mysql backup
- mysql create database syntax
- mysql database vs schema
- mysql sample database employees
- mysql database data example
- mysql database schema table
- select mysql database for schema output
- mysql create database example
- mysql create database sql
- mysql database creator
- mysql sample database download
- mysql database schema