hellodb.io
MODELS · 13
/
20 refs · 89 fields
user
9
PK
id
uuid
username
varchar
email
varchar
phone
varchar?
password_hash
varchar
is_verified
boolean
status
enum
created_at
timestamp
deleted_at
timestamp?
profile
9
PK
id
uuid
FK
user_id
uuid
display_name
varchar
bio
text?
avatar_url
varchar?
website
varchar?
is_private
boolean
follower_count
bigint
updated_at
timestamp
post
9
PK
id
uuid
FK
author_id
uuid
caption
text?
location_name
varchar?
visibility
enum
comments_enabled
boolean
like_count
bigint
created_at
timestamp
deleted_at
timestamp?
media
10
PK
id
uuid
FK
post_id
uuid
media_type
enum
storage_key
varchar
width
int
height
int
duration_seconds
decimal?
position
int
alt_text
varchar?
created_at
timestamp
comment
8
PK
id
uuid
FK
post_id
uuid
FK
author_id
uuid
FK
parent_comment_id
uuid?
body
text
like_count
int
created_at
timestamp
deleted_at
timestamp?
post_like
4
PK
id
uuid
FK
post_id
uuid
FK
user_id
uuid
created_at
timestamp
comment_like
4
PK
id
uuid
FK
comment_id
uuid
FK
user_id
uuid
created_at
timestamp
follow
6
PK
id
uuid
FK
follower_id
uuid
FK
followee_id
uuid
status
enum
is_muted
boolean
created_at
timestamp
hashtag
5
PK
id
uuid
tag
varchar
post_count
bigint
is_blocked
boolean
created_at
timestamp
post_hashtag
4
PK
id
uuid
FK
post_id
uuid
FK
hashtag_id
uuid
created_at
timestamp
story
8
PK
id
uuid
FK
author_id
uuid
media_type
enum
storage_key
varchar
caption
varchar?
view_count
int
expires_at
timestamp
created_at
timestamp
direct_message
8
PK
id
uuid
FK
sender_id
uuid
FK
recipient_id
uuid
FK
shared_post_id
uuid?
body
text?
read_at
timestamp?
created_at
timestamp
deleted_at
timestamp?
saved_post
5
PK
id
uuid
FK
user_id
uuid
FK
post_id
uuid
collection_name
varchar?
created_at
timestamp
110%
Opening Instagram