代码改变世界

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)
);