Here is a picture of my relationships of my database. At the top left you will see that there is an "Entity" (The Customer). They make a transaction. One type of transaction is just a single work order to do a small job, such as going to someone's house to fix their sink.
The second type of transaction is where the customer hires us to do a job for them, such as replace the sinks in an entire apartment complex in which case a job is created and from that job, multiple work orders are created.
So, if I call your attention to the relationship between the TransactionT table and the JobT table.
Here is the criteria for the relationship:
Many transactions can have jobs
There can only be ONE job for each transaction
I am just checking myself. Is that how this is set up now or do I need to change anything?
The second type of transaction is where the customer hires us to do a job for them, such as replace the sinks in an entire apartment complex in which case a job is created and from that job, multiple work orders are created.
So, if I call your attention to the relationship between the TransactionT table and the JobT table.
Here is the criteria for the relationship:
Many transactions can have jobs
There can only be ONE job for each transaction
I am just checking myself. Is that how this is set up now or do I need to change anything?
Last edited: