Live Demo

Link: https://highlandersportjquery.herokuapp.com/index.html

Description

A simple app for coaches to manage their teams stats, averages, trash talk, and poach players from other teams.

Current MVP version omits 🚫:

• Poaching power 👊
  
• Player averages 📊
  
• Trash talk 🙊

Want to keep up with the development and roadmap of Highlander? https://trello.com/b/p1gqbNtQ/thinkful-capstone-highlander

Screenshots

Dashboard

Add a Team

View List of Teams

Add Player

Add Stat

Tech Stack

• DB: cloud-hosted PostgreSQL instance

• Server: Node, Express, Morgan, Knex, Bookshelf, Bcrypt

• Client: jQuery, HTML, CSS, Bulma

Database Structure

http://dbpatterns.com/documents/58c5ff7f1514b438af1a805e/

Tables

coaches

id	email	first_name	last_name
123	isaac@gmail.com	Isaac	Brewman
124	danny@yahoo.com	Danny	Guach

coaches_teams

coach_id	team_id
1	3
2	1
1	1

teams

id	name	city	state
1	Highlander	Bronx	NY
2	Braves	Brooklyn	NY
3	Brew Crew	Queens	NY

teams_players

team_id	player_id
1	4
2	2
3	7

players

id	first_name	last_name	email	password	position
1	Ricardo	Roman	romanR@gmail.com	Bcrypt(hash)	2nd base
2	Randy	Brown	brown@yahoo.com	Bcrypt(hash)	Catcher
3	Big	Mac	BG@yahoo.com	Bcrypt(hash)	3rd base

stats

player_id	stat_catalog_id	how_many
1	4	56
2	2	3
3	6	24

stat_catalogs

id	description
1	Hits
2	At Bats
3	Home Runs
4	Earned Runs
5	Innings Pitched
6	Strikeouts

---

Endpoints:

coach

• router.get('/')

• router.get('/:id')

• router.post('/')

• router.post('/login')

• router.put('/:id')

player

• router.get('/')

• router.get('/:id')

• router.get('/:id/stats')

• router.post('/')

• router.post('/:player_id/stats/:stat_catalog_id')

• router.put('/:player_id/stats/:stat_catalog_id')

team

• router.get('/')

• router.get('/:id')

• router.post('/')

• router.post('/:id/player')

• router.put('/:id')

stat

• router.get('/')
• router.get('/:id')