Add parks pacific marine fish codes

[aylapear]

Your Idea

• Add the fish codes from the Parks Canada marine study to the package
• Add Lynn Lee as contributor

[aylapear]

I suggest adding the new table as marineparks

@evanamiesgalonski & @joethorley What do you think the new table name should be?

[aylapear]

We assume the codes should be added to the freshwaterfish as a crossrefence (like the CDCode and ABCode columns) for the ones that span both tables like salmon. Do you agree @evanamiesgalonski ?

[evanamiesgalonski]

i think marineparksfish would be a good name for the new table. And yes I agree it would be good to have an FK column in freshwaterfish to join to the new table.

[joethorley]

Yes agree with adding a FK to freshwater fish for where they match up.

[joethorley]

Our other tables are called ab and cdc so pc would be most fitting but they may have codes for freshwater - so how about pcmarine?

[Alcon98]

Oh I like the way that sounds, really rolls off the tongue