 
 
 --
--- Name: index_designs_on_nct_id; Type: INDEX; Schema: ctgov_beta; Owner: -
---
-
-CREATE UNIQUE INDEX index_designs_on_nct_id ON ctgov_beta.designs USING btree (nct_id);
-
-
---
 -- Name: index_designs_on_outcomes_assessor_masked; Type: INDEX; Schema: ctgov_beta; Owner: -
 --
 



--
-- Name: overall_officials overall_officials_nct_id_fkey; Type: FK CONSTRAINT; Schema: ctgov; Owner: -
--

ALTER TABLE ONLY ctgov.overall_officials
    ADD CONSTRAINT overall_officials_nct_id_fkey FOREIGN KEY (nct_id) REFERENCES ctgov.studies(nct_id);


--
-- Name: participant_flows participant_flows_nct_id_fkey; Type: FK CONSTRAINT; Schema: ctgov; Owner: -
--




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

