Lorensen: moved Lorensen's strawman sqlite DICOM schema to Slicer3/strawman DICOM Schema

2010-03-09T18:27:17Z

moved Lorensen's strawman sqlite DICOM schema to Slicer3/strawman DICOM Schema

Lorensen: Created page with '

 DROP TABLE IF EXISTS main.Patient ; CREATE  TABLE IF NOT EXISTS main.Patient (   `idPatient` INTEGER,   `Name` VARCHAR(45) NULL ,   `ID` VARCHAR(50) NULL ,   `Birth Date` D…'

2010-03-09T18:25:20Z

Created page with '<pre> DROP TABLE IF EXISTS main.Patient ; CREATE TABLE IF NOT EXISTS main.Patient ( `idPatient` INTEGER, `Name` VARCHAR(45) NULL , `ID` VARCHAR(50) NULL , `Birth Date` D…'

New page

<pre>
DROP TABLE IF EXISTS main.Patient ;
CREATE TABLE IF NOT EXISTS main.Patient (
`idPatient` INTEGER,
`Name` VARCHAR(45) NULL ,
`ID` VARCHAR(50) NULL ,
`Birth Date` DATE NULL ,
`Sex` VARCHAR(1) DEFAULT 'X' ,
PRIMARY KEY (`idPatient`),
UNIQUE (Name,ID)
);

DROP TABLE IF EXISTS main.`Study` ;
CREATE TABLE IF NOT EXISTS main.`Study` (
`idStudy` INTEGER ,
`UID` VARCHAR(64) NOT NULL ,
`ID` VARCHAR(32) NULL ,
`Description` VARCHAR(45) NULL,
`Date` DATE NULL ,
`Time` TIME NULL ,
`Modality` VARCHAR(45) NULL ,
`Manufacturer` VARCHAR(45) NULL ,
`Institution Name` VARCHAR(45) NULL ,
`Referring Physician` VARCHAR(45) NULL ,
`Patient_idPatient` INT,
FOREIGN KEY (Patient_idPatient) REFERENCES Patient(idPatient)
PRIMARY KEY (`idStudy`),
UNIQUE (UID))
;

DROP TABLE IF EXISTS main.`Series` ;
CREATE TABLE IF NOT EXISTS main.`Series` (
`idSeries` INTEGER ,
`UID` VARCHAR(64) NOT NULL ,
`ID` VARCHAR(32) NULL ,
`Description` VARCHAR(45) NULL ,
`Image Type` VARCHAR(45) NULL ,
`Date` DATE NULL ,
`Time` TIME NULL ,
`Study_idStudy` INT NOT NULL ,
FOREIGN KEY (`Study_idStudy` ) REFERENCES `Study` (`idStudy` )
PRIMARY KEY (`idSeries`),
UNIQUE (UID))
;
DROP TABLE IF EXISTS main.`Image` ;

CREATE TABLE IF NOT EXISTS main.`Image` (
`idImage` INTEGER ,
`UID` VARCHAR(64) NOT NULL ,
`Number` INT NULL ,
`Image Position Patient` VARCHAR(64) NULL ,
`Pixel Offset` INT NULL ,
`Slice Location` FLOAT NULL ,
`FileName` VARCHAR(4096) NULL ,
`Series_idSeries` INT NOT NULL ,
FOREIGN KEY (`Series_idSeries` ) REFERENCES `Series` (`idSeries` )
PRIMARY KEY (`idImage`),
UNIQUE (UID))
;
</pre>

Slicer3/strawman DICOM Schema - Revision history

Lorensen: moved Lorensen's strawman sqlite DICOM schema to Slicer3/strawman DICOM Schema

Lorensen: Created page with '
DROP TABLE IF EXISTS main.Patient ; CREATE TABLE IF NOT EXISTS main.Patient ( `idPatient` INTEGER, `Name` VARCHAR(45) NULL , `ID` VARCHAR(50) NULL , `Birth Date` D…'

← Older revision	Revision as of 18:27, 9 March 2010
(No difference)