Created
August 12, 2011 08:25
-
-
Save aschreyer/1141693 to your computer and use it in GitHub Desktop.
PostgreSQL version of the ChEMBL11 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-08-12 09:23:17 | |
| 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 2939 (class 1259 OID 176057) | |
| -- Dependencies: 23 | |
| -- 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 2930 (class 1259 OID 175991) | |
| -- Dependencies: 23 | |
| -- 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 2924 (class 1259 OID 175937) | |
| -- Dependencies: 23 | |
| -- 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 2922 (class 1259 OID 175917) | |
| -- Dependencies: 23 | |
| -- 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), | |
| assay_category character varying(20) | |
| ); | |
| -- | |
| -- TOC entry 2923 (class 1259 OID 175929) | |
| -- Dependencies: 23 | |
| -- 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 2941 (class 1259 OID 176074) | |
| -- Dependencies: 23 | |
| -- 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, | |
| status character varying(50) | |
| ); | |
| -- | |
| -- TOC entry 2938 (class 1259 OID 176051) | |
| -- Dependencies: 23 | |
| -- 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), | |
| mol_id integer, | |
| 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 2919 (class 1259 OID 175893) | |
| -- Dependencies: 23 | |
| -- 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 2926 (class 1259 OID 175947) | |
| -- Dependencies: 23 | |
| -- 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, | |
| molformula character varying(100) | |
| ); | |
| -- | |
| -- TOC entry 2934 (class 1259 OID 176023) | |
| -- Dependencies: 23 | |
| -- 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 2925 (class 1259 OID 175942) | |
| -- Dependencies: 23 | |
| -- 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 2931 (class 1259 OID 176000) | |
| -- Dependencies: 23 | |
| -- 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 2932 (class 1259 OID 176008) | |
| -- Dependencies: 23 | |
| -- 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 2921 (class 1259 OID 175910) | |
| -- Dependencies: 23 | |
| -- 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 2920 (class 1259 OID 175904) | |
| -- Dependencies: 23 | |
| -- 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 2937 (class 1259 OID 176044) | |
| -- Dependencies: 23 | |
| -- 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 2927 (class 1259 OID 175956) | |
| -- Dependencies: 23 | |
| -- 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 2942 (class 1259 OID 176080) | |
| -- Dependencies: 23 | |
| -- Name: organism_class; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE organism_class ( | |
| oc_id integer NOT NULL, | |
| tax_id integer, | |
| l1 character varying(200), | |
| l2 character varying(200), | |
| l3 character varying(200) | |
| ); | |
| -- | |
| -- TOC entry 2928 (class 1259 OID 175962) | |
| -- Dependencies: 23 | |
| -- 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 2944 (class 1259 OID 198522) | |
| -- Dependencies: 23 | |
| -- 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 2940 (class 1259 OID 176069) | |
| -- Dependencies: 23 | |
| -- 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 2943 (class 1259 OID 176089) | |
| -- Dependencies: 23 | |
| -- 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 2935 (class 1259 OID 176028) | |
| -- Dependencies: 23 | |
| -- Name: source; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE source ( | |
| src_id integer NOT NULL, | |
| src_description text | |
| ); | |
| -- | |
| -- TOC entry 2918 (class 1259 OID 175884) | |
| -- Dependencies: 23 | |
| -- 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 2929 (class 1259 OID 175970) | |
| -- Dependencies: 23 | |
| -- 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 2933 (class 1259 OID 176018) | |
| -- Dependencies: 23 | |
| -- 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 2936 (class 1259 OID 176036) | |
| -- Dependencies: 23 | |
| -- Name: version; Type: TABLE; Schema: chembl; Owner: - | |
| -- | |
| CREATE TABLE version ( | |
| name character varying(20) NOT NULL, | |
| creation_date date, | |
| comments text | |
| ); | |
| -- | |
| -- TOC entry 3350 (class 2606 OID 176064) | |
| -- Dependencies: 2939 2939 | |
| -- Name: activities_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY activities | |
| ADD CONSTRAINT activities_pkey PRIMARY KEY (activity_id); | |
| -- | |
| -- TOC entry 3323 (class 2606 OID 175995) | |
| -- Dependencies: 2930 2930 2930 | |
| -- Name: assay2target_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY assay2target | |
| ADD CONSTRAINT assay2target_pkey PRIMARY KEY (assay_id, tid); | |
| -- | |
| -- TOC entry 3305 (class 2606 OID 175941) | |
| -- Dependencies: 2924 2924 | |
| -- 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 3297 (class 2606 OID 175924) | |
| -- Dependencies: 2922 2922 | |
| -- Name: assays_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY assays | |
| ADD CONSTRAINT assays_pkey PRIMARY KEY (assay_id); | |
| -- | |
| -- TOC entry 3303 (class 2606 OID 175936) | |
| -- Dependencies: 2923 2923 | |
| -- Name: atc_classification_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY atc_classification | |
| ADD CONSTRAINT atc_classification_pkey PRIMARY KEY (level5); | |
| -- | |
| -- TOC entry 3358 (class 2606 OID 176078) | |
| -- Dependencies: 2941 2941 | |
| -- 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 3347 (class 2606 OID 176055) | |
| -- Dependencies: 2938 2938 | |
| -- Name: compound_properties_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY compound_properties | |
| ADD CONSTRAINT compound_properties_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3285 (class 2606 OID 175900) | |
| -- Dependencies: 2919 2919 | |
| -- 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 3309 (class 2606 OID 175954) | |
| -- Dependencies: 2926 2926 | |
| -- Name: compound_structures_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY compound_structures | |
| ADD CONSTRAINT compound_structures_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3337 (class 2606 OID 176027) | |
| -- Dependencies: 2934 2934 | |
| -- 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 3307 (class 2606 OID 175946) | |
| -- Dependencies: 2925 2925 | |
| -- 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 3329 (class 2606 OID 176007) | |
| -- Dependencies: 2931 2931 | |
| -- 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 3331 (class 2606 OID 176015) | |
| -- Dependencies: 2932 2932 | |
| -- Name: docs_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY docs | |
| ADD CONSTRAINT docs_pkey PRIMARY KEY (doc_id); | |
| -- | |
| -- TOC entry 3293 (class 2606 OID 175914) | |
| -- Dependencies: 2921 2921 2921 | |
| -- Name: formulations_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY formulations | |
| ADD CONSTRAINT formulations_pkey PRIMARY KEY (product_id, ingredient); | |
| -- | |
| -- TOC entry 3290 (class 2606 OID 175908) | |
| -- Dependencies: 2920 2920 | |
| -- Name: molecule_dictionary_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY molecule_dictionary | |
| ADD CONSTRAINT molecule_dictionary_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3345 (class 2606 OID 176048) | |
| -- Dependencies: 2937 2937 | |
| -- Name: molecule_hierarchy_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY molecule_hierarchy | |
| ADD CONSTRAINT molecule_hierarchy_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3313 (class 2606 OID 175960) | |
| -- Dependencies: 2927 2927 2927 2927 | |
| -- 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 3361 (class 2606 OID 176087) | |
| -- Dependencies: 2942 2942 | |
| -- Name: organism_class_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY organism_class | |
| ADD CONSTRAINT organism_class_pkey PRIMARY KEY (oc_id); | |
| -- | |
| -- TOC entry 3315 (class 2606 OID 175969) | |
| -- Dependencies: 2928 2928 | |
| -- Name: products_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY products | |
| ADD CONSTRAINT products_pkey PRIMARY KEY (product_id); | |
| -- | |
| -- TOC entry 3367 (class 2606 OID 198529) | |
| -- Dependencies: 2944 2944 | |
| -- Name: protein_therapeutics_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY protein_therapeutics | |
| ADD CONSTRAINT protein_therapeutics_pkey PRIMARY KEY (molregno); | |
| -- | |
| -- TOC entry 3356 (class 2606 OID 176073) | |
| -- Dependencies: 2940 2940 | |
| -- 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 3364 (class 2606 OID 176093) | |
| -- Dependencies: 2943 2943 2943 | |
| -- 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 3339 (class 2606 OID 176035) | |
| -- Dependencies: 2935 2935 | |
| -- Name: source_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY source | |
| ADD CONSTRAINT source_pkey PRIMARY KEY (src_id); | |
| -- | |
| -- TOC entry 3283 (class 2606 OID 175891) | |
| -- Dependencies: 2918 2918 | |
| -- 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 3319 (class 2606 OID 175977) | |
| -- Dependencies: 2929 2929 | |
| -- Name: target_dictionary_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY target_dictionary | |
| ADD CONSTRAINT target_dictionary_pkey PRIMARY KEY (tid); | |
| -- | |
| -- TOC entry 3335 (class 2606 OID 176022) | |
| -- Dependencies: 2933 2933 | |
| -- 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 3341 (class 2606 OID 176043) | |
| -- Dependencies: 2936 2936 | |
| -- Name: version_pkey; Type: CONSTRAINT; Schema: chembl; Owner: - | |
| -- | |
| ALTER TABLE ONLY version | |
| ADD CONSTRAINT version_pkey PRIMARY KEY (name); | |
| -- | |
| -- TOC entry 3351 (class 1259 OID 176067) | |
| -- Dependencies: 2939 | |
| -- Name: idx__activities_assay_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__activities_assay_id ON activities USING btree (assay_id); | |
| -- | |
| -- TOC entry 3352 (class 1259 OID 176065) | |
| -- Dependencies: 2939 | |
| -- Name: idx__activities_doc_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__activities_doc_id ON activities USING btree (doc_id); | |
| -- | |
| -- TOC entry 3353 (class 1259 OID 176068) | |
| -- Dependencies: 2939 | |
| -- Name: idx__activities_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__activities_molregno ON activities USING btree (molregno); | |
| -- | |
| -- TOC entry 3354 (class 1259 OID 176066) | |
| -- Dependencies: 2939 | |
| -- Name: idx__activities_record_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__activities_record_id ON activities USING btree (record_id); | |
| -- | |
| -- TOC entry 3324 (class 1259 OID 175996) | |
| -- Dependencies: 2930 | |
| -- Name: idx__assay2target_assay_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__assay2target_assay_id ON assay2target USING btree (assay_id); | |
| -- | |
| -- TOC entry 3325 (class 1259 OID 175998) | |
| -- Dependencies: 2930 | |
| -- Name: idx__assay2target_confidence_score; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__assay2target_confidence_score ON assay2target USING btree (confidence_score); | |
| -- | |
| -- TOC entry 3326 (class 1259 OID 175999) | |
| -- Dependencies: 2930 | |
| -- Name: idx__assay2target_relationship_type; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__assay2target_relationship_type ON assay2target USING btree (relationship_type); | |
| -- | |
| -- TOC entry 3327 (class 1259 OID 175997) | |
| -- Dependencies: 2930 | |
| -- Name: idx__assay2target_tid; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__assay2target_tid ON assay2target USING btree (tid); | |
| -- | |
| -- TOC entry 3298 (class 1259 OID 175925) | |
| -- Dependencies: 2922 | |
| -- Name: idx__assays_assay_type; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__assays_assay_type ON assays USING btree (assay_type); | |
| -- | |
| -- TOC entry 3299 (class 1259 OID 175928) | |
| -- Dependencies: 2922 | |
| -- Name: idx__assays_doc_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__assays_doc_id ON assays USING btree (doc_id); | |
| -- | |
| -- TOC entry 3300 (class 1259 OID 175927) | |
| -- Dependencies: 2922 | |
| -- Name: idx__assays_src_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__assays_src_id ON assays USING btree (src_id); | |
| -- | |
| -- TOC entry 3348 (class 1259 OID 176056) | |
| -- Dependencies: 2938 | |
| -- Name: idx__compound_properties_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__compound_properties_molregno ON compound_properties USING btree (molregno); | |
| -- | |
| -- TOC entry 3286 (class 1259 OID 175901) | |
| -- Dependencies: 2919 | |
| -- Name: idx__compound_records_doc_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__compound_records_doc_id ON compound_records USING btree (doc_id); | |
| -- | |
| -- TOC entry 3287 (class 1259 OID 175902) | |
| -- Dependencies: 2919 | |
| -- Name: idx__compound_records_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__compound_records_molregno ON compound_records USING btree (molregno); | |
| -- | |
| -- TOC entry 3288 (class 1259 OID 175903) | |
| -- Dependencies: 2919 | |
| -- Name: idx__compound_records_src_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__compound_records_src_id ON compound_records USING btree (src_id); | |
| -- | |
| -- TOC entry 3310 (class 1259 OID 175955) | |
| -- Dependencies: 2926 | |
| -- Name: idx__compound_structures_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__compound_structures_molregno ON compound_structures USING btree (molregno); | |
| -- | |
| -- TOC entry 3332 (class 1259 OID 176017) | |
| -- Dependencies: 2932 | |
| -- Name: idx__docs_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__docs_chembl_id ON docs USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3294 (class 1259 OID 175916) | |
| -- Dependencies: 2921 | |
| -- Name: idx__formulations_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__formulations_molregno ON formulations USING btree (molregno); | |
| -- | |
| -- TOC entry 3295 (class 1259 OID 175915) | |
| -- Dependencies: 2921 | |
| -- Name: idx__formulations_product_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__formulations_product_id ON formulations USING btree (product_id); | |
| -- | |
| -- TOC entry 3342 (class 1259 OID 176049) | |
| -- Dependencies: 2937 | |
| -- Name: idx__molecule_hierarchy_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__molecule_hierarchy_molregno ON molecule_hierarchy USING btree (molregno); | |
| -- | |
| -- TOC entry 3343 (class 1259 OID 176050) | |
| -- Dependencies: 2937 | |
| -- Name: idx__molecule_hierarchy_parent_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__molecule_hierarchy_parent_molregno ON molecule_hierarchy USING btree (parent_molregno); | |
| -- | |
| -- TOC entry 3311 (class 1259 OID 175961) | |
| -- Dependencies: 2927 | |
| -- Name: idx__molecule_synonyms_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__molecule_synonyms_molregno ON molecule_synonyms USING btree (molregno); | |
| -- | |
| -- TOC entry 3365 (class 1259 OID 198530) | |
| -- Dependencies: 2944 | |
| -- Name: idx__protein_therapeutics_molregno; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__protein_therapeutics_molregno ON protein_therapeutics USING btree (molregno); | |
| -- | |
| -- TOC entry 3281 (class 1259 OID 175892) | |
| -- Dependencies: 2918 | |
| -- Name: idx__target_class_tid; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__target_class_tid ON target_class USING btree (tid); | |
| -- | |
| -- TOC entry 3316 (class 1259 OID 175981) | |
| -- Dependencies: 2929 | |
| -- Name: idx__target_dictionary_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__target_dictionary_chembl_id ON target_dictionary USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3317 (class 1259 OID 175979) | |
| -- Dependencies: 2929 | |
| -- Name: idx__target_dictionary_target_type; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE INDEX idx__target_dictionary_target_type ON target_dictionary USING btree (target_type); | |
| -- | |
| -- TOC entry 3301 (class 1259 OID 175926) | |
| -- Dependencies: 2922 | |
| -- Name: uqidx__assays_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uqidx__assays_chembl_id ON assays USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3359 (class 1259 OID 176079) | |
| -- Dependencies: 2941 2941 | |
| -- Name: uqidx__chembl_id_lookup_entity_id_entity_type; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uqidx__chembl_id_lookup_entity_id_entity_type ON chembl_id_lookup USING btree (entity_id, entity_type); | |
| -- | |
| -- TOC entry 3333 (class 1259 OID 176016) | |
| -- Dependencies: 2932 | |
| -- Name: uqidx__docs_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uqidx__docs_chembl_id ON docs USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3291 (class 1259 OID 175909) | |
| -- Dependencies: 2920 | |
| -- Name: uqidx__molecule_dictionary_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uqidx__molecule_dictionary_chembl_id ON molecule_dictionary USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3362 (class 1259 OID 176088) | |
| -- Dependencies: 2942 | |
| -- Name: uqidx__organism_class_tax_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uqidx__organism_class_tax_id ON organism_class USING btree (tax_id); | |
| -- | |
| -- TOC entry 3320 (class 1259 OID 175980) | |
| -- Dependencies: 2929 | |
| -- Name: uqidx__target_dictionary_chembl_id; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uqidx__target_dictionary_chembl_id ON target_dictionary USING btree (chembl_id); | |
| -- | |
| -- TOC entry 3321 (class 1259 OID 175978) | |
| -- Dependencies: 2929 | |
| -- Name: uqidx__target_dictionary_protein_accession; Type: INDEX; Schema: chembl; Owner: - | |
| -- | |
| CREATE UNIQUE INDEX uqidx__target_dictionary_protein_accession ON target_dictionary USING btree (protein_accession); | |
| -- Completed on 2011-08-12 09:23:44 | |
| -- | |
| -- PostgreSQL database dump complete | |
| -- |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment