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

on delete cascade

);

Create table child_disable(

Child_name varchar(20),

Child_sex varchar(4),

Child_born date,

Child_tel varchar(15),

Info_come varchar(20),

Add_time date ,

Vision varchar(10),

Hearing Varchar(4),

Language Varchar(4),

Intelligence Varchar(4),

Braindamage Varchar(4),

Brain Varchar(4),

Disable_remark varchar(80),

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

constraint gedit_child_disable

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 child_drawback(

Child_name varchar(20),

Child_sex varchar(4),

Child_born date,

Child_tel varchar(15),

Info_come varchar(20),

Add_time date ,

First_diagnosis Varchar(30),

Second_diagnosis varchar(30),

Third_diagnosis varchar(30),

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

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 child_feedback(

Child_name varchar(20),

Child_sex varchar(4),

Child_born date,

Child_tel varchar(15),

Info_come varchar(20),

Year integer not null,

Case_stat integer not null,

Feedback_stat integer not null,

Feedback_time date ,

Child_where varchar(12) ,

Child_id varchar(20) ,

Id_born varchar(20) ,

Addr_county Varchar(10) Not null,

Addr_community Varchar(20) Not null,

Address Varchar(20) not null,

Train Varchar(20) ,

School Varchar(20) ,

Design_hospital varchar(20),

Other Varchar(50),

Info_diagnosis Varchar(50) not null,

Aduit integer not null

);

反馈过程和上报信息的过程是一个相对独立的过程，所以不需要和儿童的基础信息建立外关联以及级联操作 ，否则如果删除儿童的基础信息可能会对反馈信息产生影响

年度设置:

create table Year(Year integer primary key,Year_start date not null,Year_end date not null)

标准基础信息:standard_base_info

Create table standard_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),

Father Varchar(20),

Father_nation Varchar(10),

Mother Varchar(20),

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

Sick integer,

Cold_medicine varchar(20),

Antibiotic varchar(20),

Tocolytic varchar(20),

Other_drug varchar(20),

Alcohol Varchar(20),

X_ray Varchar(20),

Chemistry Varchar(20),

Other_danger Varchar(20),

Stillbirth integer,

Abortion integer,

Sick1 varchar(20),

Relation1 varchar(10),

Sick2 varchar(20),

Relation2 varchar(10),

Sick3 Varchar(20),

Relation3 Varchar(10),

Close_marry Varchar(10),

Marry_relation Varchar(10),

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

)

标准诊断信息:standard_diagnosis_info

Create table standard_diagnosis_info (

Child_name varchar(20),

Child_sex varchar(4),

Child_born date,

Child_tel varchar(15),

Info_come varchar(20),

Add_time date,

Diagnosis_type integer,

Diagnosis_age Varchar(20),

Diagnosis_basis Varchar(20),

Hospitalized_num Varchar(20),

Num Varchar(20),

Report Varchar(20),

Department Varchar(20),

Phone_num Varchar(15),

County Varchar(10),

Vision Varchar(10),

Hearing Varchar(4),

Language Varchar(4),

Intelligence Varchar(4),

Braindamage Varchar(4),

Brain Varchar(4),

First_diagnosis Varchar(30),

Second_diagnosis Varchar(30),

Third_diagnosis Varchar(30),

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

)

注:进入标准基础信息和标准诊断信息表的数据就不能进行任何修改了.