Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
A mortgage refinance timeline for the web developed for Planet Money
branch: master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
README
footer.php
header.php
index.php
library_main.php
license.php
login.php
logout.php
planet_money_animated.gif
profile.php
refiwidget.html
register.php
screen.css
showtimeline.php
template_profile.php
template_profilelist.php
timeline.js
timeline.php
updatetimeline.php
viewprofile.php

README

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) 
);

Something went wrong with that request. Please try again.