--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- Name: assignchemicashift; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE assignchemicashift (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    details text,
    samplecondlabel character varying(127),
    chemshiftreflabel character varying(127),
    syscompname character varying(127),
    textdataformat character varying(127),
    textdata text
);


--
-- Name: authatmnomcat; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE authatmnomcat (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127)
);


--
-- Name: authoratomnom; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE authoratomnom (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    syscompname character varying(127),
    residueseqcode character varying(31),
    residuelabel character varying(31),
    atomname character varying(31),
    authoratomname character varying(31)
);


--
-- Name: biolfunclist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE biolfunclist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    biologicalfunction character varying(255)
);


--
-- Name: biolfuncmolsystem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE biolfuncmolsystem (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    namecommon character varying(255),
    abbreviationcommon character varying(127),
    ecnumber character varying(31),
    details text
);


--
-- Name: biolmoldblinks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE biolmoldblinks (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    dbname character varying(127),
    dbaccessioncode character varying(127),
    dbmolname character varying(255),
    dbentrydetails text
);


--
-- Name: biopolymresidmlabe; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE biopolymresidmlabe (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    mollabel character varying(127),
    resseqcode integer
);


--
-- Name: biopolymresidsynon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE biopolymresidsynon (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    synonym character varying(255)
);


--
-- Name: bmrbmisc; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE bmrbmisc (
    maxid integer NOT NULL
);


--
-- Name: bmrbverifywarning; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE bmrbverifywarning (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    warning character varying(127),
    warningvalue character varying(31)
);


--
-- Name: bmrbwarningcat; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE bmrbwarningcat (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127)
);


--
-- Name: chemicalshifterr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemicalshifterr (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    nucleus character varying(31),
    chemicalshifterr double precision,
    sd_chemicalshifterr integer
);


--
-- Name: chemicalshifts; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemicalshifts (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    atomshiftassignid integer,
    residueseqcode integer,
    residuelabel character varying(31),
    atomname character varying(31),
    atomtype character varying(31),
    chemshiftvalue real,
    sd_chemshiftvalue integer,
    chemshiftvalerror real,
    sd_chemshiftvalerro integer,
    chemshiftambcode character varying(2)
);


--
-- Name: chemshiftambglinks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemshiftambglinks (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    atmshiftassgnamb character varying(127)
);


--
-- Name: chemshiftexptlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemshiftexptlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    experimentlabel character varying(127)
);


--
-- Name: chemshiftrefdescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemshiftrefdescr (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    details text
);


--
-- Name: chemshiftreferences; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemshiftreferences (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    molcommonname character varying(127),
    atomtype character varying(31),
    atomisotopenumber integer,
    atomgroup character varying(31),
    chemshiftunits character varying(127),
    chemshiftvalue double precision,
    sd_chemshiftvalue integer,
    referencemethod character varying(127),
    referencetype character varying(127),
    extrefsampgeometry character varying(127),
    extreflocation character varying(127),
    extrefaxis character varying(127),
    indirectshiftratio double precision,
    sd_indirectshiftrat integer,
    shiftratiocitlabel character varying(127),
    refcorrectiontype character varying(127),
    correctionvalue double precision,
    sd_correctionvalue integer,
    correctvalcitlabel character varying(127)
);


--
-- Name: chemshiftsamplist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemshiftsamplist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    samplelabel character varying(127)
);


--
-- Name: chemshiftsoftlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE chemshiftsoftlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    softwarelabel character varying(127)
);


--
-- Name: citation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE citation (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    medlineuicode character varying(127),
    citationfull text,
    citationtitle text,
    citationtype character varying(127),
    casabstractcode character varying(127),
    journalabbrev character varying(127),
    journalnamefull character varying(127),
    journalvolume character varying(31),
    journalissue character varying(31),
    journalastm character varying(127),
    journalissn character varying(127),
    journalcsd character varying(127),
    booktitle text,
    bookchaptertitle text,
    bookvolume character varying(31),
    bookseries text,
    bookpublisher character varying(127),
    bookpublishercity character varying(127),
    bookisbn character varying(127),
    conftitle text,
    confsite text,
    confstateprov character varying(127),
    confcountry character varying(127),
    confstartdate date,
    confenddate date,
    confabstractno character varying(31),
    thesisinstitution character varying(127),
    thesisinstcity character varying(127),
    thesisinstcountry character varying(127),
    pagefirst character varying(31),
    pagelast character varying(31),
    year integer,
    details text
);


--
-- Name: citauthors; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE citauthors (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    authorordinal integer,
    authorfamilyname character varying(127),
    authorgivenname character varying(127),
    authormidinitials character varying(127),
    authorfamilytitle character varying(127)
);


--
-- Name: citeditors; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE citeditors (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    editorordinal integer,
    editorfamilyname character varying(127),
    editorgivenname character varying(127),
    editormidinitials character varying(127),
    editorfamilytitle character varying(127)
);


--
-- Name: citkeyword; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE citkeyword (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    keyword character varying(127)
);


--
-- Name: contactperson; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE contactperson (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    fullname character varying(127),
    givenname character varying(127),
    middleinitials character varying(127),
    familytitle character varying(127),
    deptinstitution character varying(127),
    mailingaddress text,
    phonenumber character varying(127),
    emailaddress character varying(127),
    faxnumber character varying(127)
);


--
-- Name: contactpersoncat; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE contactpersoncat (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127)
);


--
-- Name: crosslinkbondlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE crosslinkbondlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    bondorder character varying(127),
    bondtype character varying(127),
    atmonesyscompname character varying(127),
    atoonresiduseqcode integer,
    atmonereslabel character varying(31),
    atmoneatmname character varying(31),
    atmtwosyscompname character varying(127),
    atmtworesseqcode integer,
    atmtworeslabel character varying(31),
    atmtwoatmname character varying(31),
    details text
);


--
-- Name: crosslinkbonds; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE crosslinkbonds (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127)
);


--
-- Name: deletedatomlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE deletedatomlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    deleamsyscomponena character varying(127),
    deletatresidusecod integer,
    deletatoresidulabe character varying(31),
    deletedatomname character varying(31)
);


--
-- Name: depsindb; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE depsindb (
    number character varying(80) NOT NULL,
    dateinserted date NOT NULL
);


