var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
multiple relations between two tables
I read all threats about multiple relations on the forum. but I did not find answer my question.
I want to design a petition database,
"user" & "petition"
1) compose: "users can compose several petitions. every petition must belong to one user"
2) sign: "users can sign any petition for one time. a petition can include several user sign"
I do something but I feel there is something wrong... (you can see it attached image)
1) how must be the tables and relations in this case?
2) do you know complete example about petition database?
If you could guide me, I will be very happy
sorry for my bad english.
that model looks okay to me
why do you feel there is something wrong?
by the way, your english is fine
thank you for your answer dear r937,
I dont know. I am very newbie about database design...
Only feeling. I am not sure if its possible to define multible relations like this.
I do not want to face some problems while I run sql queries..
you said that multiple relations like this is possible and in accordance with database design consept and rules...?
thank you again...
Originally Posted by maximus___
thank you very much dear r937