Mercurial > hg > orthanc
comparison OrthancServer/PrepareDatabase.sql @ 80:6212bf978584
status of series
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 20 Sep 2012 15:18:12 +0200 |
parents | b8dfde8d64e8 |
children | 9eb40cad7935 |
comparison
equal
deleted
inserted
replaced
79:297bad4e1019 | 80:6212bf978584 |
---|---|
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 expectedNumberOfInstances INTEGER |
22 ); | 22 ); |
23 | 23 |
24 CREATE TABLE Instances( | 24 CREATE TABLE Instances( |
25 uuid TEXT PRIMARY KEY, | 25 uuid TEXT PRIMARY KEY, |
26 parentSeries TEXT REFERENCES Series(uuid) ON DELETE CASCADE, | 26 parentSeries TEXT REFERENCES Series(uuid) ON DELETE CASCADE, |
27 dicomInstance TEXT, | 27 dicomInstance TEXT, |
28 fileUuid TEXT, | 28 fileUuid TEXT, |
29 fileSize INTEGER, | 29 fileSize INTEGER, |
30 jsonUuid TEXT, | 30 jsonUuid TEXT, |
31 distantAet TEXT, | 31 distantAet TEXT, |
32 instanceIndex INTEGER | 32 indexInSeries INTEGER |
33 ); | 33 ); |
34 | 34 |
35 CREATE TABLE MainDicomTags( | 35 CREATE TABLE MainDicomTags( |
36 uuid TEXT, | 36 uuid TEXT, |
37 tagGroup INTEGER, | 37 tagGroup INTEGER, |