mysql #1072 - Key column 'relativid' doesn't exist in table

DROP TABLE IF EXISTS relativedetails;
CREATE TABLE IF NOT EXISTS relativedetails (
id int(10) unsigned zerofill NOT NULL auto_increment,
relativeid int(10) unsigned zerofill NOT NULL default '0',
primaryrelativegroup int(10) unsigned zerofill NOT NULL default '0',
foreignrelativegroup int(10) unsigned zerofill NOT NULL default '0',
primaryuserdetails varchar(255) NOT NULL default '0',
foreignuserdetails varchar(255) NOT NULL default '0',
access TINYINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY primaryrelativegroup(primaryrelativegroup),
KEY foreignrelativegroup(foreignrelativegroup),
KEY faccess(access),
foreign key(relativid) references relative(id) on delete cascade on update cascade,
foreign key(primaryrelativegroup) references relativegroup(id)on delete cascade on update cascade,
foreign key(foreignrelativegroup) refere

Mysql是什么？？？ MySQL问题 MYSQL是什么意思? 关于MYSQL!! mysql错误 关于mysql MySql问题 mysql问题 打开mysql Mysql数据库