# LaunchDarkly schema ERD

Table and field reference for the Fivetran LaunchDarkly connector.

## Table & Field Reference

### audit_log_access

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| audit_log_id | Unknown | PK, FK |
| action | Unknown |  |
| resource | Unknown |  |

### audit_log_target_resource

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| audit_log_id | Unknown | PK, FK |
| resource | Unknown |  |

### audit_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| app_id | Unknown |  |
| app_is_scim | Unknown |  |
| app_maintainer_name | Unknown |  |
| app_name | Unknown |  |
| comment | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| kind | Unknown |  |
| member_email | Unknown |  |
| member_first_name | Unknown |  |
| member_id | Unknown |  |
| member_last_name | Unknown |  |
| name | Unknown |  |
| parent_name | Unknown |  |
| parent_resource | Unknown |  |
| short_description | Unknown |  |
| subject_avatar_url | Unknown |  |
| subject_name | Unknown |  |
| target_name | Unknown |  |
| title | Unknown |  |
| title_verb | Unknown |  |
| token_ending | Unknown |  |
| token_id | Unknown |  |
| token_name | Unknown |  |
| token_service_token | Unknown |  |
| app_links_** |  |  |
| links_** |  |  |
| member_links_** |  |  |
| parent_links_** |  |  |
| subject_links_** |  |  |
| target_links_** |  |  |
| token_links_** |  |  |

### project_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_key | Unknown | PK, FK |
| tags | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| id | Unknown |  |
| include_in_snippet_by_default | Unknown |  |
| name | Unknown |  |
| using_environment_id | Unknown |  |
| using_mobile_key | Unknown |  |

### flag_default_project_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| tags | Unknown |  |

### flag_default_project

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_key | Unknown | FK |
| false_description | Unknown |  |
| false_display_name | Unknown |  |
| off_variation | Unknown |  |
| on_variation | Unknown |  |
| temporary | Unknown |  |
| true_description | Unknown |  |
| true_display_name | Unknown |  |
| using_environment_id | Unknown |  |
| using_mobile_key | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| environment_key | Unknown | PK, FK |
| tags | Unknown |  |

### required_approval_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| environment_key | Unknown | PK, FK |
| tags | Unknown |  |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| project_key | Unknown | FK |
| bypass_approvals_for_pending_changes | Unknown |  |
| can_apply_declined_changes | Unknown |  |
| can_review_own_request | Unknown |  |
| color | Unknown |  |
| confirm_change | Unknown |  |
| default_track_event | Unknown |  |
| default_ttl | Unknown |  |
| id | Unknown |  |
| min_num_approvals | Unknown |  |
| name | Unknown |  |
| require_comment | Unknown |  |
| required | Unknown |  |
| secure_mode | Unknown |  |
| service_config | Json |  |
| service_kind | Unknown |  |

### feature_flag_variation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### feature_flag_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| tags | Unknown |  |

### feature_flag_experiment_environment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| main_metric_key | Unknown | PK, FK |
| environment | Unknown |  |

### feature_flag_experiment

| Column | Type | Keys |
| --- | --- | --- |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| main_metric_key | Unknown | PK, FK |
| metric_key | Unknown | FK |
| environment_setting_** |  |  |

### feature_flag_environment_rule_clause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_environment_rule_id | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| attribute | Unknown |  |
| context_kind | Unknown |  |
| negate | Unknown |  |
| op | Unknown |  |
| values | Json |  |

### feature_flag_environment_rule_rollout_variation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_environment_rule_id | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| untracked | Unknown |  |
| variation | Unknown |  |
| weight | Unknown |  |

### feature_flag_environment_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| description | Unknown |  |
| ref | Unknown |  |
| rollout_bucket_by | Unknown |  |
| rollout_context_kind | Unknown |  |
| rollout_experiment_allocation_can_reshuffle | Unknown |  |
| rollout_experiment_allocation_default_variation | Unknown |  |
| rollout_seed | Unknown |  |
| track_event | Unknown |  |
| variation | Unknown |  |

### feature_flag_environment_fallthrough_rollout_variation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| untracked | Unknown |  |
| variation | Unknown |  |
| weight | Unknown |  |