--
-- Name: dictionary; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dictionary (
    originalsf character varying(80) NOT NULL,
    originalcategory character varying(80) NOT NULL,
    originaltag character varying(80) NOT NULL,
    dictionaryseq integer NOT NULL,
    dbtableauto character varying(20) NOT NULL,
    dbcolumnauto character varying(20) NOT NULL,
    dbtype character varying(20) NOT NULL,
    dbnullable character varying(8),
    enumerationid integer,
    foreigntable character varying(20),
    foreigncolumn character varying(20),
    indexflag character(1),
    internalflag character(1),
    dbtablemanual character varying(20) NOT NULL,
    dbcolumnmanual character varying(20) NOT NULL,
    loopflag character(1),
    sequence integer NOT NULL,
    dbspace integer NOT NULL
);


--
-- Name: entryauthors; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryauthors (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    authorordinal integer,
    authorfamilyname character varying(127),
    authorgivenname character varying(127),
    authormidinitials character varying(31),
    authorfamilytitle character varying(127)
);


--
-- Name: entrycitation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entrycitation (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    citationfull text,
    citationtitle text,
    citationstatus character varying(127),
    citationtype character varying(127),
    casabstractcode character varying(127),
    medlineuicode character varying(127),
    pubmedid character varying(127),
    journalabbrev character varying(127),
    journalnamefull character varying(127),
    journalvolume character varying(31),
    journalissue character varying(31),
    journalastm character varying(127),
    journalissn character varying(127),
    journalcsd character varying(127),
    booktitle text,
    bookchaptertitle text,
    bookvolume character varying(31),
    bookseries text,
    bookpublisher character varying(127),
    bookpublishercity character varying(127),
    bookisbn character varying(127),
    conftitle text,
    confsite text,
    confstateprov character varying(127),
    confcountry character varying(127),
    confstartdate date,
    confenddate date,
    confabstractno character varying(31),
    thesisinstitution character varying(127),
    thesisinstcity character varying(127),
    thesisinstcountry character varying(127),
    pagefirst character varying(31),
    pagelast character varying(31),
    year integer,
    details text
);


--
-- Name: entrycitauthors; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entrycitauthors (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    authorordinal integer,
    authorfamilyname character varying(127),
    authorgivenname character varying(127),
    authormidinitials character varying(127),
    authorfamilytitle character varying(127)
);


--
-- Name: entryciteditors; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryciteditors (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    editorordinal integer,
    editorfamilyname character varying(127),
    editorgivenname character varying(127),
    editormidinitials character varying(127),
    editorfamilytitle character varying(127)
);


--
-- Name: entrycitkeywords; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entrycitkeywords (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    keyword character varying(127)
);


--
-- Name: entryinfodatacat; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryinfodatacat (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    saveframcategortyp character varying(127),
    savefracategotycou integer
);


--
-- Name: entryinfodatatype; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryinfodatatype (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    datatype character varying(127),
    datatypecount integer
);


--
-- Name: entryinfopdbpref; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryinfopdbpref (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    entridpreferencpdb character varying(127)
);


--
-- Name: entryinforelbmrbid; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryinforelbmrbid (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    relatedbmrbacno integer,
    relationship text
);


--
-- Name: entryinforevisions; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryinforevisions (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    revisiondate date,
    revisionkeyword character varying(127),
    revisionauthor character varying(127),
    revisiondetail text
);


--
-- Name: entryinformation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE entryinformation (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    entrytitle text,
    bmrbaccessionumber integer,
    bmrbflatfilename character varying(31),
    entrytype character varying(31),
    submissiondate date,
    accessiondate date,
    entryorigination character varying(31),
    nmrstarversion character varying(31),
    experimentalmethod character varying(127),
    details text,
    specialinstructions text,
    revisedbmrbacno integer,
    replacebmrbacno integer,
    revisedpdbacno character varying(31),
    replacepdbacno character varying(31),
    revisiondetails text,
    releaseimmediate character(3),
    releaseonpubl character(3),
    releasedatereq date,
    releasejust text,
    exptreleasedate date,
    exptreleaseonpubl character(3),
    coordreleasedate date,
    coordreleaseonpubl character(3)
);


--
-- Name: experimentalsource; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE experimentalsource (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    mollabel character varying(127),
    productionmethod character varying(127),
    hosorganisnamcommo character varying(127),
    genus character varying(127),
    species character varying(127),
    strain character varying(127),
    variant character varying(127),
    organ character varying(127),
    tissue character varying(127),
    cellline character varying(127),
    celltype character varying(127),
    atccnumber character varying(127),
    vectortype character varying(127),
    vectorname character varying(254),
    vendorname character varying(127),
    genesource character varying(127),
    details text
);


--
-- Name: exptsourcesfc; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE exptsourcesfc (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127)
);


--
-- Name: jconstantdescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE jconstantdescr (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    details text,
    samplecondlabel character varying(127),
    spectromefrequen1h double precision,
    sd_spectromefrequen integer,
    syscompname character varying(127),
    textdataformat character varying(127),
    textdata text
);


--
-- Name: jconstantexptlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE jconstantexptlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    experimentlabel character varying(127)
);


--
-- Name: jconstants; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE jconstants (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    couplingconstantid integer,
    jcode character varying(31),
    atomoneresseqcode integer,
    atomonereslabel character varying(31),
    atomonename character varying(31),
    atomtworesseqcode integer,
    atomtworeslabel character varying(31),
    atomtwoname character varying(31),
    jvalue real,
    sd_jvalue integer,
    jminvalue real,
    sd_jminvalue integer,
    jmaxvalue real,
    sd_jmaxvalue integer,
    jvalueerror real,
    sd_jvalueerror integer
);


--
-- Name: jconstantsamplist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE jconstantsamplist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    samplelabel character varying(127)
);


--
-- Name: jconstantsoftlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE jconstantsoftlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    softwarelabel character varying(127)
);


