drsql (5/9/2011)

---

My suggestion is to create the tables like this:

create table WebAccount

(

WebAccountId int primary key, --or whatever key

...

)

create table Retailer

(

...

Steve Jones - SSC Editor (5/2/2011)

---

I'm not necessarily looking for validation here, but a way to capture and consider linking things together. I can foresee that someone says they work...

Really, an organization wouldn't be an "owner" of a certification. That is specifically tied to the user. And the user enters the things like certifications and training records. There isn't...

A certification is just a record entered by a user. It could be that they are certified to work on a piece of equipment, or that they passed a test...

Really, the "records" are separate from the organizations. A user can have certifications and information about training they have received, and they don't have to be associated with an organization,...

In the first (current) example, the user_to_organization table is just a link from the users to the organizations we have listed. The user_custom_organization is just the custom organizations that the...

The organizations that a user can have in their profile could be anything from a major company to a company they ran out of their garage. It isn't huge deal...

All of our primary...

That makes sense. Right now for the thing that I need to do, I think I'll just use either a view or triggers into new tables to get the data...

Oh, ok. Yeah, I'm not worried about actually moving the data so much as just having the data stored both ways in parallel for say a week or two while...

I'm not wanting to actually migrate from one database to another. Although this time, I kind of am...:-P

I didn't want to post exactly what I was trying to migrate at...

Yeah. For example, the developer before me had a table to store multiple ratings for each record in a long string like "|1234:5|1235:6|1236:3|" where the number before each ":" was...

ALZDBA (10/21/2009)

---

I prefer option A, but I would set the end date to a default value of '9999-12-31' and document it.

Point is to avoid the NULL.

Having the actual datetime data...

Garadin (8/14/2009)

---

Also, it's a little unclear where all this data is coming from. Is it stored in a database you have access to, are they creating this data each...

mark.dalley (5/20/2009)

---

My favorite mnemonic method is to take a quote, e.g. "To be or not to be, That is the question."

With a few obvious substitutions, this converts naturally to the...