### feature_flag_environment_target

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| context_kind | Unknown |  |
| values | Json |  |
| variation | Unknown |  |

### feature_flag_environment_context_target

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| context_kind | Unknown |  |
| values | Json |  |
| variation | Unknown |  |

### feature_flag_environment_prerequisite

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| key | Unknown |  |
| variation | Unknown |  |

### feature_flag_environment_action_denied

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| action | Unknown |  |
| reason | Json |  |

### feature_flag_environment_action_allowed

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| action | Unknown |  |
| reason | Json |  |

### feature_flag_environment_evaluation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_environment_index | Unknown | PK, FK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| context_kind | Unknown |  |

### feature_flag_environment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feature_flag_key | Unknown | PK, FK |
| feature_flag_project_key | Unknown | PK, FK |
| archived | Unknown |  |
| debug_events_until_date | Unknown |  |
| environment_name | Unknown |  |
| fallthrough_rollout_bucket_by | Unknown |  |
| fallthrough_rollout_context_kind | Unknown |  |
| fallthrough_rollout_experiment_allocation_can_reshuffle | Unknown |  |
| fallthrough_rollout_experiment_allocation_default_variation | Unknown |  |
| fallthrough_rollout_seed | Unknown |  |
| fallthrough_variation | Unknown |  |
| is_on | Unknown |  |
| last_modified | Unknown |  |
| migration_setting_check_ratio | Unknown |  |
| off_variation | Unknown |  |
| salt | Unknown |  |
| sel | Unknown |  |
| site_href | Unknown |  |
| site_type | Unknown |  |
| summary_prerequisite | Unknown |  |
| track_event | Unknown |  |
| track_event_fallthrough | Unknown |  |
| version | Unknown |  |
| summary_variations_** |  |  |

### feature_flag

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| project_key | Unknown | PK |
| associated_maintainer_id | Unknown | FK |
| associated_maintainer_team_key | Unknown | FK |
| maintainer_id | Unknown | FK |
| maintainer_team_key | Unknown | FK |
| archived | Unknown |  |
| archived_date | Unknown |  |
| baseline_idx | Unknown |  |
| creation_date | Unknown |  |
| deprecated | Unknown |  |
| deprecated_date | Unknown |  |
| description | Unknown |  |
| include_in_snippet | Unknown |  |
| kind | Unknown |  |
| maintainer_email | Unknown |  |
| maintainer_first_name | Unknown |  |
| maintainer_last_name | Unknown |  |
| maintainer_role | Unknown |  |
| migration_setting_context_kind | Unknown |  |
| migration_setting_stage_count | Unknown |  |
| name | Unknown |  |
| off_variation | Unknown |  |
| on_variation | Unknown |  |
| purpose | Unknown |  |
| temporary | Unknown |  |
| using_environment_id | Unknown |  |
| using_mobile_key | Unknown |  |
| version | Unknown |  |
| custom_property_** |  |  |

### rule_clause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| segment_key | Unknown | PK, FK |
| segment_rule_id | Unknown | PK, FK |
| attribute | Unknown |  |
| negate | Unknown |  |
| op | Unknown |  |
| values | Json |  |

### segment_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| segment_key | Unknown | PK, FK |
| bucket_by | Unknown |  |
| rollout_context_kind | Unknown |  |
| weight | Unknown |  |

### segment_tags

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| environment_key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| segment_key | Unknown | PK, FK |
| tags | Unknown |  |

### segment_flag

| Column | Type | Keys |
| --- | --- | --- |
| environment_key | Unknown | PK, FK |
| key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| segment_key | Unknown | PK, FK |

### segment_included_contexts

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| environment_key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| segment_key | Unknown | PK, FK |
| context_kind | Unknown |  |
| values | Json |  |

### segment_excluded_contexts

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| environment_key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| segment_key | Unknown | PK, FK |
| context_kind | Unknown |  |
| values | Json |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| environment_key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| creation_date | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| external | Unknown |  |
| external_link | Unknown |  |
| generation | Unknown |  |
| import_in_progress | Unknown |  |
| name | Unknown |  |
| unbounded | Unknown |  |
| unbounded_context_kind | Unknown |  |
| version | Unknown |  |
| unbounded_metadata_** |  |  |

