Created
August 9, 2011 07:48
-
-
Save aschreyer/1133562 to your computer and use it in GitHub Desktop.
PostgreSQL version of the ChEMBL10 database schema
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- PostgreSQL database dump | |
| -- | |
| -- Dumped from database version 9.0.4 | |
| -- Dumped by pg_dump version 9.0.1 | |
| -- Started on 2011-07-22 13:30:36 | |
| SET statement_timeout = 0; | |
| SET client_encoding = 'UTF8'; | |
| SET standard_conforming_strings = on; | |
| SET check_function_bodies = false; | |
| SET client_min_messages = warning; | |
| SET search_path = chembl, pg_catalog; | |
| SET default_with_oids = false; | |
| -- | |
| -- TOC entry 2730 (class 1259 OID 33491) | |
| -- Dependencies: 9 | |
| -- Name: activities; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE activities ( | |
| activity_id integer NOT NULL, | |
| assay_id integer, | |
| doc_id integer, | |
| record_id integer, | |
| molregno integer, | |
| relation character varying(50), | |
| published_value double precision, | |
| published_units character varying(100), | |
| standard_value double precision, | |
| standard_units character varying(100), | |
| standard_flag integer, | |
| standard_type character varying(250), | |
| activity_comment character varying(255), | |
| published_activity_type character varying(250) | |
| ); | |
| -- | |
| -- TOC entry 2725 (class 1259 OID 33450) | |
| -- Dependencies: 9 | |
| -- Name: assay2target; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE assay2target ( | |
| assay_id integer NOT NULL, | |
| tid integer NOT NULL, | |
| assay_tax_id integer, | |
| assay_organism character varying(250), | |
| relationship_type character(1), | |
| complex integer, | |
| multi integer, | |
| confidence_score integer, | |
| assay_strain character varying(200), | |
| curated_by character varying(32) | |
| ); | |
| -- | |
| -- TOC entry 2721 (class 1259 OID 33418) | |
| -- Dependencies: 9 | |
| -- Name: assay_type; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE assay_type ( | |
| assay_type character varying(1) NOT NULL, | |
| assay_desc character varying(250) | |
| ); | |
| -- | |
| -- TOC entry 2722 (class 1259 OID 33423) | |
| -- Dependencies: 9 | |
| -- Name: assays; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE assays ( | |
| assay_id integer NOT NULL, | |
| assay_type character varying(250), | |
| description text, | |
| doc_id integer, | |
| src_id integer, | |
| src_assay_id character varying(50), | |
| chembl_id character varying(20) | |
| ); | |
| -- | |
| -- TOC entry 2723 (class 1259 OID 33436) | |
| -- Dependencies: 9 | |
| -- Name: atc_classification; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE atc_classification ( | |
| who_name character varying(150), | |
| level1 character varying(10), | |
| level2 character varying(10), | |
| level3 character varying(10), | |
| level4 character varying(10), | |
| level5 character varying(10) NOT NULL, | |
| who_id character varying(15), | |
| level1_description character varying(150), | |
| level2_description character varying(150), | |
| level3_description character varying(150), | |
| level4_description character varying(150) | |
| ); | |
| -- | |
| -- TOC entry 2739 (class 1259 OID 33570) | |
| -- Dependencies: 9 | |
| -- Name: chembl_id_lookup; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE chembl_id_lookup ( | |
| chembl_id character varying(20) NOT NULL, | |
| entity_type character varying(50), | |
| entity_id integer | |
| ); | |
| -- | |
| -- TOC entry 2724 (class 1259 OID 33444) | |
| -- Dependencies: 9 | |
| -- Name: compound_properties; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE compound_properties ( | |
| molregno integer NOT NULL, | |
| mw_freebase double precision, | |
| alogp double precision, | |
| hba integer, | |
| hbd integer, | |
| psa double precision, | |
| rtb integer, | |
| ro3_pass character varying(3), | |
| num_ro5_violations integer, | |
| med_chem_friendly character varying(3), | |
| acd_most_apka double precision, | |
| acd_most_bpka double precision, | |
| acd_logp double precision, | |
| acd_logd double precision, | |
| molecular_species character varying(50), | |
| full_mwt double precision | |
| ); | |
| -- | |
| -- TOC entry 2731 (class 1259 OID 33503) | |
| -- Dependencies: 9 | |
| -- Name: compound_records; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE compound_records ( | |
| record_id integer NOT NULL, | |
| molregno integer, | |
| doc_id integer, | |
| compound_key character varying(250), | |
| compound_name text, | |
| src_id integer, | |
| src_compound_id character varying(100) | |
| ); | |
| -- | |
| -- TOC entry 2733 (class 1259 OID 33528) | |
| -- Dependencies: 9 | |
| -- Name: compound_structures; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE compound_structures ( | |
| molregno integer NOT NULL, | |
| molfile text, | |
| standard_inchi text, | |
| standard_inchi_key character varying(50), | |
| canonical_smiles text, | |
| non_standard_inchi text, | |
| non_standard_inchi_key character varying(50), | |
| molformula character varying(100) | |
| ); | |
| -- | |
| -- TOC entry 2720 (class 1259 OID 33413) | |
| -- Dependencies: 9 | |
| -- Name: confidence_score_lookup; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE confidence_score_lookup ( | |
| confidence_score integer NOT NULL, | |
| description character varying(250), | |
| target_mapping character varying(30) | |
| ); | |
| -- | |
| -- TOC entry 2727 (class 1259 OID 33471) | |
| -- Dependencies: 9 | |
| -- Name: curation_lookup; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE curation_lookup ( | |
| curated_by character varying(20) NOT NULL, | |
| decription character varying(100) | |
| ); | |
| -- | |
| -- TOC entry 2741 (class 1259 OID 71154) | |
| -- Dependencies: 9 | |
| -- Name: defined_daily_dose; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE defined_daily_dose ( | |
| atc_code character varying(20) NOT NULL, | |
| ddd_value double precision, | |
| ddd_units character varying(20), | |
| ddd_admr character varying(20), | |
| ddd_comment text, | |
| ddd_id bigint NOT NULL | |
| ); | |
| -- | |
| -- TOC entry 2734 (class 1259 OID 33537) | |
| -- Dependencies: 9 | |
| -- Name: docs; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE docs ( | |
| doc_id integer NOT NULL, | |
| journal character varying(50), | |
| year character varying(50), | |
| volume character varying(50), | |
| issue character varying(50), | |
| first_page character varying(50), | |
| last_page character varying(50), | |
| pubmed_id integer, | |
| doi character varying(50), | |
| chembl_id character varying(20), | |
| title text, | |
| doc_type character varying(50) | |
| ); | |
| -- | |
| -- TOC entry 2728 (class 1259 OID 33476) | |
| -- Dependencies: 9 | |
| -- Name: formulations; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE formulations ( | |
| product_id character varying(30) NOT NULL, | |
| ingredient character varying(200) NOT NULL, | |
| strength character varying(200), | |
| molregno integer | |
| ); | |
| -- | |
| -- TOC entry 2738 (class 1259 OID 33563) | |
| -- Dependencies: 9 | |
| -- Name: molecule_dictionary; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE molecule_dictionary ( | |
| molregno integer NOT NULL, | |
| pref_name character varying(255), | |
| chembl_id character varying(20), | |
| max_phase integer, | |
| therapeutic_flag integer, | |
| dosed_ingredient integer, | |
| structure_type character varying(10), | |
| chebi_id integer, | |
| chebi_par_id integer, | |
| molecule_type character varying(30), | |
| first_approval integer, | |
| oral integer, | |
| parenteral integer, | |
| topical integer, | |
| black_box_warning integer, | |
| natural_product integer, | |
| prodrug integer | |
| ); | |
| -- | |
| -- TOC entry 2719 (class 1259 OID 33405) | |
| -- Dependencies: 9 | |
| -- Name: molecule_hierarchy; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE molecule_hierarchy ( | |
| molregno integer NOT NULL, | |
| parent_molregno integer NOT NULL, | |
| active_molregno integer | |
| ); | |
| -- | |
| -- TOC entry 2737 (class 1259 OID 33557) | |
| -- Dependencies: 9 | |
| -- Name: molecule_synonyms; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE molecule_synonyms ( | |
| molregno integer NOT NULL, | |
| synonyms character varying(200) NOT NULL, | |
| syn_type character varying(50) NOT NULL, | |
| research_stem character varying(20) | |
| ); | |
| -- | |
| -- TOC entry 2729 (class 1259 OID 33483) | |
| -- Dependencies: 9 | |
| -- Name: products; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE products ( | |
| dosage_form character varying(200), | |
| route character varying(200), | |
| trade_name character varying(200), | |
| approval_date date, | |
| ad_type character varying(5), | |
| oral integer, | |
| topical integer, | |
| parenteral integer, | |
| information_source character varying(100), | |
| black_box_warning integer, | |
| applicant_full_name character varying(200), | |
| innovator_company integer, | |
| product_id character varying(30) NOT NULL | |
| ); | |
| -- | |
| -- TOC entry 2742 (class 1259 OID 71188) | |
| -- Dependencies: 9 | |
| -- Name: protein_therapeutics; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE protein_therapeutics ( | |
| molregno integer NOT NULL, | |
| protein_description text, | |
| protein_sequence text, | |
| protein_species character varying(100), | |
| protein_sequence_length integer, | |
| mature_peptide_sequence text | |
| ); | |
| -- | |
| -- TOC entry 2736 (class 1259 OID 33552) | |
| -- Dependencies: 9 | |
| -- Name: relationship_type; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE relationship_type ( | |
| relationship_type character(1) NOT NULL, | |
| relationship_desc character varying(250) | |
| ); | |
| -- | |
| -- TOC entry 2732 (class 1259 OID 33523) | |
| -- Dependencies: 9 | |
| -- Name: research_codes; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE research_codes ( | |
| stem character varying(20) NOT NULL, | |
| company character varying(100) NOT NULL, | |
| country character varying(50), | |
| previous_company character varying(100) | |
| ); | |
| -- | |
| -- TOC entry 2740 (class 1259 OID 33575) | |
| -- Dependencies: 9 | |
| -- Name: source; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE source ( | |
| src_id integer NOT NULL, | |
| src_description text | |
| ); | |
| -- | |
| -- TOC entry 2717 (class 1259 OID 33379) | |
| -- Dependencies: 9 | |
| -- Name: target_class; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE target_class ( | |
| tc_id integer NOT NULL, | |
| tid integer, | |
| l1 character varying(100), | |
| l2 character varying(100), | |
| l3 character varying(100), | |
| l4 character varying(100), | |
| l5 character varying(100), | |
| l6 character varying(100), | |
| l7 character varying(100), | |
| l8 character varying(100), | |
| target_classification character varying(250) | |
| ); | |
| -- | |
| -- TOC entry 2726 (class 1259 OID 33459) | |
| -- Dependencies: 9 | |
| -- Name: target_dictionary; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE target_dictionary ( | |
| tid integer NOT NULL, | |
| target_type character varying(25), | |
| db_source character varying(25), | |
| description text, | |
| gene_names text, | |
| pref_name character varying(200), | |
| synonyms text, | |
| keywords text, | |
| protein_sequence text, | |
| protein_md5sum character varying(32), | |
| tax_id integer, | |
| organism character varying(150), | |
| tissue character varying(50), | |
| strain character varying(25), | |
| db_version character varying(25), | |
| cell_line character varying(50), | |
| protein_accession character varying(25), | |
| ec_number character varying(50), | |
| chembl_id character varying(20) | |
| ); | |
| -- | |
| -- TOC entry 2735 (class 1259 OID 33547) | |
| -- Dependencies: 9 | |
| -- Name: target_type; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE target_type ( | |
| target_type character varying(25) NOT NULL, | |
| target_desc character varying(250) | |
| ); | |
| -- | |
| -- TOC entry 2718 (class 1259 OID 33388) | |
| -- Dependencies: 9 | |
| -- Name: version; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE version ( | |
| name character varying(20) NOT NULL, | |
| creation_date date, | |
| comments text | |
| ); | |
| -- | |
| -- TOC entry 3327 (class 2606 OID 33498) | |
| -- Dependencies: 2730 2730 | |
| -- Name: activities_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY activities | |
| ADD CONSTRAINT activities_pkey PRIMARY KEY (activity_id); | |
| -- | |
| -- TOC entry 3305 (class 2606 OID 33454) | |
| -- Dependencies: 2725 2725 2725 | |
| -- Name: assay2target_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY assay2target | |
| ADD CONSTRAINT assay2target_pkey PRIMARY KEY (assay_id, tid); | |
| -- | |
| -- TOC entry 3287 (class 2606 OID 33422) | |
| -- Dependencies: 2721 2721 | |
| -- Name: assay_type_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY assay_type | |
| ADD CONSTRAINT assay_type_pkey PRIMARY KEY (assay_type); | |
| -- | |
| -- TOC entry 3293 (class 2606 OID 33430) | |
| -- Dependencies: 2722 2722 | |
| -- Name: assays_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY assays | |
| ADD CONSTRAINT assays_pkey PRIMARY KEY (assay_id); | |
| -- | |
| -- TOC entry 3296 (class 2606 OID 33443) | |
| -- Dependencies: 2723 2723 | |
| -- Name: atc_classification_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY atc_classification | |
| ADD CONSTRAINT atc_classification_pkey PRIMARY KEY (level5); | |
| -- | |
| -- TOC entry 3354 (class 2606 OID 33574) | |
| -- Dependencies: 2739 2739 | |
| -- Name: chembl_id_lookup_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY chembl_id_lookup | |
| ADD CONSTRAINT chembl_id_lookup_pkey PRIMARY KEY (chembl_id); | |
| -- | |
| -- TOC entry 3299 (class 2606 OID 33448) | |
| -- Dependencies: 2724 2724 | |
| -- Name: compound_properties_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY compound_properties | |
| ADD CONSTRAINT compound_properties_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3332 (class 2606 OID 33510) | |
| -- Dependencies: 2731 2731 | |
| -- Name: compound_records_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY compound_records | |
| ADD CONSTRAINT compound_records_pkey PRIMARY KEY (record_id); | |
| -- | |
| -- TOC entry 3337 (class 2606 OID 33535) | |
| -- Dependencies: 2733 2733 | |
| -- Name: compound_structures_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY compound_structures | |
| ADD CONSTRAINT compound_structures_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3285 (class 2606 OID 33417) | |
| -- Dependencies: 2720 2720 | |
| -- Name: confidence_score_lookup_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY confidence_score_lookup | |
| ADD CONSTRAINT confidence_score_lookup_pkey PRIMARY KEY (confidence_score); | |
| -- | |
| -- TOC entry 3315 (class 2606 OID 33475) | |
| -- Dependencies: 2727 2727 | |
| -- Name: curation_lookup_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY curation_lookup | |
| ADD CONSTRAINT curation_lookup_pkey PRIMARY KEY (curated_by); | |
| -- | |
| -- TOC entry 3360 (class 2606 OID 71161) | |
| -- Dependencies: 2741 2741 | |
| -- Name: defined_daily_dose_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY defined_daily_dose | |
| ADD CONSTRAINT defined_daily_dose_pkey PRIMARY KEY (ddd_id); | |
| -- | |
| -- TOC entry 3339 (class 2606 OID 33544) | |
| -- Dependencies: 2734 2734 | |
| -- Name: docs_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY docs | |
| ADD CONSTRAINT docs_pkey PRIMARY KEY (doc_id); | |
| -- | |
| -- TOC entry 3319 (class 2606 OID 33480) | |
| -- Dependencies: 2728 2728 2728 | |
| -- Name: formulations_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY formulations | |
| ADD CONSTRAINT formulations_pkey PRIMARY KEY (product_id, ingredient); | |
| -- | |
| -- TOC entry 3351 (class 2606 OID 33567) | |
| -- Dependencies: 2738 2738 | |
| -- Name: molecule_dictionary_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY molecule_dictionary | |
| ADD CONSTRAINT molecule_dictionary_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3283 (class 2606 OID 33409) | |
| -- Dependencies: 2719 2719 | |
| -- Name: molecule_hierarchy_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY molecule_hierarchy | |
| ADD CONSTRAINT molecule_hierarchy_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3348 (class 2606 OID 33561) | |
| -- Dependencies: 2737 2737 2737 2737 | |
| -- Name: molecule_synonyms_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY molecule_synonyms | |
| ADD CONSTRAINT molecule_synonyms_pkey PRIMARY KEY (molregno, synonyms, syn_type); | |
| -- | |
| -- TOC entry 3321 (class 2606 OID 33490) | |
| -- Dependencies: 2729 2729 | |
| -- Name: products_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY products | |
| ADD CONSTRAINT products_pkey PRIMARY KEY (product_id); | |
| -- | |
| -- TOC entry 3363 (class 2606 OID 71195) | |
| -- Dependencies: 2742 2742 | |
| -- Name: protein_therapeutics_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY protein_therapeutics | |
| ADD CONSTRAINT protein_therapeutics_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3345 (class 2606 OID 33556) | |
| -- Dependencies: 2736 2736 | |
| -- Name: relationship_type_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY relationship_type | |
| ADD CONSTRAINT relationship_type_pkey PRIMARY KEY (relationship_type); | |
| -- | |
| -- TOC entry 3334 (class 2606 OID 33527) | |
| -- Dependencies: 2732 2732 2732 | |
| -- Name: research_codes_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY research_codes | |
| ADD CONSTRAINT research_codes_pkey PRIMARY KEY (stem, company); | |
| -- | |
| -- TOC entry 3357 (class 2606 OID 33582) | |
| -- Dependencies: 2740 2740 | |
| -- Name: source_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY source | |
| ADD CONSTRAINT source_pkey PRIMARY KEY (src_id); | |
| -- | |
| -- TOC entry 3276 (class 2606 OID 33386) | |
| -- Dependencies: 2717 2717 | |
| -- Name: target_class_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY target_class | |
| ADD CONSTRAINT target_class_pkey PRIMARY KEY (tc_id); | |
| -- | |
| -- TOC entry 3311 (class 2606 OID 33466) | |
| -- Dependencies: 2726 2726 | |
| -- Name: target_dictionary_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY target_dictionary | |
| ADD CONSTRAINT target_dictionary_pkey PRIMARY KEY (tid); | |
| -- | |
| -- TOC entry 3343 (class 2606 OID 33551) | |
| -- Dependencies: 2735 2735 | |
| -- Name: target_type_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY target_type | |
| ADD CONSTRAINT target_type_pkey PRIMARY KEY (target_type); | |
| -- | |
| -- TOC entry 3278 (class 2606 OID 33395) | |
| -- Dependencies: 2718 2718 | |
| -- Name: version_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY version | |
| ADD CONSTRAINT version_pkey PRIMARY KEY (name); | |
| -- | |
| -- TOC entry 3322 (class 1259 OID 33501) | |
| -- Dependencies: 2730 | |
| -- Name: activities_idx_assay_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX activities_idx_assay_id ON activities USING btree (assay_id); | |
| -- | |
| -- TOC entry 3323 (class 1259 OID 33499) | |
| -- Dependencies: 2730 | |
| -- Name: activities_idx_doc_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX activities_idx_doc_id ON activities USING btree (doc_id); | |
| -- | |
| -- TOC entry 3324 (class 1259 OID 33502) | |
| -- Dependencies: 2730 | |
| -- Name: activities_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX activities_idx_molregno ON activities USING btree (molregno); | |
| -- | |
| -- TOC entry 3325 (class 1259 OID 33500) | |
| -- Dependencies: 2730 | |
| -- Name: activities_idx_record_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX activities_idx_record_id ON activities USING btree (record_id); | |
| -- | |
| -- TOC entry 3300 (class 1259 OID 33455) | |
| -- Dependencies: 2725 | |
| -- Name: assay2target_idx_assay_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assay2target_idx_assay_id ON assay2target USING btree (assay_id); | |
| -- | |
| -- TOC entry 3301 (class 1259 OID 33457) | |
| -- Dependencies: 2725 | |
| -- Name: assay2target_idx_confidence_score; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assay2target_idx_confidence_score ON assay2target USING btree (confidence_score); | |
| -- | |
| -- TOC entry 3302 (class 1259 OID 33458) | |
| -- Dependencies: 2725 | |
| -- Name: assay2target_idx_relationship_type; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assay2target_idx_relationship_type ON assay2target USING btree (relationship_type); | |
| -- | |
| -- TOC entry 3303 (class 1259 OID 33456) | |
| -- Dependencies: 2725 | |
| -- Name: assay2target_idx_tid; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assay2target_idx_tid ON assay2target USING btree (tid); | |
| -- | |
| -- TOC entry 3288 (class 1259 OID 33435) | |
| -- Dependencies: 2722 | |
| -- Name: assays_idx_assay_type; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assays_idx_assay_type ON assays USING btree (assay_type); | |
| -- | |
| -- TOC entry 3289 (class 1259 OID 33433) | |
| -- Dependencies: 2722 | |
| -- Name: assays_idx_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assays_idx_chembl_id ON assays USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3290 (class 1259 OID 33432) | |
| -- Dependencies: 2722 | |
| -- Name: assays_idx_doc_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assays_idx_doc_id ON assays USING btree (doc_id); | |
| -- | |
| -- TOC entry 3291 (class 1259 OID 33434) | |
| -- Dependencies: 2722 | |
| -- Name: assays_idx_src_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX assays_idx_src_id ON assays USING btree (src_id); | |
| -- | |
| -- TOC entry 3297 (class 1259 OID 33449) | |
| -- Dependencies: 2724 | |
| -- Name: compound_properties_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX compound_properties_idx_molregno ON compound_properties USING btree (molregno); | |
| -- | |
| -- TOC entry 3328 (class 1259 OID 33512) | |
| -- Dependencies: 2731 | |
| -- Name: compound_records_idx_doc_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX compound_records_idx_doc_id ON compound_records USING btree (doc_id); | |
| -- | |
| -- TOC entry 3329 (class 1259 OID 33511) | |
| -- Dependencies: 2731 | |
| -- Name: compound_records_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX compound_records_idx_molregno ON compound_records USING btree (molregno); | |
| -- | |
| -- TOC entry 3330 (class 1259 OID 33513) | |
| -- Dependencies: 2731 | |
| -- Name: compound_records_idx_src_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX compound_records_idx_src_id ON compound_records USING btree (src_id); | |
| -- | |
| -- TOC entry 3335 (class 1259 OID 33536) | |
| -- Dependencies: 2733 | |
| -- Name: compound_structures_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX compound_structures_idx_molregno ON compound_structures USING btree (molregno); | |
| -- | |
| -- TOC entry 3358 (class 1259 OID 71162) | |
| -- Dependencies: 2741 | |
| -- Name: defined_daily_dose_idx_atc_code; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX defined_daily_dose_idx_atc_code ON defined_daily_dose USING btree (atc_code); | |
| -- | |
| -- TOC entry 3316 (class 1259 OID 33482) | |
| -- Dependencies: 2728 | |
| -- Name: formulations_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX formulations_idx_molregno ON formulations USING btree (molregno); | |
| -- | |
| -- TOC entry 3317 (class 1259 OID 33481) | |
| -- Dependencies: 2728 | |
| -- Name: formulations_idx_product_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX formulations_idx_product_id ON formulations USING btree (product_id); | |
| -- | |
| -- TOC entry 3355 (class 1259 OID 71205) | |
| -- Dependencies: 2739 2739 | |
| -- Name: idx_chembl_id_lookup_entity; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX idx_chembl_id_lookup_entity ON chembl_id_lookup USING btree (entity_type, entity_id); | |
| -- | |
| -- TOC entry 3340 (class 1259 OID 97055) | |
| -- Dependencies: 2734 | |
| -- Name: idx_docs_pubmed_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx_docs_pubmed_id ON docs USING btree (pubmed_id); | |
| -- | |
| -- TOC entry 3306 (class 1259 OID 71206) | |
| -- Dependencies: 2726 2726 | |
| -- Name: idx_target_dictionary_db_source; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx_target_dictionary_db_source ON target_dictionary USING btree (db_source, protein_accession); | |
| -- | |
| -- TOC entry 3307 (class 1259 OID 71207) | |
| -- Dependencies: 2726 2726 | |
| -- Name: idx_target_dictionary_protein_accession; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx_target_dictionary_protein_accession ON target_dictionary USING btree (protein_accession, db_source); | |
| -- | |
| -- TOC entry 3349 (class 1259 OID 33568) | |
| -- Dependencies: 2738 | |
| -- Name: molecule_dictionary_idx_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX molecule_dictionary_idx_chembl_id ON molecule_dictionary USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3279 (class 1259 OID 33410) | |
| -- Dependencies: 2719 | |
| -- Name: molecule_hierarchy_idx_active_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX molecule_hierarchy_idx_active_molregno ON molecule_hierarchy USING btree (active_molregno); | |
| -- | |
| -- TOC entry 3280 (class 1259 OID 33412) | |
| -- Dependencies: 2719 | |
| -- Name: molecule_hierarchy_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX molecule_hierarchy_idx_molregno ON molecule_hierarchy USING btree (molregno); | |
| -- | |
| -- TOC entry 3281 (class 1259 OID 33411) | |
| -- Dependencies: 2719 | |
| -- Name: molecule_hierarchy_idx_parent_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX molecule_hierarchy_idx_parent_molregno ON molecule_hierarchy USING btree (parent_molregno); | |
| -- | |
| -- TOC entry 3346 (class 1259 OID 33562) | |
| -- Dependencies: 2737 | |
| -- Name: molecule_synonyms_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX molecule_synonyms_idx_molregno ON molecule_synonyms USING btree (molregno); | |
| -- | |
| -- TOC entry 3361 (class 1259 OID 71196) | |
| -- Dependencies: 2742 | |
| -- Name: protein_therapeutics_idx_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX protein_therapeutics_idx_molregno ON protein_therapeutics USING btree (molregno); | |
| -- | |
| -- TOC entry 3274 (class 1259 OID 33387) | |
| -- Dependencies: 2717 | |
| -- Name: target_class_idx_tid; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX target_class_idx_tid ON target_class USING btree (tid); | |
| -- | |
| -- TOC entry 3308 (class 1259 OID 33470) | |
| -- Dependencies: 2726 | |
| -- Name: target_dictionary_idx_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX target_dictionary_idx_chembl_id ON target_dictionary USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3309 (class 1259 OID 33469) | |
| -- Dependencies: 2726 | |
| -- Name: target_dictionary_idx_target_type; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX target_dictionary_idx_target_type ON target_dictionary USING btree (target_type); | |
| -- | |
| -- TOC entry 3294 (class 1259 OID 33431) | |
| -- Dependencies: 2722 | |
| -- Name: uk_assays_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uk_assays_chembl_id ON assays USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3341 (class 1259 OID 33545) | |
| -- Dependencies: 2734 | |
| -- Name: uk_docs_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uk_docs_chembl_id ON docs USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3352 (class 1259 OID 33569) | |
| -- Dependencies: 2738 | |
| -- Name: uk_moldict_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uk_moldict_chembl_id ON molecule_dictionary USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3312 (class 1259 OID 33468) | |
| -- Dependencies: 2726 | |
| -- Name: uk_targdict_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uk_targdict_chembl_id ON target_dictionary USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3313 (class 1259 OID 33467) | |
| -- Dependencies: 2726 | |
| -- Name: uk_targdict_protacc; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uk_targdict_protacc ON target_dictionary USING btree (protein_accession); | |
| -- Completed on 2011-07-22 13:30:36 | |
| -- | |
| -- PostgreSQL database dump complete | |
| -- |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment