colap Posted September 4, 2011 Share Posted September 4, 2011 Every poll can have 7 or 8 or more options. Every quiz can have 5 or more options. This is what i tried => create table polls (id integer not null auto_increment primary key, question varchar(300) not null, mark tinyint not null, created datetime, modified datetime); create table pollsanswers (id integer not null integer auto_increment primary key, poll_id integer not null, answer varchar(500) not null, mark tityint not null, created datetime, modified datetime); create table quizes (id integer not null auto_increment primary key, question varchar(300) not null, mark tinyint not null, created datetime, modified datetime); create table quizesanswers (id integer not null integer auto_increment primary key, quiz_id integer not null, answer varchar(500) not null, mark tityint not null, created datetime, modified datetime); Link to comment https://forums.phpfreaks.com/topic/246395-i-need-a-mysql-table-relationship-for-polls-and-quizes/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.