{@" CREATE TABLE DAAssayResult
                                        (
                                           ClinicID         VARCHAR2 (64),
                                           ClinicName       VARCHAR2 (64),
                                           SampleTo         VARCHAR2 (64),
                                           AssayBarcode     VARCHAR2 (64) NOT NULL,
                                           SampleType       VARCHAR2 (32),
                                           PatientName      VARCHAR2 (32),
                                           PSex             VARCHAR2 (8),
                                           PAge             VARCHAR2 (8),
                                           PAgeUnit         VARCHAR2 (8),
                                           PIDCard          VARCHAR2 (64),
                                           PPhoneNumber     VARCHAR2 (64),
                                           PPatientCode     VARCHAR2 (64),
                                           CollectDate      DATE,
                                           CollectEmp       VARCHAR2 (32),
                                           AssayDate        DATE,
                                           AssayEmp         VARCHAR2 (32),
                                           AuditDate        DATE,
                                           AuditEmp         VARCHAR2 (32),
                                           ReAuditDate      DATE,
                                           ReAuditEmp       VARCHAR2 (32),
                                           AssayItemID      VARCHAR2 (64),
                                           AssaySCode       VARCHAR2 (32) NOT NULL,
                                           AnalyteCode      VARCHAR2 (64),
                                           AssayResult      VARCHAR2 (128),
                                           AssayReference   VARCHAR2 (512),
                                           ReferenceLower   VARCHAR2 (32),
                                           ReferenceHigh    VARCHAR2 (32),
                                           Units            VARCHAR2 (32),
                                           ResultFlag       VARCHAR2 (8),
                                           RangeFlag        VARCHAR2 (8),
                                           ClientName       VARCHAR2 (128),
                                           UploadTime       DATE
                                        )"
                                       ,@"COMMENT ON TABLE DAAssayResult IS '迪安检验结果表'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ClinicID IS '对接码'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.SampleTo IS '检测单位'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AssayBarcode IS '检测单位条码'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ClinicName IS '开单科室'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.SampleType IS '标本类型'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.PatientName IS '病人姓名'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.PSex IS '病人性别'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.PAge IS '病人年龄'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.PAgeUnit IS '年龄单位'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.PIDCard IS '身份证号码'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.PPhoneNumber IS '联系方式'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.PPatientCode IS '病人编码'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.CollectDate IS '采集时间'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.CollectEmp IS '采集人员'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AssayDate IS '检验日期'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AssayEmp IS '检验人员'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AuditDate IS '审核时间'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AuditEmp IS '审核人员'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ReAuditDate IS '复审核时间'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ReAuditEmp IS '复审核人员'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AssayItemID IS '检验项目编码(转换后)'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AssaySCode IS '检验单位项目标志'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AnalyteCode IS '检验单位项目代码'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AssayResult IS '结果'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.AssayReference IS '参考范围'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ReferenceLower IS '参考低值'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ReferenceHigh IS '参考高值'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.Units IS '单位'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.RangeFlag IS '危急值标记'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ResultFlag IS '异常标记'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.ClientName IS '客户名称'"
                                       ,@"COMMENT ON COLUMN DAAssayResult.UploadTime IS '上传时间'"
                                       ,@"ALTER TABLE DAAssayResult ADD (
                                          CONSTRAINT DAAssayResult_PK
                                          PRIMARY KEY
                                          (AssayBarcode, AssaySCode) )"};