[Xerte] Re: MySQL dbase diagram

[Tom Reijnders]

Ehmm... yes. But regrettably that cannot be modelled in this tool. It is 
either '1 to 1' or '1 to n', so maybe it is best to make it '1 to n' (or 
edit the diagram by hand)

Tom

Op 27-6-2011 10:13, Pat Lockley schreef:
> 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.
>>
>>
>>
>>      
> _______________________________________________
> 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