Skip to content

Instantly share code, notes, and snippets.

@volkanunsal volkanunsal/schema

Created Jun 16, 2020
Embed
What would you like to do?
# 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
#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.