Comments

Comments go on posts and can be infinitely recursive on each other

Comments DDL

Table "public.comments"
    Column     |            Type             |                       Modifiers                       
---------------+-----------------------------+-------------------------------------------------------
 id            | integer                     | not null default nextval('comments_id_seq'::regclass)
 content       | text                        | 
 hashtags      | text                        | 
 parent        | integer                     | 
 user_id       | integer                     | 
 post_id       | integer                     | 
 upvote_count  | character varying(128)      | 
 date_created  | timestamp without time zone | 
 date_modified | timestamp without time zone | 
Indexes:
    "comments_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "comments_post_id_fkey" FOREIGN KEY (post_id) REFERENCES posts(id)
    "comments_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)