Sfrgttk

How can I portion out frozen cookie dough?

Writing text next to a table

Is it a Cyclops number? "Nobody" knows!

Is there a way to make cleveref distinguish two environments with the same counter?

What do you call someone who likes to pick fights?

Why is there an extra space when I type "ls" on the Desktop?

How do we create new idioms and use them in a novel?

Why does this boat have a landing pad? (SpaceX's GO Searcher) Any plans for propulsive capsule landings?

What is the purpose of a disclaimer like "this is not legal advice"?

Use Mercury as quenching liquid for swords?

Why aren't there more Gauls like Obelix?

How do I increase the number of TTY consoles?

Under what conditions can the right to be silence be revoked in the USA?

Sampling from Gaussian mixture models, when are the sampled data independent?

Are small insurances worth it?

What is this tube in a jet engine's air intake?

Is there stress on two letters on the word стоят

Smooth vector fields on a surface modulo diffeomorphisms

Difference between `nmap local-IP-address` and `nmap localhost`

Do Paladin Auras of Differing Oaths Stack?

Is it appropriate to ask a former professor to order a book for me through an inter-library loan?

How should I solve this integral with changing parameters?

Which country has more?

Is "cogitate" used appropriately in "I cogitate that success relies on hard work"?

schedule join multiple tables

How do I properly design a many-to-many (charges/payments) accounting system?One to one relationship or another approach?Supertype/Subtype deciding between category: complete disjoint or incomplete overlappingDatabase Design - One table for different types of transactionsWhat is the best way to model an invoicing system with different forms of invoice items?Assigning items to containersERD for a web development companyQuestion when designing a databaseBest design approach to Overriding Table FieldsWhat is the correct way of creating a one-to-one relationship?

0

Basically I need an scalable efficient way to select all scheduled items so it made sense that the main table is the schedule. The problem is that all the operation tables have different properties

I created a diagram which is obviously wrong but demonstrates what I am trying to achieve.

I was thinking about having the join on the other side so that all three operations pointed to the schedule, but if I do that then to get a complete schedule I have to aggregate all the operation tables. What if I have loads more in the future?

Another option was to have the delivery, maintenance, loading columns in the schedule table but again there could be loads more operations. I'm just wondering of I am missing something or is this the best option?

https://dbdiagram.io/d/5c846e62f7c5bb70c72f3f36

database-design mysql-5.7

share

edited 42 secs ago

jim smith

asked 6 mins ago

jim smithjim smith

101

New contributor

jim smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

Basically I need an scalable efficient way to select all scheduled items so it made sense that the main table is the schedule. The problem is that all the operation tables have different properties

I created a diagram which is obviously wrong but demonstrates what I am trying to achieve.

I was thinking about having the join on the other side so that all three operations pointed to the schedule, but if I do that then to get a complete schedule I have to aggregate all the operation tables. What if I have loads more in the future?

Another option was to have the delivery, maintenance, loading columns in the schedule table but again there could be loads more operations. I'm just wondering of I am missing something or is this the best option?

https://dbdiagram.io/d/5c846e62f7c5bb70c72f3f36

database-design mysql-5.7

share

edited 42 secs ago

jim smith

asked 6 mins ago

jim smithjim smith

101

New contributor

jim smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Basically I need an scalable efficient way to select all scheduled items so it made sense that the main table is the schedule. The problem is that all the operation tables have different properties

I created a diagram which is obviously wrong but demonstrates what I am trying to achieve.

I was thinking about having the join on the other side so that all three operations pointed to the schedule, but if I do that then to get a complete schedule I have to aggregate all the operation tables. What if I have loads more in the future?

Another option was to have the delivery, maintenance, loading columns in the schedule table but again there could be loads more operations. I'm just wondering of I am missing something or is this the best option?

https://dbdiagram.io/d/5c846e62f7c5bb70c72f3f36

database-design mysql-5.7

share

edited 42 secs ago

jim smith

asked 6 mins ago

jim smithjim smith

101

New contributor

jim smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

edited 42 secs ago

jim smith

asked 6 mins ago

jim smithjim smith

101

New contributor

jim smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

edited 42 secs ago

jim smith

asked 6 mins ago

jim smithjim smith

101

New contributor

jim smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

jim smithjim smith

101

New contributor

jim smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

jim smithjim smith

101