數(shù)據(jù)庫(kù)課程設(shè)計(jì)__醫(yī)院管理信息系統(tǒng)(編輯修改稿)
2024-10-21 10:16 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 e table admin_person（a_id char(8)primary key，admin_name char(20)not null，sex char(2)default 39。男39。 not null ，add_time smallint default39。039。，person_ID char(18)not null，call_job_id char(8)，addr char(50)，sum_money int，phone char(15)，photo image, constraint fk_admin_call_job foreign key(call_job_id)references call_job(c_id)，constraint Ck_admin_add_time check(add_time=0), constraint ck_sex check(sex in(39。男 39。,39。女39。)))帳號(hào)密碼create table account_password(acc_id char(16)primary key，password char(20)default39。66666639。 not null)手術(shù)類型create table operation_way(opera_id char(5)primary key, opera_name char(25)not null，fee_for_op int)病人手術(shù)create table doc_sick(sick_id char(5)，doctor_id char(8)，real_date smalldatetime，opera_way_id char(5)，constraint Fk_doc_sick_sick_stand_person foreign key(sick_id)references sick_stand_person(stan_in_num)，constraint Fk_doc_sick_doctor foreign key(doctor_id)references doctor(id)，constraint Fk_doc_sick_operation_way foreign key(opera_way_id)references operation_way(opera_id))藥品類型create table drug_type(dy_id char(5)primary key，dy_name char(20)not null,)藥品信息create table drug(d_id char(15)primary key，d_name char(30)not null，make_datetime smalldatetime not null, valid int not null, manufacturer char(30)not null，drug_manage_person_id char(8)，drug_store_id char(5)，d_type_id char(5)，d_price smallint not null，d_number smallint not null，constraint Fk_drug_admin_person foreign key(drug_manage_person_id)references admin_person(a_id), constraint Fk_drug_drug_store foreign key(drug_store_id)references drug_store(drug_id), constraint Fk_drug_drug_type foreign key(d_type_id)references drug_type(dy_id))付費(fèi)create table fee(stan_in_num char(5)primary key，ought_fee int not null，fact_fee int not null，fee_wipe_out_scale_id char(5)，stored_fee int not null，cur_time smalldatetime，stop_drug char(2)default39。停39。, constraint Ck_stop_drug check(stop_drug in(39。停39。,39。用39。))，constraint Fk_fee_sick_stand_person foreign key(stan_in_num)references sick_stand_person(stan_in_num)，constraint Fk_fee_fee_way foreign key(fee_wipe_out_scale_id)references fee_way(fee_id))病人藥create table drug_sick_person(reg_num char(8), d_id char(15), num smallint, real_date smalldatetime, doc_id char(8), constraint Fk_drug_sick_person_sick_person foreign key(reg_num)references sick_person(reg_num), constraint Fk_drug_sick_person_drug foreign key(d_id)references drug(d_id), constraint Fk_drug_sick_person_doctor foreign key(doc_id)references doctor(id), constraint Ck_num check(num0),)Go go create trigger doc_time_add on doc_sick after insert as declare @doc_id char(8)@sick_id char(5)select @doc_id=doc_id from inserted i join doctor_wage dw on = update doctor_wage set operation_time=operation_time+1 where doc_id=@doc_idgo create trigger call_job_delete on call_job after delete as begin if exists(select *from deleted D join doctor doc on = where C_id not in(select distinct id from doctor))beginprint39。還有人使用這個(gè)職稱類型，刪除不成功！39。rollback transactionend elseprint3
語(yǔ)文相關(guān)推薦
鄂ICP備17016276號(hào)-1