# Higher Logic Vanilla schema ERD

Table and field reference for the Fivetran Higher Logic Vanilla connector.

## Table & Field Reference

### event_insert_user_role

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| insert_user_role_id | Unknown | PK, FK |

### event_insert_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### event_update_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| insert_user_id | Unknown | FK |
| last_comment_user_id | Unknown | FK |
| update_user_id | Unknown | FK |
| all_day_event | Unknown |  |
| body | Unknown |  |
| cta_is_external | Unknown |  |
| cta_label | Unknown |  |
| cta_url | Unknown |  |
| date_ends | Unknown |  |
| date_inserted | Unknown |  |
| date_starts | Instant |  |
| date_updated | Unknown |  |
| display_organizer | Unknown |  |
| excerpt | Unknown |  |
| foreign_id | Unknown |  |
| foreign_subtype | Unknown |  |
| foreign_type | Unknown |  |
| image_alt | Unknown |  |
| image_url | Unknown |  |
| image_url_src_set | Json |  |
| location | Unknown |  |
| location_url | Unknown |  |
| name | Unknown |  |
| parent_record_id | Unknown |  |
| parent_record_type | Unknown |  |
| permission_attend | Unknown |  |
| permission_create | Unknown |  |
| permission_edit | Unknown |  |
| permission_member | Unknown |  |
| permission_organizer | Unknown |  |
| permission_view | Unknown |  |
| safe_location_url | Unknown |  |
| url | Unknown |  |

### comment_insert_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| comment_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### comment_insert_user_role

| Column | Type | Keys |
| --- | --- | --- |
| comment_id | Unknown | PK, FK |
| insert_user_role_id | Unknown | PK, FK |

### comment_reaction

| Column | Type | Keys |
| --- | --- | --- |
| comment_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |
| class | Unknown |  |
| count | Unknown |  |
| has_reacted | Unknown |  |
| reaction_value | Unknown |  |

### comment_update_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| comment_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| discussion_id | Unknown | FK |
| insert_user_id | Unknown | FK |
| update_user_id | Unknown | FK |
| body | Unknown |  |
| date_inserted | Instant |  |
| date_updated | Unknown |  |
| depth | Unknown |  |
| format | Unknown |  |
| name | Unknown |  |
| parent_record_id | Unknown |  |
| parent_record_type | Unknown |  |
| score | Unknown |  |
| url | Unknown |  |
| report_meta_** |  |  |

### category_allowed_discussion_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| allowed_discussion_type | Unknown |  |

### category_breadcrumb

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### category_children

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| last_post_comment_id | Unknown | FK |
| last_post_discussion_id | Unknown | FK |
| last_post_insert_user_id | Unknown | FK |
| children | Json |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| last_post_insert_user_id | Unknown | FK |
| parent_id | Unknown | FK |
| custom_permissions | Unknown |  |
| date_inserted | Unknown |  |
| depth | Unknown |  |
| description | Unknown |  |
| display_as | Unknown |  |
| featured | Unknown |  |
| followed | Unknown |  |
| icon_url | Unknown |  |
| icon_url_src_set_10 | Unknown |  |
| icon_url_src_set_1200 | Unknown |  |
| icon_url_src_set_1600 | Unknown |  |
| icon_url_src_set_300 | Unknown |  |
| icon_url_src_set_800 | Unknown |  |
| is_archived | Unknown |  |
| last_post_date_inserted | Unknown |  |
| last_post_discussion_id | Unknown |  |
| last_post_name | Unknown |  |
| last_post_url | Unknown |  |
| name | Unknown |  |
| permission | Json |  |
| sort | Unknown |  |
| url | Unknown |  |
| urlcode | Unknown |  |

### reaction

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tag_id | Unknown | FK |
| active | Unknown |  |
| class | Unknown |  |
| custom | Unknown |  |
| description | Unknown |  |
| hidden | Unknown |  |
| name | Unknown |  |
| points | Unknown |  |
| reaction_value | Unknown |  |
| sort | Unknown |  |
| url_code | Unknown |  |
| attributes_** |  |  |

### search_insert_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| search_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### search_insert_user_role

| Column | Type | Keys |
| --- | --- | --- |
| insert_user_role_id | Unknown | PK, FK |
| search_id | Unknown | PK, FK |

### search_tag

| Column | Type | Keys |
| --- | --- | --- |
| search_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### search_update_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| search_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| discussion_id | Unknown | FK |
| insert_user_id | Unknown | FK |
| update_user_id | Unknown | FK |
| body | Unknown |  |
| body_plain_text | Unknown |  |
| date_inserted | Instant |  |
| date_updated | Unknown |  |
| excerpt | Unknown |  |
| image | Unknown |  |
| is_foreign | Unknown |  |
| legacy_type | Unknown |  |
| name | Unknown |  |
| record_type | Unknown |  |
| scope | Unknown |  |
| score | Unknown |  |
| site_domain | Unknown |  |
| site_id | Unknown |  |
| subquery_match_count | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### discussion_insert_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| discussion_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### discussion_last_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| discussion_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### discussion_tag

| Column | Type | Keys |
| --- | --- | --- |
| discussion_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### discussion_update_user_badge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| discussion_id | Unknown | PK, FK |
| badge_id | Unknown |  |
| date_inserted | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| url | Unknown |  |

