Development > DevGuide > Topic

Database Design/#5326

New topicBookmark

May 29, 2007 / xl
Apr 9, 2009 / luchyx
View previous 12 versions
 

Attached files

streber-ERD.png
streber-ERD.png
#5328 by xl, 161k
streber-database.odb
5898 bytes / ID 5329 / May 29, 2007
Show Details
   
 
This page is still a draft. Sooner or later it should give an introduction to strebers database scheme.

Overviewπ

streber-ERD.png

On itemsπ

Most of data elements handled by streber are derived from DbProjectItems: Projects, tasks, comments. Anything related to a project.

These elements are composed of two parts:
  1. The item for common data like Type, access information and dates.
  2. The date from another table like "task", "person" etc.

Tables with itemsπ

projectπ

taskπ

personπ

fileπ

commentπ

effortπ

companyπ

Other tables π

There are a number of other tables with different purposes:

dbπ

This table holds information about the current version of the database scheme. The database version is checked, when directly accessing index.php. If the database scheme is out of data, the installation tries to upgrade automatically.

itemchangeπ

This table holds a list of all changes done to DbProjectItems fields for which log_changes is enabled. The actually logging of difference is quiet complex and needs some further documentation.

see: item_change.inc.php


projectpersonπ

Projectperson joins persons with projects. It defines teams and stores rights of a team member.

taskpersonπ

Assigns a person to a task. The assignment stuff is pretty complex and needs some further documentation.


employmentπ

This table joins persons with companies. It is only used for rendering information in personView and companyView.

issueπ

This table extends the fields of task with information of a bug report (e.g. Version numbers and detailed description of an issue). It the referenced by the issue_report field of the task table.



Also seeπ

As a start you find here an Entity-Relation-Diagram and the Openoffice file i used to create it
(how? see ERD of streber database - xl )


4 Comments

guest:relation pm_task -> pm_project?

5 years ago - Delete

I would like to make some reports with sql.
I just can't see how to get from pm_task to pm_project.
There is a relation via pm_effort, but not all tasks have effort.

Please advise.

Henk van der Meer

luchyx:Why

4 years ago

Why str_tasks doesn't have a project reference column.?

How is the right way to retrieve all tasks for a project?

guest:The same questión...

3 years ago - Delete

Does anybody have an answer for this question?
I can't see how should I get all the tasks related to a a project.

thanks!

luchyx:

3 years ago

maybe pixtur can get some lights on this?

Add Comment