2 <!DOCTYPE para PUBLIC "-//OASIS//DTD DocBook XML 5.0//EN"
3 "http://www.oasis-open.org/docbook/xml/5.0/dtd/docbook.dtd" [
4 <!-- Use symbols for repeating text. -->
5 <!ENTITY % entities SYSTEM "../entities">
7 <!ENTITY % constants SYSTEM "../constants">
10 <!-- Copyright (C) 2013, 2018 The Meme Factory, Inc. http://www.meme.com
11 - Copyright (C) 2005, 2007, 2010 Karl O. Pinc <kop@meme.com> and others
12 - See document output for full copyright information. -->
14 <!-- Core documentation on the DISTS view.
16 - This is indeed the query that makes the view, so don't break it!
18 - The "code" element must have a 'role="view"' attribute
19 - so that Gombe-MI code generation can get the code
20 - and actually make the view!
23 <para xmlns="http://docbook.org/ns/docbook"
26 <figure xml:id="dists-code">
27 <title>Query Defining the DISTS View</title>
29 <code role="view">SELECT distances.distid AS distid
30 , distances.intid AS intid
31 , dpart1s.dpid AS dpart1pid
32 , dpart2s.dpid AS dpart2pid
33 , distances.uncertain AS uncertain
34 , dpart1s.role AS dpart1role
35 , dpart1s.participant AS participant1
36 , dpart2s.role AS dpart2role
37 , dpart2s.participant AS participant2
38 , distances.distance AS distance
40 JOIN distanceparts AS dpart1s
41 ON (dpart1s.distid = distances.distid)
42 JOIN distanceparts AS dpart2s
43 ON (dpart2s.distid = distances.distid)
44 WHERE dpart1s.dpid <> dpart2s.dpid</code><code>;</code></literallayout>
47 <!-- Figure containing DISTS view diagram. -->
49 <!-- Use mediaobject role attribute to select either xhtml (html)
50 or pdf (dblatex) file paths. -->
52 <figure xml:id="dists-erd">
53 <title>Entity Relationship Diagram of the DISTS View</title>
55 <imageobject role="html">
56 <imagedata scalefit="1" width="6in"
57 fileref="/doc/diagrams/dists.png" format="PNG" />
59 <imageobject role="dblatex">
60 <imagedata scalefit="1" width="6in"
61 fileref="/diagrams/dists.eps" format="EPS" />
64 <textobject> <phrase>If we could we would display here the
65 diagram showing how the DISTS view is constructed.</phrase>