Database structure |
| Tables |
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 |