### segment_access

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| environment_key | Unknown | FK |
| project_key | Unknown | FK |
| segment_key | Unknown | FK |
| access_type | Unknown |  |
| action | Unknown |  |
| actions | Json |  |
| effect | Unknown |  |
| not_actions | Json |  |
| not_resources | Json |  |
| resources | Json |  |
| role_name | Unknown |  |

### segment_target

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| target_key | Unknown | PK |
| environment_key | Unknown | PK, FK |
| project_key | Unknown | PK, FK |
| segment_key | Unknown | PK, FK |
| object_type | Unknown |  |

### metric_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| metric_key | Unknown | PK, FK |
| tags | Unknown |  |

### metric_randomization_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| metric_key | Unknown | PK, FK |
| randomization_unit | Unknown |  |

### metric

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| associated_maintainer_id | Unknown | FK |
| maintainer_id | Unknown | FK |
| project_key | Unknown | FK |
| attached_flag_count | Unknown |  |
| creation_date | Unknown |  |
| description | Unknown |  |
| event_key | Unknown |  |
| experiment_count | Unknown |  |
| id | Unknown |  |
| is_numeric | Unknown |  |
| kind | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| success_criteria | Unknown |  |
| unit | Unknown |  |

### metric_access

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| metric_key | Unknown | FK |
| access_type | Unknown |  |
| action | Unknown |  |
| actions | Json |  |
| effect | Unknown |  |
| not_actions | Json |  |
| not_resources | Json |  |
| resources | Json |  |
| role_name | Unknown |  |

### role_project

| Column | Type | Keys |
| --- | --- | --- |
| project_key | Unknown | PK, FK |
| role_key | Unknown | PK, FK |
| role_team_key | Unknown | PK, FK |

### role

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| team_key | Unknown | PK, FK |
| applied_on | Unknown |  |
| name | Unknown |  |

### team_project

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK, FK |
| team_key | Unknown | PK, FK |

### maintainer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_key | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| role | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| creation_date | Unknown |  |
| description | Unknown |  |
| identity_provider_sync | Unknown |  |
| last_modified | Unknown |  |
| maintainers_total_count | Unknown |  |
| members_total_count | Unknown |  |
| name | Unknown |  |
| project_total_count | Unknown |  |
| roles_total_count | Unknown |  |
| version | Unknown |  |

### team_access

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| team_key | Unknown | FK |
| access_type | Unknown |  |
| action | Unknown |  |
| actions | Json |  |
| effect | Unknown |  |
| not_actions | Json |  |
| not_resources | Json |  |
| resources | Json |  |
| role_name | Unknown |  |

## Relationships

