At work, I am currently dealing with a table that has no primary key, no foreign key, duplicate (almost) serial numbers, booleans stored as strings, and so on. It's a nightmare of a table.

Entity framework is acting like I'm on meth for using such a table.

[–] ChickenLadyLovesLife@lemmy.world 31 points 11 months ago (4 children)

My all-time favorite database table was a table named STATE, meant to store all US states. It had 531 rows.

[–] outcide@lemmy.world 14 points 11 months ago

Relatable. 🤣

[–] reverendsteveii@lemm.ee 12 points 11 months ago

well, there's confusion, paranoia, agitation and so many others...

[–] Melatonin@lemmy.dbzer0.com 4 points 11 months ago

Confusion ... Your medical condition Disorganized

[–] psud@aussie.zone 3 points 11 months ago

I have been trying to get people in my area to make their new table generically named, since it's going to be the only table that can map a date range to a different date range, but I'm on holidays now, and they can't imagine anything other than their little project needing this table, so it's going to be named for this one project, and it's columns will be named for the specific data they'll hold :(

[–] peyotecosmico@programming.dev 20 points 11 months ago (1 children)

I've been there and you know what's worse about it? When you fix it only you or a handful of people notice the astronomical labor you did.

"It worked before why did you change it? You are just doing busywork"

[–] PizzaMane@lemm.ee 11 points 11 months ago

Yeah. Luckily the work I am doing is to fix some really bad work that the entire company has been complaining about. So once it's fixed it will hopefully be a little bit more recognition than that. Plus my boss is pretty level headed.

But who fucking knows? There is always the likelihood that people will say things along those lines. And it ain't my job to fight them on that.

[–] SaintWacko@midwest.social 11 points 11 months ago* (last edited 11 months ago) (1 children)

How about a date stored as an integer?

Edit: and I'm not taking about a timestamp

[–] PizzaMane@lemm.ee 11 points 11 months ago* (last edited 11 months ago)

No, we have worse. Dates sometimes stored as strings, sometimes as datetimes, and sometimes as integers. There is no consistency, logic, or forethought to the schema.

It's rough.