company_name table

[coyotemarin]

We should keep track of alternate names for companies, so we can match against them.

Fields:

• company: canonical company name
• company_name: company name
• is_full: did we pick this as the company's full name?

I don't think we need a flag to tell us a name is canonical (just check if company == company_name).

[coyotemarin]

This is done.