Sorry I slightly misrepresented the schema. An Account does not have a company id column. So in your opinion what's the best option here. I have a company that may or maynot have a reference to an account. However both the company and the aacount tables need to have a way to link multiple contacts to them. I was gonna just put an either or constraint on the contact table ie. Must have accountid or companyid but not both. The kicker with that is a company can later get referenced to an accountid, which means i need a trigger to go check it's contacts and remove the company id and add the account id. Idk I'm just hoping I'll discover a more elegant solution
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.