# Appcues schema ERD

Table and field reference for the Fivetran Appcues connector.

## Table & Field Reference

### checklist

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| cloned_by | Unknown |  |
| cloned_from | Unknown |  |
| completion_flow_id | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| internal_name | Unknown |  |
| intro_flow_id | Unknown |  |
| is_dismissable | Unknown |  |
| is_sequential | Unknown |  |
| items | Json |  |
| published | Unknown |  |
| published_and_dirty | Unknown |  |
| published_at | Unknown |  |
| published_by | Unknown |  |
| rule | Json |  |
| state | Unknown |  |
| style_beacon_background_color | Unknown |  |
| style_beacon_horizontal_offset | Unknown |  |
| style_beacon_icon | Unknown |  |
| style_beacon_text_color | Unknown |  |
| style_beacon_vertical_offset | Unknown |  |
| style_completion_icon | Unknown |  |
| style_header_icon | Unknown |  |
| style_position | Unknown |  |
| style_primary_color | Unknown |  |
| style_success_color | Unknown |  |
| style_success_image_code | Unknown |  |
| style_type | Unknown |  |
| text_token_beacon_text | Unknown |  |
| text_token_completion_dismiss_text | Unknown |  |
| text_token_completion_text | Unknown |  |
| text_token_completion_title | Unknown |  |
| text_token_description_text | Unknown |  |
| text_token_dismiss_cancel_text | Unknown |  |
| text_token_dismiss_confirm_text | Unknown |  |
| text_token_dismiss_prompt_text | Unknown |  |
| text_token_dismiss_text | Unknown |  |
| text_token_header_text | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| unpublished_at | Unknown |  |
| unpublished_by | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |

### launch_pad_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| launch_pad_id | Unknown | PK, FK |
| actions | Json |  |
| children | Json |  |
| content | Json |  |
| content_type | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| index | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| rows | Json |  |
| traits | Json |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |

### launch_pad_trait

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| launch_pad_id | Unknown | PK, FK |
| type | Unknown |  |

### launch_pad

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| app_id | Unknown |  |
| contains_localized_block | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| experiment | Unknown |  |
| frequency | Unknown |  |
| locked_for_localization | Unknown |  |
| name | Unknown |  |
| platform | Unknown |  |
| preview_url | Unknown |  |
| public_name | Unknown |  |
| published | Unknown |  |
| published_at | Unknown |  |
| schema_version | Unknown |  |
| tag_ids | Json |  |
| tags | Json |  |
| theme | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| url | Unknown |  |

### flow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| frequency | Unknown |  |
| name | Unknown |  |
| published | Unknown |  |
| published_at | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |

### pin_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| pin_id | Unknown | PK, FK |
| actions | Json |  |
| content | Json |  |
| content_type | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| index | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |

### pin_trait

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| pin_id | Unknown | PK, FK |

### pin

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| app_id | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| experiment | Unknown |  |
| frequency | Unknown |  |
| locked_for_localization | Unknown |  |
| name | Unknown |  |
| platform | Unknown |  |
| preview_url | Unknown |  |
| published | Unknown |  |
| published_at | Unknown |  |
| schema_version | Unknown |  |
| state | Unknown |  |
| tags | Json |  |
| theme | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| url | Unknown |  |

### banner_step_trait

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| banner_id | Unknown | PK, FK |
| banner_step_id | Unknown | PK, FK |
| config | Json |  |
| type | Unknown |  |

### banner_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| banner_id | Unknown | PK, FK |
| actions | Json |  |
| children | Json |  |
| content | Json |  |
| content_type | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| index | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| rows | Json |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |

### banner_trait

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| banner_id | Unknown | PK, FK |
| config | Json |  |
| type | Unknown |  |

### banner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| app_id | Unknown |  |
| contains_localized_block | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| created_by_email | Unknown |  |
| experiment | Unknown |  |
| frequency | Unknown |  |
| locked_for_localization | Unknown |  |
| name | Unknown |  |
| platform | Unknown |  |
| preview_url | Unknown |  |
| public_name | Unknown |  |
| published | Unknown |  |
| published_and_dirty | Unknown |  |
| published_at | Unknown |  |
| schema_version | Unknown |  |
| tag_ids | Json |  |
| tags | Json |  |
| theme | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| updated_by_email | Unknown |  |
| url | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| url | Unknown |  |

### mobile_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mobile_id | Unknown | PK, FK |
| actions | Json |  |
| content | Json |  |
| content_type | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| index | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |

### mobile_trait

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| mobile_id | Unknown | PK, FK |

### mobile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| app_id | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| experiment | Unknown |  |
| frequency | Unknown |  |
| locked_for_localization | Unknown |  |
| name | Unknown |  |
| platform | Unknown |  |
| preview_url | Unknown |  |
| published | Unknown |  |
| published_at | Unknown |  |
| schema_version | Unknown |  |
| state | Unknown |  |
| tags | Json |  |
| theme | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| url | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| attributes | Json |  |
| id | Unknown |  |
| name | Unknown |  |
| timestamps | Unknown |  |
| user_id | Unknown |  |

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| user_id | Unknown |  |
| custom_** |  |  |

## Relationships

- launch_pad_step(launch_pad_id) → launch_pad(id)
- launch_pad_trait(launch_pad_id) → launch_pad(id)
- pin_step(pin_id) → pin(id)
- pin_trait(pin_id) → pin(id)
- banner_step_trait(banner_id) → banner_step(banner_id)
- banner_step_trait(banner_step_id) → banner_step(id)
- banner_step(banner_id) → banner(id)
- banner_trait(banner_id) → banner(id)
- mobile_step(mobile_id) → mobile(id)
- mobile_trait(mobile_id) → mobile(id)