Giter Site home page Giter Site logo

planet-refi's Introduction

DATABASE SCHEMA:

USERS
    - userid
    - username
    - password

PROFILES
    - profileid
    - userid
    - firstname
    - lastname
    - city
    - state
    - purchaseprice
    - purchasedate
    - mortgagebalance
    - housephoto
    - twittername

TIMELINE
    - timelineid
    - profileid
    - userid
    - entrydate
    - title
    - description

DATABASE CREATION SQL STATEMENTS:

CREATE TABLE users (
    userid INT NOT NULL AUTO_INCREMENT,
    username VARCHAR(20),
    password VARCHAR(100),
    PRIMARY KEY (userid)
);

CREATE TABLE profiles (
    profileid INT NOT NULL AUTO_INCREMENT,
    userid INT NOT NULL,
    firstname VARCHAR(25),
    lastname VARCHAR(25),
    city VARCHAR(100),
    state VARCHAR(2),
    purchaseprice FLOAT(10,2),
    purchasedate INT,
    mortgagebalance FLOAT(10,2),
    housephoto VARCHAR(255),
    twittername VARCHAR(50),
    FOREIGN KEY (userid) REFERENCES users (userid),
    PRIMARY KEY (profileid)
);

CREATE TABLE timeine (
    timelineid INT NOT NULL AUTO_INCREMENT,
    profileid INT NOT NULL,
    userid INT NOT NULL,
    entrydate INT NOT NULL,
    title VARCHAR(255),
    description TEXT,
    FOREIGN KEY (profileid) REFERENCES profile (profileid),
    FOREIGN KEY (userid) REFERENCES users (userid),
    PRIMARY KEY (timelineid) 
);

planet-refi's People

Contributors

sipple avatar brennen avatar

Stargazers

avatar avatar

Watchers

avatar avatar

planet-refi's Issues

Change Header Text & Title

Change reference to: NPR's Planet Money

Call it Planet Money Listen Race to Refinance

Add "Want to play?" e-mail link

TEXT:
Welcome to the refinance timeline. This is the ongoing timeline of three regular people, connected only by their love of Planet Money, who are trying to refinance their mortgage. Mortgage rates are low, but credit is tight. If they're lucky, their refinance will be more interesting than ever other banking transaction in history. If they're very lucky, they'll manage to save some money on their home in the process.

The timeline below is easy to use. Just put your mouse over the either band and click and drag to the left or right.

Wish us luck.

Add ability to edit timeline entries

Right now you can't change them once they're submitted. This needs to be fixed so that on either the profile page or the add timeline entry page you see a list of old entries, ordered chronologically.

Change Timeline Start Date

The timeline should begin at the beginning. The first event should be in the leftmost third of the timeline.

Add Profiles to buttom of page

Divide the area below the timline into three divs, put a smaller version of the house photos & a name in each div, which links to the full profile.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.