[Xerte] Re: MySQL dbase diagram

[KnowledgeWare]

Thank you Tom, Pat, Ron and others for this additional dbase info!

 

RonM2

 

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Tom Reijnders
Sent: Monday, June 27, 2011 12:06 AM
To: Xerte discussion list
Subject: [Xerte] Re: MySQL dbase diagram

 

You can do a similar thing with the latest MySQL Workbench (free download
from MySQL)
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. 

I added my understanding of them in the diagram attached.

Tom

Op 26-6-2011 12:29, Ron Mitchell schreef: 

There's a download from code.google which creates a diagram from a sql
export http://code.google.com/p/database-diagram/ 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: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] 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"
<mailto:knowledgeware at kccsoft.com> <knowledgeware at kccsoft.com> wrote:
 
  

Thanks Pat! Very useful...I'll pour over it later this week.
 
RonM2
 
 
 
-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
Sent: Saturday, June 25, 2011 4:22 PM
To: Xerte discussion list
Subject: [Xerte] Re: MySQL dbase diagram
 
 
    

https://docs.google.com/document/pub?id=1wvpQ-COyylzsV65yBIOKMRzjmkff-xKtAE9
  

UMNeJZ6o
 
crude document
 
Not sure this suits the ZIP
 
Maybe a developers zip?
 
 
 
 
_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte
 
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.
 
    

 
_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte
  
 
 
_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte
 
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.
 
  





-- 
--
 
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20110627/25bf84f1/attachment.html>