# Rundeck schema ERD

Table and field reference for the Fivetran Rundeck connector.

## Table & Field Reference

### project

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| name | Unknown | PK |
| description | Unknown |  |
| label | Unknown |  |
| url | Unknown |  |

### config_list

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| category | Unknown |  |
| label | Unknown |  |
| level | Unknown |  |
| value | Unknown |  |

### config_meta_list

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| auth_required | Unknown |  |
| category | Unknown |  |
| datatype | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| encrypted | Unknown |  |
| label | Unknown |  |
| link | Unknown |  |
| required | Unknown |  |
| restart | Unknown |  |
| strata | Unknown |  |
| visibility | Unknown |  |

### plugin

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| artifact_name | Unknown |  |
| author | Unknown |  |
| builtin | Unknown |  |
| description | Unknown |  |
| icon_url | Unknown |  |
| id | Unknown |  |
| plugin_version | Unknown |  |
| provider_metadata_faicon | Unknown |  |
| service | Unknown |  |
| title | Unknown |  |

### execution_successful_node

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| execution_id | Unknown | PK, FK |
| successfulnode | Unknown |  |

### execution_failed_node

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| execution_id | Unknown | PK, FK |
| failednode | Unknown |  |

### execution

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | FK |
| argstring | Unknown |  |
| custom_status | Unknown |  |
| date_ended_date | Unknown |  |
| date_ended_unixtime | Unknown |  |
| date_started_date | Unknown |  |
| date_started_unixtime | Unknown |  |
| job_average_duration | Unknown |  |
| project | Unknown |  |
| server_uuid | Unknown |  |
| status | Unknown |  |
| users | Unknown |  |
| custom_options_** |  |  |

### system_info

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| rundeck_server_uuid | Unknown | FK |
| cpu_load_average | Unknown |  |
| cpu_processor | Unknown |  |
| duration | Unknown |  |
| epoch | Unknown |  |
| executions_active | Unknown |  |
| executions_execution_mode | Unknown |  |
| extended_rundeck_pro_build_git | Unknown |  |
| extended_rundeck_pro_edition | Unknown |  |
| extended_rundeck_pro_version | Unknown |  |
| healthcheck_content_type | Unknown |  |
| healthcheck_href | Unknown |  |
| jvm_implementation_version | Unknown |  |
| jvm_name | Unknown |  |
| jvm_vendor | Unknown |  |
| jvm_version | Unknown |  |
| load_average_average | Unknown |  |
| load_average_unit | Unknown |  |
| metrics_content_type | Unknown |  |
| metrics_href | Unknown |  |
| os_arch | Unknown |  |
| os_name | Unknown |  |
| os_version | Unknown |  |
| ping_content_type | Unknown |  |
| ping_href | Unknown |  |
| processors | Unknown |  |
| rundeck_apiversion | Unknown |  |
| rundeck_base | Unknown |  |
| rundeck_build | Unknown |  |
| rundeck_build_git | Unknown |  |
| rundeck_node | Unknown |  |
| rundeck_version | Unknown |  |
| stats_cpu_load_average_average | Unknown |  |
| stats_cpu_load_average_unit | Unknown |  |
| stats_memory_free | Unknown |  |
| stats_memory_max | Unknown |  |
| stats_memory_total | Unknown |  |
| stats_memory_unit | Unknown |  |
| stats_scheduler_running | Unknown |  |
| stats_scheduler_thread_pool_size | Unknown |  |
| stats_threads_active | Unknown |  |
| stats_uptime_since_datetime | Unknown |  |
| stats_uptime_since_unit | Unknown |  |
| thread_dump_content_type | Unknown |  |
| thread_dump_href | Unknown |  |
| timestamp_datetime | Unknown |  |
| timestamp_epoch | Unknown |  |
| timestamp_unit | Unknown |  |
| unit | Unknown |  |

### log_storage

| Column | Type | Keys |
| --- | --- | --- |
| plugin_name | Unknown | PK, FK |
| enabled | Unknown |  |
| failed_count | Unknown |  |
| incomplete_count | Unknown |  |
| missing_count | Unknown |  |
| queued_count | Unknown |  |
| queued_incomplete_count | Unknown |  |
| queued_request_count | Unknown |  |
| queued_retries_count | Unknown |  |
| retries_count | Unknown |  |
| succeeded_count | Unknown |  |
| total_count | Unknown |  |

### user_class

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| message | Unknown |  |
| state | Unknown |  |
| custom_allocations_** |  |  |
| custom_entitled_** |  |  |
| custom_exceeded_** |  |  |
| custom_summary_** |  |  |

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| login | Unknown | PK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_job | Unknown |  |
| last_name | Unknown |  |
| token | Unknown |  |
| updated | Unknown |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_name | Unknown | FK |
| description | Unknown |  |
| enabled | Unknown |  |
| groups | Unknown |  |
| href | Unknown |  |
| name | Unknown |  |
| perma_link | Unknown |  |
| schedule_enabled | Unknown |  |
| scheduled | Unknown |  |
| server_node_uuid | Unknown |  |
| server_owner | Unknown |  |

## Relationships

- execution_successful_node(execution_id) → execution(id)
- execution_failed_node(execution_id) → execution(id)
- execution(job_id) → job(id)
- system_info(rundeck_server_uuid) → job(server_node_uuid)
- log_storage(plugin_name) → plugin(name)
- job(project_name) → project(name)