]project-open[ : @This Wiki

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register


Remote Training
SaaS Service

2 registered users
 in last 24 hours

]po[ Forum Topic

Forums are a way to organize discussions about relevant project issues between project members.  ]project-open[ forums implement the traditional discussion forum, but also utilizes the forum for task assignation, incident notifications and general news postings.   ­


Forum Fields



  • Subject
  • Posted In
  • Posted By­
  • Status
  • Posting Date
  • Priority
  • Assigned To
  • Due Date
  • Visible For
  • Receive Updates
  • Task Body
  • Access Permissions


The datastructures for ]po[ Forums really look like the ones for a mail reader with topics (the messages) and a mapping between topics and users (im_forum_topic_user_map) to store whether a user has read a topic or filed the topic in one of his folders.  

create table im_forum_topics (
        -- administrative information
        topic_id        integer
                        constraint im_forum_topics_pk primary key,
        topic_name      varchar(200),
        topic_path      varchar(200),
        object_id       integer not null
                        constraint im_forum_topics_object_fk
                        references acs_objects,
        parent_id       integer
                        constraint im_forum_topics_parent_fk
                        references im_forum_topics,
        topic_type_id   integer not null
                        constraint im_forum_topics_type_fk
                        references im_categories,
        topic_status_id integer
                        constraint im_forum_topics_status_fk
                        references im_categories,
        posting_date    date,
        owner_id        integer not null
                        constraint im_forum_topics_owner_fk
                        references users,
        scope           varchar(20) default 'group'
                        constraint im_forum_topics_scope_ck
                        check (scope in ('pm', 'group','public','client','staff','not_client')),
        -- message content
        subject         varchar(200) not null,
        message         clob,
        -- task and incident specific fields
        priority        number(1),
        due_date        date,
        asignee_id      integer
                        constraint im_forum_topics_asignee_fk
                        references users

create table im_forum_topic_user_map (
        topic_id        integer
                        constraint im_forum_topics_um_topic_fk
                        references im_forum_topics,
        user_id         integer
                        constraint im_forum_topics_um_user_fk
                        references users,
        -- read_p in ('f' or NULL) indicates "New" items
        read_p          char(1) default 't'
                        constraint im_forum_topics_um_read_ck
                        check (read_p in ('t','f')),
        -- folder_id in (0 or NULL) indicates "Inbox" items
        -- folder_id = 1 indicates "Deleted" items
        -- folder_id for users start with 10
        folder_id       integer default 0
                        constraint im_forum_topics_um_folder_fk
                        references im_forum_folders,
        receive_updates varchar(20) default 'major'
                        constraint im_forum_topics_um_rec_ck check (
                        receive_updates in ('all','none','major')),
        constraint im_forum_topics_um_rec_pk
        primary key (topic_id, user_id)

create table im_forum_folders (
        folder_id       integer
                        constraint im_forum_folders_pk
                        primary key,
        user_id         integer
                        constraint im_forum_folders_user_fk
                        references users,
        parent_id       integer
                        constraint im_forum_folders_parent_fk
                        references im_forum_folders,
        folder_name     varchar(200)




Related Help

Related Tutorials

Related Object Types

Related Packages

Related Modules

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

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


Demo Server
Modules & Functionality
Business Processes supported


Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support


RSS Community / Sourceforge
Register for Newsletter

Get in touch


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