@Tables Overview
This page provides a list of all tables used in ]po[ grouped by funcitional area.
]project-open[ Tables
The following tables are part of the ]po[ system and contain the business objects of ]po[.
- Core GUI Tables - Menus, Portlet Components and auxillary tables.
- Core Objects Tables - Companies, Projects and Users
- DynField Tables - SQL Metadata model to extend objects with custom fields
- Filestorage Tables - Filestorage - associating files with projects, companies and users.
- Financial Tables - Financials: Expenses, Financial Documents, Cost Centers etc.
- Forum Tables - Discussion forum associated with projects, companies and users.
- Full-Text Search Tables - Full-Text index of all important objects.
- Gantt & Timesheet Tables - Project tasks, Gantt integration, time sheet and absences.
- Helpdesk & ITSM Tables - Helpdesk, configuration database & release management.
- Reporting Tables - Reports, indicators and data-warehouse cubes
- Simple Survey Tables - Surveys associated with projects, companies and users.
- Skill & Freelance Tables - Skill management, freelance information and RFQs
- Translation Tables - Translation tasks, translation prices and translation quality.
- Workflow Tables - Tables for the Petri-Net workflow.
OpenACS Tables
The following tables are part of the OpenACS platform. They usually keep system information that is not visible to the normal user.