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) 2012, 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 BIOGRAPHY_UPLOAD 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="biography_upload-code">
27 <title>Query Defining the BIOGRAPHY_UPLOAD View</title>
29 <code role="view">SELECT biography_data.animid::TEXT AS "B_AnimID"
30 , biography_data.animid_num::TEXT AS "B_AnimID_num"
31 , biography_data.animname::TEXT AS "B_AnimName"
32 , biography_data.birthgroup::TEXT AS "B_BirthGroup"
33 , biography_data.bgcertainty::TEXT AS "B_BGCertainty"
34 , biography_data.sex::TEXT AS "B_Sex"
35 , biography_data.momid::TEXT AS "B_MomID"
37 WHEN biography_data.dad_prelim THEN
38 (biography_data.dadid || 'gmi_dadid_prelim')::TEXT
40 biography_data.dadid::TEXT
42 , biography_data.dad_published AS "B_DadID_publication_info"
43 , biography_data.firstborn::TEXT AS "B_FirstBorn"
44 , biography_data.birthdate AS "B_Birthdate"
45 , biography_data.bdmin AS "B_BDMin"
46 , biography_data.bdmax AS "B_BDMax"
47 , biography_data.bddist::TEXT AS "B_BDDist"
48 , biography_data.entrydate AS "B_Entrydate"
49 , biography_data.entrytype::TEXT AS "B_Entrytype"
50 , biography_data.departdate AS "B_Departdate"
51 , biography_data.departdateerror AS "B_DepartdateError"
52 , biography_data.departtype::TEXT AS "B_Departtype"
53 FROM biography_data</code><code>;</code></literallayout>
56 <!-- Figure containing BIOGRAPHY_UPLOAD view diagram. -->
58 <!-- Use mediaobject role attribute to select either xhtml (html)
59 or pdf (dblatex) file paths. -->
61 <figure xml:id="biography_upload-erd">
62 <title>Entity Relationship Diagram of the BIOGRAPHY_UPLOAD View</title>
64 <imageobject role="html">
65 <imagedata scalefit="1" width="6in"
66 fileref="/doc/diagrams/biography_upload.png" format="PNG" />
68 <imageobject role="dblatex">
69 <imagedata scalefit="1" width="6in"
70 fileref="/diagrams/biography_upload.eps" format="EPS" />
73 <textobject> <phrase>If we could we would display here the
74 diagram showing how the BIOGRAPHY_UPLOAD view is constructed.</phrase>