医院查询.txt

实施医院管理系统

医院 ：
1。HospitalID    医院编号
2。Name	         医院名//
3。GradeID        医院级别号 //     （字典）
4。ProvinceID   所在省份号       （字典）
5。CityID              所在城市号
6。Address      详细地址//
7。Traffic         交通方式

医生：
1。DoctorID             医生编号
2。Name                  医生名称//
3。SexID                  医生性别号    （字典）
4。Old                     医生年龄
5。ProfessID           职称号   //          （字典）
6。BelongOffID       所属科室号  //     （字典）
7。Specialty            专长 //
8。BelongID            所在医院号        
9。DocTime	              门诊时间 //
10。TelphonNum   电话号码 //

症状：
1。ID                      症状号
2。SymptomName          症状名
3。BelongOffID     所属科室号     （字典）


城市：
1。CityID             城市号
2。ProvinceID     所属省号  
3。CityName       城市名   //


字典：
1。 ID                      字典号
2。Category           所属目
3。Detail                细节
4。Enable             









SELECT Hospitall.HospitalID, Hospitall.Name AS HospitalName, Hospitall.GradeID, 
      Hospitall.ProvinceID, Hospitall.CityID, Hospitall.Address, Hospitall.Traffic, 
      Dictionary_2.Detail AS Grade, Dictionary_1.Detail AS ProvinceName, City.CityName, 
      Doctor.DoctorID, Doctor.Name, Doctor.SexID, Dictionary_2.Detail AS Sex, Doctor.Old, 
      Doctor.ProfessID, Dictionary_3.Detail AS Profess, Doctor.BelongOffID, 
      Dictionary_4.Detail AS BelongOffice, Doctor.Specialty, Doctor.BelongID, 
      Doctor.DocTime, Doctor.TelphonNum, Symptom.SymptomName, 
      Symptom.BelongOffID AS OfficeID, Dictionary_5.Detail AS OfficeName
FROM Doctor INNER JOIN
      Dictionary Dictionary_2 ON Doctor.SexID = Dictionary_2.ID INNER JOIN
      Dictionary Dictionary_3 ON Doctor.ProfessID = Dictionary_3.ID INNER JOIN
      Dictionary Dictionary_4 ON Doctor.BelongOffID = Dictionary_4.ID INNER JOIN
      Hospitall INNER JOIN
      Dictionary Dictionary_6 ON Hospitall.GradeID = Dictionary_6.ID INNER JOIN
      Dictionary Dictionary_1 ON Hospitall.ProvinceID = Dictionary_1.ID INNER JOIN
      City ON Hospitall.CityID = City.CityID ON 
      Doctor.BelongID = Hospitall.HospitalID INNER JOIN
      Symptom ON Doctor.BelongOffID = Symptom.BelongOffID INNER JOIN
      Dictionary Dictionary_5 ON Symptom.BelongOffID = Dictionary_5.ID