### discussion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| insert_user_id | Unknown | FK |
| last_user_id | Unknown | FK |
| resolved_user_id | Unknown | FK |
| update_user_id | Unknown | FK |
| announce | Unknown |  |
| body | Unknown |  |
| bookmarked | Unknown |  |
| canonical_url | Unknown |  |
| closed | Unknown |  |
| count_unread | Unknown |  |
| count_views | Unknown |  |
| date_inserted | Instant |  |
| date_last_comment | Unknown |  |
| date_updated | Unknown |  |
| dismissed | Unknown |  |
| excerpt | Unknown |  |
| format | Unknown |  |
| hot | Unknown |  |
| image_alt | Unknown |  |
| image_url | Unknown |  |
| internal_status_id | Unknown |  |
| internal_status_name | Unknown |  |
| internal_status_record_sub_type | Unknown |  |
| internal_status_record_type | Unknown |  |
| internal_status_state | Unknown |  |
| last_post_comment_id | Unknown |  |
| last_post_discussion_id | Unknown |  |
| name | Unknown |  |
| pinned | Unknown |  |
| resolved | Unknown |  |
| score | Unknown |  |
| sink | Unknown |  |
| snippet | Unknown |  |
| status_id | Unknown |  |
| status_name | Unknown |  |
| status_record_sub_type | Unknown |  |
| status_record_type | Unknown |  |
| status_state | Unknown |  |
| unread | Unknown |  |
| url | Unknown |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| users_id | Unknown | PK, FK |
| date_expires | Unknown |  |
| date_inserted | Unknown |  |
| date_updated | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK |
| user_id | Unknown | PK, FK |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| banned | Unknown |  |
| bypass_spam | Unknown |  |
| count_visits | Unknown |  |
| date_inserted | Instant |  |
| date_last_active | Unknown |  |
| date_updated | Unknown |  |
| email | Unknown |  |
| email_confirmed | Unknown |  |
| extended_bio | Unknown |  |
| extended_care_planning | Unknown |  |
| extended_care_projects | Unknown |  |
| extended_concierge | Unknown |  |
| extended_group | Unknown |  |
| extended_partner | Unknown |  |
| hash_method | Unknown |  |
| insert_ip_address | Unknown |  |
| is_admin | Unknown |  |
| is_super_admin | Unknown |  |
| is_sys_admin | Unknown |  |
| label | Unknown |  |
| last_ip_address | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| points | Unknown |  |
| private | Unknown |  |
| profile_fields_bio | Unknown |  |
| profile_fields_care_planning | Unknown |  |
| profile_fields_care_projects | Unknown |  |
| profile_fields_concierge | Unknown |  |
| profile_fields_group | Unknown |  |
| profile_fields_partner | Unknown |  |
| profile_photo_url | Unknown |  |
| rank_id | Unknown |  |
| rank_name | Unknown |  |
| rank_user_title | Unknown |  |
| show_email | Unknown |  |
| sso_id | Unknown |  |
| url | Unknown |  |
| custom_** |  |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| name | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| url_code | Unknown |  |

## Relationships

- event_insert_user_role(insert_user_role_id) → users(id)
- event_insert_user_role(event_id) → event(id)
- event_insert_user_badge(event_id) → event(id)
- event_update_user_badge(event_id) → event(id)
- event(last_comment_user_id) → users(id)
- event(insert_user_id) → users(id)
- event(update_user_id) → users(id)
- comment_insert_user_badge(comment_id) → comment(id)
- comment_insert_user_role(insert_user_role_id) → users(id)
- comment_insert_user_role(comment_id) → comment(id)
- comment_reaction(tag_id) → tags(id)
- comment_reaction(comment_id) → comment(id)
- comment_update_user_badge(comment_id) → comment(id)
- comment(discussion_id) → discussion(id)
- comment(category_id) → category(id)
- comment(insert_user_id) → users(id)
- comment(update_user_id) → users(id)
- category_allowed_discussion_type(category_id) → category(id)
- category_breadcrumb(category_id) → category(id)
- category_children(category_id) → category(id)
- category_children(last_post_discussion_id) → discussion(id)
- category_children(last_post_comment_id) → comment(id)
- category_children(last_post_insert_user_id) → users(id)
- category(last_post_insert_user_id) → users(id)
- category(parent_id) → category(id)
- reaction(tag_id) → tags(id)
- search_insert_user_badge(search_id) → search(id)
- search_insert_user_role(insert_user_role_id) → users(id)
- search_insert_user_role(search_id) → search(id)
- search_tag(tag_id) → tags(id)
- search_tag(search_id) → search(id)
- search_update_user_badge(search_id) → search(id)
- search(discussion_id) → discussion(id)
- search(category_id) → category(id)
- search(insert_user_id) → users(id)
- search(update_user_id) → users(id)
- discussion_insert_user_badge(discussion_id) → discussion(id)
- discussion_last_user_badge(discussion_id) → discussion(id)
- discussion_tag(tag_id) → tags(id)
- discussion_tag(discussion_id) → discussion(id)
- discussion_update_user_badge(discussion_id) → discussion(id)
- discussion(category_id) → category(id)
- discussion(last_user_id) → users(id)
- discussion(insert_user_id) → users(id)
- discussion(resolved_user_id) → users(id)
- discussion(update_user_id) → users(id)
- session(users_id) → users(id)
- user_role(user_id) → users(id)
- tags(parent_id) → tags(id)