- audit_log_access(audit_log_id) → audit_log(id)
- audit_log_target_resource(audit_log_id) → audit_log(id)
- project_tag(project_key) → project(key)
- flag_default_project_tag(_fivetran_id) → flag_default_project(_fivetran_id)
- flag_default_project(project_key) → project(key)
- tags(environment_key) → environment(key)
- required_approval_tag(environment_key) → environment(key)
- environment(project_key) → project(key)
- feature_flag_variation(feature_flag_key) → feature_flag(key)
- feature_flag_variation(feature_flag_project_key) → feature_flag(project_key)
- feature_flag_tag(feature_flag_key) → feature_flag(key)
- feature_flag_tag(feature_flag_project_key) → feature_flag(project_key)
- feature_flag_experiment_environment(main_metric_key) → feature_flag_experiment(main_metric_key)
- feature_flag_experiment_environment(feature_flag_project_key) → feature_flag_experiment(feature_flag_project_key)
- feature_flag_experiment_environment(feature_flag_key) → feature_flag_experiment(feature_flag_key)
- feature_flag_experiment(main_metric_key) → metric(key)
- feature_flag_experiment(metric_key) → metric(key)
- feature_flag_experiment(feature_flag_key) → feature_flag(key)
- feature_flag_experiment(feature_flag_project_key) → feature_flag(project_key)
- feature_flag_environment_rule_clause(feature_flag_key) → feature_flag_environment_rule(feature_flag_key)
- feature_flag_environment_rule_clause(feature_flag_project_key) → feature_flag_environment_rule(feature_flag_project_key)
- feature_flag_environment_rule_clause(feature_flag_environment_index) → feature_flag_environment_rule(feature_flag_environment_index)
- feature_flag_environment_rule_clause(feature_flag_environment_rule_id) → feature_flag_environment_rule(id)
- feature_flag_environment_rule_rollout_variation(feature_flag_key) → feature_flag_environment_rule(feature_flag_key)
- feature_flag_environment_rule_rollout_variation(feature_flag_project_key) → feature_flag_environment_rule(feature_flag_project_key)
- feature_flag_environment_rule_rollout_variation(feature_flag_environment_index) → feature_flag_environment_rule(feature_flag_environment_index)
- feature_flag_environment_rule_rollout_variation(feature_flag_environment_rule_id) → feature_flag_environment_rule(id)
- feature_flag_environment_rule(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_rule(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_rule(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment_fallthrough_rollout_variation(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_fallthrough_rollout_variation(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_fallthrough_rollout_variation(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment_target(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_target(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_target(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment_context_target(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_context_target(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_context_target(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment_prerequisite(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_prerequisite(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_prerequisite(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment_action_denied(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_action_denied(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_action_denied(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment_action_allowed(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_action_allowed(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_action_allowed(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment_evaluation(feature_flag_key) → feature_flag_environment(feature_flag_key)
- feature_flag_environment_evaluation(feature_flag_project_key) → feature_flag_environment(feature_flag_project_key)
- feature_flag_environment_evaluation(feature_flag_environment_index) → feature_flag_environment(index)
- feature_flag_environment(feature_flag_key) → feature_flag(key)
- feature_flag_environment(feature_flag_project_key) → feature_flag(project_key)
- feature_flag(maintainer_team_key) → team(key)
- feature_flag(associated_maintainer_team_key) → team(key)
- feature_flag(associated_maintainer_id) → maintainer(id)
- feature_flag(maintainer_id) → maintainer(id)
- rule_clause(segment_rule_id) → segment_rule(id)
- rule_clause(segment_key) → segment_rule(segment_key)
- rule_clause(project_key) → segment_rule(project_key)
- rule_clause(environment_key) → segment_rule(environment_key)
- segment_rule(segment_key) → segment(key)
- segment_rule(project_key) → segment(project_key)
- segment_rule(environment_key) → segment(environment_key)
- segment_tags(segment_key) → segment(key)
- segment_tags(project_key) → segment(project_key)
- segment_tags(environment_key) → segment(environment_key)
- segment_flag(key) → feature_flag(key)
- segment_flag(segment_key) → segment(key)
- segment_flag(project_key) → segment(project_key)
- segment_flag(environment_key) → segment(environment_key)
- segment_included_contexts(segment_key) → segment(key)
- segment_included_contexts(project_key) → segment(project_key)
- segment_included_contexts(environment_key) → segment(environment_key)
- segment_excluded_contexts(segment_key) → segment(key)
- segment_excluded_contexts(project_key) → segment(project_key)
- segment_excluded_contexts(environment_key) → segment(environment_key)
- segment(project_key) → project(key)
- segment(environment_key) → environment(key)
- segment_access(segment_key) → segment(key)
- segment_access(project_key) → segment(project_key)
- segment_access(environment_key) → segment(environment_key)
- segment_target(segment_key) → segment(key)
- segment_target(project_key) → segment(project_key)
- segment_target(environment_key) → segment(environment_key)
- metric_tag(metric_key) → metric(key)
- metric_randomization_unit(metric_key) → metric(key)
- metric(maintainer_id) → maintainer(id)
- metric(associated_maintainer_id) → maintainer(id)
- metric(project_key) → project(key)
- metric_access(metric_key) → metric(key)
- role_project(project_key) → project(key)
- role_project(role_key) → role(key)
- role_project(role_team_key) → role(team_key)
- role(team_key) → team(key)
- team_project(key) → project(key)
- team_project(team_key) → team(key)
- maintainer(team_key) → team(key)
- team_access(team_key) → team(key)