[Xerte] Re: MySQL dbase diagram

[Tom Reijnders]

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"<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/44fbbc8a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dbase_diagram.pdf
Type: application/pdf
Size: 166294 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20110627/44fbbc8a/attachment-0001.pdf>