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