Contents

require 'sniff/database'

Sniff::Database.define_schema do
  create_table "residence_records", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "profile_id"
    t.date     "acquisition"
    t.string   "name"
    t.string   "urbanity_name"
    t.float    "floorspace_estimate"
    t.integer  "floors"
    t.string   "residence_class_name"
    t.date     "construction_year"
    t.float    "annual_fuel_oil_volume_estimate"
    t.float    "annual_fuel_oil_cost"
    t.float    "monthly_natural_gas_volume_estimate"
    t.float    "monthly_natural_gas_cost"
    t.float    "monthly_electricity_use_estimate"
    t.float    "monthly_electricity_cost"
    t.float    "green_electricity"
    t.float    "annual_propane_volume_estimate"
    t.float    "annual_propane_cost"
    t.float    "annual_wood_volume_estimate"
    t.float    "annual_kerosene_volume_estimate"
    t.float    "annual_coal_volume_estimate"
    t.float    "annual_coal_cost"
    t.string   "clothes_machine_use_name"
    t.integer  "refrigerator_count"
    t.float    "lighting_efficiency"
    t.boolean  "ownership"
    t.integer  "freezer_count"
    t.string   "air_conditioner_use_name"
    t.string   "dishwasher_use_name"
    t.string   "zip_code_name"
    t.float    "occupation"
    t.integer  "residents"
    t.integer  "bedrooms"
    t.integer  "dining_rooms"
    t.integer  "living_rooms"
    t.integer  "kitchens"
    t.integer  "full_bathrooms"
    t.integer  "half_bathrooms"
    t.integer  "heated_garage_berths"
    t.integer  "other_rooms"
    t.date     "retirement"
    t.float    "bathrooms"
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
residence-0.0.16	lib/test_support/db/schema.rb
residence-0.0.15	lib/test_support/db/schema.rb
residence-0.0.14	lib/test_support/db/schema.rb
residence-0.0.13	lib/test_support/db/schema.rb
residence-0.0.12	lib/test_support/db/schema.rb
residence-0.0.11	lib/test_support/db/schema.rb
residence-0.0.10	lib/test_support/db/schema.rb
residence-0.0.9	lib/test_support/db/schema.rb
residence-0.0.8	lib/test_support/db/schema.rb
residence-0.0.7	lib/test_support/db/schema.rb
residence-0.0.6	lib/test_support/db/schema.rb
residence-0.0.5	lib/test_support/db/schema.rb
residence-0.0.4	lib/test_support/db/schema.rb