scarab

Table NameOM ClassDescription
SCARAB_ACTIVITYActivityContains activities on issues
SCARAB_ATTACHMENTAttachment
SCARAB_ATTACHMENT_TYPEAttachmentType
SCARAB_ATTRIBUTEAttribute
SCARAB_CONDITIONCondition
SCARAB_ATTRIBUTE_GROUPAttributeGroup
SCARAB_R_ATTRIBUTE_ATTRGROUPRAttributeAttributeGroup
SCARAB_ATTRIBUTE_CLASSAttributeClass
SCARAB_ATTRIBUTE_OPTIONAttributeOption
SCARAB_OPTION_RELATIONSHIPOptionRelationship
SCARAB_ATTRIBUTE_TYPEAttributeType
SCARAB_DEPENDDepend
SCARAB_DEPEND_TYPEDependType
SCARAB_ISSUEIssue
SCARAB_ISSUE_TYPEIssueType
SCARAB_R_MODULE_ISSUE_TYPERModuleIssueType
SCARAB_MIT_LISTMITList
SCARAB_MIT_LISTITEMMITListItem
SCARAB_ISSUE_ATTRIBUTE_VALUEAttributeValue
SCARAB_MODIFICATIONModification
SCARAB_MODULEScarabModule
SCARAB_R_MODULE_ATTRIBUTERModuleAttribute
SCARAB_R_ISSUETYPE_ATTRIBUTERIssueTypeAttribute
SCARAB_R_MODULE_OPTIONRModuleOption
SCARAB_R_ISSUETYPE_OPTIONRIssueTypeOption
SCARAB_R_OPTION_OPTIONROptionOption
SCARAB_R_MODULE_USER_ATTRIBUTERModuleUserAttribute
SCARAB_TRANSACTIONActivitySet
SCARAB_TRANSACTION_TYPEActivitySetType
TURBINE_USERScarabUserImpl
TURBINE_ROLEScarabRoleImpl
SCARAB_USER_PREFERENCEUserPreference
SCARAB_USER_VOTEUserVote
SCARAB_ISSUE_VOTEIssueVote
SCARAB_QUERYQuery
SCARAB_R_QUERY_USERRQueryUser
SCARAB_FREQUENCYFrequency
SCARAB_ISSUE_TEMPLATE_INFOIssueTemplateInfo
SCARAB_SCOPEScope
SCARAB_REPORTReport
SCARAB_PENDING_GROUP_USER_ROLEPendingGroupUserRole
SCARAB_GLOBAL_PARAMETERGlobalParameter
SCARAB_TRANSITIONTransition
SCARAB_NOTIFICATION_STATUSNotificationStatus
SCARAB_NOTIFICATION_FILTERNotificationFilter
SCARAB_DEFAULT_NOTIFICATION_FILTERNotificationDefaultFilter

SCARAB_ACTIVITY

Contains activities on issues

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ACTIVITY_IDBIGINTActivityIdXXID generated via IDBROKER
ISSUE_IDBIGINTIssueIdXX
ATTRIBUTE_IDINTEGERAttributeIdXX
TRANSACTION_IDBIGINTTransactionIdXX
OLD_NUMERIC_VALUEINTEGEROldNumericValue
NEW_NUMERIC_VALUEINTEGERNewNumericValue
OLD_USER_IDINTEGEROldUserIdX
NEW_USER_IDINTEGERNewUserIdX
OLD_OPTION_IDINTEGEROldOptionIdX
NEW_OPTION_IDINTEGERNewOptionIdX
OLD_VALUELONGVARCHAROldValue
NEW_VALUELONGVARCHARNewValue
DEPEND_IDINTEGERDependIdX
DESCRIPTIONVARCHAR(255)Description
END_DATEDATEEndDate
ATTACHMENT_IDBIGINTAttachmentIdX
ACTIVITY_TYPEVARCHAR(30)ActivityType

