I think the character associatiion needs a bit of work. I dont think that the charid belongs in this table.
possibilities I see:
1. make an instance table, with an instance ID (PK)... one per instanced zone.
Then make a char_instance table which associates players to instances.. if you make the charID the primary key in the association table, it enforces the 1 zone/player constraint.
2. take charid out of the instance table, add a field to the account table which is their instance ID. this also enforces your constraint.
I can help with the SQL to manipulate this if you want. just ask.
|