1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
CREATE TABLE PatientLevel
(
PatNam char(64) not null,
PatID char(64) not null,
PatBirDat int not null,
PatBirTim real,
PatSex char(16) not null,
NumPatRelStu int not null,
NumPatRelSer int not null,
NumPatRelIma int not null,
InsertDate int not null,
InsertTime real not null,
Owner char(16),
GroupName char(16),
Priv char(9)
)
\g
CREATE UNIQUE INDEX idx1 ON PatientLevel(PatNam)
\g
CREATE TABLE StudyLevel
(
StuDat int not null,
StuTim real not null,
AccNum char(16) not null,
StuID char(16) not null,
StuInsUID char(64) not null,
RefPhyNam char(64) not null,
StuDes char(64),
PatAge char(4),
PatSiz char(16),
PatWei char(16),
NumStuRelSer int not null,
NumStuRelIma int not null,
InsertDate int not null,
InsertTime real not null,
Owner char(16),
GroupName char(16),
Priv char(9),
PatParent char(64) not null
)
\g
CREATE UNIQUE INDEX idx1 ON StudyLevel(StuInsUID)
\g
CREATE TABLE SeriesLevel
(
Mod char(16) not null,
SerNum char(12) not null,
SerInsUID char(64) not null,
ProNam char(64),
SerDes char(64),
BodParExa char(16),
ViePos char(16),
NumSerRelIma int not null,
InsertDate int not null,
InsertTime real not null,
Owner char(16),
GroupName char(16),
Priv char(9),
StuParent char(64) not null
)
\g
CREATE UNIQUE INDEX idx1 ON SeriesLevel(SerInsUID)
\g
CREATE TABLE ImageLevel
(
ImaNum char(12) not null,
SOPInsUID char(64) not null,
SOPClaUID char(64) not null,
SamPerPix int not null,
PhoInt char(16) not null,
Row int not null,
Col int not null,
BitAll int not null,
BitSto int not null,
PixRep int not null,
PatOri char(16),
InsertDate int not null,
InsertTime real not null,
Owner char(16),
GroupName char(16),
Priv char(9),
SerParent char(64) not null
)
\g
CREATE UNIQUE INDEX idx1 ON ImageLevel(SOPInsUID)
\g
CREATE TABLE InstanceTable
(
ImageUID char(64) not null,
RespondingTitle char(16) ,
Medium char(32),
Path char(255) not null,
Size int not null,
Transfer char(64) not null
)
\g
|