--
-- Name: ligand; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE ligand (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    moltype character varying(127),
    namecommon character varying(255),
    abbreviationcommon character varying(127),
    namecas character varying(255),
    casregistrynumber character varying(127),
    nameiupac character varying(511),
    pdbcode character varying(31),
    molempiricalform character varying(127),
    molecularmass double precision,
    sd_molecularmass integer,
    molcharge character varying(31),
    molparamagnetic character(3),
    molaromatic character(3),
    details text,
    smilesrep text,
    topologyfilename character varying(255),
    molstructfilename character varying(255),
    molstructfileform character varying(255),
    stereochemiparamfn character varying(255)
);


--
-- Name: ligandatomlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE ligandatomlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    atomname character varying(31),
    atomtype character varying(31),
    atomchirality character varying(31),
    atomcharge character varying(31),
    atomoxidationnum character varying(31),
    atomunpairelectron character varying(31)
);


--
-- Name: ligandbiolfunction; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE ligandbiolfunction (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    biologicalfunction text
);


--
-- Name: ligandbondlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE ligandbondlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    bondorder character varying(127),
    bonatomoneatomname character varying(31),
    bonatomtwoatomname character varying(31)
);


--
-- Name: liganddblinks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE liganddblinks (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    dbname character varying(127),
    dbaccessioncode character varying(127),
    dbmolname text,
    dbentrydetails text
);


--
-- Name: ligandsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE ligandsynonym (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    synonym character varying(127)
);


--
-- Name: magequivsystemcomp; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE magequivsystemcomp (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    magneticequivid character(3),
    magneticequivcomp character varying(127)
);


--
-- Name: molpuritydescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE molpuritydescr (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    mollabel character varying(127),
    molpurityvalue double precision,
    sd_molpurityvalue integer,
    molpurityvalueunit character varying(31),
    puritymeasmethod character varying(127)
);


--
-- Name: molsystemcomp; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE molsystemcomp (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    molsystemcompname character varying(127),
    mollabel character varying(127)
);


--
-- Name: naturalsource; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE naturalsource (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    mollabel character varying(127),
    organismnamecommon character varying(127),
    organismacronym character varying(127),
    ictvdbdecimalcode character varying(127),
    ncbitaxonomyid character varying(127),
    superkingdom character varying(127),
    kingdom character varying(127),
    genus character varying(127),
    species character varying(127),
    strain character varying(127),
    variant character varying(127),
    subvariant character varying(127),
    organ character varying(127),
    tissue character varying(127),
    cellline character varying(127),
    celltype character varying(127),
    atccnumber character varying(127),
    organelle character varying(127),
    fraction character varying(127),
    secretion character varying(127),
    plasmid character varying(127),
    genemnemonic character varying(127),
    details text
);


--
-- Name: naturalsourcesfc; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE naturalsourcesfc (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127)
);


--
-- Name: nmrexperimental; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE nmrexperimental (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    experimentname character varying(1023),
    samplelabel character varying(127),
    bmrbpsequaccessnum character varying(31),
    pulssequencfilname text,
    pusequeparametfina text,
    pusequeschematfina text,
    pusequeschemafform character varying(127),
    details text
);


--
-- Name: nmrexptcit; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE nmrexptcit (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    citationlabel character varying(127)
);


--
-- Name: nmrspecacqpar; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE nmrspecacqpar (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    acquisitidimensiid character varying(31),
    detectedatomtype character varying(31),
    spectromcarrfreque character varying(31),
    sd_spectromcarrfreq integer,
    acquisitiontime character varying(31),
    sd_acquisitiontime integer,
    mixingtime character varying(31),
    sd_mixingtime integer,
    spectralwidth character varying(31),
    sd_spectralwidth integer,
    spectralfolding character varying(31),
    datapointnumber integer,
    datapointtype character varying(31),
    datapointspacing character varying(31)
);


--
-- Name: nmrspecprocpar; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE nmrspecprocpar (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    processidimensioid character varying(31),
    exponentialfactor double precision,
    sd_exponentialfacto integer,
    gaussianfactor double precision,
    sd_gaussianfactor integer,
    processerealpoints integer
);


--
-- Name: nmrspectrometer; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE nmrspectrometer (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    manufacturer character varying(127),
    model character varying(127),
    fieldstrength character varying(127),
    softversionnumber character varying(127),
    details text
);


--
-- Name: polymerbiofunc; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE polymerbiofunc (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    biologicalfunction text
);


--
-- Name: polymerdblinks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE polymerdblinks (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    dbname character varying(127),
    dbaccessioncode character varying(127),
    dbmolname character varying(380),
    dbexptlmethod character varying(31),
    databasesegmentid character varying(127),
    dbseqhomologytype character varying(31),
    seqquerypercent character varying(31),
    seqsubjectlength character varying(31),
    seqidentitypercent character varying(31),
    seqpositivepercent character varying(31),
    seqhomolexpval character varying(31),
    seqdifdetails text,
    seqaligndetails text
);


--
-- Name: polymerdescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE polymerdescr (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    moltype character varying(127),
    molpolymerclass character varying(127),
    namecommon character varying(380),
    namevariant character varying(255),
    abbreviationcommon character varying(127),
    namecas character varying(255),
    casregistrynumber character varying(127),
    ecnumber character varying(127),
    molecularmass double precision,
    sd_molecularmass integer,
    molthiolstate character varying(63),
    details text,
    sequencecitlabel character varying(127),
    ambigseqfeatures character varying(683),
    residuecount integer,
    molressequence text,
    seqhomolquerydate character varying(31),
    seqhomolqueryrev character varying(31)
);


--
-- Name: polymersyn; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE polymersyn (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    synonym character varying(127)
);


--
-- Name: residueatomlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE residueatomlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    atomname character varying(31),
    pdbatomname character varying(31),
    atomtype character varying(31),
    atomchirality character varying(127),
    atomcharge character varying(127),
    atomoxidationnum character varying(127),
    atomunpairelectron character varying(127)
);


--
-- Name: residuebondlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE residuebondlist (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    bondorder character varying(127),
    bonatomoneatomname character varying(127),
    bonatomtwoatomname character varying(127),
    pdbatomoneatomname character varying(127),
    pdbatomtwoatomname character varying(127)
);


