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, 2014, 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 DATASHEETS 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="datasheets-code">
27 <title>Query Defining the DATASHEETS View: Part I</title>
29 <code role="view">SELECT *
31 (SELECT datasheet_events.followid AS followid
32 , datasheet_events.intid AS intid
33 , datasheet_events.date AS date
34 , datasheet_events.time AS time
35 , datasheet_events.mom AS mom
36 , datasheet_events.infant AS infant
37 , datasheet_events.infant2 AS infant2
38 , datasheet_events.sib AS sib
39 , datasheet_events.sib2 AS sib2
40 , datasheet_events.eid AS eid
41 , datasheet_events.behavior AS e_behavior
42 , datasheet_events.position AS e_position
43 , datasheet_events.uncertain AS e_uncertain
44 , datasheet_events.e_mom AS e_mom
45 , datasheet_events.e_mompart AS e_mompart
46 , datasheet_events.e_mom_foodpart AS e_mom_foodpart
47 , datasheet_events.e_mom_foodkind AS e_mom_foodkind
48 , datasheet_events.e_mom_fishpart AS e_mom_fishpart
49 , datasheet_events.e_mom_fishkind AS e_mom_fishkind
50 , datasheet_events.e_mom_fishresult AS e_mom_fishresult
51 , datasheet_events.e_mom_voc AS e_mom_voc
52 , datasheet_events.e_mom_play AS e_mom_play
53 , datasheet_events.e_mom_rest AS e_mom_rest
54 , datasheet_events.e_infant AS e_infant
55 , datasheet_events.e_infantpart AS e_infantpart
56 , datasheet_events.e_infant_foodpart AS e_infant_foodpart
57 , datasheet_events.e_infant_foodkind AS e_infant_foodkind
58 , datasheet_events.e_infant_fishpart AS e_infant_fishpart
59 , datasheet_events.e_infant_fishkind AS e_infant_fishkind
60 , datasheet_events.e_infant_fishresult AS e_infant_fishresult
61 , datasheet_events.e_infant_voc AS e_infant_voc
62 , datasheet_events.e_infant_play AS e_infant_play
63 , datasheet_events.e_infant_ride AS e_infant_ride
64 , datasheet_events.e_infant_rest AS e_infant_rest
65 , datasheet_events.e_sib as e_sib
66 , datasheet_events.e_sibpart AS e_sibpart
67 , datasheet_events.e_sib_foodpart AS e_sib_foodpart
68 , datasheet_events.e_sib_foodkind AS e_sib_foodkind
69 , datasheet_events.e_sib_fishpart AS e_sib_fishpart
70 , datasheet_events.e_sib_fishkind AS e_sib_fishkind
71 , datasheet_events.e_sib_fishresult AS e_sib_fishresult
72 , datasheet_events.e_sib_voc AS e_sib_voc
73 , datasheet_events.e_sib_play AS e_sib_play
74 , datasheet_events.e_sib_ride AS e_sib_ride
75 , datasheet_events.e_sib_rest AS e_sib_rest
76 , datasheet_events.e_nonfocal AS e_nonfocal
77 , datasheet_events.e_nonfocalpart as e_nonfocalpart
78 , datasheet_events.e_baboon AS e_baboon
79 , datasheet_events.e_baboonpart AS e_baboonpart
80 </code></literallayout>
82 <figure xml:id="datasheets-code-part2">
83 <title>Query Defining the DATASHEETS View: Part II</title>
84 <literallayout><code role="view"> , NULL AS d_distid
90 , datasheet_events.i_comment AS i_comment
91 , datasheet_events.e_comment AS e_comment
93 </code></literallayout>
95 <figure xml:id="datasheets-code-part3">
96 <title>Query Defining the DATASHEETS View: Part III</title>
97 <literallayout><code role="view"> UNION
98 SELECT family_dists.followid AS followid
99 , family_dists.intid AS intid
100 , family_dists.date AS date
101 , family_dists.time AS time
102 , family_dists.mom AS mom
103 , family_dists.infant AS infant
104 , family_dists.infant2 AS infant2
105 , family_dists.sib AS sib
106 , family_dists.sib2 AS sib2
110 , NULL AS e_uncertain
113 , NULL AS e_mom_foodpart
114 , NULL AS e_mom_foodkind
115 , NULL AS e_mom_fishpart
116 , NULL AS e_mom_fishkind
117 , NULL AS e_mom_fishresult
122 , NULL AS e_infantpart
123 , NULL AS e_infant_foodpart
124 , NULL AS e_infant_foodkind
125 , NULL AS e_infant_fishpart
126 , NULL AS e_infant_fishkind
127 , NULL AS e_infant_fishresult
128 , NULL AS e_infant_voc
129 , NULL AS e_infant_play
130 , NULL AS e_infant_ride
131 , NULL AS e_infant_rest
134 , NULL AS e_sib_foodpart
135 , NULL AS e_sib_foodkind
136 , NULL AS e_sib_fishpart
137 , NULL AS e_sib_fishkind
138 , NULL AS e_sib_fishresult
144 , NULL AS e_nonfocalpart
146 , NULL AS e_baboonpart
147 </code></literallayout>
149 <figure xml:id="datasheets-code-part4">
150 <title>Query Defining the DATASHEETS View: Part IV</title>
151 <literallayout><code role="view"> , family_dists.distid AS d_distid
152 , family_dists.uncertain AS d_uncertain
153 , family_dists.d_mom AS d_mom
154 , family_dists.d_infant AS d_infant
155 , family_dists.d_sib AS d_sib
156 , family_dists.distance AS d_distance
157 , family_dists.i_comment AS i_comment
168 , q.d_infant IS NULL</code><code>;</code></literallayout>
171 <!-- Figure containing DATASHEETS view diagram. -->
173 <!-- Use mediaobject role attribute to select either xhtml (html)
174 or pdf (dblatex) file paths. -->
176 <figure xml:id="datasheets-erd">
177 <title>Entity Relationship Diagram of the DATASHEETS View</title>
179 <textobject> <phrase>The DATASHEETS view ER diagram
180 intentionally omitted due to query size.</phrase>