Create opportunity tables in analytics db

[mxk0]

Summary

Create tables based on the decision made in #2933

Acceptance criteria

Tables:

• opportunity (3)
• opportunity_summary (4)
• current_opportunity_summary (5)
• lk_opportunity_status (1)
• lk_opportunity_category (2)

[mdragon]

@babebe I think these four should cover it, but if there's any additional tables you think we need or find would be helpful as you build these out, please let me know.

[mdragon]

@chouinar now that you're back, can you just double-check me on this list to make sure I didn't miss anything critical to this first pass?

[chouinar]

If you want the agency names in any reports, you would also want the agency table. Otherwise, that should be enough for count of opportunity by status - technically the summary table could also be excluded as the status is stored in the current_opportunity_summary table, but the summary table has most of the interesting info about an opportunity that I could see some queries built for.

[babebe]

@mdragon do we want agency names?

[mdragon]

@babebe lets go without Agency for this ticket and if we're making good progress we can consider doing agency in a separate ticket now or later when needed.