--
-- Name: residuedescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE residuedescr (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    moltype character varying(127),
    namecommon character varying(255),
    abbreviationcommon character varying(127),
    nameiupac character varying(511),
    namecas character varying(255),
    casregistrynumber character varying(127),
    bmrbcode character varying(127),
    pdbcode character varying(31),
    stdresderivative character varying(255),
    molempiricalform character varying(127),
    molecularmass double precision,
    sd_molecularmass integer,
    molparamagnetic character(3),
    details text,
    smilesrep text,
    topologyfilename character varying(255),
    molstructfilename character varying(255),
    molstructfileform character varying(255),
    stereochemiparamfn character varying(255)
);


--
-- Name: residuesequence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE residuesequence (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    resseqcode integer,
    resauthorseqcode character varying(31),
    insertioncode character varying(31),
    residuelabel character varying(31),
    segmendefinitiocod character varying(31)
);


--
-- Name: sampleconddescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE sampleconddescr (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    details text
);


--
-- Name: sampleconditions; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE sampleconditions (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    variabletype character varying(127),
    variablevalue double precision,
    sd_variablevalue integer,
    variablevalueerror double precision,
    sd_variablevalueerr integer,
    variablevalueunits character varying(31)
);


--
-- Name: samplecontents; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE samplecontents (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    mollabel character varying(127),
    concvalue character varying(15),
    sd_concvalue integer,
    concvalueunit character varying(127),
    concminvalue double precision,
    sd_concminvalue integer,
    concmaxvalue double precision,
    sd_concmaxvalue integer,
    isotopiclabeling character varying(127)
);


--
-- Name: sampledescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE sampledescr (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    sampletype character varying(127),
    details text
);


--
-- Name: samplepuritydescr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE samplepuritydescr (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    details text,
    samplelabel character varying(127)
);


--
-- Name: seqalignmenttable; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE seqalignmenttable (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    pdbseqreslocation character varying(31),
    pdbseqresreslabel character varying(31),
    dbresseqcode character varying(31),
    dbresinsertcode character varying(31),
    dbresiduelabel character varying(31),
    dbchainid character varying(31),
    resseqcode character varying(31),
    resauthorseqcode character varying(31),
    residuelabel character varying(31),
    assignedchemshifts character varying(31),
    couplingconstants character varying(31)
);


--
-- Name: sequencealignments; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE sequencealignments (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    syscompname character varying(127),
    databasename character varying(127),
    databasaccessiocod character varying(127),
    sequenchomologtype character varying(127)
);


--
-- Name: sfidseq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE sfidseq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- Name: softplatformvendor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE softplatformvendor (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    platformvendor character varying(127),
    platformmodel character varying(127),
    operatingsystem character varying(127),
    osversion character varying(127),
    hardwarecode character varying(127)
);


--
-- Name: software; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE software (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    name character varying(127),
    version character varying(127),
    details text,
    citationlabel character varying(127)
);


--
-- Name: softwaretask; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE softwaretask (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    task character varying(380)
);


--
-- Name: softwarevendor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE softwarevendor (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    vendor character varying(127),
    address text,
    electronicaddress text
);


--
-- Name: sysmolcomponents; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE sysmolcomponents (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    molsyscompname character varying(127)
);


--
-- Name: system; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE system (
    saveframeid integer NOT NULL,
    originalblock character varying(80),
    originalframe character varying(80),
    saveframecategory character varying(127),
    molsystemname character varying(255),
    abbreviationcommon character varying(127),
    ecnumber character varying(127),
    sysmolweight double precision,
    sd_sysmolweight integer,
    sysphysicalstate character varying(127),
    sysoligmerstate character varying(127),
    systemorder character varying(127),
    systemparamagnetic character(3),
    systemthiolstate character varying(31),
    dbquerydate character varying(31),
    details text
);


--
-- Name: systembiolfunc; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE systembiolfunc (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    biologicalfunction text
);


--
-- Name: systemdblinks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE systemdblinks (
    saveframeid integer,
    originalblock character varying(80),
    originalframe character varying(80),
    loopseq integer,
    dbname character varying(127),
    dbaccessioncode character varying(127),
    dbmolname text,
    dbexptlmethod character varying(31),
    dbrelationtype character varying(254),
    dbentrydetails text
);


--
-- Name: assignchemicashift_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY assignchemicashift
    ADD CONSTRAINT assignchemicashift_pkey PRIMARY KEY (saveframeid);


--
-- Name: authatmnomcat_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY authatmnomcat
    ADD CONSTRAINT authatmnomcat_pkey PRIMARY KEY (saveframeid);


--
-- Name: biolfuncmolsystem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY biolfuncmolsystem
    ADD CONSTRAINT biolfuncmolsystem_pkey PRIMARY KEY (saveframeid);


--
-- Name: bmrbwarningcat_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY bmrbwarningcat
    ADD CONSTRAINT bmrbwarningcat_pkey PRIMARY KEY (saveframeid);


--
-- Name: chemshiftrefdescr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY chemshiftrefdescr
    ADD CONSTRAINT chemshiftrefdescr_pkey PRIMARY KEY (saveframeid);


--
-- Name: citation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY citation
    ADD CONSTRAINT citation_pkey PRIMARY KEY (saveframeid);


--
-- Name: contactpersoncat_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY contactpersoncat
    ADD CONSTRAINT contactpersoncat_pkey PRIMARY KEY (saveframeid);


--
-- Name: crosslinkbonds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY crosslinkbonds
    ADD CONSTRAINT crosslinkbonds_pkey PRIMARY KEY (saveframeid);


--
-- Name: depsindb_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY depsindb
    ADD CONSTRAINT depsindb_pkey PRIMARY KEY (number);


--
-- Name: entrycitation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY entrycitation
    ADD CONSTRAINT entrycitation_pkey PRIMARY KEY (saveframeid);


--
-- Name: entryinformation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY entryinformation
    ADD CONSTRAINT entryinformation_pkey PRIMARY KEY (saveframeid);


--
-- Name: exptsourcesfc_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY exptsourcesfc
    ADD CONSTRAINT exptsourcesfc_pkey PRIMARY KEY (saveframeid);


--
-- Name: jconstantdescr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY jconstantdescr
    ADD CONSTRAINT jconstantdescr_pkey PRIMARY KEY (saveframeid);


--
-- Name: ligand_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY ligand
    ADD CONSTRAINT ligand_pkey PRIMARY KEY (saveframeid);