SCARAB_ATTACHMENT

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ATTACHMENT_IDBIGINTAttachmentIdXX
ISSUE_IDBIGINTIssueIdX
ATTACHMENT_TYPE_IDINTEGERTypeIdXX
ATTACHMENT_NAMEVARCHAR(255)NameX
ATTACHMENT_DATALONGVARCHARData
ATTACHMENT_FILE_PATHVARCHAR(255)FileName
ATTACHMENT_MIME_TYPEVARCHAR(255)MimeTypeX
MODIFIED_BYINTEGERModifiedByX
CREATED_BYINTEGERCreatedByX
MODIFIED_DATETIMESTAMPModifiedDate
CREATED_DATETIMESTAMPCreatedDate
DELETEDINTEGER0Deleted

SCARAB_ATTACHMENT_TYPE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ATTACHMENT_TYPE_IDINTEGERAttachmentTypeIdXX
ATTACHMENT_TYPE_NAMEVARCHAR(255)NameX
SEARCHABLEINTEGER0Searchable

SCARAB_ATTRIBUTE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ATTRIBUTE_IDINTEGERAttributeIdXX
ATTRIBUTE_NAMEVARCHAR(255)NameX
ATTRIBUTE_TYPE_IDINTEGERTypeIdXX
PERMISSIONVARCHAR(255)Permission
REQUIRED_OPTION_IDINTEGERRequiredOptionIdX
DESCRIPTIONVARCHAR(255)DescriptionX
ACTIONVARCHAR(255)Action
CREATED_BYINTEGERCreatedByX
CREATED_DATETIMESTAMPCreatedDate
DELETEDINTEGER0Deleted

SCARAB_CONDITION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
CONDITION_IDBIGINTConditionIdXX
TRANSITION_IDINTEGERTransitionIdX
MODULE_IDINTEGERModuleIdX
ISSUE_TYPE_IDINTEGERIssueTypeIdX
ATTRIBUTE_IDINTEGERAttributeIdX
OPTION_IDINTEGEROptionIdXX

SCARAB_ATTRIBUTE_GROUP

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ATTRIBUTE_GROUP_IDINTEGERAttributeGroupIdXX
NAMEVARCHAR(255)NameX
DESCRIPTIONVARCHAR(255)Description
MODULE_IDINTEGERModuleIdX
ISSUE_TYPE_IDINTEGERIssueTypeIdXX
ACTIVEINTEGER0Active
DEDUPEINTEGER0Dedupe
PREFERRED_ORDERINTEGER-1Order

SCARAB_R_ATTRIBUTE_ATTRGROUP

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
GROUP_IDINTEGERGroupIdXXX
ATTRIBUTE_IDINTEGERAttributeIdXXX
PREFERRED_ORDERINTEGER-1Order

SCARAB_ATTRIBUTE_CLASS

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ATTRIBUTE_CLASS_IDINTEGERAttributeClassIdXX
ATTRIBUTE_CLASS_NAMEVARCHAR(255)NameX
ATTRIBUTE_CLASS_DESCVARCHAR(255)DescX
JAVA_CLASS_NAMEVARCHAR(255)JavaClassName

SCARAB_ATTRIBUTE_OPTION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
OPTION_IDINTEGEROptionIdXX
ATTRIBUTE_IDINTEGERAttributeIdXX
OPTION_NAMEVARCHAR(255)NameX
DELETEDINTEGER0Deleted

SCARAB_OPTION_RELATIONSHIP

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
RELATIONSHIP_IDINTEGERRelationshipIdXX
RELATIONSHIP_NAMEVARCHAR(100)NameX

SCARAB_ATTRIBUTE_TYPE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ATTRIBUTE_TYPE_IDINTEGERAttributeTypeIdXX
ATTRIBUTE_CLASS_IDINTEGERClassIdXX
ATTRIBUTE_TYPE_NAMEVARCHAR(255)NameX
JAVA_CLASS_NAMEVARCHAR(255)JavaClassName
VALIDATION_KEYVARCHAR(20)ValidationKey

SCARAB_DEPEND

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
DEPEND_IDINTEGERDependIdXX
OBSERVED_IDBIGINTObservedIdXX
OBSERVER_IDBIGINTObserverIdXX
DEPEND_TYPE_IDINTEGERTypeIdXX
DELETEDINTEGER0Deleted

SCARAB_DEPEND_TYPE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
DEPEND_TYPE_IDINTEGERDependTypeIdXX
DEPEND_TYPE_NAMEVARCHAR(100)NameX

