-- Name: arc_project_pipeline_meta_data arc_project_pipeline_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_project_pipeline_meta_data
    ADD CONSTRAINT arc_project_pipeline_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: arc_project_pipeline arc_project_pipeline_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_project_pipeline
    ADD CONSTRAINT arc_project_pipeline_pkey PRIMARY KEY (arc_pipelinedata_id);


--
-- Name: arc_project arc_project_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_project
    ADD CONSTRAINT arc_project_pkey PRIMARY KEY (arc_project_id);


--
-- Name: arc_project arc_project_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_project
    ADD CONSTRAINT arc_project_u_1 UNIQUE (id);


--
-- Name: arc_property_history arc_property_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_property_history
    ADD CONSTRAINT arc_property_history_pkey PRIMARY KEY (history_id);


--
-- Name: arc_property_meta_data arc_property_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_property_meta_data
    ADD CONSTRAINT arc_property_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: arc_property arc_property_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_property
    ADD CONSTRAINT arc_property_pkey PRIMARY KEY (arc_property_id);


--
-- Name: arc_property arc_property_u_prop_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.arc_property
    ADD CONSTRAINT arc_property_u_prop_name UNIQUE (name, properties_property_arc_project_arc_project_id);


--
-- Name: cat_catalog_history cat_catalog_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_history
    ADD CONSTRAINT cat_catalog_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_catalog_meta_data cat_catalog_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_meta_data
    ADD CONSTRAINT cat_catalog_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_catalog_metafield_history cat_catalog_metafield_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_metafield_history
    ADD CONSTRAINT cat_catalog_metafield_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_catalog_metafield_meta_data cat_catalog_metafield_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_metafield_meta_data
    ADD CONSTRAINT cat_catalog_metafield_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_catalog_metafield cat_catalog_metafield_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_metafield
    ADD CONSTRAINT cat_catalog_metafield_pkey PRIMARY KEY (cat_catalog_metafield_id);


--
-- Name: cat_catalog cat_catalog_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog
    ADD CONSTRAINT cat_catalog_pkey PRIMARY KEY (cat_catalog_id);


--
-- Name: cat_catalog_tag_history cat_catalog_tag_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_tag_history
    ADD CONSTRAINT cat_catalog_tag_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_catalog_tag_meta_data cat_catalog_tag_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_tag_meta_data
    ADD CONSTRAINT cat_catalog_tag_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_catalog_tag cat_catalog_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_catalog_tag
    ADD CONSTRAINT cat_catalog_tag_pkey PRIMARY KEY (cat_catalog_tag_id);


--
-- Name: cat_dcmcatalog_history cat_dcmcatalog_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_dcmcatalog_history
    ADD CONSTRAINT cat_dcmcatalog_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_dcmcatalog_meta_data cat_dcmcatalog_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_dcmcatalog_meta_data
    ADD CONSTRAINT cat_dcmcatalog_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_dcmcatalog cat_dcmcatalog_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_dcmcatalog
    ADD CONSTRAINT cat_dcmcatalog_pkey PRIMARY KEY (cat_catalog_id);


--
-- Name: cat_dcmentry_history cat_dcmentry_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_dcmentry_history
    ADD CONSTRAINT cat_dcmentry_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_dcmentry_meta_data cat_dcmentry_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_dcmentry_meta_data
    ADD CONSTRAINT cat_dcmentry_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_dcmentry cat_dcmentry_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_dcmentry
    ADD CONSTRAINT cat_dcmentry_pkey PRIMARY KEY (cat_entry_id);


--
-- Name: cat_entry_history cat_entry_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_history
    ADD CONSTRAINT cat_entry_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_entry_meta_data cat_entry_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_meta_data
    ADD CONSTRAINT cat_entry_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_entry_metafield_history cat_entry_metafield_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_metafield_history
    ADD CONSTRAINT cat_entry_metafield_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_entry_metafield_meta_data cat_entry_metafield_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_metafield_meta_data
    ADD CONSTRAINT cat_entry_metafield_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_entry_metafield cat_entry_metafield_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_metafield
    ADD CONSTRAINT cat_entry_metafield_pkey PRIMARY KEY (cat_entry_metafield_id);


--
-- Name: cat_entry cat_entry_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry
    ADD CONSTRAINT cat_entry_pkey PRIMARY KEY (cat_entry_id);


--
-- Name: cat_entry_tag_history cat_entry_tag_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_tag_history
    ADD CONSTRAINT cat_entry_tag_history_pkey PRIMARY KEY (history_id);


--
-- Name: cat_entry_tag_meta_data cat_entry_tag_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_tag_meta_data
    ADD CONSTRAINT cat_entry_tag_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: cat_entry_tag cat_entry_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.cat_entry_tag
    ADD CONSTRAINT cat_entry_tag_pkey PRIMARY KEY (cat_entry_tag_id);


--
-- Name: img_assessor_in_resource_history img_assessor_in_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.img_assessor_in_resource_history
    ADD CONSTRAINT img_assessor_in_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: img_assessor_in_resource img_assessor_in_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.img_assessor_in_resource
    ADD CONSTRAINT img_assessor_in_resource_pkey PRIMARY KEY (img_assessor_in_resource_id);


--
-- Name: img_assessor_out_resource_history img_assessor_out_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.img_assessor_out_resource_history
    ADD CONSTRAINT img_assessor_out_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: img_assessor_out_resource img_assessor_out_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.img_assessor_out_resource
    ADD CONSTRAINT img_assessor_out_resource_pkey PRIMARY KEY (img_assessor_out_resource_id);


--
-- Name: pipe_pipelinedetails_element_history pipe_pipelinedetails_element_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_element_history
    ADD CONSTRAINT pipe_pipelinedetails_element_history_pkey PRIMARY KEY (history_id);


--
-- Name: pipe_pipelinedetails_element_meta_data pipe_pipelinedetails_element_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_element_meta_data
    ADD CONSTRAINT pipe_pipelinedetails_element_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: pipe_pipelinedetails_element pipe_pipelinedetails_element_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_element
    ADD CONSTRAINT pipe_pipelinedetails_element_pkey PRIMARY KEY (pipe_pipelinedetails_element_id);


--
-- Name: pipe_pipelinedetails_history pipe_pipelinedetails_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_history
    ADD CONSTRAINT pipe_pipelinedetails_history_pkey PRIMARY KEY (history_id);


--
-- Name: pipe_pipelinedetails_meta_data pipe_pipelinedetails_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_meta_data
    ADD CONSTRAINT pipe_pipelinedetails_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: pipe_pipelinedetails_parameter_history pipe_pipelinedetails_parameter_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_parameter_history
    ADD CONSTRAINT pipe_pipelinedetails_parameter_history_pkey PRIMARY KEY (history_id);


--
-- Name: pipe_pipelinedetails_parameter_meta_data pipe_pipelinedetails_parameter_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_parameter_meta_data
    ADD CONSTRAINT pipe_pipelinedetails_parameter_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: pipe_pipelinedetails_parameter pipe_pipelinedetails_parameter_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails_parameter
    ADD CONSTRAINT pipe_pipelinedetails_parameter_pkey PRIMARY KEY (pipe_pipelinedetails_parameter_id);


--
-- Name: pipe_pipelinedetails pipe_pipelinedetails_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinedetails
    ADD CONSTRAINT pipe_pipelinedetails_pkey PRIMARY KEY (path);


--
-- Name: pipe_pipelinerepository_history pipe_pipelinerepository_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinerepository_history
    ADD CONSTRAINT pipe_pipelinerepository_history_pkey PRIMARY KEY (history_id);


--
-- Name: pipe_pipelinerepository_meta_data pipe_pipelinerepository_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinerepository_meta_data
    ADD CONSTRAINT pipe_pipelinerepository_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: pipe_pipelinerepository pipe_pipelinerepository_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.pipe_pipelinerepository
    ADD CONSTRAINT pipe_pipelinerepository_pkey PRIMARY KEY (pipe_pipelinerepository_id);


--
-- Name: prov_process_history prov_process_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_process_history
    ADD CONSTRAINT prov_process_history_pkey PRIMARY KEY (history_id);


--
-- Name: prov_process_meta_data prov_process_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_process_meta_data
    ADD CONSTRAINT prov_process_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: prov_process prov_process_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_process
    ADD CONSTRAINT prov_process_pkey PRIMARY KEY (prov_process_id);


--
-- Name: prov_processstep_history prov_processstep_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_processstep_history
    ADD CONSTRAINT prov_processstep_history_pkey PRIMARY KEY (history_id);


--
-- Name: prov_processstep_library_history prov_processstep_library_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_processstep_library_history
    ADD CONSTRAINT prov_processstep_library_history_pkey PRIMARY KEY (history_id);


--
-- Name: prov_processstep_library_meta_data prov_processstep_library_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_processstep_library_meta_data
    ADD CONSTRAINT prov_processstep_library_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: prov_processstep_library prov_processstep_library_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_processstep_library
    ADD CONSTRAINT prov_processstep_library_pkey PRIMARY KEY (prov_processstep_library_id);


--
-- Name: prov_processstep_meta_data prov_processstep_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_processstep_meta_data
    ADD CONSTRAINT prov_processstep_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: prov_processstep prov_processstep_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_processstep
    ADD CONSTRAINT prov_processstep_pkey PRIMARY KEY (prov_processstep_id);


--
-- Name: prov_processstep prov_processstep_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.prov_processstep
    ADD CONSTRAINT prov_processstep_u_true UNIQUE (program, "timestamp", prov_process_prov_process_id);


--
-- Name: recon_in_resource_history recon_in_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.recon_in_resource_history
    ADD CONSTRAINT recon_in_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: recon_in_resource recon_in_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.recon_in_resource
    ADD CONSTRAINT recon_in_resource_pkey PRIMARY KEY (recon_in_resource_id);


--
-- Name: recon_out_resource_history recon_out_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.recon_out_resource_history
    ADD CONSTRAINT recon_out_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: recon_out_resource recon_out_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.recon_out_resource
    ADD CONSTRAINT recon_out_resource_pkey PRIMARY KEY (recon_out_resource_id);


--
-- Name: scr_screeningassessment_history scr_screeningassessment_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.scr_screeningassessment_history
    ADD CONSTRAINT scr_screeningassessment_history_pkey PRIMARY KEY (history_id);


--
-- Name: scr_screeningassessment_meta_data scr_screeningassessment_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.scr_screeningassessment_meta_data
    ADD CONSTRAINT scr_screeningassessment_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: scr_screeningassessment scr_screeningassessment_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.scr_screeningassessment
    ADD CONSTRAINT scr_screeningassessment_pkey PRIMARY KEY (id);


--
-- Name: scr_screeningscandata_history scr_screeningscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.scr_screeningscandata_history
    ADD CONSTRAINT scr_screeningscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: scr_screeningscandata_meta_data scr_screeningscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.scr_screeningscandata_meta_data
    ADD CONSTRAINT scr_screeningscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: scr_screeningscandata scr_screeningscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.scr_screeningscandata
    ADD CONSTRAINT scr_screeningscandata_pkey PRIMARY KEY (scr_screeningscandata_id);


--
-- Name: scr_screeningscandata scr_screeningscandata_u_scr_scan_id_fk; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.scr_screeningscandata
    ADD CONSTRAINT scr_screeningscandata_u_scr_scan_id_fk UNIQUE (imagescan_id, scans_scan_scr_screeningassessm_id);


--
-- Name: xhbm_automation_event_ids uk_1gch55t7dfb4ifryhdwat15uy; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_automation_event_ids
    ADD CONSTRAINT uk_1gch55t7dfb4ifryhdwat15uy UNIQUE (external_id, src_event_class);


--
-- Name: xhbm_xdat_user_auth uk_2i284rpisd88f114bask3pt5g; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xdat_user_auth
    ADD CONSTRAINT uk_2i284rpisd88f114bask3pt5g UNIQUE (auth_user, auth_method_id);


--
-- Name: xhbm_tool uk_5p77s7ss9l8pbqdy16pj0i3i7; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_tool
    ADD CONSTRAINT uk_5p77s7ss9l8pbqdy16pj0i3i7 UNIQUE (tool_name);


--
-- Name: xhbm_xft_field_exclusion uk_9voob0ga1c2geip73p696no7n; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xft_field_exclusion
    ADD CONSTRAINT uk_9voob0ga1c2geip73p696no7n UNIQUE (scope, target_id, pattern);


--
-- Name: xhbm_data_cache_item uk_acf04xuaofxr1yd05g1jc5fy3; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_data_cache_item
    ADD CONSTRAINT uk_acf04xuaofxr1yd05g1jc5fy3 UNIQUE (key);


--
-- Name: xhbm_script uk_axamxg24fytqk6ob5n26qvsbi; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script
    ADD CONSTRAINT uk_axamxg24fytqk6ob5n26qvsbi UNIQUE (script_id, disabled);


--
-- Name: xhbm_group_feature uk_b645qeaw6k1nhhwugnmwufxtd; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_group_feature
    ADD CONSTRAINT uk_b645qeaw6k1nhhwugnmwufxtd UNIQUE (feature, group_id, disabled);


--
-- Name: xhbm_script_trigger_template uk_bhnmy1f1fw629ooxumyh26vkb; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script_trigger_template
    ADD CONSTRAINT uk_bhnmy1f1fw629ooxumyh26vkb UNIQUE (template_id, disabled);


--
-- Name: xhbm_alias_token uk_cww07clrguh0stjda3naaq0ho; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_alias_token
    ADD CONSTRAINT uk_cww07clrguh0stjda3naaq0ho UNIQUE (alias);


--
-- Name: xhbm_category uk_erqeifrqno8mbctp99vepwnc9; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_category
    ADD CONSTRAINT uk_erqeifrqno8mbctp99vepwnc9 UNIQUE (scope, event, enabled, disabled);


--
-- Name: xhbm_user_change_request uk_g4vgq3vkk1yo5u57puudpdhrw; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_user_change_request
    ADD CONSTRAINT uk_g4vgq3vkk1yo5u57puudpdhrw UNIQUE (username, field_to_change, disabled);


--
-- Name: xhbm_channel uk_gu7ds1lqdysgjr92ko6smsr0w; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_channel
    ADD CONSTRAINT uk_gu7ds1lqdysgjr92ko6smsr0w UNIQUE (name);


--
-- Name: xhbm_host_info uk_jyijfo8n7i5dc1ec9hfpl1vik; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_host_info
    ADD CONSTRAINT uk_jyijfo8n7i5dc1ec9hfpl1vik UNIQUE (host_name);


--
-- Name: xhbm_spawner_element uk_k73t29bdeevq9pwdt7h2pdqcb; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_spawner_element
    ADD CONSTRAINT uk_k73t29bdeevq9pwdt7h2pdqcb UNIQUE (namespace, element_id);


--
-- Name: xhbm_script_trigger uk_kv6hfqitrp86x5w04dptyh9be; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script_trigger
    ADD CONSTRAINT uk_kv6hfqitrp86x5w04dptyh9be UNIQUE (trigger_id);


--
-- Name: xhbm_event uk_l2gwckfnfwnhguheqn4ta42vk; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_event
    ADD CONSTRAINT uk_l2gwckfnfwnhguheqn4ta42vk UNIQUE (event_label);


--
-- Name: xhbm_preference uk_log4u2q6pfqrfpl8k6adh9x18; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_preference
    ADD CONSTRAINT uk_log4u2q6pfqrfpl8k6adh9x18 UNIQUE (tool, name, scope, entity_id);


--
-- Name: xhbm_feature_definition uk_m6lkg5cvyrpvsqrsvwnf8scob; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_feature_definition
    ADD CONSTRAINT uk_m6lkg5cvyrpvsqrsvwnf8scob UNIQUE (key, disabled);


--
-- Name: xhbm_configuration_data_configurations uk_mdcxpup676rj7pi4lp8w44msb; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_configuration_data_configurations
    ADD CONSTRAINT uk_mdcxpup676rj7pi4lp8w44msb UNIQUE (configurations);


--
-- Name: xhbm_user_registration_data uk_n14anl9ur4cv97rfkeqsoo77c; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_user_registration_data
    ADD CONSTRAINT uk_n14anl9ur4cv97rfkeqsoo77c UNIQUE (login);


--
-- Name: xhbm_xnat_task_info uk_o6alqpril6ifv67tqs4ym4htw; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xnat_task_info
    ADD CONSTRAINT uk_o6alqpril6ifv67tqs4ym4htw UNIQUE (task_id, xnat_node_info_id);


--
-- Name: xhbm_xnat_node_info uk_ptbe2bqluumpw18putg10tbvo; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xnat_node_info
    ADD CONSTRAINT uk_ptbe2bqluumpw18putg10tbvo UNIQUE (node_id, host_name);


--
-- Name: xhbm_tool uk_r7xqcamvdk7cha6gxqplc2iog; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_tool
    ADD CONSTRAINT uk_r7xqcamvdk7cha6gxqplc2iog UNIQUE (tool_id);


--
-- Name: xhbm_automation_filters uk_sugjwvw9nvo6x79a9yloqm6j3; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_automation_filters
    ADD CONSTRAINT uk_sugjwvw9nvo6x79a9yloqm6j3 UNIQUE (external_id, src_event_class, field);


--
-- Name: xhbm_event uk_tc4p7ls7ph5r4cecb2e3uxej8; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_event
    ADD CONSTRAINT uk_tc4p7ls7ph5r4cecb2e3uxej8 UNIQUE (event_id);


--
-- Name: xhbm_user_role uk_to5ye3nudu8aspnnonelx83sn; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_user_role
    ADD CONSTRAINT uk_to5ye3nudu8aspnnonelx83sn UNIQUE (role, username, disabled);


--
-- Name: val_additionalval_history val_additionalval_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_additionalval_history
    ADD CONSTRAINT val_additionalval_history_pkey PRIMARY KEY (history_id);


--
-- Name: val_additionalval_meta_data val_additionalval_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_additionalval_meta_data
    ADD CONSTRAINT val_additionalval_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: val_additionalval val_additionalval_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_additionalval
    ADD CONSTRAINT val_additionalval_pkey PRIMARY KEY (val_additionalval_id);


--
-- Name: val_protocoldata_comment_history val_protocoldata_comment_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_comment_history
    ADD CONSTRAINT val_protocoldata_comment_history_pkey PRIMARY KEY (history_id);


--
-- Name: val_protocoldata_comment_meta_data val_protocoldata_comment_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_comment_meta_data
    ADD CONSTRAINT val_protocoldata_comment_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: val_protocoldata_comment val_protocoldata_comment_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_comment
    ADD CONSTRAINT val_protocoldata_comment_pkey PRIMARY KEY (val_protocoldata_comment_id);


--
-- Name: val_protocoldata_comment val_protocoldata_comment_u_ses_comment_date; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_comment
    ADD CONSTRAINT val_protocoldata_comment_u_ses_comment_date UNIQUE (datetime, check_comments_comment_val_prot_id);


--
-- Name: val_protocoldata_condition_history val_protocoldata_condition_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_condition_history
    ADD CONSTRAINT val_protocoldata_condition_history_pkey PRIMARY KEY (history_id);


--
-- Name: val_protocoldata_condition_meta_data val_protocoldata_condition_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_condition_meta_data
    ADD CONSTRAINT val_protocoldata_condition_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: val_protocoldata_condition val_protocoldata_condition_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_condition
    ADD CONSTRAINT val_protocoldata_condition_pkey PRIMARY KEY (val_protocoldata_condition_id);


--
-- Name: val_protocoldata_condition val_protocoldata_condition_u_scan_check_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_condition
    ADD CONSTRAINT val_protocoldata_condition_u_scan_check_id UNIQUE (id, check_conditions_condition_val__id);


--
-- Name: val_protocoldata_history val_protocoldata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_history
    ADD CONSTRAINT val_protocoldata_history_pkey PRIMARY KEY (history_id);


--
-- Name: val_protocoldata_meta_data val_protocoldata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_meta_data
    ADD CONSTRAINT val_protocoldata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: val_protocoldata val_protocoldata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata
    ADD CONSTRAINT val_protocoldata_pkey PRIMARY KEY (id);


--
-- Name: val_protocoldata_scan_check_comment_history val_protocoldata_scan_check_comment_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_comment_history
    ADD CONSTRAINT val_protocoldata_scan_check_comment_history_pkey PRIMARY KEY (history_id);


--
-- Name: val_protocoldata_scan_check_comment_meta_data val_protocoldata_scan_check_comment_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_comment_meta_data
    ADD CONSTRAINT val_protocoldata_scan_check_comment_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: val_protocoldata_scan_check_comment val_protocoldata_scan_check_comment_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_comment
    ADD CONSTRAINT val_protocoldata_scan_check_comment_pkey PRIMARY KEY (val_protocoldata_scan_check_comment_id);


