Mentor Me Backend

Mentor Me connects people with questions to people with answers.

This is the server side code for the app.

folder structure

• api
  • server
  • server.spec
• auth
  • auth- router
  • restricted- middleware
  • secret
• data
  • migrations
  • seeds
  • dbConfig
• resources
  • answers
    • answers- model
    • answers- router
    • router.spec
  • questions
    • questions- model
    • questions- router
    • router.spec
  • users
    • users- model
    • users- router
    • router.spec
  • mapper
• index
• knexfile

Database Schemas

The Database Schemas for the users, questions, and answers resources are:

Users

field	data type	metadata
id	unsigned integer	primary key, auto-increments, generated by database
handle	string	required, unique
email	string	required, unique
password	string	required, unique
profile_pic_url	string
business_field	string
role	string

questions

field	data type	metadata
id	unsigned integer	primary key, auto-increments, generated by database
title	text	required
body	string	required
author	string	required
FK_user_id	unsigned integer	must be the id of an existing user
business_field	string
image_url	string
likes	integer

answers

field	data type	metadata
id	unsigned integer	primary key, auto-increments, generated by database
body	string	required
author	string	required
likes	integer
FK_user_id	unsigned integer	must be the id of an existing user
FK_question.id	unsigned integer	must be the id of an existing question