Database structure
Tables
Name Column Comment
GR_CATEGORY
This table stores the task categories definitions.
GR_FILTER
Stores filters information
GR_FVALUE
Stores information about filter conditions
GR_MESSAGE
This table stores message properties.
GR_MPRSTATUS
This table establishes what the given group of users can do with the given transition.
GR_MSTATUS
This table stores the message status.
GR_PRSTATUS
User groups.
For example:
- Customer
- Manager
- Programmer
- The external user (to view the bug lists).
Each group can have a set of roles.
GR_PRUSER
This table is stores information about which users what functions carry out in projects.
GR_RESOLUTION
Task resolution
- fixed
- not a bug
- suspented
- not fixable
GR_ROLE
This table stores available user rights
GR_ROLESTATUS
This table stores conformity between rights and user groups.
GR_STATUS
This table stores Task status.
GR_SUBSCRIBER
Stores information about filter subscribers and subscription details
GR_TASK
This table stores Task properties.
GR_TRANSITION
This table stores information about transitions between status in workflow
GR_UDF
This table stores information about UDF (User-Defined Fields) properties.
GR_UDFLIST
This table contains elements of UDF's of a list datatype
GR_UDFSOURCE
This table stores for which user and which task UDF is active
GR_UDFVAL
This table stores UDF values
GR_USER
Stores users and their properties