--
-- Name: val_protocoldata_scan_check_comment val_protocoldata_scan_check_comment_u_scan_comment_date; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_comment
    ADD CONSTRAINT val_protocoldata_scan_check_comment_u_scan_comment_date UNIQUE (datetime, comments_comment_val_protocolda_val_protocoldata_scan_check_id);


--
-- Name: val_protocoldata_scan_check_condition_history val_protocoldata_scan_check_condition_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_condition_history
    ADD CONSTRAINT val_protocoldata_scan_check_condition_history_pkey PRIMARY KEY (history_id);


--
-- Name: val_protocoldata_scan_check_condition_meta_data val_protocoldata_scan_check_condition_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_condition_meta_data
    ADD CONSTRAINT val_protocoldata_scan_check_condition_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: val_protocoldata_scan_check_condition val_protocoldata_scan_check_condition_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_condition
    ADD CONSTRAINT val_protocoldata_scan_check_condition_pkey PRIMARY KEY (val_protocoldata_scan_check_condition_id);


--
-- Name: val_protocoldata_scan_check_condition val_protocoldata_scan_check_condition_u_scan_condition_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_condition
    ADD CONSTRAINT val_protocoldata_scan_check_condition_u_scan_condition_id UNIQUE (id, conditions_condition_val_protoc_val_protocoldata_scan_check_id);


--
-- Name: val_protocoldata_scan_check_history val_protocoldata_scan_check_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_history
    ADD CONSTRAINT val_protocoldata_scan_check_history_pkey PRIMARY KEY (history_id);


--
-- Name: val_protocoldata_scan_check_meta_data val_protocoldata_scan_check_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check_meta_data
    ADD CONSTRAINT val_protocoldata_scan_check_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: val_protocoldata_scan_check val_protocoldata_scan_check_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check
    ADD CONSTRAINT val_protocoldata_scan_check_pkey PRIMARY KEY (val_protocoldata_scan_check_id);


--
-- Name: val_protocoldata_scan_check val_protocoldata_scan_check_u_scan_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.val_protocoldata_scan_check
    ADD CONSTRAINT val_protocoldata_scan_check_u_scan_id UNIQUE (scan_id, scans_scan_check_val_protocolda_id);


--
-- Name: wrk_abstractexecutionenvironment_history wrk_abstractexecutionenvironment_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_abstractexecutionenvironment_history
    ADD CONSTRAINT wrk_abstractexecutionenvironment_history_pkey PRIMARY KEY (history_id);


--
-- Name: wrk_abstractexecutionenvironment_meta_data wrk_abstractexecutionenvironment_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_abstractexecutionenvironment_meta_data
    ADD CONSTRAINT wrk_abstractexecutionenvironment_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: wrk_abstractexecutionenvironment wrk_abstractexecutionenvironment_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_abstractexecutionenvironment
    ADD CONSTRAINT wrk_abstractexecutionenvironment_pkey PRIMARY KEY (wrk_abstractexecutionenvironment_id);


--
-- Name: wrk_workflowdata_history wrk_workflowdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_workflowdata_history
    ADD CONSTRAINT wrk_workflowdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: wrk_workflowdata_meta_data wrk_workflowdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_workflowdata_meta_data
    ADD CONSTRAINT wrk_workflowdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: wrk_workflowdata wrk_workflowdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_workflowdata
    ADD CONSTRAINT wrk_workflowdata_pkey PRIMARY KEY (wrk_workflowdata_id);


--
-- Name: wrk_workflowdata wrk_workflowdata_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_workflowdata
    ADD CONSTRAINT wrk_workflowdata_u_true UNIQUE (id, pipeline_name, launch_time);


--
-- Name: wrk_xnatexecutionenvironment_history wrk_xnatexecutionenvironment_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_history
    ADD CONSTRAINT wrk_xnatexecutionenvironment_history_pkey PRIMARY KEY (history_id);


