Scarab
| Table Name | Description |
|---|---|
| SCARAB_ACTIVITY | History of changes made to the attributes of an issue. |
| SCARAB_ATTACHMENT | Attachment is a piece of information associated with an issue. |
| SCARAB_ATTACHMENT_TYPE | Possible types of attachements. Example: Comment Example: File |
| SCARAB_ATTRIBUTE | Possible attributes of an issue. Example: Operating System Example: Severity |
| SCARAB_ATTRIBUTE_CLASS | Attribute class is group of attributes types that have the same properties. Example: Free form input. Example: Select one from the list. |
| SCARAB_ATTRIBUTE_GROUP | Groupings in which attributes appear on the page. |
| SCARAB_ATTRIBUTE_OPTION | Attribute option is possible value of an attribute of an issue. Example: DOS 3.1 (for attribute Operating System) |
| SCARAB_ATTRIBUTE_TYPE | Attribute type is group of attributes that have the same representation in the application data structure. Attribute type fully defines attribute behavior. Example: Integer Example: String |
| SCARAB_DEPEND | Dependency between issues. Example: Issue is a duplicate of another issue. Example: Issue is blocking another issue. |
| SCARAB_DEPEND_TYPE | Possible types of dependency between issues. Example: Duplicate Example: Block |
| SCARAB_FREQUENCY | Frequencies of an event. Examples: every half hour, weekly. |
| SCARAB_ISSUE | Information about artifact under processing in tracking system. Example: Particular defect Example: Particular inquiry |
| SCARAB_ISSUE_ATTRIBUTE_VALUE | Actual attribute of the issue with its value. |
| SCARAB_ISSUE_TEMPLATE_INFO | A saved user template for entering issues. |
| SCARAB_ISSUE_TYPE | |
| SCARAB_ISSUE_VOTE | The number of votes a user has cast for an issue. |
| SCARAB_MODIFICATION | Modification information for table. Not currently used. |
| SCARAB_MODULE | Logical category of issues. Usually corresponds to the software project. Example: Scarab |
| SCARAB_OPTION_RELATIONSHIP | Possible types of dependency between options. Example: Parent-Child Example: Requires |
| SCARAB_QUERY | A saved user query. |
| SCARAB_R_ATTRIBUTE_ATTRGROUP | Mapping from attributes to groups. |
| SCARAB_R_MODULE_ATTRIBUTE | Attributes that are applicable to issues of the particular module. |
| SCARAB_R_MODULE_ISSUE_TYPE | Mapping between modules and issue types. |
| SCARAB_R_MODULE_OPTION | Options that are applicable to issues of the particular module. |
| SCARAB_R_MODULE_USER_ATTRIBUTE | User's choice of attributes to appear on the Issue List screen. |
| SCARAB_R_OPTION_OPTION | Sets up relations between options. |
| SCARAB_R_QUERY_USER | Users subscribed to a query. |
| SCARAB_REPORT | A saved report. |
| SCARAB_SCOPE | Scope: personal, global. |
| SCARAB_TRANSACTION | Transaction is a group of attribute modification that are performed together. |
| SCARAB_TRANSACTION_TYPE | Possible types of transactions. Example: Issue Created Example: Issue Moved |
| SCARAB_USER_PREFERENCE | This table is used to store user preferences and other information relating to a specific user. |
| SCARAB_USER_VOTE | A user's record of votes. It is assumed that a module that supports voting will give a new user some votes to use when the user is added, otherwise the user has no votes. |
| TURBINE_USER | Dummy table for where the USER_ID lives. In most cases, this will be a foreign table outside of the scope of Scarab itself. For example, if you are using Scarab with Turbine, then this will be defined as TURBINE_USER. For use in other systems, you will want to define this to be the name of your own USER table and update the FK references in this file to point at the new name. Then, all you need to do is regenerate the OR code to use the new table name. |
| Column Name | Type | Description |
|---|---|---|
| ACTIVITY_ID * | INTEGER not null | PK. |
| ATTRIBUTE_ID | INTEGER not null | Attribute that has been modified. |
| DESCRIPTION | VARCHAR (255) null | System-generated description of modification. |
| END_DATE | DATE null | Date this Activity is no longer the current value of the Attribute. |
| ISSUE_ID | INTEGER not null | Issue attribute of which has been modified. |
| NEW_NUMERIC_VALUE | INTEGER null | Value of integer attribute after modification. |
| NEW_OPTION_ID | INTEGER null | Value of option attribute after modification. |
| NEW_USER_ID | INTEGER null | Value of user attribute after modification. |
| NEW_VALUE | LONGVARCHAR null | Value of attribute after modification. |
| OLD_NUMERIC_VALUE | INTEGER null | Value of integer attribute before modification. |
| OLD_OPTION_ID | INTEGER null | Value of option attribute before modification. |
| OLD_USER_ID | INTEGER null | Value of user attribute before modification. |
| OLD_VALUE | LONGVARCHAR null | Value of attribute before modification. |
| TRANSACTION_ID | INTEGER not null | Transaction to which the attribute modification belongs. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE | ATTRIBUTE_ID | ATTRIBUTE_ID |
| SCARAB_ATTRIBUTE_OPTION | OLD_OPTION_ID | OPTION_ID |
| SCARAB_ATTRIBUTE_OPTION | NEW_OPTION_ID | OPTION_ID |
| SCARAB_ISSUE | ISSUE_ID | ISSUE_ID |
| SCARAB_TRANSACTION | TRANSACTION_ID | TRANSACTION_ID |
| TURBINE_USER | OLD_USER_ID | USER_ID |
| TURBINE_USER | NEW_USER_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| ATTACHMENT_ID * | INTEGER not null | Unique identifier. |
| ATTACHMENT_DATA | VARBINARY null | Actual information constituting the attachment. |
| ATTACHMENT_FILE_PATH | VARCHAR (255) null | Server side location of the file that contains attachment. Location is relative to the central file storage location specified in the application properties. |
| ATTACHMENT_MIME_TYPE | VARCHAR (25) not null | MIME type of the attachment. Describes type of information constituting an attachment. |
| ATTACHMENT_NAME | VARCHAR (255) not null | Name that is displayed in the UI. |
| ATTACHMENT_TYPE_ID | INTEGER not null | Type. |
| CREATED_BY | INTEGER null | Person that associated the attachment with an issue initially. |
| CREATED_DATE | TIMESTAMP null | Date of the initial association of attachment with an issue. |
| DELETED | BOOLEANINT (1) null | Flag, which marks that attachment has been deleted. |
| ISSUE_ID | INTEGER null | Issue that attachment is associated with. |
| MODIFIED_BY | INTEGER null | Person that made last modification to the attachment. |
| MODIFIED_DATE | TIMESTAMP null | Date of the last modification of the attachment. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTACHMENT_TYPE | ATTACHMENT_TYPE_ID | ATTACHMENT_TYPE_ID |
| SCARAB_ISSUE | ISSUE_ID | ISSUE_ID |
| TURBINE_USER | CREATED_BY | USER_ID |
| TURBINE_USER | MODIFIED_BY | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| ATTRIBUTE_ID * | INTEGER not null | Unique identifier. |
| ACTION | VARCHAR (255) null | For user attributes, whether the user will be emailed, cc'd, or neither. |
| ATTRIBUTE_NAME | VARCHAR (255) not null | Name. |
| ATTRIBUTE_TYPE_ID | INTEGER not null | Type. |
| CREATED_BY | INTEGER null | Person that set value to the column of the table initially. |
| CREATED_DATE | TIMESTAMP null | Date of the initial set of the column of the table. |
| DELETED | BOOLEANINT (1) null | Flag, which marks that attribute has been deleted. |
| DESCRIPTION | VARCHAR (255) not null | Description. |
| PERMISSION | VARCHAR (255) null | A permission related to this attribute. |
| REQUIRED_OPTION_ID | INTEGER null | A required option for this attribute to be active. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE_OPTION | REQUIRED_OPTION_ID | OPTION_ID |
| SCARAB_ATTRIBUTE_TYPE | ATTRIBUTE_TYPE_ID | ATTRIBUTE_TYPE_ID |
Attribute class is group of attributes types that have the same properties. Example: Free form input. Example: Select one from the list.
| Column Name | Type | Description |
|---|---|---|
| ATTRIBUTE_CLASS_ID * | INTEGER not null | Unique identifier. |
| ATTRIBUTE_CLASS_DESC | VARCHAR (255) not null | Description. |
| ATTRIBUTE_CLASS_NAME | VARCHAR (255) not null | Name. |
| JAVA_CLASS_NAME | VARCHAR (255) null | Fully qualified name of the java class that represents attribute, belonging to the attribute class, in the application. |
| Column Name | Type | Description |
|---|---|---|
| ATTRIBUTE_GROUP_ID * | INTEGER not null | Unique identifier. |
| ACTIVE | BOOLEANINT (1) null | |
| DEDUPE | BOOLEANINT (1) null | |
| DESCRIPTION | VARCHAR (255) null | |
| ISSUE_TYPE_ID | INTEGER not null | Issue type. |
| MODULE_ID | INTEGER not null | Module. |
| NAME | VARCHAR (255) not null | |
| PREFERRED_ORDER | INTEGER null |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ISSUE_TYPE | ISSUE_TYPE_ID | ISSUE_TYPE_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
Attribute option is possible value of an attribute of an issue. Example: DOS 3.1 (for attribute Operating System)
Attribute type is group of attributes that have the same representation in the application data structure. Attribute type fully defines attribute behavior. Example: Integer Example: String
| Column Name | Type | Description |
|---|---|---|
| ATTRIBUTE_TYPE_ID * | INTEGER not null | Unique identifier. |
| ATTRIBUTE_CLASS_ID | INTEGER not null | Attribute class. |
| ATTRIBUTE_TYPE_NAME | VARCHAR (255) not null | Name. |
| JAVA_CLASS_NAME | VARCHAR (255) null | Fully qualified name of the java class that represents attribute, belonging to the attribute type, in the application. |
| VALIDATION_KEY | VARCHAR (20) null | A key which ties into a validation service (intake). |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE_CLASS | ATTRIBUTE_CLASS_ID | ATTRIBUTE_CLASS_ID |
Dependency between issues. Example: Issue is a duplicate of another issue. Example: Issue is blocking another issue.
| Column Name | Type | Description |
|---|---|---|
| OBSERVED_ID * | INTEGER not null | Issue that other issue depends upon. Example: Issue that blocks. Example: Issue that has duplicates. |
| OBSERVER_ID * | INTEGER not null | Issue that depends on other issue. Example: Issue that is being blocked. Example: Issue that is duplicate. |
| DELETED | BOOLEANINT (1) null | Flag, which marks that dependency has been deleted. |
| DEPEND_TYPE_ID | INTEGER not null | Type. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_DEPEND_TYPE | DEPEND_TYPE_ID | DEPEND_TYPE_ID |
| SCARAB_ISSUE | OBSERVED_ID | ISSUE_ID |
| SCARAB_ISSUE | OBSERVER_ID | ISSUE_ID |
Information about artifact under processing in tracking system. Example: Particular defect Example: Particular inquiry
| Column Name | Type | Description |
|---|---|---|
| ISSUE_ID * | INTEGER not null | Unique identifier used for primary key. |
| DELETED | BOOLEANINT (1) null | Flag, which marks that issue has been deleted. |
| ID_COUNT | INTEGER (10) not null | Part of Id which is an integer. |
| ID_DOMAIN | VARCHAR (127) null | The instance of scarab the issue was originally reported to. This field could be null for the normal instance where the issue is local to this database. |
| ID_PREFIX | CHAR (4) not null | Part of Id related to module. |
| MODULE_ID | INTEGER not null | Module that issue relates to. |
| TYPE_ID | INTEGER null | Type : Issue, or Enter Issue Template. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ISSUE_TYPE | TYPE_ID | ISSUE_TYPE_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
| Column Name | Type | Description |
|---|---|---|
| VALUE_ID * | INTEGER not null | PK. |
| ATTRIBUTE_ID | INTEGER not null | Attribute. |
| DELETED | BOOLEANINT (1) null | Flag, which marks that attribute has been deleted. |
| ISSUE_ID | INTEGER not null | Issue that attribute belongs to. |
| NUMERIC_VALUE | INTEGER (11) null | some attributes are better saved in numeric format, so this column can be used in place of VALUE. |
| OPTION_ID | INTEGER null | Option that is the value of the attribute if attribute is option based. |
| USER_ID | INTEGER null | Person that is the value of the attribute if attribute is person based. |
| VALUE | LONGVARCHAR null | Display value of the attribute. This column should always contain a value which serves as a 'summary value' of the attribute, you MAY need to look elsewhere to get real value. Purpose of this 'duplication' is to be able to get overview of the attribute independently of what kind of attribute this is. This also improves performance so you do not need to perform (sometimes complex) processing each time you view the issue. It lets you get list of issues with their attributes with a single SQL statement. Examples of what would go into this fields for different kinds of attributes: - For 'free-form' attributes this would be the actual value (it's String representation to be exact) - For 'select-one' this would be a copy of value in SCARAB_ATTRIBUTE_OPTION.DISPLAY_VALUE. There will also be an apropriate value in OPTION_ID column which you should use to join with SCARAB_ATTRIBUTE_OPTION - For 'voted' attributes this would be the vote result. For bugzilla-style votes it is sum of all votes casted. For average vote this result is DISPLAY_VALUE of OPTION which has computed as: round(sum(votes.numeric_value)/count(votes)). For 'Tracking' attribute which is also considered a voted attribute this value is a list of login_IDs of users tracking the issue. It is responsibility of Attribute's subclass which implements this ATTRIBUTE_TYPE to populate this field with an apropriate value. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE | ATTRIBUTE_ID | ATTRIBUTE_ID |
| SCARAB_ATTRIBUTE_OPTION | OPTION_ID | OPTION_ID |
| SCARAB_ISSUE | ISSUE_ID | ISSUE_ID |
| TURBINE_USER | USER_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| ISSUE_ID * | INTEGER not null | |
| APPROVED | BOOLEANINT (1) null | |
| ATTACHMENT_TYPE_ID | INTEGER not null | |
| DESCRIPTION | VARCHAR (255) null | The description of the saved template. |
| NAME | VARCHAR (255) not null | Person. |
| SCOPE_ID | INTEGER not null | Scope : personal or global. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ISSUE | ISSUE_ID | ISSUE_ID |
| SCARAB_SCOPE | SCOPE_ID | SCOPE_ID |
| Column Name | Type | Description |
|---|---|---|
| ISSUE_TYPE_ID * | INTEGER not null | Unique identifier used for primary key. |
| DELETED | BOOLEANINT (1) null | |
| DESCRIPTION | VARCHAR (255) null | Description. |
| NAME | VARCHAR (100) not null | Name. |
| PARENT_ID | INTEGER not null | If this issue type is a template, the id of the issue type it Corresponds to. If is not, parent id is 0. |
| Column Name | Type | Description |
|---|---|---|
| ISSUE_ID * | INTEGER not null | Module. |
| USER_ID * | INTEGER not null | Person. |
| VOTES | INTEGER (3) null | The votes a user has cast for the issue. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ISSUE | ISSUE_ID | ISSUE_ID |
| TURBINE_USER | USER_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| COLUMN_ID * | INTEGER not null | Column of the table. |
| TABLE_ID * | INTEGER not null | Table. |
| CREATED_BY | INTEGER null | Person that set value to the column of the table initially. |
| CREATED_DATE | TIMESTAMP null | Date of the initial set of the column of the table. |
| MODIFIED_BY | INTEGER null | Person that made last modification to the column of the table. |
| MODIFIED_DATE | TIMESTAMP null | Date of the last modification of the column of the table. |
Logical category of issues. Usually corresponds to the software project. Example: Scarab
| Column Name | Type | Description |
|---|---|---|
| MODULE_ID * | INTEGER not null | Unique identifier. |
| CLASS_KEY | INTEGER null | |
| DELETED | BOOLEANINT (1) null | Flag, which marks that module has been deleted. |
| DOMAIN | VARCHAR (127) null | The instance name of scarab the module is located within. |
| MODULE_CODE | CHAR (4) not null | Abbreviation whose primary use to identify related issues. |
| MODULE_DESCRIPTION | VARCHAR (255) not null | Description. |
| MODULE_NAME | VARCHAR (255) not null | Name. It is RealName because Module implements the Turbine Group interface and having it as Name would clash with that interface. Please note that the result of group.getName() needs to be unique for each SCARAB_MODULE. |
| MODULE_URL | VARCHAR (255) null | URL pointing to the information on the module. |
| OWNER_ID | INTEGER null | Person that is responsible for the module. @deprecated. |
| PARENT_ID | INTEGER not null | Parent module containing the module. Allows for hierarchical structure of modules. |
| QA_CONTACT_ID | INTEGER null | Key quality assurance person for the module. @deprecated. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_MODULE | PARENT_ID | MODULE_ID |
| TURBINE_USER | OWNER_ID | USER_ID |
| TURBINE_USER | QA_CONTACT_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| QUERY_ID * | INTEGER not null | |
| APPROVED | BOOLEANINT (1) null | |
| CREATED_DATE | TIMESTAMP null | |
| DELETED | BOOLEANINT (1) null | |
| DESCRIPTION | VARCHAR (255) null | The description of the saved query. |
| ISSUE_TYPE_ID | INTEGER not null | Issue type. |
| MODULE_ID | INTEGER null | Module. |
| NAME | VARCHAR (255) not null | The name the query will be saved under. |
| SCOPE_ID | INTEGER not null | Type. |
| SUBSCRIPTION_FREQUENCY_ID | INTEGER null | Default subscription frequency. |
| USER_ID | INTEGER not null | Person. |
| VALUE | LONGVARCHAR not null | The query string. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_FREQUENCY | SUBSCRIPTION_FREQUENCY_ID | FREQUENCY_ID |
| SCARAB_ISSUE_TYPE | ISSUE_TYPE_ID | ISSUE_TYPE_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
| SCARAB_SCOPE | SCOPE_ID | SCOPE_ID |
| TURBINE_USER | USER_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| ATTRIBUTE_ID * | INTEGER not null | Attribute. |
| GROUP_ID * | INTEGER not null | Group. |
| PREFERRED_ORDER | INTEGER null |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE | ATTRIBUTE_ID | ATTRIBUTE_ID |
| SCARAB_ATTRIBUTE_GROUP | GROUP_ID | ATTRIBUTE_GROUP_ID |
| Column Name | Type | Description |
|---|---|---|
| ATTRIBUTE_ID * | INTEGER not null | Attribute. |
| ISSUE_TYPE_ID * | INTEGER not null | Issue type. |
| MODULE_ID * | INTEGER not null | Module. |
| ACTIVE | BOOLEANINT (1) not null | Flag, which marks that module attribute is not used. |
| DEFAULT_TEXT_FLAG | BOOLEANINT (1) not null | Flag, which marks that this attribute should be used in the email subject line, when an issue is created. May be used in other contexts as well. |
| DISPLAY_VALUE | VARCHAR (255) not null | Value that represents the attribute in the UI. |
| PREFERRED_ORDER | INTEGER not null | Column order. |
| QUICK_SEARCH | BOOLEANINT (1) not null | Flag, which marks this attribute as being eligible for quick search. |
| REQUIRED | BOOLEANINT (1) not null | Flag, which marks that issues entered for this module must have this attribute set. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE | ATTRIBUTE_ID | ATTRIBUTE_ID |
| SCARAB_ISSUE_TYPE | ISSUE_TYPE_ID | ISSUE_TYPE_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
| Column Name | Type | Description |
|---|---|---|
| ISSUE_TYPE_ID * | INTEGER not null | Artifact type. |
| MODULE_ID * | INTEGER not null | Module. |
| ACTIVE | BOOLEANINT (1) not null | Flag, which marks that the issue type is not used. |
| COMMENTS | INTEGER null | Default number of comments. |
| DEDUPE | BOOLEANINT (1) null | Deduping on/off for this module/issuetype. |
| DISPLAY | BOOLEANINT (1) not null | Whether or not the issue type shows up in left hand nav. |
| DISPLAY_DESCRIPTION | VARCHAR (255) null | Value that represents the description of the issue type in the UI. |
| DISPLAY_NAME | VARCHAR (255) null | Value that represents the name of the issue type in the UI. |
| HISTORY | INTEGER null | Default number of history entries. |
| PREFERRED_ORDER | INTEGER null | Order the the issue types appear in the left nav. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ISSUE_TYPE | ISSUE_TYPE_ID | ISSUE_TYPE_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
| Column Name | Type | Description |
|---|---|---|
| ISSUE_TYPE_ID * | INTEGER not null | Issue Type. |
| MODULE_ID * | INTEGER not null | Module. |
| OPTION_ID * | INTEGER not null | Option. |
| ACTIVE | BOOLEANINT (1) not null | Flag, which marks that option has been deleted within the module. |
| DISPLAY_VALUE | VARCHAR (255) null | Value that represents the option in the UI. |
| PREFERRED_ORDER | INTEGER null | Allows the template engineer and module owner some means to order option listings. |
| WEIGHT | INTEGER null |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE_OPTION | OPTION_ID | OPTION_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
SCARAB_R_MODULE_USER_ATTRIBUTE
| Column Name | Type | Description |
|---|---|---|
| ATTRIBUTE_ID * | INTEGER not null | Attribute. |
| ISSUE_TYPE_ID * | INTEGER not null | Artifact type. |
| MODULE_ID * | INTEGER not null | Module. |
| USER_ID * | INTEGER not null | Person. |
| PREFERRED_ORDER | INTEGER not null | Column order. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE | ATTRIBUTE_ID | ATTRIBUTE_ID |
| SCARAB_ISSUE_TYPE | ISSUE_TYPE_ID | ISSUE_TYPE_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
| TURBINE_USER | USER_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| OPTION1_ID * | INTEGER not null | Parent Option. |
| OPTION2_ID * | INTEGER not null | Child Option. |
| PREFERRED_ORDER | INTEGER not null | The preferred order that these options should be shown in. Each option should have a 1-N ordering for all of its options (regardless of nesting). |
| RELATIONSHIP_ID | INTEGER not null | The type of relationship. See the SCARAB_OPTION_RELATIONSHIP table for the different types. |
| WEIGHT | INTEGER null | This gives 'weight' to an option. In other words, it can be used to set the 'importance' of one option vs. another option. P1 can be made more 'important' than P2. This is currently not used in any of the code. This may become more useful in the future when we have outside workflow logic. This is placed here because an Attribute Option may have different weights with different parents. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTRIBUTE_OPTION | OPTION1_ID | OPTION_ID |
| SCARAB_ATTRIBUTE_OPTION | OPTION2_ID | OPTION_ID |
| SCARAB_OPTION_RELATIONSHIP | RELATIONSHIP_ID | RELATIONSHIP_ID |
| Column Name | Type | Description |
|---|---|---|
| QUERY_ID * | INTEGER not null | Query. |
| USER_ID * | INTEGER not null | Person. |
| IS_SUBSCRIBED | BOOLEANINT (1) null | Is user subscribed. |
| ISDEFAULT | BOOLEANINT (1) null | Whether this is the user's default query. |
| SUBSCRIPTION_FREQUENCY_ID | INTEGER null | User's subscription frequency. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_FREQUENCY | SUBSCRIPTION_FREQUENCY_ID | FREQUENCY_ID |
| SCARAB_QUERY | QUERY_ID | QUERY_ID |
| TURBINE_USER | USER_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| REPORT_ID * | INTEGER not null | |
| CREATED_DATE | TIMESTAMP null | |
| DELETED | BOOLEANINT (1) null | |
| DESCRIPTION | VARCHAR (255) null | The description of the saved report. |
| ISSUE_TYPE_ID | INTEGER not null | Issue type. |
| MODULE_ID | INTEGER null | Module. |
| NAME | VARCHAR (255) not null | The name the report will be saved under. |
| QUERY_STRING | LONGVARCHAR not null | The report string. |
| USER_ID | INTEGER not null | Person. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ISSUE_TYPE | ISSUE_TYPE_ID | ISSUE_TYPE_ID |
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
| TURBINE_USER | USER_ID | USER_ID |
| Column Name | Type | Description |
|---|---|---|
| TRANSACTION_ID * | INTEGER not null | Unique identifier. |
| ATTACHMENT_ID | INTEGER null | Comment added to modification. |
| CREATED_BY | INTEGER null | Person that performed the transaction. |
| CREATED_DATE | TIMESTAMP null | Date of the transaction. |
| TYPE_ID | INTEGER null | Possible enumerated transaction type. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_ATTACHMENT | ATTACHMENT_ID | ATTACHMENT_ID |
| SCARAB_TRANSACTION_TYPE | TYPE_ID | TYPE_ID |
| TURBINE_USER | CREATED_BY | USER_ID |
This table is used to store user preferences and other information relating to a specific user.
| Column Name | Type | Description |
|---|---|---|
| USER_ID * | INTEGER not null | Unique identifier. |
| PASSWORD_EXPIRE | TIMESTAMP not null | This is a column that Scarab standalone needs. Torque doesn't do anything with it at this point because this is an aliased table. Leaving it in here just as an FYI and in the hope that one day, Torque will generate the right methods even for aliased tables. |
A user's record of votes. It is assumed that a module that supports voting will give a new user some votes to use when the user is added, otherwise the user has no votes.
| Column Name | Type | Description |
|---|---|---|
| MODULE_ID * | INTEGER not null | Module. |
| USER_ID * | INTEGER not null | Person. |
| TOTAL_VOTES | INTEGER (3) null | The total votes a user is allowed to cast in a project. |
| USED_VOTES | INTEGER (3) null | The number of votes a user has cast in a project. |
| Foreign Table | Local Field | Foreign Field |
|---|---|---|
| SCARAB_MODULE | MODULE_ID | MODULE_ID |
| TURBINE_USER | USER_ID | USER_ID |
Dummy table for where the USER_ID lives. In most cases, this will be a foreign table outside of the scope of Scarab itself. For example, if you are using Scarab with Turbine, then this will be defined as TURBINE_USER. For use in other systems, you will want to define this to be the name of your own USER table and update the FK references in this file to point at the new name. Then, all you need to do is regenerate the OR code to use the new table name.