3 ms·

I had a job where the database was intentionally lacking FKs so that users could input data out of order, for example create a shipping route Foo that goes to a

I had a job where the database was intentionally lacking FKs so that users could input data out of order, for example create a shipping route Foo that goes to a warehouse Bar, before the warehouse existed. Let's just say it was a suboptimal design.

redact207 7y ago
this just sounds like eventual consistency which can form part of a perfectly optimal design
- Lord_Zero 7y ago
  Or "eventual" never comes and you end up with a bunch of inconsistent data.