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 CHIMPS 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="chimps-code">
27 <title>Query Defining the CHIMPS View</title>
29 <code role="view">SELECT chimpids.chimpid AS chimpid
30 , biography_data.animid AS animid
31 , biography_data.animid_num AS animid_num
32 , biography_data.animname AS animname
33 , biography_data.birthgroup AS birthgroup
34 , biography_data.bgcertainty AS bgcertainty
35 , biography_data.sex AS sex
36 , biography_data.momid AS momid
37 , biography_data.dadid AS dadid
38 , biography_data.dad_prelim AS dad_prelim
39 , biography_data.dad_published AS dad_published
40 , biography_data.firstborn AS firstborn
41 , biography_data.birthdate AS birthdate
42 , biography_data.bdmin AS bdmin
43 , biography_data.bdmax AS bdmax
44 , biography_data.bddist AS bddist
45 , biography_data.entrydate AS entrydate
46 , biography_data.entrytype AS entrytype
47 , biography_data.departdate AS departdate
48 , biography_data.departdateerror AS departdateerror
49 , biography_data.departtype AS departtype
50 , biography_data.import_datetime AS import_datetime
53 JOIN chimpids ON (chimpids.animid = biography_data.animid)
54 LEFT OUTER JOIN twins ON (twins.animid = biography_data.animid)</code><code>;</code></literallayout>
57 <!-- Figure containing CHIMPS view diagram. -->
59 <!-- Use mediaobject role attribute to select either xhtml (html)
60 or pdf (dblatex) file paths. -->
62 <figure xml:id="chimps-erd">
63 <title>Entity Relationship Diagram of the CHIMPS View</title>
65 <imageobject role="html">
66 <imagedata scalefit="1" width="6in"
67 fileref="/doc/diagrams/chimps.png" format="PNG" />
69 <imageobject role="dblatex">
70 <imagedata scalefit="1" width="6in"
71 fileref="/diagrams/chimps.eps" format="EPS" />
74 <textobject> <phrase>If we could we would display here the
75 diagram showing how the CHIMPS view is constructed.</phrase>