SCARAB_ISSUE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ISSUE_IDBIGINTIssueIdXX
ID_PREFIXVARCHAR(@SCARAB_MODULE_CODE_LENGTH@)IdPrefixX
ID_COUNTINTEGERIdCountX
ID_DOMAINVARCHAR(127)IdDomain
TYPE_IDINTEGERTypeIdX
MODULE_IDINTEGERModuleIdXX
CREATED_TRANS_IDBIGINTCreatedTransIdX
LAST_TRANS_IDBIGINTLastTransIdX
DELETEDINTEGER0Deleted
MOVEDINTEGER0Moved

SCARAB_ISSUE_TYPE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ISSUE_TYPE_IDINTEGERIssueTypeIdXX
NAMEVARCHAR(100)NameX
DESCRIPTIONVARCHAR(255)Description
PARENT_IDINTEGERParentIdXX
DEDUPEINTEGER1Dedupe
DELETEDINTEGER0Deleted
LOCKEDINTEGER0Locked
ISDEFAULTINTEGER0Isdefault

SCARAB_R_MODULE_ISSUE_TYPE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
MODULE_IDINTEGERModuleIdXXX
ISSUE_TYPE_IDINTEGERIssueTypeIdXXX
ACTIVEINTEGER1ActiveX
DISPLAYINTEGER1DisplayX
PREFERRED_ORDERINTEGER0Order
DEDUPEINTEGER1Dedupe
HISTORYINTEGER5History
COMMENTSINTEGER5Comments
DISPLAY_NAMEVARCHAR(255)DisplayName
DISPLAY_DESCRIPTIONVARCHAR(255)DisplayDescription

SCARAB_MIT_LIST

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
LIST_IDBIGINTListIdXX
NAMEVARCHAR(100)Name
ACTIVEINTEGER1Active
MODIFIABLEINTEGER1Modifiable
USER_IDINTEGERUserIdX

SCARAB_MIT_LISTITEM

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ITEM_IDBIGINTItemIdXX
MODULE_IDINTEGERModuleIdX
ISSUE_TYPE_IDINTEGERIssueTypeIdX
LIST_IDBIGINTListIdXX

SCARAB_ISSUE_ATTRIBUTE_VALUE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
VALUE_IDBIGINTValueIdXX
ISSUE_IDBIGINTIssueIdXX
ATTRIBUTE_IDINTEGERAttributeIdXX
NUMERIC_VALUEINTEGERNumericValue
OPTION_IDINTEGEROptionIdX
USER_IDINTEGERUserIdX
VALUELONGVARCHARValue
DELETEDINTEGER0Deleted

SCARAB_MODIFICATION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
TABLE_IDINTEGERTableIdXX
COLUMN_IDINTEGERColumnIdXX
MODIFIED_BYINTEGERModifiedBy
CREATED_BYINTEGERCreatedBy
MODIFIED_DATETIMESTAMPModifiedDate
CREATED_DATETIMESTAMPCreatedDate

SCARAB_MODULE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
MODULE_IDINTEGERModuleIdXX
MODULE_NAMEVARCHAR(255)RealNameX
DOMAINVARCHAR(127)Domain
MODULE_CODEVARCHAR(@SCARAB_MODULE_CODE_LENGTH@)CodeX
MODULE_DESCRIPTIONVARCHAR(255)DescriptionX
MODULE_URLVARCHAR(255)Url
ARCHIVE_EMAILVARCHAR(99)ArchiveEmail
PARENT_IDINTEGERParentIdXX
OWNER_IDINTEGEROwnerIdX
QA_CONTACT_IDINTEGERQaContactIdX
DELETEDINTEGER0Deleted
LOCKEDINTEGER0Locked
CLASS_KEYINTEGERClassKey

SCARAB_R_MODULE_ATTRIBUTE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
MODULE_IDINTEGERModuleIdXXX
ATTRIBUTE_IDINTEGERAttributeIdXXX
ISSUE_TYPE_IDINTEGERIssueTypeIdXXX
DISPLAY_VALUEVARCHAR(255)DisplayValueX
ACTIVEINTEGER1ActiveX
REQUIREDINTEGER0RequiredX
PREFERRED_ORDERINTEGER0OrderX
QUICK_SEARCHINTEGER0QuickSearchX
DEFAULT_TEXT_FLAGINTEGER0DefaultTextFlagX

