Qtl schema

[Ken Youens-Clark]

On Jul 21, 2004, at 3:05 PM, Miskell, Craig wrote:

>> Please send me (off-list) the data dump you have.  I will find the
>> correct version of the schema to go with it.
> Attached - it's the one straight off the ftp download site (grabbed it
> yesterday).

Craig,

Thank you for your patience in clearing up the discrepancies b/w the 
schemas and the tab dumps.  This table definition for the "qtl" table 
should work with the dump you have:

CREATE TABLE qtl
(
     qtl_id              NUMBER(11)      NOT NULL    CONSTRAINT pk_qtl 
PRIMARY KEY,
     published_symbol    VARCHAR2(100),
     qtl_trait_id        NUMBER(11)      NOT NULL,
     linkage_group       VARCHAR2(32)    NOT NULL,
     start_position      NUMBER(11,2)    NOT NULL,
     stop_position       NUMBER(11,2)    NOT NULL,
     comments            long,
     qtl_accession_id    VARCHAR2(20)    NOT NULL,
     qtl_species_id      NUMBER(11)      NOT NULL,
     species             VARCHAR2(50)    NOT NULL,
     UNIQUE ( qtl_accession_id ),
     FOREIGN KEY ( qtl_trait_id ) REFERENCES qtl_trait
);

ky