СКРИПТЫ В INTERBASE

[tuchka1989]

Народ подскажите мне. вот я пишу скрипт
create table resulrat1
(nomer nnum,
rezult char(6) not null check (rezult in ('zach','nezach','otl','hor','ud',' neud')),
nomer_ved integer not null check (nomer_ved >0),
nomer_stud integer not null check (nomer_stud between 0 and 500000),
primary key(nomer,nomer_ved),
foreign key (nomer_ved) references vedom(nomer) on delete set null on update cascade,
foreign key (nomer_stud) references student (univernumber) on delete set null on update cascade);

Он мне выдает ошибку типа
unsucceful metadata update
could not find UNIQUE INDEX with specified columns on line 1:...
Че это значит?? уже задолбалась!!!!!!!!!

[Proof]

Попробуй

nomer nnum not null