Skip to content
No description, website, or topics provided.
HTML JavaScript CSS TSQL
Branch: master
Clone or download
Pull request Compare This branch is 2 commits ahead, 2 commits behind Evans-N:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
bin
public
routes
views
README.md
app.js
db.js
package-lock.json
package.json
schema.sql
seed.sql

README.md

🗼 🗽 🗻 🌉 🚢 🚗 ⛵️ 🚂 ✈️

TRVLR

🇯🇵 🇺🇸 🇮🇹 🇬🇧 🇪🇸 🇬🇧 🇫🇷 🇩🇪 🇨🇳

DC-Backend-Project

Created by: Ian Miller, Nathan Evans, and Anthony Pellingra


Project Overview

A social travel app to make planning trips with friends easier. We store user data after registration and give the user a session cookie. Afterwards they can customize a trip they would like to go on, and allow other users to attend the new trip.

Our Project Goals- Backend

  • Allow our site to create users.
  • Allow each user to create a trip.
  • Allow users to join other users trips.
  • Store user profile pictures and main trip picture in database.
  • Used a join table to accommodate a many to many relationship.
  • Site implements authentication and validation.

Our Site Features- Frontend

  • Users have a timeline feature to show trips they have attended/created.
  • Set a carousel on the landing page to show recently made trips by other users.
  • Added hover features to navbar, about us icons, and footer

Database Formatting

Users Table
First Name Last Name Email Phone Password Picture
Users Name username@me.com 1234567890 b-crypt File/Path/to/profile/pic/storage
Trips Table
Name of Trip City Country Start Date End Date Users (id) Trip Description Picture
Traveling Abroad Paris France 08-23-2019 09-06-2019 1 Going to the Eiffel Tower File/path/to trip/image/storage
Attendees Table

This table controls our many to many relationship by storing which user(id) is attending which trip(id).

User(id) Trip(id)
(id)-user1 (id)-trip3

In this example the user from the above user table is deciding to attend a trip created by another user.

You can’t perform that action at this time.