CREATE TABLE PROTEIN (NREF_ID CHAR(10) NOT NULL ,  P_NAME VARCHAR(2019) , LAST_UPDATED DATE ,   SEQUENCE VARCHAR(5500) ,  SEQ_LENGTH INTEGER )
CREATE TABLE IDENTICAL_SEQ  (NREF_ID_1 CHAR(10) NOT NULL, ORDINAL INTEGER ,  NREF_ID_2 CHAR(10) NOT NULL, TAXON_ID_2 CHAR(10) )
CREATE TABLE NEIGHBORING_SEQ  ( NREF_ID_1 CHAR(10) NOT NULL ,   ORDINAL INTEGER ,   NREF_ID_2 CHAR(10) NOT NULL ,   TAXON_ID_2 CHAR(10) ,   LENGTH_2 INTEGER ,   SCORE REAL ,   OVERLAP_LENGTH INTEGER ,   START_1 INTEGER ,   END_1 INTEGER ,   START_2 INTEGER ,   END_2 INTEGER )
CREATE TABLE ORGANISM  ( NREF_ID CHAR(10) NOT NULL ,  ORDINAL INTEGER NOT NULL, TAXON_ID CHAR(10) ,  NAME VARCHAR(136) )
CREATE TABLE SOURCE  (NREF_ID CHAR(10) NOT NULL ,   P_ID CHAR(10) NOT NULL, P_NAME VARCHAR(2025) ,   SOURCE CHAR(9) ,   TAXON_ID CHAR(10) NOT NULL,   ACCESSION CHAR(10) NOT NULL)
CREATE TABLE TAXONOMY  (  NREF_ID CHAR(10) NOT NULL ,   TAXON_ID CHAR(10) NOT NULL, SPECIES_NAME VARCHAR(87) ,   COMMON_NAME VARCHAR(74) ,   LINEAGE VARCHAR(60) NOT NULL )
ALTER TABLE PROTEIN  ADD PRIMARY KEY (NREF_ID)   DATA CAPTURE NONE  NOT VOLATILE;
ALTER TABLE IDENTICAL_SEQ  ADD PRIMARY KEY (NREF_ID_1, NREF_ID_2)  ADD   FOREIGN KEY (NREF_ID_1) REFERENCES PROTEIN (NREF_ID) ON DELETE NO ACTION ON UPDATE NO ACTION  DATA CAPTURE NONE  NOT VOLATILE ;
ALTER TABLE NEIGHBORING_SEQ  ADD PRIMARY KEY (NREF_ID_1, NREF_ID_2)  ADD   FOREIGN KEY (NREF_ID_1) REFERENCES PROTEIN (NREF_ID) ON DELETE NO ACTION ON UPDATE NO ACTION  DATA CAPTURE NONE  NOT VOLATILE; 
ALTER TABLE ORGANISM  ADD PRIMARY KEY (NREF_ID, ORDINAL)  ADD   FOREIGN KEY (NREF_ID) REFERENCES PROTEIN (NREF_ID) ON DELETE NO ACTION ON UPDATE NO ACTION  DATA CAPTURE NONE  NOT VOLATILE; 
ALTER TABLE SOURCE  ADD PRIMARY KEY (NREF_ID, P_ID, TAXON_ID, ACCESSION)  ADD   FOREIGN KEY (NREF_ID) REFERENCES PROTEIN (NREF_ID) ON DELETE NO ACTION ON UPDATE NO ACTION  DATA CAPTURE NONE  NOT VOLATILE; 
ALTER TABLE TAXONOMY  ADD PRIMARY KEY (NREF_ID, TAXON_ID, LINEAGE)  ADD   FOREIGN KEY (NREF_ID) REFERENCES PROTEIN (NREF_ID) ON DELETE NO ACTION ON UPDATE NO ACTION  DATA CAPTURE NONE  NOT VOLATILE;