GR_WORKFLOW
This table stores information about which workflow belongs to which task.
Column(s) of "GR_CATEGORY" Table
Name Datatype
Null Option
Comment
category_id VARCHAR(32)
NOT NULL
Category identifier.
Primary key
category_name VARCHAR(40) NULL
Category name
category_workflow VARCHAR(32)
NOT NULL
Parent workflow of the category
category_task VARCHAR(32)
NOT NULL
Parent category task
Column(s) of "GR_FILTER" Table
Name Datatype
Null Option
Comment
filter_id VARCHAR(32)
NOT NULL
Filter identifier
filter_name VARCHAR(40) NULL
Name of the filter
filter_description VARCHAR(4000) NULL
Filter description
filter_active INTEGER NULL Reserved
filter_priv INTEGER NULL
Defines, private filter or not - if private, than this filter can be used only by it owner
filter_task VARCHAR(32)
NOT NULL
Task to filter
filter_owner VARCHAR(32)
NOT NULL
User that have created filter
Column(s) of "GR_FVALUE" Table
Name Datatype
Null Option
Comment
fvalue_id VARCHAR(32)
NOT NULL
Filter condition identifier
fvalue_filter VARCHAR(32)
NOT NULL
Filter-owner of this condition
fvalue_key VARCHAR(40) NULL
Filter field
fvalue_value VARCHAR(4000) NULL
Value of the filter's field
Column(s) of "GR_MESSAGE" Table
Name Datatype
Null Option
Comment
message_id VARCHAR(32)
NOT NULL
Message identifier
message_description VARCHAR(4000) NULL
Message description
message_pruser VARCHAR(32)
NOT NULL
Project user identifier
message_time DATE NULL
Date and tme of a message
message_mstatus VARCHAR(32)
NOT NULL
Message status
message_hrs NUMBER(10,2) NULL
Time in hours spent on a work, describing current message
message_handler VARCHAR(32) NULL
Message handler
message_resolution VARCHAR(32) NULL
Message resolution
Column(s) of "GR_MPRSTATUS" Table
Name Datatype
Null Option
Comment
mprstatus_id VARCHAR(32)
NOT NULL
Identifier
mprstatus_type VARCHAR(40) NULL
The type defines variants:
1) P:PROCESS - user from prstatus group can execute this transition
2) A:HANDLER - user from prstatus group can be next handler
3) M:MAIL - user from prstatus group will receive the email notification.
mprstatus_mstatus VARCHAR(32)
NOT NULL
Message status
mprstatus_prstatus VARCHAR(32)
NOT NULL
Role
Column(s) of "GR_MSTATUS" Table
Name Datatype
Null Option
Comment
mstatus_id VARCHAR(32)
NOT NULL
Message status identifier
mstatus_name VARCHAR(2000) NULL
Status name
mstatus_description VARCHAR(2000) NULL
Status description
mstatus_workflow VARCHAR(32)
NOT NULL
Workflow-owner of current message status
Column(s) of "GR_PRSTATUS" Table
Name Datatype
Null Option
Comment
prstatus_id VARCHAR(32)
NOT NULL
User role in current project
prstatus_name VARCHAR(40) NULL
Name of the status
prstatus_user VARCHAR(32)
NOT NULL
Status owner
prstatus_priv INTEGER NULL
Specifies current status is private or not
Column(s) of "GR_PRUSER" Table
Name Datatype
Null Option
Comment
pruser_id VARCHAR(32)
NOT NULL
Project user identifier
pruser_task VARCHAR(32)
NOT NULL
Task
pruser_user VARCHAR(32)
NOT NULL
User
pruser_acl INTEGER NULL
If this field is "1" then current user have rights on this task
pruser_filter VARCHAR(32)
NOT NULL
Default filter for the current task and user
Column(s) of "GR_RESOLUTION" Table
Name Datatype
Null Option
Comment
resolution_id VARCHAR(32)
NOT NULL
Resolution identifier
resolution_name VARCHAR(40) NULL
Name of the resolution
resolution_mstatus VARCHAR(32)
NOT NULL
Resolution message status
Column(s) of "GR_ROLE" Table
Name Datatype
Null Option
Comment
role_id VARCHAR(32)
NOT NULL
Role identifier
role_name VARCHAR(40) NULL
Name of the role
role_description VARCHAR(4000) NULL
Role description
Column(s) of "GR_ROLESTATUS" Table
Name Datatype
Null Option
Comment
rolestatus_id VARCHAR(32)
NOT NULL
Role status identifier
rolestatus_prstatus VARCHAR(32)
NOT NULL
User status in the project
rolestatus_role VARCHAR(32)
NOT NULL
Role-owner of the current status
Column(s) of "GR_STATUS" Table
Name Datatype
Null Option
Comment
status_id VARCHAR(32)
NOT NULL
Status identifier
status_name VARCHAR(40) NULL
Status name
status_type VARCHAR(40) NULL
Type of the status
status_workflow VARCHAR(32)
NOT NULL
Parent status workflow
status_color VARCHAR(40) NULL
Color that corresponds to current status
Column(s) of "GR_SUBSCRIBER" Table
Name Datatype
Null Option
Comment
subscriber_id VARCHAR(32)
NOT NULL
Subscriber Identifier
subscriber_user VARCHAR(32)
NOT NULL
User-subscriber
subscriber_filter VARCHAR(32)
NOT NULL
Subscription filter
subscriber_task VARCHAR(32)
NOT NULL
Subscription task
subscriber_sendonempty INTEGER NULL
Defines, send or not notification messages if filter results are empty
subscriber_startdate DATE NULL
Starting date of notification sending
subscriber_stopdate DATE NULL
Final date of notification sending
subscriber_nextrun DATE NULL
Next date when filter should be executed
subscriber_interval INTEGER NULL
Interval in minutes to execute filter
Column(s) of "GR_TASK" Table
Name Datatype
Null Option
Comment
task_id VARCHAR(32)
NOT NULL
Task identifier
task_shortname VARCHAR(40) NULL
Short name (alias) of the task
task_name VARCHAR(160)
NOT NULL
Task name
task_submitdate DATE NULL
Date when task was submitted
task_updatedate DATE NULL
Date when task was last updated
task_closedate DATE NULL
Date when task was closed
task_description VARCHAR2(4000) NULL
Task description
task_abudget NUMBER(10,2) NULL
Task actual budget - total time spent (in hours) on a task
task_budget NUMBER(10,2) NULL
Task budget - time in hours reserved for a task.
task_deadline DATE NULL
Task deadline - final date when task must be done
task_category VARCHAR(32)
NOT NULL
Category of a task
task_status VARCHAR(32)
NOT NULL
Current task status
task_resolution VARCHAR(32)
NOT NULL
Task resolution
task_priority INTEGER NULL
Task priority
task_submitter VARCHAR(32) NULL
User that have submit the current task
task_handler VARCHAR(32) NULL
Current task handler
task_parent VARCHAR(32) NULL
Parent task
Column(s) of "GR_TRANSITION" Table
Name Datatype
Null Option
Comment
transition_id VARCHAR(32)
NOT NULL
Transition identifier
transition_start VARCHAR(32)
NOT NULL
Defines, that current transition is start transition in workflow, or not.
transition_finish VARCHAR(32)
NOT NULL
Defines, that current transition is final transition in workflow, or not.
transition_mstatus VARCHAR(32)
NOT NULL
Message when current transition executing
Column(s) of "GR_UDF" Table
Name Datatype
Null Option
Comment
udf_id VARCHAR(32)
NOT NULL
UDF identifier
udf_caption VARCHAR(4000) NULL
UDF caption
udf_order INTEGER NULL
The order, in which current UDF will be displayed among the others
udf_def VARCHAR(4000) NULL
UDF description
udf_required INTEGER NULL
Specifies, current UDF is required or not
udf_type INTEGER NULL
UDF datatype
0 - string
1 - num
2 - date
3 - list
udf_visible INTEGER NULL
UDF visible in task caption or not
udf_mail INTEGER NULL
Include this field in email notification or not
1 - include in email
0 - not include in email
udf_udfsource VARCHAR(32)
NOT NULL
Link to user and task in UDFSOURCE table
Column(s) of "GR_UDFLIST" Table
Name Datatype
Null Option
Comment
udflist_id VARCHAR(32)
NOT NULL
UDF list identifier
udflist_val VARCHAR(20) NULL
Name of the element in the list
udflist_order INTEGER NULL
Order in which current element will be displayed
udflist_udf VARCHAR(32)
NOT NULL
UDF to which this list element is corresponds
Column(s) of "GR_UDFSOURCE" Table
Name Datatype
Null Option
Comment
udfsource_id VARCHAR(32)
NOT NULL
UDF source identifier
udfsource_task VARCHAR(32) NULL
Task-source of UDF
udfsource_user VARCHAR(32) NULL
User that have created UDF
Column(s) of "GR_UDFVAL" Table
Name Datatype
Null Option
Comment
udfval_id VARCHAR(32)
NOT NULL
UDF value identifier
udfval_str VARCHAR(4000) NULL
Specifies that current UDF is of a string type, if not empty
udfval_num NUMBER NULL
Specifies that current UDF is of a numeric type, if not empty
udfval_dat DATE NULL
Specifies that current UDF is of a datetime type, if not empty
udfval_udflist VARCHAR(32) NULL
Specifies that current UDF is of a list type, if not empty, and corresponds to the list in UDFLIST
udfval_udf VARCHAR(32)
NOT NULL
UDF which current value corresponds to
udfval_udfsource VARCHAR(32)
NOT NULL
UDF source which current value corresponds to
Column(s) of "GR_USER" Table
Name Datatype
Null Option
Comment
user_id VARCHAR(32)
NOT NULL
User Identifier.
user_login VARCHAR(40)
NOT NULL
User login
user_password VARCHAR(40) NULL
User Password (Encrypted)
user_name VARCHAR(40)
NOT NULL
User Name
user_tel VARCHAR(40) NULL
User telephone number
user_email VARCHAR(40) NULL
User email address
user_smsmail VARCHAR(40) NULL
User email-to-sms address
user_active INTEGER NULL Reserved
user_prstatus VARCHAR(32)
NOT NULL
User status in the project (Group with the set of rights which user belongs to)
user_service VARCHAR(4000) NULL
Additional user abilities
user_locale VARCHAR(20) NULL
User locale
user_timezone VARCHAR(20) NULL
User timezone
user_last_visited DATE NULL
Date, when the user last time visited GranPM
user_child_allowed INTEGER NULL
Defines user ability to create child users
user_manager VARCHAR(32) NULL
Manager (parental user) of the current user
Column(s) of "GR_WORKFLOW" Table
Name Datatype
Null Option
Comment
workflow_id VARCHAR(32)
NOT NULL
Workflow identifier
workflow_name VARCHAR(40) NULL
Workflow name
workflow_task VARCHAR(32)
NOT NULL
Parent workflow task