Seqtable_helper schema

[Steven Schmidt]

Here it is.

It's in 
gramene_ensembl/load-scripts/seqtable/

On Wednesday 21 July 2004 05:34 pm, Ken Youens-Clark wrote:
> Craig,
>
> I will have to defer this one to the Gramene list to see who can help
> you.  I'm unfamiliar with that part of the schema.
>
> ky
>
> Begin forwarded message:
> > Hi,
> > 	I don't suppose you could forward the release 13 schema for
> > SEQTABLE_HELPER too?  I cobbled together a schema from somewhere (can't
> > recall where), but it's apparently quite wrong.
> >
> > Thanks,
> >
> > Craig Miskell,
> > Technical Support,
> > AgResearch Invermay
> > 03 489-9279

-- 
Steven Schmidt
www.gramene.org
Cold Spring Harbor Laboratory
516-367-6977
Maybe someday I'll start following my own advice.
-------------- next part --------------
drop table seqtable_prehelper;
CREATE TABLE seqtable_prehelper
(
  contig_id				NUMBER(10)
 ,clone_id				NUMBER(10)
      --only set if this is in clone table
 ,embl_acc				VARCHAR2(40)
     -- will differ from clone.embl_acc for tigr
 ,embl_version				NUMBER(10)
 ,htg_phase				NUMBER(10)
 ,chromosome				VARCHAR2(10)
 ,super_name				VARCHAR2(20)
 ,super_chr_start			NUMBER(10)
 ,super_chr_end				NUMBER(10)
 ,clone_super_start			NUMBER(10)
 ,clone_super_end			NUMBER(10)
 ,clone_chr_start			NUMBER(10)
 ,clone_chr_end				NUMBER(10)
 ,contig_clone_start			NUMBER(10)
 ,contig_clone_end			NUMBER(10)
 ,bacname				VARCHAR2(40)
 ,bac_length				NUMBER(10)
 ,source				VARCHAR2(40)
);
create index seqtabph_chromosome on seqtable_prehelper(chromosome);
create index seqtabph_contig_id on seqtable_prehelper(contig_id);

drop table seqtable_helper;
CREATE TABLE seqtable_helper
(
 clone_id				NUMBER(10)
      --only set if this is in clone table
 ,bacname				VARCHAR2(40)
 ,chromosome			    	VARCHAR2(10)
-- ,rgp_order				NUMBER(10)
 ,embl_acc				VARCHAR2(40)
     -- will differ from clone.embl_acc for tigr
 ,embl_version				NUMBER(10)
 ,htg_phase				NUMBER(10)
      -- need for deciding whether to link or not
-- ,site				VARCHAR2(40)
-- ,site_home_page			VARCHAR2(80)
-- ,fragments				NUMBER(10)
-- ,clone_length			NUMBER(10)
-- ,clone_num_on_sp			NUMBER(10)
 ,super_name				VARCHAR2(20)
 ,super_chr_start			NUMBER(10)
 ,super_chr_end				NUMBER(10)
 ,clone_super_start			NUMBER(10)
 ,clone_super_end			NUMBER(10)
 ,clone_chr_start			NUMBER(10)
 ,clone_chr_end				NUMBER(10)
 ,marker_name				VARCHAR2(20)
 ,marker_type				VARCHAR2(20)
-- ,marker_id				NUMBER(10)
 ,jrgp_rflp_cm				NUMBER
 ,jrgp_rflp_map				VARCHAR2(20)
 ,jrgp_rflp_feature			VARCHAR2(20)
            -- These are accession id's  
 ,cornell_rflp_cm			NUMBER
 ,cornell_rflp_map			VARCHAR2(20)
 ,cornell_rflp_feature			VARCHAR2(20)
 ,irmi_ssr_cm				NUMBER
 ,irmi_ssr_map				VARCHAR2(20)
 ,irmi_ssr_feature			VARCHAR2(20)
);
create index seqtabh_chromosome on seqtable_helper(chromosome);
create index seqtabh_marker_name on seqtable_helper(marker_name);