Contains activities on issues
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | BIGINT | ActivityId | X | X | ID generated via IDBROKER | |||
| ISSUE_ID | BIGINT | IssueId | X | X | ||||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | ||||
| TRANSACTION_ID | BIGINT | TransactionId | X | X | ||||
| OLD_NUMERIC_VALUE | INTEGER | OldNumericValue | ||||||
| NEW_NUMERIC_VALUE | INTEGER | NewNumericValue | ||||||
| OLD_USER_ID | INTEGER | OldUserId | X | |||||
| NEW_USER_ID | INTEGER | NewUserId | X | |||||
| OLD_OPTION_ID | INTEGER | OldOptionId | X | |||||
| NEW_OPTION_ID | INTEGER | NewOptionId | X | |||||
| OLD_VALUE | LONGVARCHAR | OldValue | ||||||
| NEW_VALUE | LONGVARCHAR | NewValue | ||||||
| DEPEND_ID | INTEGER | DependId | X | |||||
| DESCRIPTION | VARCHAR | (255) | Description | |||||
| END_DATE | DATE | EndDate | ||||||
| ATTACHMENT_ID | BIGINT | AttachmentId | X | |||||
| ACTIVITY_TYPE | VARCHAR | (30) | ActivityType |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ATTACHMENT_ID | BIGINT | AttachmentId | X | X | ||||
| ISSUE_ID | BIGINT | IssueId | X | |||||
| ATTACHMENT_TYPE_ID | INTEGER | TypeId | X | X | ||||
| ATTACHMENT_NAME | VARCHAR | (255) | Name | X | ||||
| ATTACHMENT_DATA | LONGVARCHAR | Data | ||||||
| ATTACHMENT_FILE_PATH | VARCHAR | (255) | FileName | |||||
| ATTACHMENT_MIME_TYPE | VARCHAR | (255) | MimeType | X | ||||
| MODIFIED_BY | INTEGER | ModifiedBy | X | |||||
| CREATED_BY | INTEGER | CreatedBy | X | |||||
| MODIFIED_DATE | TIMESTAMP | ModifiedDate | ||||||
| CREATED_DATE | TIMESTAMP | CreatedDate | ||||||
| DELETED | INTEGER | 0 | Deleted |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ATTACHMENT_TYPE_ID | INTEGER | AttachmentTypeId | X | X | ||||
| ATTACHMENT_TYPE_NAME | VARCHAR | (255) | Name | X | ||||
| SEARCHABLE | INTEGER | 0 | Searchable |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | ||||
| ATTRIBUTE_NAME | VARCHAR | (255) | Name | X | ||||
| ATTRIBUTE_TYPE_ID | INTEGER | TypeId | X | X | ||||
| PERMISSION | VARCHAR | (255) | Permission | |||||
| REQUIRED_OPTION_ID | INTEGER | RequiredOptionId | X | |||||
| DESCRIPTION | VARCHAR | (255) | Description | X | ||||
| ACTION | VARCHAR | (255) | Action | |||||
| CREATED_BY | INTEGER | CreatedBy | X | |||||
| CREATED_DATE | TIMESTAMP | CreatedDate | ||||||
| DELETED | INTEGER | 0 | Deleted |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| CONDITION_ID | BIGINT | ConditionId | X | X | ||||
| TRANSITION_ID | INTEGER | TransitionId | X | |||||
| MODULE_ID | INTEGER | ModuleId | X | |||||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | |||||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | |||||
| OPTION_ID | INTEGER | OptionId | X | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ATTRIBUTE_GROUP_ID | INTEGER | AttributeGroupId | X | X | ||||
| NAME | VARCHAR | (255) | Name | X | ||||
| DESCRIPTION | VARCHAR | (255) | Description | |||||
| MODULE_ID | INTEGER | ModuleId | X | |||||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | ||||
| ACTIVE | INTEGER | 0 | Active | |||||
| DEDUPE | INTEGER | 0 | Dedupe | |||||
| PREFERRED_ORDER | INTEGER | -1 | Order |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| GROUP_ID | INTEGER | GroupId | X | X | X | |||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | X | |||
| PREFERRED_ORDER | INTEGER | -1 | Order |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ATTRIBUTE_CLASS_ID | INTEGER | AttributeClassId | X | X | ||||
| ATTRIBUTE_CLASS_NAME | VARCHAR | (255) | Name | X | ||||
| ATTRIBUTE_CLASS_DESC | VARCHAR | (255) | Desc | X | ||||
| JAVA_CLASS_NAME | VARCHAR | (255) | JavaClassName |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| OPTION_ID | INTEGER | OptionId | X | X | ||||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | ||||
| OPTION_NAME | VARCHAR | (255) | Name | X | ||||
| DELETED | INTEGER | 0 | Deleted |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| RELATIONSHIP_ID | INTEGER | RelationshipId | X | X | ||||
| RELATIONSHIP_NAME | VARCHAR | (100) | Name | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ATTRIBUTE_TYPE_ID | INTEGER | AttributeTypeId | X | X | ||||
| ATTRIBUTE_CLASS_ID | INTEGER | ClassId | X | X | ||||
| ATTRIBUTE_TYPE_NAME | VARCHAR | (255) | Name | X | ||||
| JAVA_CLASS_NAME | VARCHAR | (255) | JavaClassName | |||||
| VALIDATION_KEY | VARCHAR | (20) | ValidationKey |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| DEPEND_ID | INTEGER | DependId | X | X | ||||
| OBSERVED_ID | BIGINT | ObservedId | X | X | ||||
| OBSERVER_ID | BIGINT | ObserverId | X | X | ||||
| DEPEND_TYPE_ID | INTEGER | TypeId | X | X | ||||
| DELETED | INTEGER | 0 | Deleted |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| DEPEND_TYPE_ID | INTEGER | DependTypeId | X | X | ||||
| DEPEND_TYPE_NAME | VARCHAR | (100) | Name | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ISSUE_ID | BIGINT | IssueId | X | X | ||||
| ID_PREFIX | VARCHAR | (@SCARAB_MODULE_CODE_LENGTH@) | IdPrefix | X | ||||
| ID_COUNT | INTEGER | IdCount | X | |||||
| ID_DOMAIN | VARCHAR | (127) | IdDomain | |||||
| TYPE_ID | INTEGER | TypeId | X | |||||
| MODULE_ID | INTEGER | ModuleId | X | X | ||||
| CREATED_TRANS_ID | BIGINT | CreatedTransId | X | |||||
| LAST_TRANS_ID | BIGINT | LastTransId | X | |||||
| DELETED | INTEGER | 0 | Deleted | |||||
| MOVED | INTEGER | 0 | Moved |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | ||||
| NAME | VARCHAR | (100) | Name | X | ||||
| DESCRIPTION | VARCHAR | (255) | Description | |||||
| PARENT_ID | INTEGER | ParentId | X | X | ||||
| DEDUPE | INTEGER | 1 | Dedupe | |||||
| DELETED | INTEGER | 0 | Deleted | |||||
| LOCKED | INTEGER | 0 | Locked | |||||
| ISDEFAULT | INTEGER | 0 | Isdefault |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| MODULE_ID | INTEGER | ModuleId | X | X | X | |||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | X | |||
| ACTIVE | INTEGER | 1 | Active | X | ||||
| DISPLAY | INTEGER | 1 | Display | X | ||||
| PREFERRED_ORDER | INTEGER | 0 | Order | |||||
| DEDUPE | INTEGER | 1 | Dedupe | |||||
| HISTORY | INTEGER | 5 | History | |||||
| COMMENTS | INTEGER | 5 | Comments | |||||
| DISPLAY_NAME | VARCHAR | (255) | DisplayName | |||||
| DISPLAY_DESCRIPTION | VARCHAR | (255) | DisplayDescription |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| LIST_ID | BIGINT | ListId | X | X | ||||
| NAME | VARCHAR | (100) | Name | |||||
| ACTIVE | INTEGER | 1 | Active | |||||
| MODIFIABLE | INTEGER | 1 | Modifiable | |||||
| USER_ID | INTEGER | UserId | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ITEM_ID | BIGINT | ItemId | X | X | ||||
| MODULE_ID | INTEGER | ModuleId | X | |||||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | |||||
| LIST_ID | BIGINT | ListId | X | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| VALUE_ID | BIGINT | ValueId | X | X | ||||
| ISSUE_ID | BIGINT | IssueId | X | X | ||||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | ||||
| NUMERIC_VALUE | INTEGER | NumericValue | ||||||
| OPTION_ID | INTEGER | OptionId | X | |||||
| USER_ID | INTEGER | UserId | X | |||||
| VALUE | LONGVARCHAR | Value | ||||||
| DELETED | INTEGER | 0 | Deleted |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| TABLE_ID | INTEGER | TableId | X | X | ||||
| COLUMN_ID | INTEGER | ColumnId | X | X | ||||
| MODIFIED_BY | INTEGER | ModifiedBy | ||||||
| CREATED_BY | INTEGER | CreatedBy | ||||||
| MODIFIED_DATE | TIMESTAMP | ModifiedDate | ||||||
| CREATED_DATE | TIMESTAMP | CreatedDate |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| MODULE_ID | INTEGER | ModuleId | X | X | ||||
| MODULE_NAME | VARCHAR | (255) | RealName | X | ||||
| DOMAIN | VARCHAR | (127) | Domain | |||||
| MODULE_CODE | VARCHAR | (@SCARAB_MODULE_CODE_LENGTH@) | Code | X | ||||
| MODULE_DESCRIPTION | VARCHAR | (255) | Description | X | ||||
| MODULE_URL | VARCHAR | (255) | Url | |||||
| ARCHIVE_EMAIL | VARCHAR | (99) | ArchiveEmail | |||||
| PARENT_ID | INTEGER | ParentId | X | X | ||||
| OWNER_ID | INTEGER | OwnerId | X | |||||
| QA_CONTACT_ID | INTEGER | QaContactId | X | |||||
| DELETED | INTEGER | 0 | Deleted | |||||
| LOCKED | INTEGER | 0 | Locked | |||||
| CLASS_KEY | INTEGER | ClassKey |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| MODULE_ID | INTEGER | ModuleId | X | X | X | |||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | X | |||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | X | |||
| DISPLAY_VALUE | VARCHAR | (255) | DisplayValue | X | ||||
| ACTIVE | INTEGER | 1 | Active | X | ||||
| REQUIRED | INTEGER | 0 | Required | X | ||||
| PREFERRED_ORDER | INTEGER | 0 | Order | X | ||||
| QUICK_SEARCH | INTEGER | 0 | QuickSearch | X | ||||
| DEFAULT_TEXT_FLAG | INTEGER | 0 | DefaultTextFlag | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | X | |||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | X | |||
| ACTIVE | INTEGER | 1 | Active | X | ||||
| REQUIRED | INTEGER | 0 | Required | X | ||||
| PREFERRED_ORDER | INTEGER | 0 | Order | X | ||||
| QUICK_SEARCH | INTEGER | 0 | QuickSearch | X | ||||
| DEFAULT_TEXT_FLAG | INTEGER | 0 | DefaultTextFlag | X | ||||
| LOCKED | INTEGER | 0 | Locked |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| MODULE_ID | INTEGER | ModuleId | X | X | X | |||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | X | |||
| OPTION_ID | INTEGER | OptionId | X | X | X | |||
| DISPLAY_VALUE | VARCHAR | (255) | DisplayValue | |||||
| ACTIVE | INTEGER | 1 | Active | X | ||||
| PREFERRED_ORDER | INTEGER | -1 | Order | |||||
| WEIGHT | INTEGER | -1 | Weight |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | X | |||
| OPTION_ID | INTEGER | OptionId | X | X | X | |||
| ACTIVE | INTEGER | 1 | Active | X | ||||
| LOCKED | INTEGER | 0 | Locked | |||||
| PREFERRED_ORDER | INTEGER | -1 | Order | |||||
| WEIGHT | INTEGER | -1 | Weight |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| OPTION1_ID | INTEGER | Option1Id | X | X | X | |||
| OPTION2_ID | INTEGER | Option2Id | X | X | X | |||
| RELATIONSHIP_ID | INTEGER | RelationshipId | X | X | ||||
| WEIGHT | INTEGER | Weight | ||||||
| PREFERRED_ORDER | INTEGER | PreferredOrder | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| RMUA_ID | BIGINT | RmuaId | X | X | ||||
| LIST_ID | BIGINT | ListId | X | |||||
| MODULE_ID | INTEGER | ModuleId | X | |||||
| USER_ID | INTEGER | UserId | X | X | ||||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | |||||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | ||||
| INTERNAL_ATTRIBUTE | VARCHAR | (20) | InternalAttribute | |||||
| PREFERRED_ORDER | INTEGER | 0 | Order | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| TRANSACTION_ID | BIGINT | ActivitySetId | X | X | ||||
| TYPE_ID | INTEGER | TypeId | X | |||||
| ATTACHMENT_ID | BIGINT | AttachmentId | X | |||||
| CREATED_BY | INTEGER | CreatedBy | X | |||||
| CREATED_DATE | TIMESTAMP | CreatedDate |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| TYPE_ID | INTEGER | TypeId | X | X | ||||
| NAME | VARCHAR | (100) | Name | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| USER_ID | INTEGER | UserId | X | X | X | |||
| PASSWORD_EXPIRE | TIMESTAMP | PasswordExpire | ||||||
| ENTER_ISSUE_REDIRECT | INTEGER | EnterIssueRedirect | ||||||
| HOME_PAGE | VARCHAR | (32) | HomePage | |||||
| LOCALE | VARCHAR | (255) | Locale |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| MODULE_ID | INTEGER | ModuleId | X | X | X | |||
| USER_ID | INTEGER | UserId | X | X | X | |||
| TOTAL_VOTES | INTEGER | 0 | TotalVotes | |||||
| USED_VOTES | INTEGER | 0 | UsedVotes |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ISSUE_ID | BIGINT | IssueId | X | X | X | |||
| USER_ID | INTEGER | UserId | X | X | X | |||
| VOTES | INTEGER | 0 | Votes |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| QUERY_ID | BIGINT | QueryId | X | X | ||||
| USER_ID | INTEGER | UserId | X | X | ||||
| NAME | VARCHAR | (255) | Name | X | ||||
| DESCRIPTION | VARCHAR | (255) | Description | |||||
| VALUE | LONGVARCHAR | Value | X | |||||
| SCOPE_ID | INTEGER | ScopeId | X | X | ||||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | |||||
| MODULE_ID | INTEGER | ModuleId | X | |||||
| LIST_ID | BIGINT | ListId | X | |||||
| DELETED | INTEGER | 0 | Deleted | |||||
| APPROVED | INTEGER | 0 | Approved | |||||
| CREATED_DATE | TIMESTAMP | CreatedDate | ||||||
| SUBSCRIPTION_FREQUENCY_ID | INTEGER | SubscriptionFrequencyId | X | |||||
| HOME_PAGE | INTEGER | 0 | HomePage | |||||
| PREFERRED_ORDER | INTEGER | 0 | Order |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| QUERY_ID | BIGINT | QueryId | X | X | X | |||
| USER_ID | INTEGER | UserId | X | X | X | |||
| IS_SUBSCRIBED | INTEGER | 0 | IsSubscribed | |||||
| SUBSCRIPTION_FREQUENCY_ID | INTEGER | SubscriptionFrequency | X | |||||
| ISDEFAULT | INTEGER | 0 | Isdefault |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| FREQUENCY_ID | INTEGER | FrequencyId | X | X | ||||
| FREQUENCY_NAME | VARCHAR | (255) | Name | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ISSUE_ID | BIGINT | IssueId | X | X | X | |||
| NAME | VARCHAR | (255) | Name | X | ||||
| DESCRIPTION | VARCHAR | (255) | Description | |||||
| APPROVED | INTEGER | 0 | Approved | |||||
| SCOPE_ID | INTEGER | ScopeId | X | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| SCOPE_ID | INTEGER | ScopeId | X | X | ||||
| SCOPE_NAME | VARCHAR | (255) | Name | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| REPORT_ID | INTEGER | ReportId | X | X | ||||
| USER_ID | INTEGER | UserId | X | X | ||||
| MODULE_ID | INTEGER | ModuleId | X | |||||
| ISSUE_TYPE_ID | INTEGER | IssueTypeId | X | X | ||||
| NAME | VARCHAR | (255) | Name | X | ||||
| DESCRIPTION | VARCHAR | (255) | Description | |||||
| QUERY_STRING | LONGVARCHAR | QueryString | X | |||||
| SCOPE_ID | INTEGER | ScopeId | X | X | ||||
| DELETED | INTEGER | 0 | Deleted | |||||
| CREATED_DATE | TIMESTAMP | CreatedDate |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| USER_ID | INTEGER | UserId | X | X | X | |||
| GROUP_ID | INTEGER | GroupId | X | X | X | |||
| ROLE_NAME | VARCHAR | (255) | RoleName | X | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| PARAMETER_ID | INTEGER | ParameterId | X | X | ||||
| NAME | VARCHAR | (255) | Name | X | ||||
| VALUE | VARCHAR | (255) | Value | X | ||||
| MODULE_ID | INTEGER | ModuleId | X |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| TRANSITION_ID | INTEGER | TransitionId | X | X | ||||
| ROLE_ID | INTEGER | RoleId | ||||||
| ATTRIBUTE_ID | INTEGER | AttributeId | X | X | ||||
| FROM_OPTION_ID | INTEGER | FromOptionId | X | |||||
| TO_OPTION_ID | INTEGER | ToOptionId | X | |||||
| DISABLED_IF_BLOCKED | INTEGER | 0 | DisabledIfBlocked |
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | BIGINT | ActivityId | X | X | X | |||
| CREATOR_ID | INTEGER | CreatorId | X | X | X | |||
| RECEIVER_ID | INTEGER | ReceiverId | X | X | ||||
| STATUS | INTEGER | Status | X | |||||
| CREATION_DATE | DATE | CreationDate | ||||||
| CHANGE_DATE | DATE | ChangeDate | ||||||
| STATUS_COMMENT | VARCHAR | (255) | Comment |