Doc Community - notfreshmen/amable GitHub Wiki
Communities
Communities are groups of people that share a common interest and want to recieve kindness regarding the topic of that community
Community DDL
Table "public.communities"
Column | Type | Modifiers
---------------+-----------------------------+----------------------------------------------------------
id | integer | not null default nextval('communities_id_seq'::regclass)
name | character varying(128) |
description | text |
banner_url | character varying(128) |
thumbnail_url | character varying(120) |
nsfw | boolean |
active | boolean |
num_upvotes | integer |
date_created | timestamp without time zone |
date_modified | timestamp without time zone |
Indexes:
"communities_pkey" PRIMARY KEY, btree (id)
Referenced by:
TABLE "community_users" CONSTRAINT "community_users_community_id_fkey" FOREIGN KEY (community_id) REFERENCES communities(id)
TABLE "posts" CONSTRAINT "posts_community_id_fkey" FOREIGN KEY (community_id) REFERENCES communities(id)