-CREATE TABLE Allele (\r
- allele_id int NOT NULL ,\r
- allele varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NOT NULL ,\r
- rev_allele_id int NULL ,\r
- src varchar (10) NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE AlleleFlagCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (12) NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE AlleleMotif (\r
- allele_id int NOT NULL ,\r
- motif_order int NOT NULL ,\r
- motif_id int NOT NULL ,\r
- repeat_cnt real NOT NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE AllocIds (\r
- name varchar (30) NOT NULL ,\r
- id int NOT NULL ,\r
- cycle int NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_updated_time TIMESTAMP NULL ,\r
- comment varchar (255) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE Author (\r
- pub_id int NOT NULL ,\r
- position smallint NOT NULL ,\r
- author varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE Batch_tax_id (\r
- batch_id int NOT NULL ,\r
- tax_id int NOT NULL ,\r
- update_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE ChiSqPValueLookUp (\r
- df smallint NOT NULL ,\r
- chisq_from float NOT NULL ,\r
- chisq_to float NOT NULL ,\r
- pvalue_upper_bound float NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE CpGCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (12) NOT NULL ,\r
- descrip varchar (255) NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE GenBankDivisionCode (\r
- code varchar (6) NOT NULL ,\r
- abbrev varchar (40) NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- display_order smallint NOT NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE GenderCode (\r
- code char (1) NOT NULL ,\r
- gender varchar (6) NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE GenomeBuildInfo (\r
- snp_build_id int NOT NULL ,\r
- tax_id int NOT NULL ,\r
- database_name varchar (32) NOT NULL ,\r
- ncbi_build_id int NOT NULL ,\r
- ncbi_build_ver smallint NOT NULL ,\r
- insert_time TIMESTAMP DEFAULT NOW() NOT NULL ,\r
- is_major smallint DEFAULT 1 NOT NULL ,\r
- ncbi_genome_tax_id int DEFAULT 1 NOT NULL ,\r
- ref_assembly varchar (255) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE GtyAllele (\r
- gty_id int NOT NULL ,\r
- rev_flag bit NOT NULL ,\r
- chr_num smallint NOT NULL ,\r
- fwd_allele_id int NOT NULL ,\r
- unigty_id int NULL ,\r
- create_time TIMESTAMP NOT NULL ,\r
- last_updated_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE IUPACna (\r
- allele varchar (1) NOT NULL ,\r
- meaning varchar (10) NOT NULL ,\r
- bitcode varchar (4) NOT NULL ,\r
- value smallint NOT NULL ,\r
- rev_base char (1) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE LoadHistory (\r
- build_id int NOT NULL ,\r
- loaddate TIMESTAMP NOT NULL ,\r
- status char (30) NOT NULL ,\r
- comments varchar (255) NULL ,\r
- script varchar (255) NULL ,\r
- ftp_done_date TIMESTAMP NULL ,\r
- entrez_done_date TIMESTAMP NULL ,\r
- blastdb_done_date TIMESTAMP NULL ,\r
- web_date TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE LocTypeCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (12) NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- create_time TIMESTAMP DEFAULT NOW() NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE MapLinkCode (\r
- which_code varchar (20) NOT NULL ,\r
- code smallint NOT NULL ,\r
- abbr varchar (10) NULL ,\r
- note varchar (255) NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE Method (\r
- method_id int NOT NULL ,\r
- handle varchar (20) NOT NULL ,\r
- loc_method_id varchar (64) NOT NULL ,\r
- loc_method_id_upp varchar (64) NOT NULL ,\r
- method_class smallint NULL ,\r
- template_type smallint NULL ,\r
- seq_both_strands varchar (3) NULL ,\r
- mult_pcr_amplification varchar (3) NULL ,\r
- mult_clones_tested varchar (3) NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE MethodClass (\r
- meth_class_id smallint NOT NULL ,\r
- name varchar (64) NOT NULL ,\r
- last_updated_time TIMESTAMP NOT NULL ,\r
- validation_status smallint NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE MethodLine (\r
- method_id int NOT NULL ,\r
- line_num smallint NOT NULL ,\r
- line varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE Moltype (\r
- code smallint NOT NULL ,\r
- moltype varchar (10) NOT NULL ,\r
- descrip varchar (255) NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE Motif (\r
- motif_id int NOT NULL ,\r
- motif varchar (253) NOT NULL ,\r
- rev_motif_id int NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE ObsGenotype (\r
- gty_id int NOT NULL ,\r
- obs varchar (512) NOT NULL ,\r
- obs_upp_fix varchar (512) NOT NULL ,\r
- last_updated_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE ObsVariation (\r
- var_id int NOT NULL ,\r
- pattern varchar (255) NOT NULL ,\r
- create_time TIMESTAMP DEFAULT NOW() NOT NULL ,\r
- last_updated_time TIMESTAMP DEFAULT NOW() NULL ,\r
- univar_id int NULL ,\r
- var_flag smallint NULL \r
-)\r
-;\r
-\r
-CREATE TABLE OrgDbStatus (\r
- database_name varchar (32) NOT NULL ,\r
- SNP_cnt int NULL ,\r
- SubSNP_cnt int NULL ,\r
- cluster_cnt int NULL ,\r
- unmapped_rs_cnt int NULL ,\r
- SubInd_cnt int NULL ,\r
- ind_cnt int NULL ,\r
- SubInd_ss_cnt int NULL ,\r
- SubPop_cnt int NULL ,\r
- pop_cnt int NULL ,\r
- SubPop_ss_cnt int NULL ,\r
- GtyFreqBySsPop_ss_cnt int NULL ,\r
- AlleleFreqBySsPop_ss_cnt int NULL ,\r
- SNPGtyFreq_rs_cnt int NULL ,\r
- SNPAlleleFreq_rs_cnt int NULL ,\r
- snp_build_max int NULL ,\r
- genome_build_max varchar (8) NULL ,\r
- map_time TIMESTAMP NULL ,\r
- cluster_time_max TIMESTAMP NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_SNPBatch_time TIMESTAMP NULL ,\r
- last_POPBatch_time TIMESTAMP NULL ,\r
- last_INDBatch_time TIMESTAMP NULL ,\r
- rsMax int NULL ,\r
- rsMissenseMax int NULL ,\r
- copy2FTP_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE OrganismTax (\r
- organism varchar (40) NOT NULL ,\r
- tax_id int NOT NULL ,\r
- common_name varchar (32) NULL ,\r
- gpipe_abbr varchar (7) NOT NULL ,\r
- create_time TIMESTAMP NOT NULL ,\r
- last_updated_time TIMESTAMP NOT NULL ,\r
- comment varchar (255) NULL ,\r
- division_cd varchar (6) NULL ,\r
- database_name varchar (32) NOT NULL ,\r
- short_common_name varchar (32) NOT NULL ,\r
- tax_id_rank varchar (5) NOT NULL ,\r
- species_tax_id int NOT NULL ,\r
- no_freq_summary bit NULL ,\r
- entrez_index smallint NULL ,\r
- pub_genome_build decimal(4, 1) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE PopClass (\r
- pop_id int NOT NULL ,\r
- pop_class_id int NOT NULL ,\r
- snp_count int NULL \r
-)\r
-;\r
-\r
-CREATE TABLE PopClassCode (\r
- pop_class_id int NOT NULL ,\r
- pop_class char (50) NOT NULL ,\r
- pop_class_text char (255) NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE Publication (\r
- pub_id int NOT NULL ,\r
- pmid int NULL ,\r
- handle varchar (20) NOT NULL ,\r
- meduid int NULL ,\r
- title varchar (235) NOT NULL ,\r
- journal varchar (255) NULL ,\r
- vol varchar (255) NULL ,\r
- suppl varchar (128) NULL ,\r
- issue varchar (128) NULL ,\r
- i_suppl varchar (128) NULL ,\r
- pages varchar (255) NULL ,\r
- year smallint NOT NULL ,\r
- status smallint NOT NULL ,\r
- blobflag smallint NULL ,\r
- last_updated TIMESTAMP NOT NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SNPGlossary (\r
- term varchar (256) NOT NULL ,\r
- description varchar (4000) NULL ,\r
- last_updated TIMESTAMP DEFAULT NOW() NULL ,\r
- used_in varchar (32) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SNP_tax_id (\r
- snp_id int NOT NULL ,\r
- tax_id int NULL ,\r
- update_time TIMESTAMP NULL ,\r
- status char (1) DEFAULT 'C' NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SnpChrCode (\r
- code varchar (8) NOT NULL ,\r
- abbrev varchar (20) NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NOT NULL ,\r
- sort_order smallint NULL ,\r
- db_name varchar (32) NULL ,\r
- NC_acc varchar (16) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SnpClassCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (20) NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- display_str varchar (255) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SnpFunctionCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (20) NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NOT NULL ,\r
- top_level_class char (5) NOT NULL ,\r
- is_coding smallint NOT NULL ,\r
- is_exon bit NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SnpValidationCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (64) NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE StrandCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (20) NOT NULL ,\r
- rs_to_ss_orien bit NOT NULL ,\r
- descrip varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SubSNPDelComm (\r
- comment_id smallint NOT NULL ,\r
- comment varchar (255) NOT NULL ,\r
- create_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE SubSNPSeqTypeCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (20) NOT NULL ,\r
- descrip varchar (255) NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE Submitter (\r
- handle varchar (20) NOT NULL ,\r
- name varchar (255) NOT NULL ,\r
- fax varchar (255) NULL ,\r
- phone varchar (255) NULL ,\r
- email varchar (255) NULL ,\r
- lab varchar (255) NULL ,\r
- institution varchar (255) NULL ,\r
- address varchar (255) NULL ,\r
- create_time TIMESTAMP DEFAULT NOW() NULL ,\r
- last_updated_time TIMESTAMP NULL \r
-)\r
-;\r
-\r
-CREATE TABLE TemplateType (\r
- temp_type_id smallint NOT NULL ,\r
- name varchar (64) NOT NULL ,\r
- last_updated_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE UniGty (\r
- unigty_id int NOT NULL ,\r
- gty_str varchar (255) NULL ,\r
- allele_id_1 int NOT NULL ,\r
- allele_id_2 int NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE UniVariAllele (\r
- univar_id int NOT NULL ,\r
- allele_id int NOT NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE UniVariation (\r
- univar_id int NOT NULL ,\r
- var_str varchar (900) NULL ,\r
- allele_cnt smallint NOT NULL ,\r
- subsnp_class smallint NOT NULL ,\r
- iupack_code char (1) NOT NULL ,\r
- top_or_bot_strand char (1) NOT NULL ,\r
- create_time TIMESTAMP NOT NULL ,\r
- last_updated_time TIMESTAMP NOT NULL ,\r
- src_code smallint NULL ,\r
- rev_univar_id int NULL \r
-)\r
-;\r
-\r
-CREATE TABLE UniVariationSrcCode (\r
- code smallint NOT NULL ,\r
- abbrev varchar (20) NOT NULL ,\r
- descrip varchar (255) NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE VariAllele (\r
- var_id int NOT NULL ,\r
- allele_id int NOT NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE db_ftp_table_list (\r
- table_name varchar (32) NOT NULL ,\r
- db_str varchar (64) NOT NULL ,\r
- create_time TIMESTAMP DEFAULT NOW() NULL \r
-)\r
-;\r
-\r
-CREATE TABLE db_map_table_name (\r
- table_name varchar (32) NOT NULL ,\r
- to_index bit NULL ,\r
- isCurrent char (1) NULL ,\r
- inNonHuman char (1) DEFAULT 'N' NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_Allele_rev (\r
- allele_id int NOT NULL ,\r
- rev_flag smallint NOT NULL ,\r
- fwd_allele_id int NOT NULL ,\r
- fwd_allele varchar (255) NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_Motif_rev (\r
- motif_id int NOT NULL ,\r
- rev_flag smallint NOT NULL ,\r
- fwd_motif varchar (253) NULL ,\r
- fwd_motif_id int NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_UniGty_allele (\r
- unigty_id int NOT NULL ,\r
- chr_num smallint NOT NULL ,\r
- allele_id int NOT NULL ,\r
- create_time TIMESTAMP NOT NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_UniGty_rev (\r
- unigty_id int NOT NULL ,\r
- rev_flag smallint NOT NULL ,\r
- fwd_unigty_id int NOT NULL ,\r
- fwd_gty_str varchar (255) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_UniVariation_rev (\r
- univar_id int NOT NULL ,\r
- rev_flag smallint NOT NULL ,\r
- fwd_univar_id int NULL ,\r
- fwd_univar_str varchar (900) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_baseFlip (\r
- base char (1) NULL ,\r
- rev_flag smallint NULL ,\r
- fwd_base char (1) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_gty2unigty_trueSNP (\r
- gty_id int NOT NULL ,\r
- rev_flag bit NOT NULL ,\r
- unigty_id int NULL ,\r
- obs varchar (512) NOT NULL ,\r
- gty_str varchar (255) NULL \r
-)\r
-;\r
-\r
-CREATE TABLE dn_summary (\r
- tax_id int NOT NULL ,\r
- build_id int NOT NULL ,\r
- type varchar (20) NOT NULL ,\r
- cnt int NOT NULL ,\r
- create_time TIMESTAMP DEFAULT NOW() NOT NULL ,\r
- last_updated_time TIMESTAMP DEFAULT NOW() NOT NULL \r
-)\r
-;\r
-\r
+CREATE TABLE Allele
+(
+allele_id int NOT NULL ,
+allele varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+rev_allele_id int NULL ,
+src varchar(10) NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE AlleleFlagCode
+(
+code smallint NOT NULL ,
+abbrev varchar(12) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE AlleleMotif
+(
+allele_id int NOT NULL ,
+motif_order int NOT NULL ,
+motif_id int NOT NULL ,
+repeat_cnt real NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE AllocIds
+(
+name varchar(30) NOT NULL ,
+id int NOT NULL ,
+cycle int NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL ,
+comment varchar(255) NULL
+);
+CREATE TABLE Author
+(
+pub_id int NOT NULL ,
+position smallint NOT NULL ,
+author varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE Batch_tax_id
+(
+batch_id int NOT NULL ,
+tax_id int NOT NULL ,
+update_time TIMESTAMP NOT NULL
+);
+CREATE TABLE ChiSqPValueLookUp
+(
+df smallint NOT NULL ,
+chisq_from float NOT NULL ,
+chisq_to float NOT NULL ,
+pvalue_upper_bound float NOT NULL
+);
+CREATE TABLE CpGCode
+(
+code smallint NOT NULL ,
+abbrev varchar(12) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE GenBankDivisionCode
+(
+code varchar(6) NOT NULL ,
+abbrev varchar(40) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+display_order smallint NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE GenderCode
+(
+code char(1) NOT NULL ,
+gender varchar(6) NOT NULL
+);
+CREATE TABLE GenomeBuildInfo
+(
+snp_build_id int NOT NULL ,
+tax_id int NOT NULL ,
+database_name varchar(32) NOT NULL ,
+ncbi_build_id int NOT NULL ,
+ncbi_build_ver smallint NOT NULL ,
+insert_time TIMESTAMP NOT NULL ,
+is_major smallint NOT NULL ,
+ncbi_genome_tax_id int NOT NULL ,
+ref_assembly varchar(32) NULL ,
+annot_set_acc varchar(32) NULL ,
+annot_set_ver smallint NULL
+);
+CREATE TABLE GtyAllele
+(
+gty_id int NOT NULL ,
+rev_flag bit NOT NULL ,
+chr_num smallint NOT NULL ,
+fwd_allele_id int NOT NULL ,
+unigty_id int NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);
+CREATE TABLE IUPACna
+(
+allele varchar(1) NOT NULL ,
+meaning varchar(10) NOT NULL ,
+bitcode varchar(4) NOT NULL ,
+value smallint NOT NULL ,
+rev_base char(1) NULL
+);
+CREATE TABLE LoadHistory
+(
+build_id int NOT NULL ,
+loaddate TIMESTAMP NOT NULL ,
+status char(30) NOT NULL ,
+comments varchar(255) NULL ,
+script varchar(255) NULL ,
+ftp_done_date TIMESTAMP NULL ,
+entrez_done_date TIMESTAMP NULL ,
+blastdb_done_date TIMESTAMP NULL ,
+web_date TIMESTAMP NULL
+);
+CREATE TABLE LocTypeCode
+(
+code smallint NOT NULL ,
+abbrev varchar(12) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE MapLinkCode
+(
+which_code varchar(20) NOT NULL ,
+code smallint NOT NULL ,
+abbr varchar(10) NULL ,
+note varchar(255) NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE Method
+(
+method_id int NOT NULL ,
+handle varchar(20) NOT NULL ,
+loc_method_id varchar(64) NOT NULL ,
+loc_method_id_upp varchar(64) NOT NULL ,
+method_class smallint NULL ,
+template_type smallint NULL ,
+seq_both_strands varchar(3) NULL ,
+mult_pcr_amplification varchar(3) NULL ,
+mult_clones_tested varchar(3) NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE MethodClass
+(
+meth_class_id smallint NOT NULL ,
+name varchar(64) NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL ,
+validation_status smallint NOT NULL
+);
+CREATE TABLE MethodLine
+(
+method_id int NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE Moltype
+(
+code smallint NOT NULL ,
+moltype varchar(10) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE Motif
+(
+motif_id int NOT NULL ,
+motif varchar(253) NOT NULL ,
+rev_motif_id int NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE ObsGenotype
+(
+gty_id int NOT NULL ,
+obs varchar(512) NOT NULL ,
+obs_upp_fix varchar(512) NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);
+CREATE TABLE ObsVariation
+(
+var_id int NOT NULL ,
+pattern varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NULL ,
+univar_id int NULL ,
+var_flag smallint NULL
+);
+CREATE TABLE OrgDbStatus
+(
+database_name varchar(32) NOT NULL ,
+SNP_cnt int NULL ,
+SubSNP_cnt int NULL ,
+cluster_cnt int NULL ,
+unmapped_rs_cnt int NULL ,
+SubInd_cnt int NULL ,
+ind_cnt int NULL ,
+SubInd_ss_cnt int NULL ,
+SubPop_cnt int NULL ,
+pop_cnt int NULL ,
+SubPop_ss_cnt int NULL ,
+GtyFreqBySsPop_ss_cnt int NULL ,
+AlleleFreqBySsPop_ss_cnt int NULL ,
+SNPGtyFreq_rs_cnt int NULL ,
+SNPAlleleFreq_rs_cnt int NULL ,
+snp_build_max int NULL ,
+genome_build_max varchar(8) NULL ,
+map_time TIMESTAMP NULL ,
+cluster_time_max TIMESTAMP NULL ,
+create_time TIMESTAMP NULL ,
+last_SNPBatch_time TIMESTAMP NULL ,
+last_POPBatch_time TIMESTAMP NULL ,
+last_INDBatch_time TIMESTAMP NULL ,
+rsMax int NULL ,
+rsMissenseMax int NULL ,
+copy2FTP_time TIMESTAMP NULL
+);
+CREATE TABLE OrganismTax
+(
+organism varchar(128) NOT NULL ,
+tax_id int NOT NULL ,
+common_name varchar(32) NULL ,
+gpipe_abbr varchar(7) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL ,
+comment varchar(255) NULL ,
+division_cd varchar(6) NULL ,
+database_name varchar(32) NOT NULL ,
+short_common_name varchar(32) NOT NULL ,
+tax_id_rank varchar(5) NOT NULL ,
+species_tax_id int NOT NULL ,
+no_freq_summary bit NULL ,
+entrez_index smallint NULL ,
+pub_genome_build decimal NULL
+);
+CREATE TABLE PopClass
+(
+pop_id int NOT NULL ,
+pop_class_id int NOT NULL ,
+snp_count int NULL
+);
+CREATE TABLE PopClassCode
+(
+pop_class_id int NOT NULL ,
+pop_class char(50) NOT NULL ,
+pop_class_text char(255) NOT NULL
+);
+CREATE TABLE Publication
+(
+pub_id int NOT NULL ,
+pmid int NULL ,
+handle varchar(20) NOT NULL ,
+meduid int NULL ,
+title varchar(235) NOT NULL ,
+journal varchar(255) NULL ,
+vol varchar(255) NULL ,
+suppl varchar(128) NULL ,
+issue varchar(128) NULL ,
+i_suppl varchar(128) NULL ,
+pages varchar(255) NULL ,
+year smallint NOT NULL ,
+status smallint NOT NULL ,
+blobflag smallint NULL ,
+last_updated TIMESTAMP NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE SNPGlossary
+(
+term varchar(256) NOT NULL ,
+description varchar(4000) NULL ,
+last_updated TIMESTAMP NULL ,
+used_in varchar(32) NULL
+);
+CREATE TABLE SNP_tax_id
+(
+snp_id int NOT NULL ,
+tax_id int NULL ,
+update_time TIMESTAMP NULL ,
+status char(1) NULL
+);
+CREATE TABLE SnpChrCode
+(
+code varchar(8) NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+sort_order smallint NULL ,
+db_name varchar(32) NULL ,
+NC_acc varchar(16) NULL
+);
+CREATE TABLE SnpClassCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+display_str varchar(255) NULL
+);
+CREATE TABLE SnpFunctionCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+top_level_class char(5) NOT NULL ,
+is_coding smallint NOT NULL ,
+is_exon bit NULL ,
+var_prop_loc_code int NULL ,
+var_prop_effect_code int NULL
+);
+CREATE TABLE SnpValidationCode
+(
+code smallint NOT NULL ,
+abbrev varchar(64) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE StrandCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+rs_to_ss_orien bit NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE SubSNPDelComm
+(
+comment_id smallint NOT NULL ,
+comment varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL
+);
+CREATE TABLE SubSNPSeqTypeCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE Submitter
+(
+handle varchar(20) NOT NULL ,
+name varchar(255) NOT NULL ,
+fax varchar(255) NULL ,
+phone varchar(255) NULL ,
+email varchar(255) NULL ,
+lab varchar(255) NULL ,
+institution varchar(255) NULL ,
+address varchar(255) NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE TemplateType
+(
+temp_type_id smallint NOT NULL ,
+name varchar(64) NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);
+CREATE TABLE UniGty
+(
+unigty_id int NOT NULL ,
+gty_str varchar(255) NULL ,
+allele_id_1 int NOT NULL ,
+allele_id_2 int NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE UniVariAllele
+(
+univar_id int NOT NULL ,
+allele_id int NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE UniVariation
+(
+univar_id int NOT NULL ,
+var_str varchar(900) NULL ,
+allele_cnt smallint NOT NULL ,
+subsnp_class smallint NOT NULL ,
+iupack_code char(1) NOT NULL ,
+top_or_bot_strand char(1) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL ,
+src_code smallint NULL ,
+rev_univar_id int NULL
+);
+CREATE TABLE UniVariationSrcCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE VariAllele
+(
+var_id int NOT NULL ,
+allele_id int NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE db_ftp_table_list
+(
+table_name varchar(32) NOT NULL ,
+db_str varchar(64) NOT NULL ,
+create_time TIMESTAMP NULL
+);
+CREATE TABLE db_map_table_name
+(
+table_name varchar(32) NOT NULL ,
+to_index bit NULL ,
+isCurrent char(1) NULL ,
+inNonHuman char(1) NOT NULL
+);
+CREATE TABLE dn_Allele_rev
+(
+allele_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_allele_id int NOT NULL ,
+fwd_allele varchar(255) NOT NULL
+);
+CREATE TABLE dn_Motif_rev
+(
+motif_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_motif varchar(253) NULL ,
+fwd_motif_id int NULL
+);
+CREATE TABLE dn_UniGty_allele
+(
+unigty_id int NOT NULL ,
+chr_num smallint NOT NULL ,
+allele_id int NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE dn_UniGty_rev
+(
+unigty_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_unigty_id int NOT NULL ,
+fwd_gty_str varchar(255) NULL
+);
+CREATE TABLE dn_UniVariation_rev
+(
+univar_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_univar_id int NULL ,
+fwd_univar_str varchar(900) NULL
+);
+CREATE TABLE dn_baseFlip
+(
+base char(1) NULL ,
+rev_flag smallint NULL ,
+fwd_base char(1) NULL
+);
+CREATE TABLE dn_gty2unigty_trueSNP
+(
+gty_id int NOT NULL ,
+rev_flag bit NOT NULL ,
+unigty_id int NULL ,
+obs varchar(512) NOT NULL ,
+gty_str varchar(255) NULL
+);
+CREATE TABLE dn_summary
+(
+tax_id int NOT NULL ,
+build_id int NOT NULL ,
+type varchar(20) NOT NULL ,
+cnt int NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);
projects / dbsnp.git / blobdiff