# Forj Community schema ERD

Table and field reference for the Fivetran Forj Community connector.

## Table & Field Reference

### user_activity_sms_reply

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| comment_type | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_type | Unknown |  |

### group_field_option

| Column | Type | Keys |
| --- | --- | --- |
| option | Unknown | PK |
| group_field_id | Unknown | PK, FK |
| group_id | Unknown | PK, FK |

### group_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | PK, FK |
| editable | Unknown |  |
| name | Unknown |  |
| other_option_flag | Unknown |  |
| placeholder | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |
| unique_name | Unknown |  |

### group_member_posting_permission

| Column | Type | Keys |
| --- | --- | --- |
| permission | Unknown | PK |
| group_id | Unknown | PK, FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_group | Unknown | FK |
| primary_admin_user_id | Unknown | FK |
| created_at | Unknown |  |
| default_emails_frequency | Unknown |  |
| email | Unknown |  |
| email_comments_to_all | Unknown |  |
| hidden_email | Unknown |  |
| logo_url | Unknown |  |
| members_count | Unknown |  |
| members_visible | Unknown |  |
| mini_thumb_url | Unknown |  |
| name | Unknown |  |
| posts_moderation | Unknown |  |
| privacy | Unknown |  |
| requires_approval | Unknown |  |
| small_thumb_url | Unknown |  |
| thumb_url | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### user_activity_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_type | Unknown |  |

### user_activity_pending_post

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| receiver_id | Unknown | FK |
| created_at | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_name | Unknown |  |
| target_type | Unknown |  |

### user_activity_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| poll_name | Unknown |  |
| post_id | Unknown |  |
| post_type | Unknown |  |

### user_activity_rsvp

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| event_id | Unknown |  |
| event_name | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_type | Unknown |  |
| status | Unknown |  |
| target_id | Unknown |  |
| target_type | Unknown |  |

### user_activity_reaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| item_id | Unknown |  |
| item_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |

### user_activity_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| comment_type | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |

### user_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| conversation_id | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_name | Unknown |  |
| target_type | Unknown |  |
| type | Unknown |  |

### user_activity_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| mention_object | Unknown |  |
| mentioned | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |

### user_activity_add_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| members_count | Unknown |  |

### user_activity_post_approved

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| receiver_id | Unknown | FK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_name | Unknown |  |
| target_type | Unknown |  |

### user_activity_join_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| created_at | Unknown |  |
| deleted | Unknown |  |

### user_activity_conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initiator_id | Unknown | FK |
| member_id | Unknown | FK |
| participant_id | Unknown | FK |
| conversation_id | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |

### user_activity_pending_applicant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| created_at | Unknown |  |
| deleted | Unknown |  |

### user_activity_post_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| comment_type | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_type | Unknown |  |

### user_activity_post

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| receiver_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_name | Unknown |  |
| target_type | Unknown |  |

### user_activity_comment_reply

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |
| comment_type | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| feed_type | Unknown |  |
| post_id | Unknown |  |
| post_name | Unknown |  |
| post_type | Unknown |  |
| target_id | Unknown |  |
| target_type | Unknown |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| is_admin | Unknown |  |
| last_invited_in | Unknown |  |
| status | Unknown |  |

### user_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| users_id | Unknown | PK, FK |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar_mini_thumb_url | Unknown |  |
| avatar_small_thumb_url | Unknown |  |
| avatar_thumb_url | Unknown |  |
| avatar_url | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_registered | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- user_activity_sms_reply(receiver_id) → users(id)
- user_activity_sms_reply(member_id) → users(id)
- group_field_option(group_field_id) → group_field(id)
- group_field_option(group_id) → group_field(group_id)
- group_field(group_id) → groups(id)
- group_member_posting_permission(group_id) → groups(id)
- groups(primary_admin_user_id) → users(id)
- groups(parent_group) → groups(id)
- user_activity_view(receiver_id) → users(id)
- user_activity_view(group_id) → groups(id)
- user_activity_view(member_id) → users(id)
- user_activity_pending_post(group_id) → groups(id)
- user_activity_pending_post(receiver_id) → users(id)
- user_activity_vote(receiver_id) → users(id)
- user_activity_vote(group_id) → groups(id)
- user_activity_vote(member_id) → users(id)
- user_activity_rsvp(group_id) → groups(id)
- user_activity_rsvp(member_id) → users(id)
- user_activity_reaction(receiver_id) → users(id)
- user_activity_reaction(group_id) → groups(id)
- user_activity_reaction(member_id) → users(id)
- user_activity_comment(receiver_id) → users(id)
- user_activity_comment(group_id) → groups(id)
- user_activity_comment(member_id) → users(id)
- user_activity(receiver_id) → users(id)
- user_activity(group_id) → groups(id)
- user_activity(member_id) → users(id)
- user_activity_mention(receiver_id) → users(id)
- user_activity_mention(group_id) → groups(id)
- user_activity_mention(member_id) → users(id)
- user_activity_add_member(group_id) → groups(id)
- user_activity_add_member(member_id) → users(id)
- user_activity_post_approved(receiver_id) → users(id)
- user_activity_post_approved(group_id) → groups(id)
- user_activity_join_group(member_id) → users(id)
- user_activity_join_group(group_id) → groups(id)
- user_activity_conversation(initiator_id) → users(id)
- user_activity_conversation(member_id) → users(id)
- user_activity_conversation(participant_id) → users(id)
- user_activity_pending_applicant(group_id) → groups(id)
- user_activity_pending_applicant(member_id) → users(id)
- user_activity_post_message(receiver_id) → users(id)
- user_activity_post_message(group_id) → groups(id)
- user_activity_post_message(member_id) → users(id)
- user_activity_post(receiver_id) → users(id)
- user_activity_post(group_id) → groups(id)
- user_activity_post(member_id) → users(id)
- user_activity_comment_reply(group_id) → groups(id)
- user_activity_comment_reply(member_id) → users(id)
- user_group(id) → groups(id)
- user_group(user_id) → users(id)
- user_custom_field(users_id) → users(id)