3-AnnetPACS数据库设计说明.doc下载

[weixin_39821746]

Annet PACS 医学影像管理系统 数据库(顶层)设计说明 Shenzhen Annet Information System Co. Ltd 目录 1引言 4 1.1标识 4 1.2数据库概述 4 1.3文档概述 4 2引用文件 4 3数据库级设计决策 5 4数据库详细设计 6 4.1 表Patient 6 4.2 表Study 6 4.3 表Image 9 4.4 表Series 10 4.5 表BookingTable 10 4.6 表filmmanage 12 4.7 表Ann 13 4.8 表DeptTable 13 4.9 表DoctorTable 14 4.10 表MethodTable 14 4.11 表PartTable 14 4.12 表MethodTable 15 4.13 表illness 15 4.14 表LabelWord 15 4.15 表Log 15 4.16 表PseudoColor 16 4.17 表Sentence 16 4.18 表Template 16 4.19 表TipImage 17 4.20 表Volume_R 17 4.21 表WinMod 18 4.22 表SysDict 18 4.23 表TeachManage 18 4.24 表Dosage 19 4.25 表Film 19 4.26 表FilmSource 19 4.27 表FilmStandard 20 4.28 表Medicine 20 4.29 表HisFeeTable 20 4.30 表HisFeeRecordTable 20 4.31 表LayerDirection 21 4.32 表LayerDistance 21 4.33 表Sequence 22 4.34 表Radiology_Ann 22 4.35 表Remote 22 4.36 表RExpense 23 1引言 1.1标识 ANNET PACS系统数据库设计说明v2.6.7，适用于Annet PACSV2.0及以下版本。 1.2数据库概述 本数据库设计数据表结构适应于Annet PACS V2.0及以下版本。适用于全院PACS系统，包含影像科室、临床发放等。 1.3文档概述 本文档属于内部机密文档，仅流通于产品研发部。未经允许，不得向第三方提供。 2引用文件 无。 3数据库级设计决策 Annet PACS数据库系统数据按照功能及性能分为：主表、公用表、RIS专用表、数字胶片室专用 表、放射专用表、超声专用表、远程专用表等。数据库表间关系如下图： 4数据库详细设计 4.1 表Patient "编号"字段名称 "字段类 "字段"字段限制 "字段说明 " " " "型 " " " " "1 "PatientID "nvarcha"20 "主键，不允许为空 "病人ID号 " " " "r " " " " "2 "HISID "nvarcha"20 " "HIS系统ID " " " "r " " " " "3 "Name "nvarcha"50 " "病人姓名 " " " "r " " " " "4 "ENNAME "nvarcha"50 " "病人姓名缩 " " " "r " " "写 " "5 "Birthday "datetim"8 " "病人生日 " " " "e " " " " "6 "Sex "nvarcha"6 "'M'/'F'/'O'/'m'/'"病人性别 " " " "r " "f'/'o' " " "7 "BloodType "nvarcha"20 " "病人血型 " " " "r " " " " "8 "Country "nvarcha"50 " "病人国籍 " " " "r " " " " "9 "Nation "nvarcha"20 " "民族 " " " "r " " " " "10 "Native "nvarcha"50 " "籍贯 " " " "r " " " " "11 "InsuranceID "nvarcha"40 " "身份证号 " " " "r " " " " "12 "OtherID "nvarcha"20 " "其它号 " " " "r " " " " "13 "OtherName "nvarcha"20 " "曾用名 " " " "r " " " " "14 "Address "nvarcha"50 " "住址 " " " "r " " " " "15 "Postcode "nvarcha"10 " "邮编 " " " "r " " " " "16 "TelNo "nvarcha"20 " "电话 " " " "r " " " " "17 "Comment "text "16 " "备注 " "18 "Del , 相关下载链接：https://download.csdn.net/download/qq_43966957/87371963?utm_source=bbsseo