WebSVN – eFlore/Archives.herbiers – /trunk/doc/bdd/herbiers.sql

-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mer 17 Décembre 2008 à 12:30
-- Version du serveur: 5.0.45
-- Version de PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de données: `tela_prod_herbiers`
--

-- --------------------------------------------------------

--
-- Structure de la table `EFLORE_DROIT`
--

CREATE TABLE IF NOT EXISTS `EFLORE_DROIT` (
  `ED_ID_DROIT` int(11) NOT NULL default '0',
  `ED_INTITULE_DROIT` varchar(50) NOT NULL default '',
  `ED_DESCRIPTION_DROIT` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ED_ID_DROIT`),
  UNIQUE KEY `EFLORE_DROIT_PK` (`ED_ID_DROIT`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `EFLORE_DROIT_POSSEDER`
--

CREATE TABLE IF NOT EXISTS `EFLORE_DROIT_POSSEDER` (
  `EDP_ID_UTILISATEUR` int(11) NOT NULL default '0',
  `EDP_ID_PROJET` int(11) NOT NULL default '0',
  `EDP_ID_DROIT` int(11) NOT NULL default '0',
  PRIMARY KEY  (`EDP_ID_UTILISATEUR`,`EDP_ID_DROIT`,`EDP_ID_PROJET`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `EFLORE_PROJET`
--

CREATE TABLE IF NOT EXISTS `EFLORE_PROJET` (
  `EPR_ID_PROJET` int(11) NOT NULL default '0',
  `EPR_CE_TYPE_PROJET_ORIGINE` int(11) NOT NULL default '0',
  `EPR_CE_OUVRAGE_SOURCE` int(11) default NULL,
  `EPR_INTITULE_PROJET` varchar(255) NOT NULL default '',
  `EPR_ABREVIATION_PROJET` varchar(40) default NULL,
  `EPR_DESCRIPTION_PROJET` varchar(255) default NULL,
  `EPR_LIEN_WEB` varchar(255) default NULL,
  `EPR_NOTES_PROJET` text,
  PRIMARY KEY  (`EPR_ID_PROJET`),
  UNIQUE KEY `EFLORE_PROJET_PK` (`EPR_ID_PROJET`),
  KEY `POSSEDER_TYPE_PROJET_FK` (`EPR_CE_TYPE_PROJET_ORIGINE`),
  KEY `ETRE_BASE_SUR_OUVRAGE_FK` (`EPR_CE_OUVRAGE_SOURCE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `gen_COUNTRY`
--

CREATE TABLE IF NOT EXISTS `gen_COUNTRY` (
  `GC_ID` varchar(5) NOT NULL default '',
  `GC_LOCALE` varchar(5) NOT NULL default '',
  `GC_NAME` varchar(80) NOT NULL default '',
  `GC_CAPITAL` varchar(80) NOT NULL default '',
  `GC_CONTINENT_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`GC_ID`,`GC_LOCALE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_ADMINISTRER`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_ADMINISTRER` (
  `HA_ID_ANNUAIRE` int(10) unsigned NOT NULL default '0',
  `HA_ID_ORG` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`HA_ID_ANNUAIRE`,`HA_ID_ORG`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_A_UN_TYPE`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_A_UN_TYPE` (
  `ID_INDIC` int(11) NOT NULL default '0',
  `ID_TYPE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID_INDIC`,`ID_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_COLLECTION`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_COLLECTION` (
  `ID` int(11) NOT NULL auto_increment,
  `PARENT_ID` int(11) default NULL,
  `LEVEL` varchar(255) default NULL,
  `COLLECTION_CODE` varchar(64) default NULL,
  `NOM_COLLECTION` varchar(255) NOT NULL default '',
  `DESCRIPTION` text,
  `STATUT` tinyint(3) unsigned NOT NULL default '1',
  `URL` varchar(255) default NULL,
  `INCLUDED_TYPE` tinyint(4) default '0',
  `STRENGTH` text,
  `PURPOSE` text,
  `NUM_ORGANISATION` int(11) default NULL,
  `NUM_SPECIMENS` int(11) default NULL,
  `NUM_SPECIES` int(11) default NULL,
  `DOC_STATE` text,
  `PERCENT_DATABASED` smallint(6) default NULL,
  `BIOCASE_URL` varchar(255) default NULL,
  `ACCESS_RESTRICTION` text,
  `USAGE_RESTRICTION` text,
  `COLLECTION_ACTIVITY` varchar(255) default NULL,
  `COLLECTION_FOCUS` varchar(255) default NULL,
  `NOTES` text,
  `COLLECTION_CLASS` tinyint(3) unsigned NOT NULL default '1',
  `COLLECTEURS` text,
  `DATE_DEBUT` date default '0000-00-00',
  `DATE_FIN` date default '0000-00-00',
  `DATE_DEBUT_CARAC` tinyint(3) unsigned NOT NULL default '1',
  `DATE_FIN_CARAC` tinyint(3) unsigned NOT NULL default '1',
  `PREC_SPECIMENS` tinyint(3) unsigned NOT NULL default '3',
  `PREC_SPECIES` tinyint(3) unsigned NOT NULL default '3',
  `ETAT_SPECIMENS` enum('1','2','3','4') NOT NULL default '1',
  `ETAT_CLASSEMENT` enum('1','2','3','4') NOT NULL default '1',
  `ETAT_PRESENTATION` enum('1','2','3','4') NOT NULL default '1',
  `MODE_CLASSEMENT` text,
  `DATE_DERNIERE_MODIF` datetime NOT NULL default '0000-00-00 00:00:00',
  `CE_MODIFIER_PAR` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=352 ;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_COLL_STATUT`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_COLL_STATUT` (
  `ID_COLL_STATUT` tinyint(3) unsigned NOT NULL auto_increment,
  `LABEL` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID_COLL_STATUT`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_COORDONNE`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_COORDONNE` (
  `HC_ID_COORDINATEUR` int(10) unsigned NOT NULL default '0',
  `HC_ID_REDACTEUR` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`HC_ID_COORDINATEUR`,`HC_ID_REDACTEUR`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_DATE_DEBUT_CARAC`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_DATE_DEBUT_CARAC` (
  `ID_DATE_CARAC` tinyint(3) unsigned NOT NULL default '0',
  `LABEL_DATE_DEBUT_CARAC` varchar(255) default NULL,
  PRIMARY KEY  (`ID_DATE_CARAC`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_DATE_FIN_CARAC`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_DATE_FIN_CARAC` (
  `ID_DATE_CARAC` tinyint(3) unsigned NOT NULL default '0',
  `LABEL_DATE_FIN_CARAC` varchar(255) default NULL,
  PRIMARY KEY  (`ID_DATE_CARAC`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_DENOMBREMENT_CARAC_SC`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_DENOMBREMENT_CARAC_SC` (
  `HDC_ID` tinyint(3) unsigned NOT NULL default '0',
  `HDC_LABEL` varchar(255) default NULL,
  PRIMARY KEY  (`HDC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_DENOMBREMENT_CARAC_SP`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_DENOMBREMENT_CARAC_SP` (
  `HDC_ID` tinyint(3) unsigned NOT NULL default '0',
  `HDC_LABEL` varchar(255) default NULL,
  PRIMARY KEY  (`HDC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_INDIC`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_INDIC` (
  `ID_INDIC` int(11) NOT NULL auto_increment,
  `ID` int(11) NOT NULL default '0',
  `REM_INDIC` text,
  `MAJ_INDIC` int(11) default NULL,
  `TXT_INDIC` text,
  PRIMARY KEY  (`ID_INDIC`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=143 ;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_INDIC_HISTORIQUE`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_INDIC_HISTORIQUE` (
  `ID_INDIC_HIST` int(10) unsigned NOT NULL auto_increment,
  `ID_INDIC` int(10) unsigned NOT NULL default '0',
  `DATE_INDIC` int(10) unsigned NOT NULL default '0',
  `ID_INDICATEUR` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID_INDIC_HIST`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=191 ;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_ont_pres`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_ont_pres` (
  `ID` int(10) unsigned NOT NULL default '0',
  `ID_PRES` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`,`ID_PRES`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_ont_un_staff`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_ont_un_staff` (
  `ID_ORG` int(11) NOT NULL default '0',
  `ID_STAFF` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID_ORG`,`ID_STAFF`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_ORGANISATION`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_ORGANISATION` (
  `ID_ORG` int(11) NOT NULL auto_increment,
  `NUM_COLLECTION` int(11) default NULL,
  `ADRESS_TEXT` text,
  `INSTITUTION_NAME` text,
  `ADRESS_LINE` text,
  `TOWN` varchar(255) default NULL,
  `REGION` varchar(255) default NULL,
  `COUNTRY_CODE` char(3) default NULL,
  `ZIP` varchar(16) default NULL,
  `TEL` varchar(64) default NULL,
  `FAX` varchar(64) default NULL,
  `EMAIL` varchar(255) default NULL,
  `HO_URL` varchar(255) default 'http://',
  `LOGO` varchar(255) default NULL,
  `TIME_ZONE` varchar(255) default NULL,
  `ORGANISATION_CLASS` enum('Botanic_Garden','Zoo','Hoticultural','Museum','Herbarium','Laboratory','Other') NOT NULL default 'Botanic_Garden',
  `COLLECTION_CLASS` enum('living','dormant','culture','preserved','observations','photography','fossil','other') NOT NULL default 'living',
  `INDEX_HERB` varchar(16) default NULL,
  `ACCESS_RESTRICTION` text,
  `STATUT_PUBLICATION` tinyint(3) unsigned NOT NULL default '0',
  `SOURCE_DES_DONNEES` varchar(255) NOT NULL default 'IH - Index Herbariorum',
  `DATE_DERNIERE_MODIF` datetime NOT NULL default '0000-00-00 00:00:00',
  `CE_MODIFIER_PAR` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID_ORG`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_PRES`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_PRES` (
  `ID_PRES` int(10) unsigned NOT NULL auto_increment,
  `LABEL` varchar(255) NOT NULL default '',
  `LABEL_ANG` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID_PRES`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_STAFF`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_STAFF` (
  `ID_STAFF` int(11) NOT NULL auto_increment,
  `NOM` varchar(255) default NULL,
  `PRENOM` varchar(255) default NULL,
  `ADRESSE1` varchar(255) default NULL,
  `ADRESSE2` varchar(255) default NULL,
  `CP` varchar(10) default NULL,
  `VILLE` varchar(255) default NULL,
  `MAIL` varchar(255) default NULL,
  `TEL` varchar(64) NOT NULL default '',
  `FAX` varchar(64) NOT NULL default '',
  `ID_TELA_BOTANICA` int(11) default NULL,
  `FONCTION` varchar(255) default NULL,
  `CONTACT` enum('non','oui') NOT NULL default 'non',
  `DATE_DERNIERE_MODIF` datetime NOT NULL default '0000-00-00 00:00:00',
  `CE_MODIFIER_PAR` mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (`ID_STAFF`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=89 ;

-- --------------------------------------------------------

--
-- Structure de la table `HERBIERS_TYPE`
--

CREATE TABLE IF NOT EXISTS `HERBIERS_TYPE` (
  `ID_TYPE` int(11) NOT NULL auto_increment,
  `LABEL_TYPE` varchar(255) default NULL,
  PRIMARY KEY  (`ID_TYPE`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
Subversion Repositories eFlore/Archives.herbiers

(root)/trunk/doc/bdd/herbiers.sql @ 26 – Rev 25
