 
 
 --
--- Name: index_studies_on_study_first_submitted_qc_date; Type: INDEX; Schema: ctgov_beta; Owner: -
---
-
-CREATE INDEX index_studies_on_study_first_submitted_qc_date ON ctgov_beta.studies USING btree (study_first_submitted_qc_date);
-
-
---
 -- Name: index_studies_on_study_type; Type: INDEX; Schema: ctgov_beta; Owner: -
 --
 
 CREATE INDEX index_studies_on_study_type ON ctgov_beta.studies USING btree (study_type);
-
-
---
--- Name: index_study_references_on_nct_id; Type: INDEX; Schema: ctgov_beta; Owner: -
---
-
-CREATE INDEX index_study_references_on_nct_id ON ctgov_beta.study_references USING btree (nct_id);
-
-
---
--- Name: index_study_references_on_pmid; Type: INDEX; Schema: ctgov_beta; Owner: -
---
-
-CREATE INDEX index_study_references_on_pmid ON ctgov_beta.study_references USING btree (pmid);
 
 
 --



--
-- Name: index_eligibilities_on_nct_id; Type: INDEX; Schema: ctgov_beta; Owner: -
--

CREATE UNIQUE INDEX index_eligibilities_on_nct_id ON ctgov_beta.eligibilities USING btree (nct_id);


--
-- Name: index_facilities_on_city; Type: INDEX; Schema: ctgov_beta; Owner: -
--




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

CREATE UNIQUE INDEX index_categories_on_nct_id_and_name ON ctgov.categories USING btree (nct_id, name);


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

CREATE UNIQUE INDEX index_categories_on_nct_id_and_name_and_grouping ON ctgov.categories USING btree (nct_id, name, "grouping");


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

