 
 
 --
--- Name: index_searches_on_query_and_grouping; Type: INDEX; Schema: support; Owner: -
---
-
-CREATE UNIQUE INDEX index_searches_on_query_and_grouping ON support.searches USING btree (query, "grouping");
-
-
---
 -- Name: index_support.load_events_on_event_type; Type: INDEX; Schema: support; Owner: -
 --
 



--
-- Name: searches searches_pkey; Type: CONSTRAINT; Schema: support; Owner: -
--

ALTER TABLE ONLY support.searches
    ADD CONSTRAINT searches_pkey PRIMARY KEY (id);


--
-- Name: study_json_records study_json_records_pkey; Type: CONSTRAINT; Schema: support; Owner: -
--




--
-- Name: index_studies_on_overall_status; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_overall_status ON ctgov.studies USING btree (overall_status);


--
-- Name: index_studies_on_phase; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_phase ON ctgov.studies USING btree (phase);


--
-- Name: index_studies_on_primary_completion_date; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_primary_completion_date ON ctgov.studies USING btree (primary_completion_date);


--
-- Name: index_studies_on_primary_completion_date_type; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_primary_completion_date_type ON ctgov.studies USING btree (primary_completion_date_type);


--
-- Name: index_studies_on_results_first_submitted_date; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_results_first_submitted_date ON ctgov.studies USING btree (results_first_submitted_date);


--
-- Name: index_studies_on_source; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_source ON ctgov.studies USING btree (source);


--
-- Name: index_studies_on_start_date; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_start_date ON ctgov.studies USING btree (start_date);


--
-- Name: index_studies_on_start_date_type; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_start_date_type ON ctgov.studies USING btree (start_date_type);


--
-- Name: index_studies_on_study_first_submitted_date; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_study_first_submitted_date ON ctgov.studies USING btree (study_first_submitted_date);


--
-- Name: index_studies_on_study_type; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_studies_on_study_type ON ctgov.studies USING btree (study_type);


--
-- Name: index_study_references_on_reference_type; Type: INDEX; Schema: ctgov; Owner: -
--

CREATE INDEX index_study_references_on_reference_type ON ctgov.study_references USING btree (reference_type);


--
-- Name: index_study_searches_on_query_and_grouping; Type: INDEX; Schema: ctgov; Owner: -
--

