# Alida schema ERD

Table and field reference for the Fivetran Alida connector.

## Table & Field Reference

### member_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | FK |
| batch_id | Unknown |  |
| communication_id | Unknown |  |
| community_id | Unknown |  |
| create_date | Instant |  |
| created_by | Unknown |  |
| event_date | Unknown |  |
| event_type | Unknown |  |
| member_data_set_type | Unknown |  |
| member_id | Unknown |  |
| participant_type | Unknown |  |
| redirect_url | Unknown |  |

### member_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| closed_on | Unknown |  |
| communication_id | Unknown |  |
| communication_status | Unknown |  |
| communicationtn_type | Unknown |  |
| create_date | Unknown |  |
| created_by | Unknown |  |
| description | Unknown |  |
| event_date | Unknown |  |
| event_type | Unknown |  |
| is_hidden | Unknown |  |
| last_update_date | Instant |  |
| last_updated_by | Unknown |  |
| link | Unknown |  |
| member_id | Unknown |  |
| name | Unknown |  |
| opened_on | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_multiple_response | Unknown |  |
| closed_date | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| dataset_type | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### activity_grouping

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | FK |
| activity_version | Unknown |  |
| can_preview | Unknown |  |
| can_publish | Unknown |  |
| created_at | Instant |  |
| default_locale | Unknown |  |
| grouping_uuid | Unknown |  |
| locales | Unknown |  |
| name | Unknown |  |
| org_id | Unknown |  |
| published_at | Instant |  |
| share_settings | Unknown |  |
| status | Unknown |  |
| styles | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### dataset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### profile_record_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dataset_id | Unknown | PK, FK |
| profile_record_id | Unknown | PK, FK |
| profile_id | Unknown | FK |
| value | Json |  |

### profile_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dataset_id | Unknown | PK, FK |
| profile_id | Unknown | FK |
| last_update_date | Unknown |  |

### profile_field_type_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dataset_id | Unknown | PK, FK |
| profile_field_id | Unknown | PK, FK |
| profile_id | Unknown | FK |
| meta_visibility | Unknown |  |
| name | Unknown |  |

### profile_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dataset_id | Unknown | PK, FK |
| profile_id | Unknown | FK |
| data_type | Unknown |  |
| is_sensitive | Unknown |  |
| meta_visibility | Unknown |  |
| name | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dataset_id | Unknown | PK, FK |
| export_date | Unknown |  |
| last_sync_date | Unknown |  |

### activity_response_field_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| activity_id | Unknown | PK, FK |
| activity_response_field_id | Unknown | PK, FK |
| activity_response_id | Unknown | PK, FK |
| id | Unknown |  |
| meta_order | Unknown |  |
| name | Unknown |  |

### activity_response_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| activity_response_id | Unknown | PK, FK |
| data_type | Unknown |  |
| is_sensitive | Unknown |  |
| meta_description | Unknown |  |
| meta_is_required | Unknown |  |
| meta_is_system | Unknown |  |
| meta_order | Unknown |  |
| meta_source_field_type | Unknown |  |
| meta_visibility | Unknown |  |
| name | Unknown |  |

### activity_response_field_group_id

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | Unknown | PK, FK |
| activity_response_field_group_id | Unknown | PK, FK |
| activity_response_id | Unknown | PK, FK |
| field_id | Unknown | PK, FK |

### activity_response_field_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| activity_response_id | Unknown | PK, FK |
| meta_description | Unknown |  |
| meta_is_required | Unknown |  |
| meta_source_field_group_type | Unknown |  |
| name | Unknown |  |

### activity_response_record_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| activity_response_id | Unknown | PK, FK |
| activity_response_record_id | Unknown | PK, FK |
| value | Json |  |

### activity_response_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| activity_response_id | Unknown | PK, FK |
| last_update_date | Unknown |  |

### activity_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| export_date | Unknown |  |
| last_sync_date | Unknown |  |
| since_date_time | Unknown |  |
| until_date_time | Unknown |  |

## Relationships

- member_event(activity_id) → activity(id)
- member_activity(id) → activity(id)
- activity_grouping(activity_id) → activity(id)
- profile_record_field(profile_record_id) → profile_record(id)
- profile_record_field(profile_id) → profile_record(profile_id)
- profile_record_field(dataset_id) → profile_record(dataset_id)
- profile_record(profile_id) → profile(id)
- profile_record(dataset_id) → profile(dataset_id)
- profile_field_type_value(profile_field_id) → profile_field(id)
- profile_field_type_value(profile_id) → profile_field(profile_id)
- profile_field_type_value(dataset_id) → profile_field(dataset_id)
- profile_field(profile_id) → profile(id)
- profile_field(dataset_id) → profile(dataset_id)
- profile(dataset_id) → dataset(id)
- activity_response_field_value(activity_response_field_id) → activity_response_field(id)
- activity_response_field_value(activity_response_id) → activity_response_field(activity_response_id)
- activity_response_field_value(activity_id) → activity_response_field(activity_id)
- activity_response_field(activity_response_id) → activity_response(id)
- activity_response_field(activity_id) → activity_response(activity_id)
- activity_response_field_group_id(field_id) → activity_response_field(id)
- activity_response_field_group_id(activity_response_id) → activity_response_field_group(activity_response_id)
- activity_response_field_group_id(activity_response_field_group_id) → activity_response_field_group(id)
- activity_response_field_group_id(activity_id) → activity_response_field_group(activity_id)
- activity_response_field_group(activity_response_id) → activity_response(id)
- activity_response_field_group(activity_id) → activity_response(activity_id)
- activity_response_record_field(activity_response_record_id) → activity_response_record(id)
- activity_response_record_field(activity_response_id) → activity_response_record(activity_response_id)
- activity_response_record_field(activity_id) → activity_response_record(activity_id)
- activity_response_record(activity_response_id) → activity_response(id)
- activity_response_record(activity_id) → activity_response(activity_id)
- activity_response(activity_id) → activity(id)