It took me a while to get in the habit of assigning primary keys, foreign keys and things like that when I first started doing database stuff too - there's a lot to keep track of at first! But eventually it becomes more or less instinctive, and the keys just kind of shape up automatically as you work out the database design.
But working with a database that large has got to be scary... At least I got to make most of my initial mistakes on smaller projects!
Yeah, if I had been the one to design this database, it would have primary and foreign keys and it wouldn't be the mess it is now. That's one of the first things I do when I design a db. Figure out what the unique key is going be and how the tables are related to each other. I usually do add additional indexes as well, but didn't think to check if this field was indexed, which was a rookie mistake. Oh well. Live and learn.
The data I'm working with is a colossal mess. I've been freaking out over the condition of it since I started working here. Legacy code (and data) is such a joy to work with. :-/
Comments 2
But working with a database that large has got to be scary... At least I got to make most of my initial mistakes on smaller projects!
Reply
The data I'm working with is a colossal mess. I've been freaking out over the condition of it since I started working here. Legacy code (and data) is such a joy to work with. :-/
Reply
Leave a comment