posted 17 years ago
Jay,
What tool are you using to do the reverse engineering?
The table structure you have defined would actually be one-to-many; you haven't defined any reverse restriction that there's a unique constraint on person (name + ssid). This is assuming that by stating you've defined ssid as unique, you mean as the primary key of ref_ssid. If you mean in the person table, then that should be sufficient.
You may want to double check your FK was correctly defined. If you did it in the order you described, it would have failed, because you can't add a FK to a table/field that doesn't yet exist. i.e., try:
But not knowing the full details or what tool your using, these are just best guesses.
There will always be people who are ahead of the curve, and people who are behind the curve. But knowledge moves the curve. --Bill James