Hey All,
I have a database that tracks projects and companies. I have been asked to add a table that will track contracts that are either associated with project OR with a company. I have made a very simple data model that is attached to this post that will hopefully help explain better. I should also mention that each project always has a company assigned to it.
My question is whether or not I am going about it the right way. Are there any obvious pitfalls with this relationship/table structure? I should mention that each relationship is 1 to many.
Thanks for any and all input and sorry for my rudimentary "data model"
I have a database that tracks projects and companies. I have been asked to add a table that will track contracts that are either associated with project OR with a company. I have made a very simple data model that is attached to this post that will hopefully help explain better. I should also mention that each project always has a company assigned to it.
My question is whether or not I am going about it the right way. Are there any obvious pitfalls with this relationship/table structure? I should mention that each relationship is 1 to many.
Thanks for any and all input and sorry for my rudimentary "data model"