<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
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:
<blockquote cite="mid:001c01cc33eb$e897b7d0$b9c72770$@co.uk" type="cite">
<pre wrap="">There's a download from code.google which creates a diagram from a sql
export <a class="moz-txt-link-freetext" href="http://code.google.com/p/database-diagram/">http://code.google.com/p/database-diagram/</a> doesn't draw any
relationship lines but they could be added in an image editor and might
compliment Pat's list. See attached screenshot saved as a jpg.
HTH
Ron
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:xerte-bounces@lists.nottingham.ac.uk">xerte-bounces@lists.nottingham.ac.uk</a>
[<a class="moz-txt-link-freetext" href="mailto:xerte-bounces@lists.nottingham.ac.uk">mailto:xerte-bounces@lists.nottingham.ac.uk</a>] On Behalf Of Pat Lockley
Sent: 26 June 2011 08:33
To: Xerte discussion list
Subject: [Xerte] Re: MySQL dbase diagram
No problem. I know it's not quite diagrammatic but I think the text does
enough?
On 26 Jun 2011, at 02:51, "KnowledgeWare" <a class="moz-txt-link-rfc2396E" href="mailto:knowledgeware@kccsoft.com"><knowledgeware@kccsoft.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Thanks Pat! Very useful...I'll pour over it later this week.
RonM2
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:xerte-bounces@lists.nottingham.ac.uk">xerte-bounces@lists.nottingham.ac.uk</a>
[<a class="moz-txt-link-freetext" href="mailto:xerte-bounces@lists.nottingham.ac.uk">mailto:xerte-bounces@lists.nottingham.ac.uk</a>] On Behalf Of Pat Lockley
Sent: Saturday, June 25, 2011 4:22 PM
To: Xerte discussion list
Subject: [Xerte] Re: MySQL dbase diagram
</pre>
</blockquote>
<pre wrap=""><a class="moz-txt-link-freetext" href="https://docs.google.com/document/pub?id=1wvpQ-COyylzsV65yBIOKMRzjmkff-xKtAE9">https://docs.google.com/document/pub?id=1wvpQ-COyylzsV65yBIOKMRzjmkff-xKtAE9</a>
</pre>
<blockquote type="cite">
<pre wrap="">UMNeJZ6o
crude document
Not sure this suits the ZIP
Maybe a developers zip?
_______________________________________________
Xerte mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a>
<a class="moz-txt-link-freetext" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a>
This message and any attachment are intended solely for the addressee and
</pre>
</blockquote>
<pre wrap="">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.
</pre>
<blockquote type="cite">
<pre wrap="">
This message has been checked for viruses but the contents of an
</pre>
</blockquote>
<pre wrap="">attachment
</pre>
<blockquote type="cite">
<pre wrap="">may still contain software viruses which could damage your computer
</pre>
</blockquote>
<pre wrap="">system:
</pre>
<blockquote type="cite">
<pre wrap="">you are advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
Xerte mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a>
<a class="moz-txt-link-freetext" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a>
</pre>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Xerte mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a>
<a class="moz-txt-link-freetext" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a>
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.
This message has been checked for viruses but the contents of an attachment
may still contain software viruses which could damage your computer system:
you are advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
--
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
</pre>
</body>
</html>