--
-- Name: naturalsourcesfc_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY naturalsourcesfc
    ADD CONSTRAINT naturalsourcesfc_pkey PRIMARY KEY (saveframeid);


--
-- Name: nmrexperimental_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY nmrexperimental
    ADD CONSTRAINT nmrexperimental_pkey PRIMARY KEY (saveframeid);


--
-- Name: nmrspectrometer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY nmrspectrometer
    ADD CONSTRAINT nmrspectrometer_pkey PRIMARY KEY (saveframeid);


--
-- Name: polymerdescr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY polymerdescr
    ADD CONSTRAINT polymerdescr_pkey PRIMARY KEY (saveframeid);


--
-- Name: residuedescr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY residuedescr
    ADD CONSTRAINT residuedescr_pkey PRIMARY KEY (saveframeid);


--
-- Name: sampleconddescr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY sampleconddescr
    ADD CONSTRAINT sampleconddescr_pkey PRIMARY KEY (saveframeid);


--
-- Name: sampledescr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY sampledescr
    ADD CONSTRAINT sampledescr_pkey PRIMARY KEY (saveframeid);


--
-- Name: samplepuritydescr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY samplepuritydescr
    ADD CONSTRAINT samplepuritydescr_pkey PRIMARY KEY (saveframeid);


--
-- Name: sequencealignments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY sequencealignments
    ADD CONSTRAINT sequencealignments_pkey PRIMARY KEY (saveframeid);


--
-- Name: software_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY software
    ADD CONSTRAINT software_pkey PRIMARY KEY (saveframeid);


--
-- Name: system_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY system
    ADD CONSTRAINT system_pkey PRIMARY KEY (saveframeid);


--
-- Name: ix100_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX ix100_1 ON dictionary USING btree (originalsf);


--
-- Name: ix100_13; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX ix100_13 ON dictionary USING btree (dbtablemanual);


--
-- Name: ix100_14; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX ix100_14 ON dictionary USING btree (dbcolumnmanual);


--
-- Name: ix100_4; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX ix100_4 ON dictionary USING btree (dbtableauto);


--
-- Name: ix100_5; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX ix100_5 ON dictionary USING btree (dbcolumnauto);


--
-- Name: t0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0001 ON bmrbverifywarning USING btree (originalblock, originalframe);


--
-- Name: t0001seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0001seq ON bmrbverifywarning USING btree (loopseq);


--
-- Name: t0001sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0001sfid ON bmrbverifywarning USING btree (saveframeid);


--
-- Name: t0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0002 ON bmrbwarningcat USING btree (originalblock, originalframe);


--
-- Name: t0003; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0003 ON biolfunclist USING btree (originalblock, originalframe);


--
-- Name: t0003seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0003seq ON biolfunclist USING btree (loopseq);


--
-- Name: t0003sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0003sfid ON biolfunclist USING btree (saveframeid);


--
-- Name: t0004; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0004 ON sysmolcomponents USING btree (originalblock, originalframe);


--
-- Name: t0004seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0004seq ON sysmolcomponents USING btree (loopseq);


--
-- Name: t0004sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0004sfid ON sysmolcomponents USING btree (saveframeid);


--
-- Name: t0005; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0005 ON entryinfopdbpref USING btree (originalblock, originalframe);


--
-- Name: t0005seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0005seq ON entryinfopdbpref USING btree (loopseq);


--
-- Name: t0005sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0005sfid ON entryinfopdbpref USING btree (saveframeid);


--
-- Name: t0006; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0006 ON entryinforelbmrbid USING btree (originalblock, originalframe);


--
-- Name: t0006seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0006seq ON entryinforelbmrbid USING btree (loopseq);


--
-- Name: t0006sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0006sfid ON entryinforelbmrbid USING btree (saveframeid);


--
-- Name: t0007; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0007 ON nmrspecacqpar USING btree (originalblock, originalframe);


--
-- Name: t0007seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0007seq ON nmrspecacqpar USING btree (loopseq);


--
-- Name: t0007sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0007sfid ON nmrspecacqpar USING btree (saveframeid);


--
-- Name: t0008; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0008 ON nmrspecprocpar USING btree (originalblock, originalframe);


--
-- Name: t0008seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0008seq ON nmrspecprocpar USING btree (loopseq);


--
-- Name: t0008sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0008sfid ON nmrspecprocpar USING btree (saveframeid);


--
-- Name: t0009; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0009 ON nmrexptcit USING btree (originalblock, originalframe);


--
-- Name: t0009seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0009seq ON nmrexptcit USING btree (loopseq);


--
-- Name: t0009sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0009sfid ON nmrexptcit USING btree (saveframeid);


--
-- Name: t0010; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0010 ON nmrexperimental USING btree (originalblock, originalframe);


--
-- Name: t0011; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0011 ON nmrspectrometer USING btree (originalblock, originalframe);


--
-- Name: t0012; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0012 ON authoratomnom USING btree (originalblock, originalframe);


--
-- Name: t0012seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0012seq ON authoratomnom USING btree (loopseq);


--
-- Name: t0012sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0012sfid ON authoratomnom USING btree (saveframeid);


--
-- Name: t0013; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0013 ON chemshiftambglinks USING btree (originalblock, originalframe);


--
-- Name: t0013seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0013seq ON chemshiftambglinks USING btree (loopseq);


--
-- Name: t0013sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0013sfid ON chemshiftambglinks USING btree (saveframeid);


--
-- Name: t0014; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0014 ON chemicalshifts USING btree (originalblock, originalframe);


--
-- Name: t0014i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0014i0001 ON chemicalshifts USING btree (residuelabel);


--
-- Name: t0014i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0014i0002 ON chemicalshifts USING btree (atomname);


--
-- Name: t0014seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0014seq ON chemicalshifts USING btree (loopseq);


--
-- Name: t0014sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0014sfid ON chemicalshifts USING btree (saveframeid);


--
-- Name: t0015; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0015 ON chemshiftexptlist USING btree (originalblock, originalframe);


--
-- Name: t0015seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0015seq ON chemshiftexptlist USING btree (loopseq);


--
-- Name: t0015sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0015sfid ON chemshiftexptlist USING btree (saveframeid);


