gistfile1.txt

# This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of Active Record to incrementally modify your database, and
# then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your database schema. If you need
# to create the application database on another system, you should be using db:schema:load, not running
# all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended to check this file into your version control system.

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

  create_table "accessories", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "project_id"
    t.integer  "position"
    t.string   "part_number"
    t.string   "short_name"
  end

  create_table "average_roof_heights", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "bill_of_materials", :force => true do |t|
    t.integer  "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "foot_quantity_calculated"
    t.integer  "module_quantity_calculated"
    t.integer  "interlock_quantity_calculated"
    t.integer  "ground_zep_quantity_calculated"
    t.integer  "array_skirt_quantity_calculated"
    t.integer  "zep_wire_clips_quantity_calculated"
    t.integer  "zep_tool_quantity_calculated"
    t.integer  "comp_mount_quantity_calculated"
    t.integer  "flat_tool_quantity_calculated"
    t.integer  "foot_quantity_override"
    t.integer  "module_quantity_override"
    t.integer  "interlock_quantity_override"
    t.integer  "ground_zep_quantity_override"
    t.integer  "array_skirt_quantity_override"
    t.integer  "zep_wire_clips_quantity_override"
    t.integer  "zep_tool_quantity_override"
    t.integer  "comp_mount_quantity_override"
    t.integer  "flat_tool_quantity_override"
    t.integer  "hybrid_interlock_overstock_quantity_calculated"
    t.integer  "hybrid_interlock_overstock_quantity_override"
    t.integer  "ground_zep_overstock_quantity_calculated"
    t.integer  "ground_zep_overstock_quantity_override"
  end

  create_table "exposure_categories", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "ground_snow_loads", :force => true do |t|
    t.string   "name"
    t.integer  "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "height_adjustment_factor_lookups", :force => true do |t|
    t.integer  "mean_roof_height_in_ft"
    t.string   "exposure_category"
    t.float    "lambda_factor"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "importance_factors", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "layouttools", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "orientation"
    t.integer  "project_id"
    t.integer  "module_meta_data_id"
    t.float    "roof_width"
    t.float    "roof_length"
    t.float    "rafter_spacing_interior_override"
  end

  create_table "lumber_types", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "module_meta_datas", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.float    "length"
    t.float    "width"
    t.string   "model_name"
    t.string   "manufacturer"
    t.float    "rated_power_stc"
    t.float    "weight"
    t.integer  "layouttool_id"
    t.integer  "skirt_id"
  end

  create_table "net_design_wind_pressure_lookups", :force => true do |t|
    t.string   "zone_name"
    t.integer  "zone_number"
    t.integer  "effective_wind_area_in_sqft"
    t.integer  "min_slope_in_degrees"
    t.integer  "max_slope_in_degrees"
    t.integer  "wind_speed_in_mph"
    t.float    "pnet_30_down_in_psf"
    t.float    "pnet_30_up_in_psf"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "newlayouttools", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "projects", :force => true do |t|
    t.string   "name"
    t.string   "first_name"
    t.string   "last_name"
    t.string   "street"
    t.string   "city"
    t.string   "zip"
    t.string   "phone"
    t.string   "email"
    t.integer  "united_state_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
    t.string   "country_code"
    t.string   "product_type"
    t.string   "state"
    t.string   "po_box"
    t.text     "removed_modules"
  end

  create_table "purling_dimensions", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "purling_spacings", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "rafter_dimensions", :force => true do |t|
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "name"
  end

  create_table "rafter_spacings", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
  end

  create_table "roof_attachment_types", :force => true do |t|
    t.string   "name"
    t.integer  "wind_uplift_in_psf"
    t.integer  "wind_down_in_psf"
    t.integer  "snow_down_in_psf"
    t.integer  "snow_shear_in_psf"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "wind_uplift_in_psf_restricted"
    t.integer  "snow_shear_in_psf_restricted"
    t.integer  "roof_type_id"
    t.float    "wind_shear_in_psf"
    t.float    "wind_shear_in_psf_restricted"
  end

  create_table "roof_sections", :force => true do |t|
    t.integer  "roof_id"
    t.integer  "roof_type_id"
    t.integer  "average_roof_height_id"
    t.integer  "rafter_spacing_id"
    t.integer  "rafter_dimensions_id"
    t.integer  "purling_spacing_id"
    t.integer  "purling_dimensions_id"
    t.integer  "roof_zone_setback_length_id"
    t.integer  "lumber_type_id"
    t.integer  "pitch_slope"
    t.integer  "azimut_angle"
    t.float    "least_horizontal_dimension"
    t.float    "length"
    t.float    "height"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "name"
    t.string   "structural_member"
    t.integer  "roof_attachment_type_id"
    t.float    "width"
    t.integer  "edge_and_corner_dimension_a"
  end

  create_table "roof_types", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "enabled"
  end

  create_table "roof_zone_setback_lengths", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "roofs", :force => true do |t|
    t.integer  "site_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "name"
  end

  create_table "sites", :force => true do |t|
    t.integer  "wind_speed_id"
    t.integer  "exposure_category_id"
    t.integer  "ground_snow_load_id"
    t.integer  "importance_factor_id"
    t.integer  "topographic_factor_id"
    t.integer  "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "skirts", :force => true do |t|
    t.string   "name"
    t.float    "length"
    t.integer  "module_meta_data_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "part_number"
    t.string   "description"
  end

  create_table "street_addresses", :force => true do |t|
    t.string   "street_address"
    t.string   "city"
    t.string   "po_box"
    t.integer  "united_state_id"
    t.string   "country_code"
    t.string   "zip"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
  end

  create_table "topographic_factors", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
  end

  create_table "united_states", :force => true do |t|
    t.string   "name"
    t.string   "abbreviation"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "users", :force => true do |t|
    t.string   "name",                      :limit => 100, :default => ""
    t.string   "email",                     :limit => 100
    t.string   "crypted_password",          :limit => 40
    t.string   "salt",                      :limit => 40
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "remember_token",            :limit => 40
    t.datetime "remember_token_expires_at"
    t.string   "reset_code"
    t.boolean  "is_admin"
    t.string   "name_last"
    t.string   "phone"
    t.string   "company"
  end

  create_table "wind_speeds", :force => true do |t|
    t.string   "name"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

end