MASTERFEATURES
- Last Updated: July 30, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- Aha! 8.0
- Documentation
Endpoint
<hostname>/api/v1/master_features
Columns
The MASTERFEATURES table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| ID* | BigInt |
| ASSIGNED_TO_USER_CREATED_AT | Timestamp(3) |
| ASSIGNED_TO_USER_DEFAULT_ASSIGNEE | Boolean |
| ASSIGNED_TO_USER_EMAIL | VarChar(64) |
| ASSIGNED_TO_USER_ID | Integer |
| ASSIGNED_TO_USER_NAME | VarChar(64) |
| ASSIGNED_TO_USER_UPDATED_AT | Timestamp(3) |
| ATTACHMENTS_CONTENT_TYPE | VarChar(64) |
| ATTACHMENTS_CREATED_AT | Timestamp(9) |
| ATTACHMENTS_DOWNLOAD_URL | VarChar(207) |
| ATTACHMENTS_FILE_NAME | VarChar(64) |
| ATTACHMENTS_FILE_SIZE | Integer |
| ATTACHMENTS_ID | BigInt |
| ATTACHMENTS_UPDATED_AT | Timestamp(9) |
| COMMENTS_COUNT | Integer |
| CREATED_AT | Timestamp(3) |
| CREATED_BY_USER_CREATED_AT | Timestamp(3) |
| CREATED_BY_USER_EMAIL | VarChar(64) |
| CREATED_BY_USER_ID | Integer |
| CREATED_BY_USER_NAME | VarChar(64) |
| CREATED_BY_USER_UPDATED_AT | Timestamp(3) |
| DESCRIPTION_BODY | VarChar(1024) |
| DESCRIPTION_CREATED_AT | Timestamp(3) |
| DESCRIPTION_ID | Integer |
| DUE_DATE | Date |
| INITIATIVE_CREATED_AT | Timestamp(3) |
| INITIATIVE_DESCRIPTION_BODY | VarChar(1024) |
| INITIATIVE_DESCRIPTION_CREATED_AT | Timestamp(3) |
| INITIATIVE_DESCRIPTION_ID | BigInt |
| INITIATIVE_ID | Integer |
| INITIATIVE_NAME | VarChar(64) |
| INITIATIVE_RESOURCE | VarChar(73) |
| INITIATIVE_URL | VarChar(64) |
| KEY | VarChar(64) |
| MASTER_FEATURE_ONLY_ORIGINAL_ESTIMATE | VarChar(64) |
| MASTER_FEATURE_ONLY_REMAINING_ESTIMATE | VarChar(64) |
| MASTER_FEATURE_ONLY_WORK_DONE | VarChar(64) |
| NAME | VarChar(64) |
| POSITION | Integer |
| PRODUCT_ID | Integer |
| PROGRESS | VarChar(64) |
| PROGRESS_SOURCE | VarChar(64) |
| RELEASE_CREATED_AT | Timestamp(3) |
| RELEASE_ID | BigInt |
| RELEASE_NAME | VarChar(64) |
| RELEASE_OWNER_CREATED_AT | Timestamp(3) |
| RELEASE_OWNER_EMAIL | VarChar(64) |
| RELEASE_OWNER_ID | Integer |
| RELEASE_OWNER_NAME | VarChar(64) |
| RELEASE_OWNER_UPDATED_AT | Timestamp(3) |
| RELEASE_PARKING_LOT | Boolean |
| RELEASE_PRODUCT_ID | Integer |
| RELEASE_PROJECT_CREATED_AT | Timestamp(3) |
| RELEASE_PROJECT_ID | Integer |
| RELEASE_PROJECT_NAME | VarChar(64) |
| RELEASE_PROJECT_PRODUCT_LINE | Boolean |
| RELEASE_PROJECT_REFERENCE_PREFIX | VarChar(64) |
| RELEASE_REFERENCE_NUM | VarChar(64) |
| RELEASE_RELEASE_DATE | Date |
| RELEASE_RESOURCE | VarChar(69) |
| RELEASE_START_DATE | Date |
| RELEASE_URL | VarChar(64) |
| RESOURCE | VarChar(79) |
| SCORE | VarChar(64) |
| SCORE_FACTS_ID | BigInt |
| SCORE_FACTS_NAME | VarChar(64) |
| SCORE_FACTS_VALUE | Integer |
| START_DATE | Date |
| UPDATED_AT | Timestamp(3) |
| URL | VarChar(64) |
| WORKFLOW_STATUS_COLOR | VarChar(64) |
| WORKFLOW_STATUS_COMPLETE | Boolean |
| WORKFLOW_STATUS_ID | Integer |
| WORKFLOW_STATUS_NAME | VarChar(64) |
| WORKFLOW_STATUS_POSITION | Integer |