Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 80:6212bf978584

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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,