[Biojava-l] ontology exception, addSequence & BioSQLSequenceDB

[Len Trigg]

Hilmar Lapp wrote:
> On Tuesday, October 14, 2003, at 02:37  PM, Len Trigg wrote:
> 
> >> BioSQL People - could you check the single table I've added
> >> (term_relationship_term) and see if it's sane for folding back into 
> >> the
> >> trunk of biosql development?
> >>
> 
> What's this table? -hilmar

The full message should be in the biojava list archive, but the
relevant snippet is:

-- Link a triple to a term, giving it a unique identifier. This allows
-- arbitrary expressions to be built up by then using the linked-to term
-- in another triple.
--
-- e.g. implies(isa(x, y), hasa(x, z))
CREATE TABLE term_relationship_term (
	term_relationship_id INTEGER NOT NULL,
	term_id INTEGER NOT NULL,
        PRIMARY KEY ( term_relationship_id, term_id ),
        UNIQUE ( term_relationship_id ),
        UNIQUE ( term_id ) );


Cheers,
Len.