]po[ Core GUI Tables

The following tables deal with the ]po[ GUI:

  • DynViews define the columns and layout of ]po[ list pages
  • Categories define the values of drop-down boxes
  • Component Plugins define the information presented in object view pages
  • Menus define the Menu tabs, the list of reports and other links in the system.

 


Table

Cols

Rows

Description

[im_biz_objects]

1

149

Business Objects are the super-class of all important ]po[ objects. Biz object define a generic URL for accessing the object and allow ]po[

[im_biz_object_urls]

3

44

Defines two URLs for each object type for displaying an object read-only ("display") or in edit mode. Just append the object_id of the object to the end of these URLs and you have a valid URL.

[im_categories]

12

602

Defines the values of drop-down boxes in most of ]po[. Categories keep a vast number of object states, object types and other information that is usually kept in separate tables each.
Keeping all this information in a single table simplifies configuration and allows for more sophisticated features.

[im_category_hierarchy]

2

150

Defines an is-a hierarchy on categories with "multiple inheritance". This table contains a "transitive closure" of the is-a relationship.

[im_component_plugin_user_map]

5

1314

This table maps Component Plugins to particular users, effectively allowing users to customize their GUI layout.

[im_component_plugins]

12

100

Components Plugins are handeled in the database in order to allow customizations to survive system updates.

[im_menus]

13

171

Menus represent menu tabs in the GUI, but also implements the list of reports and other links in the system.

[im_profiles]

2

14

Profiles are groups used for user "Profiles" in ]po[. Profile is a sub-type of group.

[im_start_months]

3

231

Not used anymore.

[im_start_weeks]

3

1000

Not used anymore.

[im_view_columns]

11

775

Defines the columns for each DynView

[im_views]

7

74

DynView represent the columns in a list page. This way it is possible to extend the view with information during system runtime (when installing a new package).

  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