+
−CREATE TABLE Resources(
+
−       internalId BIGSERIAL NOT NULL PRIMARY KEY,
+
−       resourceType INTEGER NOT NULL,
+
−       publicId VARCHAR(64) NOT NULL,
+
−       parentId BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE
+
−       );
+
−
+
−CREATE TABLE MainDicomTags(
+
−       id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE,
+
−       tagGroup INTEGER,
+
−       tagElement INTEGER,
+
−       value TEXT,
+
−       PRIMARY KEY(id, tagGroup, tagElement)
+
−       );
+
−
+
−CREATE TABLE DicomIdentifiers(
+
−       id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE,
+
−       tagGroup INTEGER,
+
−       tagElement INTEGER,
+
−       value TEXT,
+
−       PRIMARY KEY(id, tagGroup, tagElement)
+
−       );