# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

ActiveRecord::Schema.define(:version => 5) do

  create_table "holdings", :force => true do |t|
    t.column "market_id", :integer
    t.column "user_id",   :integer
    t.column "shares",    :integer
    t.column "cost",      :float
  end

  add_index "holdings", ["user_id"], :name => "user_id"

  create_table "markets", :force => true do |t|
    t.column "team_id",            :integer
    t.column "round",              :integer
    t.column "game",               :integer
    t.column "outstanding_shares", :integer
    t.column "volume",             :integer
    t.column "price",              :float
  end

  create_table "teams", :force => true do |t|
    t.column "name",       :string
    t.column "conference", :string
  end

  create_table "trades", :force => true do |t|
    t.column "market_id",  :integer
    t.column "user_id",    :integer
    t.column "created_on", :datetime
    t.column "shares",     :integer
    t.column "cost",       :float
  end

  add_index "trades", ["market_id"], :name => "market_id"
  add_index "trades", ["user_id"], :name => "user_id"

  create_table "users", :force => true do |t|
    t.column "created_on",      :datetime
    t.column "username",        :string
    t.column "hashed_password", :string
    t.column "email",           :string
    t.column "portfolio_value", :float
  end

  add_index "users", ["username"], :name => "username", :unique => true

end