[Obo-svn-commit] SF.net SVN: obo:[2756] OBDAPI/trunk

[<car...@us...>]

Revision: 2756
          http://obo.svn.sourceforge.net/obo/?rev=2756&view=rev
Author:   cartik73
Date:     2009-07-16 19:08:06 +0000 (Thu, 16 Jul 2009)

Log Message:
-----------
Added columns for related entities to phenotype_by_entity_character table
Added new Phenex JAR containing new code for the Labelmaker, to handle related entities

Modified Paths:
--------------
    OBDAPI/trunk/lib/buildlibs/phenex.jar
    OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql

Modified: OBDAPI/trunk/lib/buildlibs/phenex.jar
===================================================================
(Binary files differ)

Modified: OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql
===================================================================
--- OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql	2009-07-16 19:05:10 UTC (rev 2755)
+++ OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql	2009-07-16 19:08:06 UTC (rev 2756)
@@ -16,6 +16,9 @@
 entity_nid INTEGER, 
 entity_uid VARCHAR, 
 entity_label VARCHAR, 
+related_entity_nid INTEGER, 
+related_entity_uid VARCHAR, 
+related_entity_label VARCHAR, 
 reif_id INTEGER
 );
 
@@ -67,6 +70,12 @@
 'The actual uid of the ANATOMICAL ENTITY. Eq: TAO:0001510';
 COMMENT ON COLUMN phenotype_by_entity_character.entity_label IS 
 'The actual label or name of the ANATOMICAL ENTITY. Eg: "basihyal cartilage"';
+COMMENT ON COLUMN phenotype_by_entity_character.related_entity_nid IS 
+'The node id of the RELATED ANATOMICAL ENTITY as stored in the NODE table';
+COMMENT ON COLUMN phenotype_by_entity_character.related_entity_uid IS 
+'The actual uid of the RELATED ANATOMICAL ENTITY. Eq: TAO:0001510';
+COMMENT ON COLUMN phenotype_by_entity_character.related_entity_label IS 
+'The actual label or name of the RELATED ANATOMICAL ENTITY. Eg: "basihyal cartilage"';
 COMMENT ON COLUMN phenotype_by_entity_character.reif_id IS 
 'The node id of the SUBJECT -> PHENOTYPE assertion as stored in the LINK table. This is 
 the link to the publication, character number, character text, state text, comments etc 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.