This page is still a draft. Sooner or later it should give an introduction to strebers database scheme.
Overview
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:
- The item for common data like Type, access information and dates.
- 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.phpprojectperson
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 )