create table typeinfo(

typeid varchar2(10) primary key,

typename varchar2(20));

create table userinfo_f(

id varchar2(10) primary key,

username varchar2(20),

typeid_new varchar2(10) ,

constraint fk_typeid_new foreign key(typeid_new) references typeinfo(typeid));

insert into typeinfo values(1,'aaa',1);

insert into userinfo_f values(2,'bbb',null);

insert into userinfo_f values(3,'ccc',null);