--
-- Name: wrk_xnatexecutionenvironment_meta_data wrk_xnatexecutionenvironment_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_meta_data
    ADD CONSTRAINT wrk_xnatexecutionenvironment_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_history wrk_xnatexecutionenvironment_notify_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_notify_history
    ADD CONSTRAINT wrk_xnatexecutionenvironment_notify_history_pkey PRIMARY KEY (history_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_meta_data wrk_xnatexecutionenvironment_notify_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_notify_meta_data
    ADD CONSTRAINT wrk_xnatexecutionenvironment_notify_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: wrk_xnatexecutionenvironment_notify wrk_xnatexecutionenvironment_notify_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_notify
    ADD CONSTRAINT wrk_xnatexecutionenvironment_notify_pkey PRIMARY KEY (wrk_xnatexecutionenvironment_notify_id);


--
-- Name: wrk_xnatexecutionenvironment_notify wrk_xnatexecutionenvironment_notify_u_notify; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_notify
    ADD CONSTRAINT wrk_xnatexecutionenvironment_notify_u_notify UNIQUE (notify, wrk_xnatexecutionenvironment_wrk_abstractexecutionenvironmen);


--
-- Name: wrk_xnatexecutionenvironment_parameter_history wrk_xnatexecutionenvironment_parameter_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_parameter_history
    ADD CONSTRAINT wrk_xnatexecutionenvironment_parameter_history_pkey PRIMARY KEY (history_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter_meta_data wrk_xnatexecutionenvironment_parameter_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_parameter_meta_data
    ADD CONSTRAINT wrk_xnatexecutionenvironment_parameter_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter wrk_xnatexecutionenvironment_parameter_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_parameter
    ADD CONSTRAINT wrk_xnatexecutionenvironment_parameter_pkey PRIMARY KEY (wrk_xnatexecutionenvironment_parameter_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter wrk_xnatexecutionenvironment_parameter_u_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment_parameter
    ADD CONSTRAINT wrk_xnatexecutionenvironment_parameter_u_name UNIQUE (name, parameters_parameter_wrk_xnatex_wrk_abstractexecutionenvironmen);


--
-- Name: wrk_xnatexecutionenvironment wrk_xnatexecutionenvironment_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.wrk_xnatexecutionenvironment
    ADD CONSTRAINT wrk_xnatexecutionenvironment_pkey PRIMARY KEY (wrk_abstractexecutionenvironment_id);


--
-- Name: xdat_a_xdat_action_type_allowe_xdat_role_type_history xdat_a_xdat_action_type_allowe_xdat_role_type_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_a_xdat_action_type_allowe_xdat_role_type_history
    ADD CONSTRAINT xdat_a_xdat_action_type_allowe_xdat_role_type_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_a_xdat_action_type_allowe_xdat_role_type xdat_a_xdat_action_type_allowe_xdat_role_type_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_a_xdat_action_type_allowe_xdat_role_type
    ADD CONSTRAINT xdat_a_xdat_action_type_allowe_xdat_role_type_pkey PRIMARY KEY (xdat_a_xdat_action_type_allowe_xdat_role_type_id);


--
-- Name: xdat_access_log_history xdat_access_log_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_access_log_history
    ADD CONSTRAINT xdat_access_log_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_access_log_meta_data xdat_access_log_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_access_log_meta_data
    ADD CONSTRAINT xdat_access_log_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_access_log xdat_access_log_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_access_log
    ADD CONSTRAINT xdat_access_log_pkey PRIMARY KEY (xdat_access_log_id);


--
-- Name: xdat_action_type_history xdat_action_type_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_action_type_history
    ADD CONSTRAINT xdat_action_type_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_action_type_meta_data xdat_action_type_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_action_type_meta_data
    ADD CONSTRAINT xdat_action_type_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_action_type xdat_action_type_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_action_type
    ADD CONSTRAINT xdat_action_type_pkey PRIMARY KEY (action_name);


--
-- Name: xdat_change_info_history xdat_change_info_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_change_info_history
    ADD CONSTRAINT xdat_change_info_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_change_info_meta_data xdat_change_info_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_change_info_meta_data
    ADD CONSTRAINT xdat_change_info_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_change_info xdat_change_info_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_change_info
    ADD CONSTRAINT xdat_change_info_pkey PRIMARY KEY (xdat_change_info_id);


--
-- Name: xdat_criteria_history xdat_criteria_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_criteria_history
    ADD CONSTRAINT xdat_criteria_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_criteria_meta_data xdat_criteria_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_criteria_meta_data
    ADD CONSTRAINT xdat_criteria_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_criteria xdat_criteria_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_criteria
    ADD CONSTRAINT xdat_criteria_pkey PRIMARY KEY (xdat_criteria_id);


--
-- Name: xdat_criteria_set_history xdat_criteria_set_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_criteria_set_history
    ADD CONSTRAINT xdat_criteria_set_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_criteria_set_meta_data xdat_criteria_set_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_criteria_set_meta_data
    ADD CONSTRAINT xdat_criteria_set_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_criteria_set xdat_criteria_set_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_criteria_set
    ADD CONSTRAINT xdat_criteria_set_pkey PRIMARY KEY (xdat_criteria_set_id);


--
-- Name: xdat_element_access_history xdat_element_access_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access_history
    ADD CONSTRAINT xdat_element_access_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_element_access_meta_data xdat_element_access_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access_meta_data
    ADD CONSTRAINT xdat_element_access_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_element_access xdat_element_access_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access
    ADD CONSTRAINT xdat_element_access_pkey PRIMARY KEY (xdat_element_access_id);


--
-- Name: xdat_element_access_secure_ip_history xdat_element_access_secure_ip_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access_secure_ip_history
    ADD CONSTRAINT xdat_element_access_secure_ip_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_element_access_secure_ip_meta_data xdat_element_access_secure_ip_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access_secure_ip_meta_data
    ADD CONSTRAINT xdat_element_access_secure_ip_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_element_access_secure_ip xdat_element_access_secure_ip_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access_secure_ip
    ADD CONSTRAINT xdat_element_access_secure_ip_pkey PRIMARY KEY (xdat_element_access_secure_ip_id);


--
-- Name: xdat_element_access_secure_ip xdat_element_access_secure_ip_u_unique; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access_secure_ip
    ADD CONSTRAINT xdat_element_access_secure_ip_u_unique UNIQUE (secure_ip, xdat_element_access_xdat_element_access_id);


--
-- Name: xdat_element_access xdat_element_access_u_group_access; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access
    ADD CONSTRAINT xdat_element_access_u_group_access UNIQUE (element_name, xdat_usergroup_xdat_usergroup_id);


--
-- Name: xdat_element_access xdat_element_access_u_user_access; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_access
    ADD CONSTRAINT xdat_element_access_u_user_access UNIQUE (element_name, xdat_user_xdat_user_id);


--
-- Name: xdat_element_action_type_history xdat_element_action_type_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_action_type_history
    ADD CONSTRAINT xdat_element_action_type_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_element_action_type_meta_data xdat_element_action_type_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_action_type_meta_data
    ADD CONSTRAINT xdat_element_action_type_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_element_action_type xdat_element_action_type_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_action_type
    ADD CONSTRAINT xdat_element_action_type_pkey PRIMARY KEY (xdat_element_action_type_id);


--
-- Name: xdat_element_action_type xdat_element_action_type_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_action_type
    ADD CONSTRAINT xdat_element_action_type_u_true UNIQUE (element_action_name, element_actions_element_action__element_name);


--
-- Name: xdat_element_security_history xdat_element_security_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_security_history
    ADD CONSTRAINT xdat_element_security_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_element_security_listing_action_history xdat_element_security_listing_action_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_security_listing_action_history
    ADD CONSTRAINT xdat_element_security_listing_action_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_element_security_listing_action_meta_data xdat_element_security_listing_action_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_security_listing_action_meta_data
    ADD CONSTRAINT xdat_element_security_listing_action_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_element_security_listing_action xdat_element_security_listing_action_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_security_listing_action
    ADD CONSTRAINT xdat_element_security_listing_action_pkey PRIMARY KEY (xdat_element_security_listing_action_id);


--
-- Name: xdat_element_security_listing_action xdat_element_security_listing_action_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_security_listing_action
    ADD CONSTRAINT xdat_element_security_listing_action_u_true UNIQUE (element_action_name, listing_actions_listing_action__element_name);


--
-- Name: xdat_element_security_meta_data xdat_element_security_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_security_meta_data
    ADD CONSTRAINT xdat_element_security_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_element_security xdat_element_security_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_element_security
    ADD CONSTRAINT xdat_element_security_pkey PRIMARY KEY (element_name);


--
-- Name: xdat_field_mapping_history xdat_field_mapping_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_field_mapping_history
    ADD CONSTRAINT xdat_field_mapping_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_field_mapping_meta_data xdat_field_mapping_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_field_mapping_meta_data
    ADD CONSTRAINT xdat_field_mapping_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_field_mapping xdat_field_mapping_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_field_mapping
    ADD CONSTRAINT xdat_field_mapping_pkey PRIMARY KEY (xdat_field_mapping_id);


--
-- Name: xdat_field_mapping_set_history xdat_field_mapping_set_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_field_mapping_set_history
    ADD CONSTRAINT xdat_field_mapping_set_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_field_mapping_set_meta_data xdat_field_mapping_set_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_field_mapping_set_meta_data
    ADD CONSTRAINT xdat_field_mapping_set_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_field_mapping_set xdat_field_mapping_set_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_field_mapping_set
    ADD CONSTRAINT xdat_field_mapping_set_pkey PRIMARY KEY (xdat_field_mapping_set_id);


--
-- Name: xdat_infoentry_history xdat_infoentry_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_infoentry_history
    ADD CONSTRAINT xdat_infoentry_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_infoentry_meta_data xdat_infoentry_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_infoentry_meta_data
    ADD CONSTRAINT xdat_infoentry_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_infoentry xdat_infoentry_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_infoentry
    ADD CONSTRAINT xdat_infoentry_pkey PRIMARY KEY (xdat_infoentry_id);


--
-- Name: xdat_infoentry xdat_infoentry_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_infoentry
    ADD CONSTRAINT xdat_infoentry_u_1 UNIQUE (title);


--
-- Name: xdat_meta_element xdat_meta_element_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_meta_element
    ADD CONSTRAINT xdat_meta_element_pkey PRIMARY KEY (xdat_meta_element_id);


--
-- Name: xdat_meta_element xdat_meta_element_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_meta_element
    ADD CONSTRAINT xdat_meta_element_u_1 UNIQUE (element_name);


--
-- Name: xdat_newsentry_history xdat_newsentry_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_newsentry_history
    ADD CONSTRAINT xdat_newsentry_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_newsentry_meta_data xdat_newsentry_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_newsentry_meta_data
    ADD CONSTRAINT xdat_newsentry_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_newsentry xdat_newsentry_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_newsentry
    ADD CONSTRAINT xdat_newsentry_pkey PRIMARY KEY (xdat_newsentry_id);


--
-- Name: xdat_newsentry xdat_newsentry_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_newsentry
    ADD CONSTRAINT xdat_newsentry_u_1 UNIQUE (title);


--
-- Name: xdat_primary_security_field_history xdat_primary_security_field_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_primary_security_field_history
    ADD CONSTRAINT xdat_primary_security_field_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_primary_security_field_meta_data xdat_primary_security_field_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_primary_security_field_meta_data
    ADD CONSTRAINT xdat_primary_security_field_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_primary_security_field xdat_primary_security_field_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_primary_security_field
    ADD CONSTRAINT xdat_primary_security_field_pkey PRIMARY KEY (xdat_primary_security_field_id);


--
-- Name: xdat_primary_security_field xdat_primary_security_field_u_unique; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_primary_security_field
    ADD CONSTRAINT xdat_primary_security_field_u_unique UNIQUE (primary_security_field, primary_security_fields_primary_element_name);


--
-- Name: xdat_r_xdat_role_type_assign_xdat_user_history xdat_r_xdat_role_type_assign_xdat_user_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_r_xdat_role_type_assign_xdat_user_history
    ADD CONSTRAINT xdat_r_xdat_role_type_assign_xdat_user_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_r_xdat_role_type_assign_xdat_user xdat_r_xdat_role_type_assign_xdat_user_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_r_xdat_role_type_assign_xdat_user
    ADD CONSTRAINT xdat_r_xdat_role_type_assign_xdat_user_pkey PRIMARY KEY (xdat_r_xdat_role_type_assign_xdat_user_id);


--
-- Name: xdat_role_type_history xdat_role_type_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_role_type_history
    ADD CONSTRAINT xdat_role_type_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_role_type_meta_data xdat_role_type_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_role_type_meta_data
    ADD CONSTRAINT xdat_role_type_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_role_type xdat_role_type_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_role_type
    ADD CONSTRAINT xdat_role_type_pkey PRIMARY KEY (role_name);


--
-- Name: xdat_search_field_history xdat_search_field_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_search_field_history
    ADD CONSTRAINT xdat_search_field_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_search_field_meta_data xdat_search_field_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_search_field_meta_data
    ADD CONSTRAINT xdat_search_field_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_search_field xdat_search_field_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_search_field
    ADD CONSTRAINT xdat_search_field_pkey PRIMARY KEY (xdat_search_field_id);


--
-- Name: xdat_search_field xdat_search_field_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_search_field
    ADD CONSTRAINT xdat_search_field_u_true UNIQUE (element_name, field_id, xdat_stored_search_id);


--
-- Name: xdat_search_history xdat_search_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_search_history
    ADD CONSTRAINT xdat_search_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_search_meta_data xdat_search_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_search_meta_data
    ADD CONSTRAINT xdat_search_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_search xdat_search_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_search
    ADD CONSTRAINT xdat_search_pkey PRIMARY KEY (id);


--
-- Name: xdat_security_history xdat_security_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_security_history
    ADD CONSTRAINT xdat_security_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_security_meta_data xdat_security_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_security_meta_data
    ADD CONSTRAINT xdat_security_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_security xdat_security_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_security
    ADD CONSTRAINT xdat_security_pkey PRIMARY KEY (xdat_security_id);


--
-- Name: xdat_security xdat_security_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_security
    ADD CONSTRAINT xdat_security_u_1 UNIQUE (system);


--
-- Name: xdat_stored_search_allowed_user_history xdat_stored_search_allowed_user_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_allowed_user_history
    ADD CONSTRAINT xdat_stored_search_allowed_user_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_stored_search_allowed_user_meta_data xdat_stored_search_allowed_user_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_allowed_user_meta_data
    ADD CONSTRAINT xdat_stored_search_allowed_user_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_stored_search_allowed_user xdat_stored_search_allowed_user_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_allowed_user
    ADD CONSTRAINT xdat_stored_search_allowed_user_pkey PRIMARY KEY (xdat_stored_search_allowed_user_id);


--
-- Name: xdat_stored_search_allowed_user xdat_stored_search_allowed_user_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_allowed_user
    ADD CONSTRAINT xdat_stored_search_allowed_user_u_true UNIQUE (login, xdat_stored_search_id);


--
-- Name: xdat_stored_search_groupid_history xdat_stored_search_groupid_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_groupid_history
    ADD CONSTRAINT xdat_stored_search_groupid_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_stored_search_groupid_meta_data xdat_stored_search_groupid_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_groupid_meta_data
    ADD CONSTRAINT xdat_stored_search_groupid_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_stored_search_groupid xdat_stored_search_groupid_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_groupid
    ADD CONSTRAINT xdat_stored_search_groupid_pkey PRIMARY KEY (xdat_stored_search_groupid_id);


--
-- Name: xdat_stored_search_groupid xdat_stored_search_groupid_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_groupid
    ADD CONSTRAINT xdat_stored_search_groupid_u_true UNIQUE (groupid, allowed_groups_groupid_xdat_sto_id);


--
-- Name: xdat_stored_search_history xdat_stored_search_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_history
    ADD CONSTRAINT xdat_stored_search_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_stored_search_meta_data xdat_stored_search_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search_meta_data
    ADD CONSTRAINT xdat_stored_search_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_stored_search xdat_stored_search_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_stored_search
    ADD CONSTRAINT xdat_stored_search_pkey PRIMARY KEY (id);


--
-- Name: xdat_user_groupid_history xdat_user_groupid_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_groupid_history
    ADD CONSTRAINT xdat_user_groupid_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_user_groupid_meta_data xdat_user_groupid_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_groupid_meta_data
    ADD CONSTRAINT xdat_user_groupid_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_user_groupid xdat_user_groupid_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_groupid
    ADD CONSTRAINT xdat_user_groupid_pkey PRIMARY KEY (xdat_user_groupid_id);


--
-- Name: xdat_user_groupid xdat_user_groupid_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_groupid
    ADD CONSTRAINT xdat_user_groupid_u_true UNIQUE (groupid, groups_groupid_xdat_user_xdat_user_id);


--
-- Name: xdat_user_history xdat_user_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_history
    ADD CONSTRAINT xdat_user_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_user_login_history xdat_user_login_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_login_history
    ADD CONSTRAINT xdat_user_login_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_user_login_meta_data xdat_user_login_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_login_meta_data
    ADD CONSTRAINT xdat_user_login_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_user_login xdat_user_login_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_login
    ADD CONSTRAINT xdat_user_login_pkey PRIMARY KEY (xdat_user_login_id);


--
-- Name: xdat_user_login xdat_user_login_u_unique; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_login
    ADD CONSTRAINT xdat_user_login_u_unique UNIQUE (login_date, user_xdat_user_id);


--
-- Name: xdat_user_meta_data xdat_user_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user_meta_data
    ADD CONSTRAINT xdat_user_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_user xdat_user_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user
    ADD CONSTRAINT xdat_user_pkey PRIMARY KEY (xdat_user_id);


--
-- Name: xdat_user xdat_user_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_user
    ADD CONSTRAINT xdat_user_u_1 UNIQUE (login);


--
-- Name: xdat_usergroup_history xdat_usergroup_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_usergroup_history
    ADD CONSTRAINT xdat_usergroup_history_pkey PRIMARY KEY (history_id);


--
-- Name: xdat_usergroup_meta_data xdat_usergroup_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_usergroup_meta_data
    ADD CONSTRAINT xdat_usergroup_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xdat_usergroup xdat_usergroup_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_usergroup
    ADD CONSTRAINT xdat_usergroup_pkey PRIMARY KEY (xdat_usergroup_id);


--
-- Name: xdat_usergroup xdat_usergroup_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xdat_usergroup
    ADD CONSTRAINT xdat_usergroup_u_1 UNIQUE (id);


--
-- Name: xhbm_alias_token xhbm_alias_token_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_alias_token
    ADD CONSTRAINT xhbm_alias_token_pkey PRIMARY KEY (id);


--
-- Name: xhbm_archive_processor_instance_aud xhbm_archive_processor_instance_aud_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_archive_processor_instance_aud
    ADD CONSTRAINT xhbm_archive_processor_instance_aud_pkey PRIMARY KEY (id, rev);


--
-- Name: xhbm_archive_processor_instance_parameters_aud xhbm_archive_processor_instance_parameters_aud_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_archive_processor_instance_parameters_aud
    ADD CONSTRAINT xhbm_archive_processor_instance_parameters_aud_pkey PRIMARY KEY (rev, archive_processor_instance, value, parameter_name);


--
-- Name: xhbm_archive_processor_instance_parameters xhbm_archive_processor_instance_parameters_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_archive_processor_instance_parameters
    ADD CONSTRAINT xhbm_archive_processor_instance_parameters_pkey PRIMARY KEY (archive_processor_instance, parameter_name);


--
-- Name: xhbm_archive_processor_instance xhbm_archive_processor_instance_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_archive_processor_instance
    ADD CONSTRAINT xhbm_archive_processor_instance_pkey PRIMARY KEY (id);


--
-- Name: xhbm_archive_processor_instance_project_ids_list_aud xhbm_archive_processor_instance_project_ids_list_aud_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_archive_processor_instance_project_ids_list_aud
    ADD CONSTRAINT xhbm_archive_processor_instance_project_ids_list_aud_pkey PRIMARY KEY (rev, archive_processor_instance, project_ids_list);


--
-- Name: xhbm_archive_processor_instance_scp_blacklist_aud xhbm_archive_processor_instance_scp_blacklist_aud_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_archive_processor_instance_scp_blacklist_aud
    ADD CONSTRAINT xhbm_archive_processor_instance_scp_blacklist_aud_pkey PRIMARY KEY (rev, archive_processor_instance, scp_blacklist);


--
-- Name: xhbm_archive_processor_instance_scp_whitelist_aud xhbm_archive_processor_instance_scp_whitelist_aud_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_archive_processor_instance_scp_whitelist_aud
    ADD CONSTRAINT xhbm_archive_processor_instance_scp_whitelist_aud_pkey PRIMARY KEY (rev, archive_processor_instance, scp_whitelist);


--
-- Name: xhbm_automation_event_ids_ids xhbm_automation_event_ids_ids_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_automation_event_ids_ids
    ADD CONSTRAINT xhbm_automation_event_ids_ids_pkey PRIMARY KEY (id);


--
-- Name: xhbm_automation_event_ids xhbm_automation_event_ids_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_automation_event_ids
    ADD CONSTRAINT xhbm_automation_event_ids_pkey PRIMARY KEY (id);


--
-- Name: xhbm_automation_filters xhbm_automation_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_automation_filters
    ADD CONSTRAINT xhbm_automation_filters_pkey PRIMARY KEY (id);


--
-- Name: xhbm_category xhbm_category_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_category
    ADD CONSTRAINT xhbm_category_pkey PRIMARY KEY (id);


--
-- Name: xhbm_channel xhbm_channel_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_channel
    ADD CONSTRAINT xhbm_channel_pkey PRIMARY KEY (id);


--
-- Name: xhbm_configuration_data_configurations xhbm_configuration_data_configurations_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_configuration_data_configurations
    ADD CONSTRAINT xhbm_configuration_data_configurations_pkey PRIMARY KEY (configuration_data, configurations);


--
-- Name: xhbm_configuration_data xhbm_configuration_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_configuration_data
    ADD CONSTRAINT xhbm_configuration_data_pkey PRIMARY KEY (id);


--
-- Name: xhbm_configuration xhbm_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_configuration
    ADD CONSTRAINT xhbm_configuration_pkey PRIMARY KEY (id);


--
-- Name: xhbm_data_cache_item xhbm_data_cache_item_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_data_cache_item
    ADD CONSTRAINT xhbm_data_cache_item_pkey PRIMARY KEY (id);


--
-- Name: xhbm_definition xhbm_definition_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_definition
    ADD CONSTRAINT xhbm_definition_pkey PRIMARY KEY (id);


--
-- Name: xhbm_event_filters xhbm_event_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_event_filters
    ADD CONSTRAINT xhbm_event_filters_pkey PRIMARY KEY (id);


--
-- Name: xhbm_event xhbm_event_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_event
    ADD CONSTRAINT xhbm_event_pkey PRIMARY KEY (id);


--
-- Name: xhbm_event_specific_fields xhbm_event_specific_fields_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_event_specific_fields
    ADD CONSTRAINT xhbm_event_specific_fields_pkey PRIMARY KEY (id);


--
-- Name: xhbm_feature_definition xhbm_feature_definition_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_feature_definition
    ADD CONSTRAINT xhbm_feature_definition_pkey PRIMARY KEY (id);


--
-- Name: xhbm_group_feature xhbm_group_feature_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_group_feature
    ADD CONSTRAINT xhbm_group_feature_pkey PRIMARY KEY (id);


--
-- Name: xhbm_host_info xhbm_host_info_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_host_info
    ADD CONSTRAINT xhbm_host_info_pkey PRIMARY KEY (id);


--
-- Name: xhbm_notification xhbm_notification_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_notification
    ADD CONSTRAINT xhbm_notification_pkey PRIMARY KEY (id);


--
-- Name: xhbm_persistent_event xhbm_persistent_event_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_persistent_event
    ADD CONSTRAINT xhbm_persistent_event_pkey PRIMARY KEY (id);


--
-- Name: xhbm_preference xhbm_preference_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_preference
    ADD CONSTRAINT xhbm_preference_pkey PRIMARY KEY (id);


--
-- Name: xhbm_revinfo xhbm_revinfo_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_revinfo
    ADD CONSTRAINT xhbm_revinfo_pkey PRIMARY KEY (rev);


--
-- Name: xhbm_script_aud xhbm_script_aud_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script_aud
    ADD CONSTRAINT xhbm_script_aud_pkey PRIMARY KEY (id, rev);


--
-- Name: xhbm_script_launch_request_event xhbm_script_launch_request_event_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script_launch_request_event
    ADD CONSTRAINT xhbm_script_launch_request_event_pkey PRIMARY KEY (id);


--
-- Name: xhbm_script xhbm_script_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script
    ADD CONSTRAINT xhbm_script_pkey PRIMARY KEY (id);


--
-- Name: xhbm_script_trigger xhbm_script_trigger_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script_trigger
    ADD CONSTRAINT xhbm_script_trigger_pkey PRIMARY KEY (id);


--
-- Name: xhbm_script_trigger_template xhbm_script_trigger_template_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script_trigger_template
    ADD CONSTRAINT xhbm_script_trigger_template_pkey PRIMARY KEY (id);


--
-- Name: xhbm_script_trigger_template_triggers xhbm_script_trigger_template_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_script_trigger_template_triggers
    ADD CONSTRAINT xhbm_script_trigger_template_triggers_pkey PRIMARY KEY (script_trigger_template, triggers);


--
-- Name: xhbm_spawner_element xhbm_spawner_element_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_spawner_element
    ADD CONSTRAINT xhbm_spawner_element_pkey PRIMARY KEY (id);


--
-- Name: xhbm_subscriber xhbm_subscriber_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_subscriber
    ADD CONSTRAINT xhbm_subscriber_pkey PRIMARY KEY (id);


--
-- Name: xhbm_subscription xhbm_subscription_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_subscription
    ADD CONSTRAINT xhbm_subscription_pkey PRIMARY KEY (id);


--
-- Name: xhbm_tool xhbm_tool_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_tool
    ADD CONSTRAINT xhbm_tool_pkey PRIMARY KEY (id);


--
-- Name: xhbm_user_change_request xhbm_user_change_request_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_user_change_request
    ADD CONSTRAINT xhbm_user_change_request_pkey PRIMARY KEY (id);


--
-- Name: xhbm_user_registration_data xhbm_user_registration_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_user_registration_data
    ADD CONSTRAINT xhbm_user_registration_data_pkey PRIMARY KEY (id);


--
-- Name: xhbm_user_role xhbm_user_role_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_user_role
    ADD CONSTRAINT xhbm_user_role_pkey PRIMARY KEY (id);


--
-- Name: xhbm_xdat_user_auth xhbm_xdat_user_auth_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xdat_user_auth
    ADD CONSTRAINT xhbm_xdat_user_auth_pkey PRIMARY KEY (id);


--
-- Name: xhbm_xft_field_exclusion xhbm_xft_field_exclusion_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xft_field_exclusion
    ADD CONSTRAINT xhbm_xft_field_exclusion_pkey PRIMARY KEY (id);


--
-- Name: xhbm_xnat_node_info xhbm_xnat_node_info_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xnat_node_info
    ADD CONSTRAINT xhbm_xnat_node_info_pkey PRIMARY KEY (id);


--
-- Name: xhbm_xnat_task_info xhbm_xnat_task_info_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xhbm_xnat_task_info
    ADD CONSTRAINT xhbm_xnat_task_info_pkey PRIMARY KEY (id);


--
-- Name: xnat_a_scidresearchdata_history xnat_a_scidresearchdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_scidresearchdata_history
    ADD CONSTRAINT xnat_a_scidresearchdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_a_scidresearchdata_meta_data xnat_a_scidresearchdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_scidresearchdata_meta_data
    ADD CONSTRAINT xnat_a_scidresearchdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_a_scidresearchdata xnat_a_scidresearchdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_scidresearchdata
    ADD CONSTRAINT xnat_a_scidresearchdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_a_sideeffectspittsburghdata_history xnat_a_sideeffectspittsburghdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_sideeffectspittsburghdata_history
    ADD CONSTRAINT xnat_a_sideeffectspittsburghdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data xnat_a_sideeffectspittsburghdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_sideeffectspittsburghdata_meta_data
    ADD CONSTRAINT xnat_a_sideeffectspittsburghdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_a_sideeffectspittsburghdata xnat_a_sideeffectspittsburghdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_sideeffectspittsburghdata
    ADD CONSTRAINT xnat_a_sideeffectspittsburghdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_a_updrs3data_history xnat_a_updrs3data_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_updrs3data_history
    ADD CONSTRAINT xnat_a_updrs3data_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_a_updrs3data_meta_data xnat_a_updrs3data_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_updrs3data_meta_data
    ADD CONSTRAINT xnat_a_updrs3data_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_a_updrs3data xnat_a_updrs3data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_updrs3data
    ADD CONSTRAINT xnat_a_updrs3data_pkey PRIMARY KEY (id);


--
-- Name: xnat_a_ybocsdata_history xnat_a_ybocsdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_ybocsdata_history
    ADD CONSTRAINT xnat_a_ybocsdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_a_ybocsdata_meta_data xnat_a_ybocsdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_ybocsdata_meta_data
    ADD CONSTRAINT xnat_a_ybocsdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_a_ybocsdata xnat_a_ybocsdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_ybocsdata
    ADD CONSTRAINT xnat_a_ybocsdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_a_ygtssdata_history xnat_a_ygtssdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_ygtssdata_history
    ADD CONSTRAINT xnat_a_ygtssdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_a_ygtssdata_meta_data xnat_a_ygtssdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_ygtssdata_meta_data
    ADD CONSTRAINT xnat_a_ygtssdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_a_ygtssdata xnat_a_ygtssdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_a_ygtssdata
    ADD CONSTRAINT xnat_a_ygtssdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_abstractdemographicdata_history xnat_abstractdemographicdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractdemographicdata_history
    ADD CONSTRAINT xnat_abstractdemographicdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_abstractdemographicdata_meta_data xnat_abstractdemographicdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractdemographicdata_meta_data
    ADD CONSTRAINT xnat_abstractdemographicdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_abstractdemographicdata xnat_abstractdemographicdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractdemographicdata
    ADD CONSTRAINT xnat_abstractdemographicdata_pkey PRIMARY KEY (xnat_abstractdemographicdata_id);


--
-- Name: xnat_abstractprotocol_history xnat_abstractprotocol_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractprotocol_history
    ADD CONSTRAINT xnat_abstractprotocol_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_abstractprotocol_meta_data xnat_abstractprotocol_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractprotocol_meta_data
    ADD CONSTRAINT xnat_abstractprotocol_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_abstractprotocol xnat_abstractprotocol_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractprotocol
    ADD CONSTRAINT xnat_abstractprotocol_pkey PRIMARY KEY (xnat_abstractprotocol_id);


--
-- Name: xnat_abstractprotocol xnat_abstractprotocol_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractprotocol
    ADD CONSTRAINT xnat_abstractprotocol_u_1 UNIQUE (id);


--
-- Name: xnat_abstractresource_history xnat_abstractresource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractresource_history
    ADD CONSTRAINT xnat_abstractresource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_abstractresource_meta_data xnat_abstractresource_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractresource_meta_data
    ADD CONSTRAINT xnat_abstractresource_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_abstractresource xnat_abstractresource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractresource
    ADD CONSTRAINT xnat_abstractresource_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_abstractresource_tag_history xnat_abstractresource_tag_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractresource_tag_history
    ADD CONSTRAINT xnat_abstractresource_tag_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_abstractresource_tag_meta_data xnat_abstractresource_tag_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractresource_tag_meta_data
    ADD CONSTRAINT xnat_abstractresource_tag_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_abstractresource_tag xnat_abstractresource_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractresource_tag
    ADD CONSTRAINT xnat_abstractresource_tag_pkey PRIMARY KEY (xnat_abstractresource_tag_id);


--
-- Name: xnat_abstractresource_tag xnat_abstractresource_tag_u_catalog_tag; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractresource_tag
    ADD CONSTRAINT xnat_abstractresource_tag_u_catalog_tag UNIQUE (tag, tags_tag_xnat_abstractresource_xnat_abstractresource_id);


--
-- Name: xnat_abstractstatistics_history xnat_abstractstatistics_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractstatistics_history
    ADD CONSTRAINT xnat_abstractstatistics_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_abstractstatistics_meta_data xnat_abstractstatistics_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractstatistics_meta_data
    ADD CONSTRAINT xnat_abstractstatistics_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_abstractstatistics xnat_abstractstatistics_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractstatistics
    ADD CONSTRAINT xnat_abstractstatistics_pkey PRIMARY KEY (xnat_abstractstatistics_id);


--
-- Name: xnat_abstractsubjectmetadata_history xnat_abstractsubjectmetadata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractsubjectmetadata_history
    ADD CONSTRAINT xnat_abstractsubjectmetadata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_abstractsubjectmetadata_meta_data xnat_abstractsubjectmetadata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractsubjectmetadata_meta_data
    ADD CONSTRAINT xnat_abstractsubjectmetadata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_abstractsubjectmetadata xnat_abstractsubjectmetadata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_abstractsubjectmetadata
    ADD CONSTRAINT xnat_abstractsubjectmetadata_pkey PRIMARY KEY (xnat_abstractsubjectmetadata_id);


--
-- Name: xnat_addfield_history xnat_addfield_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_addfield_history
    ADD CONSTRAINT xnat_addfield_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_addfield_meta_data xnat_addfield_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_addfield_meta_data
    ADD CONSTRAINT xnat_addfield_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_addfield xnat_addfield_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_addfield
    ADD CONSTRAINT xnat_addfield_pkey PRIMARY KEY (xnat_addfield_id);


--
-- Name: xnat_addfield xnat_addfield_u_assessor; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_addfield
    ADD CONSTRAINT xnat_addfield_u_assessor UNIQUE (name, parameters_addparam_xnat_imagea_id);


--
-- Name: xnat_addfield xnat_addfield_u_pet_scan; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_addfield
    ADD CONSTRAINT xnat_addfield_u_pet_scan UNIQUE (name, parameters_addparam_xnat_petsca_xnat_imagescandata_id);


--
-- Name: xnat_addfield xnat_addfield_u_recon; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_addfield
    ADD CONSTRAINT xnat_addfield_u_recon UNIQUE (name, parameters_addparam_xnat_recons_xnat_reconstructedimagedata_id);


--
-- Name: xnat_addfield xnat_addfield_u_scan; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_addfield
    ADD CONSTRAINT xnat_addfield_u_scan UNIQUE (name, parameters_addparam_xnat_mrscan_xnat_imagescandata_id);


--
-- Name: xnat_algorithm_history xnat_algorithm_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_algorithm_history
    ADD CONSTRAINT xnat_algorithm_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_algorithm_meta_data xnat_algorithm_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_algorithm_meta_data
    ADD CONSTRAINT xnat_algorithm_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_algorithm xnat_algorithm_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_algorithm
    ADD CONSTRAINT xnat_algorithm_pkey PRIMARY KEY (xnat_algorithm_id);


--
-- Name: xnat_computationdata_history xnat_computationdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_computationdata_history
    ADD CONSTRAINT xnat_computationdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_computationdata_meta_data xnat_computationdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_computationdata_meta_data
    ADD CONSTRAINT xnat_computationdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_computationdata xnat_computationdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_computationdata
    ADD CONSTRAINT xnat_computationdata_pkey PRIMARY KEY (xnat_computationdata_id);


--
-- Name: xnat_computationdata xnat_computationdata_u_pet_recon; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_computationdata
    ADD CONSTRAINT xnat_computationdata_u_pet_recon UNIQUE (name, source, computations_datum_xnat_reconst_xnat_reconstructedimagedata_id);


--
-- Name: xnat_contrastbolus_history xnat_contrastbolus_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_contrastbolus_history
    ADD CONSTRAINT xnat_contrastbolus_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_contrastbolus_meta_data xnat_contrastbolus_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_contrastbolus_meta_data
    ADD CONSTRAINT xnat_contrastbolus_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_contrastbolus xnat_contrastbolus_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_contrastbolus
    ADD CONSTRAINT xnat_contrastbolus_pkey PRIMARY KEY (xnat_contrastbolus_id);


--
-- Name: xnat_crscandata_history xnat_crscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_crscandata_history
    ADD CONSTRAINT xnat_crscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_crscandata_meta_data xnat_crscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_crscandata_meta_data
    ADD CONSTRAINT xnat_crscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_crscandata xnat_crscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_crscandata
    ADD CONSTRAINT xnat_crscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_crsessiondata_history xnat_crsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_crsessiondata_history
    ADD CONSTRAINT xnat_crsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_crsessiondata_meta_data xnat_crsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_crsessiondata_meta_data
    ADD CONSTRAINT xnat_crsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_crsessiondata xnat_crsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_crsessiondata
    ADD CONSTRAINT xnat_crsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_ctscandata_focalspot_history xnat_ctscandata_focalspot_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctscandata_focalspot_history
    ADD CONSTRAINT xnat_ctscandata_focalspot_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_ctscandata_focalspot_meta_data xnat_ctscandata_focalspot_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctscandata_focalspot_meta_data
    ADD CONSTRAINT xnat_ctscandata_focalspot_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_ctscandata_focalspot xnat_ctscandata_focalspot_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctscandata_focalspot
    ADD CONSTRAINT xnat_ctscandata_focalspot_pkey PRIMARY KEY (xnat_ctscandata_focalspot_id);


--
-- Name: xnat_ctscandata_focalspot xnat_ctscandata_focalspot_u_fspot; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctscandata_focalspot
    ADD CONSTRAINT xnat_ctscandata_focalspot_u_fspot UNIQUE (focalspot, parameters_focalspots_focalspot_xnat_imagescandata_id);


--
-- Name: xnat_ctscandata_history xnat_ctscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctscandata_history
    ADD CONSTRAINT xnat_ctscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_ctscandata_meta_data xnat_ctscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctscandata_meta_data
    ADD CONSTRAINT xnat_ctscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_ctscandata xnat_ctscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctscandata
    ADD CONSTRAINT xnat_ctscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_ctsessiondata_history xnat_ctsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctsessiondata_history
    ADD CONSTRAINT xnat_ctsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_ctsessiondata_meta_data xnat_ctsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctsessiondata_meta_data
    ADD CONSTRAINT xnat_ctsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_ctsessiondata xnat_ctsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ctsessiondata
    ADD CONSTRAINT xnat_ctsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_datatypeprotocol_fieldgroups_history xnat_datatypeprotocol_fieldgroups_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_datatypeprotocol_fieldgroups_history
    ADD CONSTRAINT xnat_datatypeprotocol_fieldgroups_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_datatypeprotocol_fieldgroups xnat_datatypeprotocol_fieldgroups_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_datatypeprotocol_fieldgroups
    ADD CONSTRAINT xnat_datatypeprotocol_fieldgroups_pkey PRIMARY KEY (xnat_datatypeprotocol_fieldgroups_id);


--
-- Name: xnat_datatypeprotocol_history xnat_datatypeprotocol_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_datatypeprotocol_history
    ADD CONSTRAINT xnat_datatypeprotocol_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_datatypeprotocol_meta_data xnat_datatypeprotocol_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_datatypeprotocol_meta_data
    ADD CONSTRAINT xnat_datatypeprotocol_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_datatypeprotocol xnat_datatypeprotocol_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_datatypeprotocol
    ADD CONSTRAINT xnat_datatypeprotocol_pkey PRIMARY KEY (xnat_abstractprotocol_id);


--
-- Name: xnat_demographicdata_history xnat_demographicdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_demographicdata_history
    ADD CONSTRAINT xnat_demographicdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_demographicdata_meta_data xnat_demographicdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_demographicdata_meta_data
    ADD CONSTRAINT xnat_demographicdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_demographicdata xnat_demographicdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_demographicdata
    ADD CONSTRAINT xnat_demographicdata_pkey PRIMARY KEY (xnat_abstractdemographicdata_id);


--
-- Name: xnat_deriveddata_history xnat_deriveddata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_deriveddata_history
    ADD CONSTRAINT xnat_deriveddata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_deriveddata_meta_data xnat_deriveddata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_deriveddata_meta_data
    ADD CONSTRAINT xnat_deriveddata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_deriveddata xnat_deriveddata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_deriveddata
    ADD CONSTRAINT xnat_deriveddata_pkey PRIMARY KEY (id);


--
-- Name: xnat_dicomcodedvalue_history xnat_dicomcodedvalue_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomcodedvalue_history
    ADD CONSTRAINT xnat_dicomcodedvalue_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_dicomcodedvalue_meta_data xnat_dicomcodedvalue_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomcodedvalue_meta_data
    ADD CONSTRAINT xnat_dicomcodedvalue_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_dicomcodedvalue xnat_dicomcodedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomcodedvalue
    ADD CONSTRAINT xnat_dicomcodedvalue_pkey PRIMARY KEY (xnat_dicomcodedvalue_id);


--
-- Name: xnat_dicomseries_history xnat_dicomseries_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries_history
    ADD CONSTRAINT xnat_dicomseries_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_dicomseries_image_history xnat_dicomseries_image_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries_image_history
    ADD CONSTRAINT xnat_dicomseries_image_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_dicomseries_image_meta_data xnat_dicomseries_image_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries_image_meta_data
    ADD CONSTRAINT xnat_dicomseries_image_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_dicomseries_image xnat_dicomseries_image_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries_image
    ADD CONSTRAINT xnat_dicomseries_image_pkey PRIMARY KEY (xnat_dicomseries_image_id);


--
-- Name: xnat_dicomseries_image xnat_dicomseries_image_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries_image
    ADD CONSTRAINT xnat_dicomseries_image_u_1 UNIQUE (sop_instance_uid);


--
-- Name: xnat_dicomseries_meta_data xnat_dicomseries_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries_meta_data
    ADD CONSTRAINT xnat_dicomseries_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_dicomseries xnat_dicomseries_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries
    ADD CONSTRAINT xnat_dicomseries_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_dicomseries xnat_dicomseries_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dicomseries
    ADD CONSTRAINT xnat_dicomseries_u_1 UNIQUE (uid);


--
-- Name: xnat_dx3dcraniofacialscandata_history xnat_dx3dcraniofacialscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dx3dcraniofacialscandata_history
    ADD CONSTRAINT xnat_dx3dcraniofacialscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_dx3dcraniofacialscandata_meta_data xnat_dx3dcraniofacialscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dx3dcraniofacialscandata_meta_data
    ADD CONSTRAINT xnat_dx3dcraniofacialscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_dx3dcraniofacialscandata xnat_dx3dcraniofacialscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dx3dcraniofacialscandata
    ADD CONSTRAINT xnat_dx3dcraniofacialscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_history xnat_dx3dcraniofacialsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dx3dcraniofacialsessiondata_history
    ADD CONSTRAINT xnat_dx3dcraniofacialsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data xnat_dx3dcraniofacialsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dx3dcraniofacialsessiondata_meta_data
    ADD CONSTRAINT xnat_dx3dcraniofacialsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata xnat_dx3dcraniofacialsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dx3dcraniofacialsessiondata
    ADD CONSTRAINT xnat_dx3dcraniofacialsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_dxscandata_history xnat_dxscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dxscandata_history
    ADD CONSTRAINT xnat_dxscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_dxscandata_meta_data xnat_dxscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dxscandata_meta_data
    ADD CONSTRAINT xnat_dxscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_dxscandata xnat_dxscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dxscandata
    ADD CONSTRAINT xnat_dxscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_dxsessiondata_history xnat_dxsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dxsessiondata_history
    ADD CONSTRAINT xnat_dxsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_dxsessiondata_meta_data xnat_dxsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dxsessiondata_meta_data
    ADD CONSTRAINT xnat_dxsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_dxsessiondata xnat_dxsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_dxsessiondata
    ADD CONSTRAINT xnat_dxsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_ecgscandata_history xnat_ecgscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ecgscandata_history
    ADD CONSTRAINT xnat_ecgscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_ecgscandata_meta_data xnat_ecgscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ecgscandata_meta_data
    ADD CONSTRAINT xnat_ecgscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_ecgscandata xnat_ecgscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ecgscandata
    ADD CONSTRAINT xnat_ecgscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_ecgsessiondata_history xnat_ecgsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ecgsessiondata_history
    ADD CONSTRAINT xnat_ecgsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_ecgsessiondata_meta_data xnat_ecgsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ecgsessiondata_meta_data
    ADD CONSTRAINT xnat_ecgsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_ecgsessiondata xnat_ecgsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ecgsessiondata
    ADD CONSTRAINT xnat_ecgsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_eegscandata_channel_history xnat_eegscandata_channel_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_channel_history
    ADD CONSTRAINT xnat_eegscandata_channel_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_eegscandata_channel_meta_data xnat_eegscandata_channel_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_channel_meta_data
    ADD CONSTRAINT xnat_eegscandata_channel_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_eegscandata_channel xnat_eegscandata_channel_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_channel
    ADD CONSTRAINT xnat_eegscandata_channel_pkey PRIMARY KEY (xnat_eegscandata_channel_id);


--
-- Name: xnat_eegscandata_channel xnat_eegscandata_channel_u_scan_id_fk; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_channel
    ADD CONSTRAINT xnat_eegscandata_channel_u_scan_id_fk UNIQUE (name, channels_channel_xnat_eegscanda_xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_history xnat_eegscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_history
    ADD CONSTRAINT xnat_eegscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_eegscandata_impedance_history xnat_eegscandata_impedance_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_impedance_history
    ADD CONSTRAINT xnat_eegscandata_impedance_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_eegscandata_impedance_meta_data xnat_eegscandata_impedance_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_impedance_meta_data
    ADD CONSTRAINT xnat_eegscandata_impedance_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_eegscandata_impedance xnat_eegscandata_impedance_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_impedance
    ADD CONSTRAINT xnat_eegscandata_impedance_pkey PRIMARY KEY (xnat_eegscandata_impedance_id);


--
-- Name: xnat_eegscandata_impedance xnat_eegscandata_impedance_u_scan_imp_id_fk; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_impedance
    ADD CONSTRAINT xnat_eegscandata_impedance_u_scan_imp_id_fk UNIQUE (name, softwarefiltersimpedances_imped_xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_meta_data xnat_eegscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata_meta_data
    ADD CONSTRAINT xnat_eegscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_eegscandata xnat_eegscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegscandata
    ADD CONSTRAINT xnat_eegscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_eegsessiondata_history xnat_eegsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegsessiondata_history
    ADD CONSTRAINT xnat_eegsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_eegsessiondata_meta_data xnat_eegsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegsessiondata_meta_data
    ADD CONSTRAINT xnat_eegsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_eegsessiondata xnat_eegsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_eegsessiondata
    ADD CONSTRAINT xnat_eegsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_epsscandata_history xnat_epsscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_epsscandata_history
    ADD CONSTRAINT xnat_epsscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_epsscandata_meta_data xnat_epsscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_epsscandata_meta_data
    ADD CONSTRAINT xnat_epsscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_epsscandata xnat_epsscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_epsscandata
    ADD CONSTRAINT xnat_epsscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_epssessiondata_history xnat_epssessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_epssessiondata_history
    ADD CONSTRAINT xnat_epssessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_epssessiondata_meta_data xnat_epssessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_epssessiondata_meta_data
    ADD CONSTRAINT xnat_epssessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_epssessiondata xnat_epssessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_epssessiondata
    ADD CONSTRAINT xnat_epssessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_esscandata_history xnat_esscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esscandata_history
    ADD CONSTRAINT xnat_esscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_esscandata_meta_data xnat_esscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esscandata_meta_data
    ADD CONSTRAINT xnat_esscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_esscandata xnat_esscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esscandata
    ADD CONSTRAINT xnat_esscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_essessiondata_history xnat_essessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_essessiondata_history
    ADD CONSTRAINT xnat_essessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_essessiondata_meta_data xnat_essessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_essessiondata_meta_data
    ADD CONSTRAINT xnat_essessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_essessiondata xnat_essessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_essessiondata
    ADD CONSTRAINT xnat_essessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_esvscandata_history xnat_esvscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esvscandata_history
    ADD CONSTRAINT xnat_esvscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_esvscandata_meta_data xnat_esvscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esvscandata_meta_data
    ADD CONSTRAINT xnat_esvscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_esvscandata xnat_esvscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esvscandata
    ADD CONSTRAINT xnat_esvscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_esvsessiondata_history xnat_esvsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esvsessiondata_history
    ADD CONSTRAINT xnat_esvsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_esvsessiondata_meta_data xnat_esvsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esvsessiondata_meta_data
    ADD CONSTRAINT xnat_esvsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_esvsessiondata xnat_esvsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_esvsessiondata
    ADD CONSTRAINT xnat_esvsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_experimentdata_field_history xnat_experimentdata_field_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_field_history
    ADD CONSTRAINT xnat_experimentdata_field_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_experimentdata_field_meta_data xnat_experimentdata_field_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_field_meta_data
    ADD CONSTRAINT xnat_experimentdata_field_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_experimentdata_field xnat_experimentdata_field_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_field
    ADD CONSTRAINT xnat_experimentdata_field_pkey PRIMARY KEY (xnat_experimentdata_field_id);


--
-- Name: xnat_experimentdata_field xnat_experimentdata_field_u_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_field
    ADD CONSTRAINT xnat_experimentdata_field_u_name UNIQUE (name, fields_field_xnat_experimentdat_id);


--
-- Name: xnat_experimentdata_history xnat_experimentdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_history
    ADD CONSTRAINT xnat_experimentdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_experimentdata_meta_data xnat_experimentdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_meta_data
    ADD CONSTRAINT xnat_experimentdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_experimentdata xnat_experimentdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata
    ADD CONSTRAINT xnat_experimentdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_experimentdata_resource_history xnat_experimentdata_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_resource_history
    ADD CONSTRAINT xnat_experimentdata_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_experimentdata_resource xnat_experimentdata_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_resource
    ADD CONSTRAINT xnat_experimentdata_resource_pkey PRIMARY KEY (xnat_experimentdata_resource_id);


--
-- Name: xnat_experimentdata_share_history xnat_experimentdata_share_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_share_history
    ADD CONSTRAINT xnat_experimentdata_share_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_experimentdata_share_meta_data xnat_experimentdata_share_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_share_meta_data
    ADD CONSTRAINT xnat_experimentdata_share_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_experimentdata_share xnat_experimentdata_share_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_share
    ADD CONSTRAINT xnat_experimentdata_share_pkey PRIMARY KEY (xnat_experimentdata_share_id);


--
-- Name: xnat_experimentdata_share xnat_experimentdata_share_u_project_expt; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata_share
    ADD CONSTRAINT xnat_experimentdata_share_u_project_expt UNIQUE (project, sharing_share_xnat_experimentda_id);


--
-- Name: xnat_experimentdata xnat_experimentdata_u_proj_label; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_experimentdata
    ADD CONSTRAINT xnat_experimentdata_u_proj_label UNIQUE (project, label);


--
-- Name: xnat_fielddefinitiongroup_field_history xnat_fielddefinitiongroup_field_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field_history
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_fielddefinitiongroup_field_meta_data xnat_fielddefinitiongroup_field_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field_meta_data
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_fielddefinitiongroup_field xnat_fielddefinitiongroup_field_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_pkey PRIMARY KEY (xnat_fielddefinitiongroup_field_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_history xnat_fielddefinitiongroup_field_possiblevalue_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field_possiblevalue_history
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_possiblevalue_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_meta_data xnat_fielddefinitiongroup_field_possiblevalue_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_possiblevalue_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue xnat_fielddefinitiongroup_field_possiblevalue_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field_possiblevalue
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_possiblevalue_pkey PRIMARY KEY (xnat_fielddefinitiongroup_field_possiblevalue_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue xnat_fielddefinitiongroup_field_possiblevalue_u_pvalue; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field_possiblevalue
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_possiblevalue_u_pvalue UNIQUE (possiblevalue, possiblevalues_possiblevalue_xn_xnat_fielddefinitiongroup_field);


--
-- Name: xnat_fielddefinitiongroup_field xnat_fielddefinitiongroup_field_u_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_field
    ADD CONSTRAINT xnat_fielddefinitiongroup_field_u_name UNIQUE (name, fields_field_xnat_fielddefiniti_xnat_fielddefinitiongroup_id);


--
-- Name: xnat_fielddefinitiongroup_history xnat_fielddefinitiongroup_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_history
    ADD CONSTRAINT xnat_fielddefinitiongroup_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_fielddefinitiongroup_meta_data xnat_fielddefinitiongroup_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup_meta_data
    ADD CONSTRAINT xnat_fielddefinitiongroup_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_fielddefinitiongroup xnat_fielddefinitiongroup_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup
    ADD CONSTRAINT xnat_fielddefinitiongroup_pkey PRIMARY KEY (xnat_fielddefinitiongroup_id);


--
-- Name: xnat_fielddefinitiongroup xnat_fielddefinitiongroup_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_fielddefinitiongroup
    ADD CONSTRAINT xnat_fielddefinitiongroup_u_true UNIQUE (id, data_type);


--
-- Name: xnat_genericdata_history xnat_genericdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_genericdata_history
    ADD CONSTRAINT xnat_genericdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_genericdata_meta_data xnat_genericdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_genericdata_meta_data
    ADD CONSTRAINT xnat_genericdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_genericdata xnat_genericdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_genericdata
    ADD CONSTRAINT xnat_genericdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_gmscandata_history xnat_gmscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmscandata_history
    ADD CONSTRAINT xnat_gmscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_gmscandata_meta_data xnat_gmscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmscandata_meta_data
    ADD CONSTRAINT xnat_gmscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_gmscandata xnat_gmscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmscandata
    ADD CONSTRAINT xnat_gmscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_gmsessiondata_history xnat_gmsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmsessiondata_history
    ADD CONSTRAINT xnat_gmsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_gmsessiondata_meta_data xnat_gmsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmsessiondata_meta_data
    ADD CONSTRAINT xnat_gmsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_gmsessiondata xnat_gmsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmsessiondata
    ADD CONSTRAINT xnat_gmsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_gmvscandata_history xnat_gmvscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmvscandata_history
    ADD CONSTRAINT xnat_gmvscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_gmvscandata_meta_data xnat_gmvscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmvscandata_meta_data
    ADD CONSTRAINT xnat_gmvscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_gmvscandata xnat_gmvscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmvscandata
    ADD CONSTRAINT xnat_gmvscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_gmvsessiondata_history xnat_gmvsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmvsessiondata_history
    ADD CONSTRAINT xnat_gmvsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_gmvsessiondata_meta_data xnat_gmvsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmvsessiondata_meta_data
    ADD CONSTRAINT xnat_gmvsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_gmvsessiondata xnat_gmvsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_gmvsessiondata
    ADD CONSTRAINT xnat_gmvsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_hdscandata_history xnat_hdscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_hdscandata_history
    ADD CONSTRAINT xnat_hdscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_hdscandata_meta_data xnat_hdscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_hdscandata_meta_data
    ADD CONSTRAINT xnat_hdscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_hdscandata xnat_hdscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_hdscandata
    ADD CONSTRAINT xnat_hdscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_hdsessiondata_history xnat_hdsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_hdsessiondata_history
    ADD CONSTRAINT xnat_hdsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_hdsessiondata_meta_data xnat_hdsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_hdsessiondata_meta_data
    ADD CONSTRAINT xnat_hdsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_hdsessiondata xnat_hdsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_hdsessiondata
    ADD CONSTRAINT xnat_hdsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_imageassessordata_history xnat_imageassessordata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageassessordata_history
    ADD CONSTRAINT xnat_imageassessordata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_imageassessordata_meta_data xnat_imageassessordata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageassessordata_meta_data
    ADD CONSTRAINT xnat_imageassessordata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_imageassessordata xnat_imageassessordata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageassessordata
    ADD CONSTRAINT xnat_imageassessordata_pkey PRIMARY KEY (id);


--
-- Name: xnat_imageresource_history xnat_imageresource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageresource_history
    ADD CONSTRAINT xnat_imageresource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_imageresource_meta_data xnat_imageresource_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageresource_meta_data
    ADD CONSTRAINT xnat_imageresource_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_imageresource xnat_imageresource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageresource
    ADD CONSTRAINT xnat_imageresource_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_imageresourceseries_history xnat_imageresourceseries_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageresourceseries_history
    ADD CONSTRAINT xnat_imageresourceseries_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_imageresourceseries_meta_data xnat_imageresourceseries_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageresourceseries_meta_data
    ADD CONSTRAINT xnat_imageresourceseries_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_imageresourceseries xnat_imageresourceseries_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imageresourceseries
    ADD CONSTRAINT xnat_imageresourceseries_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_imagescandata_history xnat_imagescandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata_history
    ADD CONSTRAINT xnat_imagescandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_imagescandata_meta_data xnat_imagescandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata_meta_data
    ADD CONSTRAINT xnat_imagescandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_imagescandata xnat_imagescandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata
    ADD CONSTRAINT xnat_imagescandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_imagescandata_share_history xnat_imagescandata_share_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata_share_history
    ADD CONSTRAINT xnat_imagescandata_share_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_imagescandata_share_meta_data xnat_imagescandata_share_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata_share_meta_data
    ADD CONSTRAINT xnat_imagescandata_share_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_imagescandata_share xnat_imagescandata_share_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata_share
    ADD CONSTRAINT xnat_imagescandata_share_pkey PRIMARY KEY (xnat_imagescandata_share_id);


--
-- Name: xnat_imagescandata_share xnat_imagescandata_share_u_project_scan; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata_share
    ADD CONSTRAINT xnat_imagescandata_share_u_project_scan UNIQUE (project, sharing_share_xnat_imagescandat_xnat_imagescandata_id);


--
-- Name: xnat_imagescandata xnat_imagescandata_u_mr_id_fk; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagescandata
    ADD CONSTRAINT xnat_imagescandata_u_mr_id_fk UNIQUE (image_session_id, id);


--
-- Name: xnat_imagesessiondata_history xnat_imagesessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagesessiondata_history
    ADD CONSTRAINT xnat_imagesessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_imagesessiondata_meta_data xnat_imagesessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagesessiondata_meta_data
    ADD CONSTRAINT xnat_imagesessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_imagesessiondata xnat_imagesessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_imagesessiondata
    ADD CONSTRAINT xnat_imagesessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_investigatordata_history xnat_investigatordata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_investigatordata_history
    ADD CONSTRAINT xnat_investigatordata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_investigatordata_meta_data xnat_investigatordata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_investigatordata_meta_data
    ADD CONSTRAINT xnat_investigatordata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_investigatordata xnat_investigatordata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_investigatordata
    ADD CONSTRAINT xnat_investigatordata_pkey PRIMARY KEY (xnat_investigatordata_id);


--
-- Name: xnat_investigatordata xnat_investigatordata_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_investigatordata
    ADD CONSTRAINT xnat_investigatordata_u_true UNIQUE (firstname, lastname);


--
-- Name: xnat_ioscandata_history xnat_ioscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ioscandata_history
    ADD CONSTRAINT xnat_ioscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_ioscandata_meta_data xnat_ioscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ioscandata_meta_data
    ADD CONSTRAINT xnat_ioscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_ioscandata xnat_ioscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ioscandata
    ADD CONSTRAINT xnat_ioscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_iosessiondata_history xnat_iosessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_iosessiondata_history
    ADD CONSTRAINT xnat_iosessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_iosessiondata_meta_data xnat_iosessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_iosessiondata_meta_data
    ADD CONSTRAINT xnat_iosessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_iosessiondata xnat_iosessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_iosessiondata
    ADD CONSTRAINT xnat_iosessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_megscandata_history xnat_megscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_megscandata_history
    ADD CONSTRAINT xnat_megscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_megscandata_meta_data xnat_megscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_megscandata_meta_data
    ADD CONSTRAINT xnat_megscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_megscandata xnat_megscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_megscandata
    ADD CONSTRAINT xnat_megscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_megsessiondata_history xnat_megsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_megsessiondata_history
    ADD CONSTRAINT xnat_megsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_megsessiondata_meta_data xnat_megsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_megsessiondata_meta_data
    ADD CONSTRAINT xnat_megsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_megsessiondata xnat_megsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_megsessiondata
    ADD CONSTRAINT xnat_megsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_mgscandata_history xnat_mgscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mgscandata_history
    ADD CONSTRAINT xnat_mgscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_mgscandata_meta_data xnat_mgscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mgscandata_meta_data
    ADD CONSTRAINT xnat_mgscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_mgscandata xnat_mgscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mgscandata
    ADD CONSTRAINT xnat_mgscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_mgsessiondata_history xnat_mgsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mgsessiondata_history
    ADD CONSTRAINT xnat_mgsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_mgsessiondata_meta_data xnat_mgsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mgsessiondata_meta_data
    ADD CONSTRAINT xnat_mgsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_mgsessiondata xnat_mgsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mgsessiondata
    ADD CONSTRAINT xnat_mgsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_mrassessordata_history xnat_mrassessordata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrassessordata_history
    ADD CONSTRAINT xnat_mrassessordata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_mrassessordata_meta_data xnat_mrassessordata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrassessordata_meta_data
    ADD CONSTRAINT xnat_mrassessordata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_mrassessordata xnat_mrassessordata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrassessordata
    ADD CONSTRAINT xnat_mrassessordata_pkey PRIMARY KEY (id);


--
-- Name: xnat_mrqcscandata_history xnat_mrqcscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrqcscandata_history
    ADD CONSTRAINT xnat_mrqcscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_mrqcscandata_meta_data xnat_mrqcscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrqcscandata_meta_data
    ADD CONSTRAINT xnat_mrqcscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_mrqcscandata xnat_mrqcscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrqcscandata
    ADD CONSTRAINT xnat_mrqcscandata_pkey PRIMARY KEY (xnat_qcscandata_id);


--
-- Name: xnat_mrscandata_history xnat_mrscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrscandata_history
    ADD CONSTRAINT xnat_mrscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_mrscandata_meta_data xnat_mrscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrscandata_meta_data
    ADD CONSTRAINT xnat_mrscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_mrscandata xnat_mrscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrscandata
    ADD CONSTRAINT xnat_mrscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_mrsessiondata_history xnat_mrsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrsessiondata_history
    ADD CONSTRAINT xnat_mrsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_mrsessiondata_meta_data xnat_mrsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrsessiondata_meta_data
    ADD CONSTRAINT xnat_mrsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_mrsessiondata xnat_mrsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrsessiondata
    ADD CONSTRAINT xnat_mrsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_mrsscandata_history xnat_mrsscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrsscandata_history
    ADD CONSTRAINT xnat_mrsscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_mrsscandata_meta_data xnat_mrsscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrsscandata_meta_data
    ADD CONSTRAINT xnat_mrsscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_mrsscandata xnat_mrsscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_mrsscandata
    ADD CONSTRAINT xnat_mrsscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_nmscandata_history xnat_nmscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_nmscandata_history
    ADD CONSTRAINT xnat_nmscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_nmscandata_meta_data xnat_nmscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_nmscandata_meta_data
    ADD CONSTRAINT xnat_nmscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_nmscandata xnat_nmscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_nmscandata
    ADD CONSTRAINT xnat_nmscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_nmsessiondata_history xnat_nmsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_nmsessiondata_history
    ADD CONSTRAINT xnat_nmsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_nmsessiondata_meta_data xnat_nmsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_nmsessiondata_meta_data
    ADD CONSTRAINT xnat_nmsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_nmsessiondata xnat_nmsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_nmsessiondata
    ADD CONSTRAINT xnat_nmsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_opscandata_history xnat_opscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_opscandata_history
    ADD CONSTRAINT xnat_opscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_opscandata_meta_data xnat_opscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_opscandata_meta_data
    ADD CONSTRAINT xnat_opscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_opscandata xnat_opscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_opscandata
    ADD CONSTRAINT xnat_opscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_opsessiondata_history xnat_opsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_opsessiondata_history
    ADD CONSTRAINT xnat_opsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_opsessiondata_meta_data xnat_opsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_opsessiondata_meta_data
    ADD CONSTRAINT xnat_opsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_opsessiondata xnat_opsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_opsessiondata
    ADD CONSTRAINT xnat_opsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_optscandata_history xnat_optscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_optscandata_history
    ADD CONSTRAINT xnat_optscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_optscandata_meta_data xnat_optscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_optscandata_meta_data
    ADD CONSTRAINT xnat_optscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_optscandata xnat_optscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_optscandata
    ADD CONSTRAINT xnat_optscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_optsessiondata_history xnat_optsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_optsessiondata_history
    ADD CONSTRAINT xnat_optsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_optsessiondata_meta_data xnat_optsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_optsessiondata_meta_data
    ADD CONSTRAINT xnat_optsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_optsessiondata xnat_optsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_optsessiondata
    ADD CONSTRAINT xnat_optsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_otherdicomscandata_history xnat_otherdicomscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherdicomscandata_history
    ADD CONSTRAINT xnat_otherdicomscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_otherdicomscandata_meta_data xnat_otherdicomscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherdicomscandata_meta_data
    ADD CONSTRAINT xnat_otherdicomscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_otherdicomscandata xnat_otherdicomscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherdicomscandata
    ADD CONSTRAINT xnat_otherdicomscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_otherdicomsessiondata_history xnat_otherdicomsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherdicomsessiondata_history
    ADD CONSTRAINT xnat_otherdicomsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_otherdicomsessiondata_meta_data xnat_otherdicomsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherdicomsessiondata_meta_data
    ADD CONSTRAINT xnat_otherdicomsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_otherdicomsessiondata xnat_otherdicomsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherdicomsessiondata
    ADD CONSTRAINT xnat_otherdicomsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_otherqcscandata_history xnat_otherqcscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherqcscandata_history
    ADD CONSTRAINT xnat_otherqcscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_otherqcscandata_meta_data xnat_otherqcscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherqcscandata_meta_data
    ADD CONSTRAINT xnat_otherqcscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_otherqcscandata xnat_otherqcscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_otherqcscandata
    ADD CONSTRAINT xnat_otherqcscandata_pkey PRIMARY KEY (xnat_qcscandata_id);


--
-- Name: xnat_petassessordata_history xnat_petassessordata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petassessordata_history
    ADD CONSTRAINT xnat_petassessordata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_petassessordata_meta_data xnat_petassessordata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petassessordata_meta_data
    ADD CONSTRAINT xnat_petassessordata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_petassessordata xnat_petassessordata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petassessordata
    ADD CONSTRAINT xnat_petassessordata_pkey PRIMARY KEY (id);


--
-- Name: xnat_petmrsessiondata_history xnat_petmrsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petmrsessiondata_history
    ADD CONSTRAINT xnat_petmrsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_petmrsessiondata_meta_data xnat_petmrsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petmrsessiondata_meta_data
    ADD CONSTRAINT xnat_petmrsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_petmrsessiondata xnat_petmrsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petmrsessiondata
    ADD CONSTRAINT xnat_petmrsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_petqcscandata_history xnat_petqcscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petqcscandata_history
    ADD CONSTRAINT xnat_petqcscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_petqcscandata_meta_data xnat_petqcscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petqcscandata_meta_data
    ADD CONSTRAINT xnat_petqcscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_petqcscandata xnat_petqcscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petqcscandata
    ADD CONSTRAINT xnat_petqcscandata_pkey PRIMARY KEY (xnat_qcscandata_id);


--
-- Name: xnat_petqcscandata_processingerror_history xnat_petqcscandata_processingerror_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petqcscandata_processingerror_history
    ADD CONSTRAINT xnat_petqcscandata_processingerror_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_petqcscandata_processingerror_meta_data xnat_petqcscandata_processingerror_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petqcscandata_processingerror_meta_data
    ADD CONSTRAINT xnat_petqcscandata_processingerror_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_petqcscandata_processingerror xnat_petqcscandata_processingerror_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petqcscandata_processingerror
    ADD CONSTRAINT xnat_petqcscandata_processingerror_pkey PRIMARY KEY (xnat_petqcscandata_processingerror_id);


--
-- Name: xnat_petqcscandata_processingerror xnat_petqcscandata_processingerror_u_qc_processing_error_fk; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petqcscandata_processingerror
    ADD CONSTRAINT xnat_petqcscandata_processingerror_u_qc_processing_error_fk UNIQUE (processingerror, processingerrors_processingerro_xnat_qcscandata_id);


--
-- Name: xnat_petscandata_frame_history xnat_petscandata_frame_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petscandata_frame_history
    ADD CONSTRAINT xnat_petscandata_frame_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_petscandata_frame_meta_data xnat_petscandata_frame_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petscandata_frame_meta_data
    ADD CONSTRAINT xnat_petscandata_frame_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_petscandata_frame xnat_petscandata_frame_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petscandata_frame
    ADD CONSTRAINT xnat_petscandata_frame_pkey PRIMARY KEY (xnat_petscandata_frame_id);


--
-- Name: xnat_petscandata_frame xnat_petscandata_frame_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petscandata_frame
    ADD CONSTRAINT xnat_petscandata_frame_u_true UNIQUE (number, parameters_frames_frame_xnat_pe_xnat_imagescandata_id);


--
-- Name: xnat_petscandata_history xnat_petscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petscandata_history
    ADD CONSTRAINT xnat_petscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_petscandata_meta_data xnat_petscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petscandata_meta_data
    ADD CONSTRAINT xnat_petscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_petscandata xnat_petscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petscandata
    ADD CONSTRAINT xnat_petscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_petsessiondata_history xnat_petsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petsessiondata_history
    ADD CONSTRAINT xnat_petsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_petsessiondata_meta_data xnat_petsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petsessiondata_meta_data
    ADD CONSTRAINT xnat_petsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_petsessiondata xnat_petsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_petsessiondata
    ADD CONSTRAINT xnat_petsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_projectdata_alias_history xnat_projectdata_alias_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_alias_history
    ADD CONSTRAINT xnat_projectdata_alias_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_projectdata_alias_meta_data xnat_projectdata_alias_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_alias_meta_data
    ADD CONSTRAINT xnat_projectdata_alias_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_projectdata_alias xnat_projectdata_alias_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_alias
    ADD CONSTRAINT xnat_projectdata_alias_pkey PRIMARY KEY (xnat_projectdata_alias_id);


--
-- Name: xnat_projectdata_alias xnat_projectdata_alias_u_value; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_alias
    ADD CONSTRAINT xnat_projectdata_alias_u_value UNIQUE (alias, aliases_alias_xnat_projectdata_id);


--
-- Name: xnat_projectdata_field_history xnat_projectdata_field_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_field_history
    ADD CONSTRAINT xnat_projectdata_field_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_projectdata_field_meta_data xnat_projectdata_field_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_field_meta_data
    ADD CONSTRAINT xnat_projectdata_field_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_projectdata_field xnat_projectdata_field_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_field
    ADD CONSTRAINT xnat_projectdata_field_pkey PRIMARY KEY (xnat_projectdata_field_id);


--
-- Name: xnat_projectdata_field xnat_projectdata_field_u_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_field
    ADD CONSTRAINT xnat_projectdata_field_u_name UNIQUE (name, fields_field_xnat_projectdata_id);


--
-- Name: xnat_projectdata_history xnat_projectdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_history
    ADD CONSTRAINT xnat_projectdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_projectdata_investigator_history xnat_projectdata_investigator_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_investigator_history
    ADD CONSTRAINT xnat_projectdata_investigator_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_projectdata_investigator xnat_projectdata_investigator_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_investigator
    ADD CONSTRAINT xnat_projectdata_investigator_pkey PRIMARY KEY (xnat_projectdata_investigator_id);


--
-- Name: xnat_projectdata_meta_data xnat_projectdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_meta_data
    ADD CONSTRAINT xnat_projectdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_projectdata xnat_projectdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata
    ADD CONSTRAINT xnat_projectdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_projectdata_resource_history xnat_projectdata_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_resource_history
    ADD CONSTRAINT xnat_projectdata_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_projectdata_resource xnat_projectdata_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectdata_resource
    ADD CONSTRAINT xnat_projectdata_resource_pkey PRIMARY KEY (xnat_projectdata_resource_id);


--
-- Name: xnat_projectparticipant_history xnat_projectparticipant_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectparticipant_history
    ADD CONSTRAINT xnat_projectparticipant_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_projectparticipant_meta_data xnat_projectparticipant_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectparticipant_meta_data
    ADD CONSTRAINT xnat_projectparticipant_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_projectparticipant xnat_projectparticipant_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectparticipant
    ADD CONSTRAINT xnat_projectparticipant_pkey PRIMARY KEY (xnat_projectparticipant_id);


--
-- Name: xnat_projectparticipant xnat_projectparticipant_u_proj_subj; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_projectparticipant
    ADD CONSTRAINT xnat_projectparticipant_u_proj_subj UNIQUE (project, subject_id);


--
-- Name: xnat_publicationresource_history xnat_publicationresource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource_history
    ADD CONSTRAINT xnat_publicationresource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_publicationresource_meta_data xnat_publicationresource_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource_meta_data
    ADD CONSTRAINT xnat_publicationresource_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_publicationresource xnat_publicationresource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource
    ADD CONSTRAINT xnat_publicationresource_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_publicationresource xnat_publicationresource_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource
    ADD CONSTRAINT xnat_publicationresource_u_1 UNIQUE (title);


--
-- Name: xnat_publicationresource xnat_publicationresource_u_2; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource
    ADD CONSTRAINT xnat_publicationresource_u_2 UNIQUE (doi);


--
-- Name: xnat_publicationresource xnat_publicationresource_u_3; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource
    ADD CONSTRAINT xnat_publicationresource_u_3 UNIQUE (pubmed);


--
-- Name: xnat_publicationresource xnat_publicationresource_u_4; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource
    ADD CONSTRAINT xnat_publicationresource_u_4 UNIQUE (medline);


--
-- Name: xnat_publicationresource xnat_publicationresource_u_5; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_publicationresource
    ADD CONSTRAINT xnat_publicationresource_u_5 UNIQUE (uri);


--
-- Name: xnat_pvisitdata_history xnat_pvisitdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_pvisitdata_history
    ADD CONSTRAINT xnat_pvisitdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_pvisitdata_meta_data xnat_pvisitdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_pvisitdata_meta_data
    ADD CONSTRAINT xnat_pvisitdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_pvisitdata xnat_pvisitdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_pvisitdata
    ADD CONSTRAINT xnat_pvisitdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_qcassessmentdata_history xnat_qcassessmentdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_history
    ADD CONSTRAINT xnat_qcassessmentdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_qcassessmentdata_meta_data xnat_qcassessmentdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_meta_data
    ADD CONSTRAINT xnat_qcassessmentdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_qcassessmentdata xnat_qcassessmentdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata
    ADD CONSTRAINT xnat_qcassessmentdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_qcassessmentdata_scan_history xnat_qcassessmentdata_scan_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan_history
    ADD CONSTRAINT xnat_qcassessmentdata_scan_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_qcassessmentdata_scan_meta_data xnat_qcassessmentdata_scan_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan_meta_data
    ADD CONSTRAINT xnat_qcassessmentdata_scan_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_qcassessmentdata_scan xnat_qcassessmentdata_scan_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan
    ADD CONSTRAINT xnat_qcassessmentdata_scan_pkey PRIMARY KEY (xnat_qcassessmentdata_scan_id);


--
-- Name: xnat_qcassessmentdata_scan_slice_history xnat_qcassessmentdata_scan_slice_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan_slice_history
    ADD CONSTRAINT xnat_qcassessmentdata_scan_slice_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_qcassessmentdata_scan_slice_meta_data xnat_qcassessmentdata_scan_slice_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan_slice_meta_data
    ADD CONSTRAINT xnat_qcassessmentdata_scan_slice_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_qcassessmentdata_scan_slice xnat_qcassessmentdata_scan_slice_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan_slice
    ADD CONSTRAINT xnat_qcassessmentdata_scan_slice_pkey PRIMARY KEY (xnat_qcassessmentdata_scan_slice_id);


--
-- Name: xnat_qcassessmentdata_scan_slice xnat_qcassessmentdata_scan_slice_u_slice_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan_slice
    ADD CONSTRAINT xnat_qcassessmentdata_scan_slice_u_slice_id UNIQUE (number, sliceqc_slice_xnat_qcassessment_xnat_qcassessmentdata_scan_id);


--
-- Name: xnat_qcassessmentdata_scan xnat_qcassessmentdata_scan_u_assessor_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcassessmentdata_scan
    ADD CONSTRAINT xnat_qcassessmentdata_scan_u_assessor_id UNIQUE (id, scans_scan_xnat_qcassessmentdat_id);


--
-- Name: xnat_qcmanualassessordata_history xnat_qcmanualassessordata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcmanualassessordata_history
    ADD CONSTRAINT xnat_qcmanualassessordata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_qcmanualassessordata_meta_data xnat_qcmanualassessordata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcmanualassessordata_meta_data
    ADD CONSTRAINT xnat_qcmanualassessordata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_qcmanualassessordata xnat_qcmanualassessordata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcmanualassessordata
    ADD CONSTRAINT xnat_qcmanualassessordata_pkey PRIMARY KEY (id);


--
-- Name: xnat_qcscandata_field_history xnat_qcscandata_field_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata_field_history
    ADD CONSTRAINT xnat_qcscandata_field_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_qcscandata_field_meta_data xnat_qcscandata_field_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata_field_meta_data
    ADD CONSTRAINT xnat_qcscandata_field_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_qcscandata_field xnat_qcscandata_field_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata_field
    ADD CONSTRAINT xnat_qcscandata_field_pkey PRIMARY KEY (xnat_qcscandata_field_id);


--
-- Name: xnat_qcscandata_field xnat_qcscandata_field_u_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata_field
    ADD CONSTRAINT xnat_qcscandata_field_u_name UNIQUE (name, fields_field_xnat_qcscandata_xnat_qcscandata_id);


--
-- Name: xnat_qcscandata_history xnat_qcscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata_history
    ADD CONSTRAINT xnat_qcscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_qcscandata_meta_data xnat_qcscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata_meta_data
    ADD CONSTRAINT xnat_qcscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_qcscandata xnat_qcscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata
    ADD CONSTRAINT xnat_qcscandata_pkey PRIMARY KEY (xnat_qcscandata_id);


--
-- Name: xnat_qcscandata xnat_qcscandata_u_qc_scan_id_fk; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_qcscandata
    ADD CONSTRAINT xnat_qcscandata_u_qc_scan_id_fk UNIQUE (imagescan_id, scans_scan_xnat_qcmanualassesso_id);


--
-- Name: xnat_reconstructedimagedata_history xnat_reconstructedimagedata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata_history
    ADD CONSTRAINT xnat_reconstructedimagedata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_reconstructedimagedata_meta_data xnat_reconstructedimagedata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata_meta_data
    ADD CONSTRAINT xnat_reconstructedimagedata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_reconstructedimagedata xnat_reconstructedimagedata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata
    ADD CONSTRAINT xnat_reconstructedimagedata_pkey PRIMARY KEY (xnat_reconstructedimagedata_id);


--
-- Name: xnat_reconstructedimagedata_scanid_history xnat_reconstructedimagedata_scanid_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata_scanid_history
    ADD CONSTRAINT xnat_reconstructedimagedata_scanid_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_reconstructedimagedata_scanid_meta_data xnat_reconstructedimagedata_scanid_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata_scanid_meta_data
    ADD CONSTRAINT xnat_reconstructedimagedata_scanid_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_reconstructedimagedata_scanid xnat_reconstructedimagedata_scanid_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata_scanid
    ADD CONSTRAINT xnat_reconstructedimagedata_scanid_pkey PRIMARY KEY (xnat_reconstructedimagedata_scanid_id);


--
-- Name: xnat_reconstructedimagedata_scanid xnat_reconstructedimagedata_scanid_u_in_scan; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata_scanid
    ADD CONSTRAINT xnat_reconstructedimagedata_scanid_u_in_scan UNIQUE (scanid, inscans_scanid_xnat_reconstruct_xnat_reconstructedimagedata_id);


--
-- Name: xnat_reconstructedimagedata xnat_reconstructedimagedata_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_reconstructedimagedata
    ADD CONSTRAINT xnat_reconstructedimagedata_u_1 UNIQUE (id);


--
-- Name: xnat_regionresource_history xnat_regionresource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource_history
    ADD CONSTRAINT xnat_regionresource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_regionresource_label_history xnat_regionresource_label_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource_label_history
    ADD CONSTRAINT xnat_regionresource_label_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_regionresource_label_meta_data xnat_regionresource_label_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource_label_meta_data
    ADD CONSTRAINT xnat_regionresource_label_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_regionresource_label xnat_regionresource_label_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource_label
    ADD CONSTRAINT xnat_regionresource_label_pkey PRIMARY KEY (xnat_regionresource_label_id);


--
-- Name: xnat_regionresource_label xnat_regionresource_label_u_unique_region; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource_label
    ADD CONSTRAINT xnat_regionresource_label_u_unique_region UNIQUE (id, subregionlabels_label_xnat_regi_xnat_regionresource_id);


--
-- Name: xnat_regionresource_meta_data xnat_regionresource_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource_meta_data
    ADD CONSTRAINT xnat_regionresource_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_regionresource xnat_regionresource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource
    ADD CONSTRAINT xnat_regionresource_pkey PRIMARY KEY (xnat_regionresource_id);


--
-- Name: xnat_regionresource xnat_regionresource_u_session; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_regionresource
    ADD CONSTRAINT xnat_regionresource_u_session UNIQUE (creator_firstname, creator_lastname, name, hemisphere, session_id);


--
-- Name: xnat_resource_history xnat_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resource_history
    ADD CONSTRAINT xnat_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_resource_meta_data xnat_resource_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resource_meta_data
    ADD CONSTRAINT xnat_resource_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_resource xnat_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resource
    ADD CONSTRAINT xnat_resource_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_resource xnat_resource_u_1; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resource
    ADD CONSTRAINT xnat_resource_u_1 UNIQUE (uri);


--
-- Name: xnat_resourcecatalog_history xnat_resourcecatalog_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resourcecatalog_history
    ADD CONSTRAINT xnat_resourcecatalog_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_resourcecatalog_meta_data xnat_resourcecatalog_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resourcecatalog_meta_data
    ADD CONSTRAINT xnat_resourcecatalog_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_resourcecatalog xnat_resourcecatalog_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resourcecatalog
    ADD CONSTRAINT xnat_resourcecatalog_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_resourceseries_history xnat_resourceseries_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resourceseries_history
    ADD CONSTRAINT xnat_resourceseries_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_resourceseries_meta_data xnat_resourceseries_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resourceseries_meta_data
    ADD CONSTRAINT xnat_resourceseries_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_resourceseries xnat_resourceseries_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resourceseries
    ADD CONSTRAINT xnat_resourceseries_pkey PRIMARY KEY (xnat_abstractresource_id);


--
-- Name: xnat_resourceseries xnat_resourceseries_u_pattern_path; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_resourceseries
    ADD CONSTRAINT xnat_resourceseries_u_pattern_path UNIQUE (path, pattern);


--
-- Name: xnat_rfscandata_history xnat_rfscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rfscandata_history
    ADD CONSTRAINT xnat_rfscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_rfscandata_meta_data xnat_rfscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rfscandata_meta_data
    ADD CONSTRAINT xnat_rfscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_rfscandata xnat_rfscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rfscandata
    ADD CONSTRAINT xnat_rfscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_rfsessiondata_history xnat_rfsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rfsessiondata_history
    ADD CONSTRAINT xnat_rfsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_rfsessiondata_meta_data xnat_rfsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rfsessiondata_meta_data
    ADD CONSTRAINT xnat_rfsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_rfsessiondata xnat_rfsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rfsessiondata
    ADD CONSTRAINT xnat_rfsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_rtimagescandata_history xnat_rtimagescandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rtimagescandata_history
    ADD CONSTRAINT xnat_rtimagescandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_rtimagescandata_meta_data xnat_rtimagescandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rtimagescandata_meta_data
    ADD CONSTRAINT xnat_rtimagescandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_rtimagescandata xnat_rtimagescandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rtimagescandata
    ADD CONSTRAINT xnat_rtimagescandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_rtsessiondata_history xnat_rtsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rtsessiondata_history
    ADD CONSTRAINT xnat_rtsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_rtsessiondata_meta_data xnat_rtsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rtsessiondata_meta_data
    ADD CONSTRAINT xnat_rtsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_rtsessiondata xnat_rtsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_rtsessiondata
    ADD CONSTRAINT xnat_rtsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_scscandata_history xnat_scscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_scscandata_history
    ADD CONSTRAINT xnat_scscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_scscandata_meta_data xnat_scscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_scscandata_meta_data
    ADD CONSTRAINT xnat_scscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_scscandata xnat_scscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_scscandata
    ADD CONSTRAINT xnat_scscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_segscandata_history xnat_segscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_segscandata_history
    ADD CONSTRAINT xnat_segscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_segscandata_meta_data xnat_segscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_segscandata_meta_data
    ADD CONSTRAINT xnat_segscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_segscandata xnat_segscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_segscandata
    ADD CONSTRAINT xnat_segscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_smscandata_history xnat_smscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_smscandata_history
    ADD CONSTRAINT xnat_smscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_smscandata_meta_data xnat_smscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_smscandata_meta_data
    ADD CONSTRAINT xnat_smscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_smscandata xnat_smscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_smscandata
    ADD CONSTRAINT xnat_smscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_smsessiondata_history xnat_smsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_smsessiondata_history
    ADD CONSTRAINT xnat_smsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_smsessiondata_meta_data xnat_smsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_smsessiondata_meta_data
    ADD CONSTRAINT xnat_smsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_smsessiondata xnat_smsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_smsessiondata
    ADD CONSTRAINT xnat_smsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_srscandata_history xnat_srscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_srscandata_history
    ADD CONSTRAINT xnat_srscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_srscandata_meta_data xnat_srscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_srscandata_meta_data
    ADD CONSTRAINT xnat_srscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_srscandata xnat_srscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_srscandata
    ADD CONSTRAINT xnat_srscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_srsessiondata_history xnat_srsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_srsessiondata_history
    ADD CONSTRAINT xnat_srsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_srsessiondata_meta_data xnat_srsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_srsessiondata_meta_data
    ADD CONSTRAINT xnat_srsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_srsessiondata xnat_srsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_srsessiondata
    ADD CONSTRAINT xnat_srsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_statisticsdata_addfield_history xnat_statisticsdata_addfield_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_addfield_history
    ADD CONSTRAINT xnat_statisticsdata_addfield_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_statisticsdata_addfield_meta_data xnat_statisticsdata_addfield_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_addfield_meta_data
    ADD CONSTRAINT xnat_statisticsdata_addfield_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_statisticsdata_addfield xnat_statisticsdata_addfield_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_addfield
    ADD CONSTRAINT xnat_statisticsdata_addfield_pkey PRIMARY KEY (xnat_statisticsdata_addfield_id);


--
-- Name: xnat_statisticsdata_addfield xnat_statisticsdata_addfield_u_add_field_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_addfield
    ADD CONSTRAINT xnat_statisticsdata_addfield_u_add_field_name UNIQUE (name, xnat_statisticsdata_xnat_abstractstatistics_id);


--
-- Name: xnat_statisticsdata_additionalstatistics_history xnat_statisticsdata_additionalstatistics_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_additionalstatistics_history
    ADD CONSTRAINT xnat_statisticsdata_additionalstatistics_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_statisticsdata_additionalstatistics_meta_data xnat_statisticsdata_additionalstatistics_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_additionalstatistics_meta_data
    ADD CONSTRAINT xnat_statisticsdata_additionalstatistics_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_statisticsdata_additionalstatistics xnat_statisticsdata_additionalstatistics_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_additionalstatistics
    ADD CONSTRAINT xnat_statisticsdata_additionalstatistics_pkey PRIMARY KEY (xnat_statisticsdata_additionalstatistics_id);


--
-- Name: xnat_statisticsdata_additionalstatistics xnat_statisticsdata_additionalstatistics_u_add_stat_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_additionalstatistics
    ADD CONSTRAINT xnat_statisticsdata_additionalstatistics_u_add_stat_name UNIQUE (name, xnat_statisticsdata_xnat_abstractstatistics_id);


--
-- Name: xnat_statisticsdata_history xnat_statisticsdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_history
    ADD CONSTRAINT xnat_statisticsdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_statisticsdata_meta_data xnat_statisticsdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata_meta_data
    ADD CONSTRAINT xnat_statisticsdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_statisticsdata xnat_statisticsdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_statisticsdata
    ADD CONSTRAINT xnat_statisticsdata_pkey PRIMARY KEY (xnat_abstractstatistics_id);


--
-- Name: xnat_studyprotocol_condition_history xnat_studyprotocol_condition_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_condition_history
    ADD CONSTRAINT xnat_studyprotocol_condition_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_studyprotocol_condition_meta_data xnat_studyprotocol_condition_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_condition_meta_data
    ADD CONSTRAINT xnat_studyprotocol_condition_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_studyprotocol_condition xnat_studyprotocol_condition_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_condition
    ADD CONSTRAINT xnat_studyprotocol_condition_pkey PRIMARY KEY (xnat_studyprotocol_condition_id);


--
-- Name: xnat_studyprotocol_condition xnat_studyprotocol_condition_u_fk_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_condition
    ADD CONSTRAINT xnat_studyprotocol_condition_u_fk_id UNIQUE (id, acqconditions_condition_xnat_st_xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_condition xnat_studyprotocol_condition_u_fk_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_condition
    ADD CONSTRAINT xnat_studyprotocol_condition_u_fk_name UNIQUE (name, acqconditions_condition_xnat_st_xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_group_history xnat_studyprotocol_group_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_group_history
    ADD CONSTRAINT xnat_studyprotocol_group_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_studyprotocol_group_meta_data xnat_studyprotocol_group_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_group_meta_data
    ADD CONSTRAINT xnat_studyprotocol_group_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_studyprotocol_group xnat_studyprotocol_group_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_group
    ADD CONSTRAINT xnat_studyprotocol_group_pkey PRIMARY KEY (xnat_studyprotocol_group_id);


--
-- Name: xnat_studyprotocol_group xnat_studyprotocol_group_u_fk_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_group
    ADD CONSTRAINT xnat_studyprotocol_group_u_fk_id UNIQUE (id, subjectgroups_group_xnat_studyp_xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_group xnat_studyprotocol_group_u_fk_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_group
    ADD CONSTRAINT xnat_studyprotocol_group_u_fk_name UNIQUE (name, subjectgroups_group_xnat_studyp_xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_history xnat_studyprotocol_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_history
    ADD CONSTRAINT xnat_studyprotocol_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_studyprotocol_meta_data xnat_studyprotocol_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_meta_data
    ADD CONSTRAINT xnat_studyprotocol_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_studyprotocol xnat_studyprotocol_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol
    ADD CONSTRAINT xnat_studyprotocol_pkey PRIMARY KEY (xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_session_history xnat_studyprotocol_session_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_session_history
    ADD CONSTRAINT xnat_studyprotocol_session_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_studyprotocol_session_meta_data xnat_studyprotocol_session_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_session_meta_data
    ADD CONSTRAINT xnat_studyprotocol_session_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_studyprotocol_session xnat_studyprotocol_session_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_session
    ADD CONSTRAINT xnat_studyprotocol_session_pkey PRIMARY KEY (xnat_studyprotocol_session_id);


--
-- Name: xnat_studyprotocol_session xnat_studyprotocol_session_u_fk_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_session
    ADD CONSTRAINT xnat_studyprotocol_session_u_fk_id UNIQUE (id, imagesessiontypes_session_xnat__xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_session xnat_studyprotocol_session_u_fk_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_session
    ADD CONSTRAINT xnat_studyprotocol_session_u_fk_name UNIQUE (name, imagesessiontypes_session_xnat__xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_variable_history xnat_studyprotocol_variable_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_variable_history
    ADD CONSTRAINT xnat_studyprotocol_variable_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_studyprotocol_variable_meta_data xnat_studyprotocol_variable_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_variable_meta_data
    ADD CONSTRAINT xnat_studyprotocol_variable_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_studyprotocol_variable xnat_studyprotocol_variable_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_variable
    ADD CONSTRAINT xnat_studyprotocol_variable_pkey PRIMARY KEY (xnat_studyprotocol_variable_id);


--
-- Name: xnat_studyprotocol_variable xnat_studyprotocol_variable_u_fk_id; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_variable
    ADD CONSTRAINT xnat_studyprotocol_variable_u_fk_id UNIQUE (id, subjectvariables_variable_xnat__xnat_abstractprotocol_id);


--
-- Name: xnat_studyprotocol_variable xnat_studyprotocol_variable_u_fk_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_studyprotocol_variable
    ADD CONSTRAINT xnat_studyprotocol_variable_u_fk_name UNIQUE (name, subjectvariables_variable_xnat__xnat_abstractprotocol_id);


--
-- Name: xnat_subjectassessordata_history xnat_subjectassessordata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectassessordata_history
    ADD CONSTRAINT xnat_subjectassessordata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectassessordata_meta_data xnat_subjectassessordata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectassessordata_meta_data
    ADD CONSTRAINT xnat_subjectassessordata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_subjectassessordata xnat_subjectassessordata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectassessordata
    ADD CONSTRAINT xnat_subjectassessordata_pkey PRIMARY KEY (id);


--
-- Name: xnat_subjectdata_addid_history xnat_subjectdata_addid_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_addid_history
    ADD CONSTRAINT xnat_subjectdata_addid_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectdata_addid_meta_data xnat_subjectdata_addid_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_addid_meta_data
    ADD CONSTRAINT xnat_subjectdata_addid_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_subjectdata_addid xnat_subjectdata_addid_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_addid
    ADD CONSTRAINT xnat_subjectdata_addid_pkey PRIMARY KEY (xnat_subjectdata_addid_id);


--
-- Name: xnat_subjectdata_addid xnat_subjectdata_addid_u_unique_name_value; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_addid
    ADD CONSTRAINT xnat_subjectdata_addid_u_unique_name_value UNIQUE (addid, name);


--
-- Name: xnat_subjectdata_addid xnat_subjectdata_addid_u_unique_subject_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_addid
    ADD CONSTRAINT xnat_subjectdata_addid_u_unique_subject_name UNIQUE (name, xnat_subjectdata_id);


--
-- Name: xnat_subjectdata_field_history xnat_subjectdata_field_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_field_history
    ADD CONSTRAINT xnat_subjectdata_field_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectdata_field_meta_data xnat_subjectdata_field_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_field_meta_data
    ADD CONSTRAINT xnat_subjectdata_field_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_subjectdata_field xnat_subjectdata_field_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_field
    ADD CONSTRAINT xnat_subjectdata_field_pkey PRIMARY KEY (xnat_subjectdata_field_id);


--
-- Name: xnat_subjectdata_field xnat_subjectdata_field_u_subject_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_field
    ADD CONSTRAINT xnat_subjectdata_field_u_subject_name UNIQUE (name, fields_field_xnat_subjectdata_id);


--
-- Name: xnat_subjectdata_history xnat_subjectdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_history
    ADD CONSTRAINT xnat_subjectdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectdata_meta_data xnat_subjectdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_meta_data
    ADD CONSTRAINT xnat_subjectdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_subjectdata xnat_subjectdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata
    ADD CONSTRAINT xnat_subjectdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_subjectdata_resource_history xnat_subjectdata_resource_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_resource_history
    ADD CONSTRAINT xnat_subjectdata_resource_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectdata_resource xnat_subjectdata_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata_resource
    ADD CONSTRAINT xnat_subjectdata_resource_pkey PRIMARY KEY (xnat_subjectdata_resource_id);


--
-- Name: xnat_subjectdata xnat_subjectdata_u_proj_subj; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectdata
    ADD CONSTRAINT xnat_subjectdata_u_proj_subj UNIQUE (project, label);


--
-- Name: xnat_subjectmetadata_history xnat_subjectmetadata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectmetadata_history
    ADD CONSTRAINT xnat_subjectmetadata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectmetadata_meta_data xnat_subjectmetadata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectmetadata_meta_data
    ADD CONSTRAINT xnat_subjectmetadata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_subjectmetadata xnat_subjectmetadata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectmetadata
    ADD CONSTRAINT xnat_subjectmetadata_pkey PRIMARY KEY (xnat_abstractsubjectmetadata_id);


--
-- Name: xnat_subjectvariablesdata_history xnat_subjectvariablesdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectvariablesdata_history
    ADD CONSTRAINT xnat_subjectvariablesdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectvariablesdata_meta_data xnat_subjectvariablesdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectvariablesdata_meta_data
    ADD CONSTRAINT xnat_subjectvariablesdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_subjectvariablesdata xnat_subjectvariablesdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectvariablesdata
    ADD CONSTRAINT xnat_subjectvariablesdata_pkey PRIMARY KEY (id);


--
-- Name: xnat_subjectvariablesdata_variable_history xnat_subjectvariablesdata_variable_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectvariablesdata_variable_history
    ADD CONSTRAINT xnat_subjectvariablesdata_variable_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_subjectvariablesdata_variable_meta_data xnat_subjectvariablesdata_variable_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectvariablesdata_variable_meta_data
    ADD CONSTRAINT xnat_subjectvariablesdata_variable_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_subjectvariablesdata_variable xnat_subjectvariablesdata_variable_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectvariablesdata_variable
    ADD CONSTRAINT xnat_subjectvariablesdata_variable_pkey PRIMARY KEY (xnat_subjectvariablesdata_variable_id);


--
-- Name: xnat_subjectvariablesdata_variable xnat_subjectvariablesdata_variable_u_fk_name; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_subjectvariablesdata_variable
    ADD CONSTRAINT xnat_subjectvariablesdata_variable_u_fk_name UNIQUE (name, variables_variable_xnat_subject_id);


--
-- Name: xnat_usscandata_history xnat_usscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_usscandata_history
    ADD CONSTRAINT xnat_usscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_usscandata_meta_data xnat_usscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_usscandata_meta_data
    ADD CONSTRAINT xnat_usscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_usscandata xnat_usscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_usscandata
    ADD CONSTRAINT xnat_usscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_ussessiondata_history xnat_ussessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ussessiondata_history
    ADD CONSTRAINT xnat_ussessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_ussessiondata_meta_data xnat_ussessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ussessiondata_meta_data
    ADD CONSTRAINT xnat_ussessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_ussessiondata xnat_ussessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_ussessiondata
    ADD CONSTRAINT xnat_ussessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_validationdata_history xnat_validationdata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_validationdata_history
    ADD CONSTRAINT xnat_validationdata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_validationdata_meta_data xnat_validationdata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_validationdata_meta_data
    ADD CONSTRAINT xnat_validationdata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_validationdata xnat_validationdata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_validationdata
    ADD CONSTRAINT xnat_validationdata_pkey PRIMARY KEY (xnat_validationdata_id);


--
-- Name: xnat_voiceaudioscandata_history xnat_voiceaudioscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_voiceaudioscandata_history
    ADD CONSTRAINT xnat_voiceaudioscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_voiceaudioscandata_meta_data xnat_voiceaudioscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_voiceaudioscandata_meta_data
    ADD CONSTRAINT xnat_voiceaudioscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_voiceaudioscandata xnat_voiceaudioscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_voiceaudioscandata
    ADD CONSTRAINT xnat_voiceaudioscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_volumetricregion_history xnat_volumetricregion_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_volumetricregion_history
    ADD CONSTRAINT xnat_volumetricregion_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_volumetricregion_meta_data xnat_volumetricregion_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_volumetricregion_meta_data
    ADD CONSTRAINT xnat_volumetricregion_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_volumetricregion xnat_volumetricregion_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_volumetricregion
    ADD CONSTRAINT xnat_volumetricregion_pkey PRIMARY KEY (xnat_volumetricregion_id);


--
-- Name: xnat_volumetricregion_subregion_history xnat_volumetricregion_subregion_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_volumetricregion_subregion_history
    ADD CONSTRAINT xnat_volumetricregion_subregion_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_volumetricregion_subregion_meta_data xnat_volumetricregion_subregion_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_volumetricregion_subregion_meta_data
    ADD CONSTRAINT xnat_volumetricregion_subregion_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_volumetricregion_subregion xnat_volumetricregion_subregion_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_volumetricregion_subregion
    ADD CONSTRAINT xnat_volumetricregion_subregion_pkey PRIMARY KEY (xnat_volumetricregion_subregion_id);


--
-- Name: xnat_volumetricregion_subregion xnat_volumetricregion_subregion_u_true; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_volumetricregion_subregion
    ADD CONSTRAINT xnat_volumetricregion_subregion_u_true UNIQUE (name, subregions_subregion_xnat_volum_xnat_volumetricregion_id);


--
-- Name: xnat_xa3dscandata_history xnat_xa3dscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xa3dscandata_history
    ADD CONSTRAINT xnat_xa3dscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xa3dscandata_meta_data xnat_xa3dscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xa3dscandata_meta_data
    ADD CONSTRAINT xnat_xa3dscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xa3dscandata xnat_xa3dscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xa3dscandata
    ADD CONSTRAINT xnat_xa3dscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_xa3dsessiondata_history xnat_xa3dsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xa3dsessiondata_history
    ADD CONSTRAINT xnat_xa3dsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xa3dsessiondata_meta_data xnat_xa3dsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xa3dsessiondata_meta_data
    ADD CONSTRAINT xnat_xa3dsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xa3dsessiondata xnat_xa3dsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xa3dsessiondata
    ADD CONSTRAINT xnat_xa3dsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_xascandata_history xnat_xascandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xascandata_history
    ADD CONSTRAINT xnat_xascandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xascandata_meta_data xnat_xascandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xascandata_meta_data
    ADD CONSTRAINT xnat_xascandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xascandata xnat_xascandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xascandata
    ADD CONSTRAINT xnat_xascandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_xasessiondata_history xnat_xasessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xasessiondata_history
    ADD CONSTRAINT xnat_xasessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xasessiondata_meta_data xnat_xasessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xasessiondata_meta_data
    ADD CONSTRAINT xnat_xasessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xasessiondata xnat_xasessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xasessiondata
    ADD CONSTRAINT xnat_xasessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_xcscandata_history xnat_xcscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcscandata_history
    ADD CONSTRAINT xnat_xcscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xcscandata_meta_data xnat_xcscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcscandata_meta_data
    ADD CONSTRAINT xnat_xcscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xcscandata xnat_xcscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcscandata
    ADD CONSTRAINT xnat_xcscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_xcsessiondata_history xnat_xcsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcsessiondata_history
    ADD CONSTRAINT xnat_xcsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xcsessiondata_meta_data xnat_xcsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcsessiondata_meta_data
    ADD CONSTRAINT xnat_xcsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xcsessiondata xnat_xcsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcsessiondata
    ADD CONSTRAINT xnat_xcsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xnat_xcvscandata_history xnat_xcvscandata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcvscandata_history
    ADD CONSTRAINT xnat_xcvscandata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xcvscandata_meta_data xnat_xcvscandata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcvscandata_meta_data
    ADD CONSTRAINT xnat_xcvscandata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xcvscandata xnat_xcvscandata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcvscandata
    ADD CONSTRAINT xnat_xcvscandata_pkey PRIMARY KEY (xnat_imagescandata_id);


--
-- Name: xnat_xcvsessiondata_history xnat_xcvsessiondata_history_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcvsessiondata_history
    ADD CONSTRAINT xnat_xcvsessiondata_history_pkey PRIMARY KEY (history_id);


--
-- Name: xnat_xcvsessiondata_meta_data xnat_xcvsessiondata_meta_data_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcvsessiondata_meta_data
    ADD CONSTRAINT xnat_xcvsessiondata_meta_data_pkey PRIMARY KEY (meta_data_id);


--
-- Name: xnat_xcvsessiondata xnat_xcvsessiondata_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xnat_xcvsessiondata
    ADD CONSTRAINT xnat_xcvsessiondata_pkey PRIMARY KEY (id);


--
-- Name: xs_par_table xs_par_table_guid_key; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xs_par_table
    ADD CONSTRAINT xs_par_table_guid_key UNIQUE (guid);


--
-- Name: xs_par_table xs_par_table_pkey; Type: CONSTRAINT; Schema: public; Owner: xnat
--

ALTER TABLE ONLY public.xs_par_table
    ADD CONSTRAINT xs_par_table_pkey PRIMARY KEY (par_id);


--
-- Name: activemq_msgs_cidx; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX activemq_msgs_cidx ON public.activemq_msgs USING btree (container);


--
-- Name: activemq_msgs_eidx; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX activemq_msgs_eidx ON public.activemq_msgs USING btree (expiration);


--
-- Name: activemq_msgs_midx; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX activemq_msgs_midx ON public.activemq_msgs USING btree (msgid_prod, msgid_seq);


--
-- Name: activemq_msgs_pidx; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX activemq_msgs_pidx ON public.activemq_msgs USING btree (priority);


--
-- Name: arc_archivespecification_arc_archivespecification_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_arc_archivespecification_id1_hash ON public.arc_archivespecification USING hash (arc_archivespecification_id);


--
-- Name: arc_archivespecification_archivespecification_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_archivespecification_info1 ON public.arc_archivespecification USING btree (archivespecification_info);


--
-- Name: arc_archivespecification_archivespecification_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_archivespecification_info1_hash ON public.arc_archivespecification USING hash (archivespecification_info);


--
-- Name: arc_archivespecification_globalpaths_arc_pathinfo_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_globalpaths_arc_pathinfo_id1 ON public.arc_archivespecification USING btree (globalpaths_arc_pathinfo_id);


--
-- Name: arc_archivespecification_globalpaths_arc_pathinfo_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_globalpaths_arc_pathinfo_id1_hash ON public.arc_archivespecification USING hash (globalpaths_arc_pathinfo_id);


--
-- Name: arc_archivespecification_meta_data_activation_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_meta_data_activation_user_xdat_u1 ON public.arc_archivespecification_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_archivespecification_meta_data_activation_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_meta_data_activation_user_xdat_u1_hash ON public.arc_archivespecification_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_archivespecification_meta_data_insert_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_meta_data_insert_user_xdat_user_1 ON public.arc_archivespecification_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_archivespecification_meta_data_insert_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_meta_data_insert_user_xdat_user_1_hash ON public.arc_archivespecification_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_archivespecification_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_meta_data_meta_data_id1_hash ON public.arc_archivespecification_meta_data USING hash (meta_data_id);


--
-- Name: arc_archivespecification_notification_type_arc_archivespe1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_arc_archivespe1_hash ON public.arc_archivespecification_notification_type USING hash (arc_archivespecification_notification_type_id);


--
-- Name: arc_archivespecification_notification_type_archivespecifi1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_archivespecifi1 ON public.arc_archivespecification_notification_type USING btree (archivespecification_notification_type_info);


--
-- Name: arc_archivespecification_notification_type_archivespecifi1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_archivespecifi1_hash ON public.arc_archivespecification_notification_type USING hash (archivespecification_notification_type_info);


--
-- Name: arc_archivespecification_notification_type_meta_data_acti1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_meta_data_acti1 ON public.arc_archivespecification_notification_type_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_archivespecification_notification_type_meta_data_acti1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_meta_data_acti1_hash ON public.arc_archivespecification_notification_type_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_archivespecification_notification_type_meta_data_inse1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_meta_data_inse1 ON public.arc_archivespecification_notification_type_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_archivespecification_notification_type_meta_data_inse1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_meta_data_inse1_hash ON public.arc_archivespecification_notification_type_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_archivespecification_notification_type_meta_data_meta1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_meta_data_meta1_hash ON public.arc_archivespecification_notification_type_meta_data USING hash (meta_data_id);


--
-- Name: arc_archivespecification_notification_type_notification_t1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_notification_t1 ON public.arc_archivespecification_notification_type USING btree (notification_types_notification_arc_archivespecification_id);


--
-- Name: arc_archivespecification_notification_type_notification_t1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_archivespecification_notification_type_notification_t1_hash ON public.arc_archivespecification_notification_type USING hash (notification_types_notification_arc_archivespecification_id);


--
-- Name: arc_fieldspecification_arc_fieldspecification_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_arc_fieldspecification_id1_hash ON public.arc_fieldspecification USING hash (arc_fieldspecification_id);


--
-- Name: arc_fieldspecification_fieldspecification_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_fieldspecification_info1 ON public.arc_fieldspecification USING btree (fieldspecification_info);


--
-- Name: arc_fieldspecification_fieldspecification_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_fieldspecification_info1_hash ON public.arc_fieldspecification USING hash (fieldspecification_info);


--
-- Name: arc_fieldspecification_fieldspecifications_fieldspecif_ar1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_fieldspecifications_fieldspecif_ar1 ON public.arc_fieldspecification USING btree (fieldspecifications_fieldspecif_arc_archivespecification_id);


--
-- Name: arc_fieldspecification_fieldspecifications_fieldspecif_ar1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_fieldspecifications_fieldspecif_ar1_hash ON public.arc_fieldspecification USING hash (fieldspecifications_fieldspecif_arc_archivespecification_id);


--
-- Name: arc_fieldspecification_fieldspecifications_fieldspecif_ar2; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_fieldspecifications_fieldspecif_ar2 ON public.arc_fieldspecification USING btree (fieldspecifications_fieldspecif_arc_project_id);


--
-- Name: arc_fieldspecification_fieldspecifications_fieldspecif_ar2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_fieldspecifications_fieldspecif_ar2_hash ON public.arc_fieldspecification USING hash (fieldspecifications_fieldspecif_arc_project_id);


--
-- Name: arc_fieldspecification_meta_data_activation_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_meta_data_activation_user_xdat_use1 ON public.arc_fieldspecification_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_fieldspecification_meta_data_activation_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_meta_data_activation_user_xdat_use1_hash ON public.arc_fieldspecification_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_fieldspecification_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_meta_data_insert_user_xdat_user_id1 ON public.arc_fieldspecification_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_fieldspecification_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_meta_data_insert_user_xdat_user_id1_hash ON public.arc_fieldspecification_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_fieldspecification_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_fieldspecification_meta_data_meta_data_id1_hash ON public.arc_fieldspecification_meta_data USING hash (meta_data_id);


--
-- Name: arc_pathinfo_arc_pathinfo_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_arc_pathinfo_id1_hash ON public.arc_pathinfo USING hash (arc_pathinfo_id);


--
-- Name: arc_pathinfo_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_meta_data_activation_user_xdat_user_id1 ON public.arc_pathinfo_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_pathinfo_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_meta_data_activation_user_xdat_user_id1_hash ON public.arc_pathinfo_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_pathinfo_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_meta_data_insert_user_xdat_user_id1 ON public.arc_pathinfo_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_pathinfo_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_meta_data_insert_user_xdat_user_id1_hash ON public.arc_pathinfo_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_pathinfo_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_meta_data_meta_data_id1_hash ON public.arc_pathinfo_meta_data USING hash (meta_data_id);


--
-- Name: arc_pathinfo_pathinfo_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_pathinfo_info1 ON public.arc_pathinfo USING btree (pathinfo_info);


--
-- Name: arc_pathinfo_pathinfo_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pathinfo_pathinfo_info1_hash ON public.arc_pathinfo USING hash (pathinfo_info);


--
-- Name: arc_pipelinedata_arc_pipelinedata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_arc_pipelinedata_id1_hash ON public.arc_pipelinedata USING hash (arc_pipelinedata_id);


--
-- Name: arc_pipelinedata_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_extension1 ON public.arc_pipelinedata USING btree (extension);


--
-- Name: arc_pipelinedata_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_extension1_hash ON public.arc_pipelinedata USING hash (extension);


--
-- Name: arc_pipelinedata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_meta_data_activation_user_xdat_user_id1 ON public.arc_pipelinedata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_pipelinedata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_meta_data_activation_user_xdat_user_id1_hash ON public.arc_pipelinedata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_pipelinedata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_meta_data_insert_user_xdat_user_id1 ON public.arc_pipelinedata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_pipelinedata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_meta_data_insert_user_xdat_user_id1_hash ON public.arc_pipelinedata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_pipelinedata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_meta_data_meta_data_id1_hash ON public.arc_pipelinedata_meta_data USING hash (meta_data_id);


--
-- Name: arc_pipelinedata_pipelinedata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_pipelinedata_info1 ON public.arc_pipelinedata USING btree (pipelinedata_info);


--
-- Name: arc_pipelinedata_pipelinedata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelinedata_pipelinedata_info1_hash ON public.arc_pipelinedata USING hash (pipelinedata_info);


--
-- Name: arc_pipelineparameterdata_arc_pipelineparameterdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_arc_pipelineparameterdata_id1_hash ON public.arc_pipelineparameterdata USING hash (arc_pipelineparameterdata_id);


--
-- Name: arc_pipelineparameterdata_meta_data_activation_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_meta_data_activation_user_xdat_1 ON public.arc_pipelineparameterdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_pipelineparameterdata_meta_data_activation_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_meta_data_activation_user_xdat_1_hash ON public.arc_pipelineparameterdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_pipelineparameterdata_meta_data_insert_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_meta_data_insert_user_xdat_user1 ON public.arc_pipelineparameterdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_pipelineparameterdata_meta_data_insert_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_meta_data_insert_user_xdat_user1_hash ON public.arc_pipelineparameterdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_pipelineparameterdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_meta_data_meta_data_id1_hash ON public.arc_pipelineparameterdata_meta_data USING hash (meta_data_id);


--
-- Name: arc_pipelineparameterdata_parameters_parameter_arc_pipeli1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_parameters_parameter_arc_pipeli1 ON public.arc_pipelineparameterdata USING btree (parameters_parameter_arc_pipeli_arc_pipelinedata_id);


--
-- Name: arc_pipelineparameterdata_parameters_parameter_arc_pipeli1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_parameters_parameter_arc_pipeli1_hash ON public.arc_pipelineparameterdata USING hash (parameters_parameter_arc_pipeli_arc_pipelinedata_id);


--
-- Name: arc_pipelineparameterdata_pipelineparameterdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_pipelineparameterdata_info1 ON public.arc_pipelineparameterdata USING btree (pipelineparameterdata_info);


--
-- Name: arc_pipelineparameterdata_pipelineparameterdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_pipelineparameterdata_pipelineparameterdata_info1_hash ON public.arc_pipelineparameterdata USING hash (pipelineparameterdata_info);


--
-- Name: arc_project_arc_project_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_arc_project_id1_hash ON public.arc_project USING hash (arc_project_id);


--
-- Name: arc_project_descendant_arc_project_descendant_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_arc_project_descendant_id1_hash ON public.arc_project_descendant USING hash (arc_project_descendant_id);


--
-- Name: arc_project_descendant_meta_data_activation_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_meta_data_activation_user_xdat_use1 ON public.arc_project_descendant_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_project_descendant_meta_data_activation_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_meta_data_activation_user_xdat_use1_hash ON public.arc_project_descendant_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_project_descendant_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_meta_data_insert_user_xdat_user_id1 ON public.arc_project_descendant_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_project_descendant_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_meta_data_insert_user_xdat_user_id1_hash ON public.arc_project_descendant_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_project_descendant_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_meta_data_meta_data_id1_hash ON public.arc_project_descendant_meta_data USING hash (meta_data_id);


--
-- Name: arc_project_descendant_pipeline_arc_pipelinedata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_arc_pipelinedata_id1 ON public.arc_project_descendant_pipeline USING btree (arc_pipelinedata_id);


--
-- Name: arc_project_descendant_pipeline_arc_pipelinedata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_arc_pipelinedata_id1_hash ON public.arc_project_descendant_pipeline USING hash (arc_pipelinedata_id);


--
-- Name: arc_project_descendant_pipeline_arc_pipelinedata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_arc_pipelinedata_id2_hash ON public.arc_project_descendant_pipeline USING hash (arc_pipelinedata_id);


--
-- Name: arc_project_descendant_pipeline_arc_project_descendant_ar1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_arc_project_descendant_ar1 ON public.arc_project_descendant_pipeline USING btree (arc_project_descendant_arc_project_descendant_id);


--
-- Name: arc_project_descendant_pipeline_arc_project_descendant_ar1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_arc_project_descendant_ar1_hash ON public.arc_project_descendant_pipeline USING hash (arc_project_descendant_arc_project_descendant_id);


--
-- Name: arc_project_descendant_pipeline_meta_data_activation_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_meta_data_activation_user1 ON public.arc_project_descendant_pipeline_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_project_descendant_pipeline_meta_data_activation_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_meta_data_activation_user1_hash ON public.arc_project_descendant_pipeline_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_project_descendant_pipeline_meta_data_insert_user_xda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_meta_data_insert_user_xda1 ON public.arc_project_descendant_pipeline_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_project_descendant_pipeline_meta_data_insert_user_xda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_meta_data_insert_user_xda1_hash ON public.arc_project_descendant_pipeline_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_project_descendant_pipeline_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_meta_data_meta_data_id1_hash ON public.arc_project_descendant_pipeline_meta_data USING hash (meta_data_id);


--
-- Name: arc_project_descendant_pipeline_project_descendant_pipeli1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_project_descendant_pipeli1 ON public.arc_project_descendant_pipeline USING btree (project_descendant_pipeline_info);


--
-- Name: arc_project_descendant_pipeline_project_descendant_pipeli1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipeline_project_descendant_pipeli1_hash ON public.arc_project_descendant_pipeline USING hash (project_descendant_pipeline_info);


--
-- Name: arc_project_descendant_pipelines_descendants_descendan_ar1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipelines_descendants_descendan_ar1 ON public.arc_project_descendant USING btree (pipelines_descendants_descendan_arc_project_id);


--
-- Name: arc_project_descendant_pipelines_descendants_descendan_ar1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_pipelines_descendants_descendan_ar1_hash ON public.arc_project_descendant USING hash (pipelines_descendants_descendan_arc_project_id);


--
-- Name: arc_project_descendant_project_descendant_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_project_descendant_info1 ON public.arc_project_descendant USING btree (project_descendant_info);


--
-- Name: arc_project_descendant_project_descendant_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_descendant_project_descendant_info1_hash ON public.arc_project_descendant USING hash (project_descendant_info);


--
-- Name: arc_project_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_meta_data_activation_user_xdat_user_id1 ON public.arc_project_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_project_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_meta_data_activation_user_xdat_user_id1_hash ON public.arc_project_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_project_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_meta_data_insert_user_xdat_user_id1 ON public.arc_project_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_project_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_meta_data_insert_user_xdat_user_id1_hash ON public.arc_project_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_project_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_meta_data_meta_data_id1_hash ON public.arc_project_meta_data USING hash (meta_data_id);


--
-- Name: arc_project_paths_arc_pathinfo_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_paths_arc_pathinfo_id1 ON public.arc_project USING btree (paths_arc_pathinfo_id);


--
-- Name: arc_project_paths_arc_pathinfo_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_paths_arc_pathinfo_id1_hash ON public.arc_project USING hash (paths_arc_pathinfo_id);


--
-- Name: arc_project_pipeline_arc_pipelinedata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_arc_pipelinedata_id1 ON public.arc_project_pipeline USING btree (arc_pipelinedata_id);


--
-- Name: arc_project_pipeline_arc_pipelinedata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_arc_pipelinedata_id1_hash ON public.arc_project_pipeline USING hash (arc_pipelinedata_id);


--
-- Name: arc_project_pipeline_arc_pipelinedata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_arc_pipelinedata_id2_hash ON public.arc_project_pipeline USING hash (arc_pipelinedata_id);


--
-- Name: arc_project_pipeline_meta_data_activation_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_meta_data_activation_user_xdat_user_1 ON public.arc_project_pipeline_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_project_pipeline_meta_data_activation_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_meta_data_activation_user_xdat_user_1_hash ON public.arc_project_pipeline_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_project_pipeline_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_meta_data_insert_user_xdat_user_id1 ON public.arc_project_pipeline_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_project_pipeline_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_meta_data_insert_user_xdat_user_id1_hash ON public.arc_project_pipeline_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_project_pipeline_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_meta_data_meta_data_id1_hash ON public.arc_project_pipeline_meta_data USING hash (meta_data_id);


--
-- Name: arc_project_pipeline_pipelines_pipeline_arc_project_arc_p1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_pipelines_pipeline_arc_project_arc_p1 ON public.arc_project_pipeline USING btree (pipelines_pipeline_arc_project_arc_project_id);


--
-- Name: arc_project_pipeline_pipelines_pipeline_arc_project_arc_p1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_pipelines_pipeline_arc_project_arc_p1_hash ON public.arc_project_pipeline USING hash (pipelines_pipeline_arc_project_arc_project_id);


--
-- Name: arc_project_pipeline_project_pipeline_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_project_pipeline_info1 ON public.arc_project_pipeline USING btree (project_pipeline_info);


--
-- Name: arc_project_pipeline_project_pipeline_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_pipeline_project_pipeline_info1_hash ON public.arc_project_pipeline USING hash (project_pipeline_info);


--
-- Name: arc_project_project_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_project_info1 ON public.arc_project USING btree (project_info);


--
-- Name: arc_project_project_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_project_info1_hash ON public.arc_project USING hash (project_info);


--
-- Name: arc_project_projects_project_arc_archivespe_arc_archivesp1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_projects_project_arc_archivespe_arc_archivesp1 ON public.arc_project USING btree (projects_project_arc_archivespe_arc_archivespecification_id);


--
-- Name: arc_project_projects_project_arc_archivespe_arc_archivesp1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_project_projects_project_arc_archivespe_arc_archivesp1_hash ON public.arc_project USING hash (projects_project_arc_archivespe_arc_archivespecification_id);


--
-- Name: arc_property_arc_property_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_arc_property_id1_hash ON public.arc_property USING hash (arc_property_id);


--
-- Name: arc_property_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_meta_data_activation_user_xdat_user_id1 ON public.arc_property_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: arc_property_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_meta_data_activation_user_xdat_user_id1_hash ON public.arc_property_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: arc_property_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_meta_data_insert_user_xdat_user_id1 ON public.arc_property_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: arc_property_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_meta_data_insert_user_xdat_user_id1_hash ON public.arc_property_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: arc_property_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_meta_data_meta_data_id1_hash ON public.arc_property_meta_data USING hash (meta_data_id);


--
-- Name: arc_property_properties_property_arc_project_arc_project_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_properties_property_arc_project_arc_project_1 ON public.arc_property USING btree (properties_property_arc_project_arc_project_id);


--
-- Name: arc_property_properties_property_arc_project_arc_project_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_properties_property_arc_project_arc_project_1_hash ON public.arc_property USING hash (properties_property_arc_project_arc_project_id);


--
-- Name: arc_property_property_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_property_info1 ON public.arc_property USING btree (property_info);


--
-- Name: arc_property_property_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX arc_property_property_info1_hash ON public.arc_property USING hash (property_info);


--
-- Name: cat_catalog_cat_catalog_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_cat_catalog_id1_hash ON public.cat_catalog USING hash (cat_catalog_id);


--
-- Name: cat_catalog_catalog_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_catalog_info1 ON public.cat_catalog USING btree (catalog_info);


--
-- Name: cat_catalog_catalog_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_catalog_info1_hash ON public.cat_catalog USING hash (catalog_info);


--
-- Name: cat_catalog_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_extension1 ON public.cat_catalog USING btree (extension);


--
-- Name: cat_catalog_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_extension1_hash ON public.cat_catalog USING hash (extension);


--
-- Name: cat_catalog_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_meta_data_activation_user_xdat_user_id1 ON public.cat_catalog_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_catalog_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_meta_data_activation_user_xdat_user_id1_hash ON public.cat_catalog_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_catalog_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_meta_data_insert_user_xdat_user_id1 ON public.cat_catalog_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_catalog_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_meta_data_insert_user_xdat_user_id1_hash ON public.cat_catalog_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_catalog_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_meta_data_meta_data_id1_hash ON public.cat_catalog_meta_data USING hash (meta_data_id);


--
-- Name: cat_catalog_metafield_cat_catalog_metafield_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_cat_catalog_metafield_id1_hash ON public.cat_catalog_metafield USING hash (cat_catalog_metafield_id);


--
-- Name: cat_catalog_metafield_catalog_metafield_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_catalog_metafield_info1 ON public.cat_catalog_metafield USING btree (catalog_metafield_info);


--
-- Name: cat_catalog_metafield_catalog_metafield_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_catalog_metafield_info1_hash ON public.cat_catalog_metafield USING hash (catalog_metafield_info);


--
-- Name: cat_catalog_metafield_meta_data_activation_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_meta_data_activation_user_xdat_user1 ON public.cat_catalog_metafield_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_catalog_metafield_meta_data_activation_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_meta_data_activation_user_xdat_user1_hash ON public.cat_catalog_metafield_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_catalog_metafield_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_meta_data_insert_user_xdat_user_id1 ON public.cat_catalog_metafield_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_catalog_metafield_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_meta_data_insert_user_xdat_user_id1_hash ON public.cat_catalog_metafield_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_catalog_metafield_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_meta_data_meta_data_id1_hash ON public.cat_catalog_metafield_meta_data USING hash (meta_data_id);


--
-- Name: cat_catalog_metafield_metafields_metafield_cat_catalo_cat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_metafields_metafield_cat_catalo_cat1 ON public.cat_catalog_metafield USING btree (metafields_metafield_cat_catalo_cat_catalog_id);


--
-- Name: cat_catalog_metafield_metafields_metafield_cat_catalo_cat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_metafield_metafields_metafield_cat_catalo_cat1_hash ON public.cat_catalog_metafield USING hash (metafields_metafield_cat_catalo_cat_catalog_id);


--
-- Name: cat_catalog_sets_entryset_cat_catalog_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_sets_entryset_cat_catalog_id1 ON public.cat_catalog USING btree (sets_entryset_cat_catalog_id);


--
-- Name: cat_catalog_sets_entryset_cat_catalog_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_sets_entryset_cat_catalog_id1_hash ON public.cat_catalog USING hash (sets_entryset_cat_catalog_id);


--
-- Name: cat_catalog_tag_cat_catalog_tag_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_cat_catalog_tag_id1_hash ON public.cat_catalog_tag USING hash (cat_catalog_tag_id);


--
-- Name: cat_catalog_tag_catalog_tag_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_catalog_tag_info1 ON public.cat_catalog_tag USING btree (catalog_tag_info);


--
-- Name: cat_catalog_tag_catalog_tag_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_catalog_tag_info1_hash ON public.cat_catalog_tag USING hash (catalog_tag_info);


--
-- Name: cat_catalog_tag_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_meta_data_activation_user_xdat_user_id1 ON public.cat_catalog_tag_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_catalog_tag_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_meta_data_activation_user_xdat_user_id1_hash ON public.cat_catalog_tag_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_catalog_tag_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_meta_data_insert_user_xdat_user_id1 ON public.cat_catalog_tag_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_catalog_tag_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_meta_data_insert_user_xdat_user_id1_hash ON public.cat_catalog_tag_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_catalog_tag_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_meta_data_meta_data_id1_hash ON public.cat_catalog_tag_meta_data USING hash (meta_data_id);


--
-- Name: cat_catalog_tag_tags_tag_cat_catalog_cat_catalog_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_tags_tag_cat_catalog_cat_catalog_id1 ON public.cat_catalog_tag USING btree (tags_tag_cat_catalog_cat_catalog_id);


--
-- Name: cat_catalog_tag_tags_tag_cat_catalog_cat_catalog_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_catalog_tag_tags_tag_cat_catalog_cat_catalog_id1_hash ON public.cat_catalog_tag USING hash (tags_tag_cat_catalog_cat_catalog_id);


--
-- Name: cat_dcmcatalog_cat_catalog_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_cat_catalog_id1 ON public.cat_dcmcatalog USING btree (cat_catalog_id);


--
-- Name: cat_dcmcatalog_cat_catalog_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_cat_catalog_id1_hash ON public.cat_dcmcatalog USING hash (cat_catalog_id);


--
-- Name: cat_dcmcatalog_cat_catalog_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_cat_catalog_id2_hash ON public.cat_dcmcatalog USING hash (cat_catalog_id);


--
-- Name: cat_dcmcatalog_dcmcatalog_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_dcmcatalog_info1 ON public.cat_dcmcatalog USING btree (dcmcatalog_info);


--
-- Name: cat_dcmcatalog_dcmcatalog_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_dcmcatalog_info1_hash ON public.cat_dcmcatalog USING hash (dcmcatalog_info);


--
-- Name: cat_dcmcatalog_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_meta_data_activation_user_xdat_user_id1 ON public.cat_dcmcatalog_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_dcmcatalog_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_meta_data_activation_user_xdat_user_id1_hash ON public.cat_dcmcatalog_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_dcmcatalog_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_meta_data_insert_user_xdat_user_id1 ON public.cat_dcmcatalog_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_dcmcatalog_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_meta_data_insert_user_xdat_user_id1_hash ON public.cat_dcmcatalog_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_dcmcatalog_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmcatalog_meta_data_meta_data_id1_hash ON public.cat_dcmcatalog_meta_data USING hash (meta_data_id);


--
-- Name: cat_dcmentry_cat_entry_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_cat_entry_id1 ON public.cat_dcmentry USING btree (cat_entry_id);


--
-- Name: cat_dcmentry_cat_entry_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_cat_entry_id1_hash ON public.cat_dcmentry USING hash (cat_entry_id);


--
-- Name: cat_dcmentry_cat_entry_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_cat_entry_id2_hash ON public.cat_dcmentry USING hash (cat_entry_id);


--
-- Name: cat_dcmentry_dcmentry_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_dcmentry_info1 ON public.cat_dcmentry USING btree (dcmentry_info);


--
-- Name: cat_dcmentry_dcmentry_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_dcmentry_info1_hash ON public.cat_dcmentry USING hash (dcmentry_info);


--
-- Name: cat_dcmentry_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_meta_data_activation_user_xdat_user_id1 ON public.cat_dcmentry_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_dcmentry_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_meta_data_activation_user_xdat_user_id1_hash ON public.cat_dcmentry_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_dcmentry_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_meta_data_insert_user_xdat_user_id1 ON public.cat_dcmentry_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_dcmentry_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_meta_data_insert_user_xdat_user_id1_hash ON public.cat_dcmentry_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_dcmentry_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_dcmentry_meta_data_meta_data_id1_hash ON public.cat_dcmentry_meta_data USING hash (meta_data_id);


--
-- Name: cat_entry_cat_entry_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_cat_entry_id1_hash ON public.cat_entry USING hash (cat_entry_id);


--
-- Name: cat_entry_entries_entry_cat_catalog_cat_catalog_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_entries_entry_cat_catalog_cat_catalog_id1 ON public.cat_entry USING btree (entries_entry_cat_catalog_cat_catalog_id);


--
-- Name: cat_entry_entries_entry_cat_catalog_cat_catalog_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_entries_entry_cat_catalog_cat_catalog_id1_hash ON public.cat_entry USING hash (entries_entry_cat_catalog_cat_catalog_id);


--
-- Name: cat_entry_entry_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_entry_info1 ON public.cat_entry USING btree (entry_info);


--
-- Name: cat_entry_entry_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_entry_info1_hash ON public.cat_entry USING hash (entry_info);


--
-- Name: cat_entry_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_extension1 ON public.cat_entry USING btree (extension);


--
-- Name: cat_entry_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_extension1_hash ON public.cat_entry USING hash (extension);


--
-- Name: cat_entry_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_meta_data_activation_user_xdat_user_id1 ON public.cat_entry_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_entry_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_meta_data_activation_user_xdat_user_id1_hash ON public.cat_entry_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_entry_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_meta_data_insert_user_xdat_user_id1 ON public.cat_entry_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_entry_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_meta_data_insert_user_xdat_user_id1_hash ON public.cat_entry_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_entry_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_meta_data_meta_data_id1_hash ON public.cat_entry_meta_data USING hash (meta_data_id);


--
-- Name: cat_entry_metafield_cat_entry_metafield_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_cat_entry_metafield_id1_hash ON public.cat_entry_metafield USING hash (cat_entry_metafield_id);


--
-- Name: cat_entry_metafield_entry_metafield_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_entry_metafield_info1 ON public.cat_entry_metafield USING btree (entry_metafield_info);


--
-- Name: cat_entry_metafield_entry_metafield_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_entry_metafield_info1_hash ON public.cat_entry_metafield USING hash (entry_metafield_info);


--
-- Name: cat_entry_metafield_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_meta_data_activation_user_xdat_user_i1 ON public.cat_entry_metafield_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_entry_metafield_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_meta_data_activation_user_xdat_user_i1_hash ON public.cat_entry_metafield_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_entry_metafield_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_meta_data_insert_user_xdat_user_id1 ON public.cat_entry_metafield_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_entry_metafield_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_meta_data_insert_user_xdat_user_id1_hash ON public.cat_entry_metafield_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_entry_metafield_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_meta_data_meta_data_id1_hash ON public.cat_entry_metafield_meta_data USING hash (meta_data_id);


--
-- Name: cat_entry_metafield_metafields_metafield_cat_entry_cat_en1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_metafields_metafield_cat_entry_cat_en1 ON public.cat_entry_metafield USING btree (metafields_metafield_cat_entry_cat_entry_id);


--
-- Name: cat_entry_metafield_metafields_metafield_cat_entry_cat_en1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_metafield_metafields_metafield_cat_entry_cat_en1_hash ON public.cat_entry_metafield USING hash (metafields_metafield_cat_entry_cat_entry_id);


--
-- Name: cat_entry_tag_cat_entry_tag_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_cat_entry_tag_id1_hash ON public.cat_entry_tag USING hash (cat_entry_tag_id);


--
-- Name: cat_entry_tag_entry_tag_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_entry_tag_info1 ON public.cat_entry_tag USING btree (entry_tag_info);


--
-- Name: cat_entry_tag_entry_tag_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_entry_tag_info1_hash ON public.cat_entry_tag USING hash (entry_tag_info);


--
-- Name: cat_entry_tag_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_meta_data_activation_user_xdat_user_id1 ON public.cat_entry_tag_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: cat_entry_tag_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_meta_data_activation_user_xdat_user_id1_hash ON public.cat_entry_tag_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: cat_entry_tag_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_meta_data_insert_user_xdat_user_id1 ON public.cat_entry_tag_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: cat_entry_tag_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_meta_data_insert_user_xdat_user_id1_hash ON public.cat_entry_tag_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: cat_entry_tag_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_meta_data_meta_data_id1_hash ON public.cat_entry_tag_meta_data USING hash (meta_data_id);


--
-- Name: cat_entry_tag_tags_tag_cat_entry_cat_entry_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_tags_tag_cat_entry_cat_entry_id1 ON public.cat_entry_tag USING btree (tags_tag_cat_entry_cat_entry_id);


--
-- Name: cat_entry_tag_tags_tag_cat_entry_cat_entry_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX cat_entry_tag_tags_tag_cat_entry_cat_entry_id1_hash ON public.cat_entry_tag USING hash (tags_tag_cat_entry_cat_entry_id);


--
-- Name: pipe_pipelinedetails_element_generateselements_element_pi1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_generateselements_element_pi1 ON public.pipe_pipelinedetails_element USING btree (generateselements_element_pipe__path);


--
-- Name: pipe_pipelinedetails_element_generateselements_element_pi1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_generateselements_element_pi1_hash ON public.pipe_pipelinedetails_element USING hash (generateselements_element_pipe__path);


--
-- Name: pipe_pipelinedetails_element_meta_data_activation_user_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_meta_data_activation_user_xd1 ON public.pipe_pipelinedetails_element_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_element_meta_data_activation_user_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_meta_data_activation_user_xd1_hash ON public.pipe_pipelinedetails_element_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_element_meta_data_insert_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_meta_data_insert_user_xdat_u1 ON public.pipe_pipelinedetails_element_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_element_meta_data_insert_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_meta_data_insert_user_xdat_u1_hash ON public.pipe_pipelinedetails_element_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_element_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_meta_data_meta_data_id1_hash ON public.pipe_pipelinedetails_element_meta_data USING hash (meta_data_id);


--
-- Name: pipe_pipelinedetails_element_pipe_pipelinedetails_element1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_pipe_pipelinedetails_element1_hash ON public.pipe_pipelinedetails_element USING hash (pipe_pipelinedetails_element_id);


--
-- Name: pipe_pipelinedetails_element_pipelinedetails_element_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_pipelinedetails_element_info1 ON public.pipe_pipelinedetails_element USING btree (pipelinedetails_element_info);


--
-- Name: pipe_pipelinedetails_element_pipelinedetails_element_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_element_pipelinedetails_element_info1_hash ON public.pipe_pipelinedetails_element USING hash (pipelinedetails_element_info);


--
-- Name: pipe_pipelinedetails_meta_data_activation_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_meta_data_activation_user_xdat_user_1 ON public.pipe_pipelinedetails_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_meta_data_activation_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_meta_data_activation_user_xdat_user_1_hash ON public.pipe_pipelinedetails_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_meta_data_insert_user_xdat_user_id1 ON public.pipe_pipelinedetails_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_meta_data_insert_user_xdat_user_id1_hash ON public.pipe_pipelinedetails_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_meta_data_meta_data_id1_hash ON public.pipe_pipelinedetails_meta_data USING hash (meta_data_id);


--
-- Name: pipe_pipelinedetails_parameter_meta_data_activation_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_meta_data_activation_user_1 ON public.pipe_pipelinedetails_parameter_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_parameter_meta_data_activation_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_meta_data_activation_user_1_hash ON public.pipe_pipelinedetails_parameter_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_parameter_meta_data_insert_user_xdat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_meta_data_insert_user_xdat1 ON public.pipe_pipelinedetails_parameter_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_parameter_meta_data_insert_user_xdat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_meta_data_insert_user_xdat1_hash ON public.pipe_pipelinedetails_parameter_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinedetails_parameter_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_meta_data_meta_data_id1_hash ON public.pipe_pipelinedetails_parameter_meta_data USING hash (meta_data_id);


--
-- Name: pipe_pipelinedetails_parameter_parameters_parameter_pipe_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_parameters_parameter_pipe_1 ON public.pipe_pipelinedetails_parameter USING btree (parameters_parameter_pipe_pipel_path);


--
-- Name: pipe_pipelinedetails_parameter_parameters_parameter_pipe_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_parameters_parameter_pipe_1_hash ON public.pipe_pipelinedetails_parameter USING hash (parameters_parameter_pipe_pipel_path);


--
-- Name: pipe_pipelinedetails_parameter_pipe_pipelinedetails_param1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_pipe_pipelinedetails_param1_hash ON public.pipe_pipelinedetails_parameter USING hash (pipe_pipelinedetails_parameter_id);


--
-- Name: pipe_pipelinedetails_parameter_pipelinedetails_parameter_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_pipelinedetails_parameter_1 ON public.pipe_pipelinedetails_parameter USING btree (pipelinedetails_parameter_info);


--
-- Name: pipe_pipelinedetails_parameter_pipelinedetails_parameter_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_parameter_pipelinedetails_parameter_1_hash ON public.pipe_pipelinedetails_parameter USING hash (pipelinedetails_parameter_info);


--
