[Gmod-schema-cmts] schema/chado/modules/sequence/bridges so-bridge.sql, NONE, 1.1

[Scott C. <sco...@us...>]

Update of /cvsroot/gmod/schema/chado/modules/sequence/bridges
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv25186

Added Files:
	so-bridge.sql 
Log Message:
updating the so bridge


--- NEW FILE: so-bridge.sql ---
CREATE SCHEMA so;
SET search_path=so,public,pg_catalog;

--- ************************************************
--- *** relation: region                         ***
--- *** relation type: VIEW                      ***
--- ***                                          ***
--- *** Sequence Ontology 'Typed Feature' View   ***
--- ***                                          ***
--- ************************************************
---
--- SO Term:
--- "region"

CREATE VIEW region AS
  SELECT
    feature_id AS region_id,
    feature.*
  FROM
[...6233 lines suppressed...]
---
--- Subject Type: insertion
--- Object Type:  repeat_region
--- Predicate:    PART-OF

CREATE VIEW repeat_region2insertion AS
  SELECT
    feature_relationship_id,
    subject_id AS insertion_id,
    object_id AS repeat_region_id,
    subject_id,
    object_id,
    feature_relationship.type_id
  FROM
    insertion INNER JOIN feature_relationship ON (insertion.feature_id = subject_id)
        INNER JOIN repeat_region ON (repeat_region.feature_id = object_id);



SET search_path = public,pg_catalog;