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

  create_table "accounts", :force => true do |t|
  end

  create_table "students", :force => true do |t|
    t.integer  "account_id"
    t.integer  "legacy_id"
    t.string   "name"
    t.string   "house"
    t.string   "pet_type"
    t.integer  "pet_id"
    t.index    "name", :unique => true
    t.index    "legacy_id", :unique => true
  end

  create_table "parents", :force => true do |t|
    t.integer  "account_id"
    t.integer  "student_id"
    t.integer  "legacy_id"
    t.string   "name"
    t.index    "legacy_id", :unique => true
  end

  create_table "locations", :force => true do |t|
    t.integer  "account_id"
    t.integer  "legacy_id"
    t.string   "slug"
    t.index    "legacy_id", :unique => true
  end

  create_table "students_subjects", :force => true do |t|
    t.integer  "student_id"
    t.integer  "subject_id"
  end

  create_table "subjects", :force => true do |t|
    t.integer  "account_id"
    t.integer  "legacy_id"
    t.string   "name"
    t.index    "legacy_id", :unique => true
  end

  create_table "grades", :force => true do |t|
    t.integer  "account_id"
    t.integer  "subject_id"
    t.integer  "student_id"
    t.integer  "legacy_id"
    t.string   "value"
    t.index    "legacy_id", :unique => true
  end

  create_table "owls", :force => true do |t|
    t.integer  "account_id"
    t.integer  "legacy_id"
    t.string   "name"
    t.index    "legacy_id", :unique => true
  end

  create_table "cats", :force => true do |t|
    t.integer  "account_id"
    t.integer  "legacy_id"
    t.string   "name"
    t.index    "legacy_id", :unique => true
  end

  create_table "abilities", :force => true do |t|
    t.string   "pet_type"
    t.integer  "pet_id"
    t.integer  "legacy_id"
    t.string   "name"
    t.index    "legacy_id", :unique => true
  end

end