 
 
 --
--- Name: searches; Type: TABLE; Schema: support; Owner: -
---
-
-CREATE TABLE support.searches (
-    id integer NOT NULL,
-    save_tsv boolean DEFAULT false NOT NULL,
-    query character varying NOT NULL,
-    "grouping" character varying DEFAULT ''::character varying NOT NULL,
-    created_at timestamp without time zone NOT NULL,
-    updated_at timestamp without time zone NOT NULL,
-    name character varying DEFAULT ''::character varying NOT NULL,
-    beta_api boolean DEFAULT false NOT NULL
-);
-
-
---
--- Name: searches_id_seq; Type: SEQUENCE; Schema: support; Owner: -
---
-
-CREATE SEQUENCE support.searches_id_seq
-    AS integer
-    START WITH 1
-    INCREMENT BY 1
-    NO MINVALUE
-    NO MAXVALUE
-    CACHE 1;
-
-
---
--- Name: searches_id_seq; Type: SEQUENCE OWNED BY; Schema: support; Owner: -
---
-
-ALTER SEQUENCE support.searches_id_seq OWNED BY support.searches.id;
-
-
---
 -- Name: study_json_records; Type: TABLE; Schema: support; Owner: -
 --
 



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




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

CREATE INDEX index_milestones_on_period ON ctgov.milestones USING btree (period);


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

CREATE INDEX index_outcome_analyses_on_dispersion_type ON ctgov.outcome_analyses USING btree (dispersion_type);


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

CREATE INDEX index_outcome_analyses_on_param_type ON ctgov.outcome_analyses USING btree (param_type);


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

CREATE INDEX index_outcome_measurements_on_category ON ctgov.outcome_measurements USING btree (category);


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

CREATE INDEX index_outcome_measurements_on_classification ON ctgov.outcome_measurements USING btree (classification);


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

CREATE INDEX index_outcome_measurements_on_dispersion_type ON ctgov.outcome_measurements USING btree (dispersion_type);


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

CREATE INDEX index_outcomes_on_dispersion_type ON ctgov.outcomes USING btree (dispersion_type);


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

CREATE INDEX index_outcomes_on_param_type ON ctgov.outcomes USING btree (param_type);


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

CREATE INDEX index_overall_officials_on_affiliation ON ctgov.overall_officials USING btree (affiliation);


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

CREATE INDEX index_overall_officials_on_nct_id ON ctgov.overall_officials USING btree (nct_id);


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

CREATE INDEX index_reported_events_on_event_type ON ctgov.reported_events USING btree (event_type);


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

CREATE INDEX index_reported_events_on_subjects_affected ON ctgov.reported_events USING btree (subjects_affected);


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

CREATE INDEX index_responsible_parties_on_nct_id ON ctgov.responsible_parties USING btree (nct_id);


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

CREATE INDEX index_responsible_parties_on_organization ON ctgov.responsible_parties USING btree (organization);


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

CREATE INDEX index_responsible_parties_on_responsible_party_type ON ctgov.responsible_parties USING btree (responsible_party_type);


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

CREATE INDEX index_result_contacts_on_organization ON ctgov.result_contacts USING btree (organization);


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

CREATE INDEX index_result_groups_on_result_type ON ctgov.result_groups USING btree (result_type);


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

CREATE INDEX index_sponsors_on_agency_class ON ctgov.sponsors USING btree (agency_class);


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

CREATE INDEX index_sponsors_on_name ON ctgov.sponsors USING btree (name);


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

CREATE INDEX index_studies_on_completion_date ON ctgov.studies USING btree (completion_date);


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

CREATE INDEX index_studies_on_disposition_first_submitted_date ON ctgov.studies USING btree (disposition_first_submitted_date);


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

CREATE INDEX index_studies_on_enrollment_type ON ctgov.studies USING btree (enrollment_type);


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

CREATE INDEX index_studies_on_last_known_status ON ctgov.studies USING btree (last_known_status);


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

CREATE INDEX index_studies_on_last_update_submitted_date ON ctgov.studies USING btree (last_update_submitted_date);


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

