Hiscoder

HisCoder

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: :: 管理 ::

create table school(
id number primary key ,
schoolName varchar2(20) not null ,
address varchar2(50)
);

create table teacher(
id number primary key ,
teacherName varchar2(20) not null ,
sex varchar(2) ,
schoolId number ,
constraint fk_t_s_id foreign key(schoolId) references school(id)
);

 

posted on 2012-03-02 17:36  HisCoder  阅读(300)  评论(0编辑  收藏  举报