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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
|
CREATE TABLE PatientTable
(
PatID char(16) not null,
PatNam char(64) not null,
PatUID char(64) not null,
PatBirDat int not null,
PatSex char(16) not null
)
\g
ALTER TABLE PatientTable ADD UNIQUE P_PatUID_index (PatUID)
\g
ALTER TABLE PatientTable ADD INDEX P_PatID_index (PatID)
\g
CREATE TABLE StudyTable (
PatUID char(64) not null,
StuInsUID char(64) not null,
VisUID char(64) not null,
AccNum char(16) not null,
StuID char(16) not null,
SchStuStaDat int,
SchStuStaTim real,
SchStuLoc char(64),
ProDes char(64),
ReqPro char(16),
StuStaID char(16),
StuReaDat int,
StuReaTim real
)
\g
ALTER TABLE StudyTable ADD UNIQUE S_StuInsUID_index (StuInsUID)
\g
CREATE TABLE ResultsTable (
ResUID char(64) not null,
StuInsUID char(64) not null,
ResID char(16) not null,
Imp text,
InsCreDat char(8),
InsCreTim char(16),
InsCreUID char(64)
)
\g
ALTER TABLE ResultsTable ADD UNIQUE R_ResUID_index (ResUID)
\g
CREATE TABLE InterpretationTable (
IntUID char(64) not null,
ResUID char(64) not null,
IntID char(16),
IntTex text,
IntTypID char(16) not null,
IntStaID char(16) not null,
IntDiaDes text,
InsCreDat char(8),
InsCreTim char(16),
InsCreUID char(64),
PhyAppInt char(64),
IntAppDat char(8),
IntAppTim char(16)
)
\g
ALTER TABLE InterpretationTable ADD UNIQUE I_IntUID_index (IntUID)
\g
CREATE TABLE StudyCmpTable (
StuComUID char(64) not null,
StuInsUID char(64) not null,
Modality char(16) not null,
ProCodVal char(16),
ProCodSchDes char(16),
ProCodMea char(64),
StuDes char(64),
StuComStaID char(16),
StuID char(16)
)
\g
ALTER TABLE StudyCmpTable ADD UNIQUE SC_StuComUID_index (StuComUID)
\g
CREATE TABLE StudyCmpSeriesTable (
SerInsUID char (64) not null,
StuComUID char (64) not null,
SerDat char (8),
SerTim char (16),
RetAETit char (16),
StoMedFilSetID char (16),
StoMedFilSetUID char (64)
)
\g
ALTER TABLE StudyCmpSeriesTable ADD UNIQUE SCSeries_SerInsUID_index (SerInsUID)
\g
CREATE TABLE StudyCmpImageTable (
SOPInsUID char (64) not null,
SOPClaUID char (64) not null,
SerInsUID char (64) not null,
StuComUID char (64) not null,
RetAETit char (16),
StoMedFilSetID char (16),
StoMedFilSetUID char (64)
)
\g
ALTER TABLE StudyCmpImageTable ADD UNIQUE SCImage_SOPInsUID_index (SOPInsUID)
\g
CREATE TABLE UniqueNumbers (
NumberName char(23) not null,
UniqueNumber int not null
)
\g
CREATE TABLE StorageCommitReq (
TraUID char(64) not null,
ReqAE char(16) not null,
ResAE char(16),
ReqDat int not null,
ReqTim real not null,
ResDat int,
ResTim real
)
\g
ALTER TABLE StorageCommitReq ADD UNIQUE SCReq_TraUID_index (TraUID)
\g
CREATE TABLE CommitSOPRef (
TraUID char(64) not null,
SOPClaUID char(64) not null,
SOPInsUID char(64) not null
)
\g
CREATE TABLE WorkQueue(
TasNam char(100) not null,
TasID char(100) not null
)
\g
DELETE FROM UniqueNumbers
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('PatientID', 1000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('AccessionNumber', 2000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('StudyID', 3000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('ResultsID', 4000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('InterpretationID', 5000000)
\g
|
