Home

Jump to bottom Edit New page

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