dbkbali · January 11, 2016 18:15
diff --git a/project_schema.txt b/project_schema.txt
 # == Schema Information
 #
 # Table name: projects
 #
 #  id                           :integer          not null, primary key
 #  site_url                     :string
 #  scrape_date                  :date
 #  scrape_page                  :integer
 #  project_url                  :string
 #  project_id                   :string
 #  list_text                    :text
 #  page_text                    :text
 #  completed                    :boolean          default(FALSE)
 #  project_html                 :text             default("f")
 #  floor_plan_html              :text             default("f")
 #  updated_project_date         :date
 #  refresh                      :boolean          default(FALSE)
 #  name                         :string
 #  buildings                    :integer
 #  building_heights             :integer          default([]), is an Array
 #  building_storeys             :integer          default([]), is an Array
 #  categories                   :string           default([]), is an Array
 #  mls_zone                     :string
 #  developers                   :string           default([]), is an Array
 #  street_address               :string
 #  street_city                  :string
 #  province                     :string
 #  postal_code                  :string
 #  street_area                  :string
 #  lat                          :decimal(9, 6)
 #  lng                          :decimal(9, 6)
 #  storeys                      :integer
 #  units                        :integer
 #  ceilings                     :integer
 #  ceilings_string              :integer
 #  ceiling_from                 :integer
 #  ceiling_to                   :integer
 #  num_floor_plans              :integer
 #  price_from                   :integer
 #  price_to                     :integer
 #  price                        :string
 #  teaser                       :text
 #  project_type                 :string
 #  ownership_type               :string
 #  from_size                    :integer
 #  to_size                      :integer
 #  average_price_sqft           :integer
 #  sales_status                 :string
 #  public_launch                :string
 #  public_launch_date           :date
 #  price_from_sqft              :integer
 #  price_to_sqft                :integer
 #  parking_price_note           :string
 #  parking_price                :integer
 #  locker_price_note            :string
 #  locker_price                 :integer
 #  architects                   :string           default([]), is an Array
 #  interior_designers           :string           default([]), is an Array
 #  landscape_architect          :string           default([]), is an Array
 #  building_units               :integer          default([]), is an Array
 #  parking_spaces               :integer
 #  amenities                    :string           default([]), is an Array
 #  assignment_policy            :string
 #  development_levies           :string
 #  construction_status          :string
 #  est_maintenance_note         :string
 #  est_maintenance              :float
 #  locker_maintenance_note      :string
 #  locker_maintenance           :float
 #  parking_maintenance_note     :string
 #  parking_maintenance          :float
 #  est_property_tax_note        :string
 #  est_property_tax             :float
 #  fees_notes                   :text
 #  est_occupancy                :string
 #  est_occupancy_date           :date
 #  vip_launch                   :string
 #  vip_launch_date              :date
 #  construction_start           :string
 #  construction_start_date      :date
 #  construction_completion      :string
 #  construction_completion_date :date
 #  project_pages                :string
 #  deposit_notes                :text
 #  overview                     :text
 #  additional_specs             :string           default([]), is an Array
 #  builders                     :string           default([]), is an Array
 #  project_website              :string
 #  project_email                :string
 #  registration                 :string
 #  sales_office_phone           :string
 #  marketing_company            :string
 #  sales_company                :string
 #  type                         :string
 #  created_at                   :datetime         not null
 #  updated_at                   :datetime         not null
 #
 # Indexes
 #
 #  index_projects_on_lat_and_lng  (lat,lng)
 #
	# == Schema Information
	#
	# Table name: projects
	#
	# id :integer not null, primary key
	# site_url :string
	# scrape_date :date
	# scrape_page :integer
	# project_url :string
	# project_id :string
	# list_text :text
	# page_text :text
	# completed :boolean default(FALSE)
	# project_html :text default("f")
	# floor_plan_html :text default("f")
	# updated_project_date :date
	# refresh :boolean default(FALSE)
	# name :string
	# buildings :integer
	# building_heights :integer default([]), is an Array
	# building_storeys :integer default([]), is an Array
	# categories :string default([]), is an Array
	# mls_zone :string
	# developers :string default([]), is an Array
	# street_address :string
	# street_city :string
	# province :string
	# postal_code :string
	# street_area :string
	# lat :decimal(9, 6)
	# lng :decimal(9, 6)
	# storeys :integer
	# units :integer
	# ceilings :integer
	# ceilings_string :integer
	# ceiling_from :integer
	# ceiling_to :integer
	# num_floor_plans :integer
	# price_from :integer
	# price_to :integer
	# price :string
	# teaser :text
	# project_type :string
	# ownership_type :string
	# from_size :integer
	# to_size :integer
	# average_price_sqft :integer
	# sales_status :string
	# public_launch :string
	# public_launch_date :date
	# price_from_sqft :integer
	# price_to_sqft :integer
	# parking_price_note :string
	# parking_price :integer
	# locker_price_note :string
	# locker_price :integer
	# architects :string default([]), is an Array
	# interior_designers :string default([]), is an Array
	# landscape_architect :string default([]), is an Array
	# building_units :integer default([]), is an Array
	# parking_spaces :integer
	# amenities :string default([]), is an Array
	# assignment_policy :string
	# development_levies :string
	# construction_status :string
	# est_maintenance_note :string
	# est_maintenance :float
	# locker_maintenance_note :string
	# locker_maintenance :float
	# parking_maintenance_note :string
	# parking_maintenance :float
	# est_property_tax_note :string
	# est_property_tax :float
	# fees_notes :text
	# est_occupancy :string
	# est_occupancy_date :date
	# vip_launch :string
	# vip_launch_date :date
	# construction_start :string
	# construction_start_date :date
	# construction_completion :string
	# construction_completion_date :date
	# project_pages :string
	# deposit_notes :text
	# overview :text
	# additional_specs :string default([]), is an Array
	# builders :string default([]), is an Array
	# project_website :string
	# project_email :string
	# registration :string
	# sales_office_phone :string
	# marketing_company :string
	# sales_company :string
	# type :string
	# created_at :datetime not null
	# updated_at :datetime not null
	#
	# Indexes
	#
	# index_projects_on_lat_and_lng (lat,lng)
	#