[mmcnl]

"Show me your flowchart and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won't usually need your flowchart; it'll be obvious." -- Fred Brooks, The Mythical Man Month (1975)

[Aeolun]

This man has clearly never seen our database schema.

Show me either flowcharts and/or tables, it doesn’t matter, I’ll continue to be mystified.

[alliao]

our devs created smash hits such as

  NounFunction
  NounFunctionTemporal
  NounCollectionFunction

  FunctionNoun_Function
  FunctionNoun_FunctionItem

  Noun_Collection
  Noun_Collection_Function
  Noun_Collection_FunctionItem

i've taken out duplicating combinations where different teams wanted same things over time, but never looked up what others had done before and decided to spin their own...

[Aeolun]

Don’t forget

Noun_Collection_Function_20200406 Noun_Collection_Function_20200320_Backup

And

Noun_Collection_Function_ForJim

[SulphurSmell]

I would be having words with the DBA about this. If there is a DBA. No DBA I would hire would allow this silliness. At least not in the actual application schema.

[spacemanmatt]

> At least not in the actual application schema.

And that's how the scratchpad schema became mission-critical ;)

[Akronymus]

Hey, at least you don't store gender in the address table, where one person can have multiple addresses.

https://news.ycombinator.com/item?id=27842820

[lazide]

That will explain a lot probably about many things!

[teddyh]

He said usually.

[SulphurSmell]

This is going on my wall. Thanks so much.

[mmcnl]

I got from a comment on HN a few months ago, so also thank the commenter that I don't remember.