hellodb.io
MODELS · 14
/
28 refs · 102 fields
user
8
PK
id
uuid
username
varchar
email
varchar?
post_karma
int
comment_karma
int
is_suspended
boolean
created_at
timestamp
deleted_at
timestamp?
subreddit_member
6
PK
id
uuid
FK
subreddit_id
uuid
FK
user_id
uuid
is_favorite
boolean
notify_new_posts
boolean
joined_at
timestamp
saved_item
6
PK
id
uuid
FK
user_id
uuid
FK
post_id
uuid?
FK
comment_id
uuid?
category
varchar?
saved_at
timestamp
subreddit
9
PK
id
uuid
name
varchar
title
varchar
description
text
FK
created_by_id
uuid
visibility
enum
is_nsfw
boolean
member_count
int
created_at
timestamp
rule
7
PK
id
uuid
FK
subreddit_id
uuid
sort_order
int
title
varchar
description
text
applies_to
enum
created_at
timestamp
flair
6
PK
id
uuid
FK
subreddit_id
uuid
label
varchar
background_color
varchar
flair_kind
enum
is_mod_only
boolean
post
10
PK
id
uuid
FK
subreddit_id
uuid
FK
author_id
uuid
FK
flair_id
uuid?
title
varchar
kind
enum
body
text?
url
text?
score
int
is_locked
boolean
comment
10
PK
id
uuid
FK
post_id
uuid
FK
author_id
uuid
FK
parent_comment_id
uuid?
body
text
score
int
depth
int
materialised_path
text
is_removed
boolean
created_at
timestamp
post_vote
5
PK
id
uuid
FK
post_id
uuid
FK
user_id
uuid
direction
enum
created_at
timestamp
comment_vote
5
PK
id
uuid
FK
comment_id
uuid
FK
user_id
uuid
direction
enum
created_at
timestamp
moderator
8
PK
id
uuid
FK
subreddit_id
uuid
FK
user_id
uuid
FK
added_by_id
uuid?
is_owner
boolean
can_ban
boolean
can_manage_flair
boolean
added_at
timestamp
ban
8
PK
id
uuid
FK
subreddit_id
uuid
FK
user_id
uuid
FK
banned_by_id
uuid
reason
text
is_permanent
boolean
expires_at
timestamp?
created_at
timestamp
award
6
PK
id
uuid
name
varchar
icon_url
text
coin_cost
int
coins_granted
int
tier
enum
award_grant
8
PK
id
uuid
FK
award_id
uuid
FK
giver_id
uuid
FK
post_id
uuid?
FK
comment_id
uuid?
is_anonymous
boolean
message
varchar?
granted_at
timestamp
96%
Opening Reddit