[Xerte] Re: MySQL dbase diagram

[Pat Lockley]

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.
>
>
>