In an application I have been working on, the further into it I get, the more concerned I am that my basic table structure and foundation is built incorrectly. A stripped down version of the application (only the tables remain) is attached.
This is for an electrical construction quoting. Light fixtures in particular.
I will try to lay out the path and method to my madness so people can hopefully understand what I am trying to accomplish.
QuoteDetails is my "primary" table. It houses all of the pertinent info related to a job (quote #, bid date etc).
QuoteDetails is then linked to the table Revision (quotes could multiple version/history that I need to track).
Those two were easy, the rest is where I am running into problems. Also please note that some tables are not fully fleshed out yet (such as Status and Vendors)
Revision USED to just be tied to Type, but I ran into issues later when trying to implement the table Sheets. A job consist of Sheets (construction plans), within those sheets are types (lighting fixtures designations), with each type having a count on said sheet. In the attached, I tried adding it in differently, but don't believe it is correct at all.
My table Notes is just to hold, you guessed it, notes about a type. NEMA ratings, special features/options etc.
The other tables for the purpose of this question can be ignored.
Is there a better / more correct way to structure the tables? A quote can consist of multiple Revisions (minimum of 1 for the base/original quote). A Revision consist of multiple Sheets. Sheets can have multiple types, and a single type can be on multiple sheets.
I know more clarification will probably be needed, so ask away!
This is for an electrical construction quoting. Light fixtures in particular.
I will try to lay out the path and method to my madness so people can hopefully understand what I am trying to accomplish.
QuoteDetails is my "primary" table. It houses all of the pertinent info related to a job (quote #, bid date etc).
QuoteDetails is then linked to the table Revision (quotes could multiple version/history that I need to track).
Those two were easy, the rest is where I am running into problems. Also please note that some tables are not fully fleshed out yet (such as Status and Vendors)
Revision USED to just be tied to Type, but I ran into issues later when trying to implement the table Sheets. A job consist of Sheets (construction plans), within those sheets are types (lighting fixtures designations), with each type having a count on said sheet. In the attached, I tried adding it in differently, but don't believe it is correct at all.
My table Notes is just to hold, you guessed it, notes about a type. NEMA ratings, special features/options etc.
The other tables for the purpose of this question can be ignored.
Is there a better / more correct way to structure the tables? A quote can consist of multiple Revisions (minimum of 1 for the base/original quote). A Revision consist of multiple Sheets. Sheets can have multiple types, and a single type can be on multiple sheets.
I know more clarification will probably be needed, so ask away!