--
-- Name: t0016; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0016 ON chemshiftsoftlist USING btree (originalblock, originalframe);


--
-- Name: t0016seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0016seq ON chemshiftsoftlist USING btree (loopseq);


--
-- Name: t0016sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0016sfid ON chemshiftsoftlist USING btree (saveframeid);


--
-- Name: t0017; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0017 ON chemicalshifterr USING btree (originalblock, originalframe);


--
-- Name: t0017seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0017seq ON chemicalshifterr USING btree (loopseq);


--
-- Name: t0017sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0017sfid ON chemicalshifterr USING btree (saveframeid);


--
-- Name: t0018; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0018 ON chemshiftsamplist USING btree (originalblock, originalframe);


--
-- Name: t0018seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0018seq ON chemshiftsamplist USING btree (loopseq);


--
-- Name: t0018sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0018sfid ON chemshiftsamplist USING btree (saveframeid);


--
-- Name: t0019; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0019 ON assignchemicashift USING btree (originalblock, originalframe);


--
-- Name: t0020; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0020 ON authatmnomcat USING btree (originalblock, originalframe);


--
-- Name: t0021; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0021 ON biolmoldblinks USING btree (originalblock, originalframe);


--
-- Name: t0021seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0021seq ON biolmoldblinks USING btree (loopseq);


--
-- Name: t0021sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0021sfid ON biolmoldblinks USING btree (saveframeid);


--
-- Name: t0022; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0022 ON biolfuncmolsystem USING btree (originalblock, originalframe);


--
-- Name: t0023; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0023 ON chemshiftreferences USING btree (originalblock, originalframe);


--
-- Name: t0023i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0023i0001 ON chemshiftreferences USING btree (molcommonname);


--
-- Name: t0023seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0023seq ON chemshiftreferences USING btree (loopseq);


--
-- Name: t0023sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0023sfid ON chemshiftreferences USING btree (saveframeid);


--
-- Name: t0024; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0024 ON chemshiftrefdescr USING btree (originalblock, originalframe);


--
-- Name: t0025; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0025 ON citauthors USING btree (originalblock, originalframe);


--
-- Name: t0025seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0025seq ON citauthors USING btree (loopseq);


--
-- Name: t0025sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0025sfid ON citauthors USING btree (saveframeid);


--
-- Name: t0026; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0026 ON citeditors USING btree (originalblock, originalframe);


--
-- Name: t0026seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0026seq ON citeditors USING btree (loopseq);


--
-- Name: t0026sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0026sfid ON citeditors USING btree (saveframeid);


--
-- Name: t0027; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0027 ON citation USING btree (originalblock, originalframe);


--
-- Name: t0028; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0028 ON citkeyword USING btree (originalblock, originalframe);


--
-- Name: t0028seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0028seq ON citkeyword USING btree (loopseq);


--
-- Name: t0028sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0028sfid ON citkeyword USING btree (saveframeid);


--
-- Name: t0029; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0029 ON contactperson USING btree (originalblock, originalframe);


--
-- Name: t0029seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0029seq ON contactperson USING btree (loopseq);


--
-- Name: t0029sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0029sfid ON contactperson USING btree (saveframeid);


--
-- Name: t0030; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0030 ON contactpersoncat USING btree (originalblock, originalframe);


--
-- Name: t0031; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0031 ON jconstantexptlist USING btree (originalblock, originalframe);


--
-- Name: t0031seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0031seq ON jconstantexptlist USING btree (loopseq);


--
-- Name: t0031sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0031sfid ON jconstantexptlist USING btree (saveframeid);


--
-- Name: t0032; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0032 ON jconstants USING btree (originalblock, originalframe);


--
-- Name: t0032i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0032i0001 ON jconstants USING btree (atomonereslabel);


--
-- Name: t0032i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0032i0002 ON jconstants USING btree (atomonename);


--
-- Name: t0032seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0032seq ON jconstants USING btree (loopseq);


--
-- Name: t0032sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0032sfid ON jconstants USING btree (saveframeid);


--
-- Name: t0033; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0033 ON jconstantsamplist USING btree (originalblock, originalframe);


--
-- Name: t0033seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0033seq ON jconstantsamplist USING btree (loopseq);


--
-- Name: t0033sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0033sfid ON jconstantsamplist USING btree (saveframeid);


--
-- Name: t0034; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0034 ON jconstantsoftlist USING btree (originalblock, originalframe);


--
-- Name: t0034seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0034seq ON jconstantsoftlist USING btree (loopseq);


--
-- Name: t0034sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0034sfid ON jconstantsoftlist USING btree (saveframeid);


--
-- Name: t0035; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0035 ON jconstantdescr USING btree (originalblock, originalframe);


--
-- Name: t0036; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0036 ON deletedatomlist USING btree (originalblock, originalframe);


--
-- Name: t0036seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0036seq ON deletedatomlist USING btree (loopseq);


--
-- Name: t0036sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0036sfid ON deletedatomlist USING btree (saveframeid);


--
-- Name: t0037; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0037 ON crosslinkbondlist USING btree (originalblock, originalframe);


--
-- Name: t0037seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0037seq ON crosslinkbondlist USING btree (loopseq);


--
-- Name: t0037sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0037sfid ON crosslinkbondlist USING btree (saveframeid);


--
-- Name: t0038; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0038 ON crosslinkbonds USING btree (originalblock, originalframe);


--
-- Name: t0039; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0039 ON entryinfodatacat USING btree (originalblock, originalframe);


--
-- Name: t0039i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0039i0001 ON entryinfodatacat USING btree (saveframcategortyp);


--
-- Name: t0039seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0039seq ON entryinfodatacat USING btree (loopseq);


--
-- Name: t0039sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0039sfid ON entryinfodatacat USING btree (saveframeid);


--
-- Name: t0040; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0040 ON entryauthors USING btree (originalblock, originalframe);


--
-- Name: t0040i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0040i0001 ON entryauthors USING btree (authorfamilyname);


--
-- Name: t0040seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0040seq ON entryauthors USING btree (loopseq);


--
-- Name: t0040sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0040sfid ON entryauthors USING btree (saveframeid);


--
-- Name: t0041; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0041 ON entryinforevisions USING btree (originalblock, originalframe);


--
-- Name: t0041seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0041seq ON entryinforevisions USING btree (loopseq);


