[Xerte] Re: MySQL dbase diagram

[Pat Lockley]

all correct bar it's template name from originaltemplatedetails which
makes the folder name on the system, not template name from template
details

On Sun, Jun 26, 2011 at 11:16 PM, KnowledgeWare
<knowledgeware at kccsoft.com> wrote:
> Thanks Ron and Pat for that info/diagrams. I've attached a png diagram of a
> few core tables to this message, hope it comes through.
>
> I'm trying to understand the database design. I think I understand all in
> the attached png image except am not clear on 'templaterights' (does it
> restrict users only to their own templates?) and 'folderdetails'. Is this
> the 'USER-FILES' folders that are created?
>
> I don't think so.since the table contains 'recycle' bins etc.I'm wondering
> where those items are physically located?
>
> Is there any info on the chronological 'flow' (I can get my head around
> that, usually) of how the tables are populated and by what user action, and
> what happens when deletions in the database occurs, etc (I mean what tables
> have rows deleted and what folders physically remove files?).
>
> I've imported the dbase to SQL Server just because it's easier for me to
> work with that (but I'm no DBA!). Just wondering...is anyone running
> straight off SQL Server (instead of MySQL) or is this a real dumb idea?
>
> Thanks
> RonM2
>
> 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.
>
>
>