RSS feed
]project-open[
emphasizes the posibility to integrate clients and providers into the planning
and execution of projects. However, communication across organizational boundaries
requires special communication means (and skills!), because of the diverging
interestes, cultures etc. of the participating partners. The Task/Incident Tacker
module formalizes the communication related to the distribute of work amongst
project members. It allows to define clear responsabilities withing a project
and to hold project members accountable for the progress or their tasks.
Related Links:
]project-open[ Forums are based around methaphors from "speach act" theory. These metaphors capture the way humans are structuring their communication into Statements, Questions, Commands and Exclamations.
These concepts are represented using the "topic types":
 |
Incident (one-to-one) Somebody needs to resolve an issue. The initiator of the issue does not nessarily know who should resolve the issue and he may be lacking the authority to delegate the task. The asignee can be hold responsible for the resolution of the incident. |
 |
Task (one-to-one) There is a task to be done. The initiator knows who should do the job and has the autority to delegate the task. The asignee can be hold responsible for the completion of the task. |
 |
Discussion (many-to-many) An open (informal) discussion around a subject. There is no predetermined outcome. |
 |
News (one-to-many) Somebody informs a group of people about something. News items may spark discussion later, however. |
 |
Note (one-to-many) Somebody comments on something. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| A sample list of communications related to a project | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
State
Variables
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)
);
]project-open[ Forum
