 UPDATE read_domain
 SET domain_id = 'Measurement'
 WHERE domain_id = 'Measurement/Meas Value';
+
+UPDATE read_domain
+SET domain_id = 'Condition'
+WHERE domain_id = 'Condition/Measurement/Spec Disease Status';
+
+UPDATE read_domain
+SET domain_id = 'Condition'
+WHERE domain_id = 'Condition/Spec Disease Status';
+
+UPDATE read_domain
+SET domain_id = 'Measurement'
+WHERE domain_id = 'Measurement/Spec Disease Status';
+
+UPDATE read_domain
+SET domain_id = 'Condition'
+WHERE domain_id = 'Condition/Race';
+
+UPDATE read_domain
+SET domain_id = 'Procedure'
+WHERE domain_id = 'Procedure/Visit';
 
 -- Check that all domain_id are exists in domain table
 ALTER TABLE read_domain ADD CONSTRAINT fk_read_domain FOREIGN KEY (domain_id) REFERENCES domain (domain_id);

				AND r.vocabulary_id_2 = c2.vocabulary_id
				AND c2.vocabulary_id IN (
					'SNOMED',
					'OMOP Extension',
					'Race'
					)
			) r1 ON r1.concept_code_1 = c1.concept_code
			AND r1.vocabulary_id_1 = c1.vocabulary_id

					AND r.vocabulary_id_2 IN (
						'SNOMED',
						'OMOP Extension',
						'Race',
					    'CVX',
			            'Gender',
					    'Medicare Specialty',
				        'NUCC',
					    'Type Concept',
					    'Visit'
						)
					AND r.invalid_reason IS NULL
				)
