references/models-early-access-features.md
Early Access Features
EarlyAccessFeature (system.early_access_features)
Early access features let teams manage staged feature rollouts where users can opt in. Each feature is linked to a feature flag that controls access.
Columns
Column | Type | Nullable | Description
--- | --- | --- | ---
id | String | NOT NULL | Early access feature UUID.
team_id | Integer | NOT NULL |
feature_flag_id | Integer | NOT NULL | Feature flag gating the feature; joins to feature_flags.id.
name | String | NOT NULL | Feature name shown to users.
description | String | NOT NULL | Feature description shown to users.
stage | String | NOT NULL | Lifecycle stage, e.g. 'concept', 'beta', 'general-availability'.
documentation_url | String | NOT NULL | Link to the feature's documentation.
created_by_id | Integer | NULL | User who created the feature.
created_at | DateTime | NOT NULL | When the feature was created.
Stage Values
Value | Description
draft | Initial stage, not visible to users
concept | Gauging interest, opt-in tracked but feature flag not enabled
alpha | Active stage, opted-in users get the feature flag enabled
beta | Active stage, opted-in users get the feature flag enabled
general-availability | Active stage, feature available to all users
archived | Feature retired, flag enrollment conditions removed
Active stages (where opted-in users get the feature flag enabled): alpha, beta, general-availability.
Key Relationships
- Feature flags:
feature_flag_id->system.feature_flags.id
Important Notes
- The
stagefield uses a hyphenated valuegeneral-availability(not underscore). - Features without a
feature_flag_idare rare but possible during creation errors. - There is no soft-delete column; deleted features are removed from the table.
Common Query Patterns
List all early access features with their stages:
SELECT id, name, stage, feature_flag_id, created_at
FROM system.early_access_features
ORDER BY created_at DESC
LIMIT 100
Find active features (in alpha, beta, or GA):
SELECT id, name, stage, feature_flag_id
FROM system.early_access_features
WHERE stage IN ('alpha', 'beta', 'general-availability')
ORDER BY created_at DESC
Join with feature flags to see flag keys:
SELECT eaf.id, eaf.name, eaf.stage, ff.key AS flag_key
FROM system.early_access_features AS eaf
LEFT JOIN system.feature_flags AS ff ON eaf.feature_flag_id = ff.id
ORDER BY eaf.created_at DESC
LIMIT 100