<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-CA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thank you Tom, Pat, Ron and others for this additional dbase info!<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>RonM2<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> xerte-bounces@lists.nottingham.ac.uk [mailto:xerte-bounces@lists.nottingham.ac.uk] <b>On Behalf Of </b>Tom Reijnders<br><b>Sent:</b> Monday, June 27, 2011 12:06 AM<br><b>To:</b> Xerte discussion list<br><b>Subject:</b> [Xerte] Re: MySQL dbase diagram<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>You can do a similar thing with the latest MySQL Workbench (free download from MySQL)<br>You basically create a new model by reverse engineering an existing database. As the XOT database doesn't conatin the actual foreign key definitions, it doesn't draw the (implied) releationships. <br><br>I added my understanding of them in the diagram attached.<br><br>Tom<br><br>Op 26-6-2011 12:29, Ron Mitchell schreef: <o:p></o:p></p><pre>There's a download from code.google which creates a diagram from a sql<o:p></o:p></pre><pre>export <a href="http://code.google.com/p/database-diagram/">http://code.google.com/p/database-diagram/</a> doesn't draw any<o:p></o:p></pre><pre>relationship lines but they could be added in an image editor and might<o:p></o:p></pre><pre>compliment Pat's list. See attached screenshot saved as a jpg.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>HTH<o:p></o:p></pre><pre>Ron<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>-----Original Message-----<o:p></o:p></pre><pre>From: <a href="mailto:xerte-bounces@lists.nottingham.ac.uk">xerte-bounces@lists.nottingham.ac.uk</a><o:p></o:p></pre><pre>[<a href="mailto:xerte-bounces@lists.nottingham.ac.uk">mailto:xerte-bounces@lists.nottingham.ac.uk</a>] On Behalf Of Pat Lockley<o:p></o:p></pre><pre>Sent: 26 June 2011 08:33<o:p></o:p></pre><pre>To: Xerte discussion list<o:p></o:p></pre><pre>Subject: [Xerte] Re: MySQL dbase diagram<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>No problem. I know it's not quite diagrammatic but I think the text does<o:p></o:p></pre><pre>enough?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>On 26 Jun 2011, at 02:51, "KnowledgeWare" <a href="mailto:knowledgeware@kccsoft.com"><knowledgeware@kccsoft.com></a> wrote:<o:p></o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>Thanks Pat! Very useful...I'll pour over it later this week.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>RonM2<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>-----Original Message-----<o:p></o:p></pre><pre>From: <a href="mailto:xerte-bounces@lists.nottingham.ac.uk">xerte-bounces@lists.nottingham.ac.uk</a><o:p></o:p></pre><pre>[<a href="mailto:xerte-bounces@lists.nottingham.ac.uk">mailto:xerte-bounces@lists.nottingham.ac.uk</a>] On Behalf Of Pat Lockley<o:p></o:p></pre><pre>Sent: Saturday, June 25, 2011 4:22 PM<o:p></o:p></pre><pre>To: Xerte discussion list<o:p></o:p></pre><pre>Subject: [Xerte] Re: MySQL dbase diagram<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre></blockquote><pre><a href="https://docs.google.com/document/pub?id=1wvpQ-COyylzsV65yBIOKMRzjmkff-xKtAE9">https://docs.google.com/document/pub?id=1wvpQ-COyylzsV65yBIOKMRzjmkff-xKtAE9</a><o:p></o:p></pre><pre> <o:p></o:p></pre><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>UMNeJZ6o<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>crude document<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Not sure this suits the ZIP<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Maybe a developers zip?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Xerte mailing list<o:p></o:p></pre><pre><a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><o:p></o:p></pre><pre><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><o:p></o:p></pre><pre><o:p> </o:p></pre><pre>This message and any attachment are intended solely for the addressee and<o:p></o:p></pre><pre> <o:p></o:p></pre></blockquote><pre>may contain confidential information. If you have received this message in<o:p></o:p></pre><pre>error, please send it back to me, and immediately delete it. Please do not<o:p></o:p></pre><pre>use, copy or disclose the information contained in this message or in any<o:p></o:p></pre><pre>attachment. Any views or opinions expressed by the author of this email do<o:p></o:p></pre><pre>not necessarily reflect the views of the University of Nottingham.<o:p></o:p></pre><pre> <o:p></o:p></pre><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre><o:p> </o:p></pre><pre>This message has been checked for viruses but the contents of an<o:p></o:p></pre><pre> <o:p></o:p></pre></blockquote><pre>attachment<o:p></o:p></pre><pre> <o:p></o:p></pre><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>may still contain software viruses which could damage your computer<o:p></o:p></pre><pre> <o:p></o:p></pre></blockquote><pre>system:<o:p></o:p></pre><pre> <o:p></o:p></pre><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>you are advised to perform your own checks. Email communications with the<o:p></o:p></pre><pre>University of Nottingham may be monitored as permitted by UK legislation.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre></blockquote><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Xerte mailing list<o:p></o:p></pre><pre><a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><o:p></o:p></pre><pre><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><o:p></o:p></pre><pre> <o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Xerte mailing list<o:p></o:p></pre><pre><a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><o:p></o:p></pre><pre><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><o:p></o:p></pre><pre><o:p> </o:p></pre><pre>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>This message has been checked for viruses but the contents of an attachment<o:p></o:p></pre><pre>may still contain software viruses which could damage your computer system:<o:p></o:p></pre><pre>you are advised to perform your own checks. Email communications with the<o:p></o:p></pre><pre>University of Nottingham may be monitored as permitted by UK legislation.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><p class=MsoNormal><br><br><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre>--<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Tom Reijnders<o:p></o:p></pre><pre>TOR Informatica<o:p></o:p></pre><pre>Chopinlaan 27<o:p></o:p></pre><pre>5242HM Rosmalen<o:p></o:p></pre><pre>Tel: 073 5226191<o:p></o:p></pre><pre>Fax: 073 5226196<o:p></o:p></pre><pre><o:p> </o:p></pre></div></body></html>