oracle 创建表 外键约束
2017-02-05 17:07 甘雨路 阅读(727) 评论(0) 编辑 收藏 举报create table usertable( id int primary key, username varchar(32) not null, birthday date, sex char(1), address varchar(256) );
create table orders( id int primary key, user_id int not null, numberid varchar(32) not null, createtime date, note varchar(100), constraint fk_orders foreign key (user_id) references usertable(id) );