# Helpjuice schema ERD

Table and field reference for the Fivetran Helpjuice connector.

## Table & Field Reference

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| action | Unknown |  |
| created_at | Unknown |  |
| trackable_id | Unknown |  |
| trackable_type | Unknown |  |

### groups_users

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

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| auto_groups | Json |  |
| created_at | Unknown |  |
| name | Unknown |  |
| smart_load | Unknown |  |

### category_published_question

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

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| accessibility | Unknown |  |
| codename | Unknown |  |
| description | Unknown |  |
| hierarchy | Json |  |
| icon | Unknown |  |
| image_url | Unknown |  |
| name | Unknown |  |
| sub_categories | Json |  |
| url | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| role_id | Unknown |  |
| updated_at | Unknown |  |

### article_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| article_id | Unknown | PK, FK |
| body | Unknown |  |
| body_txt | Unknown |  |
| format | Unknown |  |
| updated_at | Unknown |  |

### article_keyword

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| article_id | Unknown | PK, FK |
| name | Unknown |  |

### article

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| category_id | Unknown | FK |
| accessibility | Unknown |  |
| codename | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| hierarchy_id | Unknown |  |
| name | Unknown |  |
| next_expiration_on | Unknown |  |
| published | Unknown |  |
| updated_at | Instant |  |
| url | Unknown |  |
| views | Unknown |  |

## Relationships

- activity(owner_id) → users(id)
- groups_users(user_id) → users(id)
- groups_users(group_id) → groups(id)
- category_published_question(category_id) → category(id)
- category(parent_id) → category(id)
- article_answer(article_id) → article(id)
- article_keyword(article_id) → article(id)
- article(category_id) → category(id)
- article(author_id) → users(id)