schema

# Table name: units
#
#  id                      :bigint(8)        not null, primary key
#  name                    :string           not null
#  visibility              :string           not null
#  status                  :string           not null
#  floor                   :string
#  suite                   :string
#  rentable_sqft           :integer          default(0), not null
#  use                     :string           not null
#  building_id             :integer
#  misc                    :jsonb            not null
#  slug                    :string
#  created_at              :datetime         not null
#  updated_at              :datetime         not null
#  company_id              :integer
#  the_geom                :geometry({:srid= geometry, 4326
#  property_id             :integer
#  notes                   :text
#  links                   :text             is an Array
#  description             :text
#  district_property_class :string
#  condo_bbl               :bigint(8)
#  annual_district_payment :bigint(8)        default(0)
#  the_geom_webmercator    :geometry({:srid= geometry, 3857
#  
#  
# Table name: listings
#
#  id                             :bigint(8)        not null, primary key
#  name                           :string           not null
#  description                    :text
#  listing_type                   :string           not null
#  lease_term                     :string
#  current_uses                   :text             default([]), is an Array
#  lease_type                     :string
#  notes                          :text
#  cap_rate                       :decimal(5, 2)    default(0.0), not null
#  market_value_cents             :bigint(8)        default(0), not null
#  market_value_currency          :string           default("USD"), not null
#  url                            :string
#  incentives                     :string
#  price_per_sqft_cents           :bigint(8)        default(0), not null
#  price_per_sqft_currency        :string           default("USD"), not null
#  noi_cents                      :bigint(8)        default(0), not null
#  noi_currency                   :string           default("USD"), not null
#  aux_space_sqft                 :integer          default(0), not null
#  misc                           :jsonb            not null
#  created_at                     :datetime         not null
#  updated_at                     :datetime         not null
#  company_id                     :integer
#  the_geom                       :geometry({:srid= geometry, 4326
#  property_id                    :integer
#  links                          :text             is an Array
#  unit_name                      :string
#  status                         :string
#  intended_use                   :string           default([]), is an Array
#  visibility                     :string           default("Public")
#  the_geom_webmercator           :geometry({:srid= geometry, 3857
#  asking_rent_per_month_cents    :integer          default(0), not null
#  asking_rent_per_month_currency :string           default("USD"), not null
#  asking_price_cents             :integer          default(0), not null
#  asking_price_currency          :string           default("USD"), not null
#
#
# Table name: tenants
#
#  id                   :bigint(8)        not null, primary key
#  name                 :string
#  category             :string
#  subcategories        :text             default([]), is an Array
#  status               :string           not null
#  url                  :string
#  phone                :string
#  email                :string
#  notes                :text
#  misc                 :jsonb            not null
#  created_at           :datetime         not null
#  updated_at           :datetime         not null
#  company_id           :integer
#  the_geom             :geometry({:srid= geometry, 4326
#  property_id          :integer
#  description          :text
#  num_employees        :integer
#  links                :text             is an Array
#  unit_name            :string
#  visibility           :string           default("Public")
#  the_geom_webmercator :geometry({:srid= geometry, 3857
#
#
# Table name: properties
#
#  id                      :bigint(8)        not null, primary key
#  name                    :string
#  visibility              :string           not null
#  property_type           :string
#  property_owners         :string
#  the_geom                :geometry({:srid= not null, geometry, 4326
#  primary_contact_id      :integer
#  company_id              :integer
#  misc                    :jsonb            not null
#  created_at              :datetime         not null
#  updated_at              :datetime         not null
#  address                 :string
#  district_property_class :string
#  annual_district_payment :bigint(8)        default(0)
#  apn                     :string
#  links                   :text             is an Array
#  the_geom_webmercator    :geometry({:srid= geometry, 3857
#
#
# Table name: buildings
#
#  id                      :bigint(8)        not null, primary key
#  name                    :string
#  address                 :string           not null
#  status                  :string           not null
#  num_stories             :integer          default(0), not null
#  total_floor_area_sqft   :integer          default(0), not null
#  rentable_area_sqft      :integer          default(0), not null
#  typical_floor_size_sqft :integer
#  total_units             :integer          default(0), not null
#  year_built              :integer
#  year_last_renovated     :integer
#  url                     :string
#  notes                   :text
#  property_id             :integer
#  misc                    :jsonb            not null
#  created_at              :datetime         not null
#  updated_at              :datetime         not null
#  company_id              :integer
#  the_geom                :geometry({:srid= geometry, 4326
#  bin                     :bigint(8)
#  links                   :text             is an Array
#  the_geom_webmercator    :geometry({:srid= geometry, 3857
#
#
# Table name: developments
#
#  id                           :bigint(8)        not null, primary key
#  name                         :string           not null
#  description                  :text
#  visibility                   :string           not null
#  development_type             :string
#  status                       :string           not null
#  floor_area                   :integer          default(0), not null
#  financing                    :string
#  notes                        :text
#  url                          :string
#  cost_cents                   :bigint(8)        default(0), not null
#  cost_currency                :string           default("USD"), not null
#  program                      :string
#  multifamily_units            :integer          default(0), not null
#  multifamily_sqft             :integer          default(0), not null
#  office_units                 :integer          default(0), not null
#  retail_units                 :integer          default(0), not null
#  industrial_units             :integer          default(0), not null
#  other_units                  :integer          default(0), not null
#  hospitality_units            :integer          default(0), not null
#  comm_facilities_sqft         :integer          default(0), not null
#  parking_spots                :integer          default(0), not null
#  ownership_type               :string
#  misc                         :jsonb            not null
#  created_at                   :datetime         not null
#  updated_at                   :datetime         not null
#  company_id                   :integer
#  the_geom                     :geometry({:srid= geometry, 4326
#  property_id                  :integer
#  developer                    :string
#  architect                    :string
#  links                        :text             is an Array
#  uses                         :text             default([]), not null, is an Array
#  retail_sqft                  :integer          default(0), not null
#  office_sqft                  :integer          default(0), not null
#  industrial_sqft              :integer          default(0), not null
#  other_sqft                   :integer          default(0), not null
#  floors                       :integer          default(0), not null
#  commercial_sqft              :bigint(8)        default(0), not null
#  the_geom_webmercator         :geometry({:srid= geometry, 3857
#  affordable_multifamily_units :integer          default(0), not null
#  expected_completion_year     :integer
#