CREATE TABLE patient 
	( patientID VARCHAR(18)
	CONSTRAINT pk_patient PRIMARY KEY,
	patient_name VARCHAR(24),
	patient_birth_date VARCHAR(24),
	patient_sex VARCHAR(2));

CREATE TABLE study
	( study_instanceUID VARCHAR(64)
	CONSTRAINT pk_study PRIMARY KEY,
	
	study_date VARCHAR(24),
	study_time VARCHAR(24),
	accession_number VARCHAR(24),
	study_ID VARCHAR(24),
	study_description VARCHAR(24));

CREATE TABLE series
	(
	series_instanceUID VARCHAR(64)
	CONSTRAINT pk_series PRIMARY KEY,
	modality VARCHAR(24),
	series_number VRACHAR(24));

CREATE TABLE image 
	(
	SOP_instaceUID VARCHAR(32)
	CONSTRAINT pk_image PRIMARY KEY,
	instace_number pk_image VARCHAR(24));



	