Alida
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
profile_record_id | Unknown | PKFK |
profile_id | Unknown | FK |
value | Json |
profile_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dataset_id | Unknown | PKFK |
profile_id | Unknown | FK |
last_update_date | Unknown |
profile_field_type_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dataset_id | Unknown | PKFK |
profile_field_id | Unknown | PKFK |
profile_id | Unknown | FK |
meta_visibility | Unknown | |
name | Unknown |
profile_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dataset_id | Unknown | PKFK |
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 | PKFK |
export_date | Unknown | |
last_sync_date | Unknown |
activity_response_field_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
activity_id | Unknown | PKFK |
activity_response_field_id | Unknown | PKFK |
activity_response_id | Unknown | PKFK |
id | Unknown | |
meta_order | Unknown | |
name | Unknown |
activity_response_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_id | Unknown | PKFK |
activity_response_id | Unknown | PKFK |
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 | PKFK |
activity_response_field_group_id | Unknown | PKFK |
activity_response_id | Unknown | PKFK |
field_id | Unknown | PKFK |
activity_response_field_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_id | Unknown | PKFK |
activity_response_id | Unknown | PKFK |
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 | PKFK |
activity_response_id | Unknown | PKFK |
activity_response_record_id | Unknown | PKFK |
value | Json |
activity_response_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_id | Unknown | PKFK |
activity_response_id | Unknown | PKFK |
last_update_date | Unknown |
activity_response
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_id | Unknown | PKFK |
export_date | Unknown | |
last_sync_date | Unknown | |
since_date_time | Unknown | |
until_date_time | Unknown |