[Xerte] Re: MySQL dbase diagram

[Pat Lockley]

yeah, now looking

does additional sharing having two entries (max) for each template
mean it's 1->2 not 1->1?

On Mon, Jun 27, 2011 at 9:07 AM, Tom Reijnders <reijnders at tor.nl> wrote:
> 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
>
>
>
> _______________________________________________
> 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.
>
>
>