@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.

­

• OpenACS Bug-Tracker Tables - The OpenACS bug-tracker (not used anymore in ]po[)
  
• OpenACS Calendar Tables - The OpenACS calendar.
  
• OpenACS Content Repository Tables - Content repository stores multimedia objecs.
  
• OpenACS Localization Tables - The localization subsystem.
  
• OpenACS Mail Tables - Sending and receiving multi-part MIME mails
  
• OpenACS Notifications Table - Notification publish-subscribe system
  
• OpenACS Object Tables - The core of OpenACS
  
• OpenACS Other Tables
• OpenACS Package Manager Tables - Package meta-information, parameters & site-map.
  
• OpenACS Permission Tables - The OpenACS permission system
  
• OpenACS Relationship Tables - Relationships between objecs, including constraints.
  
• OpenACS Service Contract Tables - OpenACS publish-subscribe event system & interfaces
  
• OpenACS Status Engine Tables - OpenACS Status Engine ("Workflow")
  
• OpenACS Users & Groups - OpenACS Groups, Users and related tables.