To see the DB diagram, post the below code into right sidebar at https://dbdiagram.io/d then click the Auto Arrange at the bottom.
Table member {
id int [pk]
display_name text (100)
bio text
email text (255)
gravatar_hash text
location text (100)
is_from_stack_exchange boolean
stack_exchange_id bigint
stack_exchange_validated date
stack_exchange_last_imported date
is_email_verified boolean
is_suspended boolean
suspension_end_date date
}
Table social_media{
id bigserial [pk]
name text
}
Table member_social_media
{
id int [pk]
social_media_id bigserial [ref: > social_media.id]
member_id bigserial [ref: > member.id]
community_id bigserial [ref: > community.id]
url text
}
Table community{
id bigserial [pk]
name text
tagline text
url text
help_text text
faq text
status enum
}
Table trust_level{
id bigserial [pk]
name text
explanation text
}
Table trust_level_community{
id bigserial [pk]
community_id bigserial [ref: > community.id]
trust_level_id bigserial [ref: > trust_level.id]
is_same_as_instance boolean
name text
explanation text
}
Table member_community{
id bigserial [pk]
member_id bigserial [ref: > member.id]
community_id bigserial [ref: > community.id]
display_name text
bio text
email text
gravatar_hash text
location text
is_from_stack_exchange boolean
stack_exchange_id bigint
is_same_as_instance boolean
stack_exchange_validated date
stack_exchange_last_imported date
is_suspended boolean
suspension_end_date date
trust_level_community_id bigserial [ref: > trust_level_community.id]
is_moderator boolean
is_deleted boolean
}
Table privilege{
id bigserial [pk]
name text
}
Table community_member_privilege{
id bigserial [pk]
community_id bigserial [ref: > community.id]
member_id bigserial [ref: > member.id]
privilege_id bigserial [ref: > privilege.id]
is_suspended boolean
privilege_suspension_start_date date
privelege_suspension_end_date date
}
Table post_type{
id bigserial [pk]
name text
}
Table vote_type{
id bigserial [pk]
name text
}
Table post {
id bigserial [pk]
member_id bigserial [ref: > member.id]
community_id bigserial [ref: > community.id]
title text
body text
upvotes bigint
downvotes bigint
net_votes bigint
score decimal
is_accepted boolean
post_type_id bigserial [ref: > post_type.id]
is_closed boolean
is_protected boolean
parent_id bigserial [ref: > post.id]
is_meta boolean
is_deleted boolean
}
Table comment {
id bigserial [pk]
member_id bigserial [ref: > member.id]
post_id bigserial [ref: > post.id]
parent_comment_id bigserial [ref: > comment.id]
body text
upvotes bigint
downvotes bigint
net_votes bigint
score decimal
is_deleted boolean
deleted_at date
}
Table comment_vote{
id bigserial [pk]
comment_id bigserial [ref: > comment.id]
member_id bigserial [ref: > member.id]
vote_type_id bigserial [ref: > vote_type.id]
}
Table post_vote{
id bigserial [pk]
comment_id bigserial [ref: > comment.id]
member_id bigserial [ref: > member.id]
vote_type_id bigserial [ref: > vote_type.id]
}
Table tag {
id bigserial [pk]
community_id bigserial [ref: > comment.id]
name text
description text
tag_wiki text
is_active boolean
tag_synonym_id bigserial
usages bigint
}
Table post_tag{
id bigserial [pk]
tag_id bigserial [ref: > tag.id]
post_id bigserial [ref: > post.id]
}