数据库课程设计--健康档案管理系统

10)NULL,?[Ear][varchar](20)NULL,?[Nose][varchar](20)NULL,?[Throat][varchar](20)NULL,?[Mouth][varchar](20)NULL,?[Pulse][varchar](10)NULL,?[Heart][varchar](10)NULL,?[Hepatitis][nchar](16)NULL,?[Lung][varchar](10)NULL,?[Spleen][varchar](10)NULL,?[Tonsil][varchar](20)NULL,?[Surgical][varchar](20)NULL,?[Chest][varchar](20)NULL,?[Others][varchar](max)NULL,?[Date][smalldatetime]NULL,?[DoctorName][varchar](20)NULL,CONSTRAINT[PK_Exam]PRIMARYKEYCLUSTERED(?[Id]ASC)WITH(PAD_INDEX=OFF,PUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GOSETANSI_PADDINGOFFGOALTERTABLE[dbo].[Exam]WITHCHECKADDCONSTRAINT[FK_Exam_Student]FOREIGNKEY([StudentNumber])REFERENCES[dbo].[Student]([StudentNumber])GOALTERTABLE[dbo].[Exam]CHECKCONSTRAINT[FK_Exam_Student]8.1.2创建病历表[dbo].[History]