drop table if exists picfile;
create table picfile (
    nm int primary key,
    filename varchar(50),
    foreign key (nm) references person(nm) 
        on delete cascade on update cascade
);
describe picfile;