触发器及建表sql语句(2)

insert into users(username, passwd,permit, org) values('pt00','pt00888',36,'普陀区妇幼保健所'); insert into users(username, passwd,permit, org) values('pt01','pt01888',4,'普陀区妇幼保健所'); insert into users(username, passwd,permit, org) values('pt02','pt02888',68,'普陀区妇幼保健所');

insert into users(username, passwd,permit, org) values('zb00','zb00888',36,'闸北区妇幼保健所'); insert into users(username, passwd,permit, org) values('zb01','zb01888',4,'闸北区妇幼保健所'); insert into users(username, passwd,permit, org) values('zb02','zb02888',68,'闸北区妇幼保健所');

insert into users(username, passwd,permit, org) values('hk00','hk00888',36,'虹口区妇幼保健所'); insert into users(username, passwd,permit, org) values('hk01','hk01888',4,'虹口区妇幼保健所'); insert into users(username, passwd,permit, org) values('hk02','hk02888',68,'虹口区妇幼保健所');

insert into users(username, passwd,permit, org) values('yp00','yp00888',36,'杨浦区妇幼保健所'); insert into users(username, passwd,permit, org) values('yp01','yp01888',4,'杨浦区妇幼保健所'); insert into users(username, passwd,permit, org) values('yp02','yp02888',68,'杨浦区妇幼保健所');

insert into users(username, passwd,permit, org) values('mx00','mx00888',36,'闵行区妇幼保健所');

insert into users(username, passwd,permit, org) values('mx01','mx01888',4,'闵行区妇幼保健所'); insert into users(username, passwd,permit, org) values('mx02','mx02888',68,'闵行区妇幼保健所

insert into users(username, passwd,permit, org) values('bs00','bs00888',36,'宝山区妇幼保健所'); insert into users(username, passwd,permit, org) values('bs01','bs01888',4,'宝山区妇幼保健所'); insert into users(username, passwd,permit, org) values('bs02','bs02888',68,'宝山区妇幼保健所');

insert into users(username, passwd,permit, org) values('jd00','jd00888',36,'嘉定区妇幼保健所'); insert into users(username, passwd,permit, org) values('jd01','jd01888',4,'嘉定区妇幼保健所'); insert into users(username, passwd,permit, org) values('jd02','jd02888',68,'嘉定区妇幼保健所');

insert into users(username, passwd,permit, org) values('pd00','pd00888',36,'浦东新区妇幼保健所');

insert into users(username, passwd,permit, org) values('pd01','pd01888',4,'浦东新区妇幼保健所'); insert into users(username, passwd,permit, org) values('pd02','pd02888',68,'浦东新区妇幼保健所');

insert into users(username, passwd,permit, org) values('sj00','sj00888',36,'松江区妇幼保健所'); insert into users(username, passwd,permit, org) values('sj01','sj01888',4,'松江区妇幼保健所'); insert into users(username, passwd,permit, org) values('sj02','sj02888',68,'松江区妇幼保健所');

insert into users(username, passwd,permit, org) values('qp00','qp00888',36,'青浦区妇幼保健所'); insert into users(username, passwd,permit, org) values('qp01','qp01888',4,'青浦区妇幼保健所'); insert into users(username, passwd,permit, org) values('qp02','qp02888',68,'青浦区妇幼保健所');

insert into users(username, passwd,permit, org) values('nh00','nh00888',36,'南汇区妇幼保健所'); insert into users(username, passwd,permit, org) values('nh01','nh01888',4,'南汇区妇幼保健所'); insert into users(username, passwd,permit, org) values('nh02','nh02888',68,'南汇区妇幼保健所');

insert into users(username, passwd,permit, org) values('fx00','fx00888',36,'奉贤区妇幼保健所'); insert into users(username, passwd,permit, org) values('fx01','fx01888',4,'奉贤区妇幼保健所'); insert into users(username, passwd,permit, org) values('fx02','fx02888',68,'奉贤区妇幼保健所');

insert into users(username, passwd,permit, org) values('cm00','cm00888',36,'崇明县妇幼保健所'); insert into users(username, passwd,permit, org) values('cm01','cm01888',4,'崇明县妇幼保健所'); insert into users(username, passwd,permit, org) values('cm02','cm02888',68,'崇明县妇幼保健所');

下面是儿童信息管理部分建立数据 (注意oracle下外关联键只能用

On delete cascade不能使用on update

Cascade,要使用on update cascade只能使用触发器

)

Create table base_info

(

Child_name varchar(20),

Child_sex varchar(4),

Child_born date,

Child_tel varchar(15),

Info_come varchar(20),

Add_time date ,

Id_born varchar(20),

Child_id varchar(20),

Pregnancy_time integer,

Birth_time integer,

Gestational_weeks integer,

Birth_weight integer,

Embryo_num integer,

Shift integer,

Dead_old varchar(10),

Merger integer,

Primary key(Child_name , Child_sex,Child_born,Child_tel ,Info_come ,Add_time) );

Create table family_info

(

Child_name varchar(20),

Child_sex varchar(4),

Child_born date,

Child_tel varchar(15),

Info_come varchar(20),

Add_time date ,

Father varchar(20),

Father_born date,

Father_nation varchar(10),

Mother varchar(20),

Mother_born date,

Mother_nation varchar(10),

Family_register varchar(6) not null,

Addr_county varchar(10) not null,

Addr_community varchar(20) not null,

Address varchar(20) not null,

Post varchar(10),

Primary key(Child_name , Child_sex,Child_born,Child_tel ,Info_come ,Add_time),

constraint gedit_family_info

Foreign key(Child_name , Child_sex,Child_born,Child_tel ,Info_come ,Add_time) references Base_info(Child_name , Child_sex,Child_born,Child_tel ,Info_come ,Add_time) on delete cascade

);

Create table mother_info(

Child_name varchar(20),

Child_sex varchar(4),

Child_born date,

Child_tel varchar(15),

Info_come varchar(20),

Add_time date ,

Sick integer,

Cold_medicine varchar(20),

Antibiotic varchar(20),

Tocolytic varchar(20),

Other_drug varchar(20),

Alcohol varchar(20),

X_ray varchar(20),

Chemistry varcha …… 此处隐藏：4909字，全部文档内容请下载后查看。喜欢就下载吧 ……