SCARAB_R_ISSUETYPE_ATTRIBUTE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ATTRIBUTE_IDINTEGERAttributeIdXXX
ISSUE_TYPE_IDINTEGERIssueTypeIdXXX
ACTIVEINTEGER1ActiveX
REQUIREDINTEGER0RequiredX
PREFERRED_ORDERINTEGER0OrderX
QUICK_SEARCHINTEGER0QuickSearchX
DEFAULT_TEXT_FLAGINTEGER0DefaultTextFlagX
LOCKEDINTEGER0Locked

SCARAB_R_MODULE_OPTION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
MODULE_IDINTEGERModuleIdXXX
ISSUE_TYPE_IDINTEGERIssueTypeIdXXX
OPTION_IDINTEGEROptionIdXXX
DISPLAY_VALUEVARCHAR(255)DisplayValue
ACTIVEINTEGER1ActiveX
PREFERRED_ORDERINTEGER-1Order
WEIGHTINTEGER-1Weight

SCARAB_R_ISSUETYPE_OPTION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ISSUE_TYPE_IDINTEGERIssueTypeIdXXX
OPTION_IDINTEGEROptionIdXXX
ACTIVEINTEGER1ActiveX
LOCKEDINTEGER0Locked
PREFERRED_ORDERINTEGER-1Order
WEIGHTINTEGER-1Weight

SCARAB_R_OPTION_OPTION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
OPTION1_IDINTEGEROption1IdXXX
OPTION2_IDINTEGEROption2IdXXX
RELATIONSHIP_IDINTEGERRelationshipIdXX
WEIGHTINTEGERWeight
PREFERRED_ORDERINTEGERPreferredOrderX

SCARAB_R_MODULE_USER_ATTRIBUTE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
RMUA_IDBIGINTRmuaIdXX
LIST_IDBIGINTListIdX
MODULE_IDINTEGERModuleIdX
USER_IDINTEGERUserIdXX
ISSUE_TYPE_IDINTEGERIssueTypeIdX
ATTRIBUTE_IDINTEGERAttributeIdXX
INTERNAL_ATTRIBUTEVARCHAR(20)InternalAttribute
PREFERRED_ORDERINTEGER0OrderX

SCARAB_TRANSACTION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
TRANSACTION_IDBIGINTActivitySetIdXX
TYPE_IDINTEGERTypeIdX
ATTACHMENT_IDBIGINTAttachmentIdX
CREATED_BYINTEGERCreatedByX
CREATED_DATETIMESTAMPCreatedDate

SCARAB_TRANSACTION_TYPE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
TYPE_IDINTEGERTypeIdXX
NAMEVARCHAR(100)NameX

TURBINE_USER

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
USER_IDINTEGERUserIdXX

TURBINE_ROLE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ROLE_IDINTEGERRoleIdXX

SCARAB_USER_PREFERENCE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
USER_IDINTEGERUserIdXXX
PASSWORD_EXPIRETIMESTAMPPasswordExpire
ENTER_ISSUE_REDIRECTINTEGEREnterIssueRedirect
HOME_PAGEVARCHAR(32)HomePage
LOCALEVARCHAR(255)Locale

SCARAB_USER_VOTE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
MODULE_IDINTEGERModuleIdXXX
USER_IDINTEGERUserIdXXX
TOTAL_VOTESINTEGER0TotalVotes
USED_VOTESINTEGER0UsedVotes

SCARAB_ISSUE_VOTE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ISSUE_IDBIGINTIssueIdXXX
USER_IDINTEGERUserIdXXX
VOTESINTEGER0Votes

