Higher Logic Vanilla
Explore the interactive ERD
Table & Field Reference
event_insert_user_role
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PKFK |
insert_user_role_id | Unknown | PKFK |
event_insert_user_badge
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
badge_id | Unknown | |
date_inserted | Unknown | |
name | Unknown | |
photo_url | Unknown | |
url | Unknown |
comment_insert_user_role
| Column | Type | Keys |
|---|---|---|
comment_id | Unknown | PKFK |
insert_user_role_id | Unknown | PKFK |
comment_reaction
| Column | Type | Keys |
|---|---|---|
comment_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
class | Unknown | |
count | Unknown | |
has_reacted | Unknown | |
reaction_value | Unknown |
comment_update_user_badge
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
comment_id | Unknown | PKFK |
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 | PKFK |
allowed_discussion_type | Unknown |
category_breadcrumb
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
category_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
category_children
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
category_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
search_id | Unknown | PKFK |
search_tag
| Column | Type | Keys |
|---|---|---|
search_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
search_update_user_badge
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
search_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
badge_id | Unknown | |
date_inserted | Unknown | |
name | Unknown | |
photo_url | Unknown | |
url | Unknown |
discussion_tag
| Column | Type | Keys |
|---|---|---|
discussion_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
discussion_update_user_badge
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
discussion_id | Unknown | PKFK |
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 | PKFK |
date_expires | Unknown | |
date_inserted | Unknown | |
date_updated | Unknown |
user_role
| Column | Type | Keys |
|---|---|---|
role_id | Unknown | PK |
user_id | Unknown | PKFK |
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 |