File: cv-convenience-views.sql

package info (click to toggle)
libchado-perl 1.23-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 23,976 kB
  • ctags: 10,378
  • sloc: xml: 192,540; sql: 165,945; perl: 28,339; sh: 101; python: 73; makefile: 46
file content (16 lines) | stat: -rw-r--r-- 457 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
CREATE VIEW cvterm_relationship_with_typename AS
 SELECT
  cvterm_relationship.*,
  typeterm.name AS typename,
  typeterm.cv_id AS typeterm_cv_id
 FROM cvterm_relationship
      INNER JOIN cvterm AS typeterm ON (type_id=typeterm.cvterm_id);

CREATE VIEW cvtermprop_with_propname AS
 SELECT
  cvtermprop.*,
  propterm.name AS propname,
  propterm.cv_id AS propterm_cv_id
 FROM cvtermprop
      INNER JOIN cvterm AS propterm ON (type_id=propterm.cvterm_id);