-- -- PostgreSQL database dump -- \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 2 (OID 1334064212) -- Name: rna; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE rna ( rna_no serial NOT NULL, gene_no integer, rna_type character varying(25), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 3 (OID 1334064222) -- Name: exon; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE exon ( exon_no serial NOT NULL, gene_no integer, start_position integer NOT NULL, end_position integer NOT NULL, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 4 (OID 1334064232) -- Name: polypeptide; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide ( polypeptide_no serial NOT NULL, polypeptide_name character varying(1000), sec_polypeptide_no integer, gene_no integer, polypeptide_length integer, description character varying(3000), note text, number_aa integer, mass_experim character varying(50), mass_calc character varying(50), mass_cleaves character varying(50), pi_calc character varying(50), pi_experim character varying(50), pi_cleaved character varying(50), tmh smallint, status integer DEFAULT 0, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, "sequence" text, short_name character varying(40), hmm_prob double precision, hmm_pos integer, number_tmhelices integer, polypeptide_acc character varying(10), replicon_no integer, go character varying(500) ); -- -- TOC entry 5 (OID 1334064244) -- Name: polypeptide2dblink; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide2dblink ( polypeptide_no integer NOT NULL, dblink_no integer NOT NULL, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 6 (OID 1334064253) -- Name: homology; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE homology ( homol_prot_no serial NOT NULL, polypeptide_no integer NOT NULL, length smallint NOT NULL, identity real NOT NULL, similarity real NOT NULL, gaps real NOT NULL, score integer NOT NULL, normalized_score double precision, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 7 (OID 1334064261) -- Name: polypeptide2pathway; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide2pathway ( polypeptide_no integer, pathway_no integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 8 (OID 1334064270) -- Name: genome; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE genome ( genome_no serial NOT NULL, genome_acc character varying(10), strain character varying(100), source character varying(255), "comment" character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, genome_name character varying(100), translation_case integer DEFAULT 1, ncbi_taxonomy_no integer, lineage text, deviation double precision, mean_codon_usage double precision, stat_sites integer, stat_regulons integer, stat_promoters integer, stat_pwms integer, protein_number integer, stat_profiles integer, stat_profile_genes integer, stat_genes integer, stat_pwms_nr integer ); -- -- TOC entry 9 (OID 1334064284) -- Name: gene; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE gene ( gene_no serial NOT NULL, sec_gene_acc character varying(8), sec_gene_no integer, gene_id character varying(30), genome_project_no character varying(20), "comment" character varying(500), genomic_context character varying(500), gene_length character varying(20), gc_content double precision, confidence_level integer, status integer DEFAULT 0, locus_tag text, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, gene_name character varying(1000), description character varying(3000), short_name character varying(40), temp_data character varying(50), gene_acc character varying(10), replicon_no integer ); -- -- TOC entry 10 (OID 1334064296) -- Name: condition2transcr_unit; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE condition2transcr_unit ( condition_no integer NOT NULL, transcr_unit_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 11 (OID 1334064304) -- Name: genomics_raw_data; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE genomics_raw_data ( genomics_raw_data_no serial NOT NULL, gene_no integer, experiment_no integer, probe_set_name character varying(50), signal numeric(9,1), detection character varying(5), detection_p_value numeric(9,6), "comment" character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 12 (OID 1334064314) -- Name: phenotype; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE phenotype ( phenotype_no serial NOT NULL, phenotype_acc character varying(8), phenotype_name character varying(255), description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 13 (OID 1334064324) -- Name: method; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE method ( method_no serial NOT NULL, method_code character(4), method_name character varying(80), is_from_go boolean, description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_method_no integer ); -- -- TOC entry 14 (OID 1334064334) -- Name: material; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE material ( material_no serial NOT NULL, material_name character varying(80), description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_material_no integer ); -- -- TOC entry 15 (OID 1334064342) -- Name: genome2experiment; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE genome2experiment ( genome_no integer NOT NULL, experiment_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 16 (OID 1334064349) -- Name: material2experiment; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE material2experiment ( material_no integer NOT NULL, experiment_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 17 (OID 1334064358) -- Name: db; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE db ( db_no serial NOT NULL, name character varying(30), description character varying(255), "comment" character varying(255), webaddr character varying(100), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 18 (OID 1334064368) -- Name: protein; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE protein ( protein_no serial NOT NULL, sec_protein_acc character varying(8), sec_protein_no integer, protein_id character varying(30), protein_name character varying(1000), "comment" character varying(500), genome_no integer, calc_mass real, experim_mass character varying(50), structure_txt character varying(4000), function_txt character varying(4000), status integer DEFAULT 0, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, short_name character varying(40), description character varying(3000), protein_acc character varying(10) ); -- -- TOC entry 19 (OID 1334064382) -- Name: journal; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE journal ( journal_no serial NOT NULL, journal_name character varying(80), pubmed_name character varying(80), issn character(9), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 20 (OID 1334064392) -- Name: reference; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE reference ( reference_no serial NOT NULL, reference_acc character varying(10), journal_no integer, authors character varying(800), title character varying(800), volume character varying(10), issue character varying(10), page character varying(17), "year" smallint, ui integer, pmid integer, corresp_author character varying(50), corresp_email character varying(50), abstract text, publication_type character varying(150), mesh text, "comment" character varying(255), status integer DEFAULT 0, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_reference_no integer ); -- -- TOC entry 21 (OID 1334064406) -- Name: catalog_table; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE catalog_table ( catalog_table_no serial NOT NULL, catalog_table_name character varying(50), description character varying(255), t_sql character varying(2000), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 22 (OID 1334064419) -- Name: condition; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE condition ( condition_no serial NOT NULL, condition_acc character varying(8), condition_name character varying(51), description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 23 (OID 1334064427) -- Name: site2interaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE site2interaction ( site_no integer NOT NULL, interaction_no integer NOT NULL, site_acc character varying(15), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 24 (OID 1334064434) -- Name: condition2interaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE condition2interaction ( condition_no integer NOT NULL, interaction_no integer NOT NULL, row_acc character varying(15), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 25 (OID 1334064443) -- Name: ec; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE ec ( ec_no serial NOT NULL, parent_no integer, ec_number character varying(15), enzyme_class character varying(500), sys_name character varying(500), "comment" character varying(2000), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 26 (OID 1334064456) -- Name: compound; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE compound ( compound_no serial NOT NULL, kegg_entry character(6), compound_name character varying(500), formula character varying(500), mass numeric(19,0), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, compound_acc character varying(10), description character varying(255) ); -- -- TOC entry 27 (OID 1334064466) -- Name: pathway; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE pathway ( pathway_no serial NOT NULL, "path" character varying(15), pathway_name character varying(500), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 28 (OID 1334064476) -- Name: interaction2pathway; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction2pathway ( interaction2pathway_no serial NOT NULL, interaction_no integer, pathway_no integer, reaction_direction integer, confidence_level integer, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 29 (OID 1334064484) -- Name: compound2ec; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE compound2ec ( ec_no integer NOT NULL, compound_no integer NOT NULL, role character varying(20) NOT NULL, in_out character varying(5), ion character varying(2), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 30 (OID 1334064491) -- Name: ec2protein; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE ec2protein ( ec_no integer NOT NULL, protein_no integer NOT NULL, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 31 (OID 1334064500) -- Name: genes_temp; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE genes_temp ( genes_temp_no serial NOT NULL, organism character varying(3), gene_number character varying(50), short_name character varying(50), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 32 (OID 1334064508) -- Name: ec2genes_temp; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE ec2genes_temp ( ec_no integer NOT NULL, genes_temp_no integer NOT NULL, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 33 (OID 1334064515) -- Name: gene2replicon; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE gene2replicon ( gene_no integer NOT NULL, replicon_no integer NOT NULL, start_position integer, end_position integer, orientation character varying(3), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 34 (OID 1334064522) -- Name: gene2transcr_unit; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE gene2transcr_unit ( gene_no integer NOT NULL, transcr_unit_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 35 (OID 1334064531) -- Name: site; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE site ( site_no serial NOT NULL, site_acc character varying(50), sec_acc character varying(50), sec_site_no integer, site_id character varying(50), site_name character varying(255), site_type integer, region character varying(50), element character varying(100), replicon_no integer, start_position_old integer, end_position_old integer, orientation_old character varying(3), "sequence" character varying(500), binding_factors character varying(100), description character varying(255), "comment" character varying(255), status integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, pos1 character varying(41), start_position integer, end_position integer, orientation character varying(3), confidence_level integer, motif_no integer ); -- -- TOC entry 36 (OID 1334064541) -- Name: promoter; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE promoter ( promoter_no serial NOT NULL, promoter_acc character varying(8), promoter_name character varying(100), description character varying(1000), transcr_unit_no integer, "comment" character varying(255), status integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_promoter_no integer ); -- -- TOC entry 37 (OID 1334064551) -- Name: transcr_unit; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE transcr_unit ( transcr_unit_no serial NOT NULL, transcr_unit_acc character varying(10), transcr_unit_id character varying(30), transcr_unit_name character varying(100), description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_transcr_unit integer, confidence_level integer, sec_transcr_unit_no integer ); -- -- TOC entry 38 (OID 1334064561) -- Name: matrix; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE matrix ( matrix_no serial NOT NULL, matrix_acc character varying(8), matrix_id character varying(21), matrix_name character varying(31), mata character varying(151), matc character varying(151), matg character varying(151), matt character varying(151), consensus_calc character varying(151), consensus_search character varying(151), matrix_size integer, description character varying(255), "comment" character varying(255), status integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 39 (OID 1334064569) -- Name: site2matrix_old; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE site2matrix_old ( site_no integer NOT NULL, matrix_no integer NOT NULL, gaps character varying(25), matrix_start integer, matrix_length integer, orientation character(1), alignment character varying(21), status integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 40 (OID 1334064576) -- Name: protein_state2interaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE protein_state2interaction ( protein_state_no integer NOT NULL, interaction_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_protein_acc character varying(8), educt_product smallint DEFAULT 0 ); -- -- TOC entry 41 (OID 1334064584) -- Name: compound2protein_state; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE compound2protein_state ( compound_no integer NOT NULL, protein_state_no integer NOT NULL, number integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 42 (OID 1334064593) -- Name: domain; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE "domain" ( domain_no serial NOT NULL, domain_name character varying(50), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 43 (OID 1334064601) -- Name: domain2polypeptide; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE domain2polypeptide ( domain_no integer NOT NULL, polypeptide_no integer NOT NULL, start_position integer, end_position integer, probability smallint, description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 44 (OID 1334064608) -- Name: site2promoter; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE site2promoter ( site_no integer NOT NULL, promoter_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 45 (OID 1334064617) -- Name: go; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE go ( go_no serial NOT NULL, go_name character varying(300) NOT NULL, functional_category character varying(100), go_type character varying(60) NOT NULL, go_acc character varying(40) NOT NULL, is_obsolete integer DEFAULT 0 NOT NULL, is_root integer DEFAULT 0 NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, go_definition character varying(3000) ); -- -- TOC entry 46 (OID 1334064632) -- Name: go2go; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE go2go ( go2go_no serial NOT NULL, relationship_type integer, parent_go_no integer, go_no integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 47 (OID 1334064641) -- Name: location; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE "location" ( location_no serial NOT NULL, location_name character varying(300) NOT NULL, location_acc character varying(15), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer, description character varying(255), "comment" character varying(255) ); -- -- TOC entry 48 (OID 1334064648) -- Name: condition2pathway; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE condition2pathway ( condition_no integer NOT NULL, pathway_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 49 (OID 1334064655) -- Name: condition2protein_state; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE condition2protein_state ( condition_no integer NOT NULL, protein_state_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 50 (OID 1334064664) -- Name: condition_collection; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE condition_collection ( condition_collection_no serial NOT NULL, condition_name character varying(100) NOT NULL, condition_description character varying(1000) NOT NULL, temperature double precision, light character varying(100), agitation boolean, aerobic_growth boolean, growth_phase character varying(100), carbon_source character varying(100), nitrogen_source character varying(100), main_energy_source character varying(100), medium_defined boolean, medium_composition character varying(100), stress_situation boolean, osmolarity double precision, ph double precision, defined_condition boolean, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(30) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(30) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 51 (OID 1334064672) -- Name: interaction_type2interaction_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction_type2interaction_type ( parent_interaction_type_no integer NOT NULL, interaction_type_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 52 (OID 1334064680) -- Name: interaction_pathway2interaction_pathway; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction_pathway2interaction_pathway ( interaction_pathway2interaction_pathway_no serial NOT NULL, parent_interaction2pathway_no integer, interaction2pathway_no integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 53 (OID 1334064687) -- Name: interaction_pathway2condition; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction_pathway2condition ( interaction2pathway_no integer NOT NULL, condition_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 54 (OID 1334064693) -- Name: interaction_pathway2location; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction_pathway2location ( interaction2pathway_no integer NOT NULL, location_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 55 (OID 1334064699) -- Name: location2interaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE location2interaction ( location_no integer NOT NULL, interaction_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 56 (OID 1334064705) -- Name: location2pathway; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE location2pathway ( location_no integer NOT NULL, pathway_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 57 (OID 1334064711) -- Name: location2protein_state; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE location2protein_state ( location_no integer NOT NULL, protein_state_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 58 (OID 1334064720) -- Name: go2polypeptide; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE go2polypeptide ( go2polypeptide_no serial NOT NULL, go_no integer, polypeptide_no integer, from_geneontology boolean DEFAULT false, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, evidence character varying(10) ); -- -- TOC entry 59 (OID 1334064730) -- Name: go2rna; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE go2rna ( go2rna_no serial NOT NULL, go_no integer, rna_no integer, from_geneontology boolean DEFAULT false, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 60 (OID 1334064740) -- Name: method2go_polypeptide; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE method2go_polypeptide ( method2go_polypeptide_no serial NOT NULL, method_no integer, go2polypeptide_no integer, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 61 (OID 1334064747) -- Name: db2method_go_polypeptide; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE db2method_go_polypeptide ( db_no integer, method2go_polypeptide_no integer, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 62 (OID 1334064755) -- Name: method2go_rna; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE method2go_rna ( method2go_rna_no serial NOT NULL, method_no integer, go2rna_no integer, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 63 (OID 1334064762) -- Name: db2method_go_rna; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE db2method_go_rna ( db_no integer, method2go_rna_no integer, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 64 (OID 1334064768) -- Name: expression_profile; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE expression_profile ( expression_profile_no integer NOT NULL, phenotype_no integer, row_no integer, column_no integer, mode_of_action integer, probe_set_name character varying(50), signal_log_ratio numeric(9,1), signal_log_ratio_low numeric(9,1), signal_log_ratio_high numeric(9,1), change character varying(3), change_p_value numeric(9,6), state1 integer, state2 integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 65 (OID 1334064775) -- Name: expression_profile2gene; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE expression_profile2gene ( expression_profile_no integer NOT NULL, gene_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 66 (OID 1334064782) -- Name: expression_profile2transcr_unit; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE expression_profile2transcr_unit ( expression_profile_no integer NOT NULL, transcr_unit_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 67 (OID 1334064791) -- Name: replicon; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE replicon ( replicon_no serial NOT NULL, genome_no integer, replicon_type character varying(50), replicon_name character varying(75), "sequence" text, replicon_size integer, g_frequency integer, c_frequency integer, a_frequency integer, t_frequency integer, acc_no character varying(25), "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, genome_name character varying(100) ); -- -- TOC entry 68 (OID 1334064804) -- Name: protein_state_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE protein_state_type ( protein_state_type_no serial NOT NULL, protein_state_type_name character varying(150), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 69 (OID 1334064814) -- Name: protein_state; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE protein_state ( protein_state_no serial NOT NULL, protein_state_type_no integer, protein_no integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, description character varying(2000), protein_state_acc character varying(10) ); -- -- TOC entry 70 (OID 1334064825) -- Name: polypeptide2protein_state; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide2protein_state ( polypeptide_no integer NOT NULL, protein_state_no integer NOT NULL, modified_polypeptide_no integer, number integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 71 (OID 1334064834) -- Name: dblink; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE dblink ( dblink_no serial NOT NULL, db_no integer, id character varying(15), acc character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 72 (OID 1334064844) -- Name: dblink2table; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE dblink2table ( dblink2table_no serial NOT NULL, dblink_no integer, table_no integer, row_no integer, column_no integer, "type" character varying(20), start_position integer, end_position integer, seq_mirror character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 73 (OID 1334064852) -- Name: method2experiment; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE method2experiment ( method_no integer NOT NULL, experiment_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 74 (OID 1334064860) -- Name: experiment; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE experiment ( experiment_no serial NOT NULL, experiment_name character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_experiment_no integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 75 (OID 1334064868) -- Name: gene_tab_ps1; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE gene_tab_ps1 ( gene_no integer NOT NULL, gene_acc character varying(8), gene_id character varying(30), short_name character varying(30), gene_name character varying(500), genome_project_no character varying(20), genome_no integer, pa_class_no integer, cog_no integer, go_no integer, description character varying(500), comment001 character varying(255), genomic_context character varying(500), gene_length character varying(20), gc_content double precision, confidence_level integer, status integer, creation timestamp(0) without time zone, creator character varying(15), lastupdate timestamp(0) without time zone, lastupdater character varying(15), restriction integer, temp_data character varying(50) ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 76 (OID 1334064875) -- Name: amino_acid; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE amino_acid ( amino_acid_no serial NOT NULL, amino_acid_name character varying(50), code_1 character(1), code_3 character(3), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 77 (OID 1334064885) -- Name: codon; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE codon ( codon_no serial NOT NULL, codon_name character(3), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, "comment" character varying(255) ); -- -- TOC entry 78 (OID 1334064893) -- Name: codon2amino_acid; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE codon2amino_acid ( codon_no integer, amino_acid_no integer, translation_case integer DEFAULT 1, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 79 (OID 1334064901) -- Name: amino_acid2genome; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE amino_acid2genome ( amino_acid_no integer NOT NULL, genome_no integer NOT NULL, frequency double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, frequency_abs integer ); -- -- TOC entry 80 (OID 1334064917) -- Name: polypeptide_kh; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide_kh ( polypeptide_no bigserial NOT NULL, short_name character varying(30), polypeptide_name character varying(255), gene_no integer, description character varying(255), "comment" character varying(255), "sequence" character varying(6000), number_aa integer, mass_calc character varying(50), pi_calc character varying(50), mass_experim character varying(50), pi_experim character varying(50), status integer, creation timestamp(0) without time zone, creator character varying(15), lastupdate timestamp(0) without time zone, lastupdater character varying(15), restriction integer, number_tmhelices integer, number_tmaa double precision, number_first60_tmaa double precision, nn_pos integer, nn_prob double precision, hmm_pos integer, hmm_prob character varying(15) ); -- -- TOC entry 81 (OID 1334064925) -- Name: reaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE reaction ( reaction_no serial NOT NULL, kegg_entry character(6), description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, interaction_no integer ); -- -- TOC entry 82 (OID 1334064933) -- Name: ec2reaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE ec2reaction ( ec_no integer NOT NULL, reaction_no integer NOT NULL, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 83 (OID 1334064940) -- Name: compound2reaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE compound2reaction ( compound_no integer NOT NULL, reaction_no integer NOT NULL, number character varying(10), educt_product character varying(7), hierarchy integer, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 84 (OID 1334064949) -- Name: reaction2pathway; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE reaction2pathway ( reaction2pathway_no serial NOT NULL, reaction_no integer, pathway_no integer, reaction_direction integer, confidence_level integer, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 85 (OID 1334064959) -- Name: interaction_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction_type ( interaction_type_no serial NOT NULL, interaction_type_name character varying(250) NOT NULL, description character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 86 (OID 1334064968) -- Name: synonym; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE synonym ( synonym_no serial NOT NULL, synonym_name character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 87 (OID 1334064976) -- Name: synonym2table; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE synonym2table ( synonym_no integer, table_no integer, row_no integer, column_no integer, hierarchy integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 88 (OID 1334064983) -- Name: interaction_tab_ps1; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction_tab_ps1 ( interaction_no integer NOT NULL, interaction_acc character varying(8), interaction_type integer, confidence_level integer, mode_of_action integer, kegg_entry character varying(10), description character varying(255), comment001 character varying(255), creation timestamp(0) without time zone, creator character varying(15), lastupdate timestamp(0) without time zone, lastupdater character varying(15), restriction integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 89 (OID 1334064987) -- Name: interaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction ( interaction_no serial NOT NULL, interaction_acc character varying(8), interaction_type_no integer, confidence_level integer, mode_of_action integer, description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, sec_interaction_no integer, reversible smallint DEFAULT 0, CONSTRAINT interaction_confidence_level CHECK (((confidence_level >= 0) AND (confidence_level <= 6))) ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 90 (OID 1334064997) -- Name: interaction2table; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction2table ( interaction2table_no integer, interaction_no integer, table_no integer, row_no integer, column_no integer, row_acc character varying(8), modification_no integer, number character varying(5), educt_product character varying(7), hierarchy integer, creation timestamp(0) without time zone, creator character varying(15), lastupdate timestamp(0) without time zone, lastupdater character varying(15), restriction integer ); -- -- TOC entry 91 (OID 1334064999) -- Name: interaction2table_tab_ps1; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE interaction2table_tab_ps1 ( interaction2table_no integer NOT NULL, interaction_no integer, table_no integer, row_no integer, column_no integer, row_acc character varying(8), modification_no integer, number character varying(5), educt_product character varying(7), hierarchy integer, creation timestamp(0) without time zone, creator character varying(15), lastupdate timestamp(0) without time zone, lastupdater character varying(15), restriction integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 92 (OID 1334065001) -- Name: reference2table; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE reference2table ( reference_no integer, table_no integer, row_no integer, column_no integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 93 (OID 1334065008) -- Name: replicon2transcr_unit; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE replicon2transcr_unit ( replicon_no integer NOT NULL, transcr_unit_no integer NOT NULL, confidence_level integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 94 (OID 1334065015) -- Name: genome2table_tab_ps1; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE genome2table_tab_ps1 ( genome2table_no integer NOT NULL, genome_no integer, table_no integer, row_no integer, column_no integer, motif_no integer, start_position integer, end_position integer, orientation character varying(3), confidence_level integer, creation timestamp(0) without time zone, creator character varying(15), lastupdate timestamp(0) without time zone, lastupdater character varying(15), restriction integer ); -- -- TOC entry 95 (OID 1334065017) -- Name: genome_tab_ps1; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE genome_tab_ps1 ( genome_no integer NOT NULL, genome_acc character varying(10), organism_no integer, genome_name character varying(50), genome_size integer, source character varying(255), comment001 character varying(50), creation timestamp(0) without time zone, creator character varying(15), lastupdate timestamp(0) without time zone, lastupdater character varying(15), restriction integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 96 (OID 1334065021) -- Name: motif2replicon; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE motif2replicon ( motif2replicon_no serial NOT NULL, motif_no integer, replicon_no integer, start_position integer, end_position integer, orientation character varying(3), "sequence" character varying(500), description character varying(255), "comment" character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, genome2table_no integer, confidence_level integer ); -- -- TOC entry 97 (OID 1334065031) -- Name: motif; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE motif ( motif_no serial NOT NULL, motif_name character varying(100), description character varying(255), "comment" character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 98 (OID 1334065039) -- Name: motif2site; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE motif2site ( motif2replicon_no integer, site_no integer, confidence_level integer, description character varying(255), "comment" character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 99 (OID 1334065046) -- Name: motif2promoter; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE motif2promoter ( motif2replicon_no integer NOT NULL, promoter_no integer NOT NULL, confidence_level integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 100 (OID 1334065053) -- Name: stop_codon2genome; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE stop_codon2genome ( genome_no integer NOT NULL, codon_no integer NOT NULL, codon_bias double precision, frequency double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, frequency_abs integer ); -- -- TOC entry 101 (OID 1334065060) -- Name: start_codon2genome; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE start_codon2genome ( genome_no integer NOT NULL, codon_no integer NOT NULL, codon_bias double precision, frequency double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, frequency_abs integer ); -- -- TOC entry 102 (OID 1334065067) -- Name: protein_state2matrix; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE protein_state2matrix ( protein_state_no integer NOT NULL, matrix_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 103 (OID 1334065074) -- Name: experiment2interaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE experiment2interaction ( experiment_no integer NOT NULL, interaction_no integer NOT NULL, "comment" character varying(500), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 104 (OID 1334065081) -- Name: stop_codon2replicon; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE stop_codon2replicon ( replicon_no integer NOT NULL, codon_no integer NOT NULL, codon_bias double precision, frequency double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, frequency_abs integer ); -- -- TOC entry 105 (OID 1334065088) -- Name: start_codon2replicon; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE start_codon2replicon ( replicon_no integer NOT NULL, codon_no integer NOT NULL, codon_bias double precision, frequency double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, frequency_abs integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 106 (OID 1334065095) -- Name: compound2interaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE compound2interaction ( compound_no integer NOT NULL, interaction_no integer NOT NULL, educt_product smallint DEFAULT 0, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 107 (OID 1334065105) -- Name: modification; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE modification ( modification_no serial NOT NULL, modification_name character varying(255), description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 108 (OID 1334065113) -- Name: polypeptide2modified_polypeptide; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide2modified_polypeptide ( polypeptide_no integer NOT NULL, modified_polypeptide_no integer NOT NULL, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 109 (OID 1334065122) -- Name: polypeptide2modification; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide2modification ( polypeptide2modification_no serial NOT NULL, polypeptide_no integer NOT NULL, modification_no integer NOT NULL, start_position integer, end_position integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 110 (OID 1334065132) -- Name: site2matrix; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE site2matrix ( site2matrix_no serial NOT NULL, site_no integer NOT NULL, matrix_no integer NOT NULL, gaps character varying(25), matrix_start integer, matrix_length integer, orientation character(1), alignment character varying(21), status integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 111 (OID 1334065142) -- Name: profile; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE profile ( profile_no serial NOT NULL, interaction_no integer NOT NULL, gene_no integer NOT NULL, regulation character varying(5), fold_change double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 112 (OID 1334065150) -- Name: ncbi_taxonomy; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE ncbi_taxonomy ( taxonomy_id integer, genome_no integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 113 (OID 1334065162) -- Name: class; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE "class" ( class_no serial NOT NULL, class_acc character varying(40), class_name character varying(300), class_type character varying(60), class_definition character varying(1500), creation timestamp without time zone DEFAULT now(), creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT now(), lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 114 (OID 1340395103) -- Name: gene2class; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE gene2class ( gene_no integer NOT NULL, class_no integer NOT NULL, creation timestamp without time zone DEFAULT now(), creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT now(), lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 115 (OID 1340851488) -- Name: codon2genome; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE codon2genome ( genome_no integer NOT NULL, codon_no integer NOT NULL, codon_bias double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, frequency double precision, "comment" character varying(255), frequency_abs integer, wij double precision ); -- -- TOC entry 116 (OID 1340863583) -- Name: test; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE test ( genome_no serial NOT NULL, genome_acc character varying(10), strain character varying(100), source character varying(255), "comment" character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, genome_name character varying(100), translation_case integer DEFAULT 1, ncbi_taxonomy_no integer, lineage text, mean_codon_usage double precision, deviation double precision ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 117 (OID 1340863957) -- Name: protein_gel; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE protein_gel ( protein_gel_no serial NOT NULL, genome_no integer, protein_gel_name character varying(50), protein_fraction character varying(50), description character varying(255), "comment" character varying(255), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 118 (OID 1340863973) -- Name: spot; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE spot ( spot_no serial NOT NULL, protein_gel_no integer NOT NULL, polypeptide_no integer NOT NULL, pi double precision, mw double precision, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 119 (OID 1347836484) -- Name: graph_path; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE graph_path ( graph_path_no serial NOT NULL, go1_no integer DEFAULT '0' NOT NULL, go2_no integer DEFAULT '0' NOT NULL, distance integer DEFAULT '0' NOT NULL ); -- -- TOC entry 120 (OID 1354652019) -- Name: polypeptide2class; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE polypeptide2class ( polypeptide_no integer NOT NULL, class_no integer NOT NULL, creation timestamp without time zone DEFAULT now(), creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT now(), lastupdater character varying(15) DEFAULT "current_user"(), restriction integer ); -- -- TOC entry 121 (OID 1382510669) -- Name: eu_genome; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE eu_genome ( eu_genome_no serial NOT NULL, genome_acc character varying(10), genome_name character varying(60), strain character varying(20), source character varying(255), translation_case integer DEFAULT 1, "comment" character varying(50), creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0, mean_codon_usage double precision, deviation double precision ); -- -- TOC entry 122 (OID 1382510689) -- Name: codon2eu_genome; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE codon2eu_genome ( eu_genome_no integer NOT NULL, codon_no integer NOT NULL, wij double precision, codon_bias double precision, frequency double precision, frequency_abs integer, creation timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, creator character varying(15) DEFAULT "current_user"(), lastupdate timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone, lastupdater character varying(15) DEFAULT "current_user"(), restriction integer DEFAULT 0 ); -- -- TOC entry 136 (OID 1340394202) -- Name: gene_short_name_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene_short_name_idx ON gene USING btree (short_name); -- -- TOC entry 132 (OID 1340394203) -- Name: gene_name_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene_name_idx ON gene USING btree (gene_name); -- -- TOC entry 170 (OID 1340394204) -- Name: gene2replicon_gene_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene2replicon_gene_no_idx ON gene2replicon USING btree (gene_no); -- -- TOC entry 171 (OID 1340394205) -- Name: gene2replicon_replicon_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene2replicon_replicon_no_idx ON gene2replicon USING btree (replicon_no); -- -- TOC entry 125 (OID 1340394206) -- Name: polypeptide_gene_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX polypeptide_gene_no_idx ON polypeptide USING btree (gene_no); -- -- TOC entry 220 (OID 1340394207) -- Name: polypeptide2protein_state_polypeptide_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX polypeptide2protein_state_polypeptide_no_idx ON polypeptide2protein_state USING btree (polypeptide_no); -- -- TOC entry 221 (OID 1340394208) -- Name: polypeptide2protein_state_protein_state_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX polypeptide2protein_state_protein_state_no_idx ON polypeptide2protein_state USING btree (protein_state_no); -- -- TOC entry 218 (OID 1340394209) -- Name: polypeptide2protein_state_modified_polypeptide_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX polypeptide2protein_state_modified_polypeptide_no_idx ON polypeptide2protein_state USING btree (modified_polypeptide_no); -- -- TOC entry 217 (OID 1340394210) -- Name: protein_state_protein_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX protein_state_protein_no_idx ON protein_state USING btree (protein_no); -- -- TOC entry 150 (OID 1340394211) -- Name: protein_short_name_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX protein_short_name_idx ON protein USING btree (short_name); -- -- TOC entry 148 (OID 1340394212) -- Name: protein_name_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX protein_name_idx ON protein USING btree (protein_name); -- -- TOC entry 151 (OID 1340394213) -- Name: protein_structure_txt_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX protein_structure_txt_idx ON protein USING btree (structure_txt); -- -- TOC entry 146 (OID 1340394214) -- Name: protein_function_txt_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX protein_function_txt_idx ON protein USING btree (function_txt); -- -- TOC entry 147 (OID 1340394215) -- Name: protein_genome_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX protein_genome_no_idx ON protein USING btree (genome_no); -- -- TOC entry 135 (OID 1340395123) -- Name: gene_replicon_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene_replicon_no_idx ON gene USING btree (replicon_no); -- -- TOC entry 127 (OID 1340395125) -- Name: polypeptide_replicon_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX polypeptide_replicon_no_idx ON polypeptide USING btree (replicon_no); -- -- TOC entry 253 (OID 1340395126) -- Name: class_class_name_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX class_class_name_idx ON "class" USING btree (class_name); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 257 (OID 1340395129) -- Name: gene2class_gene_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene2class_gene_no_idx ON gene2class USING btree (gene_no); -- -- TOC entry 256 (OID 1340395130) -- Name: gene2class_class_no_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene2class_class_no_idx ON gene2class USING btree (class_no); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 133 (OID 1340864441) -- Name: gene_orf_id_idx; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX gene_orf_id_idx ON gene USING btree (genome_project_no); -- -- TOC entry 262 (OID 1347836500) -- Name: graph_path_go1_no; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX graph_path_go1_no ON graph_path USING btree (go1_no); -- -- TOC entry 263 (OID 1347836501) -- Name: graph_path_go2_no; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX graph_path_go2_no ON graph_path USING btree (go2_no); -- -- TOC entry 222 (OID 1353790072) -- Name: acc; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX acc ON dblink USING btree (acc); -- -- TOC entry 180 (OID 1353790073) -- Name: go_acc; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX go_acc ON go USING btree (go_acc); -- -- TOC entry 181 (OID 1353790074) -- Name: go_definition; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX go_definition ON go USING btree (go_definition); -- -- TOC entry 183 (OID 1353790075) -- Name: go_name; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX go_name ON go USING btree (go_name); -- -- TOC entry 123 (OID 1340394221) -- Name: rna_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY rna ADD CONSTRAINT rna_pkey PRIMARY KEY (rna_no); -- -- TOC entry 124 (OID 1340394223) -- Name: exon_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY exon ADD CONSTRAINT exon_pkey PRIMARY KEY (exon_no); -- -- TOC entry 126 (OID 1340394225) -- Name: polypeptide_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide ADD CONSTRAINT polypeptide_pkey PRIMARY KEY (polypeptide_no); -- -- TOC entry 128 (OID 1340394227) -- Name: polypeptide2dblink_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2dblink ADD CONSTRAINT polypeptide2dblink_pkey PRIMARY KEY (polypeptide_no, dblink_no); -- -- TOC entry 129 (OID 1340394229) -- Name: homology_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY homology ADD CONSTRAINT homology_pkey PRIMARY KEY (homol_prot_no, polypeptide_no); -- -- TOC entry 131 (OID 1340394231) -- Name: genome_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genome ADD CONSTRAINT genome_pkey PRIMARY KEY (genome_no); -- -- TOC entry 130 (OID 1340394233) -- Name: genome_genome_acc_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genome ADD CONSTRAINT genome_genome_acc_key UNIQUE (genome_acc); -- -- TOC entry 134 (OID 1340394235) -- Name: gene_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene ADD CONSTRAINT gene_pkey PRIMARY KEY (gene_no); -- -- TOC entry 137 (OID 1340394237) -- Name: condition2transcr_unit_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2transcr_unit ADD CONSTRAINT condition2transcr_unit_pkey PRIMARY KEY (condition_no, transcr_unit_no); -- -- TOC entry 138 (OID 1340394239) -- Name: genomics_raw_data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genomics_raw_data ADD CONSTRAINT genomics_raw_data_pkey PRIMARY KEY (genomics_raw_data_no); -- -- TOC entry 140 (OID 1340394241) -- Name: phenotype_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY phenotype ADD CONSTRAINT phenotype_pkey PRIMARY KEY (phenotype_no); -- -- TOC entry 139 (OID 1340394243) -- Name: phenotype_phenotype_acc_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY phenotype ADD CONSTRAINT phenotype_phenotype_acc_key UNIQUE (phenotype_acc); -- -- TOC entry 141 (OID 1340394245) -- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method ADD CONSTRAINT method_pkey PRIMARY KEY (method_no); -- -- TOC entry 142 (OID 1340394247) -- Name: material_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY material ADD CONSTRAINT material_pkey PRIMARY KEY (material_no); -- -- TOC entry 143 (OID 1340394249) -- Name: genome2experiment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genome2experiment ADD CONSTRAINT genome2experiment_pkey PRIMARY KEY (genome_no, experiment_no); -- -- TOC entry 144 (OID 1340394251) -- Name: material2experiment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY material2experiment ADD CONSTRAINT material2experiment_pkey PRIMARY KEY (material_no, experiment_no); -- -- TOC entry 145 (OID 1340394253) -- Name: db_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY db ADD CONSTRAINT db_pkey PRIMARY KEY (db_no); -- -- TOC entry 149 (OID 1340394255) -- Name: protein_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein ADD CONSTRAINT protein_pkey PRIMARY KEY (protein_no); -- -- TOC entry 153 (OID 1340394257) -- Name: journal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY journal ADD CONSTRAINT journal_pkey PRIMARY KEY (journal_no); -- -- TOC entry 152 (OID 1340394259) -- Name: journal_journal_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY journal ADD CONSTRAINT journal_journal_name_key UNIQUE (journal_name); -- -- TOC entry 154 (OID 1340394261) -- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reference ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_no); -- -- TOC entry 156 (OID 1340394263) -- Name: catalog_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY catalog_table ADD CONSTRAINT catalog_table_pkey PRIMARY KEY (catalog_table_no); -- -- TOC entry 155 (OID 1340394265) -- Name: catalog_table_catalog_table_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY catalog_table ADD CONSTRAINT catalog_table_catalog_table_name_key UNIQUE (catalog_table_name); -- -- TOC entry 159 (OID 1340394267) -- Name: condition_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition ADD CONSTRAINT condition_pkey PRIMARY KEY (condition_no); -- -- TOC entry 157 (OID 1340394269) -- Name: condition_condition_acc_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition ADD CONSTRAINT condition_condition_acc_key UNIQUE (condition_acc); -- -- TOC entry 158 (OID 1340394271) -- Name: condition_condition_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition ADD CONSTRAINT condition_condition_name_key UNIQUE (condition_name); -- -- TOC entry 160 (OID 1340394273) -- Name: site2interaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2interaction ADD CONSTRAINT site2interaction_pkey PRIMARY KEY (site_no, interaction_no); -- -- TOC entry 161 (OID 1340394275) -- Name: condition2interaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2interaction ADD CONSTRAINT condition2interaction_pkey PRIMARY KEY (condition_no, interaction_no); -- -- TOC entry 162 (OID 1340394277) -- Name: ec_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec ADD CONSTRAINT ec_pkey PRIMARY KEY (ec_no); -- -- TOC entry 163 (OID 1340394279) -- Name: compound_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound ADD CONSTRAINT compound_pkey PRIMARY KEY (compound_no); -- -- TOC entry 164 (OID 1340394281) -- Name: pathway_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY pathway ADD CONSTRAINT pathway_pkey PRIMARY KEY (pathway_no); -- -- TOC entry 165 (OID 1340394283) -- Name: interaction2pathway_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction2pathway ADD CONSTRAINT interaction2pathway_pkey PRIMARY KEY (interaction2pathway_no); -- -- TOC entry 166 (OID 1340394285) -- Name: compound2ec_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2ec ADD CONSTRAINT compound2ec_pkey PRIMARY KEY (ec_no, compound_no, role); -- -- TOC entry 167 (OID 1340394287) -- Name: ec2protein_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2protein ADD CONSTRAINT ec2protein_pkey PRIMARY KEY (ec_no, protein_no); -- -- TOC entry 168 (OID 1340394289) -- Name: genes_temp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genes_temp ADD CONSTRAINT genes_temp_pkey PRIMARY KEY (genes_temp_no); -- -- TOC entry 169 (OID 1340394291) -- Name: ec2genes_temp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2genes_temp ADD CONSTRAINT ec2genes_temp_pkey PRIMARY KEY (genes_temp_no, ec_no); -- -- TOC entry 172 (OID 1340394293) -- Name: gene2transcr_unit_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2transcr_unit ADD CONSTRAINT gene2transcr_unit_pkey PRIMARY KEY (gene_no, transcr_unit_no); -- -- TOC entry 173 (OID 1340394295) -- Name: site_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site ADD CONSTRAINT site_pkey PRIMARY KEY (site_no); -- -- TOC entry 174 (OID 1340394297) -- Name: promoter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY promoter ADD CONSTRAINT promoter_pkey PRIMARY KEY (promoter_no); -- -- TOC entry 175 (OID 1340394299) -- Name: transcr_unit_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY transcr_unit ADD CONSTRAINT transcr_unit_pkey PRIMARY KEY (transcr_unit_no); -- -- TOC entry 176 (OID 1340394301) -- Name: matrix_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY matrix ADD CONSTRAINT matrix_pkey PRIMARY KEY (matrix_no); -- -- TOC entry 177 (OID 1340394303) -- Name: compound2protein_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2protein_state ADD CONSTRAINT compound2protein_state_pkey PRIMARY KEY (compound_no, protein_state_no); -- -- TOC entry 178 (OID 1340394305) -- Name: domain_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY "domain" ADD CONSTRAINT domain_pkey PRIMARY KEY (domain_no); -- -- TOC entry 179 (OID 1340394307) -- Name: site2promoter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2promoter ADD CONSTRAINT site2promoter_pkey PRIMARY KEY (site_no, promoter_no); -- -- TOC entry 184 (OID 1340394309) -- Name: go_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go ADD CONSTRAINT go_pkey PRIMARY KEY (go_no); -- -- TOC entry 182 (OID 1340394311) -- Name: go_go_acc_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go ADD CONSTRAINT go_go_acc_key UNIQUE (go_acc); -- -- TOC entry 185 (OID 1340394313) -- Name: go2go_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2go ADD CONSTRAINT go2go_pkey PRIMARY KEY (go2go_no); -- -- TOC entry 187 (OID 1340394315) -- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY "location" ADD CONSTRAINT location_pkey PRIMARY KEY (location_no); -- -- TOC entry 186 (OID 1340394317) -- Name: location_location_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY "location" ADD CONSTRAINT location_location_name_key UNIQUE (location_name); -- -- TOC entry 188 (OID 1340394319) -- Name: condition2pathway_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2pathway ADD CONSTRAINT condition2pathway_pkey PRIMARY KEY (condition_no, pathway_no); -- -- TOC entry 189 (OID 1340394321) -- Name: condition2protein_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2protein_state ADD CONSTRAINT condition2protein_state_pkey PRIMARY KEY (condition_no, protein_state_no); -- -- TOC entry 192 (OID 1340394323) -- Name: condition_collection_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition_collection ADD CONSTRAINT condition_collection_pkey PRIMARY KEY (condition_collection_no); -- -- TOC entry 191 (OID 1340394325) -- Name: condition_collection_condition_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition_collection ADD CONSTRAINT condition_collection_condition_name_key UNIQUE (condition_name); -- -- TOC entry 190 (OID 1340394327) -- Name: condition_collection_condition_description_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition_collection ADD CONSTRAINT condition_collection_condition_description_key UNIQUE (condition_description); -- -- TOC entry 193 (OID 1340394329) -- Name: interaction_type2interaction_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_type2interaction_type ADD CONSTRAINT interaction_type2interaction_type_pkey PRIMARY KEY (parent_interaction_type_no, interaction_type_no); -- -- TOC entry 195 (OID 1340394331) -- Name: interaction_pathway2interaction_pathway_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2interaction_pathway ADD CONSTRAINT interaction_pathway2interaction_pathway_pkey PRIMARY KEY (interaction_pathway2interaction_pathway_no); -- -- TOC entry 194 (OID 1340394333) -- Name: interaction_pathway2interacti_parent_interaction2pathway_no_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2interaction_pathway ADD CONSTRAINT interaction_pathway2interacti_parent_interaction2pathway_no_key UNIQUE (parent_interaction2pathway_no, interaction2pathway_no); -- -- TOC entry 196 (OID 1340394335) -- Name: interaction_pathway2condition_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2condition ADD CONSTRAINT interaction_pathway2condition_pkey PRIMARY KEY (interaction2pathway_no, condition_no); -- -- TOC entry 197 (OID 1340394337) -- Name: interaction_pathway2location_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2location ADD CONSTRAINT interaction_pathway2location_pkey PRIMARY KEY (interaction2pathway_no, location_no); -- -- TOC entry 198 (OID 1340394339) -- Name: location2interaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2interaction ADD CONSTRAINT location2interaction_pkey PRIMARY KEY (location_no, interaction_no); -- -- TOC entry 199 (OID 1340394341) -- Name: location2pathway_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2pathway ADD CONSTRAINT location2pathway_pkey PRIMARY KEY (pathway_no, location_no); -- -- TOC entry 200 (OID 1340394343) -- Name: location2protein_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2protein_state ADD CONSTRAINT location2protein_state_pkey PRIMARY KEY (location_no, protein_state_no); -- -- TOC entry 201 (OID 1340394345) -- Name: go2polypeptide_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2polypeptide ADD CONSTRAINT go2polypeptide_pkey PRIMARY KEY (go2polypeptide_no); -- -- TOC entry 204 (OID 1340394347) -- Name: go2rna_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2rna ADD CONSTRAINT go2rna_pkey PRIMARY KEY (go2rna_no); -- -- TOC entry 203 (OID 1340394349) -- Name: go2rna_go_no_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2rna ADD CONSTRAINT go2rna_go_no_key UNIQUE (go_no, rna_no); -- -- TOC entry 206 (OID 1340394351) -- Name: method2go_polypeptide_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_polypeptide ADD CONSTRAINT method2go_polypeptide_pkey PRIMARY KEY (method2go_polypeptide_no); -- -- TOC entry 205 (OID 1340394353) -- Name: method2go_polypeptide_method_no_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_polypeptide ADD CONSTRAINT method2go_polypeptide_method_no_key UNIQUE (method_no, go2polypeptide_no); -- -- TOC entry 207 (OID 1340394355) -- Name: db2method_go_polypeptide_db_no_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY db2method_go_polypeptide ADD CONSTRAINT db2method_go_polypeptide_db_no_key UNIQUE (db_no, method2go_polypeptide_no); -- -- TOC entry 209 (OID 1340394357) -- Name: method2go_rna_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_rna ADD CONSTRAINT method2go_rna_pkey PRIMARY KEY (method2go_rna_no); -- -- TOC entry 208 (OID 1340394359) -- Name: method2go_rna_method_no_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_rna ADD CONSTRAINT method2go_rna_method_no_key UNIQUE (method_no, go2rna_no); -- -- TOC entry 210 (OID 1340394361) -- Name: db2method_go_rna_db_no_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY db2method_go_rna ADD CONSTRAINT db2method_go_rna_db_no_key UNIQUE (db_no, method2go_rna_no); -- -- TOC entry 211 (OID 1340394363) -- Name: expression_profile_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile ADD CONSTRAINT expression_profile_pkey PRIMARY KEY (expression_profile_no); -- -- TOC entry 212 (OID 1340394365) -- Name: expression_profile2gene_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile2gene ADD CONSTRAINT expression_profile2gene_pkey PRIMARY KEY (expression_profile_no, gene_no); -- -- TOC entry 213 (OID 1340394367) -- Name: expression_profile2transcr_unit_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile2transcr_unit ADD CONSTRAINT expression_profile2transcr_unit_pkey PRIMARY KEY (expression_profile_no, transcr_unit_no); -- -- TOC entry 214 (OID 1340394369) -- Name: replicon_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY replicon ADD CONSTRAINT replicon_pkey PRIMARY KEY (replicon_no); -- -- TOC entry 215 (OID 1340394371) -- Name: protein_state_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state_type ADD CONSTRAINT protein_state_type_pkey PRIMARY KEY (protein_state_type_no); -- -- TOC entry 216 (OID 1340394373) -- Name: protein_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state ADD CONSTRAINT protein_state_pkey PRIMARY KEY (protein_state_no); -- -- TOC entry 219 (OID 1340394375) -- Name: polypeptide2protein_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2protein_state ADD CONSTRAINT polypeptide2protein_state_pkey PRIMARY KEY (polypeptide_no, protein_state_no); -- -- TOC entry 224 (OID 1340394377) -- Name: dblink_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dblink ADD CONSTRAINT dblink_pkey PRIMARY KEY (dblink_no); -- -- TOC entry 225 (OID 1340394379) -- Name: dblink2table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dblink2table ADD CONSTRAINT dblink2table_pkey PRIMARY KEY (dblink2table_no); -- -- TOC entry 226 (OID 1340394381) -- Name: method2experiment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2experiment ADD CONSTRAINT method2experiment_pkey PRIMARY KEY (method_no, experiment_no); -- -- TOC entry 227 (OID 1340394383) -- Name: experiment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY experiment ADD CONSTRAINT experiment_pkey PRIMARY KEY (experiment_no); -- -- TOC entry 228 (OID 1340394385) -- Name: amino_acid_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY amino_acid ADD CONSTRAINT amino_acid_pkey PRIMARY KEY (amino_acid_no); -- -- TOC entry 229 (OID 1340394387) -- Name: codon_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon ADD CONSTRAINT codon_pkey PRIMARY KEY (codon_no); -- -- TOC entry 230 (OID 1340394389) -- Name: amino_acid2genome_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY amino_acid2genome ADD CONSTRAINT amino_acid2genome_pkey PRIMARY KEY (amino_acid_no, genome_no); -- -- TOC entry 231 (OID 1340394393) -- Name: reaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reaction ADD CONSTRAINT reaction_pkey PRIMARY KEY (reaction_no); -- -- TOC entry 232 (OID 1340394395) -- Name: reaction2pathway_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reaction2pathway ADD CONSTRAINT reaction2pathway_pkey PRIMARY KEY (reaction2pathway_no); -- -- TOC entry 223 (OID 1340394397) -- Name: db_no_acc_idx; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dblink ADD CONSTRAINT db_no_acc_idx UNIQUE (db_no, acc); -- -- TOC entry 234 (OID 1340394399) -- Name: interaction_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_type ADD CONSTRAINT interaction_type_pkey PRIMARY KEY (interaction_type_no); -- -- TOC entry 233 (OID 1340394401) -- Name: interaction_type_interaction_type_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_type ADD CONSTRAINT interaction_type_interaction_type_name_key UNIQUE (interaction_type_name); -- -- TOC entry 235 (OID 1340394403) -- Name: synonym_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY synonym ADD CONSTRAINT synonym_pkey PRIMARY KEY (synonym_no); -- -- TOC entry 237 (OID 1340394405) -- Name: interaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction ADD CONSTRAINT interaction_pkey PRIMARY KEY (interaction_no); -- -- TOC entry 236 (OID 1340394407) -- Name: interaction_interaction_acc_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction ADD CONSTRAINT interaction_interaction_acc_key UNIQUE (interaction_acc); -- -- TOC entry 238 (OID 1340394409) -- Name: replicon2transcr_unit_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY replicon2transcr_unit ADD CONSTRAINT replicon2transcr_unit_pkey PRIMARY KEY (replicon_no, transcr_unit_no); -- -- TOC entry 239 (OID 1340394411) -- Name: motif2replicon_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2replicon ADD CONSTRAINT motif2replicon_pkey PRIMARY KEY (motif2replicon_no); -- -- TOC entry 240 (OID 1340394413) -- Name: motif_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif ADD CONSTRAINT motif_pkey PRIMARY KEY (motif_no); -- -- TOC entry 241 (OID 1340394415) -- Name: motif2promoter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2promoter ADD CONSTRAINT motif2promoter_pkey PRIMARY KEY (motif2replicon_no, promoter_no); -- -- TOC entry 242 (OID 1340394417) -- Name: stop_codon2genome_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY stop_codon2genome ADD CONSTRAINT stop_codon2genome_pkey PRIMARY KEY (codon_no, genome_no); -- -- TOC entry 243 (OID 1340394419) -- Name: start_codon2genome_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY start_codon2genome ADD CONSTRAINT start_codon2genome_pkey PRIMARY KEY (codon_no, genome_no); -- -- TOC entry 244 (OID 1340394421) -- Name: protein_state2matrix_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state2matrix ADD CONSTRAINT protein_state2matrix_pkey PRIMARY KEY (protein_state_no, matrix_no); -- -- TOC entry 245 (OID 1340394423) -- Name: experiment2interaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY experiment2interaction ADD CONSTRAINT experiment2interaction_pkey PRIMARY KEY (experiment_no, interaction_no); -- -- TOC entry 246 (OID 1340394425) -- Name: stop_codon2replicon_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY stop_codon2replicon ADD CONSTRAINT stop_codon2replicon_pkey PRIMARY KEY (codon_no, replicon_no); -- -- TOC entry 247 (OID 1340394427) -- Name: start_codon2replicon_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY start_codon2replicon ADD CONSTRAINT start_codon2replicon_pkey PRIMARY KEY (codon_no, replicon_no); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 248 (OID 1340394429) -- Name: modification_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY modification ADD CONSTRAINT modification_pkey PRIMARY KEY (modification_no); -- -- TOC entry 249 (OID 1340394431) -- Name: polypeptide2modified_polypeptide_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2modified_polypeptide ADD CONSTRAINT polypeptide2modified_polypeptide_pkey PRIMARY KEY (polypeptide_no, modified_polypeptide_no); -- -- TOC entry 250 (OID 1340394433) -- Name: polypeptide2modification_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2modification ADD CONSTRAINT polypeptide2modification_pkey PRIMARY KEY (polypeptide2modification_no); -- -- TOC entry 251 (OID 1340394435) -- Name: site2matrix_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2matrix ADD CONSTRAINT site2matrix_pkey PRIMARY KEY (site2matrix_no); -- -- TOC entry 252 (OID 1340394437) -- Name: profile_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY profile ADD CONSTRAINT profile_pkey PRIMARY KEY (profile_no); \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 254 (OID 1340394443) -- Name: class_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY "class" ADD CONSTRAINT class_pkey PRIMARY KEY (class_no); -- -- TOC entry 255 (OID 1340394445) -- Name: class_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY "class" ADD CONSTRAINT class_unique UNIQUE (class_acc); -- -- TOC entry 269 (OID 1340394449) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY rna ADD CONSTRAINT "$1" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 270 (OID 1340394453) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY exon ADD CONSTRAINT "$1" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 271 (OID 1340394457) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide ADD CONSTRAINT "$1" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 273 (OID 1340394461) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2dblink ADD CONSTRAINT "$1" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 274 (OID 1340394465) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY homology ADD CONSTRAINT "$1" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 276 (OID 1340394469) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2pathway ADD CONSTRAINT "$1" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 275 (OID 1340394473) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2pathway ADD CONSTRAINT "$2" FOREIGN KEY (pathway_no) REFERENCES pathway(pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 292 (OID 1340394477) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec ADD CONSTRAINT "$1" FOREIGN KEY (ec_no) REFERENCES ec(ec_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 294 (OID 1340394481) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction2pathway ADD CONSTRAINT "$2" FOREIGN KEY (pathway_no) REFERENCES pathway(pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 296 (OID 1340394485) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2ec ADD CONSTRAINT "$1" FOREIGN KEY (ec_no) REFERENCES ec(ec_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 295 (OID 1340394489) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2ec ADD CONSTRAINT "$2" FOREIGN KEY (compound_no) REFERENCES compound(compound_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 298 (OID 1340394493) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2protein ADD CONSTRAINT "$1" FOREIGN KEY (ec_no) REFERENCES ec(ec_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 297 (OID 1340394497) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2protein ADD CONSTRAINT "$2" FOREIGN KEY (protein_no) REFERENCES protein(protein_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 300 (OID 1340394501) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2genes_temp ADD CONSTRAINT "$1" FOREIGN KEY (ec_no) REFERENCES ec(ec_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 299 (OID 1340394505) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2genes_temp ADD CONSTRAINT "$2" FOREIGN KEY (genes_temp_no) REFERENCES genes_temp(genes_temp_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 302 (OID 1340394509) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2replicon ADD CONSTRAINT "$2" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 304 (OID 1340394513) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2transcr_unit ADD CONSTRAINT "$1" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 303 (OID 1340394517) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2transcr_unit ADD CONSTRAINT "$2" FOREIGN KEY (transcr_unit_no) REFERENCES transcr_unit(transcr_unit_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 306 (OID 1340394521) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY promoter ADD CONSTRAINT "$1" FOREIGN KEY (transcr_unit_no) REFERENCES transcr_unit(transcr_unit_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 308 (OID 1340394525) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2matrix_old ADD CONSTRAINT "$1" FOREIGN KEY (site_no) REFERENCES site(site_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 307 (OID 1340394529) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2matrix_old ADD CONSTRAINT "$2" FOREIGN KEY (matrix_no) REFERENCES matrix(matrix_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 312 (OID 1340394533) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2protein_state ADD CONSTRAINT "$1" FOREIGN KEY (compound_no) REFERENCES compound(compound_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 286 (OID 1340394537) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein ADD CONSTRAINT "$1" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 314 (OID 1340394541) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY domain2polypeptide ADD CONSTRAINT "$1" FOREIGN KEY (domain_no) REFERENCES "domain"(domain_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 313 (OID 1340394545) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY domain2polypeptide ADD CONSTRAINT "$2" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 316 (OID 1340394549) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2promoter ADD CONSTRAINT "$1" FOREIGN KEY (site_no) REFERENCES site(site_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 315 (OID 1340394553) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2promoter ADD CONSTRAINT "$2" FOREIGN KEY (promoter_no) REFERENCES promoter(promoter_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 287 (OID 1340394557) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reference ADD CONSTRAINT "$1" FOREIGN KEY (journal_no) REFERENCES journal(journal_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 291 (OID 1340394561) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2interaction ADD CONSTRAINT "$1" FOREIGN KEY (condition_no) REFERENCES condition(condition_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 283 (OID 1340394565) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genome2experiment ADD CONSTRAINT "$1" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 285 (OID 1340394569) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY material2experiment ADD CONSTRAINT "$1" FOREIGN KEY (material_no) REFERENCES material(material_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 279 (OID 1340394573) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2transcr_unit ADD CONSTRAINT "$1" FOREIGN KEY (condition_no) REFERENCES condition(condition_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 278 (OID 1340394577) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2transcr_unit ADD CONSTRAINT "$2" FOREIGN KEY (transcr_unit_no) REFERENCES transcr_unit(transcr_unit_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 281 (OID 1340394581) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genomics_raw_data ADD CONSTRAINT "$1" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 289 (OID 1340394585) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2interaction ADD CONSTRAINT "$1" FOREIGN KEY (site_no) REFERENCES site(site_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 319 (OID 1340394589) -- Name: go2go_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2go ADD CONSTRAINT go2go_fk1 FOREIGN KEY (relationship_type) REFERENCES go(go_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 318 (OID 1340394593) -- Name: go2go_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2go ADD CONSTRAINT go2go_fk2 FOREIGN KEY (parent_go_no) REFERENCES go(go_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 317 (OID 1340394597) -- Name: go2go_fk3; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2go ADD CONSTRAINT go2go_fk3 FOREIGN KEY (go_no) REFERENCES go(go_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 321 (OID 1340394601) -- Name: condition2pathway_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2pathway ADD CONSTRAINT condition2pathway_fk1 FOREIGN KEY (condition_no) REFERENCES condition(condition_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 320 (OID 1340394605) -- Name: condition2pathway_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2pathway ADD CONSTRAINT condition2pathway_fk2 FOREIGN KEY (pathway_no) REFERENCES pathway(pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 323 (OID 1340394609) -- Name: condition2protein_state_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2protein_state ADD CONSTRAINT condition2protein_state_fk1 FOREIGN KEY (condition_no) REFERENCES condition(condition_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 327 (OID 1340394613) -- Name: interaction_pathway2interaction_pathway_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2interaction_pathway ADD CONSTRAINT interaction_pathway2interaction_pathway_fk1 FOREIGN KEY (parent_interaction2pathway_no) REFERENCES interaction2pathway(interaction2pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 326 (OID 1340394617) -- Name: interaction_pathway2interaction_pathway_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2interaction_pathway ADD CONSTRAINT interaction_pathway2interaction_pathway_fk2 FOREIGN KEY (interaction2pathway_no) REFERENCES interaction2pathway(interaction2pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 329 (OID 1340394621) -- Name: interaction_pathway2condition_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2condition ADD CONSTRAINT interaction_pathway2condition_fk1 FOREIGN KEY (interaction2pathway_no) REFERENCES interaction2pathway(interaction2pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 328 (OID 1340394625) -- Name: interaction_pathway2condition_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2condition ADD CONSTRAINT interaction_pathway2condition_fk2 FOREIGN KEY (condition_no) REFERENCES condition(condition_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 331 (OID 1340394629) -- Name: interaction_pathway2location_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2location ADD CONSTRAINT interaction_pathway2location_fk1 FOREIGN KEY (interaction2pathway_no) REFERENCES interaction2pathway(interaction2pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 330 (OID 1340394633) -- Name: interaction_pathway2location_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_pathway2location ADD CONSTRAINT interaction_pathway2location_fk2 FOREIGN KEY (location_no) REFERENCES "location"(location_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 333 (OID 1340394637) -- Name: location2interaction_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2interaction ADD CONSTRAINT location2interaction_fk1 FOREIGN KEY (location_no) REFERENCES "location"(location_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 335 (OID 1340394641) -- Name: location2pathway_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2pathway ADD CONSTRAINT location2pathway_fk1 FOREIGN KEY (location_no) REFERENCES "location"(location_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 334 (OID 1340394645) -- Name: location2pathway_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2pathway ADD CONSTRAINT location2pathway_fk2 FOREIGN KEY (pathway_no) REFERENCES pathway(pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 337 (OID 1340394649) -- Name: location2protein_state_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2protein_state ADD CONSTRAINT location2protein_state_fk1 FOREIGN KEY (location_no) REFERENCES "location"(location_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 339 (OID 1340394653) -- Name: go2polypeptide_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2polypeptide ADD CONSTRAINT go2polypeptide_fk1 FOREIGN KEY (go_no) REFERENCES go(go_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 338 (OID 1340394657) -- Name: go2polypeptide_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2polypeptide ADD CONSTRAINT go2polypeptide_fk2 FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 341 (OID 1340394661) -- Name: go2rna_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2rna ADD CONSTRAINT go2rna_fk1 FOREIGN KEY (go_no) REFERENCES go(go_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 340 (OID 1340394665) -- Name: go2rna_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2rna ADD CONSTRAINT go2rna_fk2 FOREIGN KEY (rna_no) REFERENCES rna(rna_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 343 (OID 1340394669) -- Name: method2go_polypeptide_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_polypeptide ADD CONSTRAINT method2go_polypeptide_fk1 FOREIGN KEY (method_no) REFERENCES method(method_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 342 (OID 1340394673) -- Name: method2go_polypeptide_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_polypeptide ADD CONSTRAINT method2go_polypeptide_fk2 FOREIGN KEY (go2polypeptide_no) REFERENCES go2polypeptide(go2polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 345 (OID 1340394677) -- Name: db2method_go_polypeptide_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY db2method_go_polypeptide ADD CONSTRAINT db2method_go_polypeptide_fk1 FOREIGN KEY (db_no) REFERENCES db(db_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 344 (OID 1340394681) -- Name: db2method_go_polypeptide_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY db2method_go_polypeptide ADD CONSTRAINT db2method_go_polypeptide_fk2 FOREIGN KEY (method2go_polypeptide_no) REFERENCES method2go_polypeptide(method2go_polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 347 (OID 1340394685) -- Name: method2go_rna_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_rna ADD CONSTRAINT method2go_rna_fk1 FOREIGN KEY (method_no) REFERENCES method(method_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 346 (OID 1340394689) -- Name: method2go_rna_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2go_rna ADD CONSTRAINT method2go_rna_fk2 FOREIGN KEY (go2rna_no) REFERENCES go2rna(go2rna_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 349 (OID 1340394693) -- Name: db2method_go_rna_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY db2method_go_rna ADD CONSTRAINT db2method_go_rna_fk1 FOREIGN KEY (db_no) REFERENCES db(db_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 348 (OID 1340394697) -- Name: db2method_go_rna_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY db2method_go_rna ADD CONSTRAINT db2method_go_rna_fk2 FOREIGN KEY (method2go_rna_no) REFERENCES method2go_rna(method2go_rna_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 350 (OID 1340394701) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile ADD CONSTRAINT "$1" FOREIGN KEY (phenotype_no) REFERENCES phenotype(phenotype_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 352 (OID 1340394705) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile2gene ADD CONSTRAINT "$1" FOREIGN KEY (expression_profile_no) REFERENCES expression_profile(expression_profile_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 351 (OID 1340394709) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile2gene ADD CONSTRAINT "$2" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 354 (OID 1340394713) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile2transcr_unit ADD CONSTRAINT "$1" FOREIGN KEY (expression_profile_no) REFERENCES expression_profile(expression_profile_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 353 (OID 1340394717) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY expression_profile2transcr_unit ADD CONSTRAINT "$2" FOREIGN KEY (transcr_unit_no) REFERENCES transcr_unit(transcr_unit_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 355 (OID 1340394721) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY replicon ADD CONSTRAINT "$1" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 301 (OID 1340394725) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2replicon ADD CONSTRAINT "$1" FOREIGN KEY (replicon_no) REFERENCES replicon(replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 305 (OID 1340394729) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site ADD CONSTRAINT "$1" FOREIGN KEY (replicon_no) REFERENCES replicon(replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 357 (OID 1340394733) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state ADD CONSTRAINT "$1" FOREIGN KEY (protein_no) REFERENCES protein(protein_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 356 (OID 1340394737) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state ADD CONSTRAINT "$2" FOREIGN KEY (protein_state_type_no) REFERENCES protein_state_type(protein_state_type_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 311 (OID 1340394741) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2protein_state ADD CONSTRAINT "$2" FOREIGN KEY (protein_state_no) REFERENCES protein_state(protein_state_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 310 (OID 1340394745) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state2interaction ADD CONSTRAINT "$2" FOREIGN KEY (protein_state_no) REFERENCES protein_state(protein_state_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 322 (OID 1340394749) -- Name: condition2protein_state_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2protein_state ADD CONSTRAINT condition2protein_state_fk2 FOREIGN KEY (protein_state_no) REFERENCES protein_state(protein_state_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 336 (OID 1340394753) -- Name: location2protein_state_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2protein_state ADD CONSTRAINT location2protein_state_fk2 FOREIGN KEY (protein_state_no) REFERENCES protein_state(protein_state_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 359 (OID 1340394757) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2protein_state ADD CONSTRAINT "$1" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 358 (OID 1340394761) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2protein_state ADD CONSTRAINT "$2" FOREIGN KEY (protein_state_no) REFERENCES protein_state(protein_state_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 272 (OID 1340394765) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2dblink ADD CONSTRAINT "$2" FOREIGN KEY (dblink_no) REFERENCES dblink(dblink_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 360 (OID 1340394769) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dblink ADD CONSTRAINT "$1" FOREIGN KEY (db_no) REFERENCES db(db_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 362 (OID 1340394773) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dblink2table ADD CONSTRAINT "$1" FOREIGN KEY (dblink_no) REFERENCES dblink(dblink_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 361 (OID 1340394777) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dblink2table ADD CONSTRAINT "$2" FOREIGN KEY (table_no) REFERENCES catalog_table(catalog_table_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 282 (OID 1340394781) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genome2experiment ADD CONSTRAINT "$2" FOREIGN KEY (experiment_no) REFERENCES experiment(experiment_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 284 (OID 1340394785) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY material2experiment ADD CONSTRAINT "$2" FOREIGN KEY (experiment_no) REFERENCES experiment(experiment_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 365 (OID 1340394789) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2experiment ADD CONSTRAINT "$1" FOREIGN KEY (experiment_no) REFERENCES experiment(experiment_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 280 (OID 1340394793) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY genomics_raw_data ADD CONSTRAINT "$2" FOREIGN KEY (experiment_no) REFERENCES experiment(experiment_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 364 (OID 1340394797) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2experiment ADD CONSTRAINT "$2" FOREIGN KEY (method_no) REFERENCES method(method_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 363 (OID 1340394801) -- Name: $3; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY method2experiment ADD CONSTRAINT "$3" FOREIGN KEY (experiment_no) REFERENCES experiment(experiment_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 367 (OID 1340394805) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2amino_acid ADD CONSTRAINT "$1" FOREIGN KEY (codon_no) REFERENCES codon(codon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 366 (OID 1340394809) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2amino_acid ADD CONSTRAINT "$2" FOREIGN KEY (amino_acid_no) REFERENCES amino_acid(amino_acid_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 369 (OID 1340394813) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY amino_acid2genome ADD CONSTRAINT "$1" FOREIGN KEY (amino_acid_no) REFERENCES amino_acid(amino_acid_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 368 (OID 1340394817) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY amino_acid2genome ADD CONSTRAINT "$2" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 371 (OID 1340394829) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2reaction ADD CONSTRAINT "$1" FOREIGN KEY (ec_no) REFERENCES ec(ec_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 370 (OID 1340394833) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY ec2reaction ADD CONSTRAINT "$2" FOREIGN KEY (reaction_no) REFERENCES reaction(reaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 373 (OID 1340394837) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2reaction ADD CONSTRAINT "$1" FOREIGN KEY (compound_no) REFERENCES compound(compound_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 372 (OID 1340394841) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2reaction ADD CONSTRAINT "$2" FOREIGN KEY (reaction_no) REFERENCES reaction(reaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 375 (OID 1340394845) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reaction2pathway ADD CONSTRAINT "$1" FOREIGN KEY (reaction_no) REFERENCES reaction(reaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 374 (OID 1340394849) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reaction2pathway ADD CONSTRAINT "$2" FOREIGN KEY (pathway_no) REFERENCES pathway(pathway_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 325 (OID 1340394853) -- Name: interaction_type2interaction_type_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_type2interaction_type ADD CONSTRAINT interaction_type2interaction_type_fk1 FOREIGN KEY (parent_interaction_type_no) REFERENCES interaction_type(interaction_type_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 324 (OID 1340394857) -- Name: interaction_type2interaction_type_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction_type2interaction_type ADD CONSTRAINT interaction_type2interaction_type_fk2 FOREIGN KEY (interaction_type_no) REFERENCES interaction_type(interaction_type_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 377 (OID 1340394861) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY synonym2table ADD CONSTRAINT "$1" FOREIGN KEY (synonym_no) REFERENCES synonym(synonym_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 376 (OID 1340394865) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY synonym2table ADD CONSTRAINT "$2" FOREIGN KEY (table_no) REFERENCES catalog_table(catalog_table_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 309 (OID 1340394869) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state2interaction ADD CONSTRAINT "$1" FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 290 (OID 1340394873) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY condition2interaction ADD CONSTRAINT "$2" FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 288 (OID 1340394877) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2interaction ADD CONSTRAINT "$2" FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 332 (OID 1340394881) -- Name: location2interaction_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY location2interaction ADD CONSTRAINT location2interaction_fk2 FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 293 (OID 1340394885) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY interaction2pathway ADD CONSTRAINT "$1" FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 379 (OID 1340394889) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reference2table ADD CONSTRAINT "$1" FOREIGN KEY (reference_no) REFERENCES reference(reference_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 378 (OID 1340394893) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY reference2table ADD CONSTRAINT "$2" FOREIGN KEY (table_no) REFERENCES catalog_table(catalog_table_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 381 (OID 1340394897) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY replicon2transcr_unit ADD CONSTRAINT "$1" FOREIGN KEY (replicon_no) REFERENCES replicon(replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 380 (OID 1340394901) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY replicon2transcr_unit ADD CONSTRAINT "$2" FOREIGN KEY (transcr_unit_no) REFERENCES transcr_unit(transcr_unit_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 383 (OID 1340394905) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2replicon ADD CONSTRAINT "$1" FOREIGN KEY (replicon_no) REFERENCES replicon(replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 387 (OID 1340394909) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2promoter ADD CONSTRAINT "$1" FOREIGN KEY (motif2replicon_no) REFERENCES motif2replicon(motif2replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 386 (OID 1340394913) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2promoter ADD CONSTRAINT "$2" FOREIGN KEY (promoter_no) REFERENCES promoter(promoter_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 382 (OID 1340394917) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2replicon ADD CONSTRAINT "$2" FOREIGN KEY (motif_no) REFERENCES motif(motif_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 385 (OID 1340394921) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2site ADD CONSTRAINT "$1" FOREIGN KEY (motif2replicon_no) REFERENCES motif2replicon(motif2replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 384 (OID 1340394925) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY motif2site ADD CONSTRAINT "$2" FOREIGN KEY (site_no) REFERENCES site(site_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 391 (OID 1340394929) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY start_codon2genome ADD CONSTRAINT "$1" FOREIGN KEY (codon_no) REFERENCES codon(codon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 390 (OID 1340394933) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY start_codon2genome ADD CONSTRAINT "$2" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 389 (OID 1340394937) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY stop_codon2genome ADD CONSTRAINT "$1" FOREIGN KEY (codon_no) REFERENCES codon(codon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 388 (OID 1340394941) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY stop_codon2genome ADD CONSTRAINT "$2" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 393 (OID 1340394945) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state2matrix ADD CONSTRAINT "$1" FOREIGN KEY (protein_state_no) REFERENCES protein_state(protein_state_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 392 (OID 1340394949) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_state2matrix ADD CONSTRAINT "$2" FOREIGN KEY (matrix_no) REFERENCES matrix(matrix_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 395 (OID 1340394953) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY experiment2interaction ADD CONSTRAINT "$1" FOREIGN KEY (experiment_no) REFERENCES experiment(experiment_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 394 (OID 1340394957) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY experiment2interaction ADD CONSTRAINT "$2" FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 399 (OID 1340394961) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY start_codon2replicon ADD CONSTRAINT "$1" FOREIGN KEY (codon_no) REFERENCES codon(codon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 398 (OID 1340394965) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY start_codon2replicon ADD CONSTRAINT "$2" FOREIGN KEY (replicon_no) REFERENCES replicon(replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 397 (OID 1340394969) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY stop_codon2replicon ADD CONSTRAINT "$1" FOREIGN KEY (codon_no) REFERENCES codon(codon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 396 (OID 1340394973) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY stop_codon2replicon ADD CONSTRAINT "$2" FOREIGN KEY (replicon_no) REFERENCES replicon(replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 401 (OID 1340394977) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2interaction ADD CONSTRAINT "$1" FOREIGN KEY (compound_no) REFERENCES compound(compound_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 400 (OID 1340394981) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY compound2interaction ADD CONSTRAINT "$2" FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 403 (OID 1340394985) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2modified_polypeptide ADD CONSTRAINT "$1" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 402 (OID 1340394989) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2modified_polypeptide ADD CONSTRAINT "$2" FOREIGN KEY (modified_polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 405 (OID 1340394993) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2modification ADD CONSTRAINT "$1" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 404 (OID 1340394997) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2modification ADD CONSTRAINT "$2" FOREIGN KEY (modification_no) REFERENCES modification(modification_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 407 (OID 1340395001) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2matrix ADD CONSTRAINT "$1" FOREIGN KEY (site_no) REFERENCES site(site_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 406 (OID 1340395005) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY site2matrix ADD CONSTRAINT "$2" FOREIGN KEY (matrix_no) REFERENCES matrix(matrix_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 409 (OID 1340395009) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY profile ADD CONSTRAINT "$1" FOREIGN KEY (interaction_no) REFERENCES interaction(interaction_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 408 (OID 1340395013) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY profile ADD CONSTRAINT "$2" FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 410 (OID 1340395025) -- Name: class_fkey1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY "class" ADD CONSTRAINT class_fkey1 FOREIGN KEY (class_acc) REFERENCES go(go_acc) ON UPDATE NO ACTION ON DELETE NO ACTION; \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 258 (OID 1340395109) -- Name: gene2class_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2class ADD CONSTRAINT gene2class_pkey PRIMARY KEY (gene_no, class_no); -- -- TOC entry 412 (OID 1340395111) -- Name: gene2class_fkey1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2class ADD CONSTRAINT gene2class_fkey1 FOREIGN KEY (gene_no) REFERENCES gene(gene_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 411 (OID 1340395115) -- Name: gene2class_fkey2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene2class ADD CONSTRAINT gene2class_fkey2 FOREIGN KEY (class_no) REFERENCES "class"(class_no) ON UPDATE NO ACTION ON DELETE NO ACTION; \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 277 (OID 1340395119) -- Name: gene_fkey1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY gene ADD CONSTRAINT gene_fkey1 FOREIGN KEY (replicon_no) REFERENCES replicon(replicon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 259 (OID 1340863399) -- Name: codon2genome_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2genome ADD CONSTRAINT codon2genome_pkey PRIMARY KEY (codon_no, genome_no); -- -- TOC entry 414 (OID 1340863401) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2genome ADD CONSTRAINT "$1" FOREIGN KEY (codon_no) REFERENCES codon(codon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 413 (OID 1340863405) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2genome ADD CONSTRAINT "$2" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 260 (OID 1340863965) -- Name: protein_gel_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_gel ADD CONSTRAINT protein_gel_pkey PRIMARY KEY (protein_gel_no); -- -- TOC entry 415 (OID 1340863967) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY protein_gel ADD CONSTRAINT "$1" FOREIGN KEY (genome_no) REFERENCES genome(genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 261 (OID 1340863981) -- Name: spot_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spot ADD CONSTRAINT spot_pkey PRIMARY KEY (spot_no); -- -- TOC entry 417 (OID 1340863983) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spot ADD CONSTRAINT "$1" FOREIGN KEY (protein_gel_no) REFERENCES protein_gel(protein_gel_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 416 (OID 1340863987) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spot ADD CONSTRAINT "$2" FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 264 (OID 1347836490) -- Name: graph_path_pk; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY graph_path ADD CONSTRAINT graph_path_pk PRIMARY KEY (graph_path_no); -- -- TOC entry 419 (OID 1347836492) -- Name: graph_path_fk1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY graph_path ADD CONSTRAINT graph_path_fk1 FOREIGN KEY (go1_no) REFERENCES go(go_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 418 (OID 1347836496) -- Name: graph_path_fk2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY graph_path ADD CONSTRAINT graph_path_fk2 FOREIGN KEY (go2_no) REFERENCES go(go_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 202 (OID 1348498969) -- Name: go2polypeptide_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY go2polypeptide ADD CONSTRAINT go2polypeptide_unique UNIQUE (go_no, polypeptide_no, evidence); -- -- TOC entry 265 (OID 1354652025) -- Name: polypeptide2class_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2class ADD CONSTRAINT polypeptide2class_pkey PRIMARY KEY (polypeptide_no, class_no); -- -- TOC entry 421 (OID 1354652027) -- Name: polypeptide2class_fkey1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2class ADD CONSTRAINT polypeptide2class_fkey1 FOREIGN KEY (polypeptide_no) REFERENCES polypeptide(polypeptide_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 420 (OID 1354652031) -- Name: polypeptide2class_fkey2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY polypeptide2class ADD CONSTRAINT polypeptide2class_fkey2 FOREIGN KEY (class_no) REFERENCES "class"(class_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 267 (OID 1382510685) -- Name: eu_genome_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY eu_genome ADD CONSTRAINT eu_genome_pkey PRIMARY KEY (eu_genome_no); -- -- TOC entry 266 (OID 1382510687) -- Name: eu_genome_genome_acc_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY eu_genome ADD CONSTRAINT eu_genome_genome_acc_key UNIQUE (genome_acc); -- -- TOC entry 268 (OID 1382511144) -- Name: codon2eu_genome_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2eu_genome ADD CONSTRAINT codon2eu_genome_pkey PRIMARY KEY (codon_no, eu_genome_no); -- -- TOC entry 423 (OID 1382511146) -- Name: $1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2eu_genome ADD CONSTRAINT "$1" FOREIGN KEY (codon_no) REFERENCES codon(codon_no) ON UPDATE NO ACTION ON DELETE NO ACTION; -- -- TOC entry 422 (OID 1382511150) -- Name: $2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY codon2eu_genome ADD CONSTRAINT "$2" FOREIGN KEY (eu_genome_no) REFERENCES eu_genome(eu_genome_no) ON UPDATE NO ACTION ON DELETE NO ACTION;