Mercurial > hg > orthanc
comparison OrthancServer/PrepareDatabase.sql @ 77:b8dfde8d64e8
new dicom tags
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 20 Sep 2012 13:41:18 +0200 |
parents | 4bc019d2f969 |
children | 6212bf978584 |
comparison
equal
deleted
inserted
replaced
76:e2d68529605f | 77:b8dfde8d64e8 |
---|---|
15 ); | 15 ); |
16 | 16 |
17 CREATE TABLE Series( | 17 CREATE TABLE Series( |
18 uuid TEXT PRIMARY KEY, | 18 uuid TEXT PRIMARY KEY, |
19 parentStudy TEXT REFERENCES Studies(uuid) ON DELETE CASCADE, | 19 parentStudy TEXT REFERENCES Studies(uuid) ON DELETE CASCADE, |
20 dicomSeries TEXT | 20 dicomSeries TEXT, |
21 numberOfInstances INTEGER | |
21 ); | 22 ); |
22 | 23 |
23 CREATE TABLE Instances( | 24 CREATE TABLE Instances( |
24 uuid TEXT PRIMARY KEY, | 25 uuid TEXT PRIMARY KEY, |
25 parentSeries TEXT REFERENCES Series(uuid) ON DELETE CASCADE, | 26 parentSeries TEXT REFERENCES Series(uuid) ON DELETE CASCADE, |
26 dicomInstance TEXT, | 27 dicomInstance TEXT, |
27 fileUuid TEXT, | 28 fileUuid TEXT, |
28 fileSize INTEGER, | 29 fileSize INTEGER, |
29 jsonUuid TEXT, | 30 jsonUuid TEXT, |
30 distantAet TEXT | 31 distantAet TEXT, |
32 instanceIndex INTEGER | |
31 ); | 33 ); |
32 | 34 |
33 CREATE TABLE MainDicomTags( | 35 CREATE TABLE MainDicomTags( |
34 uuid TEXT, | 36 uuid TEXT, |
35 tagGroup INTEGER, | 37 tagGroup INTEGER, |
53 CREATE INDEX DicomStudyIndex ON Studies(dicomStudy); | 55 CREATE INDEX DicomStudyIndex ON Studies(dicomStudy); |
54 CREATE INDEX DicomSeriesIndex ON Series(dicomSeries); | 56 CREATE INDEX DicomSeriesIndex ON Series(dicomSeries); |
55 CREATE INDEX DicomInstanceIndex ON Instances(dicomInstance); | 57 CREATE INDEX DicomInstanceIndex ON Instances(dicomInstance); |
56 | 58 |
57 CREATE INDEX MainDicomTagsIndex ON MainDicomTags(uuid); | 59 CREATE INDEX MainDicomTagsIndex ON MainDicomTags(uuid); |
60 CREATE INDEX MainDicomTagsGroupElement ON MainDicomTags(tagGroup, tagElement); | |
61 CREATE INDEX MainDicomTagsValues ON MainDicomTags(value COLLATE BINARY); | |
62 | |
58 CREATE INDEX ChangesIndex ON Changes(uuid); | 63 CREATE INDEX ChangesIndex ON Changes(uuid); |
59 | 64 |
60 CREATE TRIGGER InstanceRemoved | 65 CREATE TRIGGER InstanceRemoved |
61 AFTER DELETE ON Instances | 66 AFTER DELETE ON Instances |
62 FOR EACH ROW BEGIN | 67 FOR EACH ROW BEGIN |