eFlore/Projets.eflore-projetsApplications.annuaireApplications.bazarApplications.dictionnaireApplications.frameworkApplications.galerieApplications.gttApplications.papyrusApplications.projetApplications.referentielApplications.reseauApplications.wikinieFlore/Applications.bibliobotaeFlore/Applications.celeFlore/Applications.cel-consultationeFlore/Applications.coeleFlore/Applications.coel-consultationeFlore/Applications.deleFlore/Applications.eflore-consultationeFlore/Applications.moissonnageeFlore/Archives.cel-v1eFlore/Archives.cel-v2eFlore/Archives.chorologieeFlore/Archives.eflore-consultation-v1eFlore/Archives.eflore-consultation-v2eFlore/Archives.eflore-xuleFlore/Archives.herbierseFlore/Projets.communesSites.gentiana.orgSites.obs-saisons.frSites.outils-naturalistes.frSites.tela-botanica.org

BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /trunk/docs/projets/prometheus/bdd/ontologie.sql @ 227

  → /trunk/docs/projets/prometheus/bdd/prometheus_v1_00.sql @ 235

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 227 → Rev 235

/trunk/docs/projets/prometheus/bdd/prometheus_v1_00.sql/ontologie.sql
1,7 → 1,44
--
-- Structure de la table `prometheus_meta`
--
CREATE TABLE IF NOT EXISTS `prometheus_meta` (
`guid` varchar(255) NOT NULL DEFAULT 'urn:lsid:tela-botanica.org:#projet:#version',
`langue_meta` varchar(2) NOT NULL DEFAULT 'fr',
`code` varchar(20) NOT NULL,
`version` varchar(20) NOT NULL,
`titre` varchar(255) DEFAULT NULL,
`description` text,
`mots_cles` varchar(510) DEFAULT NULL,
`citation` varchar(255) DEFAULT NULL,
`url_tech` varchar(510) DEFAULT NULL,
`url_projet` varchar(510) DEFAULT NULL,
`source` text,
`createurs` text,
`editeur` varchar(1000) NOT NULL DEFAULT 'nom=Tela Botanica;guid=urn:lsid:tela-botanica.org;courriel=accueil@tela-botanica.org;telephone=+334 67 52 41 22;url.info=http://www.tela-botanica.org/page:association_tela_botanica;url.logo=http://www.tela-botanica.org/sites/accueil/generique/images/graphisme/logo_tela_fond_blanc.png;type=organisation;acronyme=TB;adresse=Association Tela Botanica - Institut de Botanique - 167 rue Auguste Broussonnet 34090 MONTPELLIER, FRANCE;latitude.wgs84=43.615892;longitude.wgs84=3.871736;contact.prenom=Jean-Pascal;contact.nom=MILCENT;contact.courriel=jpm@tela-botanica.org;contact.role=administrateur des données;',
`contributeurs` text,
`droits` text,
`url_droits` varchar(510) DEFAULT NULL,
`langue` varchar(255) NOT NULL DEFAULT 'fr',
`date_creation` varchar(30) NOT NULL DEFAULT 'YYYY-MM-DD',
`date_validite` varchar(255) DEFAULT NULL,
`couverture_spatiale` varchar(510) NOT NULL DEFAULT 'iso-3166-1.id=FX;',
`couverture_temporelle` varchar(510) DEFAULT NULL,
`web_services` varchar(510) DEFAULT NULL COMMENT 'ontologies,meta-donnees,noms,taxons,aide,textes,images,observations,noms-vernaculaires',
PRIMARY KEY (`guid`,`langue_meta`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Contenu de la table `prometheus_meta`
--
INSERT INTO `prometheus_meta` (`guid`, `langue_meta`, `code`, `version`, `titre`, `description`, `mots_cles`, `citation`, `url_tech`, `url_projet`, `source`, `createurs`, `editeur`, `contributeurs`, `droits`, `url_droits`, `langue`, `date_creation`, `date_validite`, `couverture_spatiale`, `couverture_temporelle`, `web_services`) VALUES
('urn:lsid:tela-botanica.org:prometheus:1.00', 'fr', 'PROMETHEUS', '1.00', 'Ontologie de la botanique réalisée dans le cadre du projet Prometheus.', 'Ontologie de la botanique réalisée dans le cadre du projet Prometheus.\r\nTraduction des termes en français par le réseau Tela Botanica.\r\n', 'ontologie, botanique.', NULL, 'http://www.tela-botanica.org/wikini/eflore/wakka.php?wiki=IntegrationPrometheus', 'http://www.jstor.org/stable/25065431', 'http://www.jstor.org/stable/25065431', 'Armstrong, Kate\r\np.prenom=Kate,p.nom=Armstrong,p.courriel=k.armstrong@rbge.org,o.nom=Royal Botanic Garden', '', NULL, 'Copyright © tela-botanica.org (2012). Tout droits réservés.', NULL, 'en,fr', '2003-02-18', NULL, '', NULL, 'metaDonnees:0.2;ontologies:0.2');
-- -----------------------------------------------------
-- Table `ontologie_type`
-- Table `prometheus_ontologies_type`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ontologie_type` (
CREATE TABLE IF NOT EXISTS `prometheus_ontologies_type` (
`id_type` INT NOT NULL ,
`id_type_parent` INT NOT NULL DEFAULT 0 ,
`type` VARCHAR(45) NULL ,
13,9 → 50,9
-- -----------------------------------------------------
-- Table `ontologie_auteur`
-- Table `prometheus_ontologies_auteur`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ontologie_auteur` (
CREATE TABLE IF NOT EXISTS `prometheus_ontologies_auteur` (
`id_auteur` INT NOT NULL ,
`prenom` VARCHAR(45) NULL ,
`nom` VARCHAR(45) NULL ,
29,9 → 66,9
-- -----------------------------------------------------
-- Table `ontologie_publication`
-- Table `prometheus_ontologies_publication`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ontologie_publication` (
CREATE TABLE IF NOT EXISTS `prometheus_ontologies_publication` (
`id_publication` INT NOT NULL ,
`ce_auteur_principal` INT NOT NULL ,
`titre` VARCHAR(255) NULL ,
38,12 → 75,7
`date` DATE NULL ,
`uri` VARCHAR(255) NULL ,
PRIMARY KEY (`id_publication`) ,
INDEX `fk_ontologie_publication_ontologie_auteur1` (`ce_auteur_principal` ASC) ,
CONSTRAINT `fk_ontologie_publication_ontologie_auteur1`
FOREIGN KEY (`ce_auteur_principal` )
REFERENCES `ontologie_auteur` (`id_auteur` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
INDEX `fk_ontologie_publication_ontologie_auteur1` (`ce_auteur_principal` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
50,19 → 82,14
-- -----------------------------------------------------
-- Table `ontologie_image`
-- Table `prometheus_ontologies_image`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ontologie_image` (
CREATE TABLE IF NOT EXISTS `prometheus_ontologies_image` (
`id_image` INT NOT NULL ,
`uri` VARCHAR(255) NULL ,
`ce_publication` INT NOT NULL ,
PRIMARY KEY (`id_image`) ,
INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) ,
CONSTRAINT `fk_ontologie_image_ontologie_publication1`
FOREIGN KEY (`ce_publication` )
REFERENCES `ontologie_publication` (`id_publication` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
69,45 → 96,25
-- -----------------------------------------------------
-- Table `ontologie_terme`
-- Table `prometheus_ontologies_terme`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ontologie_terme` (
CREATE TABLE IF NOT EXISTS `prometheus_ontologies_terme` (
`id_terme` INT NOT NULL COMMENT 'Identifiant global du terme (GLOBALID)' ,
`ce_type` INT NOT NULL ,
`terme` VARCHAR(255) NOT NULL ,
`definition` TEXT NULL ,
`terme_fr` VARCHAR(255) NULL ,
`definition_fr` TEXT NULL ,
`notes_fr` TEXT NULL ,
`preference` TINYINT(1) NULL COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,
`nom` VARCHAR(255) NOT NULL ,
`description` TEXT NULL ,
`nom_en` VARCHAR(255) NULL ,
`description_en` TEXT NULL ,
`preference` TINYINT(1) NULL DEFAULT 1 COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,
`ce_auteur` INT NOT NULL ,
`ce_publication` INT NOT NULL ,
`ce_image` INT NOT NULL ,
`notes` TEXT NULL ,
PRIMARY KEY (`id_terme`) ,
INDEX `fk_ontologie_terme_ontologie_terme_type` (`ce_type` ASC) ,
INDEX `fk_ontologie_terme_ontologie_auteur1` (`ce_auteur` ASC) ,
INDEX `fk_ontologie_terme_ontologie_publication1` (`ce_publication` ASC) ,
INDEX `fk_ontologie_terme_ontologie_image1` (`ce_image` ASC) ,
CONSTRAINT `fk_ontologie_terme_ontologie_terme_type`
FOREIGN KEY (`ce_type` )
REFERENCES `ontologie_type` (`id_type` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ontologie_terme_ontologie_auteur1`
FOREIGN KEY (`ce_auteur` )
REFERENCES `ontologie_auteur` (`id_auteur` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ontologie_terme_ontologie_publication1`
FOREIGN KEY (`ce_publication` )
REFERENCES `ontologie_publication` (`id_publication` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ontologie_terme_ontologie_image1`
FOREIGN KEY (`ce_image` )
REFERENCES `ontologie_image` (`id_image` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
INDEX `fk_ontologie_terme_ontologie_image1` (`ce_image` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
114,9 → 121,9
-- -----------------------------------------------------
-- Table `ontologie_hierarchie`
-- Table `prometheus_ontologies_hierarchie`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ontologie_hierarchie` (
CREATE TABLE IF NOT EXISTS `prometheus_ontologies_hierarchie` (
`id_noeud` INT NOT NULL ,
`id_noeud_parent` INT NOT NULL ,
`chemin_noms` VARCHAR(500) NOT NULL ,
123,12 → 130,7
`chemin_ids` VARCHAR(100) NOT NULL ,
`ce_terme` INT NOT NULL ,
PRIMARY KEY (`id_noeud`) ,
INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) ,
CONSTRAINT `fk_ontologie_hierarchie_ontologie_terme1`
FOREIGN KEY (`ce_terme` )
REFERENCES `ontologie_terme` (`id_terme` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
135,48 → 137,39
-- -----------------------------------------------------
-- Table `ontologie_relation`
-- Table `prometheus_ontologies_relation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ontologie_relation` (
CREATE TABLE IF NOT EXISTS `prometheus_ontologies_relation` (
`id_terme_01` INT NOT NULL ,
`id_terme_02` INT NOT NULL ,
`relation` VARCHAR(45) NULL COMMENT 'Relation entre terme_01 et terme_02.' ,
PRIMARY KEY (`id_terme_01`, `id_terme_02`) ,
INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) ,
CONSTRAINT `fk_ontologie_relations_ontologie_terme1`
FOREIGN KEY (`id_terme_01` )
REFERENCES `ontologie_terme` (`id_terme` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ontologie_relations_ontologie_terme2`
FOREIGN KEY (`id_terme_02` )
REFERENCES `ontologie_terme` (`id_terme` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
`relation` VARCHAR(45) NOT NULL COMMENT 'Relation entre terme_01 et terme_02.' ,
PRIMARY KEY (`id_terme_01`, `id_terme_02`, `relation`) ,
INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
-- -----------------------------------------------------
-- Data for table `ontologie_type`
-- Data for table `prometheus_ontologies_type`
-- -----------------------------------------------------
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (1, 0, 'Global', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (4, 1, 'Modificateur relatif', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (5, 1, 'Valeur relative', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (6, 1, 'Modificateur spatial', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (7, 1, 'Localisateur de region', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (8, 1, 'Modificateur temporel', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (9, 1, 'Unité', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (10, 1, 'Propriété quantitative', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (11, 1, 'Propriété quantitative redéfinie', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (12, 0, 'Botanique', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (13, 12, 'État qualitatif', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (14, 12, 'Type de structure', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (15, 12, 'Structure', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (16, 12, 'Région', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (17, 12, 'Structure générique', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (18, 12, 'Groupe d\'états', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (19, 18, 'Sous-groupe d\'états', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (2, 1, 'Modificateur de fréquence', NULL);
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (3, 1, 'Qualificateur', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (1, 0, 'Global', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (4, 1, 'Modificateur relatif', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (5, 1, 'Valeur relative', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (6, 1, 'Modificateur spatial', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (7, 1, 'Localisateur de region', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (8, 1, 'Modificateur temporel', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (9, 1, 'Unité', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (10, 1, 'Propriété quantitative', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (11, 1, 'Propriété quantitative redéfinie', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (12, 0, 'Botanique', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (13, 12, 'État qualitatif', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (14, 12, 'Type de structure', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (15, 12, 'Structure', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (16, 12, 'Région', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (17, 12, 'Structure générique', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (18, 12, 'Groupe d\'états', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (19, 18, 'Sous-groupe d\'états', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (2, 1, 'Modificateur de fréquence', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (3, 1, 'Qualificateur', NULL);
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (20, 12, 'Terme déconseillé', NULL);