Helpjuice
Explore the interactive ERD
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
body | Unknown | |
body_txt | Unknown | |
format | Unknown | |
updated_at | Unknown | |
article_keyword
| Column | Type | Keys |
|---|
id | Unknown | PK |
article_id | Unknown | PKFK |
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 | |
