https://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&action=history&feed=atomDesigning the Database "On Paper" - Revision history2024-03-29T07:52:14ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=14644&oldid=prevLorinda: add link to Sumit database design course, both in External links and introductory paragraph2008-12-12T21:53:03Z<p>add link to Sumit database design course, both in External links and introductory paragraph</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 21:53, 12 December 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Before actually creating a new Database document in NeoOffice, it is important to think through what sorts of data you will be storing and how you need to access it. Planning out your database on paper ahead of time will save you hours of frustration and restructuring later.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Before actually creating a new Database document in NeoOffice, it is important to think through what sorts of data you will be storing and how you need to access it. Planning out your database on paper ahead of time will save you hours of frustration and restructuring later. <ins style="color: red; font-weight: bold; text-decoration: none;"> [What follows is a rather informal description by someone who has been essentially self-taught when it comes to database design. For a discussion of database design that covers the formal theory as well as offering an example, see [http://www.sum-it.nl/cursus/dbdesign/english/index.php3 the Sum-it Database Design Course]]</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==First Questions==</td><td> </td><td style="background: #eee; font-size: smaller;">==First Questions==</td></tr>
<tr><td colspan="2" align="left"><strong>Line 126:</strong></td>
<td colspan="2" align="left"><strong>Line 126:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Related External Links==</td><td> </td><td style="background: #eee; font-size: smaller;">==Related External Links==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">* [http://www.sum-it.nl/cursus/dbdesign/english/index.php3 the Sum-it Database Design Course]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* [http://www.oooforum.org/forum/viewtopic.phtml?p=108553#108553 Books on database design] from OOoForum.org<br></td><td> </td><td style="background: #eee; font-size: smaller;">* [http://www.oooforum.org/forum/viewtopic.phtml?p=108553#108553 Books on database design] from OOoForum.org<br></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* [http://www.oooforum.org/forum/viewtopic.phtml?t=60484 OpenOffice.org Forum discussion on planning a database]<br></td><td> </td><td style="background: #eee; font-size: smaller;">* [http://www.oooforum.org/forum/viewtopic.phtml?t=60484 OpenOffice.org Forum discussion on planning a database]<br></td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13827&oldid=prevLorinda: /* Finished Planning List for the Birding Database */ add a note about some addition fields that might be helpful for actual birders.2008-05-09T02:32:02Z<p><span class="autocomment">Finished Planning List for the Birding Database -</span> add a note about some addition fields that might be helpful for actual birders.</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 02:32, 9 May 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 79:</strong></td>
<td colspan="2" align="left"><strong>Line 79:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Sight (Yes/No field type) - bird identified by sight.</td><td> </td><td style="background: #eee; font-size: smaller;">:Sight (Yes/No field type) - bird identified by sight.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Comments (bird behavior, where cited, etc.)</td><td> </td><td style="background: #eee; font-size: smaller;">:Comments (bird behavior, where cited, etc.)</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:('''Note:''' if tracking sightings for a family of birders, add two yes/no fields for each family member, one for voice and one for sight. e.g. JaneVoice, JaneSight, JohnVoice, JohnSight)</td><td>+</td><td style="background: #cfc; font-size: smaller;">:('''Note:''' if tracking sightings for a family of birders, add two yes/no fields for each family member, one for voice and one for sight. e.g. JaneVoice, JaneSight, JohnVoice, JohnSight<ins style="color: red; font-weight: bold; text-decoration: none;">. I also discovered that it was handy to have a GuestVoice and a GuestSight field. That way if I am birding with a group I can add sightings by other members of the group. This is helpful for tracking information about birds seen at particular locations, for example.</ins>)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Locations Table</td><td> </td><td style="background: #eee; font-size: smaller;">Locations Table</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13633&oldid=prevLJ-Bettona: /* Finished Planning List for the Birding Database */ consistency - remove space from field name JohnVoice2008-03-29T10:47:32Z<p><span class="autocomment">Finished Planning List for the Birding Database -</span> consistency - remove space from field name JohnVoice</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:47, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 79:</strong></td>
<td colspan="2" align="left"><strong>Line 79:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Sight (Yes/No field type) - bird identified by sight.</td><td> </td><td style="background: #eee; font-size: smaller;">:Sight (Yes/No field type) - bird identified by sight.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Comments (bird behavior, where cited, etc.)</td><td> </td><td style="background: #eee; font-size: smaller;">:Comments (bird behavior, where cited, etc.)</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:('''Note:''' if tracking sightings for a family of birders, add two yes/no fields for each family member, one for voice and one for sight. e.g. JaneVoice, JaneSight, <del style="color: red; font-weight: bold; text-decoration: none;">John Voice</del>, JohnSight)</td><td>+</td><td style="background: #cfc; font-size: smaller;">:('''Note:''' if tracking sightings for a family of birders, add two yes/no fields for each family member, one for voice and one for sight. e.g. JaneVoice, JaneSight, <ins style="color: red; font-weight: bold; text-decoration: none;">JohnVoice</ins>, JohnSight)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Locations Table</td><td> </td><td style="background: #eee; font-size: smaller;">Locations Table</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13632&oldid=prevLJ-Bettona: /* Guidelines for Field and Table names */ typo delete e from using2008-03-29T10:46:26Z<p><span class="autocomment">Guidelines for Field and Table names -</span> typo delete e from using</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:46, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 33:</strong></td>
<td colspan="2" align="left"><strong>Line 33:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Field names must begin with a letter and must only contain letters, numbers, and underscores. No spaces or other characters.</td><td> </td><td style="background: #eee; font-size: smaller;">*Field names must begin with a letter and must only contain letters, numbers, and underscores. No spaces or other characters.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Table names can contain spaces, but the standard is to use underscores instead.</td><td> </td><td style="background: #eee; font-size: smaller;">*Table names can contain spaces, but the standard is to use underscores instead.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Field names should be easily understandable by anyone <del style="color: red; font-weight: bold; text-decoration: none;">useing </del>the database</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Field names should be easily understandable by anyone <ins style="color: red; font-weight: bold; text-decoration: none;">using </ins>the database</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Field names should be unique across the whole database. You '''can''' have a field called "ID" in each table, and the database will work (because Neo keeps track of what table it comes from), but it is more confusing for the User. It is better to name these fields AOU_ID, Sightings_ID, etc., so it is clear in the field name what table it relates to.</td><td> </td><td style="background: #eee; font-size: smaller;">*Field names should be unique across the whole database. You '''can''' have a field called "ID" in each table, and the database will work (because Neo keeps track of what table it comes from), but it is more confusing for the User. It is better to name these fields AOU_ID, Sightings_ID, etc., so it is clear in the field name what table it relates to.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13631&oldid=prevLJ-Bettona: /* Guidlines for Field and Table names */ type - guidelines2008-03-29T10:45:34Z<p><span class="autocomment">Guidlines for Field and Table names -</span> type - guidelines</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:45, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 30:</strong></td>
<td colspan="2" align="left"><strong>Line 30:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Once you have given thought to these questions, you are ready to beginning planning what tables and fields you need. </td><td> </td><td style="background: #eee; font-size: smaller;">Once you have given thought to these questions, you are ready to beginning planning what tables and fields you need. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">===<del style="color: red; font-weight: bold; text-decoration: none;">Guidlines </del>for Field and Table names===</td><td>+</td><td style="background: #cfc; font-size: smaller;">===<ins style="color: red; font-weight: bold; text-decoration: none;">Guidelines </ins>for Field and Table names===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Field names must begin with a letter and must only contain letters, numbers, and underscores. No spaces or other characters.</td><td> </td><td style="background: #eee; font-size: smaller;">*Field names must begin with a letter and must only contain letters, numbers, and underscores. No spaces or other characters.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Table names can contain spaces, but the standard is to use underscores instead.</td><td> </td><td style="background: #eee; font-size: smaller;">*Table names can contain spaces, but the standard is to use underscores instead.</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13630&oldid=prevLJ-Bettona: /* First Questions */ typo and syntax replace to with you, add y to variety, delete more2008-03-29T10:44:45Z<p><span class="autocomment">First Questions -</span> typo and syntax replace to with you, add y to variety, delete more</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:44, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 16:</strong></td>
<td colspan="2" align="left"><strong>Line 16:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*How should the data be grouped</td><td> </td><td style="background: #eee; font-size: smaller;">*How should the data be grouped</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Simple linear databases (like the database in ClarisWorks/Appleworks, for example) only allowed you to work with one table or group of data in a data base. This limited what kind of data <del style="color: red; font-weight: bold; text-decoration: none;">to </del>could store and how it could relate. Relational databases like Base (and File Maker Pro and Helix RADE for Classic), allow you to work with multiple tables of relatively independent data that can relate to each other in a <del style="color: red; font-weight: bold; text-decoration: none;">variet </del>of ways. </td><td>+</td><td style="background: #cfc; font-size: smaller;">:Simple linear databases (like the database in ClarisWorks/Appleworks, for example) only allowed you to work with one table or group of data in a data base. This limited what kind of data <ins style="color: red; font-weight: bold; text-decoration: none;">you </ins>could store and how it could relate. Relational databases like Base (and File Maker Pro and Helix RADE for Classic), allow you to work with multiple tables of relatively independent data that can relate to each other in a <ins style="color: red; font-weight: bold; text-decoration: none;">variety </ins>of ways. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Figuring out how to group your data, or what tables you need, is an essential. Think carefully about what data is closely tied together, and what data needs to be independent of other groups (or tables) of data. In a simple database to catalog music, for example, you might want to three groups: Albums (Name, date, etc.), Songs, and Composers. These should be separate because <del style="color: red; font-weight: bold; text-decoration: none;">more </del>an Album contains more than one song, and Composers(or Artists) produce more than one Album.</td><td>+</td><td style="background: #cfc; font-size: smaller;">:Figuring out how to group your data, or what tables you need, is an essential. Think carefully about what data is closely tied together, and what data needs to be independent of other groups (or tables) of data. In a simple database to catalog music, for example, you might want to three groups: Albums (Name, date, etc.), Songs, and Composers. These should be separate because <ins style="color: red; font-weight: bold; text-decoration: none;"> </ins>an Album contains more than one song, and Composers(or Artists) produce more than one Album.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:For the birders journal, the most natural groupings are:</td><td> </td><td style="background: #eee; font-size: smaller;">:For the birders journal, the most natural groupings are:</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13523&oldid=prevLJ-Bettona: /* Finished Planning List for the Birding Database */ consistency of field names2008-03-13T17:36:20Z<p><span class="autocomment">Finished Planning List for the Birding Database -</span> consistency of field names</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 17:36, 13 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 86:</strong></td>
<td colspan="2" align="left"><strong>Line 86:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:City</td><td> </td><td style="background: #eee; font-size: smaller;">:City</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:County</td><td> </td><td style="background: #eee; font-size: smaller;">:County</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:<del style="color: red; font-weight: bold; text-decoration: none;">State/Province </del>(default value to your state)</td><td>+</td><td style="background: #cfc; font-size: smaller;">:<ins style="color: red; font-weight: bold; text-decoration: none;">StateOrProvince </ins>(default value to your state)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Country (default value to your country)</td><td> </td><td style="background: #eee; font-size: smaller;">:Country (default value to your country)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Terrain_Type</td><td> </td><td style="background: #eee; font-size: smaller;">:Terrain_Type</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13496&oldid=prevLJ-Bettona: /* Finished Planning List for the Birding Database */2008-03-08T10:41:52Z<p><span class="autocomment">Finished Planning List for the Birding Database</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:41, 8 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 62:</strong></td>
<td colspan="2" align="left"><strong>Line 62:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Start_Time (time field type)</td><td> </td><td style="background: #eee; font-size: smaller;">:Start_Time (time field type)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:End_Time (time field type)</td><td> </td><td style="background: #eee; font-size: smaller;">:End_Time (time field type)</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Field_Trip_Location (<del style="color: red; font-weight: bold; text-decoration: none;">integer field type, </del>relates to Locations table)</td><td>+</td><td style="background: #cfc; font-size: smaller;">:Field_Trip_Location (relates to Locations table)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Weather</td><td> </td><td style="background: #eee; font-size: smaller;">:Weather</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Wind</td><td> </td><td style="background: #eee; font-size: smaller;">:Wind</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13495&oldid=prevLJ-Bettona: /* Finished Planning List for the Birding Database */ missing field type2008-03-08T10:30:18Z<p><span class="autocomment">Finished Planning List for the Birding Database -</span> missing field type</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:30, 8 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 62:</strong></td>
<td colspan="2" align="left"><strong>Line 62:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Start_Time (time field type)</td><td> </td><td style="background: #eee; font-size: smaller;">:Start_Time (time field type)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:End_Time (time field type)</td><td> </td><td style="background: #eee; font-size: smaller;">:End_Time (time field type)</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Field_Trip_Location (relates to Locations table)</td><td>+</td><td style="background: #cfc; font-size: smaller;">:Field_Trip_Location (<ins style="color: red; font-weight: bold; text-decoration: none;">integer field type, </ins>relates to Locations table)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Weather</td><td> </td><td style="background: #eee; font-size: smaller;">:Weather</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Wind</td><td> </td><td style="background: #eee; font-size: smaller;">:Wind</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Temp (as text so 60s, etc. is allowed)</td><td> </td><td style="background: #eee; font-size: smaller;">:Temp (as text so 60s, etc. is allowed)</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Terrain_Type</td><td colspan="2"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Water_Type</td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Participants</td><td> </td><td style="background: #eee; font-size: smaller;">:Participants</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Comments</td><td> </td><td style="background: #eee; font-size: smaller;">:Comments</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Designing_the_Database_%22On_Paper%22&diff=13491&oldid=prevLJ-Bettona: /* Finished Planning List for the Birding Database */ add two missing fields to Field_Trips Table2008-03-08T08:24:31Z<p><span class="autocomment">Finished Planning List for the Birding Database -</span> add two missing fields to Field_Trips Table</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 08:24, 8 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 66:</strong></td>
<td colspan="2" align="left"><strong>Line 66:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Wind</td><td> </td><td style="background: #eee; font-size: smaller;">:Wind</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Temp (as text so 60s, etc. is allowed)</td><td> </td><td style="background: #eee; font-size: smaller;">:Temp (as text so 60s, etc. is allowed)</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">:Terrain_Type</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">:Water_Type</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Participants</td><td> </td><td style="background: #eee; font-size: smaller;">:Participants</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Comments</td><td> </td><td style="background: #eee; font-size: smaller;">:Comments</td></tr>
</table>LJ-Bettona