Re: [Publex-developers] Databse

[PubleX Developer's M. L. <pub...@li...>]

The tables look pretty accurate.  That should work for our needs.  We will
need a few additional fields in the Document and Users tables, but I'm sure
you took that into consideration.

In regards to the class responsible for creating a project, this will need
to reside in PubleX.Core so that the server component may access it.  The
server component will actually be responsible for physically creating the
documents and database entries.  What the user does will only be an
interface implemented in PDE.  Otherwise, you are correct.  These classes do
need to be implemented.

The PubleX.PDE.Document class is actually one of the first classes written
in the project.  It was originally going to be used for an individual XML
file to keep track of all associated files (graphics, style sheets, etc).
Most of this will still need to be implemented in the Document class, but
this class may also need a way to communicate with the SQL server class to
send the appropriate requests (checking-out/checking-in/link updates/etc).

Jason

On 2/2/07, PubleX Developer's Mailing List <
pub...@li...> wrote:
>
> Hi,
>
> I've been busy for the last few days (end of semester, exams, etc..).
> But now I'm back :) and I have a question about DB part of publex.
>
>
> The database of every project will contain at least 3 tables:
>
> 1) TbProject
>     - PName
>     - PUsers (form TbUsers)
>     - PDocuments (from TbDocument)
>     - other fields (start date, end date, chapters, ..)
>
> 2) TbUsers
>     - UName
>     - ULevel
>     - UProject (from TbProject)
>
>       ULevel:
>           - PM
>           - ProjectEditor
>           - PublicationControl
>
> 3) TbDocument
>     - DName
>     - DProject (from TbProject)
>     - DChapter
>     ... - document contents..
>
> It's obvious that we need some classes describing our project structure.
> There is one class: PubleX.PDE.Document but it does not have all the
> fields needed by db. When Publex user creates new project the program
> should crate the project structure with chapters, asigned users, users
> tasks,.. And this functionality does not belong to the Publex.Core.DB
> part. Am I right? Do we need to create this classes inside PubleX.PDE ??
>
> Regards,
> harnas
>