FEATURES
- Last Updated: July 30, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- Aha! 8.0
- Documentation
Endpoint
<hostname>/api/v1/features
Columns
The FEATURES table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| ID* | BigInt |
| ASSIGNED_TO_USER | VarChar(64) |
| COMMENTS_COUNT | Integer |
| CREATED_AT | Timestamp(3) |
| CREATED_BY_USER_AVATAR_URL | VarChar(174) |
| CREATED_BY_USER_CREATED_AT | Timestamp(3) |
| CREATED_BY_USER_EMAIL | VarChar(64) |
| CREATED_BY_USER_ID | BigInt |
| CREATED_BY_USER_NAME | VarChar(64) |
| CREATED_BY_USER_UPDATED_AT | Timestamp(3) |
| DESCRIPTION_BODY | VarChar(1024) |
| DESCRIPTION_CREATED_AT | Timestamp(3) |
| DESCRIPTION_ID | BigInt |
| DUE_DATE | VarChar(64) |
| FEATURE_ONLY_ORIGINAL_ESTIMATE | VarChar(64) |
| FEATURE_ONLY_REMAINING_ESTIMATE | VarChar(64) |
| FEATURE_ONLY_WORK_DONE | VarChar(64) |
| FEATURETIMETRACKING_ID | BigInt |
| FEATURETIMETRACKING_OCCURRED_ON | Date |
| FEATURETIMETRACKING_USER_CREATED_AT | Timestamp(3) |
| FEATURETIMETRACKING_USER_EMAIL | VarChar(64) |
| FEATURETIMETRACKING_USER_ID | BigInt |
| FEATURETIMETRACKING_USER_NAME | VarChar(64) |
| FEATURETIMETRACKING_USER_UPDATED_AT | Timestamp(3) |
| FEATURETIMETRACKING_WORK_DONE | Double |
| FEATURETIMETRACKING_WORK_UNITS | Integer |
| INITIATIVE_CREATED_AT | Timestamp(3) |
| INITIATIVE_DESCRIPTION_BODY | VarChar(1024) |
| INITIATIVE_DESCRIPTION_CREATED_AT | Timestamp(3) |
| INITIATIVE_DESCRIPTION_ID | BigInt |
| INITIATIVE_ID | BigInt |
| INITIATIVE_NAME | VarChar(64) |
| INITIATIVE_RESOURCE | VarChar(87) |
| INITIATIVE_URL | VarChar(76) |
| KEY | VarChar(64) |
| NAME | VarChar(127) |
| ORIGINAL_ESTIMATE | VarChar(64) |
| POSITION | Integer |
| PRODUCT_ID | BigInt |
| PROGRESS | VarChar(64) |
| PROGRESS_SOURCE | VarChar(64) |
| RELEASE_CREATED_AT | Timestamp(3) |
| RELEASE_ID | BigInt |
| RELEASE_KEY | VarChar(64) |
| RELEASE_NAME | VarChar(64) |
| RELEASE_OWNER_AVATAR_URL | VarChar(174) |
| RELEASE_OWNER_CREATED_AT | Timestamp(3) |
| RELEASE_OWNER_EMAIL | VarChar(64) |
| RELEASE_OWNER_ID | BigInt |
| RELEASE_OWNER_NAME | VarChar(64) |
| RELEASE_OWNER_UPDATED_AT | Timestamp(3) |
| RELEASE_PARKING_LOT | Boolean |
| RELEASE_PRODUCT_ID | BigInt |
| RELEASE_PROJECT_CREATED_AT | Timestamp(3) |
| RELEASE_PROJECT_ID | BigInt |
| RELEASE_PROJECT_NAME | VarChar(64) |
| RELEASE_PROJECT_PRODUCT_LINE | Boolean |
| RELEASE_PROJECT_REFERENCE_PREFIX | VarChar(64) |
| RELEASE_RESOURCE | VarChar(87) |
| RELEASE_URL | VarChar(76) |
| REMAINING_ESTIMATE | VarChar(64) |
| RESOURCE | VarChar(84) |
| SCORE | Integer |
| START_DATE | VarChar(64) |
| UPDATED_AT | Timestamp(3) |
| URL | VarChar(73) |
| USE_REQUIREMENTS_ESTIMATES | Boolean |
| WORK_DONE | VarChar(64) |
| WORK_UNITS | Integer |
| WORKFLOW_KIND_ID | BigInt |
| WORKFLOW_KIND_NAME | VarChar(64) |
| WORKFLOW_STATUS_COLOR | VarChar(64) |
| WORKFLOW_STATUS_COMPLETE | Boolean |
| WORKFLOW_STATUS_ID | BigInt |
| WORKFLOW_STATUS_NAME | VarChar(64) |
| WORKFLOW_STATUS_POSITION | Integer |