Hi

So I have a college project to create a database that will allow people to rate a company based on how the customer felt they performed.

Iit would be good to know if Im on the right track

I will create a number of tables and then use views to extract data, I have exported the table structure below comments appreciated

Companyinfo

CREATE TABLE IF NOT EXISTS `companyinfo` (
`companyid` int(11) NOT NULL auto_increment,
`companyname` varchar(255) NOT NULL,
`companywebsite` varchar(255) NOT NULL,
`companyemail` varchar(255) NOT NULL,
PRIMARY KEY (`companyid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



Userinfo

CREATE TABLE IF NOT EXISTS `userinfo` (
`userid` int(11) NOT NULL auto_increment,
`fullname` varchar(255) NOT NULL,
`emailaddress` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


Scoringinfo

CREATE TABLE IF NOT EXISTS `scoringinfo` (
`scoreid` int(11) NOT NULL auto_increment,
`companyid` int(11) NOT NULL COMMENT 'from companyinfo',
`userid` int(11) NOT NULL COMMENT 'from userinfo',
`score` int(11) NOT NULL COMMENT 'score',
PRIMARY KEY (`scoreid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Thanks

John