gistfile1

  create_table "itsidiy_activities", :force => true do |t|
    t.integer "user_id"
    t.string  "uuid"
    t.boolean "public"
    t.boolean "draft"
    t.string  "short_name"
    t.boolean "textile"
    t.string  "name"
    t.string  "description"
    t.text    "introduction"
    t.text    "standards"
    t.integer "probe_type_id"
    t.text    "materials"
    t.text    "safety"
    t.text    "proced"
    t.text    "predict"
    t.text    "collectdata"
    t.text    "analysis"
    t.text    "conclusion"
    t.text    "further"
    t.integer "sds_offering_id"
    t.string  "content_digest"
    t.boolean "introduction_text_response"
    t.boolean "prediction_text_response"
    t.boolean "prediction_graph_response"
    t.boolean "proced_text_response"
    t.boolean "proced_drawing_response"
    t.boolean "collectdata_text_response"
    t.boolean "analysis_text_response"
    t.boolean "conclusion_text_response"
    t.boolean "further_text_response"
    t.text    "collectdata2"
    t.boolean "collectdata2_text_response"
    t.boolean "collectdata_probe_active"
    t.boolean "collectdata_model_active"
    t.boolean "collectdata2_probe_active"
    t.boolean "collectdata2_model_active"
    t.integer "collectdata2_probetype_id"
    t.integer "model_id"
    t.integer "collectdata2_model_id"
    t.boolean "collectdata_probe_multi"
    t.boolean "collectdata2_probe_multi"
    t.text    "collectdata3"
    t.boolean "collectdata3_text_response"
    t.boolean "collectdata3_probe_active"
    t.boolean "collectdata3_model_active"
    t.boolean "collectdata3_probe_multi"
    t.integer "collectdata3_probetype_id"
    t.integer "collectdata3_model_id"
    t.boolean "further_model_active"
    t.integer "further_model_id"
    t.boolean "collectdata_drawing_response"
    t.boolean "collectdata2_drawing_response"
    t.boolean "collectdata3_drawing_response"
    t.boolean "further_drawing_response"
    t.boolean "introduction_drawing_response"
    t.boolean "prediction_drawing_response"
    t.boolean "analysis_drawing_response"
    t.boolean "conclusion_drawing_response"
    t.boolean "further_probe_active"
    t.integer "further_probetype_id"
    t.boolean "further_probe_multi"
    t.text    "custom_otml"
    t.boolean "collectdata_graph_response"
    t.boolean "collectdata1_calibration_active"
    t.integer "collectdata1_calibration_id"
    t.boolean "collectdata2_calibration_active"
    t.integer "collectdata2_calibration_id"
    t.boolean "collectdata3_calibration_active"
    t.integer "collectdata3_calibration_id"
    t.boolean "furtherprobe_calibration_active"
    t.integer "furtherprobe_calibration_id"
    t.boolean "nobundles"
    t.integer "parent_id"
    t.integer "parent_version"
    t.integer "version"
    t.integer "previous_user_id"
    t.string  "image_url"
    t.text    "career_stem"
    t.boolean "career_stem_text_response"
    t.boolean "archived",                        :default => false
    t.text    "career_stem2"
    t.boolean "career_stem2_text_response"
  end


  ## Not sure if we need this, or if we can use something else
  ##
  create_table "itsidiy_calibrations", :force => true do |t|
    t.integer "data_filter_id"
    t.integer "probe_type_id"
    t.boolean "default_calibration"
    t.integer "physical_unit_id"
    t.integer "user_id"
    t.string  "name"
    t.text    "description"
    t.float   "k0"
    t.float   "k1"
    t.float   "k2"
    t.float   "k3"
    t.integer "y_axis_min"
    t.integer "y_axis_max"
    t.integer "x_axis_min"
    t.integer "x_axis_max"
    t.integer "previous_user_id"
    t.string  "uuid"
  end

  create_table "itsidiy_data_filters", :force => true do |t|
    t.integer "user_id"
    t.string  "name"
    t.text    "description"
    t.string  "otrunk_object_class"
    t.boolean "k0_active"
    t.boolean "k1_active"
    t.boolean "k2_active"
    t.boolean "k3_active"
    t.integer "previous_user_id"
    t.string  "uuid"
  end

  create_table "itsidiy_device_configs", :force => true do |t|
    t.integer  "vendor_interface_id"
    t.string   "config_string"
    t.integer  "user_id"
    t.string   "uuid"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "previous_user_id"
  end

  create_table "itsidiy_external_otrunk_activities", :force => true do |t|
    t.integer "user_id"
    t.boolean "public"
    t.string  "name"
    t.text    "description"
    t.text    "otml"
    t.integer "sds_offering_id"
    t.string  "short_name"
    t.string  "uuid"
    t.string  "external_otml_url"
    t.boolean "external_otml_always_update"
    t.date    "external_otml_last_modified"
    t.string  "external_otml_filename"
    t.string  "custom_reporting_mode"
    t.boolean "nobundles"
    t.integer "parent_id"
    t.integer "parent_version"
    t.integer "version"
    t.integer "previous_user_id"
  end

  create_table "itsidiy_model_types", :force => true do |t|
    t.string  "name"
    t.text    "description"
    t.string  "url"
    t.text    "credits"
    t.string  "otrunk_object_class"
    t.string  "otrunk_view_class"
    t.boolean "authorable"
    t.integer "user_id"
    t.boolean "sizeable"
    t.integer "previous_user_id"
    t.string  "uuid"
  end

  create_table "itsidiy_models", :force => true do |t|
    t.integer "user_id"
    t.integer "model_type_id"
    t.string  "name"
    t.string  "url"
    t.boolean "public"
    t.boolean "textile"
    t.text    "description"
    t.text    "instructions"
    t.boolean "snapshot_active"
    t.text    "credits"
    t.string  "uuid"
    t.integer "sds_offering_id"
    t.string  "short_name"
    t.integer "height"
    t.integer "width"
    t.boolean "nobundles"
    t.integer "parent_id"
    t.integer "parent_version"
    t.integer "version"
    t.integer "previous_user_id"
    t.string  "image_url"
  end