Skip to content
hkal edited this page Nov 21, 2013 · 4 revisions

Welcome to the crunchinator wiki!

Models

Company

  • id
  • name
  • permalink
  • crunchbase_url
  • homepage_url
  • blog_url
  • blog_feed_url
  • twitter_username
  • category_code
  • number_of_employees
  • founded_year
  • founded_month
  • founded_day
  • deadpooled_year
  • deadpooled_month
  • deadpooled_day
  • deadpooled_url
  • tag_list
  • alias_list
  • email_address
  • phone_number
  • description
  • created_at
  • updated_at
  • overview
  • total_money_raised
  • ipo

Person

  • id
  • First name
  • last name
  • permalink

Relationship

  • id
  • person_id
  • company_id
  • is_past
  • title

FundingRound

  • id
  • round_code
  • source_url
  • source_description
  • raised_amount
  • raised_currency_code
  • funded_year
  • funded_month
  • funded_day

Investor

Note: This is polymorphic on people, and companys

  • company_id
  • investor_type (FINANCIAL, COMPANY, PERSON)
  • investor_id

Office

  • description
  • address1
  • address2
  • zip_code
  • city
  • state_code
  • country_code
  • latitude
  • longitude
  • headquarters - boolean

##Associations

  • many to many between company and person through relationships
  • many to many between funding round and person through investors
  • polymorphic on investors to company, person, (a company can be a financial org as well)
  • Company has many FundingRounds
  • Company has many Offices

##Data to Omit (First round)

  • products
  • competitors
  • providerships
  • investments
  • acquisition
  • acquisitions
  • Milestones
  • video_embeds
  • screenshots
  • external_links
  • partners
Clone this wiki locally