[Xerte] Re: MySQL dbase diagram

[Tom Reijnders]

Like this?

Op 27-6-2011 9:39, Pat Lockley schreef:
> i thnink play_security_details is only linked to access_to_whom in
> templatedetails
>
> On Mon, Jun 27, 2011 at 8:05 AM, Tom Reijnders<reijnders at tor.nl>  wrote:
>    
>> 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
>>
>>
>> _______________________________________________
>> 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
>
>    

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196


-------------- next part --------------
A non-text attachment was scrubbed...
Name: dbase_diagram_v2.pdf
Type: application/pdf
Size: 178144 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20110627/13e5ac85/attachment-0001.pdf>