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
|
CREATE TABLE PatientTable
(
PatID char(16) primary key,
PatNam char(64) not null,
PatUID char(64) not null,
PatBirDat int not null,
PatSex char(16) not null
)
\g
CREATE TABLE StudyTable (
PatUID char(64) not null,
StuInsUID char(64) primary key,
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
CREATE TABLE ResultsTable (
ResUID char(64) primary key,
StuInsUID char(64) not null,
ResID char(16) not null,
Imp char(1024),
InsCreDat char(8),
InsCreTim char(16),
InsCreUID char(64)
)
\g
CREATE TABLE InterpretationTable (
IntUID char(64) primary key,
ResUID char(64) not null,
IntID char(16),
IntTex char(1024),
IntTypID char(16) not null,
IntStaID char(16) not null,
IntDiaDes char(10240),
InsCreDat char(8),
InsCreTim char(16),
InsCreUID char(64),
PhyAppInt char(64),
IntAppDat char(8),
IntAppTim char(16)
)
\g
CREATE TABLE StudyCmpTable (
StuComUID char(64) primary key,
StuInsUID char(64) not null,
Mod char(16) not null,
ProCodVal char(16),
ProCodSchDes char(16),
ProCodMea char(64),
StuDes char(64),
StuComStaID char(16),
StuID char(16)
)
\g
CREATE TABLE StudyCmpSeriesTable (
SerInsUID char (64) primary key,
StuComUID char (64) not null,
SerDat char (8),
SerTim char (16),
RetAETit char (16),
StoMedFilSetID char (16),
StoMedFilSetUID char (64)
)
\g
CREATE TABLE StudyCmpImageTable (
SOPInsUID char (64) primary key,
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
CREATE TABLE UniqueNumbers (
NumberName char(23) not null,
UniqueNumber int not null
)
\g
CREATE TABLE StorageCommitReq (
TraUID char(64) primary key,
ReqAE char(16) not null,
ResAE char(16),
ReqDat int not null,
ReqTim real not null,
ResDat int,
ResTim real
)
\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
|
