ActiveRecord::Schema.define(version: 20150127171609) do

  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"

  create_table "firms", force: :cascade do |t|
    t.string   "name"
    t.string   "address"
    t.string   "postcode"
    t.string   "tel"
    t.string   "email"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "solicitors", force: :cascade do |t|
    t.string   "name"
    t.string   "address"
    t.string   "postcode"
    t.string   "mobile"
    t.string   "email"
    t.integer  "firm_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "solicitors", ["firm_id"], name: "index_solicitors_on_firm_id", using: :btree

  add_foreign_key "solicitors", "firms"
end
