All projects

Full-stack web app · Turing School

The HeLP Network

Winner of the 2105 cohort's Turing School final project competition

React based web app to help professionals ask and find important legal and ethical questions. Developed backend with Python, Django, PostgreSQL. Deployed to Heroku with CircleCI.

  • React
  • Python
  • Django
  • PostgreSQL
  • OAuth
  • Heroku
  • CircleCI
The HeLP Network logo

01 Mission

Our mission is to connect expertise across specialty areas of public helping professions to ask and find questions to important legal and ethical concerns central to helping support our communities and each other.

Database schema

Relational database built out with PostgreSQL.

users

id integer
username string
password string
email string
title string
is_active boolean
is_staff boolean
is_admin boolean
is_superuser boolean
timestamps datetime

question_flags

id integer
user users
post posts
comment string
status enum
timestamps datetime

question_votes

id integer
user users
post posts
vote_type enum
timestamps datetime

posts

id integer
user users
title string
body string
quarantine boolean
timestamps datetime

tagging

id integer
post posts
tag tag

tag

id integer
name string
timestamps datetime

responses

id integer
post posts
user users
body string
quarantine boolean
timestamps datetime

connections

id integer
user_sent users
user_received users
status enum
timestamps datetime

response_votes

id integer
user users
response responses
vote_type enum
timestamps datetime

response_flags

id integer
user users
response responses
comment string
status enum
timestamps datetime
one to many primary key → table foreign key

TapHover or click a table to trace its relationships and see its fields up close.

02 Features

Login with OAuth

Log in to The HeLP Network through your LinkedIn account via OAuth.

Find answers

Easily browse through existing legal and ethical questions.

Search & vote

Search for questions through relevant tags or by title. Take an active role in the community by voting for the most useful questions and responses.

Ask your own questions

Ask a new question and tag it with existing or new tags. Respond to others' questions, and freely edit or delete your previous questions and responses.