X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_9606_table.sql;h=aa943dee97d69f20e68e9c5c3d39f3279cf54c52;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=555e45c3e257d224bdef80e73708a886fc7b23d5;hpb=6e51d2d339036d36e6294b1bbed27e5c18a6a2f5;p=dbsnp.git diff --git a/schema/human_9606_schema/human_9606_table.sql b/schema/human_9606_schema/human_9606_table.sql index 555e45c..aa943de 100644 --- a/schema/human_9606_schema/human_9606_table.sql +++ b/schema/human_9606_schema/human_9606_table.sql @@ -1,896 +1,1075 @@ -CREATE TABLE [AlleleFreqBySsPop] ( - [subsnp_id] [int] NOT NULL , - [pop_id] [int] NOT NULL , - [allele_id] [int] NOT NULL , - [source] [varchar] (2) NOT NULL , - [cnt] [real] NULL , - [freq] [real] NULL , - [last_updated_time] [datetime] NOT NULL +CREATE TABLE [AlleleFreqBySsPop] +( +[subsnp_id] [int] NOT NULL , +[pop_id] [int] NOT NULL , +[allele_id] [int] NOT NULL , +[source] [varchar](2) NOT NULL , +[cnt] [real] NULL , +[freq] [real] NULL , +[last_updated_time] [datetime] NOT NULL ) GO - - -CREATE TABLE [Batch] ( - [batch_id] [int] NOT NULL , - [handle] [varchar] (20) NOT NULL , - [loc_batch_id] [varchar] (64) NOT NULL , - [loc_batch_id_upp] [varchar] (64) NOT NULL , - [batch_type] [char] (3) NOT NULL , - [status] [tinyint] NULL , - [simul_sts_status] [tinyint] NOT NULL , - [moltype] [varchar] (8) NOT NULL , - [method_id] [int] NOT NULL , - [samplesize] [int] NULL , - [synonym_type] [varchar] (255) NULL , - [submitted_time] [smalldatetime] NOT NULL , - [linkout_url] [varchar] (255) NULL , - [pop_id] [int] NULL , - [last_updated_time] [smalldatetime] NULL , - [success_rate_int] [int] NULL , - [build_id] [int] NULL , - [tax_id] [int] NOT NULL , - [ss_cnt] [int] NULL -) -GO - - -CREATE TABLE [BatchCita] ( - [batch_id] [int] NOT NULL , - [position] [int] NOT NULL , - [pub_id] [int] NOT NULL , - [citation] [varchar] (255) NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [BatchCommLine] ( - [batch_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [BatchCultivar] ( - [batch_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [BatchMeExLine] ( - [batch_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [BatchStrain] ( - [batch_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [BatchValCode] ( - [batch_id] [int] NOT NULL , - [validation_status] [tinyint] NOT NULL -) -GO - - -CREATE TABLE [Contact] ( - [batch_id] [int] NOT NULL , - [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] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [FreqSummaryBySsPop] ( - [subsnp_id] [int] NOT NULL , - [pop_id] [int] NOT NULL , - [source] [varchar] (1) NOT NULL , - [chr_cnt] [int] NOT NULL , - [ind_cnt] [int] NOT NULL , - [non_founder_ind_cnt] [int] NOT NULL , - [chisq] [real] NULL , - [df] [tinyint] NULL , - [hwp] [real] NULL , - [het] [real] NULL , - [het_se] [real] NULL , - [last_updated_time] [smalldatetime] NOT NULL -) -GO - - -CREATE TABLE [GeneIdToName] ( - [gene_id] [int] NOT NULL , - [gene_symbol] [varchar] (64) NOT NULL , - [gene_name] [varchar] (255) NULL , - [gene_type] [varchar] (255) NULL , - [tax_id] [int] NOT NULL , - [last_update_time] [smalldatetime] NOT NULL , - [ref_tax_id] [int] NOT NULL , - [dbSNP_tax_id] [int] NOT NULL , - [ins_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [GtyFreqBySsPop] ( - [subsnp_id] [int] NOT NULL , - [pop_id] [int] NOT NULL , - [unigty_id] [int] NOT NULL , - [source] [varchar] (1) NULL , - [cnt] [real] NULL , - [freq] [real] NULL , - [last_updated_time] [datetime] NOT NULL -) -GO - - -CREATE TABLE [IndGrpCode] ( - [code] [tinyint] NOT NULL , - [name] [varchar] (32) NOT NULL , - [descrip] [varchar] (255) NOT NULL -) -GO - - -CREATE TABLE [IndivBySource] ( - [ind_id] [int] NOT NULL , - [src_id] [int] NOT NULL , - [src_ind_id] [varchar] (64) NOT NULL , - [create_time] [smalldatetime] NOT NULL , - [src_ind_grp] [varchar] (64) NULL -) -GO - - -CREATE TABLE [IndivSourceCode] ( - [code] [int] NOT NULL , - [name] [varchar] (22) NOT NULL , - [descrip] [varchar] (255) NULL , - [create_time] [smalldatetime] NOT NULL , - [src_type] [varchar] (10) NULL , - [display_order] [tinyint] NULL -) -GO - - -CREATE TABLE [Individual] ( - [ind_id] [int] NOT NULL , - [descrip] [varchar] (255) NULL , - [create_time] [smalldatetime] NOT NULL , - [tax_id] [int] NULL , - [ind_grp] [tinyint] NULL -) -GO - - -CREATE TABLE [OmimVarLocusIdSNP] ( - [omim_id] [int] NOT NULL , - [locus_id] [int] NULL , - [omimvar_id] [char] (4) NULL , - [locus_symbol] [char] (10) NULL , - [var1] [char] (20) NULL , - [aa_position] [int] NULL , - [var2] [char] (20) NULL , - [var_class] [int] NOT NULL , - [snp_id] [int] NOT NULL -) -GO - - -CREATE TABLE [Pedigree] ( - [ped_id] [numeric](7, 0) NOT NULL , - [curator] [varchar] (12) NOT NULL , - [curator_ped_id] [varchar] (12) NOT NULL , - [create_time] [smalldatetime] NOT NULL -) -GO - - -CREATE TABLE [PedigreeIndividual] ( - [ped_id] [decimal](7, 0) NOT NULL , - [ind_id] [int] NOT NULL , - [ma_ind_id] [int] NULL , - [pa_ind_id] [int] NULL , - [sex] [char] (1) NULL , - [create_time] [smalldatetime] NOT NULL -) -GO - - -CREATE TABLE [PopLine] ( - [pop_id] [int] NOT NULL , - [line_num] [int] NOT NULL , - [line] [varchar] (255) NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [PopMandLine] ( - [pop_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [Population] ( - [pop_id] [int] NOT NULL , - [handle] [varchar] (20) NOT NULL , - [loc_pop_id] [varchar] (64) NOT NULL , - [loc_pop_id_upp] [varchar] (64) NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL , - [src_id] [int] NULL -) -GO - - -CREATE TABLE [RsMergeArch] ( - [rsHigh] [int] NULL , - [rsLow] [int] NULL , - [build_id] [int] NULL , - [orien] [tinyint] NULL , - [create_time] [datetime] NOT NULL , - [last_updated_time] [datetime] NOT NULL , - [rsCurrent] [int] NULL , - [orien2Current] [tinyint] NULL , - [comment] [varchar] (255) NULL -) -GO - - -CREATE TABLE [SNP] ( - [snp_id] [int] NULL , - [avg_heterozygosity] [real] NULL , - [het_se] [real] NULL , - [create_time] [datetime] NULL , - [last_updated_time] [datetime] NULL , - [CpG_code] [tinyint] NULL , - [tax_id] [int] NULL , - [validation_status] [tinyint] NULL , - [exemplar_subsnp_id] [int] NULL , - [univar_id] [int] NULL , - [cnt_subsnp] [int] NULL , - [map_property] [tinyint] NULL -) -GO - - -CREATE TABLE [SNP3D] ( - [snp_id] [int] NOT NULL , - [protein_acc] [char] (50) NOT NULL , - [master_gi] [int] NOT NULL , - [neighbor_gi] [int] NOT NULL , - [aa_position] [int] NOT NULL , - [var_res] [char] (1) NOT NULL , - [contig_res] [char] (1) NOT NULL , - [neighbor_res] [char] (1) NOT NULL , - [neighbor_pos] [int] NOT NULL , - [var_color] [int] NOT NULL , - [var_label] [int] NOT NULL + +CREATE TABLE [Batch] +( +[batch_id] [int] NOT NULL , +[handle] [varchar](20) NOT NULL , +[loc_batch_id] [varchar](64) NOT NULL , +[loc_batch_id_upp] [varchar](64) NOT NULL , +[batch_type] [char](3) NOT NULL , +[status] [tinyint] NULL , +[simul_sts_status] [tinyint] NOT NULL , +[moltype] [varchar](8) NOT NULL , +[method_id] [int] NOT NULL , +[samplesize] [int] NULL , +[synonym_type] [varchar](255) NULL , +[submitted_time] [smalldatetime] NOT NULL , +[linkout_url] [varchar](255) NULL , +[pop_id] [int] NULL , +[last_updated_time] [smalldatetime] NULL , +[success_rate_int] [int] NULL , +[build_id] [int] NULL , +[tax_id] [int] NOT NULL , +[ss_cnt] [int] NULL +) +GO + +CREATE TABLE [BatchCita] +( +[batch_id] [int] NOT NULL , +[position] [int] NOT NULL , +[pub_id] [int] NOT NULL , +[citation] [varchar](255) NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [BatchCommLine] +( +[batch_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [BatchCultivar] +( +[batch_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [BatchMeExLine] +( +[batch_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [BatchStrain] +( +[batch_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [BatchValCode] +( +[batch_id] [int] NOT NULL , +[validation_status] [tinyint] NOT NULL ) GO - -CREATE TABLE [SNPAlleleFreq] ( - [snp_id] [int] NOT NULL , - [allele_id] [int] NOT NULL , - [chr_cnt] [float] NULL , - [freq] [float] NULL , - [last_updated_time] [datetime] NOT NULL +CREATE TABLE [ClinSigCode] +( +[code] [int] NOT NULL , +[abbrev] [varchar](64) NULL , +[descrip] [varchar](255) NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL ) GO - -CREATE TABLE [SNPAncestralAllele] ( - [snp_id] [int] NOT NULL , - [ancestral_allele_id] [int] NOT NULL , - [batch_id] [int] NOT NULL +CREATE TABLE [Contact] +( +[batch_id] [int] NOT NULL , +[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] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL ) GO - -CREATE TABLE [SNPGtyFreq] ( - [snp_id] [int] NOT NULL , - [unigty_id] [int] NOT NULL , - [ind_cnt] [float] NULL , - [freq] [float] NULL , - [last_updated_time] [datetime] NOT NULL +CREATE TABLE [FreqSummaryBySsPop] +( +[subsnp_id] [int] NOT NULL , +[pop_id] [int] NOT NULL , +[source] [varchar](1) NOT NULL , +[chr_cnt] [float] NULL , +[ind_cnt] [float] NULL , +[non_founder_ind_cnt] [int] NOT NULL , +[chisq] [float] NULL , +[df] [int] NULL , +[hwp] [float] NOT NULL , +[het] [int] NULL , +[het_se] [int] NULL , +[last_updated_time] [datetime] NOT NULL ) GO - -CREATE TABLE [SNPHWProb] ( - [snp_id] [int] NOT NULL , - [df] [tinyint] NULL , - [chisq] [real] NULL , - [hwp] [real] NULL , - [ind_cnt] [smallint] NULL , - [last_updated_time] [smalldatetime] NULL +CREATE TABLE [GeneIdToName] +( +[gene_id] [int] NOT NULL , +[gene_symbol] [varchar](64) NOT NULL , +[gene_name] [varchar](255) NULL , +[gene_type] [varchar](255) NULL , +[tax_id] [int] NOT NULL , +[last_update_time] [smalldatetime] NOT NULL , +[ref_tax_id] [int] NOT NULL , +[dbSNP_tax_id] [int] NOT NULL , +[ins_time] [smalldatetime] NULL ) GO - -CREATE TABLE [SNPHistory] ( - [snp_id] [int] NOT NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NOT NULL , - [history_create_time] [smalldatetime] NULL , - [comment] [varchar] (255) NULL +CREATE TABLE [GtyFreqBySsPop] +( +[subsnp_id] [int] NOT NULL , +[pop_id] [int] NOT NULL , +[unigty_id] [int] NOT NULL , +[source] [varchar](1) NULL , +[cnt] [real] NULL , +[freq] [real] NULL , +[last_updated_time] [datetime] NOT NULL ) GO - -CREATE TABLE [SNPPubmed] ( - [snp_id] [int] NOT NULL , - [subsnp_id] [int] NOT NULL , - [pubmed_id] [int] NOT NULL , - [type] [varchar] (16) NOT NULL , - [score] [int] NOT NULL , - [upd_date] [smalldatetime] NOT NULL +CREATE TABLE [IndGrpCode] +( +[code] [tinyint] NOT NULL , +[name] [varchar](32) NOT NULL , +[descrip] [varchar](255) NOT NULL ) GO - -CREATE TABLE [SNPSubSNPLink] ( - [subsnp_id] [int] NULL , - [snp_id] [int] NULL , - [substrand_reversed_flag] [tinyint] NULL , - [create_time] [datetime] NULL , - [last_updated_time] [datetime] NULL , - [build_id] [int] NULL , - [comment] [varchar] (255) NULL +CREATE TABLE [IndivBySource] +( +[ind_id] [int] NOT NULL , +[src_id] [int] NOT NULL , +[src_ind_id] [varchar](64) NOT NULL , +[create_time] [smalldatetime] NOT NULL , +[src_ind_grp] [varchar](64) NULL ) GO - -CREATE TABLE [SNPSubSNPLinkHistory] ( - [subsnp_id] [int] NULL , - [snp_id] [int] NULL , - [build_id] [int] NULL , - [history_create_time] [datetime] NOT NULL , - [link_create_time] [datetime] NULL , - [link_last_updated_time] [datetime] NULL , - [orien] [tinyint] NULL , - [build_id_when_history_made] [int] NULL , - [comment] [varchar] (255) NULL +CREATE TABLE [IndivSourceCode] +( +[code] [int] NOT NULL , +[name] [varchar](22) NOT NULL , +[descrip] [varchar](255) NULL , +[create_time] [smalldatetime] NOT NULL , +[src_type] [varchar](10) NULL , +[display_order] [tinyint] NULL ) GO - -CREATE TABLE [SNPVal] ( - [batch_id] [int] NOT NULL , - [snp_id] [int] NOT NULL +CREATE TABLE [Individual] +( +[ind_id] [int] NOT NULL , +[descrip] [varchar](255) NULL , +[create_time] [smalldatetime] NOT NULL , +[tax_id] [int] NULL , +[ind_grp] [tinyint] NULL ) GO - -CREATE TABLE [SNP_HGVS] ( - [snp_id] [int] NULL , - [hgvs_name] [varchar] (256) NULL , - [source] [varchar] (8) NOT NULL , - [upd_time] [datetime] NOT NULL +CREATE TABLE [OmimVarLocusIdSNP] +( +[omim_id] [int] NOT NULL , +[locus_id] [int] NULL , +[omimvar_id] [char](4) NULL , +[locus_symbol] [char](10) NULL , +[var1] [char](20) NULL , +[aa_position] [int] NULL , +[var2] [char](20) NULL , +[var_class] [int] NOT NULL , +[snp_id] [int] NOT NULL ) GO - -CREATE TABLE [SNP_bitfield] ( - [snp_id] [int] NOT NULL , - [ver_code] [tinyint] NULL , - [link_prop_b1] [tinyint] NULL , - [link_prop_b2] [tinyint] NULL , - [gene_prop_b1] [tinyint] NULL , - [gene_prop_b2] [tinyint] NULL , - [map_prop] [tinyint] NULL , - [freq_prop] [tinyint] NULL , - [gty_prop] [tinyint] NULL , - [hapmap_prop] [tinyint] NULL , - [pheno_prop] [tinyint] NULL , - [variation_class] [tinyint] NOT NULL , - [quality_check] [tinyint] NULL , - [upd_time] [datetime] NOT NULL , - [encoding] [binary] (12) NULL -) +CREATE TABLE [Pedigree] +( +[ped_id] [numeric] NOT NULL , +[curator] [varchar](12) NOT NULL , +[curator_ped_id] [varchar](12) NOT NULL , +[create_time] [smalldatetime] NOT NULL +) GO - -CREATE TABLE [SubPop] ( - [batch_id] [int] NOT NULL , - [subsnp_id] [int] NOT NULL , - [pop_id] [int] NOT NULL , - [type] [char] (3) NOT NULL , - [samplesize] [int] NOT NULL , - [submitted_strand_code] [tinyint] NULL , - [submitted_rs] [int] NULL , - [allele_flag] [tinyint] NULL , - [ambiguity_status] [tinyint] NULL , - [sub_heterozygosity] [real] NULL , - [est_heterozygosity] [real] NULL , - [est_het_se_sq] [real] NULL , - [last_updated_time] [smalldatetime] NOT NULL , - [observed] [varchar] (1000) NULL , - [sub_het_se_sq] [real] NULL , - [subpop_id] [int] IDENTITY (1, 1) NOT NULL +CREATE TABLE [PedigreeIndividual] +( +[ped_id] [decimal] NOT NULL , +[ind_id] [int] NOT NULL , +[ma_ind_id] [int] NULL , +[pa_ind_id] [int] NULL , +[sex] [char](1) NULL , +[create_time] [smalldatetime] NOT NULL ) GO - -CREATE TABLE [SubPopAllele] ( - [batch_id] [int] NOT NULL , - [subsnp_id] [int] NOT NULL , - [pop_id] [int] NOT NULL , - [allele] [char] (1) NOT NULL , - [other] [varchar] (255) NULL , - [freq] [real] NULL , - [cnt_int] [int] NULL , - [freq_min] [real] NULL , - [freq_max] [real] NULL , - [data_src] [varchar] (6) NULL , - [type] [char] (3) NULL , - [last_updated_time] [smalldatetime] NULL , - [allele_flag] [tinyint] NULL , - [cnt] [real] NULL , - [allele_id] [int] NULL , - [subpop_id] [int] NOT NULL +CREATE TABLE [PopLine] +( +[pop_id] [int] NOT NULL , +[line_num] [int] NOT NULL , +[line] [varchar](255) NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL ) GO - -CREATE TABLE [SubPopGty] ( - [subpop_id] [int] NOT NULL , - [gty_id] [int] NOT NULL , - [gty_str] [varchar] (255) NULL , - [cnt] [real] NULL , - [freq] [real] NULL , - [last_updated_time] [smalldatetime] NOT NULL +CREATE TABLE [PopMandLine] +( +[pop_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL ) GO - -CREATE TABLE [SubSNP] ( - [subsnp_id] [int] NOT NULL , - [known_snp_handle] [varchar] (20) NULL , - [known_snp_loc_id] [varchar] (64) NULL , - [known_snp_loc_id_upp] [varchar] (64) NULL , - [batch_id] [int] NOT NULL , - [loc_snp_id] [varchar] (64) NULL , - [loc_snp_id_upp] [varchar] (64) NULL , - [synonym_names] [varchar] (255) NULL , - [loc_sts_id] [varchar] (64) NULL , - [loc_sts_id_upp] [varchar] (64) NULL , - [segregate] [char] (1) NOT NULL , - [indiv_homozygosity_detected] [char] (1) NULL , - [PCR_confirmed_ind] [char] (1) NULL , - [gene_name] [varchar] (64) NULL , - [sequence_len] [int] NULL , - [samplesize] [int] NULL , - [EXPRESSED_SEQUENCE_ind] [char] (1) NULL , - [SOMATIC_ind] [char] (1) NULL , - [sub_locus_id] [int] NULL , - [create_time] [smalldatetime] NULL , - [last_updated_time] [smalldatetime] NULL , - [ancestral_allele] [varchar] (255) NULL , - [CpG_code] [tinyint] NULL , - [variation_id] [int] NULL , - [top_or_bot_strand] [char] (1) NULL , - [validation_status] [tinyint] NULL , - [snp_id] [int] NULL , - [tax_id] [int] NOT NULL , - [chr_id] [tinyint] NULL +CREATE TABLE [Population] +( +[pop_id] [int] NOT NULL , +[handle] [varchar](20) NOT NULL , +[loc_pop_id] [varchar](64) NOT NULL , +[loc_pop_id_upp] [varchar](64) NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL , +[src_id] [int] NULL ) GO - -CREATE TABLE [SubSNPAcc_ins] ( - [subsnp_id] [int] NOT NULL , - [acc_type_ind] [char] (1) NOT NULL , - [acc_part] [varchar] (16) NOT NULL , - [acc_ver] [int] NULL +CREATE TABLE [RsMergeArch] +( +[rsHigh] [int] NULL , +[rsLow] [int] NULL , +[build_id] [int] NULL , +[orien] [tinyint] NULL , +[create_time] [datetime] NOT NULL , +[last_updated_time] [datetime] NOT NULL , +[rsCurrent] [int] NULL , +[orien2Current] [tinyint] NULL , +[comment] [varchar](255) NULL ) GO - -CREATE TABLE [SubSNPCommLine_ins] ( - [subsnp_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL +CREATE TABLE [SNP] +( +[snp_id] [int] NULL , +[avg_heterozygosity] [real] NULL , +[het_se] [real] NULL , +[create_time] [datetime] NULL , +[last_updated_time] [datetime] NULL , +[CpG_code] [tinyint] NULL , +[tax_id] [int] NULL , +[validation_status] [tinyint] NULL , +[exemplar_subsnp_id] [int] NULL , +[univar_id] [int] NULL , +[cnt_subsnp] [int] NULL , +[map_property] [tinyint] NULL ) GO - -CREATE TABLE [SubSNPHGVS] ( - [subsnp_id] [int] NOT NULL , - [sub_hgvs_c] [varchar] (32) NULL , - [sub_hgvs_g] [varchar] (32) NULL , - [sub_hgvs_p] [varchar] (32) NULL , - [cal_hgvs_c] [varchar] (32) NULL , - [cal_hgvs_g] [varchar] (32) NULL , - [cal_hgvs_p] [varchar] (32) NULL , - [upd_time] [smalldatetime] NULL , - [gene_id] [int] NULL +CREATE TABLE [SNP3D] +( +[snp_id] [int] NOT NULL , +[protein_acc] [char](50) NOT NULL , +[master_gi] [int] NOT NULL , +[neighbor_gi] [int] NOT NULL , +[aa_position] [int] NOT NULL , +[var_res] [char](1) NOT NULL , +[contig_res] [char](1) NOT NULL , +[neighbor_res] [char](1) NOT NULL , +[neighbor_pos] [int] NOT NULL , +[var_color] [int] NOT NULL , +[var_label] [int] NOT NULL ) GO - -CREATE TABLE [SubSNPLinkout] ( - [subsnp_id] [int] NOT NULL , - [url_val] [varchar] (255) NOT NULL , - [updated_time] [smalldatetime] NULL , - [link_type] [varchar] (3) NOT NULL +CREATE TABLE [SNPAlleleFreq] +( +[snp_id] [int] NOT NULL , +[allele_id] [int] NOT NULL , +[chr_cnt] [float] NULL , +[freq] [float] NULL , +[last_updated_time] [datetime] NOT NULL ) GO - -CREATE TABLE [SubSNPMdFailLn] ( - [subsnp_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL +CREATE TABLE [SNPAlleleFreq_TGP] +( +[snp_id] [int] NOT NULL , +[allele_id] [int] NOT NULL , +[freq] [float] NULL , +[count] [int] NULL , +[is_minor_allele] [bit] NULL ) GO - -CREATE TABLE [SubSNPNoVariSeq] ( - [subsnp_id] [int] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL +CREATE TABLE [SNPAncestralAllele] +( +[snp_id] [int] NOT NULL , +[ancestral_allele_id] [int] NOT NULL , +[batch_id] [int] NOT NULL ) GO - -CREATE TABLE [SubSNPOmim] ( - [subsnp_id] [int] NOT NULL , - [omim_id] [int] NOT NULL , - [allele_variant_id] [varchar] (32) NULL , - [update_time] [smalldatetime] NULL , - [mutObsCount] [int] NULL +CREATE TABLE [SNPClinSig] +( +[snp_id] [int] NOT NULL , +[clin_sig_id] [int] NULL , +[upd_time] [smalldatetime] NULL , +[clin_test_code] [varchar](16) NULL ) GO - -CREATE TABLE [SubSNPPubmed] ( - [subsnp_id] [int] NOT NULL , - [line_num] [int] NOT NULL , - [pubmed_id] [int] NOT NULL , - [updated_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [SubSNPSeq3_ins] ( - [subsnp_id] [int] NOT NULL , - [type] [tinyint] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL +CREATE TABLE [SNPGtyFreq] +( +[snp_id] [int] NOT NULL , +[unigty_id] [int] NOT NULL , +[ind_cnt] [float] NULL , +[freq] [float] NULL , +[last_updated_time] [datetime] NOT NULL ) GO - -CREATE TABLE [SubSNPSeq5_ins] ( - [subsnp_id] [int] NOT NULL , - [type] [tinyint] NOT NULL , - [line_num] [tinyint] NOT NULL , - [line] [varchar] (255) NOT NULL +CREATE TABLE [SNPHWProb] +( +[snp_id] [int] NOT NULL , +[df] [tinyint] NULL , +[chisq] [real] NULL , +[hwp] [real] NULL , +[ind_cnt] [smallint] NULL , +[last_updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [SNPHistory] +( +[snp_id] [int] NOT NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NOT NULL , +[history_create_time] [smalldatetime] NULL , +[comment] [varchar](255) NULL , +[reactivated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [SNPPubmed] +( +[snp_id] [int] NULL , +[subsnp_id] [int] NOT NULL , +[pubmed_id] [int] NULL , +[type] [varchar](9) NOT NULL , +[score] [int] NOT NULL , +[upd_time] [datetime] NOT NULL +) +GO + +CREATE TABLE [SNPSubSNPLink] +( +[subsnp_id] [int] NULL , +[snp_id] [int] NULL , +[substrand_reversed_flag] [tinyint] NULL , +[create_time] [datetime] NULL , +[last_updated_time] [datetime] NULL , +[build_id] [int] NULL , +[comment] [varchar](255) NULL +) +GO + +CREATE TABLE [SNPSubSNPLinkHistory] +( +[subsnp_id] [int] NULL , +[snp_id] [int] NULL , +[build_id] [int] NULL , +[history_create_time] [datetime] NOT NULL , +[link_create_time] [datetime] NULL , +[link_last_updated_time] [datetime] NULL , +[orien] [tinyint] NULL , +[build_id_when_history_made] [int] NULL , +[comment] [varchar](255) NULL +) +GO + +CREATE TABLE [SNPSuspect] +( +[snp_id] [int] NOT NULL , +[reason_code] [int] NULL , +[upd_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [dbo].[SuspectReasonCode]( + [code] [int] NOT NULL, + [abbrev] [varchar](64) NULL, + [descrip] [varchar](255) NULL, + [create_time] [smalldatetime] NULL, + [last_update_time] [smalldatetime] NULL, +PRIMARY KEY CLUSTERED +( + [code] ASC +)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] +) ON [PRIMARY] + +CREATE TABLE [SNPVal] +( +[batch_id] [int] NOT NULL , +[snp_id] [int] NOT NULL +) +GO + +CREATE TABLE [SNP_HGVS] +( +[snp_id] [int] NULL , +[hgvs_name] [varchar](4000) NULL , +[source] [varchar](3) NOT NULL , +[upd_time] [datetime] NOT NULL +) +GO + +CREATE TABLE [SNP_bitfield] +( +[snp_id] [int] NOT NULL , +[ver_code] [tinyint] NULL , +[link_prop_b1] [tinyint] NULL , +[link_prop_b2] [tinyint] NULL , +[gene_prop_b1] [tinyint] NULL , +[gene_prop_b2] [tinyint] NULL , +[map_prop] [tinyint] NULL , +[freq_prop] [tinyint] NULL , +[gty_prop] [tinyint] NULL , +[hapmap_prop] [tinyint] NULL , +[pheno_prop] [tinyint] NULL , +[variation_class] [tinyint] NOT NULL , +[quality_check] [tinyint] NULL , +[upd_time] [datetime] NOT NULL , +[encoding] [binary] NULL +) +GO + +CREATE TABLE [SubPop] +( +[batch_id] [int] NOT NULL , +[subsnp_id] [int] NOT NULL , +[pop_id] [int] NOT NULL , +[type] [char](3) NOT NULL , +[samplesize] [int] NOT NULL , +[submitted_strand_code] [tinyint] NULL , +[submitted_rs] [int] NULL , +[allele_flag] [tinyint] NULL , +[ambiguity_status] [tinyint] NULL , +[sub_heterozygosity] [real] NULL , +[est_heterozygosity] [real] NULL , +[est_het_se_sq] [real] NULL , +[last_updated_time] [smalldatetime] NOT NULL , +[observed] [varchar](1000) NULL , +[sub_het_se_sq] [real] NULL , +[subpop_id] [int] IDENTITY(1,1) NOT NULL +) +GO + +CREATE TABLE [SubPopAllele] +( +[batch_id] [int] NOT NULL , +[subsnp_id] [int] NOT NULL , +[pop_id] [int] NOT NULL , +[allele] [char](1) NOT NULL , +[other] [varchar](255) NULL , +[freq] [real] NULL , +[cnt_int] [int] NULL , +[freq_min] [real] NULL , +[freq_max] [real] NULL , +[data_src] [varchar](6) NULL , +[type] [char](3) NULL , +[last_updated_time] [smalldatetime] NULL , +[allele_flag] [tinyint] NULL , +[cnt] [real] NULL , +[allele_id] [int] NULL , +[subpop_id] [int] NOT NULL +) +GO + +CREATE TABLE [SubPopGty] +( +[subpop_id] [int] NOT NULL , +[gty_id] [int] NOT NULL , +[gty_str] [varchar](255) NULL , +[cnt] [real] NULL , +[freq] [real] NULL , +[last_updated_time] [smalldatetime] NOT NULL +) +GO + +CREATE TABLE [SubSNP] +( +[subsnp_id] [int] NOT NULL , +[known_snp_handle] [varchar](20) NULL , +[known_snp_loc_id] [varchar](64) NULL , +[known_snp_loc_id_upp] [varchar](64) NULL , +[batch_id] [int] NOT NULL , +[loc_snp_id] [varchar](64) NULL , +[loc_snp_id_upp] [varchar](64) NULL , +[synonym_names] [varchar](255) NULL , +[loc_sts_id] [varchar](64) NULL , +[loc_sts_id_upp] [varchar](64) NULL , +[segregate] [char](1) NOT NULL , +[indiv_homozygosity_detected] [char](1) NULL , +[PCR_confirmed_ind] [char](1) NULL , +[gene_name] [varchar](64) NULL , +[sequence_len] [int] NULL , +[samplesize] [int] NULL , +[EXPRESSED_SEQUENCE_ind] [char](1) NULL , +[SOMATIC_ind] [char](1) NULL , +[sub_locus_id] [int] NULL , +[create_time] [smalldatetime] NULL , +[last_updated_time] [smalldatetime] NULL , +[ancestral_allele] [varchar](255) NULL , +[CpG_code] [tinyint] NULL , +[variation_id] [int] NULL , +[top_or_bot_strand] [char](1) NULL , +[validation_status] [tinyint] NULL , +[snp_id] [int] NULL , +[tax_id] [int] NOT NULL , +[chr_id] [tinyint] NULL +) +GO + +CREATE TABLE [SubSNPAcc_ins] +( +[subsnp_id] [int] NOT NULL , +[acc_type_ind] [char](1) NOT NULL , +[acc_part] [varchar](16) NOT NULL , +[acc_ver] [int] NULL +) +GO + +CREATE TABLE [SubSNPCommLine_ins] +( +[subsnp_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL +) +GO + +CREATE TABLE [SubSNPHGVS] +( +[subsnp_id] [int] NOT NULL , +[sub_hgvs_c] [varchar](32) NULL , +[sub_hgvs_g] [varchar](64) NULL , +[sub_hgvs_p] [varchar](32) NULL , +[cal_hgvs_c] [varchar](32) NULL , +[cal_hgvs_g] [varchar](32) NULL , +[cal_hgvs_p] [varchar](32) NULL , +[upd_time] [smalldatetime] NULL , +[gene_id] [int] NULL ) GO - -CREATE TABLE [SubSNPSeqPos] ( - [subsnp_id] [int] NOT NULL , - [contig_acc] [varchar] (20) NOT NULL , - [contig_pos] [int] NOT NULL , - [chr] [varchar] (2) NULL , - [upstream_len] [int] NOT NULL , - [downstream_len] [int] NOT NULL , - [last_update_time] [smalldatetime] NOT NULL , - [mrna_acc] [varchar] (24) NULL +CREATE TABLE [SubSNPLinkout] +( +[subsnp_id] [int] NOT NULL , +[url_val] [varchar](255) NOT NULL , +[updated_time] [smalldatetime] NULL , +[link_type] [varchar](3) NOT NULL ) GO - -CREATE TABLE [SubSNP_top_or_bot] ( - [subsnp_id] [int] NOT NULL , - [top_or_bot] [char] (1) NULL , - [step] [tinyint] NULL , - [last_updated_time] [smalldatetime] NULL +CREATE TABLE [SubSNPMdFailLn] +( +[subsnp_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL ) GO - -CREATE TABLE [SubmittedIndividual] ( - [submitted_ind_id] [int] NOT NULL , - [pop_id] [int] NOT NULL , - [loc_ind_id_upp] [varchar] (64) NOT NULL , - [ind_id] [int] NULL , - [create_time] [smalldatetime] NOT NULL , - [last_updated_time] [smalldatetime] NULL , - [tax_id] [int] NOT NULL , - [loc_ind_alias] [varchar] (64) NULL , - [loc_ind_id] [varchar] (64) NULL , - [loc_ind_grp] [varchar] (64) NULL , - [ploidy] [tinyint] NULL +CREATE TABLE [SubSNPNoVariSeq] +( +[subsnp_id] [int] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL ) -GO - - -CREATE TABLE [Synonym] ( - [subsnp_id] [int] NOT NULL , - [type] [varchar] (64) NOT NULL , - [name] [varchar] (64) NULL +GO + +CREATE TABLE [SubSNPOmim] +( +[subsnp_id] [int] NOT NULL , +[omim_id] [int] NOT NULL , +[allele_variant_id] [varchar](32) NULL , +[update_time] [smalldatetime] NULL , +[mutObsCount] [int] NULL +) +GO + +CREATE TABLE [SubSNPPubmed] +( +[subsnp_id] [int] NOT NULL , +[line_num] [int] NOT NULL , +[pubmed_id] [int] NOT NULL , +[updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [SubSNPSeq3_ins] +( +[subsnp_id] [int] NOT NULL , +[type] [tinyint] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL +) +GO + +CREATE TABLE [SubSNPSeq5_ins] +( +[subsnp_id] [int] NOT NULL , +[type] [tinyint] NOT NULL , +[line_num] [tinyint] NOT NULL , +[line] [varchar](255) NOT NULL +) +GO + +CREATE TABLE [SubSNPSeqPos] +( +[subsnp_id] [int] NOT NULL , +[contig_acc] [varchar](20) NOT NULL , +[contig_pos] [int] NOT NULL , +[chr] [varchar](2) NULL , +[upstream_len] [int] NOT NULL , +[downstream_len] [int] NOT NULL , +[last_update_time] [smalldatetime] NOT NULL , +[mrna_acc] [varchar](24) NULL +) +GO + +CREATE TABLE [SubSNP_top_or_bot] +( +[subsnp_id] [int] NOT NULL , +[top_or_bot] [char](1) NULL , +[step] [tinyint] NULL , +[last_updated_time] [smalldatetime] NULL +) +GO + +CREATE TABLE [SubmittedIndividual] +( +[submitted_ind_id] [int] NOT NULL , +[pop_id] [int] NOT NULL , +[loc_ind_id_upp] [varchar](64) NOT NULL , +[ind_id] [int] NULL , +[create_time] [smalldatetime] NOT NULL , +[last_updated_time] [smalldatetime] NULL , +[tax_id] [int] NOT NULL , +[loc_ind_alias] [varchar](64) NULL , +[loc_ind_id] [varchar](64) NULL , +[loc_ind_grp] [varchar](64) NULL , +[ploidy] [tinyint] NULL +) +GO + +CREATE TABLE [Synonym] +( +[subsnp_id] [int] NOT NULL , +[type] [varchar](64) NOT NULL , +[name] [varchar](64) NULL +) +GO + +CREATE TABLE [b135_ContigInfo_37_3] +( +[ctg_id] [int] NOT NULL , +[tax_id] [int] NOT NULL , +[contig_acc] [varchar](32) NOT NULL , +[contig_ver] [tinyint] NOT NULL , +[contig_name] [varchar](63) NULL , +[contig_chr] [varchar](32) NULL , +[contig_start] [int] NULL , +[contig_end] [int] NULL , +[orient] [tinyint] NULL , +[contig_gi] [int] NOT NULL , +[group_term] [varchar](32) NULL , +[group_label] [varchar](32) NULL , +[contig_label] [varchar](32) NULL , +[build_id] [int] NOT NULL , +[build_ver] [int] NOT NULL , +[last_updated_time] [datetime] NOT NULL , +[placement_status] [tinyint] NOT NULL , +[asm_acc] [varchar](32) NULL , +[asm_version] [smallint] NULL , +[chr_gi] [int] NULL , +[par_fl] [tinyint] NULL , +[top_level_fl] [tinyint] NOT NULL , +[gen_rgn] [varchar](32) NULL +) +GO + +CREATE TABLE [b135_MapLinkHGVS_37_3] +( +[snp_type] [char](2) NOT NULL , +[snp_id] [int] NULL , +[gi] [int] NULL , +[accession_how_cd] [int] NOT NULL , +[offset] [int] NULL , +[asn_to] [int] NULL , +[lf_ngbr] [int] NULL , +[rf_ngbr] [int] NULL , +[lc_ngbr] [int] NULL , +[rc_ngbr] [int] NULL , +[loc_type] [tinyint] NULL , +[build_id] [int] NULL , +[process_time] [smalldatetime] NULL , +[process_status] [int] NOT NULL , +[orientation] [tinyint] NULL , +[allele] [varchar](255) NULL , +[aln_quality] [real] NULL , +[num_mism] [int] NULL , +[num_del] [int] NULL , +[num_ins] [int] NULL , +[tier] [tinyint] NULL , +[ctg_gi] [int] NULL , +[ctg_from] [int] NULL , +[ctg_to] [int] NULL , +[ctg_orient] [tinyint] NULL +) +GO + +CREATE TABLE [b135_MapLinkInfo_37_3] +( +[gi] [int] NOT NULL , +[accession] [varchar](32) NOT NULL , +[accession_ver] [smallint] NOT NULL , +[acc] [varchar](32) NOT NULL , +[version] [smallint] NOT NULL , +[status] [varchar](32) NULL , +[create_dt] [smalldatetime] NULL , +[update_dt] [smalldatetime] NULL , +[cds_from] [int] NULL , +[cds_to] [int] NULL +) +GO + +CREATE TABLE [b135_MapLink_37_3] +( +[snp_type] [char](2) NOT NULL , +[snp_id] [int] NULL , +[gi] [int] NULL , +[accession_how_cd] [int] NULL , +[offset] [int] NULL , +[asn_to] [int] NULL , +[lf_ngbr] [int] NULL , +[rf_ngbr] [int] NULL , +[lc_ngbr] [int] NULL , +[rc_ngbr] [int] NULL , +[loc_type] [tinyint] NOT NULL , +[build_id] [int] NULL , +[process_time] [smalldatetime] NOT NULL , +[process_status] [int] NOT NULL , +[orientation] [tinyint] NULL , +[allele] [varchar](1024) NULL , +[aln_quality] [real] NULL , +[num_mism] [int] NULL , +[num_ins] [int] NULL , +[num_del] [int] NULL , +[tier] [tinyint] NULL , +[ctg_gi] [int] NULL , +[ctg_from] [int] NULL , +[ctg_to] [int] NULL , +[ctg_orient] [tinyint] NULL , +[source] [varchar](5) NOT NULL +) +GO + +CREATE TABLE [b135_ProteinInfo_37_3] +( +[gi] [int] NOT NULL , +[acc] [varchar](32) NOT NULL , +[version] [smallint] NOT NULL , +[prot_gi] [int] NOT NULL , +[prot_acc] [varchar](32) NOT NULL , +[prot_ver] [smallint] NOT NULL , +[status] [varchar](32) NULL , +[create_dt] [smalldatetime] NULL , +[update_dt] [smalldatetime] NULL +) +GO + +CREATE TABLE [b135_Remapped_37_3] +( +[snp_type] [char](2) NOT NULL , +[snp_id] [int] NULL , +[src_gi] [int] NOT NULL , +[src_from] [int] NOT NULL , +[src_to] [int] NOT NULL , +[src_l_ngbr] [int] NOT NULL , +[src_r_ngbr] [int] NOT NULL , +[src_orientation] [tinyint] NULL , +[src_aln_quality] [real] NULL , +[tgt_gi] [int] NULL , +[tgt_from] [int] NULL , +[tgt_to] [int] NULL , +[tgt_l_ngbr] [int] NULL , +[tgt_r_ngbr] [int] NULL , +[tgt_loc_type] [tinyint] NOT NULL , +[tgt_orientation] [tinyint] NULL , +[tgt_allele] [varchar](1024) NULL , +[tgt_aln_quality] [real] NULL , +[last_updated_time] [smalldatetime] NOT NULL , +[comment] [varchar](255) NULL +) +GO + +CREATE TABLE [b135_SNPChrPosOnRef_37_3] +( +[snp_id] [int] NOT NULL , +[chr] [varchar](32) NOT NULL , +[pos] [int] NULL , +[orien] [int] NULL , +[neighbor_snp_list] [int] NULL , +[isPAR] [varchar](1) NOT NULL +) +GO + +CREATE TABLE [b135_SNPContigLoc_37_3] +( +[snp_type] [char](2) NOT NULL , +[snp_id] [int] NOT NULL , +[ctg_id] [int] NOT NULL , +[asn_from] [int] NOT NULL , +[asn_to] [int] NOT NULL , +[lf_ngbr] [int] NULL , +[rf_ngbr] [int] NULL , +[lc_ngbr] [int] NOT NULL , +[rc_ngbr] [int] NOT NULL , +[loc_type] [tinyint] NOT NULL , +[phys_pos_from] [int] NULL , +[snp_bld_id] [int] NOT NULL , +[last_updated_time] [smalldatetime] NOT NULL , +[process_status] [tinyint] NOT NULL , +[orientation] [tinyint] NULL , +[allele] [varchar](1024) NULL , +[loc_sts_uid] [int] NULL , +[aln_quality] [real] NULL , +[num_mism] [int] NULL , +[num_del] [int] NULL , +[num_ins] [int] NULL , +[tier] [tinyint] NULL +) +GO + +CREATE TABLE [b135_SNPContigLocusId_37_3] +( +[snp_id] [int] NOT NULL , +[contig_acc] [varchar](32) NULL , +[contig_ver] [tinyint] NULL , +[asn_from] [int] NULL , +[asn_to] [int] NULL , +[locus_id] [int] NULL , +[locus_symbol] [varchar](128) NULL , +[mrna_acc] [varchar](32) NOT NULL , +[mrna_ver] [smallint] NOT NULL , +[protein_acc] [varchar](32) NULL , +[protein_ver] [smallint] NULL , +[fxn_class] [int] NOT NULL , +[reading_frame] [int] NULL , +[allele] [varchar](256) NULL , +[residue] [varchar](1024) NULL , +[aa_position] [int] NULL , +[build_id] [varchar](4) NOT NULL , +[ctg_id] [int] NULL , +[mrna_start] [int] NULL , +[mrna_stop] [int] NULL , +[codon] [varchar](1024) NULL , +[protRes] [char](3) NULL , +[contig_gi] [int] NULL , +[mrna_gi] [int] NOT NULL , +[mrna_orien] [tinyint] NULL , +[cp_mrna_ver] [smallint] NULL , +[cp_mrna_gi] [int] NULL , +[verComp] [varchar](7) NULL +) +GO + +CREATE TABLE [b135_SNPContigProtein_37_3] +( +[snp_id] [int] NOT NULL , +[contig_gi] [int] NOT NULL , +[contig_start] [int] NOT NULL , +[contig_stop] [int] NOT NULL , +[contig_orien] [tinyint] NOT NULL , +[contig_allele] [varchar](1024) NULL , +[mrna_gi] [int] NOT NULL , +[mrna_acc] [varchar](32) NOT NULL , +[mrna_ver] [smallint] NOT NULL , +[mrna_start] [int] NULL , +[mrna_stop] [int] NULL , +[mrna_orien] [tinyint] NULL , +[gene_symbol] [varchar](128) NULL , +[gene_id] [int] NULL , +[prot_gi] [int] NULL , +[prot_acc] [varchar](32) NULL , +[prot_ver] [smallint] NULL , +[prot_start] [int] NULL , +[prot_stop] [int] NULL , +[frame] [tinyint] NULL , +[var_allele] [varchar](1024) NULL , +[residue] [varchar](1024) NULL , +[mrna_codon] [varchar](1024) NULL , +[codon] [varchar](1024) NULL , +[fxn_class] [int] NOT NULL , +[in_stop_codon] [tinyint] NULL +) +GO + +CREATE TABLE [b135_SNPMapInfo_37_3] +( +[snp_type] [char](2) NOT NULL , +[snp_id] [int] NOT NULL , +[chr_cnt] [int] NOT NULL , +[contig_cnt] [int] NOT NULL , +[loc_cnt] [int] NOT NULL , +[weight] [int] NOT NULL , +[hap_cnt] [int] NULL , +[placed_cnt] [int] NOT NULL , +[unlocalized_cnt] [int] NOT NULL , +[unplaced_cnt] [int] NOT NULL , +[aligned_cnt] [int] NOT NULL , +[md5] [char](32) NULL , +[asm_acc] [varchar](32) NULL , +[asm_version] [smallint] NULL , +[assembly] [varchar](32) NULL +) +GO + +CREATE TABLE [b135_SNPMapLinkProtein_37_3] +( +[snp_id] [int] NOT NULL , +[mrna_acc] [varchar](32) NOT NULL , +[mrna_ver] [smallint] NOT NULL , +[mrna_gi] [int] NOT NULL , +[mrna_start] [int] NULL , +[mrna_stop] [int] NULL , +[mrna_orien] [tinyint] NULL , +[allele] [varchar](1024) NULL , +[gene_symbol] [varchar](128) NULL , +[gene_id] [int] NULL , +[prot_gi] [int] NULL , +[prot_acc] [varchar](32) NULL , +[prot_ver] [smallint] NULL , +[prot_start] [int] NULL , +[prot_stop] [int] NULL , +[frame] [tinyint] NULL , +[var_allele] [varchar](1024) NULL , +[residue] [varchar](1024) NULL , +[mrna_codon] [varchar](1024) NULL , +[codon] [varchar](1024) NULL , +[fxn_class] [int] NOT NULL , +[ctg_gi] [int] NULL , +[ctg_from] [int] NULL , +[ctg_to] [int] NULL , +[ctg_orientation] [tinyint] NULL , +[source] [varchar](7) NULL +) +GO + +CREATE TABLE [dn_IND_batchCount] +( +[batch_id] [int] NOT NULL , +[pop_id] [int] NOT NULL , +[ss_cnt] [int] NOT NULL , +[rs_cnt] [int] NOT NULL , +[ind_cnt] [int] NOT NULL , +[create_time] [datetime] NOT NULL +) +GO + +CREATE TABLE [dn_IND_batch_pop] +( +[batch_id] [smallint] NOT NULL , +[pop_id] [int] NOT NULL , +[update_time] [datetime] NOT NULL +) +GO + +CREATE TABLE [dn_PopulationIndGrp] +( +[pop_id] [int] NOT NULL , +[ind_grp_name] [varchar](32) NOT NULL , +[ind_grp_code] [tinyint] NOT NULL +) +GO + +CREATE TABLE [dn_batchCount] +( +[batch_id] [int] NOT NULL , +[ss_cnt] [int] NOT NULL , +[rs_cnt] [int] NOT NULL , +[rs_validated_cnt] [int] NOT NULL , +[create_time] [smalldatetime] NOT NULL , +[pop_cnt] [int] NULL , +[ind_cnt] [int] NULL +) +GO + +CREATE TABLE [dn_handleCount] +( +[handle] [varchar](20) NOT NULL , +[batch_type] [char](3) NOT NULL , +[ss_cnt] [int] NOT NULL , +[rs_cnt] [int] NULL , +[rs_validated_cnt] [int] NULL , +[create_time] [smalldatetime] NOT NULL +) +GO + +CREATE TABLE [dn_snpFxnCnt] +( +[build_id] [int] NOT NULL , +[fxn_class] [tinyint] NULL , +[snp_cnt] [int] NOT NULL , +[gene_cnt] [int] NOT NULL , +[create_time] [smalldatetime] NOT NULL , +[last_updated_time] [smalldatetime] NOT NULL , +[tax_id] [int] NOT NULL +) +GO + +CREATE TABLE [dn_table_rowcount] +( +[tabname] [varchar](64) NOT NULL , +[row_cnt] [int] NOT NULL , +[build_id] [int] NOT NULL , +[update_time] [datetime] NOT NULL , +[rows_in_spaceused] [int] NULL , +[reserved_KB_spaceused] [int] NULL , +[data_KB_spaceused] [int] NULL , +[index_size_KB_spaceused] [int] NULL , +[unused_KB_spaceused] [int] NULL ) GO - -CREATE TABLE [b132_ContigInfo_37_1] ( - [ctg_id] [int] NOT NULL , - [tax_id] [int] NOT NULL , - [contig_acc] [varchar] (32) NOT NULL , - [contig_ver] [tinyint] NULL , - [contig_name] [varchar] (32) NOT NULL , - [contig_chr] [varchar] (32) NULL , - [contig_start] [int] NULL , - [contig_end] [int] NULL , - [orient] [tinyint] NULL , - [contig_gi] [int] NULL , - [group_term] [varchar] (32) NULL , - [group_label] [varchar] (32) NULL , - [contig_label] [varchar] (32) NULL , - [build_id] [int] NULL , - [build_ver] [int] NULL , - [last_updated_time] [datetime] NOT NULL , - [placement_status] [tinyint] NOT NULL -) -GO - - -CREATE TABLE [b132_GenomeAssemblyInfo_37_1] ( - [assembly] [varchar] (32) NOT NULL , - [assembly_type] [varchar] (8) NOT NULL , - [rep_order] [tinyint] NULL , - [comment] [varchar] (255) NULL , - [upd_time] [smalldatetime] NULL -) -GO - - -CREATE TABLE [b132_MapLinkInfo_37_1] ( - [gi] [int] NULL , - [accession] [varchar] (127) NULL , - [accession_ver] [int] NULL -) -GO - - -CREATE TABLE [b132_MapLink_37_1] ( - [snp_type] [char] (2) NOT NULL , - [snp_id] [int] NULL , - [gi] [int] NOT NULL , - [accession_how_cd] [int] NULL , - [offset] [int] NULL , - [asn_to] [int] NULL , - [lf_ngbr] [int] NULL , - [rf_ngbr] [int] NULL , - [lc_ngbr] [int] NULL , - [rc_ngbr] [int] NULL , - [loc_type] [tinyint] NULL , - [build_id] [int] NULL , - [process_time] [datetime] NULL , - [process_status] [int] NULL , - [orientation] [int] NULL , - [allele] [varchar] (1024) NULL , - [aln_quality] [float] NULL , - [num_mism] [int] NULL , - [num_ins] [int] NULL , - [num_del] [int] NULL , - [tier] [int] NULL , - [ctg_gi] [int] NULL , - [ctg_from] [int] NULL , - [ctg_to] [int] NULL , - [ctg_orient] [tinyint] NULL , - [source] [varchar] (5) NOT NULL -) -GO - - -CREATE TABLE [b132_ProteinInfo_37_1] ( - [prot_gi] [int] NULL , - [prot_acc] [varchar] (128) NULL , - [prot_ver] [int] NULL -) -GO - - -CREATE TABLE [b132_SNPChrPosOnRef_37_1] ( - [snp_id] [int] NULL , - [chr] [varchar] (32) NULL , - [pos] [int] NULL , - [orien] [int] NULL , - [neighbor_snp_list] [int] NULL , - [isPAR] [varchar] (1) NOT NULL -) -GO - - -CREATE TABLE [b132_SNPContigLoc_37_1] ( - [snp_type] [char] (2) NOT NULL , - [snp_id] [int] NOT NULL , - [ctg_id] [int] NOT NULL , - [asn_from] [int] NOT NULL , - [asn_to] [int] NOT NULL , - [lf_ngbr] [int] NULL , - [rf_ngbr] [int] NULL , - [lc_ngbr] [int] NOT NULL , - [rc_ngbr] [int] NOT NULL , - [loc_type] [tinyint] NOT NULL , - [phys_pos_from] [int] NULL , - [snp_bld_id] [int] NOT NULL , - [last_updated_time] [datetime] NOT NULL , - [process_status] [int] NOT NULL , - [orientation] [tinyint] NULL , - [allele] [varchar] (1024) NULL , - [loc_sts_uid] [int] NULL , - [aln_quality] [float] NULL , - [num_mism] [int] NULL , - [num_del] [int] NULL , - [num_ins] [int] NULL , - [tier] [tinyint] NULL -) -GO - - -CREATE TABLE [b132_SNPContigLocusId_37_1] ( - [snp_id] [int] NULL , - [contig_acc] [varchar] (32) NULL , - [contig_ver] [tinyint] NULL , - [asn_from] [int] NULL , - [asn_to] [int] NULL , - [locus_id] [int] NULL , - [locus_symbol] [varchar] (128) NULL , - [mrna_acc] [varchar] (128) NULL , - [mrna_ver] [int] NULL , - [protein_acc] [varchar] (128) NULL , - [protein_ver] [int] NULL , - [fxn_class] [int] NULL , - [reading_frame] [int] NULL , - [allele] [varchar] (256) NULL , - [residue] [varchar] (1024) NULL , - [aa_position] [int] NULL , - [build_id] [varchar] (4) NOT NULL , - [ctg_id] [int] NULL , - [mrna_start] [int] NULL , - [mrna_stop] [int] NULL , - [codon] [varchar] (1024) NULL , - [protRes] [char] (3) NULL , - [contig_gi] [int] NULL , - [mrna_gi] [int] NULL , - [mrna_orien] [tinyint] NULL , - [cp_mrna_ver] [int] NULL , - [cp_mrna_gi] [int] NULL , - [verComp] [varchar] (7) NOT NULL -) -GO - - -CREATE TABLE [b132_SNPMapInfo_37_1] ( - [snp_type] [char] (2) NOT NULL , - [snp_id] [int] NOT NULL , - [chr_cnt] [int] NOT NULL , - [contig_cnt] [int] NOT NULL , - [loc_cnt] [int] NOT NULL , - [weight] [int] NOT NULL , - [hap_cnt] [int] NOT NULL , - [placed_cnt] [int] NOT NULL , - [grouped_cnt] [int] NOT NULL , - [unplaced_cnt] [int] NOT NULL , - [md5] [char] (32) NULL , - [assembly] [varchar] (32) NULL -) -GO - - -CREATE TABLE [dn_IND_batchCount] ( - [batch_id] [int] NOT NULL , - [pop_id] [int] NOT NULL , - [ss_cnt] [int] NOT NULL , - [rs_cnt] [int] NOT NULL , - [ind_cnt] [int] NOT NULL , - [create_time] [datetime] NOT NULL -) -GO - - -CREATE TABLE [dn_IND_batch_pop] ( - [batch_id] [smallint] NOT NULL , - [pop_id] [int] NOT NULL , - [update_time] [datetime] NOT NULL -) -GO - - -CREATE TABLE [dn_PopulationIndGrp] ( - [pop_id] [int] NOT NULL , - [ind_grp_name] [varchar] (32) NOT NULL , - [ind_grp_code] [tinyint] NOT NULL -) -GO - - -CREATE TABLE [dn_batchCount] ( - [batch_id] [int] NOT NULL , - [ss_cnt] [int] NOT NULL , - [rs_cnt] [int] NOT NULL , - [rs_validated_cnt] [int] NOT NULL , - [create_time] [smalldatetime] NOT NULL , - [pop_cnt] [int] NULL , - [ind_cnt] [int] NULL -) -GO - - -CREATE TABLE [dn_handleCount] ( - [handle] [varchar] (20) NOT NULL , - [batch_type] [char] (3) NOT NULL , - [ss_cnt] [int] NOT NULL , - [rs_cnt] [int] NULL , - [rs_validated_cnt] [int] NULL , - [create_time] [smalldatetime] NOT NULL -) -GO - - -CREATE TABLE [dn_snpFxnCnt] ( - [build_id] [int] NOT NULL , - [fxn_class] [tinyint] NULL , - [snp_cnt] [int] NOT NULL , - [gene_cnt] [int] NOT NULL , - [create_time] [smalldatetime] NOT NULL , - [last_updated_time] [smalldatetime] NOT NULL , - [tax_id] [int] NOT NULL -) -GO - - -CREATE TABLE [dn_table_rowcount] ( - [tabname] [varchar] (64) NOT NULL , - [row_cnt] [int] NOT NULL , - [build_id] [int] NOT NULL , - [update_time] [datetime] NOT NULL , - [rows_in_spaceused] [int] NULL , - [reserved_KB_spaceused] [int] NULL , - [data_KB_spaceused] [int] NULL , - [index_size_KB_spaceused] [int] NULL , - [unused_KB_spaceused] [int] NULL -) -GO - -