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

  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com