Topic List |
Page List:
1 |
---|---|
DevsBro 02/26/20 1:18:39 PM #1: |
This is the worst database I've seen in my entire life.
1002 tables. Probably 980 of those are named two letters, an optional underscore, three digits and an optional underscore with more digits. Ok so maybe the related application generates tables and just has no regard whatsoever for human readability for some reason. It doesn't explain the optional underscore but hey, I'm sure there's a view that sum--ok there are no views. Maybe it's a stored procedure, or a udf. Nope. Those are all updates. Well... Uh... Well why don't we just see what's in some of these tables? field1 field2 field3 field4 field5 field6 field7 field8 field9 field10 field11 OMG WHAT Ok don't panic. Panic is the enemy. Maybe I just picked a bad one that got made as a test. Let me try another. Ok, there's an ID column, and a varchar column with what look like type names. This is good. This I can work with. Let me try another. Well this this is completely denormalized and, as luck would have it, it literally has those exact same type names in one column spelled out and everything. It's like they were trying to normalize the thing then gave up. Which, honestly, I can't blame them. This whole thing needs to be nuked and started over. --- 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 ... Copied to Clipboard!
|
E32005 02/26/20 1:21:12 PM #2: |
... Copied to Clipboard!
|
Christian RULES 02/26/20 1:23:19 PM #3: |
...cool story bro
--- TRUMP 2020 - Keep America Great - Promises Made! Promises Kept! #KAG #MAGA MAN FAN EIGHT YEARS - https://youtu.be/EZGNmxa-sGM - https://imgur.com/K1Q7M5r ... Copied to Clipboard!
|
Romulox28 02/26/20 1:23:59 PM #4: |
... Copied to Clipboard!
|
E32005 02/26/20 1:29:33 PM #5: |
Romulox28 posted...
i think we work at the same company you two should touch tips --- ... Copied to Clipboard!
|
DevsBro 02/26/20 5:13:17 PM #6: |
Ok so I spent a couple of hours deciphering this bad boy and noticed that in cases where the table name particular letters, the number after the underscore refers to the field number. So for example, ab000_13 contains the values that show up in field13 of at least one other table.
I also picked another table at random and found the numbers before the underscore that it references. Who came up with this I swear. It's a good thing I have a query I use that searches an entire database for a string, lol. --- 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 ... Copied to Clipboard!
|
Topic List |
Page List:
1 |