--
-- Name: t0041sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0041sfid ON entryinforevisions USING btree (saveframeid);


--
-- Name: t0042; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0042 ON entrycitauthors USING btree (originalblock, originalframe);


--
-- Name: t0042i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0042i0001 ON entrycitauthors USING btree (authorfamilyname);


--
-- Name: t0042i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0042i0002 ON entrycitauthors USING btree (authorgivenname);


--
-- Name: t0042i0003; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0042i0003 ON entrycitauthors USING btree (authormidinitials);


--
-- Name: t0042seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0042seq ON entrycitauthors USING btree (loopseq);


--
-- Name: t0042sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0042sfid ON entrycitauthors USING btree (saveframeid);


--
-- Name: t0043; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0043 ON entryciteditors USING btree (originalblock, originalframe);


--
-- Name: t0043seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0043seq ON entryciteditors USING btree (loopseq);


--
-- Name: t0043sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0043sfid ON entryciteditors USING btree (saveframeid);


--
-- Name: t0044; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0044 ON entryinfodatatype USING btree (originalblock, originalframe);


--
-- Name: t0044i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0044i0001 ON entryinfodatatype USING btree (datatype);


--
-- Name: t0044seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0044seq ON entryinfodatatype USING btree (loopseq);


--
-- Name: t0044sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0044sfid ON entryinfodatatype USING btree (saveframeid);


--
-- Name: t0045; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0045 ON entrycitkeywords USING btree (originalblock, originalframe);


--
-- Name: t0045seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0045seq ON entrycitkeywords USING btree (loopseq);


--
-- Name: t0045sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0045sfid ON entrycitkeywords USING btree (saveframeid);


--
-- Name: t0046; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0046 ON entrycitation USING btree (originalblock, originalframe);


--
-- Name: t0047; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0047 ON entryinformation USING btree (originalblock, originalframe);


--
-- Name: t0047i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0047i0001 ON entryinformation USING btree (bmrbaccessionumber);


--
-- Name: t0048; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0048 ON experimentalsource USING btree (originalblock, originalframe);


--
-- Name: t0048i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0048i0001 ON experimentalsource USING btree (productionmethod);


--
-- Name: t0048i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0048i0002 ON experimentalsource USING btree (hosorganisnamcommo);


--
-- Name: t0048seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0048seq ON experimentalsource USING btree (loopseq);


--
-- Name: t0048sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0048sfid ON experimentalsource USING btree (saveframeid);


--
-- Name: t0049; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0049 ON exptsourcesfc USING btree (originalblock, originalframe);


--
-- Name: t0050; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0050 ON ligandbiolfunction USING btree (originalblock, originalframe);


--
-- Name: t0050seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0050seq ON ligandbiolfunction USING btree (loopseq);


--
-- Name: t0050sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0050sfid ON ligandbiolfunction USING btree (saveframeid);


--
-- Name: t0051; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0051 ON ligand USING btree (originalblock, originalframe);


--
-- Name: t0051i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0051i0001 ON ligand USING btree (namecommon);


--
-- Name: t0051i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0051i0002 ON ligand USING btree (abbreviationcommon);


--
-- Name: t0051i0003; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0051i0003 ON ligand USING btree (molaromatic);


--
-- Name: t0052; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0052 ON ligandatomlist USING btree (originalblock, originalframe);


--
-- Name: t0052seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0052seq ON ligandatomlist USING btree (loopseq);


--
-- Name: t0052sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0052sfid ON ligandatomlist USING btree (saveframeid);


--
-- Name: t0053; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0053 ON ligandbondlist USING btree (originalblock, originalframe);


--
-- Name: t0053seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0053seq ON ligandbondlist USING btree (loopseq);


--
-- Name: t0053sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0053sfid ON ligandbondlist USING btree (saveframeid);


--
-- Name: t0054; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0054 ON liganddblinks USING btree (originalblock, originalframe);


--
-- Name: t0054seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0054seq ON liganddblinks USING btree (loopseq);


--
-- Name: t0054sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0054sfid ON liganddblinks USING btree (saveframeid);


--
-- Name: t0055; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0055 ON ligandsynonym USING btree (originalblock, originalframe);


--
-- Name: t0055seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0055seq ON ligandsynonym USING btree (loopseq);


--
-- Name: t0055sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0055sfid ON ligandsynonym USING btree (saveframeid);


--
-- Name: t0056; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0056 ON magequivsystemcomp USING btree (originalblock, originalframe);


--
-- Name: t0056seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0056seq ON magequivsystemcomp USING btree (loopseq);


--
-- Name: t0056sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0056sfid ON magequivsystemcomp USING btree (saveframeid);


--
-- Name: t0057; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0057 ON systembiolfunc USING btree (originalblock, originalframe);


--
-- Name: t0057seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0057seq ON systembiolfunc USING btree (loopseq);


--
-- Name: t0057sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0057sfid ON systembiolfunc USING btree (saveframeid);


--
-- Name: t0058; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0058 ON molsystemcomp USING btree (originalblock, originalframe);


--
-- Name: t0058seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0058seq ON molsystemcomp USING btree (loopseq);


--
-- Name: t0058sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0058sfid ON molsystemcomp USING btree (saveframeid);


--
-- Name: t0059; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0059 ON systemdblinks USING btree (originalblock, originalframe);


--
-- Name: t0059seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0059seq ON systemdblinks USING btree (loopseq);


--
-- Name: t0059sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0059sfid ON systemdblinks USING btree (saveframeid);


--
-- Name: t0060; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0060 ON system USING btree (originalblock, originalframe);


--
-- Name: t0060i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0060i0001 ON system USING btree (abbreviationcommon);


--
-- Name: t0060i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0060i0002 ON system USING btree (sysphysicalstate);


--
-- Name: t0060i0003; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0060i0003 ON system USING btree (systemparamagnetic);


--
-- Name: t0061; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0061 ON polymerbiofunc USING btree (originalblock, originalframe);


--
-- Name: t0061seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0061seq ON polymerbiofunc USING btree (loopseq);


--
-- Name: t0061sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0061sfid ON polymerbiofunc USING btree (saveframeid);


--
-- Name: t0062; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0062 ON polymerdblinks USING btree (originalblock, originalframe);


--
-- Name: t0062i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0062i0001 ON polymerdblinks USING btree (dbname);


--
-- Name: t0062seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0062seq ON polymerdblinks USING btree (loopseq);


--
-- Name: t0062sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0062sfid ON polymerdblinks USING btree (saveframeid);


--
-- Name: t0063; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0063 ON residuesequence USING btree (originalblock, originalframe);


--
-- Name: t0063seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0063seq ON residuesequence USING btree (loopseq);


--
-- Name: t0063sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0063sfid ON residuesequence USING btree (saveframeid);


--
-- Name: t0064; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0064 ON polymersyn USING btree (originalblock, originalframe);


--
-- Name: t0064i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0064i0001 ON polymersyn USING btree (synonym);


--
-- Name: t0064seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0064seq ON polymersyn USING btree (loopseq);


--
-- Name: t0064sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0064sfid ON polymersyn USING btree (saveframeid);


--
-- Name: t0065; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0065 ON polymerdescr USING btree (originalblock, originalframe);


--
-- Name: t0065i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0065i0001 ON polymerdescr USING btree (molpolymerclass);


--
-- Name: t0065i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0065i0002 ON polymerdescr USING btree (namecommon);


--
-- Name: t0065i0003; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0065i0003 ON polymerdescr USING btree (residuecount);


--
-- Name: t0066; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0066 ON naturalsource USING btree (originalblock, originalframe);


--
-- Name: t0066i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0066i0001 ON naturalsource USING btree (organismnamecommon);


--
-- Name: t0066i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0066i0002 ON naturalsource USING btree (genus);


--
-- Name: t0066i0003; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0066i0003 ON naturalsource USING btree (species);


--
-- Name: t0066seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0066seq ON naturalsource USING btree (loopseq);


--
-- Name: t0066sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0066sfid ON naturalsource USING btree (saveframeid);


--
-- Name: t0067; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0067 ON naturalsourcesfc USING btree (originalblock, originalframe);


--
-- Name: t0068; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0068 ON residuebondlist USING btree (originalblock, originalframe);


--
-- Name: t0068seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0068seq ON residuebondlist USING btree (loopseq);


--
-- Name: t0068sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0068sfid ON residuebondlist USING btree (saveframeid);


--
-- Name: t0069; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0069 ON residueatomlist USING btree (originalblock, originalframe);


--
-- Name: t0069seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0069seq ON residueatomlist USING btree (loopseq);


--
-- Name: t0069sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0069sfid ON residueatomlist USING btree (saveframeid);


--
-- Name: t0070; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0070 ON biopolymresidmlabe USING btree (originalblock, originalframe);


--
-- Name: t0070seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0070seq ON biopolymresidmlabe USING btree (loopseq);


--
-- Name: t0070sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0070sfid ON biopolymresidmlabe USING btree (saveframeid);


--
-- Name: t0071; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0071 ON biopolymresidsynon USING btree (originalblock, originalframe);


--
-- Name: t0071seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0071seq ON biopolymresidsynon USING btree (loopseq);


--
-- Name: t0071sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0071sfid ON biopolymresidsynon USING btree (saveframeid);


--
-- Name: t0072; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0072 ON residuedescr USING btree (originalblock, originalframe);


--
-- Name: t0072i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0072i0001 ON residuedescr USING btree (abbreviationcommon);


--
-- Name: t0072i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0072i0002 ON residuedescr USING btree (molparamagnetic);


--
-- Name: t0073; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0073 ON sampleconditions USING btree (originalblock, originalframe);


--
-- Name: t0073i0001; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0073i0001 ON sampleconditions USING btree (variabletype);


--
-- Name: t0073i0002; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0073i0002 ON sampleconditions USING btree (variablevalue);


--
-- Name: t0073seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0073seq ON sampleconditions USING btree (loopseq);


--
-- Name: t0073sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0073sfid ON sampleconditions USING btree (saveframeid);


--
-- Name: t0074; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0074 ON molpuritydescr USING btree (originalblock, originalframe);


--
-- Name: t0074seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0074seq ON molpuritydescr USING btree (loopseq);


--
-- Name: t0074sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0074sfid ON molpuritydescr USING btree (saveframeid);


--
-- Name: t0075; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0075 ON sampledescr USING btree (originalblock, originalframe);


--
-- Name: t0076; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0076 ON sampleconddescr USING btree (originalblock, originalframe);


--
-- Name: t0077; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0077 ON samplecontents USING btree (originalblock, originalframe);


--
-- Name: t0077seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0077seq ON samplecontents USING btree (loopseq);


--
-- Name: t0077sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0077sfid ON samplecontents USING btree (saveframeid);


--
-- Name: t0078; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0078 ON samplepuritydescr USING btree (originalblock, originalframe);


--
-- Name: t0079; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0079 ON seqalignmenttable USING btree (originalblock, originalframe);


--
-- Name: t0079seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0079seq ON seqalignmenttable USING btree (loopseq);


--
-- Name: t0079sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0079sfid ON seqalignmenttable USING btree (saveframeid);


--
-- Name: t0080; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0080 ON sequencealignments USING btree (originalblock, originalframe);


--
-- Name: t0081; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0081 ON softplatformvendor USING btree (originalblock, originalframe);


--
-- Name: t0081seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0081seq ON softplatformvendor USING btree (loopseq);


--
-- Name: t0081sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0081sfid ON softplatformvendor USING btree (saveframeid);


--
-- Name: t0082; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0082 ON software USING btree (originalblock, originalframe);


--
-- Name: t0083; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0083 ON softwaretask USING btree (originalblock, originalframe);


--
-- Name: t0083seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0083seq ON softwaretask USING btree (loopseq);


--
-- Name: t0083sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0083sfid ON softwaretask USING btree (saveframeid);


--
-- Name: t0084; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0084 ON softwarevendor USING btree (originalblock, originalframe);


--
-- Name: t0084seq; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0084seq ON softwarevendor USING btree (loopseq);


--
-- Name: t0084sfid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX t0084sfid ON softwarevendor USING btree (saveframeid);


--
-- Name: uix100_14; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX uix100_14 ON dictionary USING btree (originalcategory, originaltag);


--
-- PostgreSQL database dump complete
--