SCARAB_QUERY

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
QUERY_IDBIGINTQueryIdXX
USER_IDINTEGERUserIdXX
NAMEVARCHAR(255)NameX
DESCRIPTIONVARCHAR(255)Description
VALUELONGVARCHARValueX
SCOPE_IDINTEGERScopeIdXX
ISSUE_TYPE_IDINTEGERIssueTypeIdX
MODULE_IDINTEGERModuleIdX
LIST_IDBIGINTListIdX
DELETEDINTEGER0Deleted
APPROVEDINTEGER0Approved
CREATED_DATETIMESTAMPCreatedDate
SUBSCRIPTION_FREQUENCY_IDINTEGERSubscriptionFrequencyIdX
HOME_PAGEINTEGER0HomePage
PREFERRED_ORDERINTEGER0Order

SCARAB_R_QUERY_USER

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
QUERY_IDBIGINTQueryIdXXX
USER_IDINTEGERUserIdXXX
IS_SUBSCRIBEDINTEGER0IsSubscribed
SUBSCRIPTION_FREQUENCY_IDINTEGERSubscriptionFrequencyX
ISDEFAULTINTEGER0Isdefault

SCARAB_FREQUENCY

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
FREQUENCY_IDINTEGERFrequencyIdXX
FREQUENCY_NAMEVARCHAR(255)NameX

SCARAB_ISSUE_TEMPLATE_INFO

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ISSUE_IDBIGINTIssueIdXXX
NAMEVARCHAR(255)NameX
DESCRIPTIONVARCHAR(255)Description
APPROVEDINTEGER0Approved
SCOPE_IDINTEGERScopeIdXX

SCARAB_SCOPE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
SCOPE_IDINTEGERScopeIdXX
SCOPE_NAMEVARCHAR(255)NameX

SCARAB_REPORT

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
REPORT_IDINTEGERReportIdXX
USER_IDINTEGERUserIdXX
MODULE_IDINTEGERModuleIdX
ISSUE_TYPE_IDINTEGERIssueTypeIdXX
NAMEVARCHAR(255)NameX
DESCRIPTIONVARCHAR(255)Description
QUERY_STRINGLONGVARCHARQueryStringX
SCOPE_IDINTEGERScopeIdXX
DELETEDINTEGER0Deleted
CREATED_DATETIMESTAMPCreatedDate

SCARAB_PENDING_GROUP_USER_ROLE

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
USER_IDINTEGERUserIdXXX
GROUP_IDINTEGERGroupIdXXX
ROLE_NAMEVARCHAR(255)RoleNameXX

SCARAB_GLOBAL_PARAMETER

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
PARAMETER_IDINTEGERParameterIdXX
NAMEVARCHAR(255)NameX
VALUEVARCHAR(255)ValueX
MODULE_IDINTEGERModuleIdX

SCARAB_TRANSITION

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
TRANSITION_IDINTEGERTransitionIdXX
ROLE_IDINTEGERRoleId
ATTRIBUTE_IDINTEGERAttributeIdXX
FROM_OPTION_IDINTEGERFromOptionIdX
TO_OPTION_IDINTEGERToOptionIdX
DISABLED_IF_BLOCKEDINTEGER0DisabledIfBlocked

SCARAB_NOTIFICATION_STATUS

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
ACTIVITY_IDBIGINTActivityIdXXX
CREATOR_IDINTEGERCreatorIdXXX
RECEIVER_IDINTEGERReceiverIdXX
STATUSINTEGERStatusX
CREATION_DATEDATECreationDate
CHANGE_DATEDATEChangeDate
STATUS_COMMENTVARCHAR(255)Comment

SCARAB_NOTIFICATION_FILTER

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
MODULE_IDINTEGERModuleIdXXX
USER_IDINTEGERUserIdXXX
ACTIVITY_TYPEVARCHAR(30)ActivityTypeXX
MANAGER_IDINTEGER0ManagerIdXX
FILTER_STATEINTEGER0FilterStateX
SEND_SELFINTEGER0SendSelfX
SEND_FAILURESINTEGER0SendFailuresX

SCARAB_DEFAULT_NOTIFICATION_FILTER

NameTypeSizeDefaultJavaNamePKFKnot nullDescription
MODULE_IDINTEGERModuleIdXXX
ROLE_IDINTEGERRoleIdXXX
ACTIVITY_TYPEVARCHAR(30)ActivityTypeXX
MANAGER_IDINTEGER0ManagerIdXX
FILTER_STATEINTEGER0FilterStateX
MODIFYABlEINTEGER1ModifyableX