]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

3 registered users
 in last 24 hours

]po[ Core Objects Tables

These tables are the core of ]project-open[.

  ­

­ 

Table

Cols

Rows

Description

[im_biz_object_members]

3

955

Defines a relationship between business objects and users, representing an is-member-of relationship.

[im_biz_object_role_map]

3

11

Defines the type of relationships available for each object type. For example, companies may have "Key Account Managers", while projects may have "Project Managers".

[im_companies]

34

39

Companies represent "legal persons" identified by their VAT/TAX number. The address information of companies is stored in their respective main office.

[im_company_employee_rels]

1

109

Special relationship between a user and a company, if the user is an employee of the company.

[im_emp_checkpoint_checkoffs]

5

0

Information on users having reached recruiting checkpoints. Not used in ]po[ currently.

[im_employee_checkpoints]

3

0

Checkpoints for the employee recrutingn pipeline. Not used in ]po[ currently.

[im_employees]

36

211

Extension for the persons table to keep information specific to employees.

[im_key_account_rels]

1

83

Special relationship between a user and a company, if the user is the key account manager of the company.

[im_offices]

19

84

Offices represent physical venues of companies. A company can have one or more offices.

[im_projects]

54

235

Projects represent one-time work units, containing both operational (tasks, ...) and financial information.

[im_projects_audit]

38

4

Audit table for im_projects - records changes in im_projects if the audit package is installed. The audit information allows to track the degree of project completion vs. resource consumption.

[project_approval_wf_cases]

1

0

Instances of the default Project approval workflow.

[users_contact]

34

192

Extension tables of persons. Contains